Welcome Guest
You last visited February 18, 2018, 4:36 pm
All times shown are
Eastern Time (GMT-5:00)

# Free Excel Programs

Topic closed. 72 replies. Last post 10 years ago by mglsr.

 Page 3 of 5
Pennsylvania
United States
Member #2218
September 1, 2003
5668 Posts
Online
 Posted: November 30, 2007, 6:04 pm - IP Logged

HEY WSLS:

With these programs what do you personally look for in it?? I'm new at this so please understand just tryin to absorb as much info as possible

Thanks

Saveyah,

Since you have the Virginia program click the Tab labeled ComboWheels.

This system is based on a post from the Versabet Forum with a few variations.

The system is based on the following:

1.  Digits Ranking is as follows:

Position 1 = Cold 1,2,3 - (Column AE - ComboWheels Tab)

Position 2 = Warm  1,2,3 - (Colum AF -Combo Wheels Tab)

Position 3 = Hot 1,2,3,4  - (Column AG - Combo Wheels Tab)

Wheeled into 36 Combinations Boxed and Straight (See column Ai 7 AJ)

2. Pairs Ranking:

Any Pair (Front, Back, and Side) out 30 or more skips. (See column AW - ComboWheels Tab)

You can reduse the 36 Wheeled combinations by only playing the combinations that include any Pair that is 30 or more draws out.

You can also reduce the combinations by eliminating combinations that equal  sums of 0 through 5 and sums  22 through 27.

The last draw I used was last Sunday Evening November 25.

Every draw since last Sunday November 25th I look for boxed plays and straight plays.

Look at the ComboWheel Tab and scroll over to Cell Column BE and BF.  Any number highlighted in RED indicates either a Straight Hit and or a Boxed hit.

See combos 134 and 379 hit boxed (highlighted in RED).

So these 2 combos hit boxed since Sunday's last drawing.

You could stop playing once you hit a Boxed or Straight combo and wait again after Sunday when you recalculate the darws. See Below

After you enter this Sunday's Evening drawing you would start the process all over again.

Make sure you also click the Pairs Tab and click the Toolbar to sort all the Pairs.

Click the AlphaPatterns Tab and cklick the big Toolbar to sort all the digits and VTRAC digits.

Click the ComboWheels Tab and in cells AB & AC click the Toolbar that says Click after Sunday's Draws.  This will copy and paste all the information from cell range B:T to AE:AW.

There are other Tabs that I will explain later!!

Good Luck!!!

Detroit, MI
United States
Member #8705
November 15, 2004
1397 Posts
Offline
 Posted: November 30, 2007, 7:02 pm - IP Logged

Winsumloosesum,

Thanks again for the files. Today I took the first step and updated the games for all the states. Then I tried something new. I used the midday pair file and tried CA for the first time. I played 5 numbers that corresponded to the top pairs and vtracs and hit the midday boxed. It wasn't a lot of money, but it beats what I started with and I used your pair chart.

"Excellence is the result of
Caring more than others think is wise;
Risking more than others think is safe,
Dreaming more than others think is practical, and
Expecting more than others think is possible."  Author Unknown

Pennsylvania
United States
Member #2218
September 1, 2003
5668 Posts
Online
 Posted: November 30, 2007, 9:29 pm - IP Logged

Pennsylvania Evening Draws Only - Excel Program Link:

*****Remeber to create a new folder. (Name it whatever you like)******

Unzip the 2 files into this new folder

See previous posts for instructions.

The Alpha VTRAC Pattern Chart only has 3 entries.

Trying to automate this instead of draw by draw.

Tennessee
United States
Member #2369
September 23, 2003
3072 Posts
Offline
 Posted: December 2, 2007, 10:04 am - IP Logged

Daily sequence of instructions:

DAILY:

1. Open the P3Draws Excel file first.

2.  Add a new drawing when you need to add a draw click this toolbar. ALL new drawings will be entered on line 20. Combo will be entered in cell E20.

3. Now while the P3Draws Excel file is open.  Open the 2nd Excel file Pairs1State.

4.  The last Toolbar "Click To Copy Drawings".  By clicking this Toolbar it will copy 365 past draws from the Pick3Draws Excel file into the Pairs1State Excel file > Pick3Draws Tab.

5.  Now click the next Tab labeled "Alpha Patterns"

6.  Click the Toolbar labeled "Click To Add Line".  This will add a new line and will enter the last Alpha Pattern on line 20.

7.  Now click the larger Toolbar labeled "Click To Sort & Rank Digits & VTRAC Positions"

SUNDAY: (eve draw)

1. Open the P3Draws Excel file first.

2.  Add a new drawing when you need to add a draw click this toolbar. ALL new drawings will be entered on line 20. Combo will be entered in cell E20.

3. Now while the P3Draws Excel file is open.  Open the 2nd Excel file Pairs1State.

4.  The last Toolbar "Click To Copy Drawings".  By clicking this Toolbar it will copy 365 past draws from the Pick3Draws Excel file into the Pairs1State Excel file > Pick3Draws Tab.

