{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["About","Technical issues","Introduction","2-class enrichment","2-class counts","3-class counts","3-class mixed","2-class enrich sensspec","TableSensSpec"],"not_rendered":{"charts":23,"images":5,"macros":1,"external_links":0,"defined_names":173,"comments":6,"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":"About","index":0,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Microbiological sampling plans: a tool to explore ICMSF recommendations"]
["Version 2.10:  Copyright 1998 David Legan & Mark Vandeven 2009 Marcel Zwietering & Peter Sestoft"]
[]
[null,null,null,null,"Disclaimer"]
["This spreadsheet calculates probabilities ",null,null,null,"The authors have taken every care to ensure that the output from this"]
["of acceptance for materials with different ",null,null,null,"workbook is accurate.  In making this tool available to promote discussion"]
["microbial loads and population standard ",null,null,null,"and understanding of the power and limitations of attributes sampling plans"]
["deviations.  The microbes are assumed ",null,null,null,"neither the authors nor Nabisco Inc  / ICMSF accept any liability for any "]
["to be lognormally distributed.",null,null,null,"consequences, direct or indirect resulting from a decision by the user to take,"]
[null,null,null,null,"or not to take, any action based on an output from this workbook. "]
[]
["Version 1.01",null,null,null,"Version 2.01: Addition of enrichment calculations",null,null,null,null,null,"Version 2.02: Simpliciation and reorganisation"]
["Mark Vandeven and David Legan",null,null,null,"Marcel Zwietering",null,null,null,null,null,"This version simplified and reorganized by Peter Sestoft (sestoft@itu.dk) after discussions"]
["Nabisco Research",null,null,null,"Wageningen University",null,null,null,null,null,"with Marcel Zwietering (marcel.zwietering@wur.nl)"]
["R M Schaeberle Technology Center",null,null,null,"Laboratory of Food Microbiology"]
["200 DeForest Avenue",null,null,null,"PO Box 17",null,null,null,null,null,"Version 2.03-2.05: Finilisation for posting"]
["East Hanover, NJ 07936-1944, USA",null,null,null,"6700AA Wageningen",null,null,null,null,null,"The file is further improved and updated."]
["email: VandevenM@Nabisco.com, or",null,null,null,"The Netherlands"]
["LeganD@Nabisco.com",null,null,null,"email: Marcel.Zwietering@WUR.nl",null,null,null,null,null,"Version 2.07: OC based on arithmetic mean"]
[null,null,null,null,null,null,null,null,null,null,"Version 2.08: Sensitivity and specificity added"]
["Background reading",null,null,null,null,null,null,null,null,null,"Version 2.09: 3-class mixed added"]
["ICMSF book 2",null,null,null,null,null,null,null,null,null,"Version 2.10: 3-class mixed corrected error"]
["Calculations for 2-class spreadsheet were checked against ICMSF book 2 Tables 2 and 3 and are in complete agreement."]
["Calculations for 3-class spreadsheet were checked against ICMSF book 2 Table 4 and are in complete agreement."]
["Relating microbiological criteria to food safety objectives and performance objectives"]
["M. van Schothorst, M.H. Zwietering, T. Ross, R.L. Buchanan, M.B. Cole, International Commission on Microbiological Specifications for Foods (ICMSF)"]
["Food Control 20: 967-979 (2009) "]
["Microbial testing in food safety: effect of specificity and sensitivity on sampling plans — how does the OC curve move"]
["M.H. Zwietering, H.M.W. den Besten. "]
["Current Opinion Food Science 12, 42–51 (2016)"]
[]
["Acknowledgment"]
["The curves showing the distribution of organisms in foods for entered mean counts and sigma values"]
["were inspired by unpublished work circulated to ICMSF members by Suzanne Dahms "]
["Development of this tool was inspired by Martin Cole"]
[]
[]
[]
[]
["update 2009-05-20"]
["update 2009-10-7: reduced further in calculations, removed empty modules, updated MZ"]
["update 2009-10-12: returned to goalseek, no need for solver and analytic toolpack"]
["update 2009-10-14: limited c maximally at 1e10 cfu/g in poissonlognormal"]
["update 2009-10-15: limited sigma >0.05"]
["update 2009-10-27: protected help file in Introduction"]
["update 2010-10-19: added log arithmetic means"]
["update 2013-11-25: version 07: added boxes with performance, changed graph to arithmetic mean"]
["update 2014-10-23: version 08: sensitivty and selectivity added and boxes placed in input"]
["update 2015-11-17: version 08: sensspec updated by removing alternative plan"]
["update 2015-11-23: version 08: made boxes conditional for only being represented if fitted, manual updated with log mean."]
["update 2016-09-11: version 08: added specificity and sensitivity tables, FSO added"]
["update 2018-12-15: version 09: added 3-class mixed (m is qualitative M is quantitative)"]
["update 2019-4-19: version 09: % for P reject"]
["update 2019-11-15: version 09: text in 3-class adapted : from >m to c samples between m-M"]
["update 2020-7-24: version 10: eorror in calculation corrected ",null,null,null,null,null,"\"NORMSDIST((BigM-C56)/sigma)-E56 for NORMSDIST((BigM-D56)/sigma)-NORMSDIST((m-D56)/sigma)"]
["update 2020-9-15: version 10: minor formatting things and 2-class with dash"]
["update 2020-9-18: version 10: minor editig things in word files included in tab \"introduction\" and m value in alternative plan made yellow box. Brackets added in P(accept)"]

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

{"sheet":"Introduction","index":2,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["This file can determine the performance of sampling plans for five cases:"]
[]
["● 2-class plans for enrichments (presence/absence, detection of the organism with no count results)",null,null,null,null,null,null,null,null,null,"see tab 2-class enrichment"]
["● 2-class plans for quantitative determination (like concentration<100 cfu/g)",null,null,null,null,null,null,null,null,null,"see tab 2-class counts"]
["● 3-classplans for quantitative determination (where concentration is compared to both m and M)",null,null,null,null,null,null,null,null,null,"see tab 3-class counts"]
["● 3-class mixed plans where m is qualitative and M is a concentration",null,null,null,null,null,null,null,null,null,"see tab 3-class mixed"]
["● 2-class plans for enrichments including effects sensitivity and specificity",null,null,null,null,null,null,null,null,null,"see tab 2-class enrich sensspec"]
["● Effects of sensitivity and specificity (fixed values) are also presented in a tabular form",null,null,null,null,null,null,null,null,null,"see tab TableSensSpec"]
[]
["Description of the used variables"]
["Data entry boxes are highlighted in yellow:",null,null,null,null,"All other cells are protected."]
[]
["mean","mean of the (assumed) log normal distribution describing the occurrence of bacterial contaminants; unit is log cfu per gram"]
["sigma","standard deviation of the same (assumed) log normal distribution"]
["m ","acceptable level of microbiological contamination, defined as an allowable concentration, or for enrichement no contamination in a sample of a certain weight, hence equals minus log(weight)"]
["n","number of samples tested"]
["c","number of samples whose contamination is allowed to exceed m (that is, test positive for contamination), yet the lot will be accepted"]
["amount","sample weight, in gram (only relevant for 2-class enrichement plans)"]
["P(accept)","the probability of accepting a specific lot; this is a function of the assumed contamination level (mean, sigma) and the sampling plan (n, c and amount). This is usually set at 5%, this then"]
[null,"means there is 5% probability of acceptance, or 95% probability of detecting such unacceptable lot"]
["sensitivity","true positive rate= TP/(TP+FN), (assumed to be fixed value depending on the method and not dependant on the concentration of the organisms)"]
["specificity","true negative rate= TN/(TN+FP), (assumed to be fixed value depending on the method and not dependant on the concentration of the organisms)"]
[]
["The Implied Acceptance Level, shown on all ‘tabs’ (worksheets), allows you to calculate the proportion of all the samples in the lot that would be expected to be above any chosen logCFU value"]
["(i.e., a user input). For that logCFU, the z-score is also calculated."]
[]
[]
["For a manual please open the following word-file",null,null,null,null,null,"For an explanation on arithmetic and geometric means open the following word-file"]

{"sheet":"2-class enrichment","index":3,"n_rows":138,"n_cols":34,"rows_kept":138,"cut":false,"hidden":false,"merged":[[0,33,1,38],[29,15,29,20],[29,8,29,13],[0,15,1,20],[17,18,17,19],[17,8,17,9],[0,1,1,6],[0,8,1,13],[35,1,35,20],[36,1,36,20],[56,1,56,10],[50,1,50,10],[26,1,26,6],[17,11,17,12]]}
[null,{"$f":"\"Operating characteristic curve for proportion defective, with n=\"&n&\" and c=\"&cm","v":"Operating characteristic curve for proportion defective, with n=60 and c=0"},null,null,null,null,null,null,{"$f":"\"Probability density function (PDF) for log counts.  Distribution mean = \"&FIXED(meanlog,2)&\" and sigma = \"&FIXED(sigma,2)","v":"Probability density function (PDF) for log counts.  Distribution mean = -3.31 and sigma = 0.80"},null,null,null,null,null,null,{"$f":"\"Operating characteristic curve scaled to relate log arithmetic mean count to m\"","v":"Operating characteristic curve scaled to relate log arithmetic mean count to m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Operating characteristic curve scaled to relate mean log count to m\"","v":"Operating characteristic curve scaled to relate mean log count to m"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"INPUTS",null,null,"P(accept)",null,null,null,"ALTERNATIVE n AND c",null,null,"P(accept)"]
[null,null,"Lot acceptance for Pd",null,null,null,null,null,"mean",-3.3084021294813049,null,"Computed",{"$f":"$F$53*100","v":5.0004557066320867},"%",null,"mean",{"$f":"meanlog","v":-3.3084021294813049},null,"Computed",{"$f":"F55*100","v":5.0004557066320867},"%"]
[null,null,null,null,null,"P(accept)",null,null,"sigma",0.8,null,"Desired",5,"%",null,"sigma",{"$f":"sigma","v":0.8},null,"Target, left",{"$f":"computed_P","v":5.0004557066320867},"%"]
[null,null,"Pd",20,"%",{"$f":"$F$54*100","v":1.5324955408658878E-4},"%",null,"m",{"$f":"-LOG(weight)","v":-1.3979400086720377},null,null,null,null,null,"m",{"$f":"m","v":-1.3979400086720377}]
[null,null,"actualPd",{"$f":"+Pd*100","v":4.8701468333542604},"%",{"$f":"+computed_P","v":5.0004557066320867},"%",null,"n",60,null,null,null,null,null,"n",{"$f":"n","v":60}]
[null,null,null,null,null,null,null,null,"c",0,null,null,null,null,null,"c",{"$f":"cm","v":0}]
[]
[null,null,null,null,null,null,null,null,"amount",25,"g",null,null,null,null,"amount",{"$f":"10^-alternative_m","v":25.000000000000018},"g"]
[]
[null,"Sandbox: for your own calculations"]
[null,"FSO",-1,null,null,null,null,null,null,null,null,"P(reject)",{"$f":"100-computed_P","v":94.999544293367919},"%"]
[null,"complient",{"$f":"_xlfn.NORM.DIST(C28,meanlog,sigma,1)","v":0.99804605421470571},"not comply",{"$f":"1-_xlfn.NORM.DIST(C28,meanlog,sigma,1)","v":1.9539457852942865E-3}]
[null,"%",{"$f":"100*C29","v":99.804605421470569},"%",{"$f":"100*E29","v":0.19539457852942865},null,null,null,"Means",null,null,null,null,null,null,"Implied Acceptance level "]
[null,null,null,null,null,null,null,null,null,"Arithmetic (=Average)",null,null,"Geometric (=Median)",null,null,"Percentile","z-score","Concentration at this percentile"]
[null,null,null,null,null,null,null,null,null,{"$f":"10^(meanlog+0.5*sigma^2*LN(10))","v":2.6817920578567976E-3},"cfu/g",null,{"$f":"10^meanlog","v":4.915841487605412E-4},"cfu/g",null,99.9,{"$f":"+TINV(2*(1-P32/100),1000)","v":3.0984021639129624},null,{"$f":"+meanlog+Q32*sigma","v":-0.82968039835093466}]
[null,null,null,null,null,null,null,null,"one cfu in",{"$f":"1/J32","v":372.88498825638555},"grams","one cfu in",{"$f":"1/M32","v":2034.2397176991087},"grams",null,"FSO","P(exceedance)",null,"target level"]
[null,null,null,null,null,null,null,null,null,{"$f":"+LOG(J32)","v":-2.5715748997232102},"log cfu/g",null,{"$f":"+LOG(M32)","v":-3.3084021294813053},"log cfu/g",null,{"$f":"+S32","v":-0.82968039835093466},{"$f":"1-_xlfn.NORM.DIST(P34,meanlog,sigma,1)","v":9.7283600143704962E-4},null,{"$f":"+P34-Q32*sigma","v":-3.3084021294813049}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(ABS(computed_P-desired_P)<0.001,\"This sampling plan would provide \"&FIXED(M28,0)&\" % confidence that a lot of food containing a geometric mean concentration of 1 organism in \"&FIXED(M33,1)&\" g and an arithmetic mean concentration of 1 organism in \"&FIXED(J33,1)&\" g\",\"\")","v":"This sampling plan would provide 95 % confidence that a lot of food containing a geometric mean concentration of 1 organism in 2,034.2 g and an arithmetic mean concentration of 1 organism in 372.9 g"}]
[null,{"$f":"IF(ABS(computed_P-desired_P)<0.001,\"(and having a standard deviation of \"&FIXED(sigma,2)&\" log cfu/g), would be rejected (i.e. more than \"& cm&\" out of \"&n&\" samples of \"&weight&\" grams giving detection of the organism)\",\"\")","v":"(and having a standard deviation of 0.80 log cfu/g), would be rejected (i.e. more than 0 out of 60 samples of 25 grams giving detection of the organism)"}]
[null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The calculations below are for the buttons above.  Do not edit."]
[null,"geo mean","arith mean","pa","pd","P(accept)"]
[null,{"$f":"meanlog","v":-3.3084021294813049},{"$f":"+B53+0.5*LN(10)*sigma^2","v":-2.5715748997232102},{"$f":"1-poissonlognormal(meanlog,sigma,10^-m)","v":0.95129853166645739},{"$f":"1-D53","v":4.8701468333542608E-2},{"$f":"+BINOMDIST(cm,n,$E53,1)","v":5.0004557066320864E-2},null,"<= Used by macros for finding mean and n"]
[null,null,null,{"$f":"1-E54","v":0.8},{"$f":"$D$21/100","v":0.2},{"$f":"+BINOMDIST(cm,n,$E54,1)","v":1.5324955408658878E-6},null,"<= Used in test against ICMSF tables"]
[null,{"$f":"meanlog","v":-3.3084021294813049},{"$f":"+B55+0.5*LN(10)*sigma^2","v":-2.5715748997232102},{"$f":"1-poissonlognormal(meanlog,sigma,10^-alternative_m)","v":0.95129853166645739},{"$f":"1-D55","v":4.8701468333542608E-2},{"$f":"+BINOMDIST($Q$23,$Q$22,$E55,1)","v":5.0004557066320864E-2},null,"<= Used by macro for finding m in equivalent performance criterion"]
[]
[null,"The calculations below are for the charts above.  Do not edit."]
[null,-6,{"$f":"+B58+0.5*LN(10)*sigma^2","v":-5.2631727702419049},{"$f":"1-poissonlognormal(B58,sigma,10^-m)","v":0.99986388321832842},{"$f":"1-D58","v":1.3611678167158026E-4},{"$f":"+BINOMDIST(cm,n,$E58,1)","v":0.99186570113351236},{"$f":"NORMDIST($B58,meanlog,sigma,FALSE)","v":1.7367909483534465E-3},null,{"$f":"1-poissonlognormal(B58,sigma,10^-alternative_m)","v":0.99986388321832842},{"$f":"1-I58","v":1.3611678167158026E-4},{"$f":"+BINOMDIST($Q$23,$Q$22,$J58,1)","v":0.99186570113351236}]
[null,-5.9,-5.1631727702419052,0.99982872385440436,1.7127614559564464E-4,0.98977518361253558,2.6242333471468066E-3,null,0.99982872385440436,{"$f":"1-I59","v":1.7127614559564464E-4},{"$f":"+BINOMDIST($Q$23,$Q$22,$J59,1)","v":0.98977518361253558}]
[null,-5.8,-5.0631727702419047,0.99978450871553759,2.1549128446241017E-4,0.98715237414715173,3.9036556584715843E-3,null,0.99978450871553759,2.1549128446241017E-4,0.98715237414715173]
[null,-5.7,-4.9631727702419051,0.9997289196402751,2.7108035972489564E-4,0.98386456704550507,5.7168224179410566E-3,null,0.9997289196402751,2.7108035972489564E-4,0.98386456704550507]
[null,-5.6,-4.8631727702419045,0.99965905268432864,3.4094731567135828E-4,0.97974756514506078,8.2423689535209115E-3,null,0.99965905268432864,3.4094731567135828E-4,0.97974756514506078]
[null,-5.5,-4.7631727702419049,0.99957127404315049,4.2872595684950721E-4,0.97459909889190721,1.1699398897837198E-2,null,0.99957127404315049,4.2872595684950721E-4,0.97459909889190721]
[null,-5.4,-4.6631727702419052,0.99946104249082446,5.3895750917554164E-4,0.96817137417445098,1.6348924763807199E-2,null,0.99946104249082446,5.3895750917554164E-4,0.96817137417445098]
[null,-5.3,-4.5631727702419047,0.99932269147443631,6.7730852556369125E-4,0.96016293961549981,2.2492047420784072E-2,null,0.99932269147443631,6.7730852556369125E-4,0.96016293961549981]
[null,-5.2,-4.4631727702419051,0.99914916301240897,8.5083698759103044E-4,0.9502103011168207,3.0463719958754194E-2,null,0.99914916301240897,8.5083698759103044E-4,0.9502103011168207]
[null,-5.0999999999999996,-4.3631727702419045,0.99893168459837289,1.0683154016271068E-3,0.93788007736870649,4.0621038957226206E-2,null,0.99893168459837289,1.0683154016271068E-3,0.93788007736870649]
[null,-5,-4.2631727702419049,0.99865937951261374,1.3406204873862571E-3,0.92266302724591276,5.3325295219534913E-2,null,0.99865937951261374,{"$f":"1-I68","v":1.3406204873862571E-3},0.92266302724591276]
[null,-4.9000000000000004,-4.1631727702419052,0.99831880043814647,1.6811995618535303E-3,0.90397202774728025,6.8917522796599046E-2,null,0.99831880043814647,1.6811995618535303E-3,0.90397202774728025]
[null,-4.8,-4.0631727702419047,0.99789337626675589,2.1066237332441062E-3,0.88114705634395418,8.7688006593881415E-2,null,0.99789337626675589,2.1066237332441062E-3,0.88114705634395418,"Coordinates to place m"]
[null,-4.7,-3.9631727702419055,0.99736276271814595,2.6372372818540546E-3,0.85347139257118776,0.10984110290011599,null,0.99736276271814595,2.6372372818540546E-3,0.85347139257118776,"proportion",null,"m"]
[null,-4.5999999999999996,-3.863172770241905,0.99670208919782544,3.297910802174564E-3,0.82020443915510732,0.13545770747550798,null,0.99670208919782544,3.297910802174564E-3,0.82020443915510732,0,0,{"$f":"m","v":-1.3979400086720377}]
[null,-4.5000000000000098,-3.7631727702419151,0.99588109755463239,4.1189024453676115E-3,0.78063740325786191,0.16445864442321087,null,0.99588109755463239,4.1189024453676115E-3,0.78063740325786191,{"$f":"1.1*NORMDIST(meanlog,meanlog,sigma,FALSE)","v":0.54854563555197},1,{"$f":"m","v":-1.3979400086720377}]
[null,-4.4000000000000101,-3.6631727702419155,0.99486317347112274,5.1368265288772585E-3,0.73417789003828704,0.1965729883221087,null,0.99486317347112274,5.1368265288772585E-3,0.73417789003828704]
[null,-4.3000000000000096,-3.5631727702419149,0.99360427853837929,6.395721461620707E-3,0.68046716939111573,0.23131570631575984,null,0.99360427853837929,6.395721461620707E-3,0.68046716939111573]
[null,-4.2000000000000099,-3.4631727702419153,0.99205180099560608,7.9481990043939188E-3,0.61952807576302749,0.26797887123344799,null,0.99205180099560608,7.9481990043939188E-3,0.61952807576302749]
[null,-4.1000000000000103,-3.3631727702419156,0.99014335590507108,9.8566440949289236E-3,0.55193083276180244,0.30563995941435496,null,0.99014335590507108,9.8566440949289236E-3,0.55193083276180244]
[null,-4.0000000000000098,-3.2631727702419151,0.98780558123334339,1.2194418766656612E-2,0.47894819320304099,0.34318939722116459,null,0.98780558123334339,1.2194418766656612E-2,0.47894819320304099]
[null,-3.9000000000000101,-3.1631727702419155,0.98495299466315411,1.5047005336845887E-2,0.40265240566649513,0.37937764755872561,null,0.98495299466315411,1.5047005336845887E-2,0.40265240566649513]
[null,-3.80000000000001,-3.0631727702419154,0.98148699629293379,1.8513003707066211E-2,0.32589147565346088,0.41287992318594541,null,0.98148699629293379,1.8513003707066211E-2,0.32589147565346088,"Coordinates to place Pd"]
[null,-3.7000000000000099,-2.9631727702419153,0.97729512350084768,2.2704876499152316E-2,0.2520832005625484,0.44237435253992441,null,0.97729512350084768,2.2704876499152316E-2,0.2520832005625484,"p accept"]
[null,-3.6000000000000099,-2.8631727702419152,0.97225068437240292,2.7749315627597082E-2,0.18479722752741434,0.46662742883531466,null,0.97225068437240292,2.7749315627597082E-2,0.18479722752741434,"x","y"]
[null,-3.5000000000000102,-2.7631727702419155,0.96621291281887633,3.3787087181123665E-2,0.12716577297782572,0.48457916323878997,null,0.96621291281887633,3.3787087181123665E-2,0.12716577297782572,{"$f":"+Pd","v":4.8701468333542608E-2},0]
[null,-3.4000000000000101,-2.6631727702419155,0.95902779890067935,4.0972201099320649E-2,8.1259054163237504E-2,0.49541979648782214,null,0.95902779890067935,4.0972201099320649E-2,8.1259054163237504E-2,{"$f":"+Pd","v":4.8701468333542608E-2},{"$f":"+desired_P/100","v":0.05}]
[null,-3.30000000000001,-2.5631727702419154,0.95052974858478323,4.947025141521677E-2,4.7636824972396068E-2,0.49865034770418482,null,0.95052974858478323,4.947025141521677E-2,4.7636824972396068E-2]
[null,-3.2000000000000099,-2.4631727702419153,0.94054421478496408,5.9455785215035917E-2,2.5278598234362178E-2,0.49412069608641923,null,0.94054421478496408,5.9455785215035917E-2,2.5278598234362178E-2]
[null,-3.1000000000000099,-2.3631727702419152,0.92889141295631605,7.1108587043683946E-2,1.1964564253067193E-2,0.48204114750558452,null,0.92889141295631605,7.1108587043683946E-2,1.1964564253067193E-2]
[null,-3.0000000000000102,-2.2631727702419155,0.91539118748208925,8.4608812517910748E-2,4.9705406303226125E-3,0.46296624476083037,null,0.91539118748208925,8.4608812517910748E-2,4.9705406303226125E-3]
[null,-2.9000000000000101,-2.1631727702419155,0.89986902876472252,0.10013097123527748,1.7813870251074469E-3,0.43775255736350888,null,0.89986902876472252,0.10013097123527748,1.7813870251074469E-3]
[null,-2.80000000000001,{"$f":"+B90+0.5*LN(10)*sigma^2","v":-2.0631727702419154},{"$f":"1-poissonlognormal(B90,sigma,10^-m)","v":0.88216315646574139},{"$f":"1-D90","v":0.11783684353425861},{"$f":"+BINOMDIST(cm,n,$E90,1)","v":5.4067330949240466E-4},{"$f":"NORMDIST($B90,meanlog,sigma,FALSE)","v":0.40749492576030077},null,{"$f":"1-poissonlognormal(B90,sigma,10^-alternative_m)","v":0.88216315646574139},0.11783684353425861,5.4067330949240466E-4]
[null,-2.7000000000000099,-1.9631727702419153,0.86213248532986686,0.13786751467013314,1.3628265396523705E-4,0.37344776712929489,null,0.86213248532986686,0.13786751467013314,1.3628265396523705E-4]
[null,-2.6000000000000099,-1.8631727702419152,0.8396651827606928,0.1603348172393072,2.7949157181852501E-5,0.33693930659856652,null,0.8396651827606928,0.1603348172393072,2.7949157181852501E-5]
[null,-2.5000000000000102,-1.7631727702419155,0.8146874206751189,0.1853125793248811,4.5652086734275682E-6,0.29928685127015636,null,0.8146874206751189,0.1853125793248811,4.5652086734275682E-6]
[null,-2.4000000000000101,-1.6631727702419155,0.78717182915666262,0.21282817084333738,5.8099528177118184E-7,0.26172050238617617,null,0.78717182915666262,0.21282817084333738,5.8099528177118184E-7]
[null,-2.30000000000001,-1.5631727702419154,0.75714508825465188,0.24285491174534812,5.6330883206722165E-8,0.2253211722974168,null,0.75714508825465188,0.24285491174534812,5.6330883206722165E-8]
[null,-2.2000000000000099,-1.4631727702419153,0.72469405902954231,0.27530594097045769,4.067073881541016E-9,0.19097671012486059,null,0.72469405902954231,0.27530594097045769,4.067073881541016E-9]
[null,-2.1000000000000099,-1.3631727702419152,0.68996986599577093,0.31003013400422907,2.1370142425957537E-10,0.15935766659226325,null,0.68996986599577093,0.31003013400422907,2.1370142425957537E-10]
[null,-2.0000000000000102,-1.2631727702419155,0.65318940743375964,0.34681059256624036,7.9863437327008817E-12,0.13091206242969886,null,0.65318940743375964,0.34681059256624036,7.9863437327008817E-12]
[null,-1.9000000000000099,-1.163172770241915,0.61463388967516897,0.38536611032483103,2.074866516430463E-13,0.1058767292626768,null,0.61463388967516897,0.38536611032483103,2.074866516430463E-13]
[null,-1.80000000000001,-1.0631727702419154,0.57464415238665589,0.42535584761334411,3.663865304918581E-15,8.4301541705909158E-2,null,0.57464415238665589,0.42535584761334411,3.663865304918581E-15]
[null,-1.7000000000000199,-0.96317277024192516,0.53361276363669297,0.46638723636330703,4.3010307033205175E-17,6.6082226353503679E-2,null,0.53361276363669297,0.46638723636330703,4.3010307033205175E-17]
[null,-1.6000000000000201,-0.86317277024192529,0.49197309960759905,0.50802690039240095,3.2845918319695738E-19,5.0997391670666858E-2,null,0.49197309960759905,0.50802690039240095,3.2845918319695738E-19]
[null,-1.50000000000002,-0.7631727702419252,0.45018586301748098,0.54981413698251902,1.5977586431262132E-21,3.8745869438126863E-2,null,0.45018586301748098,0.54981413698251902,1.5977586431262132E-21]
[null,-1.4000000000000199,-0.66317277024192511,0.40872371299668775,0.59127628700331225,4.8505400964750883E-24,2.8981242844051805E-2,null,0.40872371299668775,0.59127628700331225,4.8505400964750883E-24]
[null,-1.30000000000002,-0.56317277024192525,0.36805485383229308,0.63194514616770692,9.0105846197095975E-27,2.1341392344614012E-2,null,0.36805485383229308,0.63194514616770692,9.0105846197095975E-27]
[null,-1.2000000000000199,-0.46317277024192516,0.32862654057545526,0.67137345942454474,1.0049815838910675E-29,1.5471864126533643E-2,null,0.32862654057545526,0.67137345942454474,1.0049815838910675E-29]
[null,-1.1000000000000201,-0.36317277024192529,0.29084949184254394,0.70915050815745606,6.6084340686827913E-33,1.1042735865440726E-2,null,0.29084949184254394,0.70915050815745606,6.6084340686827913E-33]
[null,-1.00000000000002,-0.2631727702419252,0.25508414823587122,0.74491585176412878,2.5177248014347849E-36,7.7593416471813843E-3,null,0.25508414823587122,0.74491585176412878,2.5177248014347849E-36]
[null,-0.90000000000002001,-0.16317277024192522,0.22162958207811623,0.77837041792188377,5.4659247833732948E-40,5.3676873709570016E-3,null,0.22162958207811623,0.77837041792188377,5.4659247833732948E-40]
[null,-0.80000000000002003,-6.3172770241925247E-2,0.19071566277364571,0.80928433722635429,6.6555153718346123E-44,3.6556423592783317E-3,null,0.19071566277364571,0.80928433722635429,6.6555153718346123E-44]
[null,-0.70000000000002005,3.6827229758074731E-2,0.16249883233233764,0.83750116766766236,4.4772843492830584E-48,2.4510622281872516E-3,null,0.16249883233233764,0.83750116766766236,4.4772843492830584E-48]
[null,-0.60000000000001996,0.13682722975807482,0.13706157260644092,0.86293842739355908,1.640373063184395E-52,1.6179277445701223E-3,null,0.13706157260644092,0.86293842739355908,1.640373063184395E-52]
[null,-0.50000000000001998,0.2368272297580748,0.11441537678189606,0.88558462321810394,3.22896774405048E-57,1.0514244119565592E-3,null,0.11441537678189606,0.88558462321810394,3.22896774405048E-57]
[null,-0.40000000000002001,0.33682722975807478,9.4506798825080729E-2,0.90549320117491927,3.371189521239687E-62,6.7268406317047005E-4,null,9.4506798825080729E-2,0.90549320117491927,3.371189521239687E-62]
[null,-0.30000000000001997,0.43682722975807481,7.7225966926857237E-2,0.92277403307314276,1.8441713974195295E-67,4.2369990828793725E-4,null,7.7225966926857237E-2,0.92277403307314276,1.8441713974195295E-67]
[null,-0.20000000000002,0.53682722975807473,6.2416825326544689E-2,0.93758317467345531,5.2251713419718229E-73,2.6273610054813347E-4,null,6.2416825326544689E-2,0.93758317467345531,5.2251713419718229E-73]
[null,-0.10000000000002,0.63682722975807482,4.988831945184824E-2,0.95011168054815176,7.5845962530420506E-79,1.6039664451232934E-4,null,4.988831945184824E-2,0.95011168054815176,7.5845962530420506E-79]
[null,-2.0428103653102899E-14,0.73682722975807435,3.9425759829020413E-2,0.96057424017097959,5.5821861993715537E-85,9.6401758483764729E-5,null,3.9425759829020413E-2,0.96057424017097959,5.5821861993715537E-85]
[null,9.9999999999980105E-2,0.83682722975807489,3.0801681747319676E-2,0.96919831825268032,2.062841010543556E-91,5.7041216912637881E-5,null,3.0801681747319676E-2,0.96919831825268032,2.062841010543556E-91]
[null,0.19999999999998,0.93682722975807475,2.3785644836254005E-2,0.97621435516374599,3.7922397526952896E-98,3.3228195498949387E-5,null,2.3785644836254005E-2,0.97621435516374599,3.7922397526952896E-98]
[null,0.29999999999998,1.0368272297580747,1.8152571921576044E-2,0.98184742807842396,3.437874098903839E-105,1.905631313411208E-5,null,1.8152571921576044E-2,0.98184742807842396,3.437874098903839E-105]
[null,0.39999999999997998,{"$f":"+B122+0.5*LN(10)*sigma^2","v":1.1368272297580748},{"$f":"1-poissonlognormal(B122,sigma,10^-m)","v":1.3689391204875334E-2},{"$f":"1-D122","v":0.98631060879512467},{"$f":"+BINOMDIST(cm,n,$E122,1)","v":1.524221474959864E-112},{"$f":"NORMDIST($B122,meanlog,sigma,FALSE)","v":1.075932813777767E-5},null,{"$f":"1-poissonlognormal(B122,sigma,10^-alternative_m)","v":1.3689391204875334E-2},0.98631060879512467,1.524221474959864E-112]
[null,0.49999999999998002,1.2368272297580747,1.0199902881525169E-2,0.98980009711847483,3.2791569106016283E-120,5.9806112551897564E-6,null,1.0199902881525169E-2,0.98980009711847483,{"$f":"+BINOMDIST($Q$23,$Q$22,$J123,1)","v":3.2791569106016283E-120}]
[null,0.59999999999997999,1.3368272297580748,7.5079278318463949E-3,0.99249207216815361,3.397859093616605E-128,3.2728051021721746E-6,null,7.5079278318463949E-3,0.99249207216815361,3.397859093616605E-128]
[null,0.69999999999997997,1.4368272297580749,5.4589026027032084E-3,0.99454109739729679,1.6839172415892595E-136,1.7632295759644482E-6,null,5.4589026027032084E-3,0.99454109739729679,1.6839172415892595E-136]
[null,0.79999999999997995,1.5368272297580747,3.9201575553393653E-3,0.99607984244466063,3.9647091030559369E-145,9.3521557116812874E-7,null,3.9201575553393653E-3,0.99607984244466063,3.9647091030559369E-145]
[null,0.89999999999998004,1.6368272297580748,2.7801539011549359E-3,0.99721984609884506,4.4068703222719173E-154,4.8834724839408528E-7,null,2.7801539011549359E-3,0.99721984609884506,4.4068703222719173E-154]
[null,0.99999999999998002,1.7368272297580747,1.9469637324993627E-3,0.99805303626750064,2.2986439211406268E-163,2.5104981727831119E-7,null,1.9469637324993627E-3,0.99805303626750064,2.2986439211406268E-163]
[null,1.0999999999999699,1.8368272297580646,1.3462613198261808E-3,0.99865373868017382,5.5945103428453813E-173,1.2705893855546196E-7,null,1.3462613198261808E-3,0.99865373868017382,5.5945103428453813E-173]
[null,1.19999999999997,1.9368272297580647,9.1906071593594874E-4,0.99908093928406405,6.3190557740078165E-183,6.3308887946300935E-8,null,9.1906071593594874E-4,0.99908093928406405,6.3190557740078165E-183]
[null,1.2999999999999701,2.0368272297580647,6.193913797550854E-4,0.99938060862024491,3.2954096705299134E-193,3.1055483543935E-8,null,6.193913797550854E-4,0.99938060862024491,3.2954096705299134E-193]
[null,1.3999999999999699,2.1368272297580648,4.1205657235654503E-4,0.99958794342764345,7.896065370370309E-204,1.4997748108390365E-8,null,4.1205657235654503E-4,{"$f":"1-I132","v":0.99958794342764345},7.896065370370309E-204]
[null,1.49999999999997,2.2368272297580649,2.7057371272876107E-4,0.99972942628727124,8.6523893972020513E-215,7.1306310084447739E-9,null,2.7057371272876107E-4,0.99972942628727124,8.6523893972020513E-215]
[null,1.5999999999999699,2.3368272297580646,1.7535548894098696E-4,0.99982464451105901,4.316799498534693E-226,3.3376748045901497E-9,null,1.7535548894098696E-4,0.99982464451105901,4.316799498534693E-226]
[null,1.69999999999997,2.4368272297580647,1.121573126305897E-4,0.99988784268736941,9.764627588495551E-238,1.5380633583645699E-9,null,1.121573126305897E-4,0.99988784268736941,9.764627588495551E-238]
[null,1.7999999999999701,2.5368272297580647,7.0791509223622207E-5,0.99992920849077638,9.9740209534669027E-250,6.9778010114102873E-10,null,7.0791509223622207E-5,0.99992920849077638,9.9740209534669027E-250]
[null,1.8999999999999699,2.6368272297580648,4.409124014526089E-5,0.99995590875985474,4.5828839354592677E-262,3.1165714178930438E-10,null,4.409124014526089E-5,0.99995590875985474,4.5828839354592677E-262]
[null,1.99999999999997,2.7368272297580649,2.7096581610819293E-5,0.99997290341838918,9.4377905602062921E-275,1.370407526671924E-10,null,2.7096581610819293E-5,0.99997290341838918,9.4377905602062921E-275]

{"sheet":"2-class counts","index":4,"n_rows":139,"n_cols":34,"rows_kept":139,"cut":false,"hidden":false,"merged":[[0,33,1,38],[29,15,29,20],[0,15,1,20],[29,8,29,12],[17,18,17,19],[17,8,17,9],[17,11,17,12],[57,1,57,10],[0,1,1,6],[0,8,1,13],[51,1,51,10],[26,1,26,6],[35,1,35,20],[36,1,36,20]]}
[null,{"$f":"\"Operating characteristic curve for proportion defective, with n=\"&n&\" and c=\"&cm","v":"Operating characteristic curve for proportion defective, with n=10 and c=0"},null,null,null,null,null,null,{"$f":"\"Probability density function (PDF) for log counts.  Distribution mean = \"&FIXED(meanlog,2)&\" and sigma = \"&FIXED(sigma,2)","v":"Probability density function (PDF) for log counts.  Distribution mean = 1.48 and sigma = 0.80"},null,null,null,null,null,null,{"$f":"\"Operating characteristic curve scaled to relate log arithmetic mean count to m\"","v":"Operating characteristic curve scaled to relate log arithmetic mean count to m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Operating characteristic curve scaled to relate mean log count to m\"","v":"Operating characteristic curve scaled to relate mean log count to m"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"INPUTS",null,null,"P(accept)",null,null,null,"ALTERNATIVE n AND c",null,null,"P(accept)"]
[null,null,"Lot acceptance for Pd",null,null,null,null,null,"mean",1.4825237841696506,null,"Computed",{"$f":"$F$54*100","v":4.9999666558834166},"%",null,"mean",{"$f":"meanlog","v":1.4825237841696506},null,"Computed",{"$f":"F56*100","v":4.9999666558834166},"%"]
[null,null,null,null,null,"P(accept)",null,null,"sigma",0.8,null,"Desired",5,"%",null,"sigma",{"$f":"sigma","v":0.8},null,"Target, left",{"$f":"computed_P","v":4.9999666558834166},"%"]
[null,null,"Pd",10,"%",{"$f":"$F$55*100","v":34.867844009999992},"%",null,"m",2,null,null,null,null,null,"m",{"$f":"m","v":2}]
[null,null,"actualPd",{"$f":"+Pd*100","v":25.886604514400503},"%",{"$f":"+computed_P","v":4.9999666558834166},"%",null,"n",10,null,null,null,null,null,"n",{"$f":"n","v":10}]
[null,null,null,null,null,null,null,null,"c",0,null,null,null,null,null,"c",{"$f":"cm","v":0}]
[]
[]
[]
[null,"Sandbox: for your own calculations"]
[null,"FSO",3,null,null,null,null,null,null,null,null,"P(reject)",{"$f":"100-computed_P","v":95.000033344116588},"%"]
[null,"complient",{"$f":"_xlfn.NORM.DIST(C28,meanlog,sigma,1)","v":0.97107581871599336},"not comply",{"$f":"1-_xlfn.NORM.DIST(C28,meanlog,sigma,1)","v":2.8924181284006645E-2}]
[null,"%",{"$f":"100*C29","v":97.107581871599336},"%",{"$f":"100*E29","v":2.8924181284006645},null,null,null,"Means",null,null,null,null,null,null,"Implied Acceptance level "]
[null,null,null,null,null,null,null,null,"Arithmetic (=Average)",null,null,"Geometric (=Median)",null,null,null,"Percentile","z-score","Concentration at this percentile"]
[null,null,null,null,null,null,null,null,{"$f":"10^(meanlog+0.5*sigma^2*LN(10))","v":165.71087630157803},"cfu/g",null,{"$f":"10^meanlog","v":30.375524391766433},"cfu/g",null,null,99.9,{"$f":"+TINV(2*(1-P32/100),1000)","v":3.0984021639129624},null,{"$f":"+meanlog+Q32*sigma","v":3.9612455153000208}]
[null,null,null,null,null,null,null,null,{"$f":"+LOG(I32)","v":2.2193510139277453},"log cfu/g",null,{"$f":"+LOG(L32)","v":1.4825237841696506},"log cfu/g",null,null,"FSO","P(exceedance)",null,"target level"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+S32","v":3.9612455153000208},{"$f":"1-_xlfn.NORM.DIST(P34,meanlog,sigma,1)","v":9.7283600143704962E-4},null,{"$f":"+P34-Q32*sigma","v":1.4825237841696506}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(ABS(computed_P-desired_P)<0.001,\"This sampling plan would provide \"&FIXED(M28,0)&\" % confidence that a lot of food containing a geometric mean concentration of \"&FIXED(L32,1)&\" cfu/g and an arithmetic mean concentration of \"&FIXED(I32,1)&\" cfu/g\",\"\")","v":"This sampling plan would provide 95 % confidence that a lot of food containing a geometric mean concentration of 30.4 cfu/g and an arithmetic mean concentration of 165.7 cfu/g"}]
[null,{"$f":"IF(ABS(computed_P-desired_P)<0.001,\"(and having a standard deviation of \"&FIXED(sigma,2)&\" log cfu/g), would be rejected (i.e. more than \"& cm&\" out of \"&n&\" samples having higher levels than \"&m&\" logs cfu/g)\",\"\")","v":"(and having a standard deviation of 0.80 log cfu/g), would be rejected (i.e. more than 0 out of 10 samples having higher levels than 2 logs cfu/g)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The calculations below are for the buttons above.  Do not edit."]
[null,"geo mean","arith mean","pa","pd","P(accept)"]
[null,{"$f":"meanlog","v":1.4825237841696506},{"$f":"+B54+0.5*LN(10)*sigma^2","v":2.2193510139277453},{"$f":"NORMSDIST((m-B54)/sigma)","v":0.74113395485599498},{"$f":"1-D54","v":0.25886604514400502},{"$f":"+BINOMDIST(cm,n,$E54,1)","v":4.9999666558834165E-2},null,"<= Used by macros for finding mean and n"]
[null,null,null,{"$f":"1-E55","v":0.9},{"$f":"$D$21/100","v":0.1},{"$f":"+BINOMDIST(cm,n,$E55,1)","v":0.34867844009999993},null,"<= Used in test against ICMSF tables"]
[null,{"$f":"meanlog","v":1.4825237841696506},{"$f":"+B56+0.5*LN(10)*sigma^2","v":2.2193510139277453},{"$f":"NORMSDIST((alternative_m-B56)/sigma)","v":0.74113395485599498},{"$f":"1-D56","v":0.25886604514400502},{"$f":"+BINOMDIST($Q$23,$Q$22,$E56,1)","v":4.9999666558834165E-2},null,"<= Used by macro for finding m in equivalent performance criterion"]
[]
[null,"The calculations below are for the charts above.  Do not edit."]
[null,-4,{"$f":"+B59+0.5*LN(10)*sigma^2","v":-3.2631727702419053},{"$f":"NORMSDIST((m-B59)/sigma)","v":0.99999999999996814},{"$f":"1-D59","v":3.1863400806741993E-14},{"$f":"+BINOMDIST(cm,n,$E59,1)","v":0.99999999999968137},{"$f":"NORMDIST($B59,meanlog,sigma,FALSE)","v":3.1574860681541457E-11},null,{"$f":"NORMSDIST((alternative_m-B59)/sigma)","v":0.99999999999996814},{"$f":"1-I59","v":3.1863400806741993E-14},{"$f":"+BINOMDIST($Q$23,$Q$22,$J59,1)","v":0.99999999999968137}]
[null,-3.9,-3.1631727702419052,0.99999999999991784,8.2156503822261584E-14,0.99999999999917843,7.3787777193137032E-11,null,0.99999999999991784,{"$f":"1-I60","v":8.2156503822261584E-14},{"$f":"+BINOMDIST($Q$23,$Q$22,$J60,1)","v":0.99999999999917843}]
[null,-3.8,-3.0631727702419052,0.99999999999979161,2.0838886172214188E-13,0.99999999999791611,1.697624214079482E-10,null,0.99999999999979161,2.0838886172214188E-13,0.99999999999791611]
[null,-3.7,-2.9631727702419055,0.99999999999947964,5.2036153164181087E-13,0.99999999999479638,3.8451460774312379E-10,null,0.99999999999947964,5.2036153164181087E-13,0.99999999999479638]
[null,-3.6,-2.8631727702419054,0.99999999999872013,1.2798651027878805E-12,0.99999999998720135,8.5742920942866242E-10,null,0.99999999999872013,1.2798651027878805E-12,0.99999999998720135]
[null,-3.5,-2.7631727702419053,0.99999999999690048,3.099520640148512E-12,0.99999999996900479,1.8823390580859999E-9,null,0.99999999999690048,3.099520640148512E-12,0.99999999996900479]
[null,-3.4,-2.6631727702419052,0.99999999999260769,7.3923089871641423E-12,0.99999999992607691,4.0682869929380126E-9,null,0.99999999999260769,7.3923089871641423E-12,0.99999999992607691]
[null,-3.3,-2.5631727702419052,0.99999999998263756,1.7362444815205436E-11,0.99999999982637555,8.6564427118233826E-9,null,0.99999999998263756,1.7362444815205436E-11,0.99999999982637555]
[null,-3.2,-2.4631727702419055,0.99999999995984001,4.0159986447463325E-11,0.99999999959840014,1.8133493668254454E-8,null,0.99999999995984001,4.0159986447463325E-11,0.99999999959840014]
[null,-3.1,-2.3631727702419054,0.99999999990851851,9.1481489050693199E-11,0.99999999908518511,3.7397077080199245E-8,null,0.99999999990851851,9.1481489050693199E-11,0.99999999908518511]
[null,-3,-2.2631727702419053,0.99999999979477361,2.0522639143649712E-10,0.99999999794773609,7.5929052891677296E-8,null,0.99999999979477361,2.0522639143649712E-10,0.99999999794773609]
[null,-2.9,-2.1631727702419052,0.99999999954658192,4.5341808085908042E-10,0.99999999546581919,1.5177227869364557E-7,null,0.99999999954658192,4.5341808085908042E-10,0.99999999546581919]
[null,-2.8,-2.0631727702419052,0.9999999990134123,9.8658770042447941E-10,0.999999990134123,2.9866963780347901E-7,null,0.9999999990134123,9.8658770042447941E-10,0.999999990134123,"Coordinates to place m"]
[null,-2.7,-1.9631727702419055,0.99999999788578331,2.1142166906074067E-9,0.99999997885783332,5.7863386123822089E-7,null,0.99999999788578331,2.1142166906074067E-9,0.99999997885783332,"proportion",null,"m"]
[null,-2.6,-1.8631727702419054,0.99999999553782759,4.4621724093474313E-9,0.99999995537827679,1.1036484628658842E-6,null,0.99999999553782759,4.4621724093474313E-9,0.99999995537827679,0,0,{"$f":"m","v":2}]
[null,-2.5,-1.7631727702419053,0.99999999072460122,9.2753987823712691E-9,0.99999990724601606,2.0723916299019765E-6,null,0.99999999072460122,9.2753987823712691E-9,0.99999990724601606,{"$f":"1.1*NORMDIST(meanlog,meanlog,sigma,FALSE)","v":0.54854563555197},1,{"$f":"m","v":2}]
[null,-2.4,-1.6631727702419052,0.99999998101043752,1.8989562478033406E-8,0.99999981010439143,3.8311313774539201E-6,null,0.99999998101043752,1.8989562478033406E-8,0.99999981010439143]
[null,-2.2999999999999998,-1.5631727702419052,0.9999999617086589,3.8291341097895781E-8,0.99999961708665497,6.9726266157599195E-6,null,0.9999999617086589,3.8291341097895781E-8,0.99999961708665497]
[null,-2.2000000000000002,-1.4631727702419055,0.99999992395039483,7.6049605168826417E-8,0.99999923950420855,1.2493379211871674E-5,null,0.99999992395039483,7.6049605168826417E-8,0.99999923950420855]
[null,-2.1,-1.3631727702419054,0.99999985123112678,1.4876887322046173E-7,0.99999851231226378,2.203827428991409E-5,null,0.99999985123112678,1.4876887322046173E-7,0.99999851231226378]
[null,-2,-1.2631727702419053,0.99999971334842808,2.8665157192353519E-7,0.99999713348797836,3.8272725841555767E-5,null,0.99999971334842808,2.8665157192353519E-7,0.99999713348797836]
[null,-1.9,-1.1631727702419052,0.99999945595772444,5.4404227556315021E-7,0.99999455959056349,6.5435790541960967E-5,null,0.99999945595772444,5.4404227556315021E-7,0.99999455959056349]
[null,-1.8,-1.0631727702419052,0.99999898291675748,1.017083242516037E-6,0.99998982921412538,1.101426348235775E-4,null,0.99999898291675748,1.017083242516037E-6,0.99998982921412538,"Coordinates to place Pd"]
[null,-1.7,-0.96317277024190517,0.9999981270079944,1.8729920056026472E-6,0.9999812702378077,1.8251968812109688E-4,null,0.9999981270079944,1.8729920056026472E-6,0.9999812702378077,"p accept"]
[null,-1.6,-0.86317277024190531,0.99999660232687526,3.3976731247387093E-6,0.99996602378823618,2.9776806812555404E-4,null,0.99999660232687526,3.3976731247387093E-6,0.99996602378823618,"x","y"]
[null,-1.5,-0.76317277024190522,0.99999392837608869,6.0716239113078885E-6,0.99993928541976784,4.7825627542349123E-4,null,0.99999392837608869,6.0716239113078885E-6,0.99993928541976784,{"$f":"+Pd","v":0.25886604514400502},0]
[null,-1.4,-0.66317277024190513,0.9999893114742251,1.0688525774904534E-5,0.99989311988311069,7.5623605624280824E-4,null,0.9999893114742251,1.0688525774904534E-5,0.99989311988311069,{"$f":"+Pd","v":0.25886604514400502},{"$f":"+desired_P/100","v":0.05}]
[null,-1.3,-0.56317277024190526,0.99998146326215376,1.8536737846241991E-5,0.99981464808325249,1.1772487324578132E-3,null,0.99998146326215376,1.8536737846241991E-5,0.99981464808325249]
[null,-1.2,-0.46317277024190517,0.99996832875816688,3.1671241833119979E-5,0.99968333271589693,1.8042355331298254E-3,null,0.99996832875816688,3.1671241833119979E-5,0.99968333271589693]
[null,-1.1000000000000001,-0.36317277024190531,0.99994668765024886,5.3312349751144517E-5,0.99946700438360592,2.7222774179659947E-3,null,0.99994668765024886,5.3312349751144517E-5,0.99946700438360592]
[null,-1,-0.26317277024190522,0.99991158271479919,8.841728520081471E-5,0.99911617885779369,4.0437628510815726E-3,null,0.99991158271479919,8.841728520081471E-5,0.99911617885779369]
[null,-0.9,-0.16317277024190524,0.99985551927411875,1.4448072588124639E-4,0.99855613173996716,5.9136160585460612E-3,null,0.99985551927411875,1.4448072588124639E-4,0.99855613173996716]
[null,-0.8,{"$f":"+B91+0.5*LN(10)*sigma^2","v":-6.3172770241905263E-2},{"$f":"NORMSDIST((m-B91)/sigma)","v":0.99976737092096446},{"$f":"1-D91","v":2.3262907903554009E-4},{"$f":"+BINOMDIST(cm,n,$E91,1)","v":0.99767614293255535},{"$f":"NORMDIST($B91,meanlog,sigma,FALSE)","v":8.5140210502097271E-3},null,{"$f":"NORMSDIST((alternative_m-B91)/sigma)","v":0.99976737092096446},2.3262907903554009E-4,0.99767614293255535]
[null,-0.7,3.6827229758094826E-2,0.99963092154572497,3.6907845427502917E-4,0.99631533927883253,1.2067865560883203E-2,null,0.99963092154572497,3.6907845427502917E-4,0.99631533927883253]
[null,-0.6,0.1368272297580948,0.99942297495760923,5.7702504239076635E-4,0.99424470964983103,1.6839932868564597E-2,null,0.99942297495760923,5.7702504239076635E-4,0.99424470964983103]
[null,-0.5,0.23682722975809478,0.99911097470089161,8.8902529910839245E-4,0.99114522929052673,2.3134727963993906E-2,null,0.99911097470089161,8.8902529910839245E-4,0.99114522929052673]
[null,-0.4,0.33682722975809476,0.9986501019683699,1.3498980316301035E-3,0.98658272531308366,3.1289785578224129E-2,null,0.9986501019683699,1.3498980316301035E-3,0.98658272531308366]
[null,-0.3,0.43682722975809479,0.99797986251005399,2.0201374899460056E-3,0.97998128229504156,4.1663420858691735E-2,null,0.99797986251005399,2.0201374899460056E-3,0.97998128229504156]
[null,-0.2,0.53682722975809471,0.99702023676494544,2.9797632350545555E-3,0.97059876377404464,5.4616191558801618E-2,null,0.99702023676494544,2.9797632350545555E-3,0.97059876377404464]
[null,-0.1,0.6368272297580948,0.99566755163698739,4.3324483630126087E-3,0.95751048640672543,7.0485867502196972E-2,null,0.99566755163698739,4.3324483630126087E-3,0.95751048640672543]
[null,0,0.73682722975809478,0.99379033467422384,6.2096653257761592E-3,0.93961012080442396,8.9556442595868535E-2,null,0.99379033467422384,6.2096653257761592E-3,0.93961012080442396]
[null,9.9999999999999603E-2,0.83682722975809443,0.99122552490426163,8.7744750957383655E-3,0.91564002732893301,0.11202263076825786,null,0.99122552490426163,8.7744750957383655E-3,0.91564002732893301]
[null,0.2,0.93682722975809485,0.98777552734495533,1.2224472655044671E-2,0.88426537722533505,0.13795226956209858,null,0.98777552734495533,1.2224472655044671E-2,0.88426537722533505]
[null,0.3,1.0368272297580947,0.98320669355155121,1.6793306448448786E-2,0.84420567080232012,0.16724998241520012,null,0.98320669355155121,1.6793306448448786E-2,0.84420567080232012]
[null,0.4,1.1368272297580948,0.97724986805182079,2.2750131948179209E-2,0.79443104016705846,0.19962616353943391,null,0.97724986805182079,2.2750131948179209E-2,0.79443104016705846]
[null,0.5,1.2368272297580947,0.96960363823473861,3.0396361765261393E-2,0.73441639638467826,0.23457568267157999,null,0.96960363823473861,3.0396361765261393E-2,0.73441639638467826]
[null,0.6,1.3368272297580948,0.95994084313618289,4.0059156863817114E-2,0.6644230681837866,0.27137051949966845,null,0.95994084313618289,4.0059156863817114E-2,0.6644230681837866]
[null,0.7,1.4368272297580948,0.94791872058478044,5.2081279415219561E-2,0.58574825433198219,0.30906974363107348,null,0.94791872058478044,5.2081279415219561E-2,0.58574825433198219]
[null,0.8,1.5368272297580949,0.93319279873114191,6.6807201268858085E-2,0.50085704590820379,0.34654885357501425,null,0.93319279873114191,6.6807201268858085E-2,0.50085704590820379]
[null,0.9,1.6368272297580948,0.91543427764866436,8.4565722351335637E-2,0.41330599216708741,0.38254857609367476,null,0.91543427764866436,8.4565722351335637E-2,0.41330599216708741]
[null,1,1.7368272297580947,0.89435022633314476,0.10564977366685524,0.32739814342327372,0.41574100523381807,null,0.89435022633314476,0.10564977366685524,0.32739814342327372]
[null,1.1000000000000001,1.8368272297580948,0.86970548286319116,0.13029451713680884,0.24758371768190982,0.44480870977777592,null,0.86970548286319116,0.13029451713680884,0.24758371768190982]
[null,1.2,1.9368272297580948,0.84134474606854304,0.15865525393145696,0.17772145920802795,0.46853048332463265,null,0.84134474606854304,0.15865525393145696,0.17772145920802795]
[null,1.3,2.0368272297580949,0.80921304714748943,0.19078695285251057,0.12040063126627616,0.48586606846557545,null,0.80921304714748943,0.19078695285251057,0.12040063126627616]
[null,1.4,2.1368272297580946,0.77337264762313174,0.22662735237686826,7.6539933456223938E-2,0.49603170592068485,null,0.77337264762313174,0.22662735237686826,7.6539933456223938E-2]
[null,1.50000000000001,2.2368272297581049,0.73401447095129535,0.26598552904870465,4.5398993050072375E-2,0.49855887621875378,null,0.73401447095129535,0.26598552904870465,4.5398993050072375E-2]
[null,1.6,2.3368272297580948,0.69146246127401312,0.30853753872598688,2.4985386803259742E-2,0.49333010318079962,null,0.69146246127401312,0.30853753872598688,2.4985386803259742E-2]
[null,1.7,2.4368272297580948,0.64616976667272386,0.35383023332727614,1.2690137904000311E-2,0.48058800842807509,null,0.64616976667272386,0.35383023332727614,1.2690137904000311E-2]
[null,1.80000000000001,2.5368272297581047,0.59870632568291882,0.40129367431708118,5.9175027367363844E-3,0.46091664491530038,null,0.59870632568291882,0.40129367431708118,5.9175027367363844E-3]
[null,1.9000000000000099,2.6368272297581048,0.54973822483010792,0.45026177516989208,2.5209217031206183E-3,0.43519710973755943,null,0.54973822483010792,0.45026177516989208,2.5209217031206183E-3]
[null,2.0000000000000102,2.7368272297581049,0.49999999999999489,0.50000000000000511,9.7656249999990025E-4,0.40454213453796428,null,0.49999999999999489,0.50000000000000511,9.7656249999990025E-4]
[null,2.1,2.8368272297580948,0.45026177516988708,0.54973822483011292,3.4249228449753015E-4,0.37021641381215559,null,0.45026177516988708,0.54973822483011292,3.4249228449753015E-4]
[null,2.2000000000000099,2.9368272297581046,0.40129367431707147,0.59870632568292859,1.0829867396622452E-4,0.33355060004552894,null,0.40129367431707147,0.59870632568292859,1.0829867396622452E-4]
[null,2.30000000000001,3.0368272297581047,0.35383023332727148,0.64616976667272852,3.075738353748861E-5,0.29585705618799485,null,0.35383023332727148,0.64616976667272852,3.075738353748861E-5]
[null,2.4000000000000101,{"$f":"+B123+0.5*LN(10)*sigma^2","v":3.1368272297581048},{"$f":"NORMSDIST((m-B123)/sigma)","v":0.30853753872598239},{"$f":"1-D123","v":0.69146246127401767},{"$f":"+BINOMDIST(cm,n,$E123,1)","v":7.817719922486771E-6},{"$f":"NORMDIST($B123,meanlog,sigma,FALSE)","v":0.25835465187673362},null,{"$f":"NORMSDIST((alternative_m-B123)/sigma)","v":0.30853753872598239},0.69146246127401767,7.817719922486771E-6]
[null,2.5000000000000102,3.2368272297581049,0.26598552904869632,0.73401447095130368,1.7724749033707034E-6,0.22210830026536579,null,0.26598552904869632,{"$f":"1-I124","v":0.73401447095130368},{"$f":"+BINOMDIST($Q$23,$Q$22,$J124,1)","v":1.7724749033707034E-6}]
[null,2.6000000000000099,3.3368272297581045,0.22662735237686446,0.77337264762313551,3.5737424490573621E-7,0.18798683677552855,null,0.22662735237686446,0.77337264762313551,3.5737424490573621E-7]
[null,2.7000000000000099,3.4368272297581046,0.19078695285250719,0.80921304714749276,6.3897919433301337E-8,0.15664056480123337,null,0.19078695285250719,0.80921304714749276,6.3897919433301337E-8]
[null,2.80000000000001,3.5368272297581047,0.15865525393145408,0.84134474606854592,1.0105192360590722E-8,0.12849765122713941,null,0.15865525393145408,0.84134474606854592,1.0105192360590722E-8]
[null,2.9000000000000101,3.6368272297581048,0.13029451713680612,0.86970548286319382,1.41013732310513E-9,0.1037768029109406,null,0.13029451713680612,0.86970548286319382,1.41013732310513E-9]
[null,3.0000000000000102,3.7368272297581049,0.10564977366685292,0.89435022633314709,1.732549733365277E-10,8.25124596776632E-2,null,0.10564977366685292,0.89435022633314709,1.732549733365277E-10]
[null,3.1000000000000099,3.8368272297581045,8.4565722351333819E-2,0.91543427764866614,1.8704393441472862E-11,6.458816241256557E-2,null,8.4565722351333819E-2,0.91543427764866614,1.8704393441472862E-11]
[null,3.2000000000000099,3.9368272297581046,6.6807201268856475E-2,0.93319279873114347,1.7710579992316271E-12,4.9773762655467471E-2,null,6.6807201268856475E-2,0.93319279873114347,1.7710579992316271E-12]
[null,3.30000000000001,4.0368272297581047,5.2081279415218222E-2,0.94791872058478177,1.4683055641987165E-13,3.7762624067007304E-2,null,5.2081279415218222E-2,0.94791872058478177,1.4683055641987165E-13]
[null,3.4000000000000101,4.1368272297581052,4.005915686381599E-2,0.959940843136184,1.0641872304572015E-14,2.8205773003797643E-2,null,4.005915686381599E-2,0.959940843136184,1.0641872304572015E-14]
[null,3.5000000000000102,4.2368272297581049,3.0396361765260501E-2,0.9696036382347395,6.7331152246864742E-16,2.0740919049466209E-2,null,3.0396361765260501E-2,0.9696036382347395,6.7331152246864742E-16]
[null,3.6000000000000099,4.3368272297581045,2.275013194817856E-2,0.97724986805182146,3.7139769032541937E-17,1.5015235055012602E-2,null,2.275013194817856E-2,0.97724986805182146,3.7139769032541937E-17]
[null,3.7000000000000099,4.4368272297581051,1.6793306448448293E-2,0.98320669355155166,1.7838656042180305E-18,1.0701642103061517E-2,null,1.6793306448448293E-2,0.98320669355155166,1.7838656042180305E-18]
[null,3.80000000000001,4.5368272297581047,1.2224472655044305E-2,0.98777552734495566,7.4524888345074731E-20,7.5090130463545731E-3,null,1.2224472655044305E-2,0.98777552734495566,7.4524888345074731E-20]
[null,3.9000000000000101,4.6368272297581052,8.7744750957380619E-3,0.99122552490426197,2.705275233922416E-21,5.1871576065495488E-3,null,8.7744750957380619E-3,0.99122552490426197,2.705275233922416E-21]
[null,4.0000000000000098,4.7368272297581049,6.2096653257759224E-3,0.99379033467422406,8.5247557017761954E-23,3.5276880784505726E-3,null,6.2096653257759224E-3,0.99379033467422406,8.5247557017761954E-23]

{"sheet":"3-class counts","index":5,"n_rows":210,"n_cols":34,"rows_kept":210,"cut":false,"hidden":false,"merged":[[58,1,58,10],[0,1,1,6],[0,8,1,13],[52,1,52,10],[26,1,26,6],[35,1,35,20],[36,1,36,20],[0,33,1,38],[29,15,29,19],[0,15,1,20],[29,8,29,12],[17,18,17,19],[17,8,17,9],[17,11,17,12]]}
[null,{"$f":"\"Operating characteristic curve for proportion defective Pd and marginally acceptable Pm with n=\"&n&\" and c=\"&cm","v":"Operating characteristic curve for proportion defective Pd and marginally acceptable Pm with n=5 and c=2"},null,null,null,null,null,null,{"$f":"\"Probability density function (PDF) for log counts.  Distribution mean = \"&FIXED(meanlog,2)&\" and sigma = \"&FIXED(sigma,2)","v":"Probability density function (PDF) for log counts.  Distribution mean = 3.22 and sigma = 0.80"},null,null,null,null,null,null,{"$f":"\"Operating characteristic curve scaled to relate log arithmetic mean count to m\"","v":"Operating characteristic curve scaled to relate log arithmetic mean count to m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Operating characteristic curve scaled to relate mean log count to m\"","v":"Operating characteristic curve scaled to relate mean log count to m"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"INPUTS",null,null,"P(accept)",null,null,null,"ALTERNATIVE n AND c",null,null,"P(accept)"]
[null,null,"Lot acceptance for Pd",null,null,null,null,null,"mean",3.2151023903293385,null,"Computed",{"$f":"$S$55*100","v":4.9995265397214332},"%",null,"mean",{"$f":"meanlog","v":3.2151023903293385},null,"Computed",{"$f":"S57*100","v":4.9995265397214332},"%",null,null,null,"Coordinates to place m"]
[null,null,null,null,null,"P(accept)",null,null,"sigma",0.8,null,"Desired",5,"%",null,"sigma",{"$f":"sigma","v":0.8},null,"Target, left",{"$f":"computed_P","v":4.9995265397214332},"%",null,null,null,"proportion","m"]
[null,null,"Pd",20,"%",{"$f":"$S$56*100","v":26.869562500000004},"%",null,"m",{"$f":"LOG(500)","v":2.6989700043360187},null,null,null,null,null,"m",{"$f":"+m","v":2.6989700043360187},null,null,null,null,null,null,null,0,{"$f":"m","v":2.6989700043360187},0]
[null,null,"Pm",25,"%",null,null,null,"M",{"$f":"LOG(5000)","v":3.6989700043360187},null,null,null,null,null,"M",{"$f":"+BigM","v":3.6989700043360187},null,null,null,null,null,null,null,{"$f":"1.1*NORMDIST(meanlog,meanlog,sigma,FALSE)","v":0.54854563555197},{"$f":"m","v":2.6989700043360187},1]
[null,null,"actualPd",{"$f":"+Pd*100","v":27.264447807101135},"%",null,null,null,"n",5,null,null,null,null,null,"n",{"$f":"n","v":5}]
[null,null,"actualPm",{"$f":"+Pm*100","v":46.794554579600273},"%",{"$f":"+computed_P","v":4.9995265397214332},"%",null,"c",2,null,null,null,null,null,"c",{"$f":"cm","v":2},null,null,null,null,null,null,null,"Coordinates to place M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"proportion","M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"BigM","v":3.6989700043360187},0]
[null,"Sandbox: for your own calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1.1*NORMDIST(meanlog,meanlog,sigma,FALSE)","v":0.54854563555197},{"$f":"BigM","v":3.6989700043360187},1]
[null,"FSO",5,null,null,null,null,null,null,null,null,"P(reject)",{"$f":"100-computed_P","v":95.00047346027857},"%"]
[null,"complient",{"$f":"_xlfn.NORM.DIST(C28,meanlog,sigma,1)","v":0.98716347597880827},"not comply",{"$f":"1-_xlfn.NORM.DIST(C28,meanlog,sigma,1)","v":1.2836524021191731E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coordinates to place Pd"]
[null,"%",{"$f":"100*C29","v":98.716347597880826},"%",{"$f":"100*E29","v":1.2836524021191731},null,null,null,"Means",null,null,null,null,null,null,"Implied Acceptance level ",null,null,null,null,null,null,null,null,"p accept"]
[null,null,null,null,null,null,null,null,"Arithmetic (=Average)",null,null,"Geometric (=Median)",null,null,null,"Percentile","z-score","Concentration at this percentile",null,null,null,null,null,null,"x","y"]
[null,null,null,null,null,null,null,null,{"$f":"10^(meanlog+0.5*sigma^2*LN(10))","v":8952.1967830858921},"cfu/g",null,{"$f":"10^meanlog","v":1640.9766082561537},"cfu/g",null,null,99.9,{"$f":"+TINV(2*(1-P32/100),1000)","v":3.0984021639129624},null,{"$f":"+meanlog+Q32*sigma","v":5.6938241214597092},null,null,null,null,null,{"$f":"+Pd","v":0.27264447807101133},0]
[null,null,null,null,null,null,null,null,{"$f":"+LOG(I32)","v":3.9519296200874336},"log cfu/g",null,{"$f":"+LOG(L32)","v":3.215102390329339},"log cfu/g",null,null,"FSO","P(exceedance)",null,"target level",null,null,null,null,null,{"$f":"+Pd","v":0.27264447807101133},{"$f":"+desired_P","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+S32","v":5.6938241214597092},{"$f":"1-_xlfn.NORM.DIST(P34,meanlog,sigma,1)","v":9.7283600143704962E-4},null,{"$f":"+P34-Q32*sigma","v":3.215102390329339}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(ABS(computed_P-desired_P)<0.001,\"This sampling plan would provide \"&FIXED(M28,0)&\" % confidence that a lot of food containing a geometric mean concentration of \"&FIXED(L32,1)&\" cfu/g and an arithmetic mean concentration of \"&FIXED(I32,1)&\" cfu/g (having a\",\"\")","v":"This sampling plan would provide 95 % confidence that a lot of food containing a geometric mean concentration of 1,641.0 cfu/g and an arithmetic mean concentration of 8,952.2 cfu/g (having a"}]
[null,{"$f":"IF(ABS(computed_P-desired_P)<0.001,\"standard deviation of \"&FIXED(sigma,2)&\" log cfu/g), would be rejected (i.e. either more than \"& cm&\" out of \"&n&\" samples having levels between [\"&FIXED(m,1)&\",\"&FIXED(BigM,1)&\"] logs cfu/g or 1 or more samples higher than \"&FIXED(BigM,1)&\" log cfu/g)\",\"\")","v":"standard deviation of 0.80 log cfu/g), would be rejected (i.e. either more than 2 out of 5 samples having levels between [2.7,3.7] logs cfu/g or 1 or more samples higher than 3.7 log cfu/g)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10]
[null,"The calculations below are for the buttons above.  Do not edit."]
[null,"geo mean","arith mean","pa","pm","pd",null,null,null,null,null,null,null,null,null,null,null,null,"P(accept)"]
[null,{"$f":"meanlog","v":3.2151023903293385},{"$f":"+B55+0.5*LN(10)*sigma^2","v":3.9519296200874332},{"$f":"NORMSDIST((m-B55)/sigma)","v":0.25940997613298594},{"$f":"NORMSDIST((BigM-B55)/sigma)-NORMSDIST((m-B55)/sigma)","v":0.46794554579600273},{"$f":"1-(D55+Pm)","v":0.27264447807101133},{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D55^(n-G$52)*$E55^G$52)","v":1.1747173109778377E-3},1.0595269723931752E-2,3.8225278362304736E-2,0,0,0,0,0,0,0,0,null,{"$f":"IF($D55>0.9999999,1,IF($D55=0,0,SUM(G55:Q55)))","v":4.9995265397214328E-2},null,"<= Used by macros for finding mean and n"]
[null,null,null,{"$f":"1-(F56+E56)","v":0.55000000000000004},{"$f":"$D$22/100","v":0.25},{"$f":"D21/100","v":0.2},5.0328437500000017E-2,0.11438281250000003,0.10398437500000003,0,0,0,0,0,0,0,0,null,{"$f":"IF($D56>0.9999999,1,IF($D56=0,0,SUM(G56:Q56)))","v":0.26869562500000005},null,"<= Used in test against ICMSF tables"]
[null,{"$f":"meanlog","v":3.2151023903293385},{"$f":"+B57+0.5*LN(10)*sigma^2","v":3.9519296200874332},{"$f":"NORMSDIST((alternative_m-B57)/sigma)","v":0.25940997613298594},{"$f":"NORMSDIST((alternative_bigM-B57)/sigma)-NORMSDIST((alternative_m-B57)/sigma)","v":0.46794554579600273},{"$f":"1-(D57+E57)","v":0.27264447807101133},{"$f":"IF(G$52>alternative_c,0,(COMBIN(alternative_n,G$52))*$D57^(alternative_n-G$52)*$E57^G$52)","v":1.1747173109778377E-3},1.0595269723931752E-2,3.8225278362304736E-2,0,0,0,0,0,0,0,0,null,{"$f":"IF($D57>0.9999999,1,IF($D57=0,0,SUM(G57:Q57)))","v":4.9995265397214328E-2},null,"<= Used by macro for finding m in equivalent performance criterion"]
[]
[null,"The calculations below are for the charts above.  Do not edit."]
[null,0,{"$f":"+B60+0.5*LN(10)*sigma^2","v":0.73682722975809478},{"$f":"NORMSDIST((m-B60)/sigma)","v":0.99962919110600967},{"$f":"NORMSDIST((BigM-B60)/sigma)-NORMSDIST((m-B60)/sigma)","v":3.6892423297951726E-4},{"$f":"1-(E60+D60)","v":1.8846610108091966E-6},{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D60^(n-G$52)*$E60^G$52)","v":0.99814733001264211},1.8418866785894787E-3,1.3595373888231163E-6,0,0,0,0,0,0,0,0,null,{"$f":"IF($D60>0.9999999,1,IF($D60=0,0,SUM(G60:Q60)))","v":0.99999057622862042},{"$f":"NORMDIST($B60,meanlog,sigma,FALSE)","v":1.5509307727078059E-4}]
[null,0.1,0.83682722975809476,0.99942035709674237,5.7622459142880889E-4,{"$f":"1-(E61+D61)","v":3.4183118288177994E-6},0.99710514339571088,2.8744486730979267E-3,3.3145772956846113E-6,0,0,0,0,0,0,0,0,null,0.99998290664610445,2.5431475269493839E-4]
[null,0.2,0.93682722975809485,0.99910707572277335,8.8681671603851875E-4,6.1075611881289404E-6,0.99554334463528527,4.4182675761994059E-3,7.8433906389265163E-6,0,0,0,0,0,0,0,0,null,0.99996945560212369,4.1054885376096216E-4]
[null,0.3,1.0368272297580947,0.99864438495531083,1.3448649130499701E-3,1.0750131639203353E-5,0.99324027680289761,6.6879362595126043E-3,1.8013160543701765E-5,0,0,0,0,0,0,0,0,null,0.99994622622295393,6.5248762968514798E-4]
[null,0.4,1.1368272297580948,0.99797160970245546,2.009749588489318E-3,1.8640709055217641E-5,0.98989910881344967,9.9674645412855291E-3,4.0145646560232345E-5,0,0,0,0,0,0,0,0,null,0.99990671900129535,1.0209250725850452E-3]
[null,0.5,1.2368272297580947,0.99700850810469543,2.9596479033809908E-3,3.1843991923574677E-5,0.98513176345193898,1.4621957257903256E-2,8.681138584052173E-5,0,0,0,0,0,0,0,0,null,0.9998405320956828,1.5726410424087263E-3]
[null,0.6,1.3368272297580948,0.99565114161203516,4.2952634606853168E-3,5.3594927279521087E-5,0.97844401305897688,2.1105157429007107E-2,1.8209633424424675E-4,0,0,0,0,0,0,0,0,null,0.99973126682222824,2.3849511624367868E-3]
[null,0.7,1.4368272297580948,0.99376773073002778,6.1433969222061124E-3,8.8872347766111304E-5,0.96922465229951638,2.9958367341476513E-2,3.7040072046763992E-4,0,0,0,0,0,0,0,0,null,0.99955342036146055,3.5607667313673997E-3]
[null,0.8,1.5368272297580949,0.99119487187772715,8.6599259256079364E-3,1.4520219666491752E-4,0.95674286556233001,4.1794618700598564E-2,7.3030705122707729E-4,0,0,0,0,0,0,0,0,null,0.99926779131415566,5.2338552297448654E-3]
[null,0.9,1.6368272297580948,0.98773460347975184,1.2031641331934795E-2,2.3375518831336706E-4,0.94015907774343799,5.7260608155880667E-2,1.3949882840044484E-3,0,0,0,0,0,0,0,0,null,0.99881467418332304,7.5738035568624369E-3]
[null,1,1.7368272297580947,0.98315290447610038,1.6476286629909298E-2,3.7080889399032646E-4,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D70^(n-G$52)*$E70^G$52)","v":0.91855535387523957},7.6968603901704263E-2,2.5797752793380729E-3,0,0,0,0,0,0,0,0,null,0.99810373305628186,1.0789976929394075E-2]
[null,1.1000000000000001,1.8368272297580948,0.97718026541973158,2.2240091677010798E-2,5.7964290325762668E-4,0.89099124807479879,0.10139238245916826,4.6152710222281384E-3,0,0,0,0,0,0,0,0,null,0.99699890155619519,1.5133561443274735E-2]
[null,1.2,1.9368272297580948,0.96951496931927672,2.9592106403496632E-2,8.9292427722664769E-4,0.85658920086196555,0.13072659823804042,7.9802283146662729E-3,0,0,0,0,0,0,0,0,null,0.99529602741467227,2.0896614038079409E-2]
[null,1.3,2.0368272297580949,0.9598296363527058,3.8814748602605031E-2,1.3556150446891735E-3,0.81464946544930483,0.16471888866037201,1.3322202214442606E-2,0,0,0,0,0,0,0,0,null,0.9926905563241194,2.8406965710447457E-2]
[null,1.4,2.1368272297580946,0.94778140959043611,5.0190200112019356E-2,2.0283902975445356E-3,0.76478776151316286,0.20249843690306285,2.1446795574789266E-2,0,0,0,0,0,0,0,0,null,0.988732993991015,3.8017882269562299E-2]
[null,1.5,2.2368272297580947,0.93302588445075707,6.3982623653938364E-2,2.9914918953045655E-3,0.70707985077665325,0.24244141957624976,3.325103486492275E-2,0,0,0,0,0,0,0,0,null,0.98277230521782577,5.009162776090785E-2]
[null,1.6,2.3368272297580948,0.9152345234914917,8.0416618120543459E-2,4.3488583879648379E-3,0.64218767868836202,0.28212747658267479,4.9577975837517538E-2,0,0,0,0,0,0,0,0,null,0.97389313110855436,6.4976530278485531E-2]
[null,1.7,2.4368272297580948,0.89411487735988104,9.9652853370146732E-2,6.2322692699722237E-3,0.57143469628623744,0.31844396867532693,7.0983831989716653E-2,0,0,0,0,0,0,0,0,null,0.96086249695128112,8.2977823101259923E-2]
[null,1.8,2.5368272297580949,0.86943249525133481,0.12176237662639233,8.8051281222728539E-3,0.49679742953174361,0.34787770213362573,9.7439228504735215E-2,0,0,0,0,0,0,0,0,null,0.94211436017010453,0.10432339367389969]
[null,1.9,2.6368272297580946,0.8410330095218137,0.14670159395793814,1.2265396520248162E-2,0.42078980425622431,0.36699234338456599,0.12802912878648054,0,0,0,0,0,0,0,0,null,0.91581127642727078,0.12912654306350724]
[null,2,2.7368272297580947,0.80886258053504423,0.17429032394105615,1.6847095523899625E-2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D80^(n-G$52)*$E80^G$52)","v":0.34623719690848831},0.37302871131525395,0.16075733134160861,0,0,0,0,0,0,0,0,null,0.88002323956535089,0.15734882027278993]
[null,2.1,2.8368272297580948,0.77298474766652636,0.20419551775320521,2.2819734580268425E-2,0.27596539275478527,0.3645019932517502,0.19257733987327302,0,0,0,0,0,0,0,0,null,0.8330447258798086,0.18876679692471154]
[null,2.2000000000000002,2.9368272297580948,0.73359179556240384,0.23592317375687288,3.048503068072328E-2,0.21245762770721482,0.34163194109276557,0.21973771322656524,0,0,0,0,0,0,0,0,null,0.7738272820265456,0.22294712216097853]
[null,2.2999999999999998,3.0368272297580945,0.69100903326839047,0.26882060308431543,4.0170363647294094E-2,0.15755007846241265,0.30645552423478256,0.23843844255887461,0,0,0,0,0,0,0,0,null,0.70244404525606985,0.25923419254924196]
[null,2.4,3.1368272297580946,0.64569088979303235,0.30209051979740376,5.2218590409563892E-2,0.11223370359599961,0.26254619969139553,0.24566776204951338,0,0,0,0,0,0,0,0,null,0.62044766533690854,0.29675418019132166]
[null,2.5,3.2368272297580947,0.59820841258758684,0.33481747186317024,6.697411554924293E-2,7.660596382203122E-2,0.21438193275808012,0.23997929560608117,0,0,0,0,0,0,0,0,null,0.53096719218619248,0.33443795228810946]
[null,2.6,3.3368272297580948,0.54922854508240704,0.36600597840908466,8.4765476508508297E-2,4.9976461548003691E-2,0.16652160444024791,0.22194004046260482,0,0,0,0,0,0,0,0,null,0.43843810645085646,0.37106365211865344]
[null,2.7,3.4368272297580948,0.49948636411816366,0.39462851324171738,0.10588512264011896,3.1089818225603121E-2,0.12281545227951951,0.19406527512214583,0,0,0,0,0,0,0,0,null,0.34797054562726848,0.4053175627585715]
[null,2.8,3.5368272297580945,0.44975217744180895,0.41968031780952586,0.13056750474866519,1.8402057065651862E-2,8.585818529651297E-2,0.16023486844130663,0,0,0,0,0,0,0,0,null,0.26449511080347143,0.43586959907418027]
[null,2.9,3.6368272297580946,0.40079592146103038,0.44023708806078332,0.1589669904781863,1.0342284188771488E-2,5.6800192209597339E-2,0.12477946945414327,0,0,0,0,0,0,0,0,null,0.1919219458525121,0.46145768629795869]
[null,3,3.7368272297580947,0.35335158759851737,0.45551099293652686,0.19113741946495577,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D90^(n-G$52)*$E90^G$52)","v":5.5085238566182403E-3},3.5505616213527512E-2,9.1541677263515558E-2,0,0,0,0,0,0,0,0,null,0.13255581733366131,0.48097370964052083]
[null,3.1,3.8368272297580948,0.30808440251944103,0.46490034514708534,0.22701525233347364,2.775546825463836E-3,2.0941545021069499E-2,6.320171633871717E-2,0,0,0,0,0,0,0,0,null,8.691880818525051E-2,0.49354293662206811]
[null,3.2,{"$f":"+B92+0.5*LN(10)*sigma^2","v":3.9368272297580948},{"$f":"NORMSDIST((m-B92)/sigma)","v":0.2655631936431202},{"$f":"NORMSDIST((BigM-B92)/sigma)-NORMSDIST((m-B92)/sigma)","v":0.46802860191928364},0.26640820443759616,1.3208071583464182E-3,1.1638953411529564E-2,4.1024985565750897E-2,0,0,0,0,0,0,0,0,null,{"$f":"IF($D92>0.9999999,1,IF($D92=0,0,SUM(G92:Q92)))","v":5.3984746135626878E-2},{"$f":"NORMDIST($B92,meanlog,sigma,FALSE)","v":0.49858899940406087}]
[null,3.3,4.0368272297580949,0.22623982680374452,0.46476920646464592,0.30899096673160953,5.9271415389753007E-4,6.0881253946124319E-3,2.5013926579477447E-2,0,0,0,0,0,0,0,0,null,3.1694766127987412E-2,0.49587771617878929]
[null,3.4,4.1368272297580946,0.19043688083858112,0.45525400895445123,0.35430911020696765,2.5046975894615442E-4,2.9938361041195625E-3,1.4313990888228009E-2,0,0,0,0,0,0,0,0,null,1.7558296751293726E-2,0.48553511123346049]
[null,3.5,4.2368272297580951,0.15834391848552362,0.43986449410206319,0.40179158741241316,9.9542132492822178E-5,1.3825933502712565E-3,7.6814282529144625E-3,0,0,0,0,0,0,0,0,null,9.163563735678542E-3,0.46803770239447012]
[null,3.6,4.3368272297580948,0.13002192464250803,0.41920662043989898,0.45077145491759296,3.7160620048273003E-5,5.9905196707089729E-4,3.8628339224193236E-3,0,0,0,0,0,0,0,0,null,4.4990465095384943E-3,0.44417609840693206]
[null,3.7,4.4368272297580953,0.10541480315207737,0.39407156096608631,0.50051363588183628,1.3016913249955053E-5,2.4330526500958668E-4,1.819093385494894E-3,0,0,0,0,0,0,0,0,null,2.0754155637544357E-3,0.41499577950963051]
[null,3.8,4.5368272297580949,8.4366321507078942E-2,0.36538585593473,0.55024782255819105,4.2741087516372978E-6,9.2554638905530378E-5,8.0169800823636699E-4,0,0,0,0,0,0,0,0,null,8.9852675589353469E-4,0.38172123802019947]
[null,3.9,4.6368272297580946,6.6640609029206294E-2,0.33415531243182406,0.59920407853896962,1.314300845227328E-6,3.2951425261875265E-5,3.3045597763460219E-4,0,0,0,0,0,0,0,0,null,3.6472170374170476E-4,0.34567113538405958]
[null,4,4.7368272297580951,5.194425539966202E-2,0.30140733219885535,0.64664841240148263,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D100^(n-G$52)*$E100^G$52)","v":3.7817048109781865E-7},1.09716998489108E-5,1.2732691057761532E-4,0,0,0,0,0,0,0,0,null,1.3867678090762395E-4,0.30817262470472156]
[null,4.0999999999999996,4.8368272297580948,3.9948200359974331E-2,0.26813620215946693,0.69191559748055875,1.0173867963502038E-7,3.414399512898432E-6,4.5835562543188739E-5,0,0,0,0,0,0,0,0,null,4.935170073572219E-5,0.27048248460793101]
[null,4.2,4.9368272297580953,3.03079066430147E-2,0.23525528700010551,0.7344368063568798,2.5572883734399978E-8,9.9250604359096962E-7,1.5408011967606321E-5,0,0,0,0,0,0,0,0,null,1.6426090894931689E-5,0.23372134975588313]
[null,4.3,5.0368272297580949,2.268070831153382E-2,0.2035591184922107,0.77376017319625545,6.0018213844183309E-9,2.6933141892632407E-7,4.8344933029290576E-6,0,0,0,0,0,0,0,0,null,5.1098265432398001E-6,0.19882535796748257]
[null,4.4000000000000004,5.1368272297580955,1.6739664334776843E-2,0.17369721650380412,0.80956311916141899,1.3144186911196198E-9,6.8194577681504945E-8,1.4152265047897403E-6,0,0,0,0,0,0,0,0,null,1.4847355011623649E-6,0.16651728032075699]
[null,4.5,5.2368272297580951,1.2183667169100815E-2,0.1461602513164228,0.84165608151447635,2.6846651958266258E-10,1.6103170510009608E-8,3.8636043090594663E-7,0,0,0,0,0,0,0,0,null,4.0273206793553888E-7,0.1372969829288653]
[null,4.5999999999999996,5.3368272297580948,8.7439156568450086E-3,0.1212780089856631,0.86997807535749194,5.1112814869594538E-11,3.5446707541057765E-9,9.8329084688991919E-8,0,0,0,0,0,0,0,0,null,1.0192486825796729E-7,0.11144916712516177]
[null,4.7,5.4368272297580953,6.1871340207431819E-3,9.9227669131334184E-2,0.89458519684792259,9.0666659984340117E-12,7.270443235920583E-10,2.3320300915848537E-8,0,0,0,0,0,0,0,0,null,2.4056411905439028E-8,8.9064946112824839E-2]
[null,4.8,5.5368272297580949,4.3160937049616984E-3,8.0050227802117249E-2,0.9156336784929211,1.4978017184520012E-12,1.3889801399197077E-10,5.1522596224159581E-9,0,0,0,0,0,0,0,0,null,5.2926554381263807E-9,7.007303699202018E-2]
[null,4.9000000000000004,5.6368272297580955,2.9680760279836215E-3,6.3672533001222609E-2,0.93335939097079379,2.3034304652733054E-13,2.470712524432434E-11,1.0600572442568595E-9,0,0,0,0,0,0,0,0,null,1.0849947125477112E-9,5.4276173244192358E-2]
[null,5,5.7368272297580951,2.0119151740298187E-3,4.9932340225632199E-2,0.94805574460033792,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D110^(n-G$52)*$E110^G$52)","v":3.2964639498501499E-14},4.0906336810353388E-12,2.0304525293754704E-10,0,0,0,0,0,0,0,0,null,2.0716885125808088E-10,4.1388686919705667E-2]
[null,5.0999999999999996,5.8368272297580948,1.3442030578473254E-3,3.8603997302127005E-2,0.96005179964002563,4.3885837945257677E-15,6.3017590971465186E-13,3.6195884210304994E-11,0,0,0,0,0,0,0,0,null,3.6830448703814169E-11,3.1071929685982644E-2]
[null,5.2,5.9368272297580953,8.8514197670094537E-4,2.9422764666313755E-2,0.96969209335698525,5.4333125122869806E-16,9.0303634679823358E-14,6.0035173150417688E-12,0,0,0,0,0,0,0,0,null,6.0943642809728207E-12,2.2965132276009152E-2]
[null,5.3,6.0368272297580949,5.7441811270190167E-4,2.210629019883192E-2,0.97731929168846621,6.2537516242140695E-17,1.2033677662601587E-14,9.2622417255399124E-13,0,0,0,0,0,0,0,0,null,9.3832038773283499E-13,1.6710283797341918E-2]
[null,5.4,6.1368272297580955,3.6735551751540291E-4,1.6372308817261441E-2,0.9832603356652232,6.6901034856551116E-18,1.4908233994605795E-15,1.3288610038064672E-13,0,0,0,0,0,0,0,0,null,1.3438361388359296E-13,1.1970515380223982E-2]
[null,5.5,6.2368272297580951,2.3150803284924124E-4,1.1952159136251575E-2,0.9878163328308992,6.6501328861705292E-19,1.7166455425866371E-16,1.7725191176319619E-14,0,0,0,0,0,0,0,0,null,1.7897520743866898E-14,8.4422074711459419E-3]
[null,5.6,6.3368272297580948,1.4376261447686435E-4,8.6001530423681447E-3,0.99125608434315504,6.1408686961504438E-20,1.8367922283606152E-17,2.1976080955978806E-15,0,0,0,0,0,0,0,0,null,2.2160374265684484E-15,5.8615617106842419E-3]
[null,5.7,6.4368272297580953,8.7964414429567202E-5,6.0991696063136145E-3,0.99381286597925678,5.2666575434788784E-21,1.8258654834659796E-18,2.5319928141827358E-16,0,0,0,0,0,0,0,0,null,2.5503041355928301E-16,4.0066814098764945E-3]
[null,5.8,6.5368272297580949,5.3031178502587719E-5,4.2630625264591104E-3,0.99568390629503833,4.1942700799486643E-22,1.685841811228588E-19,2.7104240388079839E-17,0,0,0,0,0,0,0,0,null,2.7273243996210692E-17,2.69631376671491E-3]
[null,5.9,6.6368272297580955,3.149937911483839E-5,2.9365766488687831E-3,0.99703192397201634,3.1010585595570918E-23,1.4455040716152131E-20,2.695185506402806E-18,0,0,0,0,0,0,0,0,null,2.7096715577045535E-18,1.7863649789287284E-3]
[null,6,6.7368272297580951,1.8433317355640906E-5,1.9934818566741778E-3,0.99798808482597023,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D120^(n-G$52)*$E120^G$52)","v":2.128224805158953E-24},1.1507905642144251E-21,2.4890583353313445E-19,0,0,0,0,0,0,0,0,null,2.5005875232215405E-19,1.1651560954684854E-3]
[null,6.1,6.8368272297580948,1.0627256088175803E-5,1.3335758017591496E-3,0.99865579694215267,1.355519376979285E-25,8.5049603818548213E-23,2.1345132301425008E-20,0,0,0,0,0,0,0,0,null,2.1430317457181253E-20,7.4819047631692549E-4]
[null,6.2,6.9368272297580953,6.0358884925267404E-6,8.7910608820841859E-4,0.99911485802329902,8.0113561671830592E-27,5.8341302942364519E-24,1.6994414218932708E-21,0,0,0,0,0,0,0,0,null,1.7052835635436744E-21,4.7299264634359658E-4]
[null,6.3,7.0368272297580949,3.3771536498663961E-6,5.7104095905203525E-4,0.99942558188729813,4.3929281551823087E-28,3.7139884157791195E-25,1.2559923099374295E-22,0,0,0,0,0,0,0,0,null,1.2597106912813638E-22,2.9438166038245166E-4]
[null,6.4,{"$f":"+B124+0.5*LN(10)*sigma^2","v":7.1368272297580955},{"$f":"NORMSDIST((m-B124)/sigma)","v":1.8613922788401506E-6},{"$f":"NORMSDIST((BigM-B124)/sigma)-NORMSDIST((m-B124)/sigma)","v":3.6549412523656277E-4},0.99963264448248457,2.2345472405639131E-29,2.1938252841002008E-26,8.6153817467609123E-24,0,0,0,0,0,0,0,0,null,{"$f":"IF($D124>0.9999999,1,IF($D124=0,0,SUM(G124:Q124)))","v":8.6373423450743205E-24},{"$f":"NORMDIST($B124,meanlog,sigma,FALSE)","v":1.803770421113702E-4}]
[null,6.5,7.2368272297580951,1.0106275413423124E-6,2.3049740530789892E-4,{"$f":"1-(E125+D125)","v":0.99976849196715079},1.0542792202171875E-30,1.202265992114827E-27,5.4841013199447467E-25,0,0,0,0,0,0,0,0,null,5.4961345226580974E-25,1.0880927587542264E-4]
[null,6.6,7.3368272297580948,5.4050512752739217E-7,1.4322210934933696E-4,0.99985623738552309,4.6131660934042399E-32,6.1119436710867446E-29,3.2390644240577025E-26,0,0,0,0,0,0,0,0,null,3.2451809808948826E-26,6.461966882905304E-5]
[null,6.7,7.4368272297580953,2.8474357701173606E-7,8.7679670852555471E-5,0.9999120355855704,1.8718441314955632E-33,2.881938182051671E-30,1.7748417286286167E-27,0,0,0,0,0,0,0,0,null,1.7777255386548E-27,3.7781368488174845E-5]
[null,6.8,7.5368272297580949,1.4775562621180796E-7,5.2883422876375913E-5,0.99994696882149736,7.0423910071406369E-35,1.2602760085681346E-31,9.0213429851422668E-29,0,0,0,0,0,0,0,0,null,9.033952787618955E-29,2.1747272175753175E-5]
[null,6.9,7.6368272297580955,7.5519859294255337E-8,3.1423859255544138E-5,0.99996850062088516,2.4564383028567559E-36,5.1106273383092868E-33,4.2530702701874182E-30,0,0,0,0,0,0,0,0,null,4.2581833539640304E-30,1.2323839791716653E-5]
[null,7,7.7368272297580951,3.8018673173688906E-8,1.8395298682467217E-5,0.99998156668264437,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D130^(n-G$52)*$E130^G$52)","v":7.9430039959267054E-38},1.9216074463406255E-34,1.8595358530477127E-31,0,0,0,0,0,0,0,0,null,1.8614582547944529E-31,6.8754550430373535E-6]
[null,7.1,7.8368272297580948,1.8851392211664078E-8,1.0608404695964139E-5,0.99998937274391186,2.3807683811054456E-39,6.6987504664231117E-36,7.5392899481583618E-33,0,0,0,0,0,0,0,0,null,7.5459910793931663E-33,3.7763392119793583E-6]
[null,7.2,7.9368272297580953,9.2064685772794946E-9,6.0266820239494612E-6,0.99999396411150743,6.6140180532844926E-41,2.1648139768911066E-37,2.8342345102707015E-34,0,0,0,0,0,0,0,0,null,2.8363999856493978E-34,2.0419951128380512E-6]
[null,7.3,8.036827229758094,4.4283178192113992E-9,3.3727253320471847E-6,0.99999662284635016,1.7029186924428709E-42,6.4849421912557584E-39,9.8782109587630538E-36,0,0,0,0,0,0,0,0,null,9.8846976038730026E-36,1.0870575764019167E-6]
[null,7.4,8.1368272297580955,2.097847026473645E-9,1.8592944318136769E-6,0.99999813860772113,4.0632082612603131E-44,1.8005842180398708E-40,3.1916685710307419E-37,0,0,0,0,0,0,0,0,null,3.1934695615696079E-37,5.697240395069023E-7]
[null,7.5,8.2368272297580951,9.787951182167646E-10,1.0096487462240957E-6,0.99999898937245868,8.9837772070593479E-46,4.6334821377068463E-42,9.5590779805083275E-39,0,0,0,0,0,0,0,0,null,9.5637123610237548E-39,2.9396166005757591E-7]
[null,7.6,8.3368272297580948,4.4976604235428333E-10,5.4005536148503784E-7,0.99999945949487246,1.8404893723870367E-47,1.1049813233019697E-43,2.6536066834498656E-40,0,0,0,0,0,0,0,0,null,2.654711848822105E-40,1.4932447150063534E-7]
[null,7.7,8.4368272297580944,2.0354136124978769E-10,2.8454003565048626E-7,0.99999971525642295,3.493521122219424E-49,2.4418786888286044E-45,6.8272339823921506E-42,0,0,0,0,0,0,0,0,null,6.8296762104330915E-42,7.4676753669110188E-8]
[null,7.8,8.536827229758094,9.0716100102054541E-11,1.4766491011170589E-7,0.99999985224437382,6.1435848087765295E-51,5.0001702979462739E-47,1.6278250426524585E-43,0,0,0,0,0,0,0,0,null,1.6283251211181012E-43,3.676664676645381E-8]
[null,7.9,8.6368272297580955,3.9817736142414901E-11,7.5480041558112922E-8,0.99999992448014074,1.0008818683902772E-52,9.4865520167513487E-49,3.5966150255581283E-45,0,0,0,0,0,0,0,0,null,3.5975637808479902E-45,1.7821192603855449E-8]
[null,8,8.7368272297580951,1.7211721754808318E-11,3.80014614519341E-8,0.99999996198132679,1.5105029690139819E-54,1.6675066320422313E-50,7.3633178482791492E-47,0,0,0,0,0,0,0,0,null,7.3649855059614884E-47,8.5042036925651518E-9]
[]
[null,"Calculations for 3-dimensional OC graph"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table for OC graph"]
[null,null,"pa","pm","pd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pm"]
[null,null,{"$f":"1-(D145+E145)","v":0},1,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C145^(n-G$52)*$D145^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF($C145>0.9999999,1,IF($C145=0,0,SUM(F145:P145)))","v":0},null,null,"Pd",0,0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1]
[null,null,{"$f":"1-(D146+E146)","v":0},0.9,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C146^(n-G$52)*$D146^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0,null,null,1,null,{"$f":"+S200","v":-6.0000000000982672E-25}]
[null,null,9.9999999999999978E-2,0.9,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C147^(n-G$52)*$D147^G$52)","v":9.9999999999999873E-6},4.4999999999999955E-4,8.0999999999999944E-3,0,0,0,0,0,0,0,0,null,null,8.5599999999999947E-3,null,null,0.9,null,9.9999999999000272E-6,{"$f":"+S190","v":0}]
[null,null,0,0.8,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C148^(n-G$52)*$D148^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0,null,null,0.8,null,3.1999999999960001E-4,1.5999999999999988E-4,{"$f":"+S181","v":0}]
[null,null,9.9999999999999978E-2,0.8,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C149^(n-G$52)*$D149^G$52)","v":9.9999999999999873E-6},3.9999999999999959E-4,6.3999999999999968E-3,0,0,0,0,0,0,0,0,null,null,6.8099999999999966E-3,null,null,0.7,null,2.4299999999991039E-3,1.9200000000000027E-3,5.1000000000000155E-4,{"$f":"+S173","v":0}]
[null,null,0.19999999999999996,0.8,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C150^(n-G$52)*$D150^G$52)","v":3.1999999999999959E-4},6.3999999999999934E-3,5.1199999999999975E-2,0,0,0,0,0,0,0,0,null,null,5.7919999999999972E-2,null,null,0.6,null,1.023999999999841E-2,9.1800000000000059E-3,5.1199999999999961E-3,1.060000000000003E-3,{"$f":"+S166","v":0}]
[null,null,0,0.7,0.3,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C151^(n-G$52)*$D151^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0,null,null,0.5,null,3.1249999999997516E-2,2.9440000000000015E-2,2.1330000000000016E-2,9.9199999999999913E-3,1.8099999999999991E-3,{"$f":"+S160","v":0}]
[null,null,0.10000000000000009,0.7,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C152^(n-G$52)*$D152^G$52)","v":1.0000000000000045E-5},3.5000000000000119E-4,4.900000000000012E-3,0,0,0,0,0,0,0,0,null,null,5.2600000000000129E-3,null,null,0.4,null,7.7759999999996415E-2,7.4999999999999997E-2,6.1439999999999953E-2,3.8880000000000019E-2,1.6319999999999991E-2,2.7599999999999981E-3,{"$f":"+S155","v":0}]
[null,null,0.20000000000000007,0.7,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C153^(n-G$52)*$D153^G$52)","v":3.2000000000000057E-4},5.6000000000000069E-3,3.9200000000000033E-2,0,0,0,0,0,0,0,0,null,null,4.5120000000000042E-2,null,null,0.3,null,0.16806999999999511,0.16416,0.14375000000000002,0.10624000000000003,6.1830000000000038E-2,2.4319999999999981E-2,{"$f":"+S156","v":3.9100000000000107E-3},{"$f":"+S151","v":0}]
[null,null,0.30000000000000004,0.7,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C154^(n-G$52)*$D154^G$52)","v":2.4300000000000016E-3},2.8350000000000014E-2,0.13230000000000006,0,0,0,0,0,0,0,0,null,null,0.16308000000000006,null,null,0.2,null,0.32767999999999359,0.32241999999999993,0.29376000000000002,0.23749999999999999,0.16383999999999987,9.0180000000000038E-2,{"$f":"+S157","v":3.3919999999999971E-2},{"$f":"+S152","v":5.2600000000000129E-3},{"$f":"+S148","v":0}]
[null,null,0,0.6,0.4,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C155^(n-G$52)*$D155^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0,null,null,0.1,null,{"$f":"+S209","v":0.59048999999999163},{"$f":"+S198","v":0.58368000000000031},{"$f":"+S188","v":0.54536999999999991},{"$f":"+S179","v":0.46655999999999997},0.35625000000000007,0.23424000000000006,{"$f":"+S158","v":0.12393000000000005},{"$f":"+S153","v":4.5120000000000042E-2},{"$f":"+S149","v":6.8099999999999966E-3},{"$f":"+S146","v":0}]
[null,null,0.10000000000000009,0.6,0.3,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C156^(n-G$52)*$D156^G$52)","v":1.0000000000000045E-5},3.0000000000000106E-4,3.6000000000000094E-3,0,0,0,0,0,0,0,0,null,null,3.9100000000000107E-3,null,null,0,null,{"$f":"+S210","v":0.99999999999999034},{"$f":"+S199","v":0.99144000000000032},{"$f":"+S189","v":0.94208000000000047},{"$f":"+S180","v":0.83691999999999989},0.68256000000000006,0.5,{"$f":"+S159","v":0.31744000000000006},{"$f":"+S154","v":0.16308000000000006},{"$f":"+S150","v":5.7919999999999972E-2},{"$f":"+S147","v":8.5599999999999947E-3},{"$f":"+S145","v":0}]
[null,null,0.19999999999999996,0.6,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C157^(n-G$52)*$D157^G$52)","v":3.1999999999999959E-4},4.7999999999999944E-3,2.8799999999999978E-2,0,0,0,0,0,0,0,0,null,null,3.3919999999999971E-2]
[null,null,0.30000000000000004,0.6,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C158^(n-G$52)*$D158^G$52)","v":2.4300000000000016E-3},2.4300000000000013E-2,9.7200000000000036E-2,0,0,0,0,0,0,0,0,null,null,0.12393000000000005]
[null,null,0.4,0.6,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C159^(n-G$52)*$D159^G$52)","v":1.0240000000000006E-2},7.6800000000000035E-2,0.23040000000000005,0,0,0,0,0,0,0,0,null,null,0.31744000000000006]
[null,null,0,0.5,0.5,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C160^(n-G$52)*$D160^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,9.9999999999999978E-2,0.5,0.4,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C161^(n-G$52)*$D161^G$52)","v":9.9999999999999873E-6},2.4999999999999973E-4,2.4999999999999983E-3,0,0,0,0,0,0,0,0,null,null,2.7599999999999981E-3]
[null,null,0.19999999999999996,0.5,0.3,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C162^(n-G$52)*$D162^G$52)","v":3.1999999999999959E-4},3.9999999999999957E-3,1.9999999999999987E-2,0,0,0,0,0,0,0,0,null,null,2.4319999999999981E-2]
[null,null,0.30000000000000004,0.5,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C163^(n-G$52)*$D163^G$52)","v":2.4300000000000016E-3},2.0250000000000011E-2,6.7500000000000032E-2,0,0,0,0,0,0,0,0,null,null,9.0180000000000038E-2]
[null,null,0.4,0.5,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C164^(n-G$52)*$D164^G$52)","v":1.0240000000000006E-2},6.4000000000000029E-2,0.16000000000000003,0,0,0,0,0,0,0,0,null,null,0.23424000000000006]
[null,null,0.5,0.5,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C165^(n-G$52)*$D165^G$52)","v":3.125E-2},0.15625,0.3125,0,0,0,0,0,0,0,0,null,null,0.5]
[null,null,0,0.4,0.6,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C166^(n-G$52)*$D166^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,9.9999999999999978E-2,0.4,0.5,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C167^(n-G$52)*$D167^G$52)","v":9.9999999999999873E-6},1.9999999999999979E-4,1.5999999999999992E-3,0,0,0,0,0,0,0,0,null,null,1.8099999999999991E-3]
[null,null,0.19999999999999996,0.4,0.4,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C168^(n-G$52)*$D168^G$52)","v":3.1999999999999959E-4},3.1999999999999967E-3,1.2799999999999994E-2,0,0,0,0,0,0,0,0,null,null,1.6319999999999991E-2]
[null,null,0.30000000000000004,0.4,0.3,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C169^(n-G$52)*$D169^G$52)","v":2.4300000000000016E-3},1.620000000000001E-2,4.320000000000003E-2,0,0,0,0,0,0,0,0,null,null,6.1830000000000038E-2]
[null,null,0.39999999999999991,0.4,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C170^(n-G$52)*$D170^G$52)","v":1.0239999999999987E-2},5.1199999999999947E-2,0.10239999999999995,0,0,0,0,0,0,0,0,null,null,0.16383999999999987]
[null,null,0.5,0.4,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C171^(n-G$52)*$D171^G$52)","v":3.125E-2},0.125,0.20000000000000004,0,0,0,0,0,0,0,0,null,null,0.35625000000000007]
[null,null,0.6,0.4,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C172^(n-G$52)*$D172^G$52)","v":7.7759999999999996E-2},0.25919999999999999,0.34560000000000007,0,0,0,0,0,0,0,0,null,null,0.68256000000000006]
[null,null,0,0.3,0.7,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C173^(n-G$52)*$D173^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,0.10000000000000009,0.3,0.6,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C174^(n-G$52)*$D174^G$52)","v":1.0000000000000045E-5},1.5000000000000053E-4,9.0000000000000236E-4,0,0,0,0,0,0,0,0,null,null,1.060000000000003E-3]
[null,null,0.19999999999999996,0.3,0.5,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C175^(n-G$52)*$D175^G$52)","v":3.1999999999999959E-4},2.3999999999999972E-3,7.1999999999999946E-3,0,0,0,0,0,0,0,0,null,null,9.9199999999999913E-3]
[null,null,0.30000000000000004,0.3,0.4,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C176^(n-G$52)*$D176^G$52)","v":2.4300000000000016E-3},1.2150000000000006E-2,2.4300000000000009E-2,0,0,0,0,0,0,0,0,null,null,3.8880000000000019E-2]
[null,null,0.4,0.3,0.3,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C177^(n-G$52)*$D177^G$52)","v":1.0240000000000006E-2},3.8400000000000017E-2,5.7600000000000012E-2,0,0,0,0,0,0,0,0,null,null,0.10624000000000003]
[null,null,0.5,0.3,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C178^(n-G$52)*$D178^G$52)","v":3.125E-2},9.375E-2,0.11249999999999999,0,0,0,0,0,0,0,0,null,null,0.23749999999999999]
[null,null,0.6,0.3,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C179^(n-G$52)*$D179^G$52)","v":7.7759999999999996E-2},0.19439999999999996,0.19440000000000002,0,0,0,0,0,0,0,0,null,null,0.46655999999999997]
[null,null,0.7,0.3,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C180^(n-G$52)*$D180^G$52)","v":0.16806999999999994},0.36014999999999991,0.30869999999999992,0,0,0,0,0,0,0,0,null,null,0.83691999999999989]
[null,null,0,0.2,0.8,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C181^(n-G$52)*$D181^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,0.10000000000000009,0.2,0.7,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C182^(n-G$52)*$D182^G$52)","v":1.0000000000000045E-5},1.0000000000000036E-4,4.000000000000011E-4,0,0,0,0,0,0,0,0,null,null,5.1000000000000155E-4]
[null,null,0.19999999999999996,0.2,0.6,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C183^(n-G$52)*$D183^G$52)","v":3.1999999999999959E-4},1.5999999999999983E-3,3.1999999999999984E-3,0,0,0,0,0,0,0,0,null,null,5.1199999999999961E-3]
[null,null,0.30000000000000004,0.2,0.5,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C184^(n-G$52)*$D184^G$52)","v":2.4300000000000016E-3},8.1000000000000048E-3,1.0800000000000008E-2,0,0,0,0,0,0,0,0,null,null,2.1330000000000016E-2]
[null,null,0.39999999999999991,0.2,0.4,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C185^(n-G$52)*$D185^G$52)","v":1.0239999999999987E-2},2.5599999999999973E-2,2.5599999999999987E-2,0,0,0,0,0,0,0,0,null,null,6.1439999999999953E-2]
[null,null,0.5,0.2,0.3,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C186^(n-G$52)*$D186^G$52)","v":3.125E-2},6.25E-2,5.000000000000001E-2,0,0,0,0,0,0,0,0,null,null,0.14375000000000002]
[null,null,0.6,0.2,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C187^(n-G$52)*$D187^G$52)","v":7.7759999999999996E-2},0.12959999999999999,8.6400000000000018E-2,0,0,0,0,0,0,0,0,null,null,0.29376000000000002]
[null,null,0.7,0.2,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C188^(n-G$52)*$D188^G$52)","v":0.16806999999999994},0.24009999999999995,0.13719999999999999,0,0,0,0,0,0,0,0,null,null,0.54536999999999991]
[null,null,0.8,0.2,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C189^(n-G$52)*$D189^G$52)","v":0.32768000000000019},0.40960000000000019,0.20480000000000009,0,0,0,0,0,0,0,0,null,null,0.94208000000000047]
[null,null,0,0.1,0.9,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C190^(n-G$52)*$D190^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,9.9999999999999978E-2,0.1,0.8,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C191^(n-G$52)*$D191^G$52)","v":9.9999999999999873E-6},4.9999999999999948E-5,9.9999999999999951E-5,0,0,0,0,0,0,0,0,null,null,1.5999999999999988E-4]
[null,null,0.20000000000000007,0.1,0.7,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C192^(n-G$52)*$D192^G$52)","v":3.2000000000000057E-4},8.0000000000000112E-4,8.0000000000000101E-4,0,0,0,0,0,0,0,0,null,null,1.9200000000000027E-3]
[null,null,0.30000000000000004,0.1,0.6,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C193^(n-G$52)*$D193^G$52)","v":2.4300000000000016E-3},4.0500000000000024E-3,2.7000000000000019E-3,0,0,0,0,0,0,0,0,null,null,9.1800000000000059E-3]
[null,null,0.4,0.1,0.5,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C194^(n-G$52)*$D194^G$52)","v":1.0240000000000006E-2},1.2800000000000006E-2,6.4000000000000029E-3,0,0,0,0,0,0,0,0,null,null,2.9440000000000015E-2]
[null,null,0.5,0.1,0.4,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C195^(n-G$52)*$D195^G$52)","v":3.125E-2},3.125E-2,1.2500000000000002E-2,0,0,0,0,0,0,0,0,null,null,7.4999999999999997E-2]
[null,null,0.6,0.1,0.3,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C196^(n-G$52)*$D196^G$52)","v":7.7759999999999996E-2},6.4799999999999996E-2,2.1600000000000005E-2,0,0,0,0,0,0,0,0,null,null,0.16416]
[null,null,0.7,0.1,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C197^(n-G$52)*$D197^G$52)","v":0.16806999999999994},0.12004999999999998,3.4299999999999997E-2,0,0,0,0,0,0,0,0,null,null,0.32241999999999993]
[null,null,0.8,0.1,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C198^(n-G$52)*$D198^G$52)","v":0.32768000000000019},0.20480000000000009,5.1200000000000023E-2,0,0,0,0,0,0,0,0,null,null,0.58368000000000031]
[null,null,0.9,0.1,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C199^(n-G$52)*$D199^G$52)","v":0.59049000000000018},0.32805000000000012,7.290000000000002E-2,0,0,0,0,0,0,0,0,null,null,0.99144000000000032]
[null,null,-1.0000000000065512E-5,1.0000000000000001E-5,1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C200^(n-G$52)*$D200^G$52)","v":-1.0000000000327562E-25},5.000000000131025E-25,-1.0000000000196536E-24,0,0,0,0,0,0,0,0,null,null,-6.0000000000982672E-25]
[null,null,9.9990000000000023E-2,1.0000000000000001E-5,0.9,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C201^(n-G$52)*$D201^G$52)","v":9.9950009999000173E-6},4.9980002999800058E-9,9.9970002999900089E-13,0,0,0,0,0,0,0,0,null,null,9.9999999999000272E-6]
[null,null,0.19999,1.0000000000000001E-5,0.8,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C202^(n-G$52)*$D202^G$52)","v":3.1992000799959997E-4},7.9984001199959995E-8,7.9988000599989999E-12,0,0,0,0,0,0,0,0,null,null,3.1999999999960001E-4]
[null,null,0.29999000000000009,1.0000000000000001E-5,0.7,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C203^(n-G$52)*$D203^G$52)","v":2.4295950269991036E-3},4.0494600269994047E-7,2.6997300089999027E-11,0,0,0,0,0,0,0,0,null,null,2.4299999999991039E-3]
[null,null,0.39999000000000007,1.0000000000000001E-5,0.6,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C204^(n-G$52)*$D204^G$52)","v":1.0238720063998411E-2},1.2798720047999211E-6,6.3995200119999046E-11,0,0,0,0,0,0,0,0,null,null,1.023999999999841E-2]
[null,null,0.49999000000000005,1.0000000000000001E-5,0.5,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C205^(n-G$52)*$D205^G$52)","v":3.1246875124997516E-2},3.1247500074999016E-6,1.2499250014999904E-10,0,0,0,0,0,0,0,0,null,null,3.1249999999997516E-2]
[null,null,0.59999000000000002,1.0000000000000001E-5,0.4,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C206^(n-G$52)*$D206^G$52)","v":7.7753520215996422E-2},6.4795680107998816E-6,2.1598920017999908E-10,0,0,0,0,0,0,0,0,null,null,7.7759999999996415E-2]
[null,null,0.69999,1.0000000000000001E-5,0.3,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C207^(n-G$52)*$D207^G$52)","v":0.16805799534299509},1.200431401469986E-5,3.4298530020999905E-10,0,0,0,0,0,0,0,0,null,null,0.16806999999999511]
[null,null,0.79998999999999998,1.0000000000000001E-5,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C208^(n-G$52)*$D208^G$52)","v":0.3276595205119936},2.0478976019199841E-5,5.1198080023999908E-10,0,0,0,0,0,0,0,0,null,null,0.32767999999999359]
[null,null,0.89998999999999996,1.0000000000000001E-5,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C209^(n-G$52)*$D209^G$52)","v":0.59045719572899169},3.280354202429981E-5,7.2897570026999886E-10,0,0,0,0,0,0,0,0,null,null,{"$f":"IF($C209>0.9999999,1,IF($C209=0,0,SUM(F209:P209)))","v":0.59048999999999163}]
[null,null,{"$f":"1-(D210+E210)","v":0.99999000000000005},1.0000000000000001E-5,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C210^(n-G$52)*$D210^G$52)","v":0.99995000099999032},4.9998000029999818E-5,9.9997000029999939E-10,0,0,0,0,0,0,0,0,null,null,{"$f":"IF($C210>0.9999999,1,IF($C210=0,0,SUM(F210:P210)))","v":0.99999999999999034}]

{"sheet":"3-class mixed","index":6,"n_rows":210,"n_cols":34,"rows_kept":210,"cut":false,"hidden":false,"merged":[[0,1,1,6],[0,8,1,13],[0,15,1,20],[0,33,1,38],[17,8,17,9],[17,11,17,12],[17,18,17,19],[58,1,58,10],[26,1,26,6],[29,8,29,12],[29,15,29,19],[35,1,35,20],[36,1,36,20],[52,1,52,10]]}
[null,{"$f":"\"Operating characteristic curve for proportion defective Pd and marginally acceptable Pm with n=\"&n&\" and c=\"&cm","v":"Operating characteristic curve for proportion defective Pd and marginally acceptable Pm with n=5 and c=1"},null,null,null,null,null,null,{"$f":"\"Probability density function (PDF) for log counts.  Distribution mean = \"&FIXED(meanlog,2)&\" and sigma = \"&FIXED(sigma,2)","v":"Probability density function (PDF) for log counts.  Distribution mean = -1.24 and sigma = 0.80"},null,null,null,null,null,null,{"$f":"\"Operating characteristic curve scaled to relate log arithmetic mean count to m\"","v":"Operating characteristic curve scaled to relate log arithmetic mean count to m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Operating characteristic curve scaled to relate mean log count to m\"","v":"Operating characteristic curve scaled to relate mean log count to m"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"INPUTS",null,null,"P(accept)",null,null,null,"ALTERNATIVE n AND c",null,null,"P(accept)"]
[null,null,"Lot acceptance for Pd",null,null,null,null,null,"mean",-1.2358760366299137,null,"Computed",{"$f":"$S$55*100","v":5.0003847346999519},"%",null,"mean",{"$f":"meanlog","v":-1.2358760366299137},null,"Computed",{"$f":"S57*100","v":5.0003847346999519},"%",null,null,null,"Coordinates to place m"]
[null,null,null,null,null,"P(accept)",null,null,"sigma",0.8,null,"Desired",5,"%",null,"sigma",{"$f":"sigma","v":0.8},null,"Target, left",{"$f":"computed_P","v":5.0003847346999519},"%",null,null,null,"proportion","m"]
[null,null,"Pd",20,"%",{"$f":"$S$56*100","v":16.471125000000004},"%",null,"m",{"$f":"-LOG(weight)","v":-1.3979400086720377},null,null,null,null,null,"m",{"$f":"+m","v":-1.3979400086720377},null,null,null,null,null,null,null,0,{"$f":"m","v":-1.3979400086720377},0]
[null,null,"Pm",25,"%",null,null,null,"M",2,null,null,null,null,null,"M",{"$f":"+BigM","v":2},null,null,null,null,null,null,null,{"$f":"1.1*NORMDIST(meanlog,meanlog,sigma,FALSE)","v":0.54854563555197},{"$f":"m","v":-1.3979400086720377},1]
[null,null,"actualPd",{"$f":"+Pd*100","v":2.6178871419424432E-3},"%",null,null,null,"n",5,null,null,null,null,null,"n",{"$f":"n","v":5}]
[null,null,"actualPm",{"$f":"+Pm*100","v":65.737145127984817},"%",{"$f":"+computed_P","v":5.0003847346999519},"%",null,"c",1,null,null,null,null,null,"c",{"$f":"cm","v":1},null,null,null,null,null,null,null,"Coordinates to place M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"proportion","M"]
[null,null,null,null,null,null,null,null,"amount",25,"g",null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"BigM","v":2},0]
[null,"Sandbox: for your own calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1.1*NORMDIST(meanlog,meanlog,sigma,FALSE)","v":0.54854563555197},{"$f":"BigM","v":2},1]
[null,"FSO",2,null,null,null,null,null,null,null,null,"P(reject)",{"$f":"100-computed_P","v":94.999615265300051},"%"]
[null,"complient",{"$f":"_xlfn.NORM.DIST(C28,meanlog,sigma,1)","v":0.99997382112858058},"not comply",{"$f":"1-_xlfn.NORM.DIST(C28,meanlog,sigma,1)","v":2.6178871419424432E-5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coordinates to place Pd"]
[null,"%",{"$f":"100*C29","v":99.997382112858062},"%",{"$f":"100*E29","v":2.6178871419424432E-3},null,null,null,"Means",null,null,null,null,null,null,"Implied Acceptance level ",null,null,null,null,null,null,null,null,"p accept"]
[null,null,null,null,null,null,null,null,"Arithmetic (=Average)",null,null,"Geometric (=Median)",null,null,null,"Percentile","z-score","Concentration at this percentile",null,null,null,null,null,null,"x","y"]
[null,null,null,null,null,null,null,null,{"$f":"10^(meanlog+0.5*sigma^2*LN(10))","v":0.31692112808051648},"cfu/g",null,{"$f":"10^meanlog","v":5.80930212375214E-2},"cfu/g",null,null,99.9,{"$f":"+TINV(2*(1-P32/100),1000)","v":3.0984021639129624},null,{"$f":"+meanlog+Q32*sigma","v":1.2428456945004565},null,null,null,null,null,{"$f":"+Pd","v":2.6178871419424432E-5},0]
[null,null,null,null,null,null,null,null,{"$f":"+LOG(I32)","v":-0.49904880687181896},"log cfu/g",null,{"$f":"+LOG(L32)","v":-1.235876036629914},"log cfu/g",null,null,"FSO","P(exceedance)",null,"target level",null,null,null,null,null,{"$f":"+Pd","v":2.6178871419424432E-5},{"$f":"+desired_P","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+S32","v":1.2428456945004565},{"$f":"1-_xlfn.NORM.DIST(P34,meanlog,sigma,1)","v":9.7283600143704962E-4},null,{"$f":"+P34-Q32*sigma","v":-1.2358760366299137}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(ABS(computed_P-desired_P)<0.001,\"This sampling plan would provide \"&FIXED(M28,0)&\" % confidence that a lot of food containing a geometric mean concentration of \"&FIXED(L32,2)&\" cfu/g and an arithmetic mean concentration of \"&FIXED(I32,2)&\" cfu/g (having a\",\"\")","v":"This sampling plan would provide 95 % confidence that a lot of food containing a geometric mean concentration of 0.06 cfu/g and an arithmetic mean concentration of 0.32 cfu/g (having a"}]
[null,{"$f":"IF(ABS(computed_P-desired_P)<0.001,\"standard deviation of \"&FIXED(sigma,2)&\" log cfu/g), would be rejected (i.e. either more than \"& cm&\" out of \"&n&\" samples having levels between [\"&FIXED(m,1)&\",\"&FIXED(BigM,1)&\"] logs cfu/g or 1 or more samples higher than \"&FIXED(BigM,1)&\" log cfu/g)\",\"\")","v":"standard deviation of 0.80 log cfu/g), would be rejected (i.e. either more than 1 out of 5 samples having levels between [-1.4,2.0] logs cfu/g or 1 or more samples higher than 2.0 log cfu/g)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10]
[null,"The calculations below are for the buttons above.  Do not edit."]
[null,"geo mean","arith mean","pa","pm","pd",null,null,null,null,null,null,null,null,null,null,null,null,"P(accept)"]
[null,{"$f":"meanlog","v":-1.2358760366299137},{"$f":"+B55+0.5*LN(10)*sigma^2","v":-0.49904880687181896},{"$f":"1-poissonlognormal(B55,sigma,10^-m)","v":0.34260236984873238},{"$f":"NORMSDIST((BigM-B55)/sigma)-D55","v":0.6573714512798482},{"$f":"1-(D55+Pm)","v":2.6178871419424432E-5},{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D55^(n-G$52)*$E55^G$52)","v":4.7201066733854958E-3},4.5283740673614029E-2,0,0,0,0,0,0,0,0,0,null,{"$f":"IF($D55>0.9999999,1,IF($D55=0,0,SUM(G55:Q55)))","v":5.0003847346999523E-2},null,"<= Used by macros for finding mean and n"]
[null,null,null,{"$f":"1-(F56+E56)","v":0.55000000000000004},{"$f":"$D$22/100","v":0.25},{"$f":"D21/100","v":0.2},5.0328437500000017E-2,0.11438281250000003,0,0,0,0,0,0,0,0,0,null,{"$f":"IF($D56>0.9999999,1,IF($D56=0,0,SUM(G56:Q56)))","v":0.16471125000000003},null,"<= Used in test against ICMSF tables"]
[null,{"$f":"meanlog","v":-1.2358760366299137},{"$f":"+B57+0.5*LN(10)*sigma^2","v":-0.49904880687181896},{"$f":"1-poissonlognormal(B57,sigma,10^-m)","v":0.34260236984873238},{"$f":"NORMSDIST((alternative_bigM-B57)/sigma)-D57","v":0.6573714512798482},{"$f":"1-(D57+E57)","v":2.6178871419424432E-5},{"$f":"IF(G$52>alternative_c,0,(COMBIN(alternative_n,G$52))*$D57^(alternative_n-G$52)*$E57^G$52)","v":4.7201066733854958E-3},4.5283740673614029E-2,0,0,0,0,0,0,0,0,0,null,{"$f":"IF($D57>0.9999999,1,IF($D57=0,0,SUM(G57:Q57)))","v":5.0003847346999523E-2},null,"<= Used by macro for finding m in equivalent performance criterion"]
[]
[null,"The calculations below are for the charts above.  Do not edit."]
[null,-3,{"$f":"+B60+0.5*LN(10)*sigma^2","v":-2.2631727702419053},{"$f":"1-poissonlognormal(B60,sigma,10^-m)","v":0.91539118748208781},{"$f":"NORMSDIST((BigM-B60)/sigma)-D60","v":8.4608812312685799E-2},{"$f":"1-(E60+D60)","v":2.0522639143649712E-10},{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D60^(n-G$52)*$E60^G$52)","v":0.64273749477662989},0.29703834167043408,0,0,0,0,0,0,0,0,0,null,{"$f":"IF($D60>0.9999999,1,IF($D60=0,0,SUM(G60:Q60)))","v":0.93977583644706397},{"$f":"NORMDIST($B60,meanlog,sigma,FALSE)","v":4.3842607172515424E-2}]
[null,-2.9,-2.1631727702419052,0.89986902876472086,0.10013097078186106,{"$f":"1-(E61+D61)","v":4.5341808085908042E-10},0.59006047389322658,0.32828848522567411,0,0,0,0,0,0,0,0,0,null,0.91834895911890069,5.7307871073931711E-2]
[null,-2.8,-2.0631727702419052,0.88216315646573951,0.11783684254767279,9.8658770042447941E-10,0.53425005750857546,0.35681800722635421,0,0,0,0,0,0,0,0,0,null,0.89106806473492961,7.3747334308752965E-2]
[null,-2.7,-1.9631727702419055,0.86213248532986486,0.13786751255591845,2.1142166906074067E-9,0.47628844840040369,0.3808272206269856,0,0,0,0,0,0,0,0,0,null,0.85711566902738934,9.3431329151392392E-2]
[null,-2.6,-1.8631727702419054,0.83966518276069047,0.16033481277713713,4.4621724093474313E-9,0.41737912700027924,0.39849457592519599,0,0,0,0,0,0,0,0,0,null,0.81587370292547523,0.11653405969258368]
[null,-2.5,-1.7631727702419053,0.81468742067511624,0.18531257004948498,9.2753987823712691E-9,0.35888479003786256,0.40816797403397953,0,0,0,0,0,0,0,0,0,null,0.76705276407184209,0.14309596046821937]
[null,-2.4,-1.6631727702419052,0.78717182915665962,0.2128281518537779,1.8989562478033406E-8,0.30223706077421197,0.40858013894633338,0,0,0,0,0,0,0,0,0,null,0.71081719972054536,0.17298801708720216]
[null,-2.2999999999999998,-1.5631727702419052,0.75714508825464866,0.24285487345401024,3.8291341097895781E-8,0.24882587887614294,0.39905546680522602,0,0,0,0,0,0,0,0,0,null,0.64788134568136901,0.20588220729227188]
[null,-2.2000000000000002,-1.4631727702419055,0.72469405902953898,0.27530586492085585,7.6049605168826417E-8,0.19988191662502958,0.37966824243172909,0,0,0,0,0,0,0,0,0,null,0.57955015905675866,0.24123246780322052]
[null,-2.1,-1.3631727702419054,0.68996986599576737,0.31002998523535941,1.4876887322046173E-7,0.15636898532691493,0.35131298192426391,0,0,0,0,0,0,0,0,0,null,0.50768196725117887,0.27827029751429888]
[null,-2,-1.2631727702419053,0.65318940743375586,0.34681030591467221,2.8665157192353519E-7,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D70^(n-G$52)*$E70^G$52)","v":0.11890378144794397},0.31565925862442046,0,0,0,0,0,0,0,0,0,null,0.43456304007236446,0.31601819903555456]
[null,-1.9,-1.1631727702419052,0.61463388967516508,0.38536556628255936,5.4404227556315021E-7,8.7716746221807709E-2,0.27498494752783176,0,0,0,0,0,0,0,0,0,null,0.36270169374963945,0.35332265387169964]
[null,-1.8,-1.0631727702419052,0.5746441523866519,0.42535483053010559,1.017083242516037E-6,6.2660659035049998E-2,0.23190885954430471,0,0,0,0,0,0,0,0,0,null,0.29456951857935471,0.38890633959017135]
[null,-1.7,-0.96317277024190517,0.53361276363668475,0.46638536337130965,1.8729920056026472E-6,4.3264435866311859E-2,0.18906875001497239,0,0,0,0,0,0,0,0,0,null,0.23233318588128427,0.42143704701736978]
[null,-1.6,-0.86317277024190531,0.49197309960759072,0.50802350271928454,3.3976731247387093E-6,2.8820849929207908E-2,0.14880558656623283,0,0,0,0,0,0,0,0,0,null,0.17762643649544074,0.44960853454108995]
[null,-1.5,-0.76317277024190522,0.45018586301747265,0.54980806535861604,6.0716239113078885E-6,1.849095171899277E-2,0.11291418974283081,0,0,0,0,0,0,0,0,0,null,0.13140514146182358,0.47222669211659202]
[null,-1.4,-0.66317277024190513,0.40872371299667964,0.59126559847754545,1.0688525774904534E-5,1.1406415168811043E-2,8.2503420731612931E-2,0,0,0,0,0,0,0,0,0,null,9.3909835900423969E-2,0.48829318748371897]
[null,-1.3,-0.56317277024190526,0.36805485383228509,0.63192660942986867,1.8536737846241991E-5,6.7540263004368826E-3,5.7981152749314098E-2,0,0,0,0,0,0,0,0,0,null,6.4735179049750985E-2,0.49707846393145766]
[null,-1.2,-0.46317277024190517,0.3286265405754476,0.67134178818271928,3.1671241833119979E-5,3.8327736779442435E-3,3.9149320230573437E-2,0,0,0,0,0,0,0,0,0,null,4.2982093908517677E-2,0.49817666246614806]
[null,-1.1000000000000001,-0.36317277024190531,0.29084949184253661,0.70909719580771224,5.3312349751144517E-5,2.081332888202263E-3,2.5371667408062949E-2,0,0,0,0,0,0,0,0,0,null,2.7453000296265212E-2,0.49153671038290719]
[null,-1,-0.26317277024190522,0.25508414823586423,0.74482743447893496,8.841728520081471E-5,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D80^(n-G$52)*$E80^G$52)","v":1.0799840830317689E-3},1.5767380674295083E-2,0,0,0,0,0,0,0,0,0,null,1.6847364757326851E-2,0.4774662594464168]
[null,-0.9,-0.16317277024190524,0.22162958207810979,0.77822593719600897,1.4448072588124639E-4,5.3473503286228434E-4,9.3882925780667294E-3,0,0,0,0,0,0,0,0,0,null,9.9230276109290132E-3,0.4566080507325308]
[null,-0.8,-6.3172770241905263E-2,0.19071566277363983,0.80905170814732463,2.3262907903554009E-4,2.5230845694786938E-4,5.3516996219647615E-3,0,0,0,0,0,0,0,0,0,null,5.6040080789126305E-3,0.42989123512904737]
[null,-0.7,3.6827229758094826E-2,0.16249883233233231,0.83713208921339266,3.6907845427502917E-4,1.1330556039099351E-4,2.9185354481693106E-3,0,0,0,0,0,0,0,0,0,null,3.0318410085603039E-3,0.3984627842999966]
[null,-0.6,0.1368272297580948,0.13706157260643625,0.86236140235117298,5.7702504239076635E-4,4.8370274546394563E-5,1.5216758788298508E-3,0,0,0,0,0,0,0,0,0,null,1.5700461533762454E-3,0.36360603994864998]
[null,-0.5,0.23682722975809478,0.11441537678189184,0.88469559791899977,8.8902529910839245E-4,1.96074887974602E-5,7.5805628199900055E-4,0,0,0,0,0,0,0,0,0,null,7.7766377079646078E-4,0.32665443648430204]
[null,-0.4,0.33682722975809476,9.4506798825077176E-2,0.90414330314329272,1.3498980316301035E-3,7.5390263984382087E-6,3.6062803497263822E-4,0,0,0,0,0,0,0,0,0,null,3.6816706137107643E-4,0.28890840848933425]
[null,-0.3,0.43682722975809479,7.7225966926854017E-2,0.92075389558319998,2.0201374899460056E-3,2.7467350758732454E-6,1.6374460054613231E-4,0,0,0,0,0,0,0,0,0,null,1.6649133562200556E-4,0.25156252865350848]
[null,-0.2,0.53682722975809471,6.2416825326541803E-2,0.93460341143840364,2.9797632350545555E-3,9.4734545966891437E-7,7.0925771519554558E-5,0,0,0,0,0,0,0,0,0,null,7.1873116979223476E-5,0.21564821608539728]
[null,-0.1,0.6368272297580948,4.9888319451846019E-2,0.94577923218514137,4.3324483630126087E-3,3.0902553876659067E-7,2.9292421551940138E-5,0,0,0,0,0,0,0,0,0,null,2.9601447090706728E-5,0.18199520126769522]
[null,0,0.73682722975809478,3.9425759829018636E-2,0.9543645748452052,6.2096653257761592E-3,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D90^(n-G$52)*$E90^G$52)","v":9.5257758924143241E-8},1.1529344138275029E-5,0,0,0,0,0,0,0,0,0,null,1.1624601897199171E-5,0.15121265984058566]
[null,0.1,0.83682722975809476,3.0801681747317899E-2,0.96042384315694374,8.7744750957383655E-3,2.7725037766242869E-8,4.3224567316758666E-6,0,0,0,0,0,0,0,0,0,null,4.3501817694421094E-6,0.12368884019330144]
[null,0.2,{"$f":"+B92+0.5*LN(10)*sigma^2","v":0.93682722975809485},2.3785644836253006E-2,{"$f":"NORMSDIST((BigM-B92)/sigma)-D92","v":0.96398988250870232},1.2224472655044671E-2,7.6133298977016003E-9,1.5427736023366749E-6,0,0,0,0,0,0,0,0,0,null,1.5503869322343764E-6,{"$f":"NORMDIST($B92,meanlog,sigma,FALSE)","v":9.9606351027891046E-2}]
[null,0.3,1.0368272297580947,1.8152571921575045E-2,0.96505412162997617,1.6793306448448786E-2,1.9710190903402615E-9,5.2393129336220049E-7,0,0,0,0,0,0,0,0,0,null,5.2590231245254073E-7,7.896919164076141E-2]
[null,0.4,1.1368272297580948,1.3689391204874557E-2,0.96356047684694623,2.2750131948179209E-2,4.807515277322641E-10,1.6919421922198004E-7,0,0,0,0,0,0,0,0,0,null,1.6967497074971232E-7,6.1637143421980026E-2]
[null,0.5,1.2368272297580947,1.0199902881524392E-2,0.95940373535321422,3.0396361765261393E-2,1.1040282421202574E-10,5.1922495328078911E-8,0,0,0,0,0,0,0,0,0,null,5.2032898152290939E-8,4.736324640965453E-2]
[null,0.6,1.3368272297580948,7.5079278318459508E-3,0.95243291530433694,4.0059156863817114E-2,2.385615495829637E-11,1.5131596709351818E-8,0,0,0,0,0,0,0,0,0,null,1.5155452864310114E-8,3.5830640419940836E-2]
[null,0.7,1.4368272297580948,5.4589026027028753E-3,0.94245981798207756,5.2081279415219561E-2,4.8475994624276513E-12,4.1846026935409046E-9,0,0,0,0,0,0,0,0,0,null,4.1894502930033324E-9,2.6685898352166882E-2]
[null,0.8,1.5368272297580949,3.9201575553389212E-3,0.92927264117580299,6.6807201268858085E-2,9.2580092563258282E-13,1.0973047118908636E-9,0,0,0,0,0,0,0,0,0,null,1.0982305128164961E-9,1.9566954404274348E-2]
[null,0.9,1.6368272297580948,2.7801539011546028E-3,0.91265412374750976,8.4565722351335637E-2,1.6609026929489355E-13,2.7261614747904125E-10,0,0,0,0,0,0,0,0,0,null,2.7278223774833611E-10,1.412468552169599E-2]
[null,1,1.7368272297580947,1.9469637324993627E-3,0.8924032626006454,0.10564977366685524,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D100^(n-G$52)*$E100^G$52)","v":2.7976237641543779E-14},6.4115436075830512E-11,0,0,0,0,0,0,0,0,0,null,6.4143412313472051E-11,1.0038030022475938E-2]
[null,1.1000000000000001,1.8368272297580948,1.3462613198258477E-3,0.86835922154336531,0.13029451713680884,4.4222861431461093E-15,1.4262212306601538E-11,0,0,0,0,0,0,0,0,0,null,1.4266634592744685E-11,7.0231564335204496E-3]
[null,1.2,1.9368272297580948,9.1906071593594874E-4,0.84042568535260709,0.15865525393145696,6.5572390374526843E-16,2.9981001344725666E-12,0,0,0,0,0,0,0,0,0,null,2.9987558583763121E-12,4.8376043087883592E-3]
[null,1.3,2.0368272297580949,6.193913797550854E-4,0.80859365576773434,0.19078695285251057,9.1164506283301518E-17,5.9506027869667122E-13,0,0,0,0,0,0,0,0,0,null,5.9515144320295449E-13,3.2805185025230575E-3]
[null,1.4,2.1368272297580946,4.1205657235621196E-4,0.77296059105077553,0.22662735237686826,1.187911886306684E-17,1.1141784106310636E-13,0,0,0,0,0,0,0,0,0,null,1.1142972018196942E-13,2.1901244292353169E-3]
[null,1.5,2.2368272297580947,2.7057371272876107E-4,0.7337438972385707,0.26598552904870054,1.4502003469868864E-18,1.9663322863917259E-14,0,0,0,0,0,0,0,0,0,null,1.9664773064264245E-14,1.4394919351134285E-3]
[null,1.6,2.3368272297580948,1.7535548894098696E-4,0.69128710578507213,0.30853753872598688,1.6580469464228894E-19,3.268179632615282E-15,0,0,0,0,0,0,0,0,0,null,3.2683454373099243E-15,9.314591888148336E-4]
[null,1.7,2.4368272297580948,1.121573126305897E-4,0.64605760936009327,0.35383023332727614,1.7747532236828413E-20,5.1115384186903851E-16,0,0,0,0,0,0,0,0,0,null,5.1117158940127537E-16,5.9337955070360132E-4]
[null,1.8,2.5368272297580949,7.0791509223622207E-5,0.59863553417370008,0.4012936743170763,1.7778939675116588E-21,7.5172186369378466E-17,0,0,0,0,0,0,0,0,0,null,7.5173964263345981E-17,3.7214781046166824E-4]
[null,1.9,2.6368272297580946,4.409124014526089E-5,0.54969413358996766,0.45026177516988708,1.6663321420470859E-22,1.0387244723418608E-17,0,0,0,0,0,0,0,0,0,null,1.0387411356632812E-17,2.297801505419354E-4]
[null,2,2.7368272297580947,2.7096581610819293E-5,0.49997290341838918,0.5,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D110^(n-G$52)*$E110^G$52)","v":1.4607386750320846E-23},1.3476418667506601E-18,0,0,0,0,0,0,0,0,0,null,1.3476564741374104E-18,1.3967661444466107E-4]
[null,2.1,2.8368272297580948,1.6430183360838235E-5,0.45024534498652624,0.54973822483011292,1.1973250009025546E-24,1.6405477536461904E-19,0,0,0,0,0,0,0,0,0,null,1.6405597268961995E-19,8.3588982500557989E-5]
[null,2.2000000000000002,2.9368272297580948,9.8290561373337582E-6,0.40128384526093885,0.59870632568292381,9.1740072170159946E-26,1.8727031573829216E-20,0,0,0,0,0,0,0,0,0,null,1.8727123313901387E-20,4.9247991862019327E-5]
[null,2.2999999999999998,3.0368272297580945,5.8009558377980497E-6,0.35382443237143846,0.64616976667272374,6.5689778301966906E-27,2.0033464458437953E-21,0,0,0,0,0,0,0,0,0,null,2.0033530148216254E-21,2.8565521873369211E-5]
[null,2.4,3.1368272297580946,3.37740757405669E-6,0.30853416131841283,0.69146246127401312,4.394579898921199E-28,2.0072762817781982E-22,0,0,0,0,0,0,0,0,0,null,2.0072806763580971E-22,1.6312102728284432E-5]
[null,2.5000000000000102,3.2368272297581049,1.9397346798788462E-6,0.26598358931401644,0.73401447095130368,2.7460703081840887E-29,1.8827565559766963E-23,0,0,0,0,0,0,0,0,0,null,1.8827593020470045E-23,9.170476063488139E-6]
[null,2.6,3.3368272297580948,1.0988939509459783E-6,0.22662625348291726,0.77337264762313174,1.6024294342514341E-30,1.6523549831288761E-24,0,0,0,0,0,0,0,0,0,null,1.6523565855583103E-24,5.0756067250589297E-6]
[null,2.7,3.4368272297580948,6.1405083418009099E-7,0.19078633880167639,0.80921304714748943,8.7301484457246267E-32,1.3562338543020821E-25,0,0,0,0,0,0,0,0,0,null,1.3562347273169266E-25,2.7656562229217123E-6]
[null,2.80000000000001,3.5368272297581047,3.3843030222691084E-7,0.15865491550115185,0.84134474606854592,4.4396241884729209E-33,1.0406399720181914E-26,0,0,0,0,0,0,0,0,0,null,1.0406404159806103E-26,1.4836196451269665E-6]
[null,2.9000000000000101,3.6368272297581048,1.8396387890806665E-7,0.13029433317292721,0.86970548286319382,2.1069915351870927E-34,7.4614934928447685E-28,0,0,0,0,0,0,0,0,0,null,7.4614955998363036E-28,7.8353987688181425E-7]
[null,3.0000000000000102,3.7368272297581049,9.8622730426711769E-8,0.1056496750441225,0.89435022633314709,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D120^(n-G$52)*$E120^G$52)","v":9.3300744718990164E-36},4.9974246901737257E-29,0,0,0,0,0,0,0,0,0,null,4.997425623181173E-29,4.0739320536349427E-7]
[null,3.1,3.8368272297580948,5.2141801432092905E-8,8.4565670209534261E-2,0.91543427764866436,3.854163702617997E-37,3.1254188353429561E-30,0,0,0,0,0,0,0,0,0,null,3.1254192207593263E-30,2.0853579285667797E-7]
[null,3.2000000000000099,3.9368272297581046,2.7185895312697994E-8,6.6807174082961163E-2,0.93319279873114347,1.4849717814305649E-38,1.8245999840950459E-31,0,0,0,0,0,0,0,0,0,null,1.8246001325922241E-31,1.0509004605905338E-7]
[null,3.30000000000001,4.0368272297581047,1.3977660806574477E-8,5.2081265437557415E-2,0.94791872058478177,5.3354675953950178E-40,9.9400718015189122E-33,0,0,0,0,0,0,0,0,0,null,9.9400723350656713E-33,5.2138280708228748E-8]
[null,3.4000000000000101,{"$f":"+B124+0.5*LN(10)*sigma^2","v":4.1368272297581052},{"$f":"1-poissonlognormal(B124,sigma,10^-m)","v":7.0866957857518287E-9},{"$f":"NORMSDIST((BigM-B124)/sigma)-D124","v":4.0059149777120204E-2},0.959940843136184,1.7873884609850795E-41,5.0518086449016011E-34,0,0,0,0,0,0,0,0,0,null,{"$f":"IF($D124>0.9999999,1,IF($D124=0,0,SUM(G124:Q124)))","v":5.0518088236404473E-34},{"$f":"NORMDIST($B124,meanlog,sigma,FALSE)","v":2.5466307467167913E-8}]
[null,3.5000000000000102,4.2368272297581049,3.5428869837872412E-9,3.0396358222373517E-2,{"$f":"1-(E125+D125)","v":0.9696036382347395},5.5819570942022735E-43,2.3945325971973006E-35,0,0,0,0,0,0,0,0,0,null,2.3945326530168714E-35,1.224586307742325E-8]
[null,3.6000000000000099,4.3368272297581045,1.7464708568226683E-9,2.2750130201707703E-2,0.97724986805182146,1.6248254579922318E-44,1.0582767694052036E-36,0,0,0,0,0,0,0,0,0,null,1.0582767856534581E-36,5.7973159387792697E-9]
[null,3.7000000000000099,4.4368272297581051,8.4887274987011097E-10,1.6793305599575543E-2,0.98320669355155166,4.4077094773477308E-46,4.3599003654300314E-38,0,0,0,0,0,0,0,0,0,null,4.3599004095071261E-38,2.7019585813709587E-9]
[null,3.80000000000001,4.5368272297581047,4.0680681046012523E-10,1.2224472248237495E-2,0.98777552734495566,1.1141433559180005E-47,1.6739904771472338E-39,0,0,0,0,0,0,0,0,0,null,1.6739904882886672E-39,1.2397797958050277E-9]
[null,3.9000000000000101,4.6368272297581052,1.9221435554328536E-10,8.7744749035237064E-3,0.99122552490426197,2.6237901618045061E-49,5.9887256760282813E-41,0,0,0,0,0,0,0,0,0,null,5.9887257022661829E-41,5.6004712281760788E-10]
[null,4.0000000000000098,4.7368272297581049,8.9541263292858275E-11,6.2096652362346591E-3,0.99379033467422406,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$D130^(n-G$52)*$E130^G$52)","v":5.7559377266743783E-51},1.9958645371330283E-42,0,0,0,0,0,0,0,0,0,null,1.9958645428889659E-42,2.4906845973085364E-10]
[null,4.1000000000000103,4.8368272297581054,4.1123549010535498E-11,4.3324483218888429E-3,0.99566755163698761,1.1761235297569034E-52,6.1953485720843999E-44,0,0,0,0,0,0,0,0,0,null,6.1953485838456349E-44,1.0905034612340141E-10]
[null,4.2000000000000099,4.9368272297581051,1.86195503459885E-11,2.9797632164348924E-3,0.99702023676494556,2.237927143166639E-54,1.7907234219826023E-45,0,0,0,0,0,0,0,0,0,null,1.7907234242205296E-45,4.7005590239697827E-11]
[null,4.3000000000000096,5.0368272297581047,8.3110185400414593E-12,2.020137481634906E-3,0.99797986251005411,3.9652562253746831E-56,4.819122160883536E-47,0,0,0,0,0,0,0,0,0,null,4.8191221648487918E-47,1.9947391944356991E-11]
[null,4.4000000000000101,5.1368272297581052,3.6569636208128031E-12,1.3498980279730731E-3,0.99865010196837001,6.5403832880534422E-58,1.2071285659616529E-48,0,0,0,0,0,0,0,0,0,null,1.2071285666156912E-48,8.3336811594281585E-12]
[null,4.5000000000000098,5.2368272297581049,1.5860646129794986E-12,8.8902529752233131E-4,0.99911097470089161,1.0037010488672084E-59,2.8129863572089539E-50,0,0,0,0,0,0,0,0,0,null,2.8129863582126549E-50,3.4276919840479211E-12]
[null,4.6000000000000103,5.3368272297581054,6.780132011385831E-13,5.7702504171272724E-4,0.99942297495760923,1.432817077075556E-61,6.0970150159159069E-52,0,0,0,0,0,0,0,0,0,null,6.0970150173487243E-52,1.3879724497628082E-12]
[null,4.7000000000000099,5.4368272297581051,2.8577140653851529E-13,3.6907845398927863E-4,0.99963092154572497,1.9058725801307204E-63,1.2307328327482612E-53,0,0,0,0,0,0,0,0,0,null,1.2307328329388485E-53,5.5331704819267248E-13]
[null,4.8000000000000096,5.5368272297581047,1.184607967275042E-13,2.3262907891705387E-4,0.99976737092096446,2.3327771151203666E-65,2.2905121635199825E-55,0,0,0,0,0,0,0,0,0,null,2.2905121637532601E-55,2.1716078644888493E-13]
[null,4.9000000000000101,5.6368272297581052,4.8405723873656825E-14,1.4448072583282275E-4,0.99985551927411875,2.6575631634844866E-67,3.9661286319051622E-57,0,0,0,0,0,0,0,0,0,null,3.9661286321709187E-57,8.3907910997898711E-14]
[null,5.0000000000000098,5.7368272297581049,1.9317880628477724E-14,8.8417285181481719E-5,0.99991158271479919,2.6902794265941011E-69,6.1566588968457668E-59,0,0,0,0,0,0,0,0,0,null,6.1566588971147948E-59,3.191821241898694E-14]
[]
[null,"Calculations for 3-dimensional OC graph"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table for OC graph"]
[null,null,"pa","pm","pd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pm"]
[null,null,{"$f":"1-(D145+E145)","v":0},1,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C145^(n-G$52)*$D145^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF($C145>0.9999999,1,IF($C145=0,0,SUM(F145:P145)))","v":0},null,null,"Pd",0,0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1]
[null,null,{"$f":"1-(D146+E146)","v":0},0.9,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C146^(n-G$52)*$D146^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0,null,null,1,null,{"$f":"+S200","v":4.0000000000982687E-25}]
[null,null,9.9999999999999978E-2,0.9,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C147^(n-G$52)*$D147^G$52)","v":9.9999999999999873E-6},4.4999999999999955E-4,0,0,0,0,0,0,0,0,0,null,null,4.5999999999999953E-4,null,null,0.9,null,9.9999990001999978E-6,{"$f":"+S190","v":0}]
[null,null,0,0.8,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C148^(n-G$52)*$D148^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0,null,null,0.8,null,3.1999999200079993E-4,5.9999999999999934E-5,{"$f":"+S181","v":0}]
[null,null,9.9999999999999978E-2,0.8,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C149^(n-G$52)*$D149^G$52)","v":9.9999999999999873E-6},3.9999999999999959E-4,0,0,0,0,0,0,0,0,0,null,null,4.0999999999999956E-4,null,null,0.7,null,2.4299999730018037E-3,1.1200000000000016E-3,1.100000000000004E-4,{"$f":"+S173","v":0}]
[null,null,0.19999999999999996,0.8,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C150^(n-G$52)*$D150^G$52)","v":3.1999999999999959E-4},6.3999999999999934E-3,0,0,0,0,0,0,0,0,0,null,null,6.7199999999999933E-3,null,null,0.6,null,1.023999993600321E-2,6.480000000000004E-3,1.9199999999999979E-3,1.6000000000000058E-4,{"$f":"+S166","v":0}]
[null,null,0,0.7,0.3,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C151^(n-G$52)*$D151^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0,null,null,0.5,null,3.1249999875005017E-2,2.3040000000000012E-2,1.0530000000000006E-2,2.7199999999999967E-3,2.0999999999999979E-4,{"$f":"+S160","v":0}]
[null,null,0.10000000000000009,0.7,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C152^(n-G$52)*$D152^G$52)","v":1.0000000000000045E-5},3.5000000000000119E-4,0,0,0,0,0,0,0,0,0,null,null,3.6000000000000122E-4,null,null,0.4,null,7.7759999784007217E-2,6.25E-2,3.5839999999999962E-2,1.4580000000000008E-2,3.5199999999999962E-3,2.5999999999999971E-4,{"$f":"+S155","v":0}]
[null,null,0.20000000000000007,0.7,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C153^(n-G$52)*$D153^G$52)","v":3.2000000000000057E-4},5.6000000000000069E-3,0,0,0,0,0,0,0,0,0,null,null,5.9200000000000077E-3,null,null,0.3,null,0.16806999965700981,0.14255999999999999,9.375E-2,4.8640000000000023E-2,1.8630000000000011E-2,4.3199999999999957E-3,{"$f":"+S156","v":3.1000000000000108E-4},{"$f":"+S151","v":0}]
[null,null,0.30000000000000004,0.7,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C154^(n-G$52)*$D154^G$52)","v":2.4300000000000016E-3},2.8350000000000014E-2,0,0,0,0,0,0,0,0,0,null,null,3.0780000000000016E-2,null,null,0.2,null,0.3276799994880128,0.28811999999999993,0.20735999999999999,0.125,6.1439999999999932E-2,2.2680000000000013E-2,{"$f":"+S157","v":5.1199999999999943E-3},{"$f":"+S152","v":3.6000000000000122E-4},{"$f":"+S148","v":0}]
[null,null,0,0.6,0.4,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C155^(n-G$52)*$D155^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0,null,null,0.1,null,{"$f":"+S209","v":0.59048999927101598},{"$f":"+S198","v":0.53248000000000029},{"$f":"+S188","v":0.40816999999999992},{"$f":"+S179","v":0.27215999999999996},0.15625,7.4240000000000028E-2,{"$f":"+S158","v":2.6730000000000014E-2},{"$f":"+S153","v":5.9200000000000077E-3},{"$f":"+S149","v":4.0999999999999956E-4},{"$f":"+S146","v":0}]
[null,null,0.10000000000000009,0.6,0.3,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C156^(n-G$52)*$D156^G$52)","v":1.0000000000000045E-5},3.0000000000000106E-4,0,0,0,0,0,0,0,0,0,null,null,3.1000000000000108E-4,null,null,0,null,{"$f":"+S210","v":0.99999999900002035},{"$f":"+S199","v":0.91854000000000036},{"$f":"+S189","v":0.73728000000000038},{"$f":"+S180","v":0.52821999999999991},0.33695999999999998,0.1875,{"$f":"+S159","v":8.7040000000000034E-2},{"$f":"+S154","v":3.0780000000000016E-2},{"$f":"+S150","v":6.7199999999999933E-3},{"$f":"+S147","v":4.5999999999999953E-4},{"$f":"+S145","v":0}]
[null,null,0.19999999999999996,0.6,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C157^(n-G$52)*$D157^G$52)","v":3.1999999999999959E-4},4.7999999999999944E-3,0,0,0,0,0,0,0,0,0,null,null,5.1199999999999943E-3]
[null,null,0.30000000000000004,0.6,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C158^(n-G$52)*$D158^G$52)","v":2.4300000000000016E-3},2.4300000000000013E-2,0,0,0,0,0,0,0,0,0,null,null,2.6730000000000014E-2]
[null,null,0.4,0.6,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C159^(n-G$52)*$D159^G$52)","v":1.0240000000000006E-2},7.6800000000000035E-2,0,0,0,0,0,0,0,0,0,null,null,8.7040000000000034E-2]
[null,null,0,0.5,0.5,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C160^(n-G$52)*$D160^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,9.9999999999999978E-2,0.5,0.4,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C161^(n-G$52)*$D161^G$52)","v":9.9999999999999873E-6},2.4999999999999973E-4,0,0,0,0,0,0,0,0,0,null,null,2.5999999999999971E-4]
[null,null,0.19999999999999996,0.5,0.3,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C162^(n-G$52)*$D162^G$52)","v":3.1999999999999959E-4},3.9999999999999957E-3,0,0,0,0,0,0,0,0,0,null,null,4.3199999999999957E-3]
[null,null,0.30000000000000004,0.5,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C163^(n-G$52)*$D163^G$52)","v":2.4300000000000016E-3},2.0250000000000011E-2,0,0,0,0,0,0,0,0,0,null,null,2.2680000000000013E-2]
[null,null,0.4,0.5,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C164^(n-G$52)*$D164^G$52)","v":1.0240000000000006E-2},6.4000000000000029E-2,0,0,0,0,0,0,0,0,0,null,null,7.4240000000000028E-2]
[null,null,0.5,0.5,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C165^(n-G$52)*$D165^G$52)","v":3.125E-2},0.15625,0,0,0,0,0,0,0,0,0,null,null,0.1875]
[null,null,0,0.4,0.6,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C166^(n-G$52)*$D166^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,9.9999999999999978E-2,0.4,0.5,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C167^(n-G$52)*$D167^G$52)","v":9.9999999999999873E-6},1.9999999999999979E-4,0,0,0,0,0,0,0,0,0,null,null,2.0999999999999979E-4]
[null,null,0.19999999999999996,0.4,0.4,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C168^(n-G$52)*$D168^G$52)","v":3.1999999999999959E-4},3.1999999999999967E-3,0,0,0,0,0,0,0,0,0,null,null,3.5199999999999962E-3]
[null,null,0.30000000000000004,0.4,0.3,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C169^(n-G$52)*$D169^G$52)","v":2.4300000000000016E-3},1.620000000000001E-2,0,0,0,0,0,0,0,0,0,null,null,1.8630000000000011E-2]
[null,null,0.39999999999999991,0.4,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C170^(n-G$52)*$D170^G$52)","v":1.0239999999999987E-2},5.1199999999999947E-2,0,0,0,0,0,0,0,0,0,null,null,6.1439999999999932E-2]
[null,null,0.5,0.4,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C171^(n-G$52)*$D171^G$52)","v":3.125E-2},0.125,0,0,0,0,0,0,0,0,0,null,null,0.15625]
[null,null,0.6,0.4,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C172^(n-G$52)*$D172^G$52)","v":7.7759999999999996E-2},0.25919999999999999,0,0,0,0,0,0,0,0,0,null,null,0.33695999999999998]
[null,null,0,0.3,0.7,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C173^(n-G$52)*$D173^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,0.10000000000000009,0.3,0.6,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C174^(n-G$52)*$D174^G$52)","v":1.0000000000000045E-5},1.5000000000000053E-4,0,0,0,0,0,0,0,0,0,null,null,1.6000000000000058E-4]
[null,null,0.19999999999999996,0.3,0.5,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C175^(n-G$52)*$D175^G$52)","v":3.1999999999999959E-4},2.3999999999999972E-3,0,0,0,0,0,0,0,0,0,null,null,2.7199999999999967E-3]
[null,null,0.30000000000000004,0.3,0.4,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C176^(n-G$52)*$D176^G$52)","v":2.4300000000000016E-3},1.2150000000000006E-2,0,0,0,0,0,0,0,0,0,null,null,1.4580000000000008E-2]
[null,null,0.4,0.3,0.3,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C177^(n-G$52)*$D177^G$52)","v":1.0240000000000006E-2},3.8400000000000017E-2,0,0,0,0,0,0,0,0,0,null,null,4.8640000000000023E-2]
[null,null,0.5,0.3,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C178^(n-G$52)*$D178^G$52)","v":3.125E-2},9.375E-2,0,0,0,0,0,0,0,0,0,null,null,0.125]
[null,null,0.6,0.3,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C179^(n-G$52)*$D179^G$52)","v":7.7759999999999996E-2},0.19439999999999996,0,0,0,0,0,0,0,0,0,null,null,0.27215999999999996]
[null,null,0.7,0.3,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C180^(n-G$52)*$D180^G$52)","v":0.16806999999999994},0.36014999999999991,0,0,0,0,0,0,0,0,0,null,null,0.52821999999999991]
[null,null,0,0.2,0.8,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C181^(n-G$52)*$D181^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,0.10000000000000009,0.2,0.7,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C182^(n-G$52)*$D182^G$52)","v":1.0000000000000045E-5},1.0000000000000036E-4,0,0,0,0,0,0,0,0,0,null,null,1.100000000000004E-4]
[null,null,0.19999999999999996,0.2,0.6,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C183^(n-G$52)*$D183^G$52)","v":3.1999999999999959E-4},1.5999999999999983E-3,0,0,0,0,0,0,0,0,0,null,null,1.9199999999999979E-3]
[null,null,0.30000000000000004,0.2,0.5,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C184^(n-G$52)*$D184^G$52)","v":2.4300000000000016E-3},8.1000000000000048E-3,0,0,0,0,0,0,0,0,0,null,null,1.0530000000000006E-2]
[null,null,0.39999999999999991,0.2,0.4,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C185^(n-G$52)*$D185^G$52)","v":1.0239999999999987E-2},2.5599999999999973E-2,0,0,0,0,0,0,0,0,0,null,null,3.5839999999999962E-2]
[null,null,0.5,0.2,0.3,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C186^(n-G$52)*$D186^G$52)","v":3.125E-2},6.25E-2,0,0,0,0,0,0,0,0,0,null,null,9.375E-2]
[null,null,0.6,0.2,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C187^(n-G$52)*$D187^G$52)","v":7.7759999999999996E-2},0.12959999999999999,0,0,0,0,0,0,0,0,0,null,null,0.20735999999999999]
[null,null,0.7,0.2,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C188^(n-G$52)*$D188^G$52)","v":0.16806999999999994},0.24009999999999995,0,0,0,0,0,0,0,0,0,null,null,0.40816999999999992]
[null,null,0.8,0.2,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C189^(n-G$52)*$D189^G$52)","v":0.32768000000000019},0.40960000000000019,0,0,0,0,0,0,0,0,0,null,null,0.73728000000000038]
[null,null,0,0.1,0.9,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C190^(n-G$52)*$D190^G$52)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,0]
[null,null,9.9999999999999978E-2,0.1,0.8,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C191^(n-G$52)*$D191^G$52)","v":9.9999999999999873E-6},4.9999999999999948E-5,0,0,0,0,0,0,0,0,0,null,null,5.9999999999999934E-5]
[null,null,0.20000000000000007,0.1,0.7,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C192^(n-G$52)*$D192^G$52)","v":3.2000000000000057E-4},8.0000000000000112E-4,0,0,0,0,0,0,0,0,0,null,null,1.1200000000000016E-3]
[null,null,0.30000000000000004,0.1,0.6,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C193^(n-G$52)*$D193^G$52)","v":2.4300000000000016E-3},4.0500000000000024E-3,0,0,0,0,0,0,0,0,0,null,null,6.480000000000004E-3]
[null,null,0.4,0.1,0.5,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C194^(n-G$52)*$D194^G$52)","v":1.0240000000000006E-2},1.2800000000000006E-2,0,0,0,0,0,0,0,0,0,null,null,2.3040000000000012E-2]
[null,null,0.5,0.1,0.4,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C195^(n-G$52)*$D195^G$52)","v":3.125E-2},3.125E-2,0,0,0,0,0,0,0,0,0,null,null,6.25E-2]
[null,null,0.6,0.1,0.3,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C196^(n-G$52)*$D196^G$52)","v":7.7759999999999996E-2},6.4799999999999996E-2,0,0,0,0,0,0,0,0,0,null,null,0.14255999999999999]
[null,null,0.7,0.1,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C197^(n-G$52)*$D197^G$52)","v":0.16806999999999994},0.12004999999999998,0,0,0,0,0,0,0,0,0,null,null,0.28811999999999993]
[null,null,0.8,0.1,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C198^(n-G$52)*$D198^G$52)","v":0.32768000000000019},0.20480000000000009,0,0,0,0,0,0,0,0,0,null,null,0.53248000000000029]
[null,null,0.9,0.1,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C199^(n-G$52)*$D199^G$52)","v":0.59049000000000018},0.32805000000000012,0,0,0,0,0,0,0,0,0,null,null,0.91854000000000036]
[null,null,-1.0000000000065512E-5,1.0000000000000001E-5,1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C200^(n-G$52)*$D200^G$52)","v":-1.0000000000327562E-25},5.000000000131025E-25,0,0,0,0,0,0,0,0,0,null,null,4.0000000000982687E-25]
[null,null,9.9990000000000023E-2,1.0000000000000001E-5,0.9,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C201^(n-G$52)*$D201^G$52)","v":9.9950009999000173E-6},4.9980002999800058E-9,0,0,0,0,0,0,0,0,0,null,null,9.9999990001999978E-6]
[null,null,0.19999,1.0000000000000001E-5,0.8,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C202^(n-G$52)*$D202^G$52)","v":3.1992000799959997E-4},7.9984001199959995E-8,0,0,0,0,0,0,0,0,0,null,null,3.1999999200079993E-4]
[null,null,0.29999000000000009,1.0000000000000001E-5,0.7,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C203^(n-G$52)*$D203^G$52)","v":2.4295950269991036E-3},4.0494600269994047E-7,0,0,0,0,0,0,0,0,0,null,null,2.4299999730018037E-3]
[null,null,0.39999000000000007,1.0000000000000001E-5,0.6,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C204^(n-G$52)*$D204^G$52)","v":1.0238720063998411E-2},1.2798720047999211E-6,0,0,0,0,0,0,0,0,0,null,null,1.023999993600321E-2]
[null,null,0.49999000000000005,1.0000000000000001E-5,0.5,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C205^(n-G$52)*$D205^G$52)","v":3.1246875124997516E-2},3.1247500074999016E-6,0,0,0,0,0,0,0,0,0,null,null,3.1249999875005017E-2]
[null,null,0.59999000000000002,1.0000000000000001E-5,0.4,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C206^(n-G$52)*$D206^G$52)","v":7.7753520215996422E-2},6.4795680107998816E-6,0,0,0,0,0,0,0,0,0,null,null,7.7759999784007217E-2]
[null,null,0.69999,1.0000000000000001E-5,0.3,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C207^(n-G$52)*$D207^G$52)","v":0.16805799534299509},1.200431401469986E-5,0,0,0,0,0,0,0,0,0,null,null,0.16806999965700981]
[null,null,0.79998999999999998,1.0000000000000001E-5,0.2,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C208^(n-G$52)*$D208^G$52)","v":0.3276595205119936},2.0478976019199841E-5,0,0,0,0,0,0,0,0,0,null,null,0.3276799994880128]
[null,null,0.89998999999999996,1.0000000000000001E-5,0.1,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C209^(n-G$52)*$D209^G$52)","v":0.59045719572899169},3.280354202429981E-5,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF($C209>0.9999999,1,IF($C209=0,0,SUM(F209:P209)))","v":0.59048999927101598}]
[null,null,{"$f":"1-(D210+E210)","v":0.99999000000000005},1.0000000000000001E-5,0,{"$f":"IF(G$52>cm,0,(COMBIN(n,G$52))*$C210^(n-G$52)*$D210^G$52)","v":0.99995000099999032},4.9998000029999818E-5,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF($C210>0.9999999,1,IF($C210=0,0,SUM(F210:P210)))","v":0.99999999900002035}]

{"sheet":"2-class enrich sensspec","index":7,"n_rows":138,"n_cols":34,"rows_kept":138,"cut":false,"hidden":false,"merged":[[56,1,56,10],[50,1,50,10],[26,1,26,6],[17,11,17,12],[0,1,1,6],[0,8,1,13],[35,1,35,20],[36,1,36,20],[0,33,1,38],[29,15,29,20],[29,8,29,13],[0,15,1,20],[17,8,17,9]]}
[null,{"$f":"\"Operating characteristic curve for proportion defective, with n=\"&n&\" and c=\"&cm","v":"Operating characteristic curve for proportion defective, with n=30 and c=0"},null,null,null,null,null,null,{"$f":"\"Probability density function (PDF) for log counts.  Distribution mean = \"&FIXED(meanlog,2)&\" and sigma = \"&FIXED(sigma,2)","v":"Probability density function (PDF) for log counts.  Distribution mean = -2.31 and sigma = 0.80"},null,null,null,null,null,null,{"$f":"\"Operating characteristic curve scaled to relate log arithmetic mean count to m\"","v":"Operating characteristic curve scaled to relate log arithmetic mean count to m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Operating characteristic curve scaled to relate mean log count to m\"","v":"Operating characteristic curve scaled to relate mean log count to m"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"INPUTS",null,null,"P(accept)"]
[null,null,"Lot acceptance for Pd",null,null,null,null,null,"mean",-2.3120615031039637,null,"Computed",{"$f":"$F$53*100","v":5.0007645574245325},"%"]
[null,null,null,null,null,"P(accept)",null,null,"sigma",0.8,null,"Desired",5,"%"]
[null,null,"Pd",20,"%",{"$f":"$F$54*100","v":0.12379400392853797},"%",null,"m",{"$f":"-LOG(weight)","v":-1}]
[null,null,"actualPd",{"$f":"+Pd*100","v":9.5029240538933628},"%",{"$f":"+computed_P","v":5.0007645574245325},"%",null,"n",30,null,null,null,null,null,null,null,"Ideal method",{"$f":"F55*100","v":1.2562912102819594},"%"]
[null,null,null,null,null,null,null,null,"c",0,null,null,null,null,null,null,null,"Actual test",{"$f":"computed_P","v":5.0007645574245325},"%"]
[]
[null,null,null,null,null,null,null,null,"amount",10,"g",null,null,null,null,"specificity and sensitivity of the test are assumed to be fixed values "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"and not dependant on the concentration of the organisms.  "]
[null,"Sandbox: for your own calculations",null,null,null,null,null,null,"sensitivity",0.7]
[null,"FSO",-1,null,null,null,null,null,"specificity",1,null,"P(reject)",{"$f":"100-computed_P","v":94.999235442575468},"%"]
[null,"complient",{"$f":"_xlfn.NORM.DIST(C28,meanlog,sigma,1)","v":0.94950540843463016},"not comply",{"$f":"1-_xlfn.NORM.DIST(C28,meanlog,sigma,1)","v":5.049459156536984E-2}]
[null,"%",{"$f":"100*C29","v":94.950540843463017},"%",{"$f":"100*E29","v":5.049459156536984},null,null,null,"Means",null,null,null,null,null,null,"Implied Acceptance level "]
[null,null,null,null,null,null,null,null,null,"Arithmetic (=Average)",null,null,"Geometric (=Median)",null,null,"Percentile","z-score","Concentration at this percentile"]
[null,null,null,null,null,null,null,null,null,{"$f":"10^(meanlog+0.5*sigma^2*LN(10))","v":2.6592901604535091E-2},"cfu/g",null,{"$f":"10^meanlog","v":4.8745945309367012E-3},"cfu/g",null,99.9,{"$f":"+TINV(2*(1-P32/100),1000)","v":3.0984021639129624},null,{"$f":"+meanlog+Q32*sigma","v":0.16666022802640645}]
[null,null,null,null,null,null,null,null,"one cfu in",{"$f":"1/J32","v":37.604019857293885},"grams","one cfu in",{"$f":"1/M32","v":205.14526770452028},"grams",null,"FSO","P(exceedance)",null,"target level"]
[null,null,null,null,null,null,null,null,null,{"$f":"+LOG(J32)","v":-1.5752342733458693},"log cfu/g",null,{"$f":"+LOG(M32)","v":-2.3120615031039637},"log cfu/g",null,{"$f":"+S32","v":0.16666022802640645},{"$f":"1-_xlfn.NORM.DIST(P34,meanlog,sigma,1)","v":9.7283600143704962E-4},null,{"$f":"+P34-Q32*sigma","v":-2.3120615031039637}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(ABS(computed_P-desired_P)<0.001,\"This sampling plan would provide \"&FIXED(M28,0)&\" % confidence that a lot of food containing a geometric mean concentration of 1 organism in \"&FIXED(M33,1)&\" g and an arithmetic mean concentration of 1 organism in \"&FIXED(J33,1)&\" g\",\"\")","v":"This sampling plan would provide 95 % confidence that a lot of food containing a geometric mean concentration of 1 organism in 205.1 g and an arithmetic mean concentration of 1 organism in 37.6 g"}]
[null,{"$f":"IF(ABS(computed_P-desired_P)<0.001,\"(and having a standard deviation of \"&FIXED(sigma,2)&\" log cfu/g), would be rejected (i.e. more than \"&cm&\" out of \"&n&\" samples of \"&weight&\" grams giving detection of the organism) for method with sensitivity=\"&sens&\" and selectivity=\"&spec,\"\")","v":"(and having a standard deviation of 0.80 log cfu/g), would be rejected (i.e. more than 0 out of 30 samples of 10 grams giving detection of the organism) for method with sensitivity=0.7 and selectivity=1"}]
[null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The calculations below are for the buttons above.  Do not edit."]
[null,"geo mean","arith mean","pa","pd","P(accept)"]
[null,{"$f":"meanlog","v":-2.3120615031039637},{"$f":"+B53+0.5*LN(10)*sigma^2","v":-1.5752342733458691},{"$f":"1-poissonlognormal(meanlog,sigma,10^-m)","v":0.86424394208723765},{"$f":"(1-D53)*sens+D53*(1-spec)","v":9.5029240538933635E-2},{"$f":"+BINOMDIST(cm,n,$E53,1)","v":5.0007645574245328E-2},null,"<= Used by macros for finding mean and n"]
[null,null,null,{"$f":"1-E54","v":0.8},{"$f":"$D$21/100","v":0.2},{"$f":"+BINOMDIST(cm,n,$E54,1)","v":1.2379400392853797E-3},null,"<= Used in test against ICMSF tables"]
[null,{"$f":"meanlog","v":-2.3120615031039637},{"$f":"+B55+0.5*LN(10)*sigma^2","v":-1.5752342733458691},{"$f":"1-poissonlognormal(meanlog,sigma,10^-m)","v":0.86424394208723765},{"$f":"1-D55","v":0.13575605791276235},{"$f":"+BINOMDIST(cm,n,$E55,1)","v":1.2562912102819594E-2},null,"<= For ideal method"]
[]
[null,"The calculations below are for the charts above.  Do not edit."]
[null,-6,{"$f":"+B58+0.5*LN(10)*sigma^2","v":-5.2631727702419049},{"$f":"1-poissonlognormal(B58,sigma,10^-m)","v":0.99994548960024632},{"$f":"(1-D58)*sens+D58*(1-spec)","v":3.8157279827577546E-5},{"$f":"+BINOMDIST(cm,n,$E58,1)","v":0.99885591473010438},{"$f":"NORMDIST($B58,meanlog,sigma,FALSE)","v":1.2109859854084543E-5},null,{"$f":"1-poissonlognormal(B58,sigma,10^-m)","v":0.99994548960024632},{"$f":"1-I58","v":5.4510399753682215E-5},{"$f":"+BINOMDIST(cm,n,$J58,1)","v":0.99836597990192921},null,null,null,null,{"$f":"+B58+0.5*LN(10)*sigma^2","v":-5.2631727702419049}]
[null,-5.9,-5.1631727702419052,0.99993138949259519,4.8027355183366537E-5,0.99856018227755117,2.1379828304287613E-5,null,0.99993138949259519,6.861050740480934E-5,0.99794373118692625,null,null,null,null,-5.1631727702419052]
[null,-5.8,-5.0631727702419047,0.99991364656739534,6.0447402823260438E-5,0.99818816646044461,3.7160663352410155E-5,null,0.99991364656739534,8.6353432604657776E-5,0.99741263816719206,null,null,null,null,-5.0631727702419047]
[null,-5.7,-4.9631727702419051,0.99989132219545562,7.6074463181063915E-5,0.99772028180391681,6.3588246841249279E-5,null,0.99989132219545562,1.0867780454437703E-4,0.99674479838252139,null,null,null,null,-4.9631727702419051]
[null,-5.6,-4.8631727702419045,0.99986323729009463,9.5733896933758439E-5,0.99713196629792211,1.0712341117634339E-4,null,0.99986323729009463,1.3676270990536921E-4,0.9959052445837655,null,null,null,null,-4.8631727702419045]
[null,-5.5,-4.7631727702419049,0.99982791146608296,1.2046197374192545E-4,0.9963924460193867,1.7766671995912635E-4,null,0.99982791146608296,1.7208853391703638E-4,0.99485020560711002,null,null,null,null,-4.7631727702419049]
[null,-5.4,-4.6631727702419052,0.99978348720560439,1.5155895607692481E-4,0.99546320919892062,2.9009612268504755E-4,null,0.99978348720560439,2.1651279439560689E-4,0.99352496685945302,null,null,null,null,-4.6631727702419052]
[null,-5.3,-4.5631727702419047,0.99972763554085098,1.9065512140431506E-4,0.9942961302357175,4.6632845072666439E-4,null,0.99972763554085098,2.7236445914902152E-4,0.9918612536886463,null,null,null,null,-4.5631727702419047]
[null,-5.2,-4.4631727702419051,0.99965743905015303,2.397926648928794E-4,0.99283117689073352,7.3799946958098828E-4,null,0.99965743905015303,3.4256094984697061E-4,0.98977405505589233,null,null,null,null,-4.4631727702419051]
[null,-5.0999999999999996,-4.3631727702419045,0.99956924715348427,3.0152699256100755E-4,0.9909936287062765,1.1498318531506396E-3,null,0.99956924715348427,4.307528465157251E-4,0.98715780443548751,null,null,null,null,-4.3631727702419045]
[null,-5,-4.2631727702419049,0.99945849779286489,3.7905154499457967E-4,0.98869073393053886,1.7637083459874068E-3,null,0.99945849779286489,5.4150220713511388E-4,0.98388184420010483,null,null,null,null,-4.2631727702419049]
[null,-4.9000000000000004,-4.1631727702419052,0.99931949861648361,4.7635096846146972E-4,0.98580773946935041,2.6633813435535665E-3,null,0.99931949861648361,6.8050138351638534E-4,0.9797851256586686,null,null,null,null,-4.1631727702419052]
[null,-4.8,-4.0631727702419047,0.99914515979478735,5.983881436488536E-4,0.98220324902315237,3.9596252519925332E-3,null,0.99914515979478735,8.5484020521264803E-4,0.97467014925122031,"Coordinates to place m",null,null,null,-4.0631727702419047]
[null,-4.7,-3.9631727702419055,0.99892666965172705,7.5133124379106464E-4,0.97770390634320037,5.795474055033137E-3,null,0.99892666965172705,1.0733303482729495E-3,0.96829624200669762,"proportion",null,"m",null,-3.9631727702419055]
[null,-4.5999999999999996,-3.863172770241905,0.99865310349923675,9.4282755053427532E-4,0.97209847418845452,8.3509906098241451E-3,null,0.99865310349923675,1.3468965007632505E-3,0.96037242078148588,0,0,{"$f":"m","v":-1},null,-3.863172770241905]
[null,-4.5000000000000098,-3.7631727702419151,0.99831095556600058,1.1823311037995941E-3,0.96513149926438102,1.1846803186245241E-2,null,0.99831095556600058,1.6890444339994204E-3,0.95055032338727286,{"$f":"1.1*NORMDIST(meanlog,meanlog,sigma,FALSE)","v":0.54854563555197},1,{"$f":"m","v":-1},null,-3.7631727702419151]
[null,-4.4000000000000101,-3.6631727702419155,0.99788358391250132,1.4814912612490794E-3,0.95649693678191372,1.6545446830885307E-2,null,0.99788358391250132,2.1164160874986848E-3,0.93841803229168186,null,null,null,null,-3.6631727702419155]
[null,-4.3000000000000096,-3.5631727702419149,0.99735055898070435,1.8546087135069553E-3,0.94583237517976282,2.2749401518075585E-2,null,0.99735055898070435,2.6494410192956508E-3,0.92349609300243651,null,null,null,null,-3.5631727702419149]
[null,-4.2000000000000099,-3.4631727702419153,0.9966869082548544,2.3191642216019211E-3,0.93271487090716954,3.0794673240735655E-2,null,0.9966869082548544,3.3130917451456021E-3,0.90523765678154611,null,null,null,null,-3.4631727702419153]
[null,-4.1000000000000103,-3.3631727702419156,0.99586225277882201,2.8964230548245927E-3,0.91665988595210268,4.1038868032710701E-2,null,0.99586225277882201,4.1377472211779898E-3,0.88303544153599811,null,null,null,null,-3.3631727702419156]
[null,-4.0000000000000098,-3.2631727702419151,0.99483983638995965,3.6121145270282427E-3,0.89712540754985692,5.3843005606954472E-2,null,0.99483983638995965,5.160163610040347E-3,0.85623903358495923,null,null,null,null,-3.2631727702419151]
[null,-3.9000000000000101,-3.1631727702419155,0.99357545589811147,4.4971808713219702E-3,0.87352397014215877,6.9546834179960201E-2,null,0.99357545589811147,6.4245441018885296E-3,0.82418677248600303,null,null,null,null,-3.1631727702419155]
[null,-3.80000000000001,-3.0631727702419154,0.99201631042417893,5.5885827030747511E-3,0.84524587490539027,8.8438136842112616E-2,null,0.99201631042417893,7.9836895758210735E-3,0.78625674195775241,"Coordinates to place Pd",null,null,null,-3.0631727702419154]
[null,-3.7000000000000099,-2.9631727702419153,0.99009980096315975,6.9301393257881752E-3,0.81169718929324142,0.1107174188284382,null,0.99009980096315975,9.9001990368402515E-3,0.74194070127988476,"p accept",null,null,null,-2.9631727702419153]
[null,-3.6000000000000099,-2.8631727702419152,0.98775232699545146,8.5733711031839785E-3,0.77235575239690357,0.13646034630124801,null,0.98775232699545146,1.2247673004548543E-2,0.69094240067687207,"x","y",null,null,-2.8631727702419152]
[null,-3.5000000000000102,-2.7631727702419155,0.98488814537278202,1.0578298239052585E-2,0.72684692191436162,0.16558124145106048,null,0.98488814537278202,1.511185462721798E-2,0.63329681311393027,{"$f":"+Pd","v":9.5029240538933635E-2},0,null,null,-2.7631727702419155]
[null,-3.4000000000000101,-2.6631727702419155,0.98140837706802708,1.3014136052381041E-2,0.67503761969427656,0.19780166750545505,null,0.98140837706802708,1.8591622931972918E-2,0.56949880988774693,{"$f":"+Pd","v":9.5029240538933635E-2},{"$f":"+desired_P/100","v":0.05},null,null,-2.6631727702419155]
[null,-3.30000000000001,-2.5631727702419154,0.97720026849751285,1.5959812051741008E-2,0.61714193526055905,0.23262849512169276,null,0.97720026849751285,2.2799731502487153E-2,0.50061900057823139,null,null,null,null,-2.5631727702419154]
[null,-3.2000000000000099,-2.4631727702419153,0.97213683420296915,1.9504216057921596E-2,0.55382418520288412,0.26934568520019736,null,0.97213683420296915,2.7863165797030853E-2,0.4283728768784385,null,null,null,null,-2.4631727702419153]
[null,-3.1000000000000099,-2.3631727702419152,0.96607702430925391,2.3746082983522265E-2,0.48627694785866044,0.30702326296086624,null,0.96607702430925391,3.3922975690746093E-2,0.35510158370599537,null,null,null,null,-2.3631727702419152]
[null,-3.0000000000000102,-2.2631727702419155,0.9588665703960999,2.8793400722730064E-2,0.41624472442354477,0.34454558709044242,null,0.9588665703960999,4.1133429603900096E-2,0.28362553873405594,null,null,null,null,-2.2631727702419155]
[null,-2.9000000000000101,-2.1631727702419155,0.95033966390158875,3.4762235268887873E-2,0.3459626042107759,0.38065912899519255,null,0.95033966390158875,4.9660336098411251E-2,0.21695300402037695,null,null,null,null,-2.1631727702419155]
[null,-2.80000000000001,{"$f":"+B90+0.5*LN(10)*sigma^2","v":-2.0631727702419154},{"$f":"1-poissonlognormal(B90,sigma,10^-m)","v":0.94032160849038515},{"$f":"(1-D90)*sens+D90*(1-spec)","v":4.1774874056730388E-2},{"$f":"+BINOMDIST(cm,n,$E90,1)","v":0.27798837419978822},{"$f":"NORMDIST($B90,meanlog,sigma,FALSE)","v":0.4140377653235513},null,{"$f":"1-poissonlognormal(B90,sigma,10^-m)","v":0.94032160849038515},{"$f":"1-I90","v":5.9678391509614848E-2},{"$f":"+BINOMDIST(cm,n,$J90,1)","v":0.15786741145690705},null,null,null,null,{"$f":"+B90+0.5*LN(10)*sigma^2","v":-2.0631727702419154}]
[null,-2.7000000000000099,-1.9631727702419153,0.92863255888117058,4.9957208783180593E-2,0.21492899515893096,0.44336132976215281,null,0.92863255888117058,7.1367441118829422E-2,0.10847188647783026,null,null,null,null,-1.9631727702419153]
[null,-2.6000000000000099,-1.8631727702419152,0.91509241119942852,5.9435312160400031E-2,0.15909630469259511,0.46740119113700546,null,0.91509241119942852,8.4907588800571476E-2,6.981497931999664E-2,null,null,null,null,-1.8631727702419152]
[null,-2.5000000000000102,-1.7631727702419155,0.89952684320250009,7.0331209758249927E-2,0.11216246551908245,0.48510524173858433,null,0.89952684320250009,0.10047315679749991,4.1727641239327616E-2,null,null,null,null,-1.7631727702419155]
[null,-2.4000000000000101,-1.6631727702419155,0.88177441791175737,8.2757907461769836E-2,7.4906463389633096E-2,0.49567414783065178,null,0.88177441791175737,0.11822558208824263,2.2946943531844847E-2,null,null,null,null,-1.6631727702419155]
[null,-2.30000000000001,-1.5631727702419154,0.86169456493456709,9.6813804545803031E-2,4.7132310789308719E-2,0.49862117592377486,null,0.86169456493456709,0.13830543506543291,1.1497425664271648E-2,null,null,null,null,-1.5631727702419154]
[null,-2.2000000000000099,-1.4631727702419153,0.8391761464056593,0.11257669751603848,2.7792323400236369E-2,0.49380935966388328,null,0.8391761464056593,0.1608238535943407,5.1951000520212244E-3,null,null,null,null,-1.4631727702419153]
[null,-2.1000000000000099,-1.3631727702419152,0.81414620795995329,0.1300976544280327,1.5279708035074425E-2,0.48146205447791712,null,0.81414620795995329,0.18585379204004671,2.0944602971759772E-3,null,null,null,null,-1.3631727702419152]
[null,-2.0000000000000102,-1.2631727702419155,0.78657842050767868,0.14939510564462491,7.7953625632556913E-3,0.46214574715930584,null,0.78657842050767868,0.21342157949232132,7.451793745849168E-4,null,null,null,null,-1.2631727702419155]
[null,-1.9000000000000099,-1.163172770241915,0.75650064803064532,0.17044954637854826,3.6752268808494309E-3,0.43672696313658055,null,0.75650064803064532,0.24349935196935468,2.3135512873791113E-4,null,null,null,null,-1.163172770241915]
[null,-1.80000000000001,-1.0631727702419154,0.72400104222958084,0.19319927043929341,1.5958367707745165E-3,0.40630783705799833,null,0.72400104222958084,0.27599895777041916,6.1969178864218483E-5,null,null,null,null,-1.0631727702419154]
[null,-1.7000000000000199,-0.96317277024192516,0.68923207694540123,0.21753754613821913,6.3665655995853569E-4,0.37214701648073045,null,0.68923207694540123,0.31076792305459877,1.4156778626903338E-5,null,null,null,null,-0.96317277024192516]
[null,-1.6000000000000201,-0.86317277024192529,0.65241200073524253,0.24331159948533021,2.330839116943389E-4,0.3355737897709638,null,0.65241200073524253,0.34758799926475747,2.7268310525382245E-6,null,null,null,null,-0.86317277024192529]
[null,-1.50000000000002,-0.7631727702419252,0.61382330673595831,0.27032368528482914,7.8326275999578764E-5,0.29790354573239597,null,0.61382330673595831,0.38617669326404169,4.3782568341070034E-7,null,null,null,null,-0.7631727702419252]
[null,-1.4000000000000199,-0.66317277024192511,0.5738079908377236,0.29833440641359343,2.4205019572376054E-5,0.26036191717031032,null,0.5738079908377236,0.4261920091622764,5.7942570496865126E-8,null,null,null,null,-0.66317277024192511]
[null,-1.30000000000002,-0.56317277024192525,0.5327595816357511,0.32706829285497419,6.904460592038008E-6,0.22402340709451685,null,0.5327595816357511,0.4672404183642489,6.2508355895733542E-9,null,null,null,null,-0.56317277024192525]
[null,-1.2000000000000199,-0.46317277024192516,0.4911121619977179,0.35622148660159747,1.8284973295433412E-6,0.18976821995199084,null,0.4911121619977179,0.5088878380022821,5.437768023641168E-10,null,null,null,null,-0.46317277024192516]
[null,-1.1000000000000201,-0.36317277024192529,0.44932684110572052,0.38547121122599559,4.5317609373680331E-7,0.15825874539128229,null,0.44932684110572052,0.55067315889427948,3.7745994727190671E-11,null,null,null,null,-0.36317277024192529]
[null,-1.00000000000002,-0.2631727702419252,0.40787635383631804,0.41448655231457737,1.0619552672387255E-7,0.12993498536405856,null,0.40787635383631804,0.59212364616368196,2.0694543448355329E-12,null,null,null,null,-0.2631727702419252]
[null,-0.90000000000002001,-0.16317277024192522,0.3672286378778602,0.44293995348549781,2.3826504466745322E-8,0.10502643736706919,null,0.3672286378778602,0.6327713621221398,8.8735265541852573E-14,null,null,null,null,-0.16317277024192522]
[null,-0.80000000000002003,-6.3172770241925247E-2,0.32783034806924782,0.47051875635152651,5.1941849297280319E-9,8.3576718382118109E-2,null,0.32783034806924782,0.67216965193075218,2.9476413782975333E-15,null,null,null,null,-6.3172770241925247E-2]
[null,-0.70000000000002005,3.6827229758074731E-2,0.29009129807817979,0.49693609134527411,1.118651539935491E-9,6.5476603685697021E-2,null,0.29009129807817979,0.70990870192182021,7.5169392708575016E-17,null,null,null,null,3.6827229758074731E-2]
[null,-0.60000000000001996,0.13682722975807482,0.25437076589712893,0.52194046387200976,2.4235923451224508E-10,5.0501133083844046E-2,null,0.25437076589712893,0.74562923410287107,1.4588677665839487E-18,null,null,null,null,0.13682722975807482]
[null,-0.50000000000001998,0.2368272297580748,0.2209664653375123,0.54532347426374139,5.3836396676880931E-11,3.8346898977950947E-2,null,0.2209664653375123,0.7790335346624877,2.1369337488387843E-20,null,null,null,null,0.2368272297580748]
[null,-0.40000000000002001,0.33682722975807478,0.19010678310070916,0.5669252518295036,1.2499304423744272E-11,2.8666424320495525E-2,null,0.19010678310070916,0.80989321689929084,2.3438423078517385E-22,null,null,null,null,0.33682722975807478]
[null,-0.30000000000001997,0.43682722975807481,0.16194663047575497,0.58663735866697153,3.0898451071198717E-12,2.1097497757409392E-2,null,0.16194663047575497,0.83805336952424503,1.9105459631629879E-24,null,null,null,null,0.43682722975807481]
[null,-0.20000000000002,0.53682722975807473,0.13656698554263591,0.6044031101201548,8.2715339671841892E-13,1.5286305066858734E-2,null,0.13656698554263591,0.86343301445736409,1.1491367097099593E-26,null,null,null,null,0.53682722975807473]
[null,-0.10000000000002,0.63682722975807482,0.11397793311365245,0.62021544682044327,2.4328700184838309E-13,1.0904060295353164E-2,null,0.11397793311365245,0.88602206688634755,5.0655116112736076E-29,null,null,null,null,0.63682722975807482]
[null,-2.0428103653102899E-14,0.73682722975807435,9.4124771667139617E-2,0.63411265983300225,7.9509951777335076E-14,7.6575195607159422E-3,null,9.4124771667139617E-2,0.90587522833286038,1.625990748615554E-31,null,null,null,null,0.73682722975807435]
[null,9.9999999999980105E-2,0.83682722975807489,7.6896570112306994E-2,0.64617240092138506,2.9090498623356471E-14,5.2942218259397784E-3,null,7.6896570112306994E-2,0.92310342988769301,3.777539985269037E-34,null,null,null,null,0.83682722975807489]
[null,0.19999999999998,0.93682722975807475,6.2136437007787149E-2,0.65650449409454892,1.1957262990807545E-14,3.603547923521576E-3,null,6.2136437007787149E-2,0.93786356299221285,6.3152478108301016E-37,null,null,null,null,0.93682722975807475]
[null,0.29999999999998,1.0368272297580747,4.9652716912245598E-2,0.66524309816142801,5.5193278849299579E-15,2.414752469122389E-3,null,4.9652716912245598E-2,0.9503472830877544,7.5559751354991254E-40,null,null,null,null,1.0368272297580747]
[null,0.39999999999997998,{"$f":"+B122+0.5*LN(10)*sigma^2","v":1.1368272297580748},{"$f":"1-poissonlognormal(B122,sigma,10^-m)","v":3.9230350427681859E-2},{"$f":"(1-D122)*sens+D122*(1-spec)","v":0.67253875470062263},{"$f":"+BINOMDIST(cm,n,$E122,1)","v":2.8496877267892442E-15},{"$f":"NORMDIST($B122,meanlog,sigma,FALSE)","v":1.5930488163303101E-3},null,{"$f":"1-poissonlognormal(B122,sigma,10^-m)","v":3.9230350427681859E-2},{"$f":"1-I122","v":0.96076964957231814},{"$f":"+BINOMDIST(cm,n,$J122,1)","v":6.4367349363664891E-43},null,null,null,null,{"$f":"+B122+0.5*LN(10)*sigma^2","v":1.1368272297580748}]
[null,0.49999999999998002,1.2368272297580747,3.0641717133543356E-2,0.67855079800651963,1.6344459318948521E-15,1.0346648572645779E-3,null,3.0641717133543356E-2,0.96935828286645664,3.8850174438021377E-46,null,null,null,null,1.2368272297580747]
[null,0.59999999999997999,1.3368272297580748,2.3656408555223329E-2,0.68344051401134365,1.0319531053785544E-15,6.6158318914693291E-4,null,2.3656408555223329E-2,0.97634359144477667,1.6537290690324179E-49,null,null,null,null,1.3368272297580748]
[null,0.69999999999997997,1.4368272297580749,1.8049533885252877E-2,0.68736532628032299,7.0976453328333493E-16,4.1646966429804581E-4,null,1.8049533885252877E-2,0.98195046611474712,4.9428761908105495E-53,null,null,null,null,1.4368272297580749]
[null,0.79999999999997995,1.5368272297580747,1.3608325870984372E-2,0.69047417189031091,5.2590442576115001E-16,2.581050091375559E-4,null,1.3608325870984372E-2,0.98639167412901563,1.0330967994545613E-56,null,null,null,null,1.5368272297580747]
[null,0.89999999999998004,1.6368272297580748,1.0136971042066456E-2,0.69290412027055348,4.1516400043503055E-16,1.5747936037111007E-4,null,1.0136971042066456E-2,0.98986302895793354,1.5039942499511501E-60,null,null,null,null,1.6368272297580748]
[null,0.99999999999998002,1.7368272297580747,7.4597244288061582E-3,0.69477819289983567,3.4551489897750139E-16,9.4594307001208793E-5,null,7.4597244288061582E-3,0.99254027557119384,1.5194399195984712E-64,null,null,null,null,1.7368272297580747]
[null,1.0999999999999699,1.8368272297580646,5.4224748395932387E-3,0.69620426761228471,3.0022721854211987E-16,5.5939748098382206E-5,null,5.4224748395932387E-3,0.99457752516040676,1.0615155650756868E-68,null,null,null,null,1.8368272297580646]
[null,1.19999999999997,1.9368272297580647,3.892998702893391E-3,0.69727490090797462,2.7005542174167854E-16,3.2567930422942835E-5,null,3.892998702893391E-3,0.99610700129710661,5.1112576135616848E-73,null,null,null,null,1.9368272297580647]
[null,1.2999999999999701,2.0368272297580647,2.7601786603005385E-3,0.69806787493778955,2.4962019043110387E-16,1.866697584352405E-5,null,2.7601786603005385E-3,0.99723982133969946,1.6908917963220059E-77,null,null,null,null,2.0368272297580647]
[null,1.3999999999999699,2.1368272297580648,1.9324709136098184E-3,0.69864727036047314,2.356426451996236E-16,1.0533481045314855E-5,null,1.9324709136098184E-3,0.99806752908639018,3.8316777490933041E-82,null,null,null,null,2.1368272297580648]
[null,1.49999999999997,2.2368272297580649,1.3358890602718221E-3,0.69906487765780967,2.2604053422954605E-16,5.8517264961887382E-6,null,1.3358890602718221E-3,0.99866411093972818,5.9307798251827138E-87,null,null,null,null,2.2368272297580649]
[null,1.5999999999999699,2.3368272297580646,9.1173864650873071E-4,0.69936178294744389,2.1944496204094534E-16,3.2004442727259983E-6,null,9.1173864650873071E-4,0.99908826135349127,6.2533238122618753E-92,null,null,null,null,2.3368272297580646]
[null,1.69999999999997,2.4368272297580647,6.1429319760908374E-4,0.69956999476167359,2.1493105019937661E-16,1.7232594481786682E-6,null,6.1429319760908374E-4,0.99938570680239092,4.4799295582037975E-97,null,null,null,null,2.4368272297580647]
[null,1.7999999999999701,2.5368272297580647,4.085555108227501E-4,0.69971401114242404,2.1186151009190836E-16,9.1349298328722271E-7,null,4.085555108227501E-4,0.99959144448917725,2.1753652483364773E-102,null,null,null,null,2.5368272297580647]
[null,1.8999999999999699,2.6368272297580648,2.6820250507753052E-4,0.69981225824644566,2.0979184973532451E-16,4.7673156935262038E-7,null,2.6820250507753052E-4,0.99973179749492247,7.1430698759477746E-108,null,null,null,null,2.6368272297580648]
[null,1.99999999999997,2.7368272297580649,1.7377166054410864E-4,0.69987835983761904,2.0841037547001994E-16,2.4493833253862932E-7,null,1.7377166054410864E-4,0.99982622833945589,1.5825904340251704E-113,null,null,null,null,2.7368272297580649]

{"sheet":"TableSensSpec","index":8,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,"In these tables the effect of specificity and sensitivity can be investigated for various number of samples and the actual Pd (probability of a defective sample)"]
[null,"At various specificities and sensitivities the probability of a negative is determined (P-) and the for a selected range of number of samples the probability of acceptance of the batch is determined "]
[null,"Specificity and sensitivity of the test are assumed to be fixed values and not dependant on the concentration of the organisms"]
[]
["actual Pd=0",null,null,null,null,null,null,null,null,"actual Pd",0.01]
[]
["specificity","P-",1,5,10,20,30,60,null,"specificity","P-",{"$f":"+C8","v":1},5,10,20,30,60]
[100,{"$f":"+A9/100","v":1},{"$f":"+$B9^C$8","v":1},1,1,1,1,1,null,{"$f":"+A9","v":100},{"$f":"+J9/100*(1-$K$6)","v":0.99},{"$f":"+$K9^L$8","v":0.99},0.95099004989999991,0.9043820750088043,0.81790693759723065,0.7397003733882801,0.54715664239076089]
[99.9,{"$f":"+A10/100","v":0.99900000000000011},{"$f":"+$B10^C$8","v":0.99900000000000011},{"$f":"+$B10^D$8","v":0.99500999000499957},0.99004488020974946,0.98018886482953704,0.97043096726308931,0.94173626222317508,null,99.9,0.98901000000000006,0.98901000000000006,0.94624460004585287,0.89537884311593618,0.80170327269963237,0.71782814883205681,0.51527725125565749]
[99.5,{"$f":"+A11/100","v":0.995},0.995,0.97524875312187509,0.95111013046577197,0.90461048027461777,0.86038419191469639,0.74026095769670508,null,99.5,0.98504999999999998,0.98504999999999998,0.92745186039628469,0.86016695335252946,0.73988718763977257,0.63642650801667444,0.40503870010629822]
[99,0.99,0.99,0.95099004989999991,0.9043820750088043,0.81790693759723065,0.7397003733882801,0.54715664239076089,null,99,0.98009999999999997,0.98009999999999997,0.9043820750088043,0.81790693759723065,0.66897175856968005,0.54715664239076089,0.29938039131233107]
[98,0.98,0.98,0.90392079679999982,0.81707280688754658,0.66760797175509412,0.54548431938243669,0.29755314269212013,null,98,0.97019999999999995,0.97019999999999995,0.85961968365447949,0.73894600052622739,0.54604119169370724,0.40349495472464009,0.16280817848823931]
[97,0.97,0.97,0.8587340256999999,0.7374241268949282,0.54379434292674711,0.4010070685431576,0.16080666902157673,null,97,0.96029999999999993,0.96029999999999993,0.81664751395127066,0.66691316204279083,0.44477316570591385,0.29662507833271318,8.7986437095888242E-2]
[96,0.96,0.96,0.81537269759999997,0.664832635991501,0.44200243387940769,0.29385764323070573,8.635231448510472E-2,null,96,0.95039999999999991,0.95039999999999991,0.77541132237772126,0.60126271887156635,0.36151685710482823,0.21736660842075256,4.724824245634078E-2]
[95,0.95,0.95,0.77378093749999999,0.5987369392383789,0.35848592240854216,0.21463876394293749,4.606979898695205E-2,null,95,0.9405,0.9405,0.73585797236479378,0.54148695549282566,0.29320812296888926,0.15876837383218989,2.5207396529317999E-2]
[94,0.94,0.94,0.73390402239999986,0.53861511409489959,0.29010624113146172,0.15625560616666473,2.441581445851183E-2,null,94,0.93059999999999998,0.93059999999999998,0.69793542288398658,0.48711385451624911,0.2372799072616775,0.11558233022549383,1.3359275060355107E-2]
[90,0.9,0.9,0.59049000000000018,0.34867844010000015,0.12157665459056941,4.2391158275216265E-2,1.7970102999144365E-3,null,90,0.89100000000000001,0.89100000000000001,0.56155011456545112,0.31533853116847133,9.9438389239488972E-2,3.1356755604539176E-2,9.8324612204279916E-4]
[]
[null,null,null,null,null,null,null,null,null,"actual Pd",0.01]
[]
[null,null,null,null,null,null,null,null,null,"sensitivity","P-",{"$f":"+C8","v":1},5,10,20,30,60]
[null,null,null,null,null,null,null,null,null,100,{"$f":"1-J23/100*$K$20","v":0.99},{"$f":"+$K23^L$22","v":0.99},0.95099004989999991,0.9043820750088043,0.81790693759723065,0.7397003733882801,0.54715664239076089]
[null,null,null,null,null,null,null,null,null,99.9,0.99000999999999995,0.99000999999999995,0.95103808067080853,0.90447343088601539,0.81807218717871966,0.73992455784996314,0.54748835130946361]
[null,null,null,null,null,null,null,null,null,99.5,0.99004999999999999,0.99004999999999999,0.95123022316119998,0.9048389374553063,0.8187335027352477,0.74082195267402273,0.54881716556375182]
[null,null,null,null,null,null,null,null,null,99,0.99009999999999998,0.99009999999999998,0.95147044494470145,0.905296007603268,0.81956086138241635,0.74194517579739694,0.55048264388903012]
[null,null,null,null,null,null,null,null,null,98,0.99019999999999997,0.99019999999999997,0.95195103410801563,0.90621077133932038,0.82121796209140596,0.74419656286455771,0.55382852417942163]
[null,null,null,null,null,null,null,null,null,97,0.99029999999999996,0.99029999999999996,0.95243181744876693,0.90712636688876147,0.82287824550480382,0.74645455323657106,0.55719440004760878]
[null,null,null,null,null,null,null,null,null,96,0.99039999999999995,0.99039999999999995,0.9529127950257904,0.90804279492386419,0.82454171741314286,0.74871916561115326,0.56058038895346141]
[null,null,null,null,null,null,null,null,null,95,0.99050000000000005,0.99050000000000005,0.95339396689793454,0.90896005611737984,0.82620838361691029,0.75099041873707639,0.5639866090348894]
[null,null,null,null,null,null,null,null,null,94,0.99060000000000004,0.99060000000000004,0.95387533312405781,0.90987815114253223,0.82787824992655268,0.75326833141428684,0.56741317911166389]
[null,null,null,null,null,null,null,null,null,90,0.99099999999999999,0.99099999999999999,0.95580274274595101,0.91355888304068256,0.83458983278253962,0.76244695543392682,0.58132535985046463]