Hi Everyone
Merry Xmas And Happy New Year to you all...
Thank you Sysp34 for your spreadsheet.
I use EL to do the stats for segment as follow...
-Creat new lottery in EL let's call it Lotto Segment Column 0 (do the same for the others column -1,-2,-3,-4,-5,-6,-7,-8,-9 and -10)
-in Windows "how many Numbers are in the drawing pool ? " enter = 36
(if your lotery is 6/49 enter 36 if it's 5/49 enter 35 i will explains it later)
-Click on "Next" button...
-in Window "What is the lowest drawn number ?" enter = 1
-I suppose you have to click "next" button to keep moving !
-in window "how many numbers are drawn ?" enter = 3
-in window "how many numbers do you bet ?" enter = 3
-in window "Is bonus drawn? " cheek "No"
(as you continue other windows will open so i'll stop using in window)
-Please mark days when the winning...
-"how many set of Numbers... " enetr = 1
-"Draw date consit...
-"please select the date of the first lottery drawing ....
-"Please mark winning match comb...
-"How many of box...
-"Do you submi...
-The Last window (at last...) click finish
Now your new created lottey will open.So you have to import the Data in it.
How to Export Update WNH - Segments into Excel
As describe by Sysp34:
Step 1
insert all past draw into package
when creating past draw, you must sort with descending date (skip formula will search descending date)
Step 2
on Package Statistics select only WNH - Segments then select only WNH - Segments
Step 3
Exporting WNH - Segments into
txt as segcolumn .txt (for exempl) to My document.
Step 4
Open Excel - Click Files Types - Select All Files and Open "segcolumn .txt"
Select
Import Wizard dialog box
click next then select delimiters "Space"
click next and change all WNH Column into Text (11 column)
Now when you click "Finish" you will have all WNH Segments opened in your xl sheet.
Step 5
Open your history Data And Copy the column "Date"
Step 6
Now Open new in Excel and Past your column "Date" in column A at Row 1
Step 7
Copy column 0 from your file "segcolumn .txt" And past it in coulmn B at Row 1 close to where you just past "Date". Select
Import Wizard dialog box click next then select delimiters "Other= "-" .Now when you click "Finish" you will have all WNH Segments for column 0 opened in your xl sheet.Like this for exemple in column A 12/16/2006 , in column B 6 , in column C 0 and in column D 0.
Step 8
in column E enter formula "=B1+10"
in column F enter formula "=C1+20"
in column G enter formula "=D1+30"
Now Your data WNH Segment Like this for exemple in column A 12/16/2006 , in column B 6 , in column C 0 , in column D 0 , in column E 16 , in column F 20 and in column G 30.
Higliht all Coulmn E ,F , G Then copy them .Click in cell B1 Then click "Special Past" and click Past Value.You will have this in column A 12/16/2006 in column B 16 in column C 20 and 30 in column D(as Exempl).
Now delete Column E F and G .Save This as "WNH Segment Column 0".
Step 9
in the new lottery just created import your "WNH Segment Column 0" et VOILA.
Now you can use EL to give you any stats ,charts or view some graphics of the segments or what so ever for your "WNH Segment Column 0" or "WNH Segment Column -1" or "WNH Segment Column -2" or "WNH Segment Column -3" or "WNH Segment Column -4" or "WNH Segment Column -5" or "WNH Segment Column -6 " ...
Any Comment PLS...
May the Year 2007 be the falling year of many Jackpots.
Merry Xmas And Happy New Year to you all...
Attach image of my WNH segment Stats for lotto 6/49 sorted by occurency...
You do not have the required permissions to view the files attached to this post.