Search

Pick 3 Excel Formula 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 pres...
Dec 25, 2009, 9:50 am - winsumloosesum

Yes Yes Yes YES YES YES!!
I finally got a reply from the GA Lottery about my request for detailed odds on all of their instant games. They sent me detailed odds for 7 of the games I requested. According to the little letter they sent with it, more are coming and they asked for my patience and apologized for taking so long. (Side note: I had gotten to the point to where I emailed WGCL-TV 46 CBS Atlanta's consumer team asking if my request fell under open records laws (thinking the GA Lot...
May 29, 2009, 12:01 pm - sorensonfan41

DiamondPalace's Pick 4 Hot n Cold
DiamondPalace's Pick 4 - HC - Excel Sheet...
May 3, 2009, 4:51 pm - diamondpalace

Still thinking...
Of a cool domain name. Too bad diamondpalace.com is already taken...but there can only be one diamondpalace! Anyway, not too worried about the domain right now. Been busy working on automating the Mega Millions Excel Sheet. Got few more things to go before it is plug play! Of course it's built to my specification along with the basic extractions to each draw. Should be able to speed up the process for other games once I completed this one. There are 10 worksheets within the ex...
Apr 8, 2009, 6:37 pm - diamondpalace

Pick 3 - 6 Numbers Wheel
I am sharing you my 6 numbers wheel for Pick 3. Download the excel sheet HERE . Pick your 6 numbers and place them into the orange box, and it will give you 20 combos for 6 numbers. I use this sometimes on hot and cold numbers mix, and then used the 20 combos and filter it through sum range 10 - 17, along with HHL/HLL and EOO/EEO frame....
Jan 24, 2009, 6:06 pm - diamondpalace

VBA Lesson 2
VBA: Lesson 2 This time we are going to sum our five numbers, then determine which one is odd and which one is even. We are going to build on what we have...
Jan 21, 2008, 9:35 pm - GASMETERGUY

Work - Getting There.....
Half of Phase I, II released - about 60Mb upload, over 200Mb sent by CD and over 400 pages of documentation. More than half of the paperwork may come back for mods - that'll be a major time eater. Not completely satisfied with appearance but functionality is good. The second half of the phases has hit a snag, corrections being made - but that's the purpose of error traps. It took long enough for the first pa...
Nov 18, 2007, 6:00 am - johnph77

Excel Formula - 6 Positions
Excel Formula Reference 6 Position Number in cell A1 (e.g. 012345) Place each digit in their own position. 0 in cell C1 1 in cell D1 2 in cell E1 3 in cell F1 4 in cell G1 5 in cell H1 =================================================== =INT(A1/100000) =INT((A1-(C1*10000))/1000) =INT((A1-((C1*100000)+(D1*10000)))/1000) =INT((A1-((C1*100000)+(D1*10000)+(E1*1000)))/100) =INT...
Oct 29, 2007, 11:36 am - winsumloosesum

pick 3 vertical pairs
experimenting with automation worked... still no backtesting, would probably need a VB routine or database for that. The basic idea is to look at the numbers drawn last night (example 3-2-6) and the numbers drawn tonight (example 4-7-8). this yields the positional vertical pairs P1 = 34 P2 = 27 P3 = 68 I created a chart that fills itself in when you add draws (using excel, also works in open office). the first row contains 00 thru 99, the columns are from 0-9 for...
Aug 3, 2007, 11:31 pm - hypersoniq

"Positive Change" and the pick 3
As always, the easiest way to start out atheory is against pick 3 data. I had previously worked with the 1-1-1 system. I had performed operations in excel that subtracted 10 and used absolute values of negative numbers... too complex! I have redone a proof of concept worksheet and have decided to adopt a rolling lookup table. there ARE no negative numbers OR numbers over 9. problem is it has to be manually changed, there are 1,000 possibilities! I got...
Jun 30, 2007, 4:14 pm - hypersoniq