{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["prob","Sheet2","Sheet3","Sheet4"],"not_rendered":{"charts":1,"macros":1,"external_links":1,"defined_names":17,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"prob","index":0,"n_rows":39,"n_cols":16,"rows_kept":39}
[null,null,"  The Hypergeometric Distribution"]
[]
[null,"           This DIGMath module lets you explore "]
[null,null,"           the hypergeometric distribution "]
[null,null,"             based on samples of size n "]
[null,null,"             drawn without replacement"]
[null,null,"              from a population of size N"]
[null,null,"     where K of the N represent success"]
[null,null,"and calculates hypergeometric probabilities"]
[]
[]
["How large is the population N (10 - 100)?"]
[{"$nulls":3},{"$f":"E13","v":47},47]
[]
["How many successes K out of N =",{"$nulls":3},{"$f":"D13","v":47},"?"]
[{"$nulls":3},{"$f":"IF(E16<=trials,E16,trials)","v":36},36]
[{"$nulls":9},"How many successes do you want: x = ?"]
["How large is the sample n?",{"$nulls":10},{"$f":"\"(Between \"&Min &\" and \" & Max &\")\"","v":"(Between 12 and 23)"}]
[{"$nulls":3},{"$f":"IF(E19<=trials,E19+1,trials)","v":23},22,{"$nulls":7},{"$f":"IF(O19<=n,O19,n)","v":20},14,20]
[]
[{"$nulls":10}," The probability of getting x =  ",null,null,{"$f":"x","v":20},{"$f":"IF(x=1,\"success\",\"successes\")","v":"successes"}]
[]
[{"$nulls":12},"out of n = ",{"$f":"n","v":23},"trials"]
[]
["Click each item below for suggestions and investigations",{"$nulls":8}," from a hypergeometric distribution with N =",{"$nulls":4},{"$f":"NN","v":47},"values,"]
[null,null,"   Item 1"]
[null,null,"   Item 2",{"$nulls":7},"of which",{"$f":"k","v":36},"are considered successes, "]
[null,null,"   Item 3"]
[{"$nulls":11},"is Probability =",{"$f":"pp","v":{"v":0.07478378300598648,"d":"0.0748"}}]
[]
[]
["To access/download all the DIGMath Apps for Statistics"]
["Click this link:",null,"DIGMath for Statistics and Probability"]
[]
["Created by:  Sheldon P. Gordon   &   Florence S. Gordon    © 2025"]
["                  Farmingdale State College      NYIT"]
["Development of this module was supported by the "]
["NSF's Division of Undergraduate Education  "]
["under grants DUE-0310123 and DUE-0442160."]

{"sheet":"Sheet2","index":1,"n_rows":161,"n_cols":14,"rows_kept":161}
[null,null,"x","PROB",null,"n",null,null,"Points",null,null,"Points for filling column"]
[null,null,1,{"$f":"IF(C2<=L,COMBIN(k,C2)*COMBIN(NN-k,n-C2)/COMBIN(NN,n),0)","v":{"$error":"#NUM!"}},null,0,null,null,0,0,null,{"$f":"x","v":{"v":20,"d":"20.00"}},0]
["Min =",{"$f":"IF(n+k-trials<0,0,n+k-trials)","v":12},2,{"$error":"#NUM!"},null,1,{"$f":"k/trials","v":0.7659574468085106},"= p",0,{"$f":"D2","v":{"$error":"#NUM!"}},null,{"$f":"L2","v":{"v":20,"d":"20.00"}},{"$f":"LOOKUP(x,C2:C102,D2:D102)","v":0.07478378300598648},"= pp"]
["Max =",{"$f":"IF(n<k,n,k)","v":23},3,{"$error":"#NUM!"},null,2,{"$f":"1-_xlfn.SINGLE(p)","v":0.23404255319148937},"= q",{"$f":"F3","v":1},{"$f":"J3","v":{"$error":"#NUM!"}},null,{"$f":"L3+0.05","v":20.05},0]
[null,null,4,{"$error":"#NUM!"},null,{"$f":"IF(F4<trials,F4+1,trials)","v":3},1,"= c0",{"$f":"I4","v":1},{"$f":"0","v":{"v":0,"d":"0.0000000"}},null,{"$f":"L4","v":20.05},{"$f":"pp","v":0.07478378300598648}]
["L =",{"$f":"IF(n<=NN, n,NN-n)","v":23},5,{"$error":"#NUM!"},null,4,null,null,{"$f":"I5","v":1},{"$f":"D3","v":{"$error":"#NUM!"}},null,{"$f":"L5+0.05","v":{"v":20.1,"d":"20.10"}},0]
[null,null,6,{"$error":"#NUM!"},null,5,null,null,{"$f":"I6+1","v":2},{"$f":"J6","v":{"$error":"#NUM!"}},null,{"$f":"L6","v":{"v":20.1,"d":"20.10"}},{"$f":"pp","v":0.07478378300598648}]
["p3=",null,7,{"$error":"#NUM!"},null,6,null,null,{"$f":"I7","v":2},{"v":0,"d":"0.0000000"},null,{"$f":"L7+0.05","v":{"v":20.150000000000002,"d":"20.15"}},0]
[null,null,8,{"$error":"#NUM!"},null,7,null,null,{"$f":"I8","v":2},{"$f":"D4","v":{"$error":"#NUM!"}},null,{"$f":"L8","v":{"v":20.150000000000002,"d":"20.15"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,9,{"$error":"#NUM!"},null,8,null,null,{"$f":"IF(I9<=trials,I9+1,trials)","v":3},{"$f":"J9","v":{"$error":"#NUM!"}},null,{"$f":"L9+0.05","v":{"v":20.200000000000003,"d":"20.20"}},0]
[null,null,10,{"$error":"#NUM!"},null,9,null,null,{"$f":"I10","v":3},{"v":0,"d":"0.0000000"},null,{"$f":"L10","v":{"v":20.200000000000003,"d":"20.20"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,11,{"$error":"#NUM!"},null,10,null,null,{"$f":"I11","v":3},{"$f":"D5","v":{"$error":"#NUM!"}},null,{"$f":"L11+0.05","v":{"v":20.250000000000004,"d":"20.25"}},0]
[null,null,12,7.7629191446306858E-5,null,11,null,null,{"$f":"IF(I12<=trials,I12+1,trials)","v":4},{"$f":"J12","v":{"$error":"#NUM!"}},null,{"$f":"L12","v":{"v":20.250000000000004,"d":"20.25"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,13,1.5764697339865409E-3,null,12,null,null,{"$f":"I13","v":4},{"v":0,"d":"0.0000000"},null,{"$f":"L13+0.05","v":{"v":20.300000000000004,"d":"20.30"}},0]
[null,null,14,0.012949572814889435,null,13,null,null,{"$f":"I14","v":4},{"$f":"D6","v":{"$error":"#NUM!"}},null,{"$f":"L14","v":{"v":20.300000000000004,"d":"20.30"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,15,0.05697812038551352,null,14,null,null,{"$f":"IF(I15<=trials,I15+1,trials)","v":5},{"$f":"J15","v":{"$error":"#NUM!"}},null,{"$f":"L15+0.05","v":{"v":20.350000000000005,"d":"20.35"}},0]
[null,null,16,0.14956756601197296,null,15,null,null,{"$f":"I16","v":5},{"v":0,"d":"0.0000000"},null,{"$f":"L16","v":{"v":20.350000000000005,"d":"20.35"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,17,0.24634657931383766,null,16,null,null,{"$f":"I17","v":5},{"$f":"D7","v":{"$error":"#NUM!"}},null,{"$f":"L17+0.05","v":{"v":20.400000000000006,"d":"20.40"}},0]
[null,null,18,0.26003250038682885,null,17,null,null,{"$f":"IF(I18<=trials,I18+1,trials)","v":6},{"$f":"J18","v":{"$error":"#NUM!"}},null,{"$f":"L18","v":{"v":20.400000000000006,"d":"20.40"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,19,0.17596184236702692,null,18,null,null,{"$f":"I19","v":6},{"v":0,"d":"0.0000000"},null,{"$f":"L19+0.05","v":{"v":20.450000000000006,"d":"20.45"}},0]
[null,null,20,0.07478378300598648,null,19,null,null,{"$f":"I20","v":6},{"$f":"D8","v":{"$error":"#NUM!"}},null,{"$f":"L20","v":{"v":20.450000000000006,"d":"20.45"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,21,0.018992706795171174,null,20,null,null,{"$f":"IF(I21<=trials,I21+1,trials)","v":7},{"$f":"J21","v":{"$error":"#NUM!"}},null,{"$f":"L21+0.05","v":{"v":20.500000000000007,"d":"20.50"}},0]
[null,null,22,2.589914562977887E-3,null,21,null,null,{"$f":"I22","v":7},{"v":0,"d":"0.0000000"},null,{"$f":"L22","v":{"v":20.500000000000007,"d":"20.50"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,23,1.4331543036241279E-4,null,22,null,null,{"$f":"I23","v":7},{"$f":"D9","v":{"$error":"#NUM!"}},null,{"$f":"L23+0.05","v":{"v":20.550000000000008,"d":"20.55"}},0]
[null,null,24,0,null,23,null,null,{"$f":"IF(I24<=trials,I24+1,trials)","v":8},{"$f":"J24","v":{"$error":"#NUM!"}},null,{"$f":"L24","v":{"v":20.550000000000008,"d":"20.55"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,25,0,null,24,null,null,{"$f":"I25","v":8},{"v":0,"d":"0.0000000"},null,{"$f":"L25+0.05","v":{"v":20.60000000000001,"d":"20.60"}},0]
[null,null,26,0,null,25,null,null,{"$f":"I26","v":8},{"$f":"D10","v":{"$error":"#NUM!"}},null,{"$f":"L26","v":{"v":20.60000000000001,"d":"20.60"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,27,0,null,26,null,null,{"$f":"IF(I27<=trials,I27+1,trials)","v":9},{"$f":"J27","v":{"$error":"#NUM!"}},null,{"$f":"L27+0.05","v":{"v":20.65000000000001,"d":"20.65"}},0]
[null,null,28,0,null,27,null,null,{"$f":"I28","v":9},{"v":0,"d":"0.0000000"},null,{"$f":"L28","v":{"v":20.65000000000001,"d":"20.65"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,29,0,null,28,null,null,{"$f":"I29","v":9},{"$f":"D11","v":{"$error":"#NUM!"}},null,{"$f":"L29+0.05","v":{"v":20.70000000000001,"d":"20.70"}},0]
[null,null,30,0,null,29,null,null,{"$f":"IF(I30<=trials,I30+1,trials)","v":10},{"$f":"J30","v":{"$error":"#NUM!"}},null,{"$f":"L30","v":{"v":20.70000000000001,"d":"20.70"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,31,0,null,30,null,null,{"$f":"I31","v":10},{"v":0,"d":"0.0000000"},null,{"$f":"L31+0.05","v":{"v":20.75000000000001,"d":"20.75"}},0]
[null,null,32,0,null,31,null,null,{"$f":"I32","v":10},{"$f":"D12","v":{"$error":"#NUM!"}},null,{"$f":"L32","v":{"v":20.75000000000001,"d":"20.75"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,33,{"$f":"IF(C34<=L,COMBIN(k,C34)*COMBIN(NN-k,n-C34)/COMBIN(NN,n),0)","v":0},null,32,null,null,{"$f":"IF(I33<=trials,I33+1,trials)","v":11},{"$f":"J33","v":{"$error":"#NUM!"}},null,{"$f":"L33+0.05","v":{"v":20.80000000000001,"d":"20.80"}},0]
[null,null,34,0,null,33,null,null,{"$f":"I34","v":11},{"v":0,"d":"0.0000000"},null,{"$f":"L34","v":{"v":20.80000000000001,"d":"20.80"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,35,0,null,34,null,null,{"$f":"I35","v":11},{"$f":"D13","v":{"v":7.7629191446306858E-5,"d":"0.0000776"}},null,{"$f":"L35+0.05","v":{"v":20.850000000000012,"d":"20.85"}},0]
[null,null,36,0,null,{"$f":"IF(F36<trials,F36+1,trials)","v":35},null,null,{"$f":"IF(I36<=trials,I36+1,trials)","v":12},{"$f":"J36","v":{"v":7.7629191446306858E-5,"d":"0.0000776"}},null,{"$f":"L36","v":{"v":20.850000000000012,"d":"20.85"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,37,0,null,36,null,null,{"$f":"I37","v":12},{"v":0,"d":"0.0000000"},null,{"$f":"L37+0.05","v":{"v":20.900000000000013,"d":"20.90"}},0]
[null,null,38,0,null,37,null,null,{"$f":"I38","v":12},{"$f":"D14","v":{"v":1.5764697339865409E-3,"d":"0.0015765"}},null,{"$f":"L38","v":{"v":20.900000000000013,"d":"20.90"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,39,0,null,38,null,null,{"$f":"IF(I39<=trials,I39+1,trials)","v":13},{"$f":"J39","v":{"v":1.5764697339865409E-3,"d":"0.0015765"}},null,{"$f":"L39+0.05","v":{"v":20.950000000000014,"d":"20.95"}},0]
[null,null,40,0,null,39,null,null,{"$f":"I40","v":13},{"v":0,"d":"0.0000000"},null,{"$f":"L40","v":{"v":20.950000000000014,"d":"20.95"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,41,0,null,40,null,null,{"$f":"I41","v":13},{"$f":"D15","v":{"v":0.012949572814889435,"d":"0.0129496"}},null,{"$f":"L41+0.05","v":{"v":21.000000000000014,"d":"21.00"}},0]
[null,null,42,0,null,41,null,null,{"$f":"IF(I42<=trials,I42+1,trials)","v":14},{"$f":"J42","v":{"v":0.012949572814889435,"d":"0.0129496"}},null,{"$f":"L42","v":{"v":21.000000000000014,"d":"21.00"}},{"$f":"pp","v":0.07478378300598648}]
[null,null,43,0,null,42,null,null,{"$f":"I43","v":14},{"v":0,"d":"0.0000000"}]
[null,null,44,0,null,43,null,null,{"$f":"I44","v":14},{"$f":"D16","v":{"v":0.05697812038551352,"d":"0.0569781"}}]
[null,null,45,0,null,44,null,null,{"$f":"IF(I45<=trials,I45+1,trials)","v":15},{"$f":"J45","v":{"v":0.05697812038551352,"d":"0.0569781"}}]
[null,null,46,0,null,45,null,null,{"$f":"I46","v":15},{"v":0,"d":"0.0000000"}]
[null,null,47,0,null,46,null,null,{"$f":"I47","v":15},{"$f":"D17","v":{"v":0.14956756601197296,"d":"0.1495676"}}]
[null,null,48,0,null,47,null,null,{"$f":"IF(I48<=trials,I48+1,trials)","v":16},{"$f":"J48","v":{"v":0.14956756601197296,"d":"0.1495676"}}]
[null,null,49,0,null,47,null,null,{"$f":"I49","v":16},{"v":0,"d":"0.0000000"}]
[null,null,49,0,null,47,null,null,{"$f":"I50","v":16},{"$f":"D18","v":{"v":0.24634657931383766,"d":"0.2463466"}}]
[{"$nulls":3},{"$f":"IF(F52<=Max,$P$3*(trials-L+F52)/F52,0)","v":0},null,47,null,null,{"$f":"IF(I51<=trials,I51+1,trials)","v":17},{"$f":"J51","v":{"v":0.24634657931383766,"d":"0.2463466"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I52","v":17},{"v":0,"d":"0.0000000"}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I53","v":17},{"$f":"D19","v":{"v":0.26003250038682885,"d":"0.2600325"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I54<=trials,I54+1,trials)","v":18},{"$f":"J54","v":{"v":0.26003250038682885,"d":"0.2600325"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I55","v":18},{"v":0,"d":"0.0000000"}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I56","v":18},{"$f":"D20","v":{"v":0.17596184236702692,"d":"0.1759618"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I57<=trials,I57+1,trials)","v":19},{"$f":"J57","v":{"v":0.17596184236702692,"d":"0.1759618"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I58","v":19},{"v":0,"d":"0.0000000"}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I59","v":19},{"$f":"D21","v":{"v":0.07478378300598648,"d":"0.0747838"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I60<=trials,I60+1,trials)","v":20},{"$f":"J60","v":{"v":0.07478378300598648,"d":"0.0747838"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I61","v":20},{"v":0,"d":"0.0000000"}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I62","v":20},{"$f":"D22","v":{"v":0.018992706795171174,"d":"0.0189927"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I63<=trials,I63+1,trials)","v":21},{"$f":"J63","v":{"v":0.018992706795171174,"d":"0.0189927"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I64","v":21},{"v":0,"d":"0.0000000"}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I65","v":21},{"$f":"D23","v":{"v":2.589914562977887E-3,"d":"0.0025899"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I66<=trials,I66+1,trials)","v":22},{"$f":"J66","v":{"v":2.589914562977887E-3,"d":"0.0025899"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I67","v":22},{"v":0,"d":"0.0000000"}]
[{"$nulls":3},0,null,{"$f":"IF(F68<trials,F68+1,trials)","v":47},null,null,{"$f":"I68","v":22},{"$f":"D24","v":{"v":1.4331543036241279E-4,"d":"0.0001433"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I69<=trials,I69+1,trials)","v":23},{"$f":"J69","v":{"v":1.4331543036241279E-4,"d":"0.0001433"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I70","v":23},{"v":0,"d":"0.0000000"}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I71","v":23},{"$f":"D25","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I72<=trials,I72+1,trials)","v":24},{"$f":"J72","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I73","v":24},{"v":0,"d":"0.0000000"}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I74","v":24},{"$f":"D26","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I75<=trials,I75+1,trials)","v":25},{"$f":"J75","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I76","v":25},{"v":0,"d":"0.0000000"}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I77","v":25},{"$f":"D27","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I78<=trials,I78+1,trials)","v":26},{"$f":"J78","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I79","v":26},{"v":0,"d":"0.0000000"}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I80","v":26},{"$f":"D28","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I81<=trials,I81+1,trials)","v":27},{"$f":"J81","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I82","v":27},{"v":0,"d":"0.0000000"}]
[{"$nulls":3},{"$f":"IF(F84<=Max,$P$3*(trials-L+F84)/F84,0)","v":0},null,47,null,null,{"$f":"I83","v":27},{"$f":"D29","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I84<=trials,I84+1,trials)","v":28},{"$f":"J84","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I85","v":28},{"v":0,"d":"0.0000000"}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I86","v":28},{"$f":"D30","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I87<=trials,I87+1,trials)","v":29},{"$f":"J87","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I88","v":29},{"$f":"D31","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I89","v":29},{"$f":"D31","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I90<=trials,I90+1,trials)","v":30},{"$f":"J90","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I91","v":30},{"$f":"D32","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I92","v":30},{"$f":"D32","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I93<=trials,I93+1,trials)","v":31},{"$f":"J93","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I94","v":31},{"$f":"D33","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I95","v":31},{"$f":"D33","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I96<=trials,I96+1,trials)","v":32},{"$f":"J96","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I97","v":32},{"$f":"D34","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I98","v":32},{"$f":"D34","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I99<=trials,I99+1,trials)","v":33},{"$f":"J99","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I100","v":33},{"$f":"D35","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I101","v":33},{"$f":"D35","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I102<=trials,I102+1,trials)","v":34},{"$f":"J102","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I103","v":34},{"$f":"D36","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I104","v":34},{"$f":"D36","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I105<=trials,I105+1,trials)","v":35},{"$f":"J105","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I106","v":35},{"$f":"D37","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I107","v":35},{"$f":"D37","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I108<=trials,I108+1,trials)","v":36},{"$f":"J108","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I109","v":36},{"$f":"D38","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I110","v":36},{"$f":"D38","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I111<=trials,I111+1,trials)","v":37},{"$f":"J111","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I112","v":37},{"$f":"D39","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I113","v":37},{"$f":"D39","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I114<=trials,I114+1,trials)","v":38},{"$f":"J114","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},{"$f":"IF(F116<=Max,$P$3*(trials-L+F116)/F116,0)","v":0},null,47,null,null,{"$f":"I115","v":38},{"$f":"D40","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I116","v":38},{"$f":"D40","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I117<=trials,I117+1,trials)","v":39},{"$f":"J117","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I118","v":39},{"$f":"D41","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I119","v":39},{"$f":"D41","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I120<=trials,I120+1,trials)","v":40},{"$f":"J120","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I121","v":40},{"$f":"D42","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I122","v":40},{"$f":"D42","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I123<=trials,I123+1,trials)","v":41},{"$f":"J123","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I124","v":41},{"$f":"D43","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I125","v":41},{"$f":"D43","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I126<=trials,I126+1,trials)","v":42},{"$f":"J126","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I127","v":42},{"$f":"D44","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I128","v":42},{"$f":"D44","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I129<=trials,I129+1,trials)","v":43},{"$f":"J129","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I130","v":43},{"$f":"D45","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I131","v":43},{"$f":"D45","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,{"$f":"IF(F132<trials,F132+1,trials)","v":47},null,null,{"$f":"IF(I132<=trials,I132+1,trials)","v":44},{"$f":"J132","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I133","v":44},{"$f":"D46","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I134","v":44},{"$f":"D46","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I135<=trials,I135+1,trials)","v":45},{"$f":"J135","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I136","v":45},{"$f":"D47","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I137","v":45},{"$f":"D47","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I138<=trials,I138+1,trials)","v":46},{"$f":"J138","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I139","v":46},{"$f":"D48","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I140","v":46},{"$f":"D48","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I141<=trials,I141+1,trials)","v":47},{"$f":"J141","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I142","v":47},{"$f":"D49","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I143","v":47},{"$f":"D49","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I144<=trials,I144+1,trials)","v":48},{"$f":"J144","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I145","v":48},{"$f":"D50","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I146","v":48},{"$f":"D50","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},{"$f":"IF(F148<=Max,$P$3*(trials-L+F148)/F148,0)","v":0},null,47,null,null,{"$f":"IF(I147<=trials,I147+1,trials)","v":47},{"$f":"J147","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I148","v":47},{"$f":"D51","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I149","v":47},{"$f":"D51","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I150<=trials,I150+1,trials)","v":48},{"$f":"J150","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I151","v":48},{"v":0,"d":"0.0000000"}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I152","v":48},{"$f":"D52","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I153<=trials,I153+1,trials)","v":47},{"$f":"J153","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I154","v":47},{"v":0,"d":"0.0000000"}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I155","v":47},{"$f":"D53","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I156<=trials,I156+1,trials)","v":48},{"$f":"J156","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I157","v":48},{"v":0,"d":"0.0000000"}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I158","v":48},{"$f":"D54","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"IF(I159<=trials,I159+1,trials)","v":47},{"$f":"J159","v":{"v":0,"d":"0.0000000"}}]
[{"$nulls":3},0,null,47,null,null,{"$f":"I160","v":47},{"v":0,"d":"0.0000000"}]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Sheet4","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}