{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","MegaCalc","Creep Calculation"],"not_rendered":{"charts":1,"images":3,"defined_names":26,"comments":3},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":46,"n_cols":14,"rows_kept":46,"merged":[[7,2,7,12],[38,2,39,5]]}
[]
[]
[]
[]
[]
[]
[null,null,"Welcome to Megazyme "]
[null,null,"To further support you, our valued customer, we have developed the Megazyme Mega-CalcTM to assist you in calculating the concentration of analyte (as g/L or g/100 g) from raw absorbance data. "]
[null,null,"Instructions for Use of Mega-CalcTM"]
[null,null,"On the Mega-CalcTM page, fill in the oranges boxes and it will provide automatic results in the white boxes."]
[null,null,"To zoom up or down, ensure the Standard tool bar is showing (View > Toolbars) & select a value from the Zoom drop-down list."]
[]
[]
[{"$nulls":3},"Sample details"]
[{"$nulls":4},"Blank absorbance values"]
[{"$nulls":4},"A1","A2"]
[{"$nulls":3},1]
[{"$nulls":3},2]
[]
[{"$nulls":4},"Sample absorbance values",{"$nulls":5},"Results"]
[{"$nulls":3},"Sample identifier","A1","A2","A2 \ncreep corrected","Sample volume \n(mL)","Dilution \n(-fold)",null,"   Abs\n(D-Lactic Acid)","D-Lactic Acid\n(g/L)","Sample\n(g/L)","D-Lactic Acid (g/100g)"]
[{"$nulls":7},{"v":0.1,"d":"0.10"},1,null,"",null,null,""]
[{"$nulls":7},{"v":0.1,"d":"0.10"},1,null,"",null,null,""]
[{"$nulls":7},{"v":0.1,"d":"0.10"},1,null,"",null,null,""]
{"$rows_empty":10}
[{"$nulls":7}," "]
[]
[null,null,"Contact Us"]
[null,null,"Further Support "]
[null,null,"To obtain further information about the specific test, or indeed any of the Megazyme products, please consult our web site."]
[{"$nulls":7},"www.megazyme.com"]
[null,null,"If you have specific questions, please contact us directly:"]
[null,null,"Technical Support:",{"$nulls":4},"Megazyme Knowledge Base"]
[null,null,"Customer Support and Sales Information:",{"$nulls":4},"Customer Support"]
[null,null,"General Information:",{"$nulls":4},"info@megazyme.com"]
[]
[{"$nulls":13},"K-DATE 09/19"]

{"sheet":"MegaCalc","index":1,"n_rows":33,"n_cols":18,"rows_kept":33,"merged":[[3,4,3,5]]}
[]
[]
[]
[{"$nulls":3},"Sample details"]
[]
[{"$nulls":4},"Blank absorbance values"]
[{"$nulls":4},"A1","A2"]
[{"$nulls":3},1]
[{"$nulls":3},2]
[{"$nulls":4},{"$f":"IF(COUNT(E8:E9)=0,0,(IF(A1_blank_1=0,0.0000001,A1_blank_1)+IF(A1_blank_2=0,0.0000001,A1_blank_2))/COUNT(E8:E9))","v":{"v":0,"d":"0.0000"}},{"$f":"IF(COUNT(F8:F9)=0,0,(IF(A2_blank_1=0,0.0000001,A2_blank_1)+IF(A2_blank_2=0,0.0000001,A2_blank_2))/COUNT(F8:F9))","v":{"v":0,"d":"0.0000"}}]
[]
[{"$nulls":4},"Sample absorbance values",{"$nulls":6},"Results"]
[{"$nulls":3},"Sample identifier","A1","A2","A2 \nCreep corrected","Sample volume \n(mL)","Dilution \n(-fold)",null,"Change in absorbance","   Abs\n(D/L-Lactic Acid)","Concentration (ganalyte/Lsample)","D-Lactic Acid\n(g/L)",null,"Sample\n(g/L)","Concentration (ganalyte/ 100gsample)","D-Lactic Acid (g/100g)"]
[null,null,1,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E11),'Creep Calculation'!E11,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,{"$f":"(IF(ISNUMBER(G14),G14,A2_sample)-A1_sample)-(A2_blank_ave-A1_blank_ave)","v":0},{"$f":"IF(OR(ISBLANK(A1_sample),AND(ISBLANK(A2_sample),G14=\"\"),A1_blank_ave=0,A2_blank_ave=0),\"\",Change_absorbance)","v":""},{"$f":"0.03204*K14*Dilution/Sample_volume","v":0},{"$f":"IF(OR(ISBLANK(A1_sample),AND(ISBLANK(A2_sample),G14=\"\"),A1_blank_ave=0,A2_blank_ave=0),\"\",Concentration_gL)","v":""},null,null,{"$f":"Concentration_gL*100/Sample_con_gL","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(Concentration_gg),\"\",Concentration_gg)","v":""}]
[null,null,2,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E12),'Creep Calculation'!E12,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,{"$f":"(IF(ISNUMBER(G15),G15,A2_sample)-A1_sample)-(A2_blank_ave-A1_blank_ave)","v":0},{"$f":"IF(OR(ISBLANK(A1_sample),AND(ISBLANK(A2_sample),G15=\"\"),A1_blank_ave=0,A2_blank_ave=0),\"\",Change_absorbance)","v":""},{"$f":"0.03204*K15*Dilution/Sample_volume","v":0},{"$f":"IF(OR(ISBLANK(A1_sample),AND(ISBLANK(A2_sample),G15=\"\"),A1_blank_ave=0,A2_blank_ave=0),\"\",Concentration_gL)","v":""},null,null,{"$f":"Concentration_gL*100/Sample_con_gL","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(Concentration_gg),\"\",Concentration_gg)","v":""}]
[null,null,3,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E13),'Creep Calculation'!E13,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]
[null,null,4,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E14),'Creep Calculation'!E14,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]
[null,null,5,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E15),'Creep Calculation'!E15,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]
[null,null,6,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E16),'Creep Calculation'!E16,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]
[null,null,7,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E17),'Creep Calculation'!E17,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]
[null,null,8,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E18),'Creep Calculation'!E18,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]
[null,null,9,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E19),'Creep Calculation'!E19,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]
[null,null,10,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E20),'Creep Calculation'!E20,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]
[null,null,11,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E21),'Creep Calculation'!E21,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]
[null,null,12,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E22),'Creep Calculation'!E22,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]
[null,null,13,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E23),'Creep Calculation'!E23,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]
[null,null,14,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E24),'Creep Calculation'!E24,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]
[null,null,15,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E25),'Creep Calculation'!E25,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]
[null,null,16,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E26),'Creep Calculation'!E26,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]
[null,null,17,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E27),'Creep Calculation'!E27,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]
[null,null,18,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E28),'Creep Calculation'!E28,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]
[null,null,19,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E29),'Creep Calculation'!E29,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]
[null,null,20,{"$nulls":3},{"$f":"IF(ISNUMBER('Creep Calculation'!E30),'Creep Calculation'!E30,\"\")","v":""},{"v":0.1,"d":"0.10"},1,null,0,"",0,"",null,null,{"$error":"#DIV/0!"},""]

