Search

Florida: 11/1 - 11/30/2008Reply
CELL B1: 0 1 2 3 4 5 6 7 8 9 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 3 3 3 3 3 3 4 4 4 4 4 5 5 5 5 6 6 6 7 7 8 CELL B2: 0 1 2 3 4 5 6 7 8 9 1 2 3 4 5 6 7 8 9 2 3 4 5 6 7 8 9 3 4 5 6 7 8 9 4 5 6 7 8 9 5 6 7 8 9 6 7 8 9 7 8 9 8 9 9 SHEET3 COPY THIS DATA OF ALL THE PAIRS TO EXCEL BOLD AN LARGE THE PAIRS GO FROME ROW 1 TO ROW 2 , I fill in red and make the numbers white Next: IN CELL B3 COPY AND PAST THIS: =COUNTIF(B$6:B$2924, =4 ) THEN COPY THIS AND ACCROSS TO THE
Nov 7, 2008, 4:38 am - Mark J - Pick 3 Forum

Tutorial for Lottaloot_WorkOut TX
Decided to show how I use the sheet for TX (but you can follow along with any state if you choose) The sheet that I have in front of me is the evening only (standardized worksheet made by SirMetro sent to those requesting a sheet) From 6/1/05 thru 6/22/05I like to use a wide range for my doubles search so the formula that I am using is =COUNTIF($J$2:$O$500,S2)**Those with limited excel knowledge (only the numbers in yellow would change)The countif simply means I'm looking in column J row 2 thr
Jun 23, 2005, 4:27 pm - lottaloot - Pick 3 Forum

Lottaloot system set-up
I have decided to share my system since there are so many people requesting their state be done. Now you can do your own. If you can tweak this, please do so let us all know. Also, if you can share numbers within the forum that you obtain from this-Please do so. To set up in excel B1(DATE) C1 (DRAW) D1 (a) E1(b) F1(c)Column G has been made to become width .17 Add to Column H1 thru M1 ( ab, ac, ba, bc, ca, cb )O1(root)P1(sum)Q1(Doubles)R1(pairs)S1(Singles or whatever you wish to call other
Jun 22, 2005, 12:35 pm - lottaloot - Pick 3 Forum

Open Discussion: Define/Refine PredictionReply
I'm no further in the prediction process, but for all the excel -erators hre, this is a simple formula for excel to backtest for straights and boxes when doing a multi-step rundown (a la Julian Dates added to last draw or 111+last draw, etc)...=IF(S2=(($D3*100)+($E3*10)+$F3), S ,IF(S2=(($D3*100)+($F3*10)+$E3), B ,IF(S2=(($F3*100)+($E3*10)+$D3), B ,IF(S2=(($F3*100)+($D3*10)+$E3), B ,IF(S2=(($E3*100)+($D3*10)+$F3), B ,IF(S2=(($E3*100)+($F3*10)+$D3), B , ))))))Assumes S2 contains the first resul
Dec 22, 2003, 10:20 pm - hypersoniq - Pick 3 Forum

TUTORIAL: How to count skips with excel
I said I would share this if ever found...I thank GillesD from another forum.Here is his explaination...------------------------------QUOTE GillesD---------------------------Skips for Pick 3 drawsLets say your data in Excel has the draw number in column A and N1, N2 and N3 in columns B, C and D starting on row #3 and going down. Row 2 can be used for labels. Note it might be best if the width of columns is small in order to see more (a width of 5 is enough).A - Skips not considering the position
Jan 23, 2004, 8:19 pm - hypersoniq - Pick 3 Forum

Need help with workout....Reply
Deb, Put this formula in V6, then copy across, then down. =COUNTIF($G$3:$J$3,G6)Carbob
Oct 26, 2005, 7:44 pm - CARBOB - Pick 3 Forum

January list- times hit & notReply
Tenaj, you probably have a program that does this (but it's not the same program) as I put this spreadsheet together myself using the =sum(countif(... feature in excel. I am becoming quite the wiz with excel. (not great, but I can make it do the simple things that I want
Jan 22, 2006, 10:04 pm - lottaloot - Pick 3 Forum

Lottaloot system set-upReply
Thanks Lottoloot, I appreciate you sharing your worksheet. I ran into a problem:The countif formulas that you have in Column R are not working for me. Have I done something wrong. The other formulas are working fine.Bolade'
Jun 22, 2005, 4:57 pm - mybolade - Pick 3 Forum

Open Discussion: Define/Refine PredictionReply
Still trying to figure out how to count skips in excel... Had been reading about using a COUNTIF formula with the INDIRECT formula, but no luck so far in actually implementing it (they didn't provide an example). Anyone have any other ideas?
Dec 28, 2003, 7:41 am - hypersoniq - Pick 3 Forum

Open Discussion: Define/Refine PredictionReply
Quote: Originally posted by WIN D on November 30, 2003 Hyper....wish you would describe this some more ....sounds interesting.ok, start off with your entire history in columns (1st ball, 2nd ball, 3rd ball)beneath the list, I put the excel formula=MODE(A2:A9100) ' for example... A2 because of the header row and 9100 represents the end of the history listnow just autofill left and you have the mode for each position. I keep the number side by side in 2 formats, one is each number in posi
Nov 30, 2003, 2:30 pm - hypersoniq - Pick 3 Forum