Pick 3 VTRAC Movement System - Excel

Reply #33

Gwoof — Wed, 08 Jan 2014 19:33:36 GMT

Will you be making another video on how to use some of the sheets

Reply #32

txwinr — Wed, 08 Jan 2014 17:58:44 GMT

thank you winsum! I'm still trying to figure it all out, so appreciate your help.

Reply #31

winsumloosesum — Wed, 08 Jan 2014 15:35:34 GMT

Here is the download link to all the Midday, Evening, and Combined draws in text format.

Draws are updated through Monday 1/6/2014 so you will need to add a draw or more to bring them up to date.

It would be easier to just open the text file for your particular draw and insert the new draws. Keep the same formatting.

https://app.box.com/s/zzvrpul79hjv07pyklwe

There are 3 Folders:

1. Midday Draws

2. Evening Draws

3. Combined Draws

Click the folder then select the state/Can... [ More ]

Reply #30

txwinr — Wed, 08 Jan 2014 14:43:24 GMT

Guess I should try it first :) Yes, looks like it works for texas. I watched the 3 vids, is there another one? He references next video in vid 3 but I don't see it on you tube.

Reply #29

Gwoof — Wed, 08 Jan 2014 14:23:47 GMT

Texas pick 3 is listed in the files so I would think you can

Reply #28

txwinr — Wed, 08 Jan 2014 13:14:20 GMT

can you use this with the texas pick 3

Reply #27

Gwoof — Tue, 07 Jan 2014 22:41:03 GMT

I've got the files to update ..... Thanks for the help

Reply #26

Gwoof — Tue, 07 Jan 2014 21:40:51 GMT

I've updated the text files for the Ont pick 3 in the three folders but the Excel program does not pick them up. Does that meen I have to update the draws one at a time.

Reply #25

Gwoof — Sat, 04 Jan 2014 18:53:28 GMT

I just downloaded this and find it very interesting . How do I bring the history for the Ont. Pick 3 up to date

Reply #24

winsumloosesum — Tue, 10 Dec 2013 22:13:07 GMT

LFF

Reply #23

LottoBoner — Tue, 10 Dec 2013 22:00:15 GMT

Are you tracking the LFF within the VTRACS

Reply #22

winsumloosesum — Tue, 10 Dec 2013 20:39:25 GMT

1. Open Pick3VTRACSystem Excel file

2. Click the Tab at the bottom labeled DrawImport

3. Click cell AB1. Select/Enter the drive letter designation for your computer.

4. Go to cell O2. Select the Type of game you want to import. 1 = Midday, 2 = Evening Only, 3 = Combined

5. If you selected 3 in cell O2 for example, go to clcik cell R10 and from the drop-down list select your state. You would select Illinois_Combined

6. In cell range F7:G10 click the Toolbar labeled Click to Impor... [ More ]

Reply #21

mlynch — Tue, 10 Dec 2013 20:24:11 GMT

Hi there... I am stuck on the Excel Program. I have all my Folders in the correct space..How do I change my State to Illinois from Pennsylvania?

Thanks

Mike

Reply #20

cheech — Sun, 10 Nov 2013 22:12:38 GMT

Hello wsls,

I no longer have a registered genuine working copy of Microsoft Office.

Questions:

Is the file Pick3VTRACSystem.xls , and the 3 state draw history sheets files, Only intended to work using the genuine Microsoft Office 97-2003 for excel?

Or can the files be used with the free Open Office Calc ver. 4.01 as well?

This is what I get, After opening Pick3VTRACSystem.xls, using the latest Open Office calc ver. 4.01 (which seems to open Pick3VTRACSystem.xls with no problems) b... [ More ]

Reply #19

winsumloosesum — Fri, 08 Nov 2013 02:20:03 GMT

Ontario Canada Pick 3 - Combined Draws Excel File:

https://app.box.com/s/w1nu2qdkjrb0tn1lzd82

Pennsylvania Pick 3 - Evening Draws Excel File:

https://app.box.com/s/jhclo0y22zkf19we9mv7

Reply #18

winsumloosesum — Tue, 05 Nov 2013 18:40:59 GMT

Here are the download links to the Pick 3 VTRAC Excel files (2007 2010 Excel versions)

Georgia (combined drawings)

https://app.box.com/s/1e76579rtkofczmrvdrm

Texas (combined drawings)

https://app.box.com/s/cxco95ls4cz4u3ozv56o

Florida (evening only)

https://app.box.com/s/3xacpjedujtfhlbmvf08

Pennyslvania (evening only)

https://app.box.com/s/ptjw7e7odif3815o28fy

Reply #17

SergeM — Sun, 03 Nov 2013 22:52:45 GMT

Nice explanation for the movements.

Reply #16

kreative1 — Sun, 03 Nov 2013 15:33:10 GMT

your videos are very informative!

Is our state a pita or what though, I'm considering taking the 10 min drive to nj and playing there instead

Reply #15

winsumloosesum — Sat, 02 Nov 2013 00:18:45 GMT

Video 1:

Creating your folders and placing the drawing Pick 3 text files in each of the 3 sub-folders.

http://www.youtube.com/watch?v=XbwIqFzDH6Q

Video 2:

This video explains how to select the correct drive letter to import the drawing text files into Excel. Also, how to select your Pick 3 game.

