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

{"sheet":"Instructions","index":0,"n_rows":50,"n_cols":13,"rows_kept":50,"merged":[[7,2,7,12],[14,4,14,5],[16,4,16,6],[20,4,20,5],[20,11,20,12],[21,11,21,12],[22,11,22,12],[44,2,44,6]]}
[]
[]
[]
[]
[]
[]
[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 from raw absorbance data. The equations used here apply to Azo-Xylan (Birchwood) Lot. 30601."]
[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},"Source of Xylanase","Trichoderma longibrachiatum; pI 9.0",{"$nulls":3},"= 97.7 x Absorbance_Squared + 178 x Absorbance + 3.1"]
[]
[{"$nulls":3},"Blank Absorbance",{"$nulls":4},"Results"]
[]
[{"$nulls":3},"Sample identifier","Absorbance values at 590 nm",null,"Average sample minus blank",null,"Xylanase mU/assay \n(i.e. per 0.5 mL)","Extraction volume \n(mL/g or mL/mL)","Further dilution \n(-fold)","Xylanase (U/mL or U/g of original preparation)"]
[{"$nulls":4},1,2]
[{"$nulls":9},50,1]
{"$rows_empty":9}
[{"$nulls":9}," "]
{"$rows_empty":9}
[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":12},"S-AXBP/L 09/19"]

{"sheet":"MegaCalc","index":1,"n_rows":31,"n_cols":18,"rows_kept":31,"merged":[[3,5,3,6],[5,5,5,6],[5,13,5,17],[9,5,9,6]]}
[]
[]
[]
[{"$nulls":4},"Sample details",{"$nulls":8},"Equation"]
[]
[{"$f":"Equations!E4","v":"Humicola insolens"},{"$nulls":3},"Source of Xylanase","Trichoderma longibrachiatum; pI 9.0",{"$nulls":7},{"$f":"VLOOKUP(F6,Equations!E4:F6,2,FALSE)","v":"= 97.7 x Absorbance_Squared + 178 x Absorbance + 3.1"}]
[{"$f":"Equations!E5","v":"Trichoderma longibrachiatum; pI 9.0"}]
[{"$f":"Equations!E6","v":"Aspergillus niger"},{"$nulls":3},"Blank Absorbance"]
[{"$nulls":13},"Results"]
[{"$nulls":4},"Sample identifier","Absorbance values at 590 nm",null,"Average sample absorbance minus blank absorbance","Average sample absorbance minus blank absorbance","Number_1","Number_2","Number_3","Xylanase mU/assay (i.e. per 0.5 mL)","Xylanase mU/assay \n(i.e. per 0.5 mL)","Extraction volume \n(mL/g or mL/mL)","Further dilution \n(-fold)","Xylanase (U/mL or U/g of original preparation)","Xylanase (U/mL or U/g of original preparation)"]
[{"$nulls":5},1,2]
[{"$nulls":3},1,{"$nulls":3},{"$f":"IF(COUNT(F12,G12)=0,0,AVERAGE(F12,G12)-Blank)","v":{"v":0,"d":"0.0000"}},{"$f":"IF(AND(ISNUMBER(Blank),OR(ISNUMBER(Sample_1),ISNUMBER(Sample_2))),Absorbance,\"\")","v":""},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"$f":"Number_1*Absorbance^2+Number_2*Absorbance+Number_3","v":{"v":3.1,"d":"3.1000"}},{"$f":"IF(AND(ISNUMBER(Blank),OR(ISNUMBER(Sample_1),ISNUMBER(Sample_2))),mU_assay,\"\")","v":""},50,1,{"$f":"mU_assay*Extract_vol*Dilution*2*1/1000","v":{"v":0.31,"d":"0.3100"}},{"$f":"IF(AND(ISNUMBER(N12),ISNUMBER(Extract_vol),ISNUMBER(Dilution)),Units_g_mL,\"\")","v":""}]
[{"$nulls":3},2,{"$nulls":3},{"$f":"IF(COUNT(F13,G13)=0,0,AVERAGE(F13,G13)-Blank)","v":{"v":0,"d":"0.0000"}},{"$f":"IF(AND(ISNUMBER(Blank),OR(ISNUMBER(Sample_1),ISNUMBER(Sample_2))),Absorbance,\"\")","v":""},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"$f":"Number_1*Absorbance^2+Number_2*Absorbance+Number_3","v":{"v":3.1,"d":"3.1000"}},{"$f":"IF(AND(ISNUMBER(Blank),OR(ISNUMBER(Sample_1),ISNUMBER(Sample_2))),mU_assay,\"\")","v":""},50,1,{"v":0.31,"d":"0.3100"},{"$f":"IF(AND(ISNUMBER(N13),ISNUMBER(Extract_vol),ISNUMBER(Dilution)),Units_g_mL,\"\")","v":""}]
[{"$nulls":3},3,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]
[{"$nulls":3},4,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]
[{"$nulls":3},5,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]
[{"$nulls":3},6,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]
[{"$nulls":3},7,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]
[{"$nulls":3},8,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]
[{"$nulls":3},9,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]
[{"$nulls":3},10,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]
[{"$nulls":3},11,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]
[{"$nulls":3},12,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]
[{"$nulls":3},13,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]
[{"$nulls":3},14,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]
[{"$nulls":3},15,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]
[{"$nulls":3},16,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]
[{"$nulls":3},17,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]
[{"$nulls":3},18,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]
[{"$nulls":3},19,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]
[{"$nulls":3},20,{"$nulls":3},{"v":0,"d":"0.0000"},"",{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,3,FALSE)","v":{"v":97.7,"d":"97.7000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,4,FALSE)","v":{"v":178,"d":"178.0000"}},{"$f":"VLOOKUP($F$6,Equations!$E$4:$I$6,5,FALSE)","v":{"v":3.1,"d":"3.1000"}},{"v":3.1,"d":"3.1000"},"",50,1,{"v":0.31,"d":"0.3100"},""]

{"sheet":"Equations","index":2,"n_rows":6,"n_cols":9,"rows_kept":6}
[]
[]
[{"$nulls":3},"Choice","Source","Equation","Number 1","Number 2","Number 3"]
[{"$nulls":3},1,"Humicola insolens","= 82.4 x Absorbance_Squared + 166 x Absorbance + 7.7",82.4,{"v":166,"d":"166.0"},7.7]
[{"$nulls":3},2,"Trichoderma longibrachiatum; pI 9.0","= 97.7 x Absorbance_Squared + 178 x Absorbance + 3.1",97.7,{"v":178,"d":"178.0"},3.1]
[{"$nulls":3},3,"Aspergillus niger","= 66.6 x Absorbance_Squared + 105 x Absorbance + 3.9",66.6,{"v":105,"d":"105.0"},3.9]