winsumloosesum's Blog

3-1-7 Rundown Excel

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

Entry #241

Ultra34 - Excel File & Video Updated

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

Entry #239

Ultra34 - Excel File & Video

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

Entry #238

Lotsoft Pro Files

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

Entry #237

Excel Files - Big Game Lotteries - Mega Millions & Power Ball

I created an Excel file (Version 2010) for the Mega Millions & Power Ball games.

1>Contains the draw histories of the current matrices for both games

2>Calculates Hits & Skips for both the White balls and Bonus balls

3>Sorts Hits, Skips, Digits using the Toolbars

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

 

Youtube video instructions:

https://youtu.be/FJ-qSc5Wxsw

 

Good Luck!!

Entry #236

MegaPower Random Picks - Power Ball

Saturday Nov. 3, 2018

20 Sets

Note: Power Ball last number on right

7 33 42 43 67 12
6 11 31 45 51 11
4 28 42 61 66 12
10 18 27 29 56 20
7 26 31 46 67 13
10 14 29 57 62 5
8 20 22 59 61 10
25 38 39 46 59 17
22 37 40 45 52 11
1 13 22 47 62 10
4 22 23 58 64 17
6 9 20 58 68 5
3 21 56 61 62 19
6 11 24 31 54 26
4 11 29 40 67 18
6 7 8 17 52 11
7 8 13 44 63 4
13 23 30 44 57 3
21 35 43 50 63 4
16 25 27 56 58 6

Entry #235

MegaPower Random Picks - Pennsylvania Cash 5/43

Saturday - Nov 3, 2018

20 Sets

7 12 14 28 39
5 15 25 33 34
3 24 26 30 42
5 16 19 24 36
10 21 35 36 40
3 6 10 16 18
3 15 28 36 40
11 21 23 29 33
11 24 25 26 42
13 17 29 37 40
4 16 23 37 40
5 7 30 31 35
4 14 27 30 39
2 8 19 35 36
4 7 14 26 39
9 25 29 32 37
10 30 34 41 43
6 15 21 31 34
4 20 21 30 42
6 12 18 21 43

Entry #234

MegaPower Random Picks - Pennsylvania Treasure Hunt 5/30

Saturday - Nov 3 2018

20 Sets

2 10 14 16 18
1 7 9 22 28
5 14 18 19 29
2 16 21 27 30
3 5 15 17 29
9 16 18 21 25
8 10 13 22 26
6 13 18 21 23
4 7 19 23 26
2 6 7 11 22
4 11 13 18 20
5 10 14 25 27
4 7 18 20 22
4 7 11 15 16
1 14 16 17 26
7 10 18 22 27
6 8 12 14 15
4 10 11 21 23
7 16 20 21 24
5 9 23 28 29

Entry #233

MegaPower Random Picks - MegaMillions

Mega Millions

Friday Nov 2, 2018

20 Sets - Last Number Right Bonus Ball Numbers

4 24 39 49 60 19
2 6 26 60 61 23
7 40 49 54 57 9
6 26 52 54 65 7
3 52 54 64 65 21
7 10 35 45 59 12
20 31 41 67 69 2
20 21 40 63 70 19
16 29 37 42 63 11
13 40 46 55 56 19
3 29 39 53 65 8
14 23 47 50 65 21
26 30 33 37 38 22
16 17 35 36 65 10
8 29 49 50 58 5
4 19 31 37 51 2
5 29 38 43 57 19
4 6 17 19 30 17
2 6 8 19 65 11
2 30 46 50 66 6

Entry #231