{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["RLOD Program","Info","Example","Example Figure"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Example Figure","index":3,"reason":"not_a_worksheet"}],"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":"RLOD Program","index":0,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":false,"merged":[[10,1,10,2],[11,1,11,2],[17,1,19,5],[16,1,16,5],[15,3,15,5],[15,1,15,2],[13,3,13,5],[14,3,14,5],[1,15,5,15],[1,1,1,14],[3,1,3,14],[4,1,6,14],[8,1,8,5],[8,8,20,19],[9,3,9,5],[10,3,10,5],[14,1,14,2],[12,1,12,2],[13,1,13,2],[9,1,9,2]]}
[]
[null,"RLOD program, version 4, dated 2024-01-10, for the determination of the relative level of detection of an alternative to a reference qualitative microbiological measurement method",null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculate\nResults",null,"Print b/w"]
[]
[null,"For more information see the following sheets 'Info' and 'Example'.  For details see: I. MARGARITESCU and P.-Th. WILRICH, Journal of AOAC International 96, 1086-1091 (2013).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Print color"]
[null,"This Excel program is distributed in the hope that it is useful, but without warranty. It can be downloaded at: www.wiwiss.fu-berlin.de/fachbereich/vwl/iso/ehemalige/wilrich/index.html  or at: www.statistics-wilrich.info.\nThere you have also the possibility to subscribe to a newsletter informing about updates of the program. For assistance contact: wilrich@wiwiss.fu-berlin.de  or  news@statistics-wilrich.info."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hide 'How to'"]
[]
[]
[null,"General information on the experiment",null,null,null,null,null,null,"How to use this program  (Macros have to be enabled, see the sheet 'Info'): \n1.  Enter information and data on the experiment into the yellow cells of the general input table.\n      −  Informative: Name and date of the experiment and microorganism; if filled in, they will be included in the result table and figure according to step 3.\n      −  Required: Sample size, no. of matrices, max. no of levels per matrix and the way how the contamination is specified (see Note 2).\n      ► The according tables for the input of your experimental data will be generated automatically below the general input table.\n2.  Enter your experimental data into the yellow cells of the matrix input tables generated according to step 1.\n3.  Press 'Ctrl+r' to start the calculation or use the button 'Calculate Results' (see top right).\n      ► The results of the RLOD calculations will be shown in an orange table below and in a new sheet 'RLOD Figure' next to this sheet.\n4.  You can change data in the yellow cells of all tables at any time.\n      ► Changes of data in the yellow tables cause deletion of the result table and figure but you can recalculate as per step 3 at any time.\n5.  You can print the tables and the figure (with an automatically adjusted print area) with the 'Print' buttons (see top right).\n6.  You can toggle between hiding and showing these instructions with the 'Hide/Show' button (see top right)."]
[null,"Experiment name:"]
[null,"Experiment date:"]
[null,"Microorganism:",null,null," Count unit: 1","cfu"]
[null,"Sample size A0:",null,null," Unit: 1","g"]
[null,"No. of matrices:"]
[null,"Max. no. of levels per matrix:"]
[null,"Contamination specification: 2",null,"known concentrations",null,null,"€"]
[null,"1  The units are set automatically to 'cfu' and 'g' as long as nothing else is entered."]
[null,"2  Select from the dropdown list. The contamination level can be specified as\n    − unknown contaminations, e.g. 1, 2, 3 etc. or  low, medium, high etc.;\n    − known concentrations in cfu/g;\n    − known dilution factors, e.g. 1 = undiluted, 0.1 = diluted 1 in 10 etc."]

{"sheet":"Info","index":1,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,1,24,6],[8,8,24,12],[3,1,3,15],[1,1,1,14],[4,1,6,14]]}
[]
[null,"RLOD program, version 4, dated 2024-01-10, for the determination of the relative level of detection of an alternative to a reference qualitative microbiological measurement method"]
[]
[null,"To use the program, go to the sheet 'RLOD Program'. For information see the following sheets 'Example'. For details see: I. MARGARITESCU and P.-Th. WILRICH, Journal of AOAC International 96, 1086-1091 (2013)."]
[null,"This Excel program is distributed in the hope that it is useful, but without warranty. It can be downloaded at: www.wiwiss.fu-berlin.de/fachbereich/vwl/iso/ehemalige/wilrich/index.html  or at: www.statistics-wilrich.info.\nThere you have also the possibility to subscribe to a newsletter informing about updates of the program. For assistance contact: wilrich@wiwiss.fu-berlin.de  or  news@statistics-wilrich.info."]
[]
[]
[]
[null,"Required version of Excel \nThis program was developed in Excel 365. It should run also in older versions, hopefully down to Excel 2007.\nEnabling of macros \nTo unblock macros on a file, right-click the downloaded file, select 'properties' and click 'unblock' at  the bottom of the tab.\nIn addition, you might have to make the folder, which is containing the file, a trusted location. To do so click File > Options > Trust Center > Trust Center Settings > Trusted Locations > Add new location ‒ and then select the respective folder via clicking Browse.\nRevisions of the program \nVersion 4, dated 2024-01-10, is completely revised in order to become more user-friendly. Additionally, notes are added for cases where a calculation is not possible because the no. of positive tests y is either equal to 0 or equal to the no. of tests n for the reference or the alternative method (or both). Furthermore, a figure of the RLOD's and their 95 % confidence intervals for the individual matrices and the combined results (if applicable) is added.",null,null,null,null,null,null,"Test statistic │z│ \n│z│ = │ĝ│/ sĝ (equation 14 in the publication) is the test statistic for the statistical test of the null hypothesis that the RLOD of the alternative to the reference method is equal to 1 (the LOD's of the alternative and the reference method are equal) against the alternative hypothesis that the RLOD is not equal to 1. \nIf │z│ is larger than 2, it is concluded that the RLOD is not equal to 1 (at the significance level 0.05).\nCombined results \nCombined results are calculated for the cases of unknown contaminations and known concentrations. In case of of known dilutions, combined results are not meaningful but you may switch to unknown contaminations in order to generate combined results.\nThe combined RLOD may be applied to all matrices if the confidence intervals of the individual matrices overlap."]

{"sheet":"Example","index":2,"n_rows":87,"n_cols":16,"rows_kept":87,"cut":false,"hidden":false,"merged":[[9,15,10,15],[10,1,10,2],[10,3,10,5],[1,1,1,14],[4,1,6,14],[8,1,8,5],[8,8,8,15],[9,1,9,2],[9,3,9,5],[9,8,9,9],[9,10,9,11],[9,13,9,14],[17,8,17,9],[18,8,18,15],[11,1,11,2],[12,1,12,2],[13,1,13,2],[13,3,13,5],[14,1,14,2],[14,3,14,5],[37,2,37,3],[37,4,37,5],[15,1,15,2],[15,3,15,5],[16,1,16,5],[17,1,19,5],[78,3,78,5],[79,2,79,3],[79,4,79,5],[21,8,28,15],[3,1,3,15],[50,3,50,5],[51,2,51,3],[51,4,51,5],[64,3,64,5],[65,2,65,3],[65,4,65,5],[21,1,21,5],[22,3,22,5],[23,2,23,3],[23,4,23,5],[36,3,36,5]]}
[]
[null,"RLOD program, version 4, dated 2024-01-10, for the determination of the relative level of detection of an alternative to a reference qualitative microbiological measurement method"]
[]
[null,"To use the program, go to the sheet 'RLOD Program'. For more information see the sheet 'Info'.  For details see: I. MARGARITESCU and P.-Th. WILRICH, Journal of AOAC International 96, 1086-1091 (2013)."]
[null,"This Excel program is distributed in the hope that it is useful, but without warranty. It can be downloaded at: www.wiwiss.fu-berlin.de/fachbereich/vwl/iso/ehemalige/wilrich/index.html  or at: www.statistics-wilrich.info.\nThere you have also the possibility to subscribe to a newsletter informing about updates of the program. For assistance contact: wilrich@wiwiss.fu-berlin.de  or  news@statistics-wilrich.info."]
[]
[]
[]
[null,"General information on the experiment",null,null,null,null,null,null,"RLOD calculation results  •  Examples as in ISO 16140-2"]
[null,"Experiment name:",null,"Examples as in ISO 16140-2",null,null,null,null,"Matrix",null,"Auxiliary values",null,null,"95 % confidence limit",null,"Test\n statistic 3"]
[null,"Experiment date:",null,null,null,null,null,null,"No.","Name","ln RLOD","sd (ln RLOD)","RLOD","lower","upper"]
[null,"Microorganism:",null,null," Count unit: 1","cfu",null,null,"i",null,"ĝ","sĝ","Ĝ","GL","GU","| z |"]
[null,"Sample size A0:",null,25," Unit: 1","g",null,null,1,"Eggs",0.159245120010159,0.36677179672110355,1.1726253453922666,0.56309975971937787,2.4419300078224007,0.43418038527987057]
[null,"No. of matrices:",null,5,null,null,null,null,2,"Feedingstuff",3.3296606074603163E-2,0.40414918817043888,1.033857142077538,0.46070296543132161,2.3200644893267408,8.2386918121337985E-2]
[null,"Max. no. of levels per matrix:",null,9,null,null,null,null,3,"Fish",0.69211033029123403,0.28652344157011517,1.9979273741495953,1.1264413855178166,3.5436498016639684,2.4155452220542579]
[null,"Contamination specification: 2",null,"known concentrations",null,null,"€",null,4,"Meat",0.93938916560011065,0.32133573629412626,2.5584181711070744,1.3454354200081484,4.8649704332975165,2.9233884050178141]
[null,"1  The units are set automatically to 'cfu' and 'g' as long as nothing else is entered.",null,null,null,null,null,null,5,"Milk",0.70283524439953882,0.38387840507199739,2.0194702900983326,0.93714096444875117,4.3518108879049739,1.8308798700664608]
[null,"2  Select from the dropdown list. The contamination level can be specified as\n    − unknown contaminations, e.g. 1, 2, 3 etc. or  low, medium, high etc.;\n    − known concentrations in cfu/g;\n    − known dilution factors, e.g. 1 = undiluted, 0.1 = diluted 1 in 10 etc.",null,null,null,null,null,null,"Combined results 3",null,0.55051260128100199,0.15293950442312584,1.7341417133384136,1.2771532688429381,2.3546488548432118,3.5995448223628443]
[null,null,null,null,null,null,null,null,"3  For information on the test statistic | z | and the combined results, see the sheet 'Info'."]
[]
[]
[null,"Experimental data",null,null,null,null,null,null,"Example \nThe data and results shown here correspond to those given in the publication:\nI. MARGARITESCU and P.-Th. WILRICH: Determination of the Relative Level of Detection of a Qualitative Microbiological Measurement Method with Respect to a Reference Measurement Method, Journal of AOAC International 96, 1086-1091 (2013).\nThese data originate from ISO 16140-2:  Microbiology of the food chain ‒ Method validation ‒ Part 2: Protocol for the validation of alternative (proprietary) methods against a reference method.\n\nTo use the program, go to the sheet 'RLOD Program'."]
[null,"Matrix 1","Name:","Eggs"]
[null,"Contamination","Reference method",null,"Alternative method"]
[null,"in cfu / g","No. of tests","No. of  + tests","No. of tests","No. of  + tests"]
[null,"dj","nRj","yRj","nAj","yAj"]
[null,1.2239999999999999E-2,6,1,6,1]
[null,1.7999999999999999E-2,6,2,6,2]
[null,3.2129999999999999E-2,6,4,6,4]
[null,5.6230000000000002E-2,6,6,6,5]
[null,8.8370000000000004E-2,6,6,6,6]
[]
[]
[]
[]
[]
[null,"Matrix 2","Name:","Feedingstuff"]
[null,"Contamination","Reference method",null,"Alternative method"]
[null,"in cfu / g","No. of tests","No. of  + tests","No. of tests","No. of  + tests"]
[null,"dj","nRj","yRj","nAj","yAj"]
[null,1.4200000000000001E-2,6,2,6,2]
[null,2.367E-2,6,2,6,3]
[null,3.7870000000000001E-2,6,6,6,5]
[null,8.43E-2,6,6,6,6]
[]
[]
[]
[]
[]
[]
[null,"Matrix 3","Name:","Fish"]
[null,"Contamination","Reference method",null,"Alternative method"]
[null,"in cfu / g","No. of tests","No. of  + tests","No. of tests","No. of  + tests"]
[null,"dj","nRj","yRj","nAj","yAj"]
[null,1.0449999999999999E-2,6,0,6,2]
[null,1.393E-2,6,2,6,1]
[null,1.5869999999999999E-2,6,5,6,2]
[null,2.5600000000000001E-2,6,4,6,4]
[null,2.777E-2,6,6,6,2]
[null,0.04,6,5,6,5]
[null,4.5330000000000002E-2,6,6,6,4]
[null,8.3199999999999996E-2,6,6,6,5]
[null,0.15867000000000001,6,6,6,6]
[]
[null,"Matrix 4","Name:","Meat"]
[null,"Contamination","Reference method",null,"Alternative method"]
[null,"in cfu / g","No. of tests","No. of  + tests","No. of tests","No. of  + tests"]
[null,"dj","nRj","yRj","nAj","yAj"]
[null,9.9500000000000005E-3,6,1,6,1]
[null,1.3270000000000001E-2,6,3,6,1]
[null,2.4750000000000001E-2,6,5,6,3]
[null,3.465E-2,6,6,6,2]
[null,4.9500000000000002E-2,6,6,6,5]
[null,5.96E-2,6,6,6,5]
[null,8.9200000000000002E-2,6,6,6,6]
[]
[]
[]
[null,"Matrix 5","Name:","Milk"]
[null,"Contamination","Reference method",null,"Alternative method"]
[null,"in cfu / g","No. of tests","No. of  + tests","No. of tests","No. of  + tests"]
[null,"dj","nRj","yRj","nAj","yAj"]
[null,1.12E-2,6,3,6,0]
[null,2.24E-2,6,2,6,0]
[null,3.7330000000000002E-2,6,4,6,3]
[null,6.5890000000000004E-2,6,5,6,4]
[null,0.10440000000000001,6,6,6,6]