PICK 3 EXCEL FORMULAS DIGIT RETURNS

Special thanks to Excel experts at mrexcel.

Excel formula for calculating the number of digit returns from the previous drawing.

For example:

if in cells a1, b1, c1

2 0 0

if in cells

0 2 2

In cell d1 enter the following formula:

=SUMPRODUCT(IF(COUNTIF(A1:C1,{0,1,2,3,4,5,6,7,8,9}) <COUNTIF(A2:C2,{0,1,2,3,4,5,6,7,8,9}),COUNTIF(A1:C1,{0,1,2,3,4,5,6,7,8,9}),COUNTIF(A2:C2,{0,1,2,3,4,5,6,7,8,9})))

Then press the following keys at the same time (Control - Shift - Enter) on your keyboard.  You should see { } at the beginning and end of the formula.

Even Odd Neighbor Numbers List with only Boxed Numbers

Courtesy of MikeK


What are Neighbor Numbers?

Digits - Neighbor
0,1         0
2,3         1
4,5         2
6,7         3
8,9         4

Neighbor Number Excel Formula?
=INT(Digit*.5)  - for example if your first position digit is in cell a1 is 8 and wanted to enter this formula in cell e1 =INT(a1*.5) this would give you the "Neighbor Digit" of 4 (see chart above)

When you are looking at a EvenOddNeighborNumbers List with only BoxedNumbers you see that there really three types of EvenOddNeighborNumbers:
1. with 4 BoxedNumbers,
2. with 6 BoxedNumbers, and
3. with 8 BoxedNumbers.

This gives you a much better tracking system for
Boxed numbers than Vtracs provides.

EvenOddNeighborNumbers:
000(4)
000,001,011,111
EvenOddNeighborNumbers:
111(4)
222,223,233,333
EvenOddNeighborNumbers:
222(4)
444,445,455,555
EvenOddNeighborNumbers:
333(4)
666,667,677,777
EvenOddNeighborNumbers:
444(4)
888,889,899,999
EvenOddNeighborNumbers:
001(6)
002,003,012,013,112,113
EvenOddNeighborNumbers:
002(6)
004,005,014,015,114,115
EvenOddNeighborNumbers:
003(6)
006,007,016,017,116,117
EvenOddNeighborNumbers:
004(6)
008,009,018,019,118,119
EvenOddNeighborNumbers:
011(6)
022,023,033,122,123,133
EvenOddNeighborNumbers:
022(6)
044,045,055,144,145,155
EvenOddNeighborNumbers:
033(6)
066,067,077,166,167,177
EvenOddNeighborNumbers:
044(6)
088,089,099,188,189,199
EvenOddNeighborNumbers:
112(6)
224,225,234,235,334,335
EvenOddNeighborNumbers:
113(6)
226,227,236,237,336,337
EvenOddNeighborNumbers:
114(6)
228,229,238,239,338,339
EvenOddNeighborNumbers:
122(6)
244,245,255,344,345,355
EvenOddNeighborNumbers:
133(6)
266,267,277,366,367,377
EvenOddNeighborNumbers:
144(6)
288,289,299,388,389,399
EvenOddNeighborNumbers:
223(6)
446,447,456,457,556,557
EvenOddNeighborNumbers:
224(6)
448,449,458,459,558,559
EvenOddNeighborNumbers:
233(6)
466,467,477,566,567,577
EvenOddNeighborNumbers:
244(6)
488,489,499,588,589,599
EvenOddNeighborNumbers:
334(6)
668,669,678,679,778,779
EvenOddNeighborNumbers:
344(6)
688,689,699,788,789,799
EvenOddNeighborNumbers:
012(8)
024,025,034,035,124,125,134,135
EvenOddNeighborNumbers:
013(8)
026,027,036,037,126,127,136,137
EvenOddNeighborNumbers:
014(8)
028,029,038,039,128,129,138,139
EvenOddNeighborNumbers:
023(8)
046,047,056,057,146,147,156,157
EvenOddNeighborNumbers:
024(8)
048,049,058,059,148,149,158,159
EvenOddNeighborNumbers:
034(8)
068,069,078,079,168,169,178,179
EvenOddNeighborNumbers:
123(8)
246,247,256,257,346,347,356,357
EvenOddNeighborNumbers:
124(8)
248,249,258,259,348,349,358,359
EvenOddNeighborNumbers:
134(8)
268,269,278,279,368,369,378,379
EvenOddNeighborNumbers:
234(8)
468,469,478,479,568,569,578,579

