Pennsylvania Pick 3 - VTRAC/ALPHA System - Excel ProgramPrevious TopicNext Topic

Hi everyone.  I created this Excel program a few years ago but wanted to test this out in the next couple weeks to see if profiatble.

If you want to play along just create a new folder on your hard drive.  Example, C:\Pick 3 Pennsylvania Eve System

Download the following zip file from box.net and unzip into your newly named folder

http://www.box.com/s/4naqs70nc2y3ndgrleqe

The zip file contains 2 Excel files. 

I will explain more in the next few posts.  May even post a video on how to use the Excel files later today.

The zip file contains 2 Excel files.  Excel 2002 version.

The 1st Excel file:

P3Draws.xls contains the Pennsylvania Pick 3 drawing history for the evening draws only (no Midday draws)

The second Excel file:

Pairs1State.xls contains all the calculations and other good stuff for the VTRAC/ALPHA Pick 3 System.

I will try and post a video later today on how to use the 2 excel files using tonights Pennsylvania Pick 3 evening drawing for Tuesday January 17, 2012 at 7pm est.

Thanks, I'm going to try the pairs file for NM.

when I opened the large chart it was read only

Here is the link to the Excel 2010 version zip file

http://www.box.com/s/muu8jr4p31z0rxrpne7h

Here is a video from tonights winning drawing 3-2-5 on Tuesday January 13, 2012

http://www.screencast.com/t/rEQTwwpa8y

Here is the download link to the updated Excel files (zip file):

http://www.box.com/s/cexrzy7lqokkuspq6osb

This is a followup video with additional ideas:

http://www.screencast.com/t/3I6bgSn1tF

Thanks Steve,

Is there an easy way to replace the draws for use with other states ??

didnt watch the video yet so maybe you addressed this question there ?

Thanks

CarliG

I just manually deleated several draws and entered my states latest results.   The program is great just for the fp, bp and odd/even feature .  I've highlighted in red the recent pairs that have hit and the ones "due" in blue.  No pun intended.  This is great for the short term to see what has hit and what may hit next.  Try it!

I updated the Pennsylvania Pick 3 Evening Excel files.  Added Positional Tabs (Position 1, Position 2, Position 3) for the ALPHA's

http://www.box.com/s/3ugnsajuu2vygi6llak9

I created another Excel program for Florida Pick 3 (Midday and Evening Draws)  The actual zip filename says evening but it is both Midday and Evening draws.

http://www.box.com/s/xoglnvlxlet9sr1advl6

Thanks Steve

For Everything you do to try and help us all out

Going to grab that Florida

CarliG

Can you do one for NM Steve?  Thanks!

how do I rid that read only from the file? thanks

Since the Excel file contain Macros you may have your "Enable Macro Security" settings set to High.  Try setting them to a lower setting.  I take it you are using Excel?  If so what version of Excel?