Welcome Guest
You last visited December 11, 2017, 8:11 am
All times shown are
Eastern Time (GMT-5:00)

# Pick 3 Block Party - Excel Program

Topic closed. 105 replies. Last post 8 years ago by foreverbad64.

 Page 2 of 8
Ohio
United States
Member #65279
September 22, 2008
5743 Posts
Offline
 Posted: November 27, 2009, 6:57 am - IP Logged

Could you do Ohio?

Pennsylvania
United States
Member #2218
September 1, 2003
5641 Posts
Offline
 Posted: November 27, 2009, 7:32 am - IP Logged

Just want to add the following. We are looking at 30 draw segements of your states Pick 3 drawings.

So just update your states results in the Excel file "DrawHistory" Excel file.

Then go to the Excel file "Systems", update the Tab labeled Sums12To15SystemCombinedChart, Midday Chart Tab, or Evening Chart Tab enter your states results in the area below:

So for example in the above image for the "evening draw for Friday November 27th North Carolina just enter it in the cell next to the date (Fri-Nov-27-2009)

Once 30  draws are completed then you need to re-calculate for the next segment of 30 draws.

Another suggestion is to look for the previous segment of 30 draws and look for any Sum of either 12, 13, 14, or 15 that did not hit.  You can see from the image below using North Carolina Midday as an example that all sums have hit this month.  Looking at the previous segments of 30, you can see what sums have not hit with a zero (0) highlighted.  So, for example in the example below you see a zero (0) in cell T16  for sum 15 occur (3) segments ago.  If you wanted you could have played the Sum 15 combos the following month and you can see that Sum 15 did have 2 combinations that hit in the next 30 draw segment.

You can see in the image above that in the current 30 draw segemnt that North Carolina evening drawings that Sum 12 has 2 combos hit, Sum 13 has 2 combos hit, Sum 14 has 3 combos hit, and Sum 15 has a total of 4 combos hit.  For a total of 11 combinations that hit for ALL the sums 12, 13, 14, and 15.  And in the image below you can see all the Sums (12, 13, 14, and 15) highlighted in column AV and where I circled all Sum 15 hits.

Sarcoxie, Missouri
United States
Member #80339
September 24, 2009
62 Posts
Offline
 Posted: November 27, 2009, 7:46 am - IP Logged

could you please do missouri thank you win

Angel4u2luv36

Pennsylvania
United States
Member #2218
September 1, 2003
5641 Posts
Offline
 Posted: November 27, 2009, 9:19 am - IP Logged

could you please do missouri thank you win

Missouri

http://www.box.net/shared/vp48j59ggn

1.  Create a new folder.  Name it whatever you like

pdf Instructions included.

Updated through Thursday November 26, 2009

Pennsylvania
United States
Member #2218
September 1, 2003
5641 Posts
Offline
 Posted: November 27, 2009, 9:39 am - IP Logged

New Mexico

http://www.box.net/shared/m1ucvtd22i

1.  Create a new folder.  Name it whatever you like

pdf Instructions included.

Updated through Thursday November 26, 2009

Pennsylvania
United States
Member #2218
September 1, 2003
5641 Posts
Offline
 Posted: November 27, 2009, 9:55 am - IP Logged

Could you do Ohio?

Ohio

http://www.box.net/shared/f80r4ji5h0

1.  Create a new folder.  Name it whatever you like

pdf Instructions included.

Updated through Thursday November 26, 2009

Dallas, TX
United States
Member #5506
July 8, 2004
24 Posts
Offline
 Posted: November 27, 2009, 10:04 am - IP Logged

It is better to open your eyes and say you don't understand, than to close your eyes and say you don't believe.

George Clinton

Pennsylvania
United States
Member #2218
September 1, 2003
5641 Posts
Offline
 Posted: November 27, 2009, 10:14 am - IP Logged

Pennsylvania

http://www.box.net/shared/x2st8s6n97

1.  Create a new folder.  Name it whatever you like

pdf Instructions included.

Updated through Thursday November 26, 2009

Pennsylvania
United States
Member #2218
September 1, 2003
5641 Posts
Offline
 Posted: November 27, 2009, 10:31 am - IP Logged

Texas

http://www.box.net/shared/7yp1o9hjat

1.  Create a new folder.  Name it whatever you like

pdf Instructions included.

Updated through Thursday November 26, 2009

Georgia
United States
Member #65404
September 26, 2008
2338 Posts
Offline
 Posted: November 27, 2009, 4:39 pm - IP Logged

Hi Winsumloosesum,

Could you provide the file for Georgia, please? Thanks.

RICH Or POOR It's Good To Have Money-\$\$!

"Win As If You Were Used To It, Lose As If You Enjoyed It For A Change."

Debra

United States
Member #714
September 18, 2002
96 Posts
Offline
 Posted: November 27, 2009, 4:57 pm - IP Logged

winsum

I realize I may have overlooked it, but where might I find this program and related files for Michigan?

Thanks!!

Sierra Vista
United States
Member #45120
August 14, 2006
44 Posts
Offline
 Posted: November 27, 2009, 5:01 pm - IP Logged

Hi Winsumloosesum,

Could you provide the file for Arizona, please?

Thanks

George

George

charlotte,nc
United States
Member #73389
April 13, 2009
81 Posts
Offline
 Posted: November 27, 2009, 5:15 pm - IP Logged

Hi Winsumloosesum,

Could you provide the file for North Carolina, please?

Thanks

joey4949

Pennsylvania
United States
Member #2218
September 1, 2003
5641 Posts
Offline
 Posted: November 27, 2009, 5:29 pm - IP Logged

Hi Winsumloosesum,

Could you provide the file for North Carolina, please?

Thanks

joey4949

North Carolina

http://www.box.net/shared/k8aftabc1e

1.  Create a new folder.  Name it whatever you like

pdf Instructions included.

Updated through Thursday November 26, 2009

Pennsylvania
United States
Member #2218
September 1, 2003
5641 Posts
Offline
 Posted: November 27, 2009, 5:40 pm - IP Logged

Hi Winsumloosesum,

Could you provide the file for Arizona, please?

Thanks

George

Arizona