{"sheet":"Creep Calculation","index":2,"n_rows":37,"n_cols":19,"rows_kept":37,"merged":[[8,5,8,9],[8,12,8,15]]}
{"$rows_empty":7}
[{"$nulls":12},"Incubation time (min)"]
[{"$nulls":5},"Allows users to select 1 sample for the graph",{"$nulls":6},"These columns show",{"$nulls":3},"ABS, t=0"]
[{"$nulls":3},"Sample",0,"0",2,4,6,8,10,12,8,10,12,0,null,null,1]
[1,null,null,1,{"$f":"TREND($M11:$O11,$M$10:$O$10,$E$10)","v":{"$error":"#VALUE!"}},{"$f":"IF($S$10=D11,E11,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF($S$10=D11,TREND($M11:$O11,$M$10:$O$10,$G$10),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF($S$10=D11,TREND($M11:$O11,$M$10:$O$10,$H$10),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF($S$10=D11,TREND($M11:$O11,$M$10:$O$10,$I$10),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF($S$10=D11,M11,\"\")","v":{"v":0,"d":"0.0000"}},{"$f":"IF($S$10=D11,N11,\"\")","v":{"v":0,"d":"0.0000"}},{"$f":"IF($S$10=D11,O11,\"\")","v":{"v":0,"d":"0.0000"}},{"$nulls":3},{"$f":"IF(ISERROR(Creep_calculation),\"\",Creep_calculation)","v":""}]
[2,null,null,2,{"$error":"#VALUE!"},{"$f":"IF($S$10=D12,E12,\"\")","v":""},{"$f":"IF($S$10=D12,TREND($M12:$O12,$M$10:$O$10,$G$10),\"\")","v":""},{"$f":"IF($S$10=D12,TREND($M12:$O12,$M$10:$O$10,$H$10),\"\")","v":""},{"$f":"IF($S$10=D12,TREND($M12:$O12,$M$10:$O$10,$I$10),\"\")","v":""},{"$f":"IF($S$10=D12,M12,\"\")","v":""},{"$f":"IF($S$10=D12,N12,\"\")","v":""},{"$f":"IF($S$10=D12,O12,\"\")","v":""},{"$nulls":3},{"$f":"IF(ISERROR(Creep_calculation),\"\",Creep_calculation)","v":""}]
[3,null,null,3,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},""]
[4,null,null,4,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},""]
[5,null,null,5,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},""]
[6,null,null,6,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},""]
[7,null,null,7,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},""]
[8,null,null,8,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},""]
[9,null,null,9,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},""]
[10,null,null,10,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},""]
[11,null,null,11,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},""]
[12,null,null,12,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},""]
[13,null,null,13,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},""]
[14,null,null,14,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},""]
[15,null,null,15,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},"",{"$f":"((A2_sample-A0_sample)-(A1_sample-A0_sample)^2/(A2_sample-A0_sample))-((A2_blank_ave-A0_blank_ave)-(A1_blank_ave-A0_blank_ave)^2/(A2_blank_ave-A0_blank_ave))","v":{"$error":"#NAME?"}}]
[16,null,null,16,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},"",{"$error":"#NAME?"}]
[17,null,null,17,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},"",{"$error":"#NAME?"}]
[18,null,null,18,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},"",{"$error":"#NAME?"}]
[19,null,null,19,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},"",{"$error":"#NAME?"}]
[20,null,null,20,{"$error":"#VALUE!"},"","","","","","","",{"$nulls":3},"",{"$error":"#NAME?"}]
[{"$nulls":16},{"$error":"#NAME?"}]
[{"$nulls":16},{"$error":"#NAME?"}]
[{"$nulls":16},{"$error":"#NAME?"}]
[{"$nulls":16},{"$error":"#VALUE!"}]
[{"$nulls":16},{"$error":"#VALUE!"}]
[{"$nulls":16},{"$error":"#VALUE!"}]
[{"$nulls":16},{"$error":"#VALUE!"}]