Search

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

new (to me) hypothesis...
Everything in nature is trying to find balance, from us as people to the cells inside of us to the atoms everywhere... I'm stuck on LoopRS development now, but the next one on the back burner will be based on the concept of Homeostasis perhaps instead of looking for the most frequent or least likely we should be seeing what draw results will tend to balance out the draw frequency... I didn't ditch PROfile, because there is much valuable data there tha...
Apr 10, 2007, 11:22 pm - hypersoniq

DB vs. Spreadsheet
Still plugging away here... got an access DB built with all PB sort order data. Now to build the queries... As for the Excel sheets, big leaps in summary screen automation and updating is getting to be a quicker process... system finally generates the quick pick just by entering the results from the last draw. think I'll keep 'em both! hot indicators are definitely direction and divisibility, still awaiting inspiration on narrowing them down however....
Mar 4, 2007, 3:52 pm - hypersoniq

MS Access for PowerBall
Ahh the challenges of designing a database. After much thinking and a quick review of the Designing a database book I used to study for my MCDBA, I have come to the realization that my entire suite of excel workbooks can be reduced to 2 tables and a few carefully crafted queries... Added bonuses, 1) new filters can be added as easily as dropping in a new query. 2) once complete, a few minor changes can be made to convert to any game 3) I can backtest...
Feb 27, 2007, 5:57 am - hypersoniq

Looking at old data in new ways
As I mentioned last post, I am right now only concentrating on the 1:42 red ball in PB. I am working on an excel file called PROfile that presents several bits of info... 1. RAW odds for example, the number 5, RAW data would indicate that there are 4 numbers lower, 1 repeat, and 37 higher. using percentages, you can see raw odds of the next number drawn being higher/lower (5 favors higher) 2. Observed history same scenario, only using observed history. 3. Confide...
Jan 26, 2007, 6:05 am - hypersoniq