# Multiple Period Simulation- Excel VBA

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

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

( 2 reviews ) New York, United States

Project ID: #4648150

## 14 freelancers are bidding on average \$279 for this job

akhila27

\$618 USD in 10 days
(7 Reviews)
6.0
deepbluetech

Hi, Seems interesting. I am an Excel macro expert and can take on the job. Let me know.

\$200 USD in 3 days
(90 Reviews)
5.3
northwolves

\$250 USD in 1 day
(50 Reviews)
5.0
Nhcuong

hi, can you send the existing code so i can check it. Best regards, Cuong NH

\$444 USD in 3 days
(28 Reviews)
4.9
anujgargiitk

Hi, I am a mathematical modeler and have extensive experience in developing VBA macros for data processing and analysis. i can handle this kind of project but please share more information to better access the quantum More

\$210 USD in 10 days
(3 Reviews)
4.7
nayabsiddiqi

\$144 USD in 1 day
(12 Reviews)
4.3

excel macro expert.......................

\$500 USD in 10 days
(15 Reviews)
3.6
drevak

Let me do this job for you.

\$526 USD in 15 days
(2 Reviews)
3.0
JScottArnold

Good afternoon- I am a statistical and analytical consultant with years of experience developing and designing Excel tools for customers. I have created simulation tools before and one of my previous works involved cre More

\$166 USD in 3 days
(1 Review)
2.8
mattc123sl

I would love to do this. Statistics and mathematics interest me, and I am an expert MS Office and VB developer. I can build you an interface where you can choose all of these variables from drop downs on a form before More

\$200 USD in 5 days
(0 Reviews)
0.0
jbanerjee

very much interested.

\$222 USD in 5 days
(0 Reviews)
0.0
nebilchaouech

i can start right now.

\$155 USD in 3 days
(0 Reviews)
0.0
swarm22

I am able to fulfill your requirements with quality , accurate and supportive work

\$500 USD in 30 days
(0 Reviews)
0.0
MattGofStP

I am very comfortable with complex calculations in excel VBA. I currently work for a company that sells leasing software to the equipment finance industry. I will be happy to do this work to your exact specifications.

\$160 USD in 4 days
(0 Reviews)
0.0
nikkiella

Hi there. I've been programming in excel VBA (even though my work is on financial analysis). I earned my Green Belt Six Sigma certification from the automation programs I had. I can definitely help you with this. Tha More

\$222 USD in 3 days
(0 Reviews)
0.0