Closed

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

Skills: C Programming, Excel, Mathematics, Statistics, Visual Basic

See more: vba simulation excel, period simulation vba, simulation period, multiple period, vba excel programming, programming meaning, goal programming example, excel programming vba, vba time, excel 2013 vba, simulation, period, excel/vba, excel model, 2013 excel visual basic, excel 2013 visual, simulation model, visual basic excel 2013, excel goal programming, excel 2013 visual basic, model excel, excel simulation model, goal programming excel, year model excel, excel vba programming

About the Employer:
( 2 reviews ) New York, United States

Project ID: #4648150

14 freelancers are bidding on average $279 for this job

akhila27

Can do this for you! Consider this DONE! Contact us for more information. SI Team.

$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

Expert of excel,see PMB please.

$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

can do your task done in limited time with pure efficiency

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

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