View Single Post
  #63  
Old 27th June 2009, 09:56 PM
woof43 woof43 is offline
Member
 
Join Date: Jan 1970
Posts: 696
Default 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
Reply With Quote