Welcome Guest
Log In | Register )
You last visited April 27, 2017, 6:23 pm
All times shown are
Eastern Time (GMT-5:00)

Sum Hit Order

Topic closed. 2 replies. Last post 7 years ago by retxx.

Page 1 of 1
winsumloosesum's avatar - Lottery-060.jpg
Thread Starter
United States
Member #2218
September 1, 2003
5461 Posts
Posted: December 18, 2009, 1:51 pm - IP Logged

Hey Chaz rememeber Barry's "Sum Hit Order" Excel file?

When you posted the Horse Gate (not to be confused with Watergate), the first thing that came to mind was Barry's "Sum Hit Order" Excel file.

You take the  Sums convert to Short Sums (0, 10, 20 = 0      1, 11, 21 = 1,       2, 12, 22 = 2     3, 13, 23 = 3       4, 14, 24 = 4        5, 15, 25 = 5         6, 16, 26 = 6          7, 17, 27 = 7           8, 18 = 8        9, 19 = 9)

Track the skips for each Short SUM (0, 1, 2, 3, 4, 5, 6, 7, 8, 9)

When the Sum hits to mark what gate the sum hit.  

So for example in the image above.  The drawing for December 17, 2009 was 1-3-0 which equals a Sum of 4 (1 + 3 + 0) or a Short Sum of 4 (see above)

The previous Skips of Short Sum 4 in cell AF 20 was 2 in cell U22

So the Horse (here we go with horses again) in Gate 8 was the winner LOL  

The Excel files Barry sent me he calculted the Quads for the Short Sums.  So the Quads are grouped AJ19, AK19, AL19 = Quad 1     AM19, AN19, AO19 = Quad 2    AP19, AQ19, AR19 = Quad 3 and AS19 is the most current draw so he did not asssign a Quad number.

Quad 3 has hit a total of 124 times since January 1, 2009.  So you have 66 boxed combos plays to filter.

So if this is the best Quad to play it would seem that Short Sums 6, 9, or 8 is due.  The Short Sum 8 is currently at 2 skips.  So mabe narrowing this down by filtering the combos in short sum 8?


The combinations highlighted in red are boxed combinations that have NOT hit in over 1000 draws.

So for example.  The 029 has not been drawn as either 029, 092, 209, 290, 902, 920 in over 1000 draws.

    winsumloosesum's avatar - Lottery-060.jpg
    Thread Starter
    United States
    Member #2218
    September 1, 2003
    5461 Posts
    Posted: December 18, 2009, 2:27 pm - IP Logged

    This is the download link to the Excel file if anyone would like a copy.

    I can not create a new Excel file for your state. 

    If I have time I will explain how to create your own states file.

    But for those who live in Pennsylvania her it is:


    For Pennsylvania Pick 3 players only.

    1.  After tonights drawing (Friday December 18, 2009) jot down the result and then open the Sum Hit Order Excel file.

    2.  Go to the Tab at the bottom labeled "PastDraws"

    3.  Go to the next Tab labeled "Draws".  Scroll over to cell range A1 through A6 where you see a Toolbar labeled "Add New Drawing".  Click this Toolbar and all the calculations will be performed.

    4.  Thats It. 

    5.  Now you can check out the chart in the "Draws" tab by scrolling over to cell range AU through CV to look at the skips.

    6.  You can also click the Tabs "Horse gates" or "HorseGateSkips" to look at the Positional "Gate" Charts.


    Anyone wanting to take the time to play with this you need to do the following:

    Obtain all your past draws and place them in the Tab labeled "PastDraws"

    Make sure the oldest drawing is at the top.

    If you go to the Tab labeled "PastDraws" you will see my next drawing is for December 18, 2009.  You will need to keep the dates in cell column A and the drawings in cell colum E.  The "E" in cell column "C" represents E for evening only drawings.

    If your using the combined draws you will need to make sure the evening an midday draws are entered correctly.

    Next go to the Tab labeled Draws and the Toolbar labeled "Add New Drawing".  Click this one click at a time until all your drawing that you want to use are completed.

    You will also need to adjust the dates in the toolbar labled "Draws" column "A".  So just click a few draws and change the dates in column A.  You will need to enter a formula that will automatically update correctly.

    Also for combined drawings you can enter a M and E in cell column C (M for Midday and E for Evening).

    Just a warning this is somewhat of a time consuming project because you are calculating 1 draw at a time.  So to calculate a years worth of draws may take around 15 to 30 minutes.

    When you click the Toolbar "Add New Drawing" each time, give the calculations time to process.  Don't keep clicking the Toolbar or you may get an error.

    Let me know if you have any questions.

      retxx's avatar - mrthumbs
      United States
      Member #48
      September 9, 2001
      3655 Posts
      Posted: December 19, 2009, 10:34 am - IP Logged

      hi win can we use the draw history from your other file and add it to this sum files such as mass fronr 3 ?thanks