{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sheet1","index":0,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[{"$nulls":4},"HIT BY \"N\" TRY"]
["P *",0.35,null,null,"DC *",0.99]
["Q ",{"$f":"1-B2","v":0.65},null,null,"N",{"$f":"LOG(1-F2)/(LOG(F5))","v":10.690234022650362}]
[{"$nulls":4},"P",{"$f":"B2","v":0.35}]
["# V *",null,null,null,"Q",{"$f":"1-F4","v":0.65}]
[5,{"$f":"$B$2*($B$3^(A6-1))","v":6.247718750000001E-2},{"$f":"1-($B$3^$A6)","v":0.8839709375}]
[null,null,null,"PROB OF\" X\" WINS IN \"N\" TRIES:"]
["N","ON \"N\"","BY \"N\"","X",3,"WINS *"]
[1,{"$f":"$B$2*($B$3^(A9-1))","v":0.35},{"$f":"1-($B$3^$A9)","v":0.35},"N",5,"TRIES *"]
[{"$f":"A9+1","v":2},{"$f":"$B$2*($B$3^(A10-1))","v":0.22749999999999998},{"$f":"1-($B$3^$A10)","v":0.5774999999999999}]
[{"$f":"A10+1","v":3},{"$f":"$B$2*($B$3^(A11-1))","v":0.14787500000000001},{"$f":"1-($B$3^$A11)","v":0.72537499999999988},"PROB",{"$f":"(B2^E8)*(B3^(E9-E8))","v":1.8114687499999997E-2},"ANY 1 TRY"]
[4,9.6118750000000017E-2,0.82149374999999991]
[5,6.247718750000001E-2,0.8839709375,null,null,"# OF OUTCOMES WHERE"]
[6,4.061017187500001E-2,0.92458110937499993,null,{"$f":"COMBIN(E9,E8)","v":10},"WE HAVE",{"$f":"E8","v":3},"WINS"]
[7,2.6396611718750008E-2,0.95097772109375001,null,null,"IN",{"$f":"E9","v":5},"TRIES"]
[8,1.7157797617187505E-2,0.9681355187109375]
[9,1.1152568451171877E-2,0.97928808716210936,"PROB",{"$f":"E11*E14","v":0.18114687499999998},"OF X WINS IN N TRIES"]
[10,7.2491694932617203E-3,0.98653725665537106]
[11,4.711960170620119E-3,0.99124921682599121,null,null,"N = 10"]
[12,3.0627741109030774E-3,0.99431199093689426,null,"X","EXACTLY","< ="]
[13,1.9908031720870007E-3,0.99630279410898126,null,0,{"$f":"BINOMDIST($E21,$E$9,$B$2,FALSE)","v":0.11602906250000003},{"$f":"BINOMDIST($E21,$E$9,$B$2,TRUE)","v":0.11602906250000003}]
[14,1.2940220618565504E-3,0.99759681617083784,null,1,{"$f":"BINOMDIST(E22,E$31,B$2,FALSE)","v":7.2491694932617201E-2},{"$f":"BINOMDIST($E22,$E$9,$B$2,TRUE)","v":0.42841499999999999}]
[15,8.4111434020675785E-4,0.99843793051104457,null,{"$f":"E22+1","v":2},{"$f":"BINOMDIST(E23,E$31,B$2,FALSE)","v":0.17565295310595705},{"$f":"BINOMDIST($E23,$E$9,$B$2,TRUE)","v":0.76483062499999988}]
[16,5.4672432113439258E-4,0.99898465483217902,null,{"$f":"E23+1","v":3},{"$f":"BINOMDIST(E24,E$31,B$2,FALSE)","v":0.25221962497265621},0.9459774999999998]
[17,3.5537080873735517E-4,0.99934002564091629,null,4,0.23766849276269511,0.99474781249999977]
[18,2.3099102567928086E-4,0.99957101666659565,null,5,0.15357041070820304,0.99999999999999978]
[19,1.5014416669153257E-4,0.9997211608332871,null,6,6.8909799676757755E-2,{"$error":"#NUM!"}]
[20,9.7593708349496191E-5,0.9998187545416366,null,7,2.1203015285156227E-2,{"$error":"#NUM!"}]
[21,6.3435910427172513E-5,0.99988219045206383,null,8,4.2813780864257769E-3,{"$error":"#NUM!"}]
[22,4.1233341777662137E-5,0.99992342379384147,null,9,5.1230165136718637E-4,{"$error":"#NUM!"}]
[23,2.680167215548039E-5,0.99995022546599699,null,10,2.7585473535156207E-5,{"$error":"#NUM!"}]
[24,1.7421086901062258E-5,0.99996764655289805]
[25,1.1323706485690465E-5,0.99997897025938376]
[26,7.360409215698803E-6,0.99998633066859943]
[27,4.7842659902042219E-6,0.99999111493458959]
[28,3.1097728936327451E-6,0.99999422470748323]
[29,2.0213523808612842E-6,0.99999624605986415]
[30,1.3138790475598349E-6,0.99999755993891171]
[31,8.5402138091389259E-7,0.99999841396029254]
[]
["ASTERIX = INPUT ITEM"]
["\"DC\" = DEGREE OF CONFIDENCE"]
["\"P\" = PROBABILITY OF A HIT"]
["\"Q\" = PROBABILITY OF NO HIT"]
["\"N\" = PLAY WHEN HIT COMES"]
["\"X\" = NUMBER OF WINS",{"$nulls":5},"BERNOULLI.XLS"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}