Search

Mastermind filteringReply
You can find the F switches -1;+0;+1 in the skips. 6,0,1,3,3,12,0,8,7,28,8,14,1,1,6,1,10,9,12,3,19,2,0,5,2,10,1,0 (out)0 Between two skips there is one score. A function can do this. The other is using Excel by lines, do the sums of 0 xor 1 for 20 lines, by number. You work on a standard countif() there.
Dec 11, 2021, 10:02 am - Speler - Lottery Discussion Forum

What about Quickpick system based on Hot/Cold numbers of any number of previous drawsReply
Warm and cool are the wheels within hot and cold. Here's a scientific theory based on my observation: What is hot becomes cold and what is cold becomes hot. I have done many different back periods of =countif() on daily 3/4 draws that go back thousands of draws. I conditional format red to blue for a quick view of the 0 to nth occurrences over time. I have never found a non-RNG game where something becomes cold and stays cold forever. I have never found a hot that stays hot forever. The perio
Apr 9, 2019, 2:57 pm - GoogilyMoogily - Lottery Systems Forum

Excel help: a formula or macro to count digit followersReply
Here is what I would do. Say your data is set up with the Game or date in column A Column B is the first number drawn and the one we will check. Columns C and D are the other 2 drawn numbers. In column E in Row 2 enter this formula =B2 B3. that will give the new number combined with the previous number. Now all you have to do is count the Sequences that match the pattern you want. So to find how many times 0 comes after 4 write this formula =countif(E1:E200, 04 ). This setup would be for 200
Mar 17, 2016, 6:04 pm - AllenB - Lottery Systems Forum

MMC Game ShowReply
The correct value at infinite tickets is 3.67857 entries per ticket. My number was off, because I had railroads at 15 instead of 16. I don't actually run a simulation for tickets at infinite tickets, because with any random distribution, if you truly do an infinite number of the events, you will have a perfectly even distribution. This seems counter intuitive, but by the definition of infinity, 1/28th of infinity, is still infinity, and one infinity is not bigger than another infinity. I a
Nov 2, 2014, 10:25 am - grengrad - Lottery Discussion Forum

anyone know the practical utility of the binomial distribution or other distribution in the lottery?Reply
Thanks, Carbob! Not quite sure what you mean by singles ? This isn't a very interesting distribution since they hit all the time, only skipping one or two draws once in a while. However, I will include a handy do it yourself kit for figuring out where in the distribution a value lies. First, set up a table in excel to record your statistic (repeats, doubles, etc., what ever you want). You want to set up an IF statement which assigns a value of 0 to a hit and adds one to every non-hit va
Jul 22, 2014, 9:03 am - Tialuvslotto - Lottery Systems Forum

Need an excel formulaReply
You posted the wrong function. You needed =SUMPRODUCT(COUNTIF($A$2:$A$10,$B2:$B10)). Use comma or semicolon according to your OS. Sumproduct works, but there is no product, just a sum. Both functions aren't usable for pick 3/4. You are supposed to pick the easy one. I stopped using nested functions for custom functions.
Jan 12, 2014, 9:06 pm - SergeM - Mathematics Forum

Excel help (dates and draws)Reply
If your good at adjusting formulas, I think this will do what you want with no macro If I get a chance later , I will play with it Its an array formula so need to control/shift/enter =IF(ROW($A2)-ROW($A$1) COUNTIF($A$3:$A$261,$I$3), ,INDEX($D$1:$D$261,SMALL(IF($A$3:$A$261=$I$3,ROW($D$3:$D$261)),ROW($A2)-ROW($A$1)))) Carlig
Oct 27, 2012, 5:09 pm - CarliG - Lottery Systems Forum

Excel Help NeededReply
Cell A11 =RANK($A9,$A$9:$E$9,1) copy/paste into Cell B11 thru E11 Cell A12 =RANK($A9,$A$9:$E$9,1) Cell B12 =RANK($B9,$A$9:$E$9,1)+COUNTIF($A$11:A$11,RANK($B$9,$A$9:$E$9,1) copy/paste into Cell C12 thru E12
Jul 26, 2010, 3:24 pm - Raven62 - Mathematics Forum

Excel questionReply
Thank you!..yes slowly but surely..I just have a hell of time remembering what the colons..semicolons commas etc represent..as soon as I have to backtrack and search online for tidbits,I lose my train of thought.. I forgot to mention I'm using 2003..when i input your equation,it highlighted the desired area to count and I hit ctrl/shift/enter after i entered it but it still only does column A...however ,it initially responded(meaning a,b,and c were being counted) when I added =COUNTIF(A:C,E1:
Jun 1, 2010, 8:36 pm - JonnyBgood07 - Mathematics Forum

Program or SpreadsheetReply
Thanks for sharing! Are you using a Matrix for the results? Each axis would have 0 9 Then using =match and =countif in each cell of the matrix would provide the count
Feb 14, 2010, 9:33 am - Raven62 - Lottery Discussion Forum