{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Lottery"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Lottery","index":0,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Numbers chosen"]
["Enter your numbers here: ",1,4,27,33,38,49]
[]
["winner?",{"$f":"OR(B2=$B$10,B2=$C$10,B2=$D$10,B2=$E$10,B2=$F$10,B2=$G$10)","v":false},false,false,false,false,true]
["winner or bonus no?",{"$f":"OR(B2=$B$10,B2=$C$10,B2=$D$10,B2=$E$10,B2=$F$10,B2=$G$10,B2=$H$10)","v":false},false,false,false,false,true]
["Matching Numbers:",{"$f":"$B$4+$C$4+$D$4+$E$4+$F$4+$G$4","v":1},"Matches"]
[null,{"$f":"B5+C5+D5+E5+F5+G5","v":1}]
["Duplicate/invalid entry?",{"$f":"OR(B2=C2,C2=D2,D2=E2,E2=F2,F2=G2,B2=G2)","v":false}]
["This Draw",null,null,null,null,null,null,"bonus"]
["(Random)",{"$f":"INT(RAND()*49)+1","v":28},30,26,10,49,47,11]
[]
["duplicate no?",{"$f":"OR(B10=$C$10,B10=$D$10,B10=$E$10,B10=$F$10,B10=$G$10,B10=H10)","v":false},{"$f":"OR(C10=$B$10,C10=$D$10,C10=$E$10,C10=$F$10,C10=$G$10,C10=H10)","v":false},{"$f":"OR(D10=$C$10,D10=$B$10,D10=$E$10,D10=$F$10,D10=$G$10,D10=H10)","v":false},{"$f":"OR(E10=$C$10,E10=$D$10,E10=$B$10,E10=$F$10,E10=$G$10,E10=H10)","v":false},{"$f":"OR(F10=$C$10,F10=$D$10,F10=$E$10,F10=$B$10,F10=$G$10,F10=H10)","v":false},{"$f":"OR(G10=$C$10,G10=$D$10,G10=$E$10,G10=$F$10,G10=$B$10,G10=H10)","v":false},{"$f":"OR(H10=$C$10,H10=$D$10,H10=$E$10,H10=$F$10,H10=$B$10,H10=G10)","v":false}]
[]
[null,{"$f":"B12+C12+D12+E12+F12+G12","v":0},"duplicates"]
[]
["Winnings"]
["Prizes",10,62,1500,100000,2000000]
[null,"3 no's","4 no's","5 no's","5+bonus","6 no's",null,"Betting Costs"]
[null,{"$f":"IF(B8=FALSE,(IF(B6=3,1,-1)),-1)","v":-1},{"$f":"IF(B8=FALSE,IF(B6=4,1,-1),-1)","v":-1},{"$f":"IF(B8=FALSE,IF(B6=5,1,-1),-1)","v":-1},{"$f":"IF(B8=FALSE,IF(B6+H12=6,1,-1),-1)","v":-1},{"$f":"IF(B8=FALSE,IF(B6=6,1,-1),-1)","v":-1},null,0]
[]
[null,null,null,null,null,null,null,3,"no's"]
[]
[]
["Lottery simulator - the winning probabilities are the same as most national lotteries."]
["Each number you pick must be between 1 and 49"]
["To gamble for the maximum jackpot - change H21 to match 6 numbers. This can be very slow so try it with 4 or 5 first."]
["CTRL-BREAK will cancel the macro."]
["If the randomly chosen draw numbers contain any duplicates, the numbers will recalculate until they are all different. "]
[]
["If your betting costs are more than the prize - then you’ve still lost!"]
[]
["This spreadsheet may be freely distributed - in the hope of educating a few people about the futility of gambling."]
[]
["Simon Sheppard"]
["(c) 1997-2024 SS64.com"]
[]
[]
[]
[]
[]
[]
["This spreadsheet has protection turned on but, if you want to look at or change the code, the password is blank."]