![Old](images/statusicon/post_old.gif)
27th June 2009, 09:56 PM
|
Member
|
|
Join Date: Jan 1970
Posts: 696
|
|
Simtools
Hi Angry,
I had a look at your sheet, if you have Simtools loaded as an Add-in you can do the following to get it working.
In Cell C27 insert Norminv(rand(),C11,C12) then copy that formula across to J27.
Now to get your sheet to work highlight from Cell B27:J2027
then go to the header or menu where you have simtools then click Simulation table depending on the speed of your computer it will only take a few seconds and you should have a new set of probs and rankings etc at M23 :J25
|