{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["PODLOD Program","Info & Equations","Example","Ex Fig combined","Ex Fig all","Ex Fig 1","Ex Fig 2","Ex Fig 3","Ex Fig 4","Ex Fig 5"],"not_rendered":{"charts":14,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Ex Fig combined","index":3,"reason":"not_a_worksheet"},{"sheet":"Ex Fig all","index":4,"reason":"not_a_worksheet"},{"sheet":"Ex Fig 1","index":5,"reason":"not_a_worksheet"},{"sheet":"Ex Fig 2","index":6,"reason":"not_a_worksheet"},{"sheet":"Ex Fig 3","index":7,"reason":"not_a_worksheet"},{"sheet":"Ex Fig 4","index":8,"reason":"not_a_worksheet"},{"sheet":"Ex Fig 5","index":9,"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":"PODLOD Program","index":0,"n_rows":18,"n_cols":20,"rows_kept":18,"cut":false,"hidden":false,"merged":[[8,6,21,19],[16,3,16,4],[17,1,17,4],[1,16,3,17],[5,16,5,17],[8,1,8,4],[9,1,9,2],[9,3,9,4],[1,1,1,15],[3,1,3,15],[4,1,6,15],[16,1,16,2],[10,1,10,2],[13,1,13,2],[10,3,10,4],[11,1,11,2],[11,3,11,4],[12,1,12,2],[14,1,14,2],[14,3,14,4],[15,1,15,2],[12,3,12,4],[13,3,13,4],[15,3,15,4]]}
[]
[null,"PODLOD program, version 12, dated 2024-03-05, for estimating the POD function and the LOD of a qualitative microbiological measurement method",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculate\nResults",null,null,"Print Tables b/w"]
[]
[null,"For information see the following sheets 'Info & Equations' and 'Example'.  For details see: C. WILRICH & P.-TH. WILRICH, Journal of AOAC International 92(6), 1763-1772 (2009).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Print Tables"]
[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,"Hide 'How to'",null,null,"Print Figures"]
[]
[]
[null,"General information on the experiment",null,null,null,null,"How to use this program  (Macros have to be enabled, see the sheet 'Info & Equations'): \n1.  To obtain reliable results, at least 3 informative inoculation levels should be used. For more information, see the sheet 'Info & Equations'.\n2.  Enter information on your experiment into the yellow cells of the general input table.\n      −  Informative: If filled in, the name and date of the experiment and the microorganism will be included in the result tables and figures (see step 4).\n      −  Optional: The units of the microorganism count and of the sample size may be chosen freely. If nothing else is entered, they are set to 'cfu' and 'g'.\n      −  Required: Sample size (also referred to as test portion size), no. of matrices (up to 30) and no. of inoculation levels (up to 30) per matrix.\n      ► The according tables for the input of your experimental results will be generated automatically based on the no. of matrices and inoculation levels.\n3.  Enter your data into the yellow cells of the input tables for the matrices generated according to step 2.\n      −  The inoculation level d may be entered either per unit of the sample size in the 1st column or per sample size in the 2nd column.\n      ► The respective other value for the inoculation level d will be entered automatically based on the sample size.\n4.  Press 'Ctrl+p' to start the calculation or use the button 'Calculate Results' (see top right).\n      ► The results will be shown in two green tables below. Figures of the probabilities of detection will be shown in the sheets next to this sheet.\n5.  You can change any input data in the yellow cells of the general table and the matrix tables at any time.\n      ► Changes of data in the input tables cause deletion of the results tables but you can recalculate as per step 4 at any time.\n6.  You can print the tables (with an automatically adjusted print area) and the figures with the respective 'Print' buttons (see top right).\n7.  You can toggle between hiding and showing these instructions with the 'Hide/Show' button (see top right)."]
[null,"Name of experiment:"]
[null,"Date of experiment:"]
[null,"Microorganism:"]
[null,"Unit of microorganism count: 1",null,"cfu"]
[null,"Sample size A0:"]
[null,"Unit of the sample size: 1",null,"g"]
[null,"No. of matrices:"]
[null,"No. of inoculation levels:"]
[null,"1  The units are automatically set to 'cfu' and 'g' but may be changed."]

{"sheet":"Info & Equations","index":1,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[[38,13,41,13],[38,14,41,14],[42,13,46,13],[42,14,46,14],[29,13,32,13],[29,14,32,14],[33,13,37,13],[33,14,37,14],[25,7,33,10],[1,1,1,14],[3,1,3,14],[4,1,6,14],[8,1,52,4],[8,7,14,10],[15,9,15,10],[16,7,16,8],[16,9,17,9],[16,10,17,10],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8]]}
[]
[null,"PODLOD program, version 12, dated 2024-03-05, for estimating the POD function and the LOD of a qualitative microbiological measurement method"]
[]
[null,"To use the program, go to the sheet 'PODLOD Program'.  For information see the following sheets 'Example'.  For details see: C. WILRICH & P.-TH. WILRICH, Journal of AOAC International 92(6), 1763-1772 (2009)."]
[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\n\nThis program was developed in Excel 365. It should run also in older versions, hopefully down to Excel 2007.\n\nEnabling of macros\n\nTo unblock macros on a file, right-click the downloaded file, select 'properties' and click 'unblock' at the bottom of the tab.\n\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 > Browse  and then select the respective folder.\n\nCorrect display of figures\n\nIn order to display the figures, the computer must be connected to a printer (driver). This can also be a converter to pdf or xps.\n\nRevisions of the program\n\nVersion 12, dated 2024-03-05, is amended to enable calculation also in case of extremely high inoculation levels. A button to toggle between hiding and showing the instructions on how to use the program is added.\n\nVersion 11, dated 2022-10-12, is amended to allow input of the units of the microorganism count and of the sample size.\n\nVersion 10, dated 2021-04-05, is amended as follows: The inoculation level d may be entered either in cfu/g or cfu/ml or in cfu/A0 (per sample size). Two result tables are generated, one with the LOD relating to d in cfu/g or cfu/ml and one with the LOD relating to d in cfu/A0.\n\nVersion 9, dated 2017-09-23, is amended as follows: The data of matrices with no fractional results y/n (no positive tubes or only positive tubes) are included in the calculation of the combined results. Additionally, the combined results are supplemented by a note informing the data of which matrices were included in the according calculation. The x-axes of the diagrams are changed so that all diagrams have the same scale. Furthermore, the design is changed and buttons are added to start the calculation and to print the tables and figures with an automatically adjusted print area.\n\nVersion 8, dated 2016-09-09, is revised with regard to the design, improved with regard to a more efficient code, corrected with regard to input data in the example sheet, the log matrix effect f is added to the results table and explanations are added in case a matrix is not calculated because no fractional results y/n are available.\n\nVersion 7, dated 2016-03-01, is improved with regard to generation of the diagrams.\n\nVersion 6.1, dated 2014-09-09, is corrected with regard to calculations for only 1 matrix.\n\nVersion 6, dated 2014-01-22, is amended by allowing the user to determine the number of matrices and the maximum no. of  contamination levels instead of having a fixed number of input tables and contamination levels.\n\nVersion 1, published in 2009, is a program for  estimating the POD function and the LOD of a qualitative microbiological measurement method.",null,null,null,null,null,"References\n\nThis PODLOD program is referenced in ISO 16140-2.\n\nDesign of the experiment\n\nTo obtain reliable results, at least 3 informative inoculation levels should be used. These preferably should correspond to a low, a target and a high inoculation level. A blank and a positive control can be used in addition but generally require 1 tube only. Such a design is shown exemplarily in the following:",null,null,null,null,null,"Equations (with the inoculation level d in unit of microorganism count / unit of sample size)"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Matrix 1","Name:","Example typical design"]
[null,null,null,null,null,null,null,"Inoculation level",null,"No. of\ninoculated tubes","No. of\npositive tubes"]
[null,null,null,null,null,null,null,"in cfu / ml","in cfu / A0"]
[null,null,null,null,null,null,null,"d",null,"n","y"]
[null,null,null,null,null,null,null,"d = 0 = blank control",null,1]
[null,null,null,null,null,null,null,"d = low level",null,6]
[null,null,null,null,null,null,null,"d = target level",null,6]
[null,null,null,null,null,null,null,"d = high level",null,6]
[null,null,null,null,null,null,null,"d = positive control",null,1]
[]
[null,null,null,null,null,null,null,"Use of different sample sizes\n\nThe calculation results of this program are based on the sample size A0 as given in the general table of the Program sheet. When working with different sample sizes (e.g. composited / pooled), it is necessary to run a separate calculation for each sample size. For this purpose, you have to enter the respective sample size in the genral table and the corresponding data into the matrix tables. Then you have to recalculate either by pressing 'Ctrl+p' or by using the button 'Calculate results'."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Protocols applied in this program"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimental results","Protocol"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"\nIf a positive result was obtained for a blank control, this is clearly an error and the test should be repeated after checking for possible causes, e.g. contaminated medium or faulty technique.","\nNo calculation is carried out for the respective matrix and its data are not included in the calculation of the combined results."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"\nIf no positive result was obtained for any of the inoculation levels, this suggests that the tubes were not inoculuted, the medium does not support growth of the test organism or the primary sample did not contain the test organism. The test procedure should be carefully checked for possible errors.","\nThe data of the respective matrix are included in the calculation of the combined results."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"\nIf only positive results were obtained for all inoculation levels (except for the blank control), this suggests that preparation of the inoculation levels was not done properly. The procedure should be carefully checked for possible errors.","\nThe data of the respective matrix are included in the calculation of the combined results."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"\nIf a negative result was obtained for the positive control, this is clearly an error and the test should be repeated after checking for possible causes e.g. failure to inoculate the medium or wrong level of test organisms in the inoculum.","\nThe data of the respective matrix are included in the calculation of the combned results."]

{"sheet":"Example","index":2,"n_rows":70,"n_cols":18,"rows_kept":70,"cut":false,"hidden":false,"merged":[[63,1,63,2],[63,3,64,3],[63,4,64,4],[65,1,65,2],[34,6,40,17],[55,1,55,2],[62,3,62,4],[3,1,3,17],[4,1,6,17],[52,3,52,4],[53,1,53,2],[53,3,54,3],[53,4,54,4],[35,1,35,2],[42,3,42,4],[43,1,43,2],[43,3,44,3],[43,4,44,4],[45,1,45,2],[31,6,32,6],[31,7,32,7],[32,3,32,4],[32,8,32,17],[33,1,33,2],[33,3,34,3],[33,4,34,4],[23,12,24,12],[23,13,24,13],[25,1,25,2],[23,1,23,2],[23,3,24,3],[23,4,24,4],[23,6,24,6],[20,1,21,4],[21,6,21,17],[22,3,22,4],[22,8,24,8],[22,9,24,9],[22,10,24,10],[22,11,22,13],[22,14,22,16],[22,17,24,17],[23,14,24,14],[23,15,24,15],[23,16,24,16],[23,7,24,7],[23,11,24,11],[17,1,17,4],[18,6,19,6],[18,7,19,7],[19,1,19,4],[19,8,19,17],[14,1,14,2],[14,3,14,4],[15,1,15,2],[15,3,15,4],[16,1,16,2],[16,3,16,4],[11,1,11,2],[11,3,11,4],[12,1,12,2],[12,3,12,4],[13,1,13,2],[13,3,13,4],[9,9,11,9],[9,10,11,10],[9,11,9,13],[10,15,11,15],[10,16,11,16],[8,1,8,4],[8,6,8,17],[1,1,1,17],[9,14,9,16],[9,17,11,17],[10,1,10,2],[10,3,10,4],[10,6,11,6],[10,7,11,7],[10,11,11,11],[10,12,11,12],[10,13,11,13],[10,14,11,14],[9,1,9,2],[9,3,9,4],[9,8,11,8]]}
[]
[null,"PODLOD program, version 12, dated 2024-03-05, for estimating the POD function and the LOD of a qualitative microbiological measurement method: Example sheet"]
[]
[null,"To use the program, go to the sheet 'PODLOD Program'.  For information see the sheet 'Info & Equations'.  For details see: C. WILRICH & P.-TH. WILRICH, Journal of AOAC International 92(6), 1763-1772 (2009)."]
[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,"PODLOD calculation results with the LOD for d in cfu / g    •  Example  •  Listeria monocytogenes  •  09.01.2009"]
[null,"Name of experiment:",null,"Example",null,null,null,null,"Matrix\neffect","ln\nmatrix\neffect","SD of ln\nmatrix\neffect","LOD50% = 50 % limit of detection",null,null,"LOD95% = 95 % limit of detection",null,null,"Test\nstatistic\nmatrix\neffect"]
[null,"Date of experiment:",null,"09.01.2009",null,null,"No.","Matrix",null,null,null,"Detection\nlimit","Lower\nconf. limit","Upper\nconf. limit","Detection\nlimit","Lower\nconf. limit","Upper\nconf. limit"]
[null,"Microorganism:",null,"Listeria monocytogenes"]
[null,"Unit of microorganism count: 1",null,"cfu",null,null,"i",null,"F̂","f̂","sf̂","d̂0.5","d̂0.5,L","d̂0.5,U","d̂0.95","d̂0.95,L","d̂0.95,U","|z|"]
[null,"Sample size A0:",null,25,null,null,1,"Pasteurized milk",0.8325382710100121,-0.18327608700098291,0.27157093116293168,3.3302838065043597E-2,1.9346291709835626E-2,5.7327731837242102E-2,0.14393247147279617,8.3613281672625037E-2,0.24776633484354529,0.67918801992055544]
[null,"Unit of the sample size: 1",null,"g",null,null,2,"Rillettes",0.93225738691388793,-7.014633620679811E-2,0.25145478853912567,2.9740592685653704E-2,1.798617293925197E-2,4.9176823567823671E-2,0.12853670308672829,7.7734946145655862E-2,0.21253869539509604,0.2786980258264089]
[null,"No. of matrices:",null,5,null,null,3,"Fish",1.2127219339819759,0.19286736541567912,0.28324863490440078,2.2862526392476289E-2,1.2974707666887764E-2,4.0285694789149222E-2,9.8810195135747056E-2,5.6075753588472665E-2,0.1741118761312814,0.67554906478298771]
[null,"No. of inoculation levels:",null,5,null,null,4,"Frozen cooked vegetables",1.5944057075936959,0.46650106968531396,0.28321863984592716,1.738948066376543E-2,9.8692926494528318E-3,3.063988965533786E-2,7.5156085036228323E-2,4.2654373178335508E-2,0.1324233999256533,1.5708317236597764]
[null,"1  The units are automatically set to 'cfu' and 'g' but may be changed.",null,null,null,null,5,"Process water",0.88593969467409195,-0.12110639539549087,0.28317806855675737,3.1295456552036818E-2,1.7762984894289041E-2,5.5137444896173504E-2,0.13525671291457467,7.6770343463687607E-2,0.23830007217707599,0.42628577968285336]
[null,null,null,null,null,null,null,"Combined results",1.0335818406483639,3.3030284859707423E-2,0.12344189777845881,2.682505258123093E-2,2.0956575282990254E-2,3.4336881683614873E-2,0.11593594839765269,9.0572811488177626E-2,0.14840153363923836,0.26735269047735455]
[null,"Experimental results",null,null,null,null,null,null,"The combined results are based on the data of matrices 1, 2, 3, 4 and 5."]
[null,"2  There are two alternatives for entering the inoculation level d.\n   The explanation is given in step 3 in 'How to use this program'."]
[null,null,null,null,null,null,"PODLOD calculation results with the LOD for d in cfu / A0    •  Example  •  Listeria monocytogenes  •  09.01.2009"]
[null,"Matrix 1","Name:","Pasteurized milk",null,null,null,null,"Matrix\neffect","ln\nmatrix\neffect","SD of ln\nmatrix\neffect","LOD50% = 50 % limit of detection",null,null,"LOD95% = 95 % limit of detection",null,null,"Test\nstatistic\nmatrix\neffect"]
[null,"Inoculation level 2",null,"No. of\ninoculated tubes","No. of\npositive tubes",null,"No.","Matrix",null,null,null,"Detection\nlimit","Lower\nconf. limit","Upper\nconf. limit","Detection\nlimit","Lower\nconf. limit","Upper\nconf. limit"]
[null,"in cfu / g","in cfu / A0"]
[null,"d",null,"n","y",null,"i",null,"F̂","f̂","sf̂","d̂0.5","d̂0.5,L","d̂0.5,U","d̂0.95","d̂0.95,L","d̂0.95,U","|z|"]
[null,1.1199999999999998E-2,0.27999999999999997,6,1,null,1,"Pasteurized milk",0.8325382710100121,-0.18327608700098291,0.27157093116293168,0.83257095162608996,0.48365729274589064,1.4331932959310525,3.5983117868199042,2.0903320418156257,6.1941583710886325,0.67918801992055544]
[null,2.2399999999999996E-2,0.55999999999999994,6,2,null,2,"Rillettes",0.93225738691388793,-7.014633620679811E-2,0.25145478853912567,0.7435148171413426,0.44965432348129925,1.2294205891955918,3.2134175771682072,1.9433736536413966,5.3134673848774012,0.2786980258264089]
[null,4.4799999999999993E-2,1.1199999999999999,6,4,null,3,"Fish",1.2127219339819759,0.19286736541567912,0.28324863490440078,0.5715631598119072,0.32436769167219409,1.0071423697287305,2.4702548783936762,1.4018938397118166,4.3527969032820346,0.67554906478298771]
[null,6.7199999999999996E-2,1.68,6,4,null,4,"Frozen cooked vegetables",1.5944057075936959,0.46650106968531396,0.28321863984592716,0.43473701659413577,0.2467323162363208,0.76599724138344649,1.8789021259057082,1.0663593294583877,3.3105849981413327,1.5708317236597764]
[null,0.1416,3.54,6,6,null,5,"Process water",0.88593969467409195,-0.12110639539549087,0.28317806855675737,0.78238641380092044,0.44407462235722606,1.3784361224043375,3.3814178228643668,1.9192585865921901,5.9575018044268999,0.42628577968285336]
[null,null,null,null,null,null,null,"Combined results",1.0335818406483639,3.3030284859707423E-2,0.12344189777845881,0.67062631453077326,0.52391438207475638,0.85842204209037187,2.8983987099413171,2.2643202872044408,3.710038340980959,0.26735269047735455]
[null,"Matrix 2","Name:","Rillettes",null,null,null,null,"The combined results are based on the data of matrices 1, 2, 3, 4 and 5."]
[null,"Inoculation level 2",null,"No. of\ninoculated tubes","No. of\npositive tubes"]
[null,"in cfu / g","in cfu / A0",null,null,null,"Example\nThe data and results shown here and the figures in the following sheets correspond to those given in the publication:\nC. WILRICH & P.-TH. WILRICH: Estimation of the POD Function and the LOD of a Qualitative Microbiological Measurement Method, \nJournal of AOAC International  92 (6), 1763-1772 (2009). \n\nTo use the program go to the Sheet 'PODLOD Program'."]
[null,"d",null,"n","y"]
[null,1.5599999999999998E-2,0.38999999999999996,6,1]
[null,3.0800000000000001E-2,0.77,6,4]
[null,6.2E-2,1.55,6,4]
[null,9.2799999999999994E-2,2.3199999999999998,6,5]
[null,9.8000000000000004E-2,2.4500000000000002,6,6]
[]
[null,"Matrix 3","Name:","Fish"]
[null,"Inoculation level 2",null,"No. of\ninoculated tubes","No. of\npositive tubes"]
[null,"in cfu / g","in cfu / A0"]
[null,"d",null,"n","y"]
[null,1.44E-2,0.36,6,1]
[null,2.92E-2,0.73,6,5]
[null,5.800000000000001E-2,1.4500000000000002,6,4]
[null,8.72E-2,2.1800000000000002,6,6]
[]
[]
[null,"Matrix 4","Name:","Frozen cooked vegetables"]
[null,"Inoculation level 2",null,"No. of\ninoculated tubes","No. of\npositive tubes"]
[null,"in cfu / g","in cfu / A0"]
[null,"d",null,"n","y"]
[null,1.0800000000000001E-2,0.27,6,2]
[null,2.1600000000000001E-2,0.54,6,4]
[null,4.3200000000000002E-2,1.08,6,4]
[null,6.4799999999999996E-2,1.6199999999999999,6,6]
[]
[]
[null,"Matrix 5","Name:","Process water"]
[null,"Inoculation level 2",null,"No. of\ninoculated tubes","No. of\npositive tubes"]
[null,"in cfu / g","in cfu / A0"]
[null,"d",null,"n","y"]
[null,0.02,0.5,6,3]
[null,0.04,1,6,2]
[null,0.08,2,6,5]
[null,0.12,3,6,6]