{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","MegaCalc"],"not_rendered":{"images":2,"defined_names":20,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":45,"n_cols":14,"rows_kept":45,"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. Over the coming months, such calculators will be developed for each of the Megazyme test kits."]
[null,null,"Instructions for Use of Mega-CalcTM"]
[null,null,"On the Mega-CalcTM pages, fill in the orange 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","Sample volume \n(mL)","Dilution \n(-fold)",null,null,"   Abs\n(Total SO2)","Total SO2\n(g/L)","Sample\n(g/L)","Total SO2 (g/100g)"]
[{"$nulls":6},{"v":0.1,"d":"0.10"},1,null,null,"",null,null,""]
[{"$nulls":6},{"v":0.1,"d":"0.10"},1,null,null,"",null,null,""]
[{"$nulls":6},{"v":0.1,"d":"0.10"},1,null,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-ETSULPH 09/19"]

{"sheet":"MegaCalc","index":1,"n_rows":53,"n_cols":20,"rows_kept":53,"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":5},"Results"]
[{"$nulls":3},"Sample identifier","A1","A2","Sample volume \n(mL)","Dilution \n(-fold)",null,"Change in absorbance","   Abs\n","   Abs\n(Total SO2)","Total SO2\n(g/L)","Total SO2\n(g/L)","Total SO2\n(g/L)",null,"Sample\n(g/L)","Total SO2 (g/100g)","Total SO2 (g/100g)","Total SO2 (g/100g)"]
[null,null,1,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,{"$f":"(A1_sample-A2_sample)-(A1_blank_ave-A2_blank_ave)","v":0},{"$f":"IF(OR(ISBLANK(A1_sample),ISBLANK(A2_sample),A1_blank_ave=0,A2_blank_ave=0),\"\",Change_absorbance)","v":""},{"$f":"K14","v":""},{"$f":"0.03396*J14*Dilution/Sample_volume","v":0},{"$f":"IF(OR(ISBLANK(A1_sample),ISBLANK(A2_sample),A1_blank_ave=0,A2_blank_ave=0),\"\",Concentration_gL)","v":""},{"$f":"N14","v":""},null,null,{"$f":"Concentration_gL*100/Sample_con_gL","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(Concentration_gg),\"\",Concentration_gg)","v":""},{"$f":"S14","v":""}]
[null,null,2,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"",{"$f":"K15","v":""},0,"",{"$f":"N15","v":""},null,null,{"$error":"#DIV/0!"},"",{"$f":"S15","v":""}]
[null,null,3,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,4,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,5,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,6,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,7,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,8,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,9,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,10,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,11,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,12,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,13,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,14,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,15,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,16,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,17,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,18,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,19,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,20,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,21,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,22,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,23,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,24,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,25,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,26,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,27,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,28,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,29,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,30,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,31,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,32,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,33,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,34,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,35,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,36,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,37,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,38,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,39,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]
[null,null,40,{"$nulls":3},{"v":0.1,"d":"0.10"},1,null,0,"","",0,"","",null,null,{"$error":"#DIV/0!"},"",""]