5.  Now click the next Tab labeled "Alpha Patterns"

6.  Click the Toolbar labeled "Click To Add Line".  This will add a new line and will enter the last Alpha Pattern on line 20.

7.  Now click the larger Toolbar labeled "Click To Sort & Rank Digits & VTRAC Positions"

8.  Click the Pairs Tab and click the Toolbar to sort all the Pairs.

9.  Click the ComboWheels Tab and in cells AB & AC click the Toolbar that says Click after Sundays Draws. This will copy and past the information from cell range B:T to AE:AW. Now you are ready for the next week.

"As Quoted by the Genius One:"

"Life i\$ Good "

\$\$\$\$ I FEEL LUCKY \$\$\$\$

*lay off and it pays off*

Pennsylvania
United States
Member #2218
September 1, 2003
5668 Posts
Online
 Posted: December 2, 2007, 11:17 am - IP Logged

Here are some other tidbits of information:

1.  Click the "Sums" Tab in your Pairs1State Excel file.

In column C8 through C11.  The total sum is highlighted as Odd or Even.

Look for 4 straight Odd or 4 Straight Even.  If for example 4 straight Odd in cell range C8 through C11 flip and play Even Sum.  Meaning look for an even Sum(s) to come out.

2.  Click the "VDigitsLongOut" Tab in your Pairs1State Excel file.  VDigits Long Out is a list of skips for VTRAC Digits.

VTRAC 1 = Digits 0 & 5

VTRAC 2 = Digits 1 & 6

VTRAC 3 = Digits 2 & 7

VTRAC 4 = Digits 3 & 8

VTRAC 5 = Digits 4 & 9

In columns B3 through C7.  Look in columns C3 through C7 for any VTRAC Digits at 5 skips or more.  For example, if VTRAC 4 in cell column  B3 through B7 is at 5.  Look for Digits 4 & 9 to be good digits to include in your next pick.

3.  In the Pairs1State Excel file click the tab labeled "VDigitsLongOut".  In cell range F13, F14, and F15 you can enter a Alpha VTRAC Pattern that you feel will be drawn next.  For example, enter the letter "A" in cell F13, enter the letter "B" in cell F14, and finally enter the letter "C" in cell F15.

Next click the Tab labeled "VTRAC Pattern Combos".  Look in cell AA6.  You now have 8 combinations to play in the next drawing based on the VTRAC Alpha Pattern you entered cells F13, F14, and F15 in the tab labeled "VDigitsLongOut".

One thing to always enter in cells F13, F14, and F15.  Always enter the letter "A" in cell F13.  Then select a combination of "B", "C", or "D" to enter in cells F14 and F15. Go to the tab labeled "VTRAC Patern Combos" to obtain your 8 "BOXED" combinations.

One thing to always enter in cells F13, F14, and F15.  Always enter the letter "E" in cell F15.  Then select a combination of "B", "C", or "D" to enter in cells F13 and F14. Go to the tab labeled "VTRAC Patern Combos" to obtain your 8 "BOXED" combinations.

Now you have 16 "Boxed" combinations for your next draw.

Good Luck!!!

New Member
Woodbridge
United States
Member #56664
November 28, 2007
13 Posts
Offline
 Posted: December 2, 2007, 11:54 am - IP Logged

Here are some other tidbits of information:

1.  Click the "Sums" Tab in your Pairs1State Excel file.

In column C8 through C11.  The total sum is highlighted as Odd or Even.

Look for 4 straight Odd or 4 Straight Even.  If for example 4 straight Odd in cell range C8 through C11 flip and play Even Sum.  Meaning look for an even Sum(s) to come out.

2.  Click the "VDigitsLongOut" Tab in your Pairs1State Excel file.  VDigits Long Out is a list of skips for VTRAC Digits.

VTRAC 1 = Digits 0 & 5

VTRAC 2 = Digits 1 & 6

VTRAC 3 = Digits 2 & 7

VTRAC 4 = Digits 3 & 8

VTRAC 5 = Digits 4 & 9

In columns B3 through C7.  Look in columns C3 through C7 for any VTRAC Digits at 5 skips or more.  For example, if VTRAC 4 in cell column  B3 through B7 is at 5.  Look for Digits 4 & 9 to be good digits to include in your next pick.

3.  In the Pairs1State Excel file click the tab labeled "VDigitsLongOut".  In cell range F13, F14, and F15 you can enter a Alpha VTRAC Pattern that you feel will be drawn next.  For example, enter the letter "A" in cell F13, enter the letter "B" in cell F14, and finally enter the letter "C" in cell F15.

Next click the Tab labeled "VTRAC Pattern Combos".  Look in cell AA6.  You now have 8 combinations to play in the next drawing based on the VTRAC Alpha Pattern you entered cells F13, F14, and F15 in the tab labeled "VDigitsLongOut".