No. of Results   : 220
No. of Selections: 35

SUM DIGITS IN ONE CELL

Using the Morefunc Add-In formula for Excel 2002:

=EVAL(SUBSTITUTE(A1,"-","+"))

Where cell A1 has the following: 1,2,3,4,5

Sum would equal 15

Google "Morefunc" English version to download Free Morefunc Add-In

COUNT NUMBER EVEN ODD IN CELL RANGE

These Excel formulas will count the number of Even Numbers and Odd Numbers in a cell range.

For example: Pick 3

You have Position 1 (A1), Position 2 (B1), Position 3 (C1)

Enter the following formula in cell D1 to count the number of "Even Digits in cell range A1 through C1

=COUNT(A1:C1)-SUMPRODUCT(MOD(A1:C1,2))

Enter the following formula in cell E1 to count the number of "Odd Digits in cell range A1 through C1

=SUMPRODUCT(MOD(A1:C1,2))  ODD

CREATING P34 COMB WITH VBA

Pick 4 Code:

Option Explicit
Dim A As Integer, B As Integer, C As Integer, D As Integer
Dim X As Double

Sub CombininationsPick4()

Columns("A:E").Select
    Selection.ClearContents
    Range("G1").Select
 
' Generates all combinations for a pick-4 lottery

Range("A1").Select

X = 1

For A = 0 To 9
For B = 0 To 9
For C = 0 To 9
For D = 0 To 9

ActiveCell.Offset(X, 0).Value = X
ActiveCell.Offset(X, 1).Value = A
ActiveCell.Offset(X, 2).Value = B
ActiveCell.Offset(X, 3).Value = C
ActiveCell.Offset(X, 4).Value = D

X = X + 1

Next D
Next C
Next B
Next A

End Sub

===============================================

Pick 3 Code:

Option Explicit
Dim A As Integer, B As Integer, C As Integer

Dim X As Double

Sub CombininationsPick3()

Columns("A:D").Select
    Selection.ClearContents
    Range("G1").Select
 
' Generates all combinations for a pick-3 lottery

Range("A1").Select

X = 1

For A = 0 To 9
For B = 0 To 9
For C = 0 To 9


ActiveCell.Offset(X, 0).Value = X
ActiveCell.Offset(X, 1).Value = A
ActiveCell.Offset(X, 2).Value = B
ActiveCell.Offset(X, 3).Value = C


X = X + 1


Next C
Next B
Next A

End Sub

Win d's Pairs Distribution Chart

  1.    13 15 17 19 35      Odd Pairs  

  2.    37 39 57 59 79

  3.    68 60 62 64 80      Even Pairs

  4.    82 84 02 04 24

  5.    12 23 34 45 56      Consecutive Pairs

  6.    67 78 89 90 01

  7.    16 27 38 49 50      Mirror Pairs

  8.    14 18 25 29 36      Ghost Pairs

  9.    03 07 47 58 69

  10.   11 22 33 44 55     66 77 88 99 00    Double Pairs

Others Method Win Pick 3

to get 27 possible combinations out of 3 numbers per positions do this

        pos.1        pos.2        pos.3

        0                1                2

        3                4                5

        6                7                8

so, you get: 012,015,018 - 042,045,048 - 072,075,078 - 312,315,318 - 342,345,348 - 372,375,378, 612,615,618 - 642,645,648 - 672,675,678 = 27 combinations

good luck!

source

Short Sum Pick 3

The sum of a number is the 3 digits added together.
The shortsum is the least significant number of the sum.
The rootsum is the digits of the sum added together to get one digit.

Example 488
4+8+8 = 20 sum, 0 shortsum, 2 (2+0) rootsum


>>>>>Shortsums<<<<<
0)
019 028 037 046 127 136 145 235 389 479 569 578
118 226 334 244 055 668 677 488 299
000

