Search

Program or SpreadsheetReply
Entering the cells I want to look at seems kind of silly. I want to look at all of them. I want to see which numbers come after eachother. If I only wanted to see what comes after 1, I would still have to look over the whole thing to find the cells with 1 in them. I may as well do that by hand. As for the use of countif formulas, I am not familiar with that. I will see if I can find something close to what I'm looking for and get back to you. Thanks.
Feb 13, 2010, 5:31 am - DMW774 - Lottery Discussion Forum

Need Math Analysis on Formula
I have been experimenting with a filter, Arithmetic Complexity in Fantasy 5. It also can be used in other lottery 6/xx type games. My question is this, can this formula be adapted to use for Play 3 Play 4 type games. In 5/xx 6/xx type games, the draws are in ascending order and the digits don't repeat. The way the formula is setup is below. I'm hoping KY Floyd or Jadelottery or anyone else who knows will supply an answer. AC HITS MED MAX AVG SKIP 0 1 1797 1 1 8.5 2249 3086.00 2
Jan 1, 2010, 12:50 pm - CARBOB - Mathematics Forum

Fla Fantasy 5 hottest number combinations to use and other tipZReply
Thanks for clearing that up. Here is a filter, I just started experimenting with, it's called Arithmetic Complexity. The maximum AC for fantasy 5 is 6. It hits approximately 45% of the draws, with AC 5, they hit 69% of all the draws. AC HITS MED MAX AVG SKIP 0 1 1797 1 1 8.5 2249 3086.00 2249 2 73 12 94 42.27 31 3 129 5 37 23.92 4 4 744 5 29 4.15 8 5 792 5 28 3.90 2 6 1346 2.29 0 5 3086 44% 5 6 2138 69% There are 163,896 combos in AC 6 an
Dec 30, 2009, 2:33 pm - CARBOB - Pick 5 Forum

Help with Gap detection formula.Reply
Are you wanting to find , how long it has been since the number was drawn? This formula will count the skips. =IF(COLUMNS(AP19:AP19) =COUNTIF($Z$17:$Z$7668,$AJ19),SMALL(IF($Z$17:$Z$7668=$AJ19,ROW($Z$17:$Z$7668)-ROW($Z$17)+1),COLUMNS(AP19:AP19))-1, ) You will have to change the ranges. Here's an image.
Jun 27, 2009, 2:47 pm - CARBOB - Mathematics Forum

SirMetro's subtract from 39 method UpdateReply
Finally, I created a set of tables that allowed me to review just how well my so-called Systems did compared to the numbers Left-Over . It looks something like this Left-over NumbersLeftOverSystemSystem Numbers 2121 14 152703041013 2906 34 37 16260530 35 3823 381329101219242537 39 12300214202430 42 0117 251032 18313239 0425 343805132901 30 13 1032030610 294126 08 37 15270405 2131 17 010308 38111725 12
Apr 22, 2007, 3:05 pm - SirMetro - Lottery Systems Forum

Pick3 and Pick4 Hit Checker?Reply
Thanks folks... I got a crude visual worksheet working. I used Countif and conditional formatting to see what is going on with the digits.
Jun 7, 2006, 4:37 pm - LottoChica23 - Lottery Systems Forum

Promising system..just boughtReply
If you want to use excel to count how many times a special number appears in draws, use this formula : =COUNTIF(J1:J5; =3 ) This one checks if the column J1 to J5 has the number 3 in it and how many times 3's appears. If you have columns of whatever length with numbers you can use this formula to count how many times a specific ball has been drawn.
May 31, 2006, 10:38 am - MillionsWanted - Lottery Systems Forum

Statistical Analysis ProgramReply
If the data is already in spreadsheet format (I doubt this due to leading zeroes) the string funtion would be a starting point. If the data is in a text file, I'd convert it into a .csv file, import the data into a spreadsheet, and use the COUNTIF function 10 times for each position. gl j
Feb 18, 2006, 2:46 am - johnph77 - Lottery Systems Forum

Sequencial Groups PredictingReply
I've just started using it and had success. I had an earlier post where I said that I would detail the strategy more completely. I hope the following will anser you questions:How many times did each number occur the last 23 games(1-22), how many times for the 23 games before that(23-45), how many times for the 23 games before that(46-68), and finally how many times did each number occur for the 23 games before that (69-91). So you are measuring occurrances of each lottery number 4 times in equal
Dec 8, 2005, 8:43 pm - JKING - Lottery Systems Forum

Using excel to keep up with numbers
I have searched this site looking for answers to use excel in helping me keep up with numbers skiped, numbers by position, etc and have found info from hypersoniq's how to count skips with excel 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 c
Nov 18, 2004, 10:02 pm - lottaloot - Pick 3 Forum