# Multiple Period Simulation- Excel VBA

CLOSED
Bids
15
Avg Bid (USD)
\$301
Project Budget (USD)
\$30 - \$250

Project Description:
Old Model: Have a vba hard coded simulation model that simulate 10,000 scenarios of variables over 1 year time horizon.
Goal: Value should be simulated multiples time per simulation, There should be options to define periouds monthly, quaterly, annually
Example: change from 1 simulation / year to 12 simulation/ 12 month, meaning 12*10,000

06/21/2013 at 15:11 EDT
A test for selecting best freelancers, my budget for this project is \$500. So work hard and be serious to this test
Question: assume num_sim= 100/ one day, how to you change to code to make it 10 times/ per hour= 240/day?
I dont want only loop times increase from 100 to 240 but what I am looking for is the increase of both frequency and total sum
Sub Simu()

''''''''''''''''''''''''''''''''''''''
'Simulate using fixed random number

Rnd (-1)
For i = 1 To num_var
For j = 1 To num_sim
temp = Rnd
If temp = 0 Then
sim(j, i) = NormSInv(0.00001)
Else
sim(j, i) = NormSInv(temp)
End If
Next j
Next i

For i = 1 To num_var
For j = 1 To num_sim
For K = 1 To i
sim3(j, i) = sim3(j, i) + sim(j, K) * L(i, K)
Next K
sim3(j, i) = Application.WorksheetFunction.NormSDist(sim3(j, i))
Next j
Next i

For i = 1 To num_var
For j = 1 To num_sim
If 0.9999 < sim3(j, i) Then
sim(j, i) = 0.9999
ElseIf 0.00001 > sim3(j, i) Then
sim(j, i) = 0.00001
Else
sim(j, i) = sim3(j, i)
End If
Next j
Next i

For i = 1 To num_va

Skills required:
C Programming, Excel, Mathematics, Statistics, Visual Basic
Project ID: 4648150
Report Project
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

\$ 618
in 10 days
\$ 200
in 3 days
\$ 250
in 1 days
\$ 444
in 3 days
\$ 210
in 10 days
\$ 144
in 1 days
\$ 500
in 10 days
\$ 526
in 15 days
\$ 166
in 3 days
\$ 222
in 3 days