1)
029 038 047 056 128 137 146 236 245 489 579 678
001 119 227 335 344 155 669 588 399
777

2)
039 048 057 129 138 147 156 237 246 345 589 679
002 011 228 336 255 066 778 688 499
444

3)
012 049 058 067 139 148 157 238 247 256 346 689
003 229 337 445 355 166 779 788 599
111

4)
013 059 068 149 158 167 239 248 257 347 356 789
004 112 022 338 446 455 266 077 699
888

5)
014 023 069 078 159 168 249 258 267 348 357 456
005 113 122 339 447 366 177 889 799
555

6)
015 024 079 123 169 178 259 268 349 358 367 457
006 114 033 448 556 466 277 088 899
222

7)
016 025 034 089 124 179 269 278 359 368 458 467
007 115 223 133 449 557 566 377 188
999

8)
017 026 035 125 134 189 279 369 378 459 468 567
008 116 224 233 044 558 477 288 099
666

9)
018 027 036 045 126 135 234 289 379 469 478 568
009 117 225 144 559 667 577 388 199
333

>>>>>Rootsums<<<<<
0)
000

1)
019 028 037 046 127 136 145 235 289 379 469 478 568
001 118 226 334 244 055 559 667 577 388 199

2)
029 038 047 056 128 137 146 236 245 389 479 569 578
002 011 119 227 335 344 155 668 677 488 299

3)
012 039 048 057 129 138 147 156 237 246 345 489 579 678
003 228 336 255 066 669 588 399
111 444 777

4)
013 049 058 067 139 148 157 238 247 256 346 589 679
004 112 022 229 337 445 355 166 778 688 499

5)
014 023 059 068 149 158 167 239 248 257 347 356 689
005 113 122 338 446 455 266 077 779 788 599

6)
015 024 069 078 123 159 168 249 258 267 348 357 456 789
006 114 033 339 447 366 177 699
222 555 888

7)
016 025 034 079 124 169 178 259 268 349 358 367 457
007 115 223 133 448 556 466 277 088 889 799

8)
017 026 035 089 125 134 179 269 278 359 368 458 467
008 116 224 233 044 449 557 566 377 188 899

9)
018 027 036 045 126 135 189 234 279 369 378 459 468 567
009 117 225 144 558 477 288 099
333 666 999

Magic Numbers

Someone sent me a Private Message a while back about this one. Please read my Private Message reply below:

____________________________________

Actually, it would help you if the formulae were written a little better. I've broken up each formula on a separate line. You start with a pervious pick 3 draw, x, and do a few separate calculations. As an example, let's do 298 and 871.

Here are the formulae, x x /p+c x/p-c (x+c) /p (x-c) /p, reordered and correctly written:

     x
    (x / p) + c
    (x / p) - c
    (x + c) / p
    (x - c) / p

x is a previous day's draw.

p is equal to approximately 3.141592654

c is equal to 666

Just plug the number in:

Example 1

     298
    (298 / 3.141592654) + 666
    (298 / 3.141592654) - 666
    (298 + 666) / 3.141592654
    (298 - 666) / 3.141592654

these then become

    298
    760.8563461
    -571.1436539
    306.8507303
    -117.1380381

these are then rounded up or down to the nearest positive value

    298
    760 or 761
    571 or 572
    306 or 307
    117 or 118

Example 2

     871
    (871 / 3.141592654) + 666
    (871 / 3.141592654) - 666
    (871 + 666) / 3.141592654
    (871 - 666) / 3.141592654

these then become

    871
    943.2479109
    -388.7520891
    489.2422951
    65.25352667

these are then rounded to

    871
    943 or 944
    388 or 389
    489 or 490
    065 or 066

I hope this helps.

source

Tips Winning Pick 4 Lottery

I always used these methods and successful 80% of the time

1. Remove the combos that have the same sum of midday and evening.

2. remove the combos that have the mirror sum to the midday and evening.

3. Remove the combos that have two digit MIRROR return to the midday and evening.

4. removing the combos that have the sum of the day

These r successful to 90% of the time..

i use many other methods depending on the recent draw numbers..

source