|Posted: August 26, 2009, 5:50 am - IP Logged|
This is MICHIGAN's worksheet
Very Important Do not delete the Ns in column A! Unless you are entering numbers for that day. It will
totally mess up all formulas
You have to have, included in zip file, morefunc installed for some of the formulas.
To start enter the last 56 draws in sheet Wk 1 @ DV2. They have to be in decesending order!
If they haven't drawn yet put in Ns in Column DV then a date in DW.
Next go to column AV2, enter your series of numbers. I am using the missing numbers for my state it just
works better that way here. If you want to use the numbers that hit instead, just enter the the numbers
missing in this area. Example: If your numbers are 1-3-4-5-6 you will put in 0-2-7-8-9. Always put them in
ascending order. THe formulas will take care of the rest for you.
If you have multiple sets I use the one that is the largest set of numbers, you can always add them together
to find out which is largest.
I keep the numbers for all 4 weeks, but you will have to test yourself.
Next go to column A and enter your numbers, remembering in no draw yet, enter just Ns in (A)
and Date in (B) then continue across to c,d,e,f for your numbers.
When you get to week 2, 3, & 4 all you have to do is enter your numbers in columns A,B,C,D,E,F & your model numbers if you choose to change weekly.
P.S. Remember back check. The calculations are for online play if you have it.