One thing to always enter in cells F13, F14, and F15.  Always enter the letter "A" in cell F13.  Then select a combination of "B", "C", or "D" to enter in cells F14 and F15. Go to the tab labeled "VTRAC Patern Combos" to obtain your 8 "BOXED" combinations.

One thing to always enter in cells F13, F14, and F15.  Always enter the letter "E" in cell F15.  Then select a combination of "B", "C", or "D" to enter in cells F13 and F14. Go to the tab labeled "VTRAC Patern Combos" to obtain your 8 "BOXED" combinations.

Now you have 16 "Boxed" combinations for your next draw.

Good Luck!!!

WSLS

I've been working with the Combo tab feature that you explained yesterday and I'm going to try working with this one today. With all these data tables what type of hit average should I be generating  to let me know that I am using it right? This is real overwhelming I think I have a lil trouble trying to read everything at once.

Pennsylvania
United States
Member #2218
September 1, 2003
5668 Posts
Online
 Posted: December 2, 2007, 12:05 pm - IP Logged

saveyah,

I would Demo this for 2 weeks for your particular state.

Every state is different so you need to TEST (Demo) to see if it is profitable.

Good Luck!!

Steve

cleveland
United States
Member #35045
March 11, 2006
40 Posts
Offline
 Posted: December 4, 2007, 5:39 am - IP Logged

Can you please post ohio if you can

thanks
lottogloria

Carters Lake, Ga.
United States
Member #5313
June 29, 2004
1065 Posts
Offline
 Posted: December 4, 2007, 7:29 am - IP Logged

WTG  !!!

ez

........ in the long run........

Pennsylvania
United States
Member #2218
September 1, 2003
5668 Posts
Online
 Posted: December 4, 2007, 12:32 pm - IP Logged

Can you please post ohio if you can

thanks
lottogloria

Ohio Combined Draws Only - Excel Program Link:

*****Remeber to create a new folder. (Name it whatever you like)******

Unzip the 2 files into this new folder

See previous posts for instructions.

The Alpha VTRAC Pattern Chart only has 3 entries.

Trying to automate this instead of draw by draw.

Tennessee
United States
Member #2369
September 23, 2003
3072 Posts
Offline
 Posted: December 4, 2007, 1:54 pm - IP Logged

Steve, this is simply amazing

Yesterdays results: Tn Mid 093 box hit  Tn Eve 052 box hit

Today results: Ky Mid 871 box hit    Tn Mid 391 box hit

"As Quoted by the Genius One:"

"Life i\$ Good "

\$\$\$\$ I FEEL LUCKY \$\$\$\$

*lay off and it pays off*

Tennessee
United States
Member #2369
September 23, 2003
3072 Posts
Offline
 Posted: December 4, 2007, 3:23 pm - IP Logged

Steve, this is simply amazing

Yesterdays results: Tn Mid 093 box hit  Tn Eve 052 box hit

Today results: Ky Mid 871 box hit    Tn Mid 391 box hit

For everyone information; Tn and Ky are the only two states that i track; thats why i posted the above info. I have been testing this program for only about 6 days. This past weekend Ky had 1 box hit and Tn had 1 str and 3 box hits. Great results so far!!!!!!

"As Quoted by the Genius One:"

"Life i\$ Good "

\$\$\$\$ I FEEL LUCKY \$\$\$\$

*lay off and it pays off*

Pennsylvania
United States
Member #2218
September 1, 2003
5668 Posts
Online
 Posted: December 4, 2007, 3:52 pm - IP Logged

For everyone information; Tn and Ky are the only two states that i track; thats why i posted the above info. I have been testing this program for only about 6 days. This past weekend Ky had 1 box hit and Tn had 1 str and 3 box hits. Great results so far!!!!!!

Mike,

Keep testing!!

As long as you make a profit thats the key.

Looks like it works in Ohio also.  (Combined Draws)

 Sun-Dec-02-2007 M 308 Sun 5 Sun-Dec-02-2007 E 109 Sun 4 Mon-Dec-03-2007 M 825 Mon 0 825 258 0 0 Mon-Dec-03-2007 E 974 Mon 0 974 479 0 1 Tue-Dec-04-2007 M 053 Tue 0 053 035 0 1

Sunday Evening drawings was the last draw for analysis.

479 boxed Monday 12/3 Eve

035 boxed Tuesday 12/4 Midday (05 Pairs was out 30 or more draws)

Nice to see this working in more than 1 state.

Tennessee
United States
Member #2369
September 23, 2003
3072 Posts
Offline
 Posted: December 4, 2007, 4:05 pm - IP Logged

Its hard to hold back when you see these kinds of results Steve, but you are right; need to keep testing; so far this is really great if you play online.

"As Quoted by the Genius One:"

"Life i\$ Good "

\$\$\$\$ I FEEL LUCKY \$\$\$\$

*lay off and it pays off*

Florida
United States
Member #46570
September 14, 2006
558 Posts
Offline
 Posted: December 4, 2007, 4:07 pm - IP Logged

Oh no .. No Florida ??

Don't Play more, Play Smarter!

 Page 3 of 5