{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["IMPORTANT ADVICE FOR USERS","Data Entry","Analysis","Demo data","Changes from previous version","Instructions","Results summaries","About ECOFFinder"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":38,"comments":0,"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":"IMPORTANT ADVICE FOR USERS","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["ECOFFinder - Important advice for users"]
[]
[">","If this software is being used to establish formal ECOFFs for EUCAST use, all the rules and conditions described in EUCAST SOP 10.1 should be followed "]
[null,null,"http://www.eucast.org/fileadmin/src/media/PDFs/EUCAST_files/EUCAST_SOPs/EUCAST_SOP_10.0_MIC_distributions_and_epidemiological_cut-off_value__ECOFF__setting_20171117.pdf"]
[]
[">","Distributions that are truncated at the lower end within the likely wild type are not acceptable for aggregation or ECOFF estimation"]
[null,null,"*At least two dilutions below the likely wild-type mode are required for acceptability"]
[null,null,"*ECOFFinder will still try to fit such distributions but the answers will be misleading"]
[]
[">","ECOFFs can only be set for species. Groups such as \"coagulase-negative Staphylococci\" do not merit ECOFFs"]
[null,null,"*However, closely-related species that can't be readily separated by MALDI-TOF, such as E. cloacae complex, can have ECOFFs established"]
[]
[null,"ECOFFinder works with any kinds of positive numbers; the cumulative total is most often the best starting value for \"Nest\", unless non-wild type data dominate (>50%)"]
[null,null,"*Raw numbers (integers)"]
[null,null,"*Decimals, such as when using percentages"]
[]
[">","Although ECOFFinder will work on any single or combination of two distributions, the output would not formally be considered an ECOFF of any kind under EUCAST rules"]
[null,null,"*It is still a useful tool for examining distributions, e.g.  for conformance to a log-normal distribution"]

{"sheet":"Data Entry","index":1,"n_rows":28,"n_cols":24,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,18,1,20],[0,4,0,8],[0,9,0,13],[5,20,5,21],[0,14,0,15],[0,20,0,21]]}
["Data Entry & Results",null,null,null,null,null,null,null,null,null,null,null,null,null,"No of Distributions\nIncluded in Data",null,null,null,{"$f":"TODAY()","v":"2020-01-26"},null,"Total Number of\nObservation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REVIEW AREA"]
["MIC","Log2MIC","Raw Count or %","Cum. Count ot %",null,"Fitted Values","Fitted %",null,"Selected Subset",{"$f":"\"≤ \"&2^Analysis!P4","v":{"$error":"#N/A"}},"Dil Range"]
[{"$f":"2^B4","v":9.765625E-4},-10,null,{"$f":"C4","v":0},{"$f":"B4","v":-10},{"$f":"IF(Analysis!A11<=Analysis!$R$4,Analysis!R11,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S11","v":{"$error":"#N/A"}},{"$f":"B4","v":-10},"Modal MIC",{"$f":"2^(VLOOKUP(MAX(C3:C23),C3:E23,3,FALSE))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(G4:G24,\">=0.01\")","v":0}]
[1.953125E-3,-9,null,{"$f":"D4+C5","v":0},-9,{"$f":"IF(Analysis!A12<=Analysis!$R$4,Analysis!R12,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S12","v":{"$error":"#N/A"}},{"$f":"B5","v":-9},"Log2MIC Mode",{"$f":"VLOOKUP(MAX(C4:C24),C4:E24,3,FALSE)","v":{"$error":"#N/A"}}]
[3.90625E-3,-8,null,{"$f":"D5+C6","v":0},-8,{"$f":"IF(Analysis!A13<=Analysis!$R$4,Analysis!R13,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S13","v":{"$error":"#N/A"}},-8,"Max Log2MIC",{"$f":"INDIRECT(ADDRESS(MATCH(MAX(D4:D24),D4:D24,0)+3,2))","v":-10},null,null,null,null,null,null,null,null,null,null,"Numerical Results"]
[7.8125E-3,-7,null,0,-7,{"$f":"IF(Analysis!A14<=Analysis!$R$4,Analysis!R14,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S14","v":{"$error":"#N/A"}},-7,"Selected Log2 Mean",{"$f":"Analysis!P6","v":{"$error":"#N/A"}},{"$f":"\"   =\"&ROUND(2^J7,3)","v":{"$error":"#N/A"}},"μg/mL",null,null,null,null,null,null,null,null,"Agent",{"$f":"J1","v":0}]
[1.5625E-2,-6,null,0,-6,{"$f":"IF(Analysis!A15<=Analysis!$R$4,Analysis!R15,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S15","v":{"$error":"#N/A"}},-6,"Selected Log2 SD",{"$f":"Analysis!P8","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,"Species",{"$f":"E1","v":0}]
[3.125E-2,-5,null,0,-5,{"$f":"IF(Analysis!A16<=Analysis!$R$4,Analysis!R16,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S16","v":{"$error":"#N/A"}},-5,"CV",{"$f":"SQRT(EXP((LN(2)*J8)^2)-1)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,"Distributions",{"$f":"Q1","v":0}]
[6.25E-2,-4,null,0,-4,{"$f":"IF(Analysis!A17<=Analysis!$R$4,Analysis!R17,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S17","v":{"$error":"#N/A"}},-4,null,null,null,null,null,null,null,null,null,null,null,null,"Observations",{"$f":"W1","v":0}]
[0.125,-3,null,0,-3,{"$f":"IF(Analysis!A18<=Analysis!$R$4,Analysis!R18,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S18","v":{"$error":"#N/A"}},-3,"Selected Values","Exact","R'd-up","%Obs>","%@ECOFF",null,null,null,null,null,null,null,"Selected Subset",{"$f":"J3","v":{"$error":"#N/A"}}]
[0.25,-2,null,0,-2,{"$f":"IF(Analysis!A19<=Analysis!$R$4,Analysis!R19,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S19","v":{"$error":"#N/A"}},-2,"ECOFF 95.0%",{"$f":"2^(NORMINV(0.95,$J$7,$J$8))","v":{"$error":"#N/A"}},{"$f":"Analysis!P39","v":{"$error":"#N/A"}},{"$f":"Analysis!P44","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K12,A4:G24,7)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Modal MIC",{"$error":"#N/A"}]
[0.5,-1,null,0,-1,{"$f":"IF(Analysis!A20<=Analysis!$R$4,Analysis!R20,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S20","v":{"$error":"#N/A"}},-1,"ECOFF 97.5%",{"$f":"2^(NORMINV(0.975,$J$7,$J$8))","v":{"$error":"#N/A"}},{"$f":"Analysis!P40","v":{"$error":"#N/A"}},{"$f":"Analysis!P45","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K13,A5:G25,7)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Log2MIC Mode",{"$error":"#N/A"}]
[1,0,null,0,0,{"$f":"IF(Analysis!A21<=Analysis!$R$4,Analysis!R21,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S21","v":{"$error":"#N/A"}},0,"ECOFF 99.0%",{"$f":"2^(NORMINV(0.99,$J$7,$J$8))","v":{"$error":"#N/A"}},{"$f":"Analysis!P41","v":{"$error":"#N/A"}},{"$f":"Analysis!P46","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,null,null,null,null,"Max Log2MIC",-10]
[2,1,null,0,1,{"$f":"IF(Analysis!A22<=Analysis!$R$4,Analysis!R22,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S22","v":{"$error":"#N/A"}},1,"ECOFF 99.5%",{"$f":"2^(NORMINV(0.995,$J$7,$J$8))","v":{"$error":"#N/A"}},{"$f":"Analysis!P42","v":{"$error":"#N/A"}},{"$f":"Analysis!P47","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,null,null,null,null,"Selected Log2 Mean",{"$error":"#N/A"}]
[4,2,null,0,2,{"$f":"IF(Analysis!A23<=Analysis!$R$4,Analysis!R23,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S23","v":{"$error":"#N/A"}},2,"ECOFF 99.9%",{"$f":"2^(NORMINV(0.999,$J$7,$J$8))","v":{"$error":"#N/A"}},{"$f":"Analysis!P43","v":{"$error":"#N/A"}},{"$f":"Analysis!P48","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,null,null,null,null,"Selected Log2 SD",{"$error":"#N/A"}]
[8,3,null,0,3,{"$f":"IF(Analysis!A24<=Analysis!$R$4,Analysis!R24,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S24","v":{"$error":"#N/A"}},3,null,null,null,null,null,null,null,null,null,null,null,null,"CV",{"$error":"#N/A"}]
[16,4,null,0,4,{"$f":"IF(Analysis!A25<=Analysis!$R$4,Analysis!R25,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S25","v":{"$error":"#N/A"}},4,"PARKED DATA (see Instructions)",null,null,null,null,null,null,null,null,null,null,null,"ECOFF 97.5% Exact",{"$f":"J13","v":{"$error":"#N/A"}}]
[32,5,null,0,5,{"$f":"IF(Analysis!A26<=Analysis!$R$4,Analysis!R26,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S26","v":{"$error":"#N/A"}},5,"MIC","Log2MIC","Count",null,null,null,null,null,null,null,null,null,"ECOFF 97.5% R'd-up",{"$f":"K13","v":{"$error":"#N/A"}}]
[64,6,null,0,6,{"$f":"IF(Analysis!A27<=Analysis!$R$4,Analysis!R27,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S27","v":{"$error":"#N/A"}},6,null,null,null,null,null,null,null,null,null,null,null,null,"ECOFF 99 % Exact",{"$f":"J14","v":{"$error":"#N/A"}}]
[128,7,null,0,7,{"$f":"IF(Analysis!A28<=Analysis!$R$4,Analysis!R28,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S28","v":{"$error":"#N/A"}},7,null,null,null,null,null,null,null,null,null,null,null,null,"ECOFF 99% R'd-up",{"$f":"K14","v":{"$error":"#N/A"}}]
[256,8,null,0,8,{"$f":"IF(Analysis!A29<=Analysis!$R$4,Analysis!R29,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S29","v":{"$error":"#N/A"}},8,null,null,null,null,null,null,null,null,null,null,null,null,"Dil Range",{"$f":"K4","v":0}]
[512,9,null,0,{"$f":"B23","v":9},{"$f":"IF(Analysis!A30<=Analysis!$R$4,Analysis!R30,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S30","v":{"$error":"#N/A"}},9,null,null,null,null,null,null,null,null,null,null,null,null,"% @ ECOFF 97.5",{"$f":"M13","v":{"$error":"#N/A"}}]
[1024,10,null,0,{"$f":"B24","v":10},{"$f":"IF(Analysis!A31<=Analysis!$R$4,Analysis!R31,NA())","v":{"$error":"#N/A"}},{"$f":"Analysis!S31","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"% @ ECOFF 99",{"$f":"M14","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",{"$f":"S1","v":"2020-01-26"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Analysis","index":2,"n_rows":48,"n_cols":19,"rows_kept":48,"cut":false,"hidden":false,"merged":[[5,1,7,2],[5,17,6,19],[35,15,37,15],[0,10,0,12],[0,6,0,9]]}
["Analysis",null,null,null,null,null,{"$f":"'Data Entry'!E1","v":0},null,null,null,{"$f":"IF('Data Entry'!J1=\"\",\"\",'Data Entry'!J1)","v":""}]
[]
[null,null,null,"Mode MIC","Subset ≤","Subset ≤","Subset ≤","Subset ≤","Subset ≤","Subset ≤","Subset ≤","Subset ≤","Subset ≤","Subset ≤",null,"Selected Log2 Subset",null,"Max Log2 MIC"]
[null,"Log2 value",null,{"$f":"'Data Entry'!J5","v":{"$error":"#N/A"}},{"$f":"IF($D4+1>'Data Entry'!$J$6,\"\",$D4+1)","v":{"$error":"#N/A"}},{"$f":"IF($D4+2>'Data Entry'!$J$6,\"\",$D4+2)","v":{"$error":"#N/A"}},{"$f":"IF($D4+3>'Data Entry'!$J$6,\"\",$D4+3)","v":{"$error":"#N/A"}},{"$f":"IF($D4+4>'Data Entry'!$J$6,\"\",$D4+4)","v":{"$error":"#N/A"}},{"$f":"IF($D4+5>'Data Entry'!$J$6,\"\",$D4+5)","v":{"$error":"#N/A"}},{"$f":"IF($D4+6>'Data Entry'!$J$6,\"\",$D4+6)","v":{"$error":"#N/A"}},{"$f":"IF($D4+7>'Data Entry'!$J$6,\"\",$D4+7)","v":{"$error":"#N/A"}},{"$f":"IF($D4+8>'Data Entry'!$J$6,\"\",$D4+8)","v":{"$error":"#N/A"}},{"$f":"IF($D4+9>'Data Entry'!$J$6,\"\",$D4+9)","v":{"$error":"#N/A"}},{"$f":"IF($D4+10>'Data Entry'!$J$6,\"\",$D4+10)","v":{"$error":"#N/A"}},null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&4)","v":{"$error":"#N/A"}},null,{"$f":"'Data Entry'!J6","v":-10}]
[null,"Value",null,{"$f":"2^D4","v":{"$error":"#N/A"}},{"$f":"IF(E4<>\"\",2^E4,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(F4<>\"\",2^F4,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(G4<>\"\",2^G4,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(H4<>\"\",2^H4,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(I4<>\"\",2^I4,\"\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"Selected Subset Log2 Mean"]
[null,"Starting Values",null,"Nest→",null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&7)","v":{"$error":"#N/A"}},null,"Please review results also on the\nData Entry sheet after solving"]
[null,null,null,"Log2 mean→",null,null,null,null,null,null,null,null,null,null,null,"Selected Subset Log2 SD"]
[null,null,null,"Log2 SD→",null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&8)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residuals Plot for Best Fit"]
[{"$f":"'Data Entry'!B3","v":"Log2MIC"},{"$f":"'Data Entry'!C3","v":"Raw Count or %"},"↓","Cum N Actual","N Pred","N Pred","N Pred","N Pred","N Pred","N Pred","N Pred","N Pred","N Pred","N Pred",null,"Best Fit","Residuals","BestFit Dist","Percent"]
[{"$f":"'Data Entry'!B4","v":-10},{"$f":"IF('Data Entry'!C4=\"\",\"\",'Data Entry'!C4)","v":""},11,{"$f":"'Data Entry'!D4","v":0},{"$f":"IF($A11<=$R$4,E$6*NORMDIST($A11,E$7,E$8,TRUE),0)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&11)","v":{"$error":"#N/A"}},{"$f":"IF(P11=0,\"\",D11-P11)","v":{"$error":"#N/A"}},{"$f":"P11","v":{"$error":"#N/A"}},{"$f":"R11/SUM(R$11:R$31)","v":{"$error":"#N/A"}}]
[{"$f":"'Data Entry'!B5","v":-9},{"$f":"IF('Data Entry'!C5=\"\",\"\",'Data Entry'!C5)","v":""},12,{"$f":"'Data Entry'!D5","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&12)","v":{"$error":"#N/A"}},{"$f":"IF(P12=0,\"\",D12-P12)","v":{"$error":"#N/A"}},{"$f":"IF(P12<>0,P12-P11,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B6","v":-8},{"$f":"IF('Data Entry'!C6=\"\",\"\",'Data Entry'!C6)","v":""},13,{"$f":"'Data Entry'!D6","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&13)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(P13<>0,P13-P12,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B7","v":-7},{"$f":"IF('Data Entry'!C7=\"\",\"\",'Data Entry'!C7)","v":""},14,{"$f":"'Data Entry'!D7","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&14)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B8","v":-6},{"$f":"IF('Data Entry'!C8=\"\",\"\",'Data Entry'!C8)","v":""},15,{"$f":"'Data Entry'!D8","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&15)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B9","v":-5},{"$f":"IF('Data Entry'!C9=\"\",\"\",'Data Entry'!C9)","v":""},16,{"$f":"'Data Entry'!D9","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&16)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B10","v":-4},{"$f":"IF('Data Entry'!C10=\"\",\"\",'Data Entry'!C10)","v":""},17,{"$f":"'Data Entry'!D10","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&17)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B11","v":-3},{"$f":"IF('Data Entry'!C11=\"\",\"\",'Data Entry'!C11)","v":""},18,{"$f":"'Data Entry'!D11","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&18)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B12","v":-2},{"$f":"IF('Data Entry'!C12=\"\",\"\",'Data Entry'!C12)","v":""},19,{"$f":"'Data Entry'!D12","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&19)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B13","v":-1},{"$f":"IF('Data Entry'!C13=\"\",\"\",'Data Entry'!C13)","v":""},20,{"$f":"'Data Entry'!D13","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&20)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B14","v":0},{"$f":"IF('Data Entry'!C14=\"\",\"\",'Data Entry'!C14)","v":""},21,{"$f":"'Data Entry'!D14","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&21)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B15","v":1},{"$f":"IF('Data Entry'!C15=\"\",\"\",'Data Entry'!C15)","v":""},22,{"$f":"'Data Entry'!D15","v":0},0,{"$f":"IF($A22<=$R$4,F$6*NORMDIST($A22,F$7,F$8,TRUE),0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&22)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B16","v":2},{"$f":"IF('Data Entry'!C16=\"\",\"\",'Data Entry'!C16)","v":""},23,{"$f":"'Data Entry'!D16","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&23)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B17","v":3},{"$f":"IF('Data Entry'!C17=\"\",\"\",'Data Entry'!C17)","v":""},24,{"$f":"'Data Entry'!D17","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&24)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B18","v":4},{"$f":"IF('Data Entry'!C18=\"\",\"\",'Data Entry'!C18)","v":""},25,{"$f":"'Data Entry'!D18","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&25)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B19","v":5},{"$f":"IF('Data Entry'!C19=\"\",\"\",'Data Entry'!C19)","v":""},26,{"$f":"'Data Entry'!D19","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&26)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B20","v":6},{"$f":"IF('Data Entry'!C20=\"\",\"\",'Data Entry'!C20)","v":""},27,{"$f":"'Data Entry'!D20","v":0},{"$f":"IF($A27<=$R$4,E$6*NORMDIST($A27,E$7,E$8,TRUE),0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&27)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B21","v":7},{"$f":"IF('Data Entry'!C21=\"\",\"\",'Data Entry'!C21)","v":""},28,{"$f":"'Data Entry'!D21","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&28)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B22","v":8},{"$f":"IF('Data Entry'!C22=\"\",\"\",'Data Entry'!C22)","v":""},29,{"$f":"'Data Entry'!D22","v":0},{"$f":"IF($A29<=$R$4,E$6*NORMDIST($A29,E$7,E$8,TRUE),0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&29)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B23","v":9},{"$f":"IF('Data Entry'!C23=\"\",\"\",'Data Entry'!C23)","v":""},30,{"$f":"'Data Entry'!D23","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&30)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Data Entry'!B24","v":10},{"$f":"IF('Data Entry'!C24=\"\",\"\",'Data Entry'!C24)","v":""},31,{"$f":"'Data Entry'!D24","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDIRECT(CHOOSE(MATCH(MIN(E$36:N$36),E$36:N$36,0),\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\")&30)","v":{"$error":"#N/A"}},{"$f":"IF(P31=0,\"\",D31-P31)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,null,null,"Stop Row",{"$f":"VLOOKUP(E4,$A10:$C31,3)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"Sum-of-squares",{"$f":"SUM(($D11:INDIRECT(\"D\"&E$33)-E11:INDIRECT(\"E\"&E$33))^2)","v":{"$error":"#N/A"}},{"$f":"SUM(($D11:INDIRECT(\"D\"&F$33)-F11:INDIRECT(\"F\"&F$33))^2)","v":{"$error":"#N/A"}},{"$f":"SUM(($D11:INDIRECT(\"D\"&G$33)-G11:INDIRECT(\"G\"&G$33))^2)","v":{"$error":"#N/A"}},{"$f":"SUM(($D11:INDIRECT(\"D\"&H$33)-H11:INDIRECT(\"H\"&H$33))^2)","v":{"$error":"#N/A"}},{"$f":"SUM(($D11:INDIRECT(\"D\"&I$33)-I11:INDIRECT(\"I\"&I$33))^2)","v":{"$error":"#N/A"}},{"$f":"SUM(($D11:INDIRECT(\"D\"&J$33)-J11:INDIRECT(\"J\"&J$33))^2)","v":{"$error":"#N/A"}},{"$f":"SUM(($D11:INDIRECT(\"D\"&K$33)-K11:INDIRECT(\"K\"&K$33))^2)","v":{"$error":"#N/A"}},{"$f":"SUM(($D11:INDIRECT(\"D\"&L$33)-L11:INDIRECT(\"L\"&L$33))^2)","v":{"$error":"#N/A"}},{"$f":"SUM(($D11:INDIRECT(\"D\"&M$33)-M11:INDIRECT(\"M\"&M$33))^2)","v":{"$error":"#N/A"}},{"$f":"SUM(($D11:INDIRECT(\"D\"&N$33)-N11:INDIRECT(\"N\"&N$33))^2)","v":{"$error":"#N/A"}}]
[null,null,null," N",{"$f":"VLOOKUP(E4,$A10:E31,4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F4,$A10:F31,4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G4,$A10:G31,4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(H4,$A10:H31,4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(I4,$A10:I31,4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(J4,$A10:J31,4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K4,$A10:K31,4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L4,$A10:L31,4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M4,$A10:M31,4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N4,$A10:N31,4)","v":{"$error":"#N/A"}}]
[null,null,null,"ABS(N – Nest)",{"$f":"IF(E$4<=9,ABS(E6-E35),\"\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"Selected ECOFF values"]
[null,null,null,"Relative Diff",{"$f":"E36/E35","v":{"$error":"#N/A"}},{"$f":"F36/F35","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,null,null,"95.0% Subset ECOFF=",{"$f":"2^(INT(NORMINV(0.95,E$7,E$8))+1)","v":{"$error":"#NUM!"}},{"$f":"2^(INT(NORMINV(0.95,F$7,F$8))+1)","v":{"$error":"#NUM!"}},{"$f":"2^(INT(NORMINV(0.95,G$7,G$8))+1)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$f":"HLOOKUP(MIN(E36:N36),E36:N43,4,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,"97.5% Subset ECOFF=",{"$f":"2^(INT(NORMINV(0.975,E$7,E$8))+1)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$f":"HLOOKUP(MIN(E36:N36),E36:N43,5,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,"99.0% Subset ECOFF=",{"$f":"2^(INT(NORMINV(0.99,E$7,E$8))+1)","v":{"$error":"#NUM!"}},{"$f":"2^(INT(NORMINV(0.99,F$7,F$8))+1)","v":{"$error":"#NUM!"}},{"$f":"2^(INT(NORMINV(0.99,G$7,G$8))+1)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$f":"HLOOKUP(MIN(E36:N36),E36:N43,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,"99.5% Subset ECOFF=",{"$f":"2^(INT(NORMINV(0.995,E$7,E$8))+1)","v":{"$error":"#NUM!"}},{"$f":"2^(INT(NORMINV(0.995,F$7,F$8))+1)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$f":"HLOOKUP(MIN(E36:N36),E36:N43,7,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,"99.9% Subset ECOFF=",{"$f":"2^(INT(NORMINV(0.999,E$7,E$8))+1)","v":{"$error":"#NUM!"}},{"$f":"2^(INT(NORMINV(0.999,F$7,F$8))+1)","v":{"$error":"#NUM!"}},{"$f":"2^(INT(NORMINV(0.999,G$7,G$8))+1)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$f":"HLOOKUP(MIN(E36:N36),E36:N43,8,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,"%Obs > 95.0%",{"$f":"($D$31-VLOOKUP(LN(E39)/LN(2), $A$11:$D$31,4))/$D$31","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$f":"($D$31-VLOOKUP(LN(P39)/LN(2), $A$11:$D$31,4))/$D$31","v":{"$error":"#N/A"}}]
[null,null,null,"%Obs > 97.5%",{"$f":"($D$31-VLOOKUP(LN(E40)/LN(2), $A$11:$D$31,4))/$D$31","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$f":"($D$31-VLOOKUP(LN(P40)/LN(2), $A$11:$D$31,4))/$D$31","v":{"$error":"#N/A"}}]
[null,null,null,"%Obs > 99.0%",{"$f":"($D$31-VLOOKUP(LN(E41)/LN(2), $A$11:$D$31,4))/$D$31","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$f":"($D$31-VLOOKUP(LN(P41)/LN(2), $A$11:$D$31,4))/$D$31","v":{"$error":"#N/A"}}]
[null,null,null,"%Obs > 99.5%",{"$f":"($D$31-VLOOKUP(LN(E42)/LN(2), $A$11:$D$31,4))/$D$31","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$f":"($D$31-VLOOKUP(LN(P42)/LN(2), $A$11:$D$31,4))/$D$31","v":{"$error":"#N/A"}}]
[null,null,null,"%Obs > 99.9%",{"$f":"($D$31-VLOOKUP(LN(E43)/LN(2), $A$11:$D$31,4))/$D$31","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$f":"($D$31-VLOOKUP(LN(P43)/LN(2), $A$11:$D$31,4))/$D$31","v":{"$error":"#N/A"}}]

{"sheet":"Demo data","index":3,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["MIC","Log2MIC","Raw Count","Raw Count","Raw Count","Raw Count","Percent"]
[{"$f":"2^B2","v":9.765625E-4},-10]
[1.953125E-3,-9,null,null,null,221]
[3.90625E-3,-8,null,null,null,341,4.3445121951219509E-2]
[7.8125E-3,-7,8,22,4,381,1.5181018841863352]
[1.5625E-2,-6,13,66,239,310,2.3203228215192886]
[3.125E-2,-5,26,70,401,218,0.89696555868134265]
[6.25E-2,-4,31,25,650,146,0.18357062869940807]
[0.125,-3,104,15,967,55,7.5187969924812026E-3]
[0.25,-2,1534,13,878,19,0]
[0.5,-1,10058,17,403,6,7.5187969924812026E-3]
[1,0,38077,19,110,null,2.2556390977443608E-2]
[2,1,14228,33,34]
[4,2,1182,14,10]
[8,3,271,22,17]
[16,4,70,35,9]
[32,5,109,31,3]
[64,6,87,181,0]
[128,7,10,2,0]
[256,8,3,11,2]
[512,9,229]
[1024,10]
[null,null,"SPNE","EAER","NGON","NGON","SAGA"]
[null,null,"Cipro","Cipro","Azithro","Ceftriax","Imipenem"]
[null,null,null,null,null,null,"Percent"]
[null,null,null,null,null,null,"Example"]
[null,null,null,null,null,null,"5 dists"]
[null,"SPNE=","Streptococcus pneumoniae"]
[null,"EAER=","Enterobacter aerogenes"]
[null,"NGON=","Neisseria gonorrhoeae"]
[null,"SAGA=","Streptococcus agalactiae"]

{"sheet":"Changes from previous version","index":4,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
["Instructions"]
[1,"Updated for version 2.1; changes highighted with red text"]
["Data Entry and Results sheet"]
[1,"New cells have been added to the top row; the information will then be stored using the Copy Numerical Results and Copy Results Image when used"]
[null,null,"Cell Q1: No of Distributions Included in Data"]
[null,null,"Cell W1: No of Distributions Included in Data","Total number of Observations"]
[2,"A macro had been created to allow pasting of horizontal data from other spreadsheets to be pasted into the \"Raw Count or %\" column: Ctrl-Shift-T"]
[3,"A date cell has been added on the top row, displaying the current date; valuable when storing the Image"]
["IMPORTANT ADVICE FOR USERS sheet (New!)"]
[1,"Advice about the use of ECOFFinder, including that it should not be used on truncated data"]
["Demo data"]
[1,"A new set of demonstration data has been added: S. agalactiae and imipenem.  It shows how \"percent\" values can be used."]
[null,null," In this example, there are 5 distributions which sum to 500% and the recommended starting value for \"Nest\" is \"5\""]
["Results summaries"]
[1,"New columns have been added: \"Total Observations\" and \"Date analysed\""]

{"sheet":"Instructions","index":5,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["ECOFFinder Instructions",null,null,null,null,"[text changes since  version 2.0 in red]"]
[]
[1,"On the Data Entry workshheet, enter the name of the species in the left orange box, and the name of the antimicrobial agent in the right orange box"]
[null,null,"–if there is more than one MIC distribution included in the data, enter the number in the green box"]
[2,"Enter data as raw counts of MICs on the Data Entry sheet. A red line graph of the distribution will appear on the Chart. You can ignore other cells for the moment."]
[null,"a.","If your wish to copy and paste from another spreadsheet and your source data are in row format, select the cell with the lowest value in the range"]
[null,null,"and then right-click \"Paste Special: Values, Transpose\". Alternatively, place the cursor in the cell for lowest value of the data and press Ctrl-Shift-T (it is an embedded macro)"]
[null,"b.","You will find a \"parking area\" in the lower centre (PARKED DATA). If there is a second mode at the higher end of the distribution that is higher than the mode in the putative wild type, "]
[null,null,"copy and paste the data at this mode and higher into the \"Parked Data\" area, then delete those values from the main data entry area,"]
[null,null,"otherwise ECOFFinder will conduct its analysis in the wrong place."]
[3,"Enter the Number of Distributions included and the Total Number of Observations (N, not %) of those distributions in the  relevant cells in the top row"]
[4,"Switch to the Analysis sheet"]
[null,"This sheet contains columns with subsets of the data of increasing size from left to right. A subset labelled \"-2\" would include all the MIC data up to an MIC of 2-2 (0.25)"]
[5,"Enter starting values in cells E6, E7, and E8. These values should be near the true or expected values."]
[null,"a.","E6: Enter a starting value for Nest. This is should be close to the known total number of isolates, BUT NOT EQUAL to that number."]
[null,null," e.g. if the total number of isolates is 2641, choose a starting value of 2500 or 2800"]
[null,"b.","E7: Enter the value (Log2 MIC) that appears in cell D4"]
[null,"c.","E8: Enter the number \"1\" (without the quotes)"]
[6,"Select (highlight) cells E6 to E8 with the cursor"]
[7,"Put the cursor over the small box at the bottom right hand corner of cell E8, and drag it to the right so that all the cells from E6 to N8 are filled"]
[null,null,"–the starting values should then be the same in each column"]
[null,null,"–to save a little time, only those cells for which there is a value in Row 4 need be filled (Excel will still do all the columns though) "]
[8,"Click the \"Solve\" button\". This runs a macro using the Excel Solver add-in that iteratively fits each subset of the data from left to right"]
[9,"Look for a cell in row 36 that is highlighted with a red background."]
[null,"a.","This shows the minimum value in that row of the absolute value of the true total number, minus the number estimated by Solver for that subset (column)"]
[null,null,"It is this subset of the data that gives the best fit to the observed values, and the ECOFF values from this set are the ones found in cells P39, P40, and P41"]
[null,null,"The same values are also highlighted with a red background in rows 39-41"]
[null,"b.","A plot of the residuals is given for that subset."]
[null,null,"The residuals are the differences between the observed counts and the estimated counts from the fitted curve at each MIC"]
[null,null,"The residuals should scatter either side of the 0 line in the centre if the selected subset values are to be believed"]
[null,null,"The residuals will diverge upwards from 0 (appropriately) at the right hand end when there are sufficient non-susceptible values"]
[10,"Return to the Data Entry sheet"]
[null,"Here you will find the data from the selected subset plotted on the same graph as the raw counts, giving another picture of how well the estimates fit the data."]
[null,"The ECOFF values from the Analysis sheet have been transferred here."]
[null,"The choice of which percentage to select when setting an ECOFF depends on its intended use"]
[null,null,"> use lower percentages to increase sensitivity for non-wild-type detection; use higher percentages to increase specificity for the wild-type "]
[11,"To re-use the spreadsheet for another analysis, click one or more of the \"Clear\" buttons on the Data Entry sheet as required."]
[12,"If you wish to copy and paste an image of all the results displayed on the Data Entry sheet, click \"Copy Results Image\". This can be pasted into another document ith the usual commands."]
[13,"If you wish to store the main results from the analysis before clearing the data and results, click the \"Copy Numerical Results\" button, which stores the information on the \"Results summaries sheet\""]
[]
["Note 1","ECOFFinder will only fit curves to the MIC range observed, starting with the subset one two-fold dilution higher than the mode. "]
[null,"It is possible to keep increasing the sizes of the subsets above the observed MIC range, and improve the fit, but this is a \"false\" improvement."]
["Note 2","ECOFFinder uses the true MIC values for estimation, not the rounded values displayed for the low dilutions (e.g. it uses \"0.3125\", not \"0.31\")"]

{"sheet":"Results summaries","index":6,"n_rows":1,"n_cols":20,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Agent","Species","Distributions","Total Observations","Selected\nSubset","Modal\nMIC","Log2MIC\nMode","Max\nLog2MIC","Selected\nLog2 Mean","Selected\nLog2 SD","CV","ECOFF 97.5%\nExact","ECOFF 97.5%\nR'd-up","ECOFF 99 %\nExact","ECOFF 99%\nR'd-up","Dilution\nRange","% @\nECOFF 97.5","% @\nECOFF 99","Date analysed","Comments"]

{"sheet":"About ECOFFinder","index":7,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,2,17,15],[2,1,2,19]]}
[]
[]
[null,"Epidemiological cutoff value (ECOFF,ECV) estimation using nonlinear regression on expanding subsets"]
[]
[null,null,"VERSION",2.1]
[]
[null,null,"John Turnidge"]
[null,null,"EUCAST"]
[null,null,"john.turnidge@escmid.org",null,null,"OR","jturnidge@gmail.com"]
[]
[]
[null,null,"IP © 2010-2019 John Turnidge "]
[null,null,"You may distribute unmodifed copies of this worksheet freely."]
[]
[null,null,null,"Last modifed:","2019-12-01"]
[]
[]
[null,null,"Reference: Turnidge J, Kalhmeter G, Kronvall G. Statistical characterisation of bacterial wild-type MIC value distributions and the determination of epidemiological cut-off values. Clin Microbiol Infect 2006; 12:418-25"]