{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["ToolBar","Field","ControlSheet","Master","Property","Condition","Data Entry Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":26,"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":"ToolBar","index":0,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Utility","Menu Item","SubMenu Item","OnAction Proc","Procedure","In Workbook"]
["Sheet","&details references",null,"Module1.details","ActivateSheet","ThisWorkbook"]
["Sheet","&syntax check of selection",null,"Module1.regionCheck","ActivateSheet","ThisWorkbook"]
["Sheet","&index file creation from selection",null,"Module1.createIndex","ActivateSheet","ThisWorkbook"]
["Sheet","&calculate tObs and logcVar",null,"Module2.collectCurves","ActivateSheet","ThisWorkbook"]
["Sheet","&replace curves given in strings by curvenames",null,"Module1.strings_To_curves","ActivateSheet","ThisWorkbook"]
["Sheet","&replace curvenames by values in strings",null,"Module1.curves_To_strings","ActivateSheet","ThisWorkbook"]
["Sheet","&compare curve with prediction",null,"Module1.sampleCurve","ActivateSheet","ThisWorkbook"]
["Sheet","&validate growth rates",null,"Module1.validate","ActivateSheet","ThisWorkbook"]

{"sheet":"Field","index":1,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["field","definition","unit","default value","possible values","syntax","sheet, csv; lower bound, first item of list"]
["key","identification code (key) of the record"]
["organism","name of organism",null,null,"!organism","TABLE","SHEET","ORGANISM"]
["specification","uncategorised specific name / feature of the organism(s) / environment"]
["source","origin of information",null,null,"!source","TABLE","SHEET","SOURCE"]
["details","other details (materials & methods)",null,null,"!details","TABLE","SHEET","DETAILS"]
["b_f","category of medium / food",null,null,"!b_f","TABLE","SHEET","B_F"]
["meas_method","method to measure bacterial response",null,null,"!meas_method","TABLE","SHEET","MEAS_METHOD"]
["condition","condition of media or food ",null,null,"!condition","TABLE","SHEET","CONDITION"]
["temp","temperature","C",20,"[-80, 150]","INTERVAL",-80,150]
["pH","pH","-",7,"[0.001, 14]","INTERVAL",1E-3,14]
["aw","water activity (default: set by NaCl) ","-",0.997,"[0, 1]","INTERVAL",0,1]
["property","possible special property of the organism",null,null,"!property","TABLE","SHEET","PROPERTY"]
["assumed","assumed/calculated factors"]
["tObs","time interval of observation","h",null,"[0,24000]","INTERVAL",0,24000]
["logc","log10 of cell concentration","log10 cell/ml in liquid and log10 cell/g in solid sample",null,"[-5,14]","INTERVAL",-5,14]
["logcVar","variation of log10 cell concentration during tObs","log10 cfu/ml",null,"[-12,12]","INTERVAL",-12,12]
["spec_rate","specific growth/death rate","1/h",null,"[-40000,7]","INTERVAL",-40000,7]
["comment","other details on the environment"]
["in_on","specification of food/media."]
["linkID","part of linked records on on co-culture responses "]
["logc0","log10 of initial cell concentration","log10 cell/ml in liquid and log10 cell/g in solid sample",null,"[-5,14]","INTERVAL",-5,14]
[]
["year","year of data submission"]
["prob_g","probability of growth/ fraction of survivors","-",1,"[0,1]","INTERVAL",0,1]

{"sheet":"ControlSheet","index":2,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[null,"mCode","sep","yLow","yUp",null,null,"Ribbon pointer"]
[null,2,1,0,9999,null,null,0]

{"sheet":"Master","index":3,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Source of the data","Species","Species characteristic","Organism pre-treatment, if any","Experimental matrix","Matrix characteristic","Experimental protocol","Measurement method","Temperature","pH","Water activity (aw) or NaCl (%)","Kinetic data","Comment"]
["Mohsina, K. and D.W. Parveen. 2014. Validation of \nmathematical models for \nBacillus cereus growth in raw spinach. Journal of Food Protection. 104:1110–1115.","Bacillus cereus","Strain(s): KM100","pre-lactic","fresh spinach","lactic acid - 400 ppm\nraw","Inoculum: Frozen stock cultures were maintained at -80°C in brain heart infusion (BHI) broth and 30% glycerol, and then resuscitated on BHI agar and incubated at 30°C for 24 hours. A single colony was growrn in 100 ml of BHI broth and incubated at 30°C for 17 hours. ","Colony counts","5°C and 10°C",5.5,0.99099999999999999,"See \"Data Entry Sheet\"","spinach variety was 'Savoy'"]
["below is an example if the data have not been published",null,null,null,null,null,"Sample preparation: Raw spinach was placed in stomacher bags, inoculated with B. cereus, and then incubated at the specified temperature.",null,"Let us know if the recorded temperature  was dynamic instead of static","Let us know if the recorded pH was dynamic instead of static","Let us know if the recorded water activity was dynamic instead of static"]
["Moshina, K. and D.W. Parveen. 2014. Institute of Food Studies, Cambridge UK",null,null,null,null,null,"Procedure: The study was performed at 5 and 10C. At each time point, two bags of inoculated spinach were removed from the incubator, stomached for 2 minutes, and then diluted in peptone broth. Next, 1 ml of the diluted sample was plated in duplicate on BHI agar. Plates were incubated at 30°C for 48 hours and the colonies were counted and reported in log10 CFU/ml. Each experiment was conducted in 2 trials and 2 replicates per trial."]

{"sheet":"Property","index":4,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["property","definition"]
["inoculated with exponential cells","Inoculated with cells from the exponential phase of growth"]
["stationary phase inoculated","Inoculated from stationary phase"]
["pre-heated","Cells heat-treated before sample was inoculated"]
["ATR-induced","Acid tolerance response (ATR) induced before sample was inlculated"]
["injured","Cells were Injured by some type of pre-treatment"]
["pre-irradiated","Cells irradiated before sample was inoculated"]
["mixed strains","Sample inoculated with mixed strains of the same species"]
["mixed species","Sample inoculated with mixed species"]
["indigenous","Non-inoculated organisms (endogeneous/background) enumerated in sample"]
["spore","Sample inoculated with spores"]
["pre-aw","Cells pretreated with specific water activity (aw) before sample was inoculated"]
["pre-pH","Cells pretreated with specific pH before sample was inoculated"]
["pre-temp","Cells pretreated at a specific temperature before sample was inoculated"]
["pre-NaCl","Cells pretreated with a specific NaCl concentration before sample was inoculated"]
["pre-dried","Cells dried before sample was inoculated"]
["pre-lactic","Cells pretreated with a specific lactic acid (possibly as salt) concentration before sample was inoculated"]
["pre-diacetic","Cells pretreated with a specific diacetic acid (possibly as salt) concentration before sample was inoculated"]
["pre-pressure","Cells pretreated with a specific pressure before the sample was inoculated"]
["pre-citric","Cells pretreated with a specific citric acid (possibly as salt) concentration before the sample was inoculated"]
["pre-acetic","Cells pretreated with a specific acetic acid (possibly as salt) concentration before the sample was inoculated"]
[]
["not listed above?","add if not listed above"]

{"sheet":"Condition","index":5,"n_rows":65,"n_cols":3,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["condition","definition","unit"]
["acetic acid","Acetic acid (possibly as salt) in the environment","ppm"]
["ALTA","ALTA fermentation product in the environment","%"]
["anaerobic","Anaerobic environment","NULL"]
["apple polyphenol","In presence of apple polyphenol","%"]
["apple_polyphenol","In presence of apple polyphenol","%"]
["argon","Argon in the environment","ppm"]
["ascorbic acid","Ascorbic acid (possibly as salt) in the environment","ppm"]
["benzoic acid","Benzoic acid (possibly as salt) in the environment","ppm"]
["betaine","In presence of betaine","%"]
["carvacrol","In presence of carvacrol","%"]
["chitosan","In presence of chitosan","%"]
["cinnamaldehyde","In presence of cinnamaldehyde","%"]
["citric acid","Citric acid (possibly as salt) in the environment","%"]
["ClO2","Chlorine dioxide in the environment","%"]
["CO2","Carbon dioxide in the environment","ppm"]
["co-culture","Other species also deliberately inoculated (but only one organism enumerated)","ppm"]
["cured","Cured by addition of a preservative","%"]
["cut","Sample cut, minced, chopped, ground, etc","NULL"]
["diacetic acid","In presence of diacetic acid (possibly as salt)","NULL"]
["dried","Dried food","NULL"]
["EDTA","Ethylenenediaminetetraacetic acid  in the environment","ppm"]
["erythorbate","Sodium erythrobate in the environment","ppm"]
["ethanol","Ethanol  in the environment","NULL"]
["fat","Fat in the environment","%"]
["frozen","Sample was frozen","%"]
["fructose","Fructose in the environment","%"]
["garlic","Garlic in the environment","%"]
["glucose","Glucose in the environment","NULL"]
["glycerol","Glycerol in the environment","%"]
["green tea leaf","In presence of green tea leaf","%"]
["green tea polyphenol","In presence of green tea polyphenol","%"]
["HCl","Hydrochloric acid in the environment","g/l"]
["heated","Inoculation in/on previously heated (cooked, baked, pasteurized, etc) but not sterilised food/medium","NULL"]
["irradiated","In an environment that has been irradiated","kGy"]
["irradiation","Irradiation at constant rate during the observation period","kGy/h"]
["kcl","Potassium chloride in the environment","%"]
["lactic acid","Lactic acid (possibly as salt) in the environment","ppm"]
["lauricidin","Lauricidin in the environment","ppm"]
["malic acid","Malic acid (possibly as salt) in the environment","ppm"]
["modified atmosphere","Modified atmosphere environment","NULL"]
["moisture","Moisture in the environment","%"]
["N2","Nitrogen in the environment","%"]
["NaCl","Sodium chloride in the environment","%"]
["nitrite","Sodium or potassium nitrite in the environment","ppm"]
["non-sterile","Indigenous flora (background) in the environment, but not counted","NULL"]
["O2","Oxygen (aerobic condition) in the environment","%"]
["oregano","Oregano essential oil in the environment","MPA"]
["potassium_lactate","Potassium lactate (added as salt)","ppm"]
["prepared_food","Prepared food"]
["pressure","Pressure controlled","ppm"]
["propionic acid","Propionic acid (possibly as salt) in the environment","NULL"]
["protein","Protein in the environment","%"]
["raw","Raw sample","NULL"]
["rosemary","Rosemary in the environment","%"]
["shaken","Shaken (agitated, stirred)","NULL"]
["smoked","Smoked food","ppm"]
["sorbic acid","Sorbic acid (possibly as salt) in the environment","NULL"]
["sterile","Sterilised before inoculation","%"]
["sucrose","Sucrose in the environment","%"]
["sugar","Sugar in the environment","%"]
["thymol","Thymol essential oil component in the environment","NULL"]
["vacuum-packed","Vacuum-packed"]
[]
["not listed above?","add if not listed above","%"]

{"sheet":"Data Entry Sheet","index":6,"n_rows":82,"n_cols":9,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
["record code","time (hours)","count (log10 CFU)",null,"these 3 columns are only used for dynamic conditions"]
[null,null,null,null,"temperature","pH","water activity"]
[null,null,null,null,"If temperature, pH or water activity were measured at all or some of the time points, then enter the data in these columns"]
["Bc_Sp_5C_T1_R1",0,3.4448251995097476]
["Bc_Sp_5C_T1_R1",9,3.6857417386022635]
["Bc_Sp_5C_T1_R1",24,4.2988530764097064]
["Bc_Sp_5C_T1_R1",33,4.9518230353159121]
["Bc_Sp_5C_T1_R1",48,5.8633228601204559]
["Bc_Sp_5C_T1_R1",57,6.5250448070368456]
["Bc_Sp_5C_T1_R1",81,7.8450980400142569]
["Bc_Sp_5C_T1_R1",104,8.672097857935718]
["Bc_Sp_5C_T1_R1",128,8.7781512503836439]
["Bc_Sp_5C_T1_R1",170,8.7075701760979367]
[]
["Bc_Sp_5C_T1_R2",0,3.3364597338485296,null,null,null,null,"A record code must be unique for each experimental record (data set)"]
["Bc_Sp_5C_T1_R2",9,3.4005379893919461]
["Bc_Sp_5C_T1_R2",23,4.075546961392531,null,null,null,null,"Below is an example of how a record code could be created, although almost any format can be used."]
["Bc_Sp_5C_T1_R2",33,4.4842998393467859]
["Bc_Sp_5C_T1_R2",54,5.8095597146352675,null,null,null,null,"Bc =  Bacillus cereus"]
["Bc_Sp_5C_T1_R2",77,7.0881360887005513,null,null,null,null,"Sp = spinach"]
["Bc_Sp_5C_T1_R2",102,8.1702617153949575,null,null,null,null,"5C = temperature","10C = temperature"]
["Bc_Sp_5C_T1_R2",127,8.5910646070264995,null,null,null,null,"T1 = trial 1","T2 = trial 2"]
["Bc_Sp_5C_T1_R2",150,8.4022613824546806,null,null,null,null,"R1 = replicate 1","R2 = replicate 2"]
["Bc_Sp_5C_T1_R2",173,8.4289442900355738]
[]
["Bc_Sp_5C_T2_R1",0,3.419955748489758]
["Bc_Sp_5C_T2_R1",21,4.8356905714924254]
["Bc_Sp_5C_T2_R1",30,5.8388490907372557]
["Bc_Sp_5C_T2_R1",45,7.1003705451175625]
["Bc_Sp_5C_T2_R1",53,7.7283537820212285]
["Bc_Sp_5C_T2_R1",68,8.7817553746524695]
["Bc_Sp_5C_T2_R1",77,8.8195439355418692]
["Bc_Sp_5C_T2_R1",92,8.8662873390841952]
[]
["Bc_Sp_5C_T2_R2",0,3.4369573306694496]
["Bc_Sp_5C_T2_R2",9,3.8356905714924254]
["Bc_Sp_5C_T2_R2",24,5.0881360887005513]
["Bc_Sp_5C_T2_R2",33,6.1003705451175625]
["Bc_Sp_5C_T2_R2",48,7.2174839442139067]
["Bc_Sp_5C_T2_R2",57,7.9566485792052033]
["Bc_Sp_5C_T2_R2",69,8.7817553746524695]
["Bc_Sp_5C_T2_R2",94,8.8095597146352684]
[]
["Bc_Sp_10C_T1_R1",0,3.7848251995097475]
["Bc_Sp_10C_T1_R1",9,4.0257417386022638]
["Bc_Sp_10C_T1_R1",24,4.6388530764097062]
["Bc_Sp_10C_T1_R1",33,5.2918230353159119]
["Bc_Sp_10C_T1_R1",48,6.2033228601204558]
["Bc_Sp_10C_T1_R1",57,6.8650448070368455]
["Bc_Sp_10C_T1_R1",81,8.1850980400142568]
["Bc_Sp_10C_T1_R1",104,9.0120978579357178]
["Bc_Sp_10C_T1_R1",128,9.1181512503836437]
["Bc_Sp_10C_T1_R1",170,9.0475701760979366]
[]
["Bc_Sp_10C_T1_R2",0,3.6764597338485294]
["Bc_Sp_10C_T1_R2",9,3.7405379893919459]
["Bc_Sp_10C_T1_R2",23,4.4155469613925309]
["Bc_Sp_10C_T1_R2",33,4.8242998393467857]
["Bc_Sp_10C_T1_R2",54,6.1495597146352674]
["Bc_Sp_10C_T1_R2",77,7.4281360887005512]
["Bc_Sp_10C_T1_R2",102,8.5102617153949573]
["Bc_Sp_10C_T1_R2",127,8.9310646070264994]
["Bc_Sp_10C_T1_R2",150,8.7422613824546804]
["Bc_Sp_10C_T1_R2",173,8.7689442900355736]
[]
["Bc_Sp_10C_T2_R1",0,3.7599557484897579]
["Bc_Sp_10C_T2_R1",21,5.1756905714924253]
["Bc_Sp_10C_T2_R1",30,6.1788490907372555]
["Bc_Sp_10C_T2_R1",45,7.4403705451175624]
["Bc_Sp_10C_T2_R1",53,8.0683537820212283]
["Bc_Sp_10C_T2_R1",68,9.1217553746524693]
["Bc_Sp_10C_T2_R1",77,9.1595439355418691]
["Bc_Sp_10C_T2_R1",92,9.2062873390841951]
[]
["Bc_Sp_10C_T2_R2",0,3.7769573306694495]
["Bc_Sp_10C_T2_R2",9,4.1756905714924253]
["Bc_Sp_10C_T2_R2",24,5.4281360887005512]
["Bc_Sp_10C_T2_R2",33,6.4403705451175624]
["Bc_Sp_10C_T2_R2",48,7.5574839442139066]
["Bc_Sp_10C_T2_R2",57,8.296648579205204]
["Bc_Sp_10C_T2_R2",69,9.1217553746524693]
["Bc_Sp_10C_T2_R2",94,9.1495597146352683]