{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Program","Equations & Info","Examples"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":3,"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":"Program","index":0,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,3,11],[4,0,4,3],[4,5,10,13],[7,0,8,3]]}
["MPN calculation program, version 5,  dated 2017-01-09,  for calculating most probable numbers, their standard deviations, confidence bounds and rarity values.\n\nMore information can be found in the following sheets 'Equations & Info' and 'Examples'.  For details see: B. Jarvis, C. Wilrich and P.-T. Wilrich, Journal of Applied Microbiology 109, 2010, 1660-1667.\nThis Excel program is distributed in the hope that it will be useful, but without any warranty.  It can be downloaded at: www.wiwiss.fu-berlin.de/fachbereich/vwl/iso/ehemalige/wilrich/index.html.\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."]
[]
[]
[]
["General data and data for generating the input tables",null,null,null,null,"How to use this program  (Macros have to be enabled):\n1.   Enter the no. of test series (up to 30) and the max. no. of dilutions (up to 30) per test series into the yellow table.\n       ► The tables for your input data will be generated automatically below.\n2.   Enter your data into the yellow cells of the input tables generated according to step 1.\n3.   Press 'Ctrl+m' to start the calculation or use the button 'Calculate Results'.\n       ► The results will be shown below in a green table (with two signifcant decimals in columns 8 to 12).\n4.   You can change the no. of test series or dilutions in row 7 at any time (and preserve data you entered before).\n5.   You can also change the data in the input tables at any time.\n       ► Changes of the input data cause the results table to be deleted but you can re-calculate as per step 3 at any time.\n6.   You can print the tables (with a dynamically adjusted print area) using the buttons 'Print Tables'."]
["Name of experiment","Date of experiment","No. of test series","Max. no. of dilutions"]
[]
["Note:  A test series / matrix consists of the different dilutions for one target organism / test medium."]

{"sheet":"Equations & Info","index":1,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[5,8,7,13],[12,8,14,13],[15,8,17,13],[18,8,20,13],[21,8,22,13],[0,0,3,11],[4,0,4,6],[4,8,4,13],[9,8,9,12],[10,8,11,13]]}
["MPN calculation program, version 5,  dated 2017-01-09,  for calculating most probable numbers, their standard deviations, confidence bounds and rarity values.\n\nMore information can be found in the following sheets 'Equations & Info' and 'Examples'.  For details see: B. Jarvis, C. Wilrich and P.-T. Wilrich, Journal of Applied Microbiology 109, 2010, 1660-1667.\nThis Excel program is distributed in the hope that it will be useful, but without any warranty.  It can be downloaded at: www.wiwiss.fu-berlin.de/fachbereich/vwl/iso/ehemalige/wilrich/index.html.\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."]
[]
[]
[]
["Equations used for the MPN calculation program:",null,null,null,null,null,null,null,"Required version of Excel:"]
[null,null,null,null,null,null,null,null,"This program should run on Excel 2003 and newer. \nIn older versions of Excel (2003 and maybe 2007) the buttons in the sheet 'Program' might not work properly (in that case the calculation can be started with 'Ctrl+m') and the equations to the left might not be displayed properly."]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Revisions of the MPN calculation program:"]
[null,null,null,null,null,null,null,null,"Version 5, dated 2017-01-09, is revised with regard to the design, improved with regard to a more efficient code and allows for easy printing of the tables."]
[]
[null,null,null,null,null,null,null,null,"Version 4, dated 2015-04-14, is amended by allowing to indicate 0 as the number of tubes n and by using scientific notation for very large and very small resulting numbers."]
[]
[]
[null,null,null,null,null,null,null,null,"Version 3, dated 2013-01-13, is amended by allowing the user to determine the number of test series and the maximum no. of dilutions instead of having a fixed number of input tables and dilutions."]
[]
[]
[null,null,null,null,null,null,null,null,"Version 2, dated 2010-07-14, is amended by giving advice on MPN falling into rarity category 3, adding a definition for the dilution factor and by indicating \"Inf\" for the MPN and the upper confidence limit in case all xi = ni."]
[]
[]
[null,null,null,null,null,null,null,null,"Version 1, published in 2010, is a program for  calculating most probable numbers, their standard deviations, confidence bounds and rarity values."]

