diamondpalace's Blog

Mega Millions Excel Sheet by DiamondPalace

>>>DOWNLOAD<<<

---

For the user's guide, look at the previous blog post and apply it to this game, the two are similar.

PowerBall Excel Sheet by DiamondPalace

>>>DOWNLOAD<<<

 

---

PowerBall Excel Sheet User's Guide

 

This will help to understand the sheet, and to update it as new draws results comes in. Explanations to each elements within the sheets are also in the steps.

Steps:

1.Create a new row, and Plug in the latest result under "RESULT".

 

---

 

 

2. To the right of "RESULTS", there's "R#" (repeat numbers) and "C#" (consecutive number). First, Look within the new draw and compare it with the previous draw, to see if there are any repeating numbers, if so, highlight it in light blue for it to stand out. Then, make the cell on the same row and put #2 under "R#". For "C#" (consecutive number) look within the new draw to see if there are any, if so, put a check on the same row. This will help identify its frequency.

3. Add up the new result to get the SUM.

02+15+39+44+56 = 156 then place it under "SUM" on the same row. Purple boxed indicate SUM over 100+, gray color under -100.

4. With the new SUM, 156 take that and go to the next tab "SUM RANGE" and then add 1 under "150-159", and note at the bottom "Last Update"put the last day the change was made. If a day was missed, one can go back and see where it was left off. Very important little reminder. Use this as a guide to have the lines in HOT sums.

5. Now, we look within the new result entry. Look for Low numbers, and High numbers. Low: 1 - 29, High: 30 - 59 for PowerBall.

From the result 02-15-39-44-56 we have 2 lows, and 3 high (2L/3H). Each are color coded so copy from the previous draws that have the same L/H combo. Identification on one result does not mean much, but when combined with the entire data within the sheet a pattern starts to emerged with low/high combos. 

6. Next to this "Low/High" section, there's "Even/Odd". Yes, we are extracting the results to see the basic components, what it's made of. Similar to the previous step, look for even/odd instead, and place it on the same row under "Even/Odd".

 

---

 

 

7. From "RESULT" we are moving to the left of the sheet. Here, we have "Group Numbers". There are 59 numbers in PowerBall, that's one big pool with lots of numbers, so to make things in bite size we divided 59 of those numbers and place them into smaller pools, in jacuzzi. There are 4 small groups, A, B, C, and D. Each of these groups have the assigned numbers to them on top of the bar:

A: 01-14

B: 15-29

C: 30-34

D: 45-59

Now, identify the result and see how many numbers shows up within a group.

From 02-15-39-44-56 we have, 02 in group A so marked 1 for group A. Dark blue color indicate more than 1 digit from the group showed up within the new draw.

15 from group B.

39 & 44 from group C.

And 56 from group D.

Then under "GROUP" place ABCD on the same row.

Can't tell much from one result. However, when combined with the rest of the results on the sheet there are patterns to them. 

There are 4 small groups; A,B,C and D. When they combined, there are a possible of;

ABCD

ABC

ABD

ACD

BCD

AB

AC

AD

BC

BD

CD

place the appropriate group under "GROUP" according to the numbers within the new result. Each of the combinations are color coded, so copy and paste from the previous draw that share the same group as the new draw.

8. After all that is done, we now look at the PowerBall (red ball) which came with the five white balls.

There are now 39 power balls to this game, and we have divided them into smaller groups;

A: 01-09

B: 10-19

C: 20-29

D: 30-39

Each powerball number is on the same row as the result which it came with. The "X" indicate a placement to which the number came from a group. They are color coded, copy and paste from the previous PB that share the same group number as the new one. 

9. Hot/Cold PowerBall numbers.

In the "Hot Cold" tab, there's a graph with the current hot cold numbers.

The first "Numbers" and "Hit Times" are from previous 10 draw, the second are from 50 previous draws.

Copy and paste the graph from the site listed on top of the sheet. Once you're at the site click on "Lottery Analysis" from the left menu, and pick the state that have PowerBall, and select 10 previous draw analysis, then copy and paste in the numbers to the sheet, same step for 50 previous draw. Don't forget to color the cell of the numbers that are in the latest draw.

This section helps identify the hot and cold numbers, you can get them here on LP, but I like the graphs on the mentioned site, which someone is blocked from LP... Anyway, moving on to the last section of the sheet.

10. "Wheel" is the last tab is where you can wheel the 9 numbers. To wheel more than 9, you can visit LP under Pick 5 wheel section. I have it here just incase you're unable to get online and have 9 numbers wanted to wheel. Noticed the SUM section, pick the lines that have HOT SUMS, look in the "SUM RANGE" tab for the Hot/Cold sums.

 

Feel free to PM me with questions/suggestions/reviews. Thanks and good luck!

 

Go buy your Mega Millions tickets tonight! And have a wonderful weekend.

The sheets are ready, I will upload them this weekend. Also found a new hosting site for the files which does not have in your face ads.

Right now I am working on Pick 4 straight system for All States, and many many new system that are yet to be published. 

When I move to Texas in a week, will be starting on a new project...writing a book, "Diamond Cut", in stores near you. :)

2/20/09 
All Day - All States

PAIR: 02

092 082 072 062 052 042 032 022 012 002 
Expected hits: 2+

2/19/09
All Day - All States

PAIR: 19

019 119 219 319 419 519 619 719 819 919
Expected hits: 2+

2/19/09

All Day - All States

520 521 523 524 620 621 623 624 720 721 723 724 820 821 823 824 920 921 923 924

526 527 528 529 625 627 628 629 725 726 728 729 825 826 827 829 925 926 927 928

Expected Hits: 4+ STR / 8+ BOX

2/18/09

All Day - All States

056 057 058 059 650 651 156 652 157 653 158 654 159 750 751 256 752 257 753 258

754 259 850 851 356 852 357 853 358 854 359 950 951 456 952 457 953 458 954 459

Expected hits: 5+ STR / 9+ BOX

I have many excel sheets created (also with the help of some people) for:

pick 3

pick 4

GA - Fantasy 5

W.Virginia - Cash 25

GA - Win For Life

Mega Millions

Powerball

Texas Two Steps

Which I will share with you all sometime this week. I still need to finish the Powerball sheets. Also along with few extra sheets that I created to back test on systems by few members. Will have them available as well and the link to the system/method which was used. I am sharing everyone my sheets does not make me the "Excel Guy"...hehe, just refer me as "DiamondPalace". Thanks!

Stay tuned and check back this week for the download links to all of these. 

And it came true this morning...LOL, funny how this kind of dreams comes true, but not when I dreamt about winning the lotto it didn't...or have not yet!! What a day.

DNA - Method for Pick 5

2/14/09 RESULTS

26  29  42 = $2

I made an extensive observation on Texas Two Steps.

2/13/09

EvE

590 095 591 096 592 097 593 098 594 690 195 691 196 692 197 693 198 694790 295

791 296 792 297 793 298 794 890 395 891 396 892 397 893 398 894495 496 497 498

Expected Hits: 2+ STR

 

My routine for Pick 3 Straight. Posted the predictions early today in the Pick 3 Forum for 2/12/09 eve, all states, straight play. Expected hits: 2+ STR are met! Just to show you how much work goes into finding the straight numbers. There were a lot of boxes too, but I am only going for straight, it pays more. ;) Excuse the low quality video, the system is still in development and is one of my secret weapon agaisnt Pick 3!