winsumloosesum's Blog

Ultra34 Install File: August 2019 Version

RL will most likely release a new/updated version in next couple days.

In the mean time you can use the install file:

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

Here are the Pick 3 and Pick 4 databases: Updated through Wednesday Oct 2, 2019

Pick 3:

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

Pick 4:

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

Here are the Virginia Pick 3 and Pick 4 database files from the beginning of each game.  Used the official Virginia lottery website.

1>2 zip files.  1 for pick 3 and 1 for pick 4

Pick3:

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

Pick4:

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

2>Inside the zip files are 3 database games.  VA3D = Midday, VA3E = Evening, VA3C = Combined Draws

3>Looks like the combined database files will work in LTB99.

Lightning Bolt 99 Video:

How to create Pick 3 database file using Excel and Access 2002

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

Download link below contains a zip file containing RL's Tools programs posted 2 years ago and also zip file to RL D-TRAP program

The Tools Programs should be the last known update.

RL's Tools Programs & Videos:

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

DTRAP Program Zip & Video:

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

Note: The DTRAP Program was also included in the Tools zip but this DTRAP has added functions.

Below are the Excel files created back in July 2018.

Original Version: I have to update the game files to current games.

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

Newer Version: Note: Not sure why I created this updated version

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

Youtube video still live or use the link below to download:

https://www.youtube.com/watch?v=QK_SEiD3RIg&feature=youtu.be

Or

Video Instruction for the Original Excel files NOT the newer version

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

 

1>Create 2 new folders and name them whatever you like.  Example: Folder 1 System198 Old, Folder 2 System198 New

2>Download the zip file above and place them in you new folder.  Old version in Old folder, New Version in New Folder

3>Unzip the the 2 zip files.

As I mentioned above I will need to update the Older Version later today.  Wednesday morning or later...

This is the older version of FLIP 1

Installation zip:

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

Games zip: Updated through June 17, 2019

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

 

Additional Files: D-File Explanation

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

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

Installation zip file:

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

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

Pick 3 Games

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

Pick 4 Games

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

Below is the download link to a zip file containing 1 Excel file:

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

I'll add a video in a day or so on how to use the Excel file.

Member requested creating a Batch to Base Excel file:

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

Column Z contains all the decimal equivalent to the Zero/One/Two/Three Batch file used in Ultra-34

Column O contains the actual 4 digit Batch Values

Columns AB through CI contain the Pick 3 sets

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

The above download link contains a zip file

Inside the zip file is an Excel file with your Michigan Pick 3 games

There are 3 worksheets.

1>Midday

2>Evening

3<Combined Draws

Each worksheet has the calculations for the 3-1-7 rundown based on the winning set drawn for each day.

To the very far right are (9) shaded boxes with the Pick 3 sets.

I only calculated the last 25 games but they can be increased to whatever past games you want to use.

You can drag the formulas/cell down to whatever date you want.

There are Toolbars in each of the worksheets for you to Add a New drawing.  You just click the Toolbar and add the Pick 3 winning number in cell H20.  The dates are automatically updated.

— Previous Private Message —
Sent By: reese2002
Sent: May 30, 2019, 6:20 pm Eastern Time (GMT-5:00)

Winsumloosesum

Am hoping that you would do me a favor? I am not very good at spreadsheets at all to say the least. I was in need of a spreadsheet that has the 317 rundown capabilities of about adding 25 draws and then saving and printing on my computer. I have to do about 3 years of draw input and use it for the system i am following. Any help would be greatly appreciated. Thanks Reese2002

Ultra-34 - Video 3

Video 3 will explain how to use the UltraStep2.xlsm Excel file to create individual game files for RL's Ultra-34 program.

Youtube video link:

https://youtu.be/tsA9O6-2ZOc

Post any comments or send me a PM.

Thanks

Win

I updated the Excel files and added additional features:

1>Added macro that will transfer either Pick 3 or Pick 4 game file(s) to the Ultra-34 Pick-3 or Pick-4 folder(s).

2>Select any game Pick 3 or Pick 4 (watch video)

3>Add new drawings as they occur during the day to any Pick 3 or Pick 4 game

I will try and post a new video tonight or tomorrow with instructions:

Download link to new zip file.  Replace the existing file created from the previous post or create a new folder and name the new folder anything you want.

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

The Excel file link below can be used to create individual game text files for RL's Ultra34 Pick 3 & Pick 4 program.

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

Video Instructions on how to use the Excel file and creating game text files:

https://youtu.be/rVl5GLsDbfA

Note: When saving your text file ensure that you save the Pick 3 text files to the Pick-3 folder. Pick 4 text files to the Pick-4 folder 

Do not use the same file name that is currently located in each of the Pick-3 and Pic-4 folders.

The Pick-3 and Pick-4 folders should be located in the folder where Ultra34 is installed.

Post any comments or send me a PM with any questions, comments etc.

Thanks

Steve

Lotsoft Pro 5 Updates

1>For those who use Lotsoft Pro 5 the Live Updates will no longer work using the Brinkster FTP server.

2>Work around is to create an FTP server on your personal computer

3>Thanks to an LP member here I created instructions for a Windows 10 machine.  This should also work for Windows 8. 

    Windows XP will require a different set of instructions.

 

Download link to Windows 10 pdf Instructions:

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

Installation file Lotsoft Pro 5:  (for those who require a new installation)

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

 

These are the .mdb files from my computer.  Once you install Lotsoft Pro you will need to replace the .mdb files in the following folder:

C:/Program Files/INW/Lotsoft/data

Download link to my .mdb files:

Pick 3 Games

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

Pick 4 Games

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