Back-test a large wheel.

[paulgh]

Greetings to all lottery enthusiasts.
I wish to find a way of back-testing a large wheel of 300+ lines against the games history of 1500+ draws without having to run each line of the wheel through the draw history separately. Ideally I would like the process to list the hits of wheel individually. e.g. Line 52 of wheel hit 3 numbers in draw 151, draw 265 and draw 900 etc.. The games that I follow are Australian lotteries 6/45+2,6/40+1,7/45+2 and 6/38+1. I am happy to purchase a commercial program if anyone can recommend such, as so far, I have been unable to find a solution. Any advice would be greatly appreciated.
Regards, paulgh.

 

[Icewynd]

Hi Paulgh,

I have backtested wheels in Excel, but it takes a lot of work to set it up.

I think Lotto Architect may offer backtesting capability -- maybe someone who is more familiar with the software can comment.

Good luck,

 

[bloubul]

Hi paulgh
I do have a excel spreadsheet.. I need to know what version of excel you have.
It's not very elegant but it does the workings.

BlouBul

 

[paulgh]

Hi BlouBul,
Thank you for your response. I have Excel 2003.

 

[bloubul]

Hi paulgh

Fellow this link. It's not the most eligant, replace my data with yours.
Latest draw on top.

https://www.mediafire.com/?v15dudnkl87ibn9

BlouBul

 

[paulgh]

Hi BlouBul,
Thanks for the link. I shall experiment with the macro and let you know, via the forum, If I have some success.
Many thanks for your assistance.
Regards, paulgh