Pick 3 VTRAC Excel System

Reply #20

lottologix — Tue, 16 Jul 2019 05:53:29 GMT

Thank you. This worked. Now the only question is why are vtracs just mirror numbers? Is there a spot in one of the spreadsheets that defines the vtracs? I would like to experiment with different numbering ideas to see if there is anything there or does it just all flatten out if you try to use number frequency or other methods to define what each vtrac is

Reply #19

winsumloosesum — Sat, 13 Jul 2019 13:13:16 GMT

Games updated through Friday, July 12, 2019

Reply #18

winsumloosesum — Fri, 12 Jul 2019 12:52:27 GMT

Pick 3 Games updated through Thursday, July 11, 2019

Use the most recent links posted.

Reply #17

Boatman1567 — Fri, 12 Jul 2019 04:18:13 GMT

Winsumloosesum,

Just downloaded your files. It's a bit late to go over it in detail but I have to say - you are such a talented guy with all that you put into this endeavor. Can hardly wait to try it out.

Thanks so much for your efforts

Reply #16

winsumloosesum — Thu, 11 Jul 2019 14:18:02 GMT

Draws updated through Wednesday, July 10, 2019

Use the download links to the zip file from the links above.

Reply #15

winsumloosesum — Wed, 10 Jul 2019 13:27:55 GMT

Draws updated through Monday, July 9, 2019

Use the download links to the zip file from the links above.

Reply #14

winsumloosesum — Tue, 09 Jul 2019 12:29:32 GMT

Draws updated through Monday, July 8, 2019

Use the download links to the zip file from the links above.

Reply #13

winsumloosesum — Mon, 08 Jul 2019 09:29:43 GMT

Updated the Pick 3 draws through Sunday July 7, 2019

Use the same download links from the previous post(s)

I'll upload some videos today..

Reply #12

winsumloosesum — Mon, 08 Jul 2019 09:26:54 GMT

Open Step2 Excel file and leave open. Next open the VTRACMovement snip sSkips Excel file. This should fix the #REF errors.

The VTRACMovemebt snip sSkips Excel file needs the Step2 Excel file open in order to calculate the formulas. In other words the Excel file feeds off the Step2 Excel file.

Let me know if this worked!!

This post has been automatically changed by the Lottery Post computer system to remove inappropriate content and/or spam.

Reply #11

lottologix — Mon, 08 Jul 2019 07:06:14 GMT

I also have file named VTRAC Movements, Has alot of #REF cells. I am sure something needs to be updated but what?? Using Excel 2007 macros enabled from the trust center. Would like to figure out what it does

Reply #10

lakerben — Sun, 07 Jul 2019 16:49:58 GMT

Thanks steve

Reply #9

winsumloosesum — Sun, 07 Jul 2019 09:05:54 GMT

The Pick 3 draws are updated through Saturday, July 6, 2019

Use the same links to the zip files above.

I updated the Step2 Excel file and added calculations to create more Pick 3 sets.

I'll post a video today on the new calculations.

Also added a new Excel file that calculates the Hits/Skips for Positions for VTRACs, Digits, Movements, and Followers.

Use the new Excel file VTRACMovementsSkip snip s.xlam with the Step2 Excel file. Open Step2.xlsm 1st then open the VTRACMovementsSki... [ More ]

Reply #8

winsumloosesum — Sat, 06 Jul 2019 12:32:54 GMT

The Pick 3 draws are updated through Friday, July 5, 2019

Download link to all 3 Excel files in 1 zip file.

https://my.pcloud.com/publink/show?code=XZYVn37ZesW1yVF2xIk78oOqRXyM3ks7Vnz7

For those who just want to use the Step2.xlsm file can download this zip file which conatins just the 1 Excel file:

https://my.pcloud.com/publink/show?code=XZmYT37ZOdLSQtQNH3XHL7uEHeqRLbcgeDhy

Reply #7

lakerben — Sat, 06 Jul 2019 03:22:43 GMT

thanks! Steve

Reply #6

Bluegal1 — Fri, 05 Jul 2019 19:42:15 GMT

Thanks for posting! Subscribed to your channel on YT

Reply #5

winsumloosesum — Fri, 05 Jul 2019 19:26:44 GMT

Fixed the error in Step 2 Excel file movement calculations:

Use the same link from Opening Post (OP)

Follow the instructions from the 1st post

https://my.pcloud.com/publink/show?code=XZYVn37ZesW1yVF2xIk78oOqRXyM3ks7Vnz7

Good luck!

Win

Reply #4

winsumloosesum — Fri, 05 Jul 2019 19:17:07 GMT

Video 5: Pennsylvania Pick 3 Evening draw selections Friday July 5 2019

https://youtu.be/IVn6cGpuwQE

Reply #3

winsumloosesum — Fri, 05 Jul 2019 19:12:55 GMT

Video 4: Re-cap of Pennsylvania Midday drawing for Friday July 5 2019

https://youtu.be/vm6RFRcAEOE

LP post from earlier today;

https://www.lotterypost.com/thread/327809/5

Reply #2

winsumloosesum — Fri, 05 Jul 2019 18:13:18 GMT

Video 3: Step3 Excel file.

https://youtu.be/hs28xBJ71z8

Reply #1

winsumloosesum — Fri, 05 Jul 2019 16:34:26 GMT

Youtube Video:

https://youtu.be/VlZUU1eULG4

This video will give an overview of each of the 3 Excel files.

Video 2:

https://youtu.be/VlZUU1eULG4

Overview of Step2.xlsm file and how to update a Pick 3 game drawing.

Pick 3 VTRAC Excel System

winsumloosesum — Fri, 05 Jul 2019 16:09:27 GMT

These are Excel files I updated and wanted to share:

https://my.pcloud.com/publink/show?code=XZYVn37ZesW1yVF2xIk78oOqRXyM3ks7Vnz7

Instructions:

1 Create a new folder and name the folder anything you like. Example, Pick3VTRAC

2 Download the zip file from the link above and save it to the new folder you created above

3 Unzip the zip file. You should have 3 Excel files.

P3StateDraws.xlsm

Step1.xlsm

Step2.xlsm

I posted a Youtube video awhile back on how to update the P3Sta... [ More ]