http://www.youtube.com/watch?v=iOAt4ygOH28

Video 3:

This video explains briefly about the movements of each positional VTRAC and calculating based on previous draws.

Reply #14

winsumloosesum — Fri, 01 Nov 2013 22:20:05 GMT

I'm in the process of rendering a new video 3 that gives an explanation of the Movements .

Reply #13

SergeM — Fri, 01 Nov 2013 21:07:35 GMT

Can you give the meaning of movement

Reply #12

winsumloosesum — Fri, 01 Nov 2013 19:09:13 GMT

Here is the Youtube link for Video 2:

http://www.youtube.com/watch?v=iOAt4ygOH28

This video explains how to select the correct drive letter to import the drawing text files into Excel. Also, how to select your Pick 3 game.

Reply #11

winsumloosesum — Fri, 01 Nov 2013 11:56:56 GMT

I also updated the P3VTRACSystem Excel file.

I created a file for Texas combined draws and Pennsylvania evening only draws.

You can only open 1 of the 2 since they both have the same file name.

Pennsylvaia Excel file:

https://app.box.com/s/1ri99dxvjge92e3qfxjj

Texas Excel file:

https://app.box.com/s/zuach9suhqk6l54t6qc9

I posted picks in the Pick 3 for Texas and Pennsylvania thread using the calculations from each of the 2 files.

I

I'll try and post some vide... [ More ]

Reply #10

winsumloosesum — Fri, 01 Nov 2013 11:49:32 GMT

I updated the drawing text files through Thursday Oct 31, 2013

Here is the link to the folder containing the 3 zip files:

https://app.box.com/s/lybagj2hr3hgmpkp2emc

Reply #9

winsumloosesum — Wed, 30 Oct 2013 10:35:48 GMT

Here are the updated Pick 3 drawings. Updated through Tuesday October 29 2013

Download link to the folder containing the 3 zip files. Midday, Evening, and Combined.

You can unzip the updated draw text files into the folders created in the previous post.

https://app.box.com/s/lybagj2hr3hgmpkp2emc

Reply #8

winsumloosesum — Mon, 28 Oct 2013 20:40:16 GMT

Here are the updated Pick 3 drawings. Updated through Sunday October 27 2013

Download link to the folder containing the 3 zip files. Midday, Evening, and Combined.

You can unzip the updated draw text files into the folders created in the previous post.

https://app.box.com/s/9l2ry02sdhkyvhjwlrsz

Reply #7

CARBOB — Mon, 28 Oct 2013 09:23:49 GMT

Thanks Steve

Reply #6

winsumloosesum — Sun, 27 Oct 2013 22:45:53 GMT

Video 1: Creating your folders and draws text files in each of the 3 sub-folders

http://www.youtube.com/watch?v=XbwIqFzDH6Q

Reply #5

winsumloosesum — Sun, 27 Oct 2013 22:02:22 GMT

I updated both the Pick 3 text files and also the 2 Excel files:

Here is the link to the folder that contains the 3 zip files for the Midday, Evening, and Combined draw history text files:

https://app.box.com/s/unhfwgunczkefu4c7wyy

Here is the link to the folder that contains the 2 Excel files: 1997 through 2003 and 2007 2010 versions:

https://app.box.com/s/whi3ak3t9xnd6xw8mmjo

You can delete the previous files downloaded from the 1st post.

Use the same folders.

I

Reply #4

CARBOB — Sun, 27 Oct 2013 11:05:59 GMT

Just saw this thread. Downloaded programs, took a quick look, waiting for instructions.

Reply #3

winsumloosesum — Sat, 26 Oct 2013 12:52:28 GMT

This should get you started.

I will post some videos on how to use the Excel file and import a sample text file later today.

I will be using the Pennsylvania Evening draws....

Reply #2

winsumloosesum — Sat, 26 Oct 2013 12:50:42 GMT

Here is a screen shot of the Main Folder Pick3System and the Sub Folders:

My hard drive is the letter C. Yours may be a different letter. As long as you name the Mian folder and Sub-folders exactly as below.

Here is a screen shot of the Sub Folder MiddayDraws and the text files that were unzipped into this folder.

Reply #1

winsumloosesum — Sat, 26 Oct 2013 12:28:02 GMT

Next,

Here are the links to the folder containing the 3 zip files:

https://app.box.com/s/puz7m6oedpuonegga6l6

The 3 zip file are as follows:

Zip File 1: Midday Draws

Zip File 2: Evening Draws

Zip File 3: Combined Draws

Download each of the 3 zip files.

1. Unzip the drawing text files for Midday Zip files into the MiddayDraws folder you created from the 1st post.

2. Unzip the drawing text files for Evening Zip files into the EveningDraws folder you created from the... [ More ]

Pick 3 VTRAC Movement System - Excel

winsumloosesum — Sat, 26 Oct 2013 12:13:51 GMT

This is an Excel file that I updated from another lottery forum called elotteryuniverse. There was a member compulotto who also was a member here for a short while explaining how to use VTRAC's.

The Excel file I'm going to share will enable you to import a Pick 3 text file from you Pick 3 game into the Excel file. I will provide the links to the zip files later today. I just finished work at 6:30 am.

I'll also post some video on how to use the Excel file.

Here is the link to the Excel f... [ More ]