{"sheet":"Examples","index":2,"n_rows":251,"n_cols":14,"rows_kept":251,"cut":false,"hidden":false,"merged":[[12,7,13,7],[12,8,13,8],[12,9,13,9],[0,0,3,11],[4,0,4,3],[4,5,10,13],[7,0,8,3],[9,0,10,3],[11,0,11,3],[11,5,11,13],[12,10,12,11],[12,12,13,12],[12,13,13,13],[13,0,13,1],[13,2,13,3],[20,0,20,1],[20,2,20,3],[12,0,12,1],[12,2,12,3],[12,5,12,6],[21,0,21,1],[21,2,21,3],[28,0,28,1],[28,2,28,3],[29,0,29,1],[29,2,29,3],[36,0,36,1],[36,2,36,3],[37,0,37,1],[37,2,37,3],[44,0,44,1],[44,2,44,3],[45,0,45,1],[45,2,45,3],[52,0,52,1],[52,2,52,3],[53,0,53,1],[53,2,53,3],[60,0,60,1],[60,2,60,3],[61,0,61,1],[61,2,61,3],[68,0,68,1],[68,2,68,3],[69,0,69,1],[69,2,69,3],[76,0,76,1],[76,2,76,3],[77,0,77,1],[77,2,77,3],[84,0,84,1],[84,2,84,3],[85,0,85,1],[85,2,85,3],[92,0,92,1],[92,2,92,3],[93,0,93,1],[93,2,93,3],[100,0,100,1],[100,2,100,3],[101,0,101,1],[101,2,101,3],[108,0,108,1],[108,2,108,3],[109,0,109,1],[109,2,109,3],[116,0,116,1],[116,2,116,3],[117,0,117,1],[117,2,117,3],[124,0,124,1],[124,2,124,3],[125,0,125,1],[125,2,125,3],[132,0,132,1],[132,2,132,3],[133,0,133,1],[133,2,133,3],[140,0,140,1],[140,2,140,3],[141,0,141,1],[141,2,141,3],[148,0,148,1],[148,2,148,3],[149,0,149,1],[149,2,149,3],[156,0,156,1],[156,2,156,3],[157,0,157,1],[157,2,157,3],[164,0,164,1],[164,2,164,3],[165,0,165,1],[165,2,165,3],[172,0,172,1],[172,2,172,3],[173,0,173,1],[173,2,173,3],[180,0,180,1],[180,2,180,3],[181,0,181,1],[181,2,181,3],[188,0,188,1],[188,2,188,3],[189,0,189,1],[189,2,189,3],[196,0,196,1],[196,2,196,3],[197,0,197,1],[197,2,197,3],[204,0,204,1],[204,2,204,3],[205,0,205,1],[205,2,205,3],[212,0,212,1],[212,2,212,3],[213,0,213,1],[213,2,213,3],[220,0,220,1],[220,2,220,3],[221,0,221,1],[221,2,221,3],[228,0,228,1],[228,2,228,3],[229,0,229,1],[229,2,229,3],[236,0,236,1],[236,2,236,3],[237,0,237,1],[237,2,237,3],[244,0,244,1],[244,2,244,3],[245,0,245,1],[245,2,245,3]]}
["MPN calculation program, version 5,  dated 2017-01-09,  for calculating most probable numbers, their standard deviations, confidence bounds and rarity values.\n\nMore information can be found in the following sheets 'Equations & Info' and 'Examples'.  For details see: B. Jarvis, C. Wilrich and P.-T. Wilrich, Journal of Applied Microbiology 109, 2010, 1660-1667.\nThis Excel program is distributed in the hope that it will be useful, but without any warranty.  It can be downloaded at: www.wiwiss.fu-berlin.de/fachbereich/vwl/iso/ehemalige/wilrich/index.html.\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."]
[]
[]
[]
["General data and data for generating the input tables",null,null,null,null,"Example Sheet   (to use the program, go to the sheet 'Program'):\n\nThe examples shown here correspond to examples given in ISO 7218, Annex C, Tables C.5 to C.7  \n(the first 10 rows of each of these Tables)."]
["Name of experiment","Date of experiment","No. of test series","Max. no. of dilutions"]
["ISO 7218","2016-12-12",30,3]
["Note:  A test series / matrix consists of the different dilutions for one target organism / test medium."]
[]
["Note:   The dilution factor d is the dilution ratio used for inoculating the tubes of that row, i.e. 1.0 (undiluted), \n0.1 (diluted 1 in 10), etc.    The volume w is the volume of the dilution added to each tube in that row."]
[]
["Input data",null,null,null,null,"Results of the MPN calculations"]
["Test series 1  /  Matrix 1   -   Designation:",null,"Table C.5, row 1 (3x3)",null,null,"Test series  /  Matrix",null,"MPN","log10 MPN","SD\nlog10 MPN","95% confidence limits",null,"Rarity\nIndex","Category"]
["Target organism  /  Test medium:",null,null,null,null,"No.","Designation",null,null,null,"Lower","Upper"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes",null,1,"Table C.5, row 1 (3x3)",0,null,null,0,1.1000000000000001,1,1]
["d","w","n","x",null,2,"Table C.5, row 2 (3x3)",0.3,-0.52,0.43,4.1000000000000002E-2,2.2999999999999998,8.6845669044209511E-2,1]
[1,1,3,0,null,3,"Table C.5, row 3 (3x3)",0.36,-0.45,0.44,4.8000000000000001E-2,2.7,1,1]
[0.1,1,3,0,null,4,"Table C.5, row 4 (3x3)",0.72,-0.14000000000000001,0.31,0.17,3,2.0521675737329558E-2,2]
[0.01,1,3,0,null,5,"Table C.5, row 5 (3x3)",0.74,-0.13,0.31,0.18,3.1,0.21071557946513267,1]
[null,null,null,null,null,6,"Table C.5, row 6 (3x3)",1.1000000000000001,5.6000000000000001E-2,0.26,0.35,3.7,2.0555398077221017E-2,2]
["Test series 2  /  Matrix 2   -   Designation:",null,"Table C.5, row 2 (3x3)",null,null,7,"Table C.5, row 7 (3x3)",0.92,-3.6999999999999998E-2,0.32,0.21,4,1,1]
["Target organism  /  Test medium:",null,null,null,null,8,"Table C.5, row 8 (3x3)",1.4,0.16,0.26,0.42,4.8,4.0712846530504589E-2,2]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes",null,9,"Table C.5, row 9 (3x3)",1.5,0.17,0.27,0.43,5,0.42578922877660069,1]
["d","w","n","x",null,10,"Table C.5, row 10 (3x3)",2,0.31,0.23,0.69,6,1.8805457597403808E-2,2]
[1,1,3,0,null,11,"Table C.6, row 1 (3x5)",0,null,null,0,0.66,1,1]
[0.1,1,3,1,null,12,"Table C.6, row 2 (3x5)",0.18,-0.74,0.43,2.5000000000000001E-2,1.3,9.174311926605408E-2,1]
[0.01,1,3,0,null,13,"Table C.6, row 3 (3x5)",0.2,-0.7,0.44,2.7E-2,1.5,1,1]
[null,null,null,null,null,14,"Table C.6, row 4 (3x5)",0.4,-0.4,0.31,9.7000000000000003E-2,1.6,1.9992656297834574E-2,2]
["Test series 3  /  Matrix 3   -   Designation:",null,"Table C.5, row 3 (3x3)",null,null,15,"Table C.6, row 5 (3x5)",0.4,-0.39,0.31,9.7000000000000003E-2,1.7,0.20547104785091477,1]
["Target organism  /  Test medium:",null,null,null,null,16,"Table C.6, row 6 (3x5)",0.61,-0.21,0.25,0.19,2,2.3606032760914376E-2,2]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes",null,17,"Table C.6, row 7 (3x5)",0.45,-0.35,0.31,0.11,1.9,1,1]
["d","w","n","x",null,18,"Table C.6, row 8 (3x5)",0.68,-0.17,0.25,0.21,2.2000000000000002,3.3951446504074341E-2,2]
[1,1,3,1,null,19,"Table C.6, row 9 (3x5)",0.68,-0.16,0.25,0.21,2.2000000000000002,0.3539382054781996,1]
[0.1,1,3,0,null,20,"Table C.6, row 10 (3x5)",0.92,-3.5999999999999997E-2,0.22,0.33,2.5,1.4761569196590895E-2,2]
[0.01,1,3,0,null,21,"Table C.7, row 1 (3x10)",0,null,null,0,0.33,1,1]
[null,null,null,null,null,22,"Table C.7, row 2 (3x10)",0.09,-1,0.43,1.2E-2,0.67,9.0909090909089968E-2,1]
["Test series 4  /  Matrix 4   -   Designation:",null,"Table C.5, row 4 (3x3)",null,null,23,"Table C.7, row 3 (3x10)",9.4E-2,-1,0.43,1.2999999999999999E-2,0.7,0.99009900990098987,1]
["Target organism  /  Test medium:",null,null,null,null,24,"Table C.7, row 4 (3x10)",0.19,-0.72,0.31,4.5999999999999999E-2,0.78,1.8922806294881772E-2,2]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes",null,25,"Table C.7, row 5 (3x10)",0.19,-0.72,0.31,4.5999999999999999E-2,0.78,0.19167468711966884,1]
["d","w","n","x",null,26,"Table C.7, row 6 (3x10)",0.28999999999999998,-0.54,0.25,0.09,0.91,2.5452848995386579E-2,2]
[1,1,3,1,null,27,"Table C.7, row 7 (3x10)",0.2,-0.7,0.31,4.8000000000000001E-2,0.82,0.98901098901098838,1]
[0.1,1,3,0,null,28,"Table C.7, row 8 (3x10)",0.3,-0.52,0.25,9.4E-2,0.95,2.9909361852918526E-2,2]
[0.01,1,3,1,null,29,"Table C.7, row 9 (3x10)",0.3,-0.52,0.25,9.4E-2,0.95,0.30455078157779097,1]
[null,null,null,null,null,30,"Table C.7, row 10 (3x10)",0.4,-0.4,0.22,0.15,1.1000000000000001,1.2493873681329514E-2,2]
["Test series 5  /  Matrix 5   -   Designation:",null,"Table C.5, row 5 (3x3)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,3,1]
[0.1,1,3,1]
[0.01,1,3,0]
[]
["Test series 6  /  Matrix 6   -   Designation:",null,"Table C.5, row 6 (3x3)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,3,1]
[0.1,1,3,2]
[0.01,1,3,0]
[]
["Test series 7  /  Matrix 7   -   Designation:",null,"Table C.5, row 7 (3x3)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,3,2]
[0.1,1,3,0]
[0.01,1,3,0]
[]
["Test series 8  /  Matrix 8   -   Designation:",null,"Table C.5, row 8 (3x3)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,3,2]
[0.1,1,3,0]
[0.01,1,3,1]
[]
["Test series 9  /  Matrix 9   -   Designation:",null,"Table C.5, row 9 (3x3)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,3,2]
[0.1,1,3,1]
[0.01,1,3,0]
[]
["Test series 10  /  Matrix 10   -   Designation:",null,"Table C.5, row 10 (3x3)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,3,2]
[0.1,1,3,1]
[0.01,1,3,1]
[]
["Test series 11  /  Matrix 11   -   Designation:",null,"Table C.6, row 1 (3x5)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,5,0]
[0.1,1,5,0]
[0.01,1,5,0]
[]
["Test series 12  /  Matrix 12   -   Designation:",null,"Table C.6, row 2 (3x5)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,5,0]
[0.1,1,5,1]
[0.01,1,5,0]
[]
["Test series 13  /  Matrix 13   -   Designation:",null,"Table C.6, row 3 (3x5)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,5,1]
[0.1,1,5,0]
[0.01,1,5,0]
[]
["Test series 14  /  Matrix 14   -   Designation:",null,"Table C.6, row 4 (3x5)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,5,1]
[0.1,1,5,0]
[0.01,1,5,1]
[]
["Test series 15  /  Matrix 15   -   Designation:",null,"Table C.6, row 5 (3x5)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,5,1]
[0.1,1,5,1]
[0.01,1,5,0]
[]
["Test series 16  /  Matrix 16   -   Designation:",null,"Table C.6, row 6 (3x5)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,5,1]
[0.1,1,5,2]
[0.01,1,5,0]
[]
["Test series 17  /  Matrix 17   -   Designation:",null,"Table C.6, row 7 (3x5)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,5,2]
[0.1,1,5,0]
[0.01,1,5,0]
[]
["Test series 18  /  Matrix 18   -   Designation:",null,"Table C.6, row 8 (3x5)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,5,2]
[0.1,1,5,0]
[0.01,1,5,1]
[]
["Test series 19  /  Matrix 19   -   Designation:",null,"Table C.6, row 9 (3x5)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,5,2]
[0.1,1,5,1]
[0.01,1,5,0]
[]
["Test series 20  /  Matrix 20   -   Designation:",null,"Table C.6, row 10 (3x5)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,5,2]
[0.1,1,5,1]
[0.01,1,5,1]
[]
["Test series 21  /  Matrix 21   -   Designation:",null,"Table C.7, row 1 (3x10)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,10,0]
[0.1,1,10,0]
[0.01,1,10,0]
[]
["Test series 22  /  Matrix 22   -   Designation:",null,"Table C.7, row 2 (3x10)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,10,0]
[0.1,1,10,1]
[0.01,1,10,0]
[]
["Test series 23  /  Matrix 23   -   Designation:",null,"Table C.7, row 3 (3x10)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,10,1]
[0.1,1,10,0]
[0.01,1,10,0]
[]
["Test series 24  /  Matrix 24   -   Designation:",null,"Table C.7, row 4 (3x10)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,10,1]
[0.1,1,10,0]
[0.01,1,10,1]
[]
["Test series 25  /  Matrix 25   -   Designation:",null,"Table C.7, row 5 (3x10)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,10,1]
[0.1,1,10,1]
[0.01,1,10,0]
[]
["Test series 26  /  Matrix 26   -   Designation:",null,"Table C.7, row 6 (3x10)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,10,1]
[0.1,1,10,2]
[0.01,1,10,0]
[]
["Test series 27  /  Matrix 27   -   Designation:",null,"Table C.7, row 7 (3x10)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,10,2]
[0.1,1,10,0]
[0.01,1,10,0]
[]
["Test series 28  /  Matrix 28   -   Designation:",null,"Table C.7, row 8 (3x10)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,10,2]
[0.1,1,10,0]
[0.01,1,10,1]
[]
["Test series 29  /  Matrix 29   -   Designation:",null,"Table C.7, row 9 (3x10)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,10,2]
[0.1,1,10,1]
[0.01,1,10,0]
[]
["Test series 30  /  Matrix 30   -   Designation:",null,"Table C.7, row 10 (3x10)"]
["Target organism  /  Test medium:"]
["Dilution factor","Volume in ml or g","No. of tubes","No. of positive tubes"]
["d","w","n","x"]
[1,1,10,2]
[0.1,1,10,1]
[0.01,1,10,1]