type in simtools.xla in google and download it to the folder name which is in the formulas and then open it up. It should fix it, it did for me!

hi shaun or moee have u managed to have a look at my spreadsheet
kennedy managed to get it working but still cant keeps not recognising my simtools if u can have look will be really grateful
ron
also have a ms access horse racing database if anyone is interested it needs work too lol

if anyone wants to contact me im angrymobs99 t hotmail.com
ron

If i get some time will check out see if i can work out what problem is, i got my code sorted out so now down to testing

I tried your program, but it won't work at all for me because it is looking for details of a Cranbourne Race that I don't have.

And I don't know what is "Mcorrels" and "corrand"

Best wait for kennedy to roll up.
He's redhot on this sort of stuff

thanks moeee same here he had it running but maybe if he changes a few things im hopeless but like to try these things can send you it running in different format if you have email address

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

On post 65 of this thread there is a spreadsheet. It may require by now some tweaking. Hope the original "author" of this excel spreadsheet is around to update it with the current Tatts web site.

It still works, but there are some columns that don't figure.
The VBA coding is a bit advance for me, but the final output is great.
The only other thing that may be considered to add is some sort of variable to include ALL_RACES, or races with CODES_ONLY, such as,
AR, SR, BR, MR, ....ETC.
That way it may not take as long to load up.

Thanks.