{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","MegaCalc FREE-SO2"],"not_rendered":{"images":2,"defined_names":47},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":64,"n_cols":15,"rows_kept":64,"merged":[[7,2,7,12],[14,4,14,7],[57,2,58,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 mg/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 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":3},"Absorbance values blanks"]
[{"$nulls":3},"Blank Values","A1","A2","A3","DAbs\n(blank)"]
[{"$nulls":3},"Replicate 1"]
[{"$nulls":3},"Replicate 2"]
[]
[{"$nulls":3},"Absorbance values for a single point standard"]
[{"$nulls":3},"Single Point Standard","A1","A2","A2","DAbs\n(standard)"]
[{"$nulls":3},"Replicate 1"]
[{"$nulls":3},"Replicate 2"]
[]
[{"$nulls":4},{"$f":"IF(AND(ISNUMBER(J26),J26>0),J26/300,\"\")","v":""},"Factor [=(Absorbance for 100 mg/L FSO2 / 100 mg/L FSO2)]"]
[]
[{"$nulls":3},"Absorbance values for a calibration curve",{"$nulls":5},"Results"]
[{"$nulls":3},"Calibration Curve","FSO2 (mg/L)","A1","A2","A3",null,"DAbs\n(standard)"," M   (mg/L)/DA\n"]
[{"$nulls":3},"STD0 Rep. 1",{"v":0,"d":"0.00"}]
[{"$nulls":3},"STD0 Rep. 2"]
[{"$nulls":3},"STD1 Rep. 1",{"v":40,"d":"40.00"}]
[{"$nulls":3},"STD1 Rep. 2"]
[{"$nulls":3},"STD2 Rep. 1",{"v":80,"d":"80.00"}]
[{"$nulls":3},"STD2 Rep. 2"]
[{"$nulls":3},"STD3 Rep. 1",{"v":160,"d":"160.00"}]
[{"$nulls":3},"STD3 Rep. 2"]
[{"$nulls":3},"STD4 Rep. 1",{"v":320,"d":"320.00"}]
[{"$nulls":3},"STD4 Rep. 2"]
[{"$nulls":3},"STD5 Rep. 1",{"v":400,"d":"400.00"},{"$nulls":7},"Mean M"]
[{"$nulls":3},"STD5 Rep. 2"]
[]
[{"$nulls":3},"Sample absorbance values",{"$nulls":5},"Results"]
[{"$nulls":3},"Sample identifier","A1","A2","A3","Dilution \n(-fold)",null,"  DAbs\n(FSO2)","FSO2\n(mg/L)",null,"Sample\n(g/L)","FSO2\n(g/100g)"]
[null,null,1,{"$nulls":4},{"v":1,"d":"1.0"}]
[null,null,2,{"$nulls":4},{"v":1,"d":"1.0"}]
[null,null,3,{"$nulls":4},{"v":1,"d":"1.0"}]
{"$rows_empty":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":6},"www.megazyme.com"]
[]
[null,null,"If you have specific questions, please contact us directly:"]
[null,null,"Technical Support:",{"$nulls":6},"Megazyme Knowledge Base"]
[null,null,"Customer Support and Sales Information:",{"$nulls":6},"Customer Support"]
[null,null,"General Information:",{"$nulls":6},"info@megazyme.com"]
[{"$nulls":14},"K-FSULPH 09/19"]

{"sheet":"MegaCalc FREE-SO2","index":1,"n_rows":75,"n_cols":20,"rows_kept":75,"merged":[[3,4,3,6],[6,12,6,17],[20,4,21,4],[22,4,23,4],[24,4,25,4],[26,4,27,4],[28,4,29,4],[30,4,31,4]]}
[]
[]
[]
[{"$nulls":3},"Sample details"]
[]
[{"$nulls":3},"Absorbance values blanks"]
[{"$nulls":3},"Blank Values","A1","A2","A3","  DAbs\n(blank)",{"$nulls":4},"Use either the single point standard\nor the calibration curve"]
[{"$nulls":3},"Replicate 1",{"$nulls":3},{"$f":"I10","v":""},{"$f":"IF(OR(ISBLANK(E8),ISBLANK(F8)),\"\",(F8-E8)-(G8-F8))","v":""}]
[{"$nulls":3},"Replicate 2",{"$nulls":4},{"$f":"IF(OR(ISBLANK(E9),ISBLANK(F9)),\"\",(F9-E9)-(G9-F9))","v":""}]
[{"$nulls":8},{"$f":"IF(COUNT(I8,I9)=0,\"\",AVERAGE(I8,I9))","v":""}]
[]
[{"$nulls":3},"Absorbance values for a single point standard"]
[{"$nulls":3},"Single Point Standard","A1","A2","A3","  DAbs\n(standard)"]
[{"$nulls":3},"Replicate 1",{"$nulls":3},{"$f":"I16","v":""},{"$f":"IF(OR(ISBLANK(E14),ISBLANK(F14),ISBLANK(G14)),\"\",(F14-E14)-(G14-F14))","v":""}]
[{"$nulls":3},"Replicate 2",{"$nulls":4},{"$f":"IF(OR(ISBLANK(E15),ISBLANK(F15),ISBLANK(G15)),\"\",(F15-E15)-(G15-F15))","v":""}]
[{"$nulls":8},{"$f":"IF(COUNT(I14,I15)=0,\"\",AVERAGE(I14,I15))","v":""},{"$f":"IF(OR(I10=\"\",COUNT(I14,I15)=0),\"\",(AVERAGE(I14,I15)-I10)/100)","v":""}]
[{"$nulls":4},{"$f":"J16","v":""},"Factor [=(Absorbance for 100 mg/L FSO2 / 100 mg/L FSO2)]"]
[]
[{"$nulls":4},"Standard absorbance values",{"$nulls":7},"Results"]
[{"$nulls":3},"FSO2 Standard","FSO2 Std (mg/L)","A1","A2","A3","Absorbance Mean A655","Average DAbs ",null,"  Abs\n(standard)"," DAbs\n(standard)","[M](mg/L)/ΔA"," M   (mg/L)/ΔA"," M   (mg/L)/ΔA"]
[{"$nulls":3},"STD0 Rep. 1",{"v":0,"d":"0.0"},{"$nulls":3},{"$f":"IF(OR(ISBLANK(F21),ISBLANK(G21),ISBLANK(H21)),\"\",(G21-F21)-(H21-G21))","v":""},{"$f":"IF(COUNT(I21:I22)=0,\"\",(AVERAGE(I21:I22)))","v":""},null,{"$f":"IF(OR($I$10=\"\",COUNT(I21:I22)=0),\"\",(AVERAGE(I21:I22)-$I$10))","v":""},{"$f":"L21","v":""}]
[{"$nulls":3},"STD0 Rep. 2",{"$nulls":4},{"$f":"IF(OR(ISBLANK(F22),ISBLANK(G22),ISBLANK(H22)),\"\",(G22-F22)-(H22-G22))","v":""}]
[{"$nulls":3},"STD1 Rep. 1",{"v":25,"d":"25.0"},{"$nulls":3},"",{"$f":"IF(COUNT(I23:I24)=0,\"\",(AVERAGE(I23:I24)))","v":""},null,{"$f":"IF(OR($I$10=\"\",COUNT(I23:I24)=0),\"\",(AVERAGE(I23:I24)-$I$10))","v":""},{"$f":"L23","v":""},{"$f":"IF((OR($I$10=\"\",L23=\"\")),\"\",E23/L23)","v":""},null,{"$f":"N23","v":""}]
[{"$nulls":3},"STD1 Rep. 2",{"$nulls":4},""]
[{"$nulls":3},"STD2 Rep. 1",{"v":50,"d":"50.0"},{"$nulls":3},"",{"$f":"IF(COUNT(I25:I26)=0,\"\",(AVERAGE(I25:I26)))","v":""},null,{"$f":"IF(OR($I$10=\"\",COUNT(I25:I26)=0),\"\",(AVERAGE(I25:I26)-$I$10))","v":""},{"$f":"L25","v":""},{"$f":"IF((OR($I$10=\"\",L25=\"\")),\"\",E25/L25)","v":""},null,{"$f":"N25","v":""}]
[{"$nulls":3},"STD2 Rep. 2",{"$nulls":4},""]
[{"$nulls":3},"STD3 Rep. 1",{"v":100,"d":"100.0"},{"$nulls":3},"",{"$f":"IF(COUNT(I27:I28)=0,\"\",(AVERAGE(I27:I28)))","v":""},null,{"$f":"IF(OR($I$10=\"\",COUNT(I27:I28)=0),\"\",(AVERAGE(I27:I28)-$I$10))","v":""},{"$f":"L27","v":""},{"$f":"IF((OR($I$10=\"\",L27=\"\")),\"\",E27/L27)","v":""},null,{"$f":"N27","v":""}]
[{"$nulls":3},"STD3 Rep. 2",{"$nulls":4},"",{"$nulls":5},{"$f":"IF(OR(ISBLANK(Std_Concentration__mg_L),ISERROR(Change_abs_std),ISERROR([M]_microg_abs),Std_Concentration__mg_L=0),\"\",[M]_microg_abs)","v":""}]
[{"$nulls":3},"STD4 Rep. 1",{"v":125,"d":"125.0"},{"$nulls":3},"",{"$f":"IF(COUNT(I29:I30)=0,\"\",(AVERAGE(I29:I30)))","v":""},null,{"$f":"IF(OR($I$10=\"\",COUNT(I29:I30)=0),\"\",(AVERAGE(I29:I30)-$I$10))","v":""},{"$f":"L29","v":""},{"$f":"IF((OR($I$10=\"\",L29=\"\")),\"\",E29/L29)","v":""},{"$f":"IF(OR(ISBLANK(Std_Concentration__mg_L),ISERROR(Change_abs_std),ISERROR([M]_microg_abs),Std_Concentration__mg_L=0),\"\",[M]_microg_abs)","v":""},{"$f":"N29","v":""}]
[{"$nulls":3},"STD4 Rep. 2",{"$nulls":4},"",{"$nulls":5},{"$f":"IF(OR(ISBLANK(Std_Concentration__mg_L),ISERROR(Change_abs_std),ISERROR([M]_microg_abs),Std_Concentration__mg_L=0),\"\",[M]_microg_abs)","v":""}]
[{"$nulls":3},"STD5 Rep. 1",{"v":150,"d":"150.0"},{"$nulls":3},"",{"$f":"IF(COUNT(I31:I32)=0,\"\",(AVERAGE(I31:I32)))","v":""},null,{"$f":"IF(OR($I$10=\"\",COUNT(I31:I32)=0),\"\",(AVERAGE(I31:I32)-$I$10))","v":""},{"$f":"L31","v":""},{"$f":"IF((OR($I$10=\"\",L31=\"\")),\"\",E31/L31)","v":""},{"$f":"IF(OR(ISBLANK(Std_Concentration__mg_L),ISERROR(Change_abs_std),ISERROR([M]_microg_abs),Std_Concentration__mg_L=0),\"\",[M]_microg_abs)","v":""},{"$f":"N31","v":""},null,"Mean M","Mean M"]
[{"$nulls":3},"STD5 Rep. 2",{"$nulls":4},{"$f":"IF(OR(ISBLANK(F32),ISBLANK(G32),ISBLANK(H32)),\"\",(G32-F32)-(H32-G32))","v":""},{"$nulls":5},{"$f":"IF(OR(ISBLANK(Std_Concentration__mg_L),ISERROR(Change_abs_std),ISERROR([M]_microg_abs),Std_Concentration__mg_L=0),\"\",[M]_microg_abs)","v":""},null,null,{"$f":"S32","v":""},{"$f":"IF(COUNT(P23:P32)<3,\"\",AVERAGE(P23:P32))","v":""}]
[]
[{"$nulls":4},"Sample absorbance values",{"$nulls":7},"Results"]
[{"$nulls":3},"Sample identifier","A1","A2","A3","Dilution \n(-fold)",null,"  Abs\n(FSO2)",null,"Concentration (mg/L)"," DAbs\n(FSO2)","FSO2\n(mg/L)","Concentration  g/100g","FSO2\n(mg/L)",null,"Sample\n(g/L)","FSO2\n(g/100g)","FSO2\n(g/100g)"]
[null,null,1,{"$nulls":4},{"v":1,"d":"1.0"},null,{"$f":"IF(OR(ISBLANK(A1_Sample),ISBLANK(A2_sample),ISBLANK(A3_Sample)),\"\",(A2_sample-A1_Sample)-(A3_Sample-A2_sample))","v":""},null,{"$f":"IF(OR(Mean_M=\"\"),((Change_absorbance_TSO2-$I$10)/FSOSTD)*Dilution____fold,(Change_absorbance_TSO2-$I$10)*Dilution____fold*Mean_M)","v":{"$error":"#VALUE!"}},{"$f":"J36","v":""},{"$f":"IF(OR(ISERROR(Concentration__mg_L),Change_absorbance_TSO2=\"\",ISBLANK(Dilution____fold),Dilution____fold=0),\"\",Concentration__mg_L)","v":""},{"$f":"(100/Concentration__gL)*(Concentration__mg_L_TSO2/1000)","v":{"$error":"#DIV/0!"}},{"$f":"N36","v":""},null,null,{"$f":"IF(OR(Concentration__mg_L_TSO2=\"\",ISBLANK(Concentration__gL),ISERROR(Concentration_g_100g_TSO2)),\"\",Concentration_g_100g_TSO2)","v":""},{"$f":"S36","v":""}]
[null,null,2,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},{"$f":"J37","v":""},{"$f":"IF(OR(ISERROR(Concentration__mg_L),Change_absorbance_TSO2=\"\",ISBLANK(Dilution____fold),Dilution____fold=0),\"\",Concentration__mg_L)","v":""},{"$f":"(100/Concentration__gL)*(Concentration__mg_L_TSO2/1000)","v":{"$error":"#DIV/0!"}},{"$f":"N37","v":""},null,null,"",""]
[null,null,3,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},{"$f":"J38","v":""},"",{"$f":"(100/Concentration__gL)*(Concentration__mg_L_TSO2/1000)","v":{"$error":"#DIV/0!"}},"",null,null,"",""]
[null,null,4,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,5,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,6,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,7,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,8,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,9,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,10,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,11,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,12,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,13,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,14,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,15,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,16,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,17,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,18,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,19,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,20,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,21,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,22,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,23,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,24,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,25,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,26,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,27,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,28,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,29,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,30,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,31,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,32,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,33,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,34,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,35,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,36,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,37,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,38,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,39,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]
[null,null,40,{"$nulls":4},{"v":1,"d":"1.0"},null,"",null,{"$error":"#VALUE!"},"","",{"$error":"#DIV/0!"},"",null,null,"",""]