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

{"sheet":"Instructions","index":0,"n_rows":39,"n_cols":16,"rows_kept":39,"merged":[[7,2,7,15],[18,4,18,5],[33,2,33,7]]}
[]
[]
[]
[]
[]
[]
[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 \nconcentration of analyte 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":4},"Reaction blank absorbance"]
[{"$nulls":4},"Replicate 1","Replicate 2","Average"]
[{"$nulls":6},""]
[{"$nulls":11},"Results",null,"Solid samples"]
[{"$nulls":3},"Sample identifier","Sample absorbance values",null,"Average sample absorbance minus blank absorbance","Sample volume (mL)","Total volume in assay tube (mL)","Incubation time (min)","Dilution \n(-fold)","GE (Units/mL)",null,"Sample weight \n(grams)","Extract volume (mL)","GE (Units/g)"]
[{"$nulls":4},"Replicate 1","Replicate 2"]
[{"$nulls":6},"",0.05,1.6,10,20,"",null,0.5,10,""]
{"$rows_empty":7}
[{"$nulls":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":13},"K-GEUX3 01/20"]

{"sheet":"MegaCalc","index":1,"n_rows":53,"n_cols":19,"rows_kept":53,"merged":[[4,4,4,6],[11,4,11,5]]}
[]
[]
[]
[]
[{"$nulls":3},"Sample details"]
[]
[{"$nulls":4},"Reaction blank absorbance"]
[{"$nulls":4},"Replicate 1","Replicate 2","Average","Average"]
[{"$nulls":6},{"$f":"AVERAGE(E9:F9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(ISNUMBER(Replicate_1),ISNUMBER(Replicate_2)),Replicate_average,\"\")","v":""}]
[]
[{"$nulls":13},"Liquid samples",{"$nulls":4},"Solid samples"]
[{"$nulls":3},"Sample identifier","Sample Absorbance values",null,"Average","Average Sample absorbance minus Blank absorbance","Sample volume (mL)","Total volume in assay (mL)","Incubation time (min)","Dilution \n(-fold)","GE (Units/mL)","GE (Units/mL)",null,"Sample weight \n(grams)","Extract volume (mL)","GE (Units/g)","GE (Units/g)"]
[{"$nulls":4},"Replicate 1","Replicate 2"]
[null,null,1,{"$nulls":3},{"$f":"IF(OR(ISBLANK(E14),ISBLANK(F14),$H$9=\"\"),\"\",(AVERAGE(E14:F14)-Replicate_average))","v":""},{"$f":"G14","v":""},0.05,1.6,10,20,{"$f":"IF(OR(ISBLANK(Sample_volume_mL),ISBLANK(Total_volume_assay_mL),ISBLANK(Incubation_time_min),ISBLANK(Dilution_fold),Average_absorbance=\"\",Dilution_fold=0),\"\",( Average_absorbance*1/Incubation_time_min*Total_volume_assay_mL/Sample_volume_mL*1/18.1*Dilution_fold))","v":""},{"$f":"M14","v":""},null,0.5,10,{"$f":"IF(OR(ISBLANK(Sample_weight_g),ISBLANK(Extract_volume_mL),Analyte_Units_L=\"\"),\"\",(Analyte_Units_L*1/Sample_weight_g*Extract_volume_mL))","v":""},{"$f":"R14","v":""}]
[null,null,2,{"$nulls":3},{"$f":"IF(OR(ISBLANK(E15),ISBLANK(F15),$H$9=\"\"),\"\",(AVERAGE(E15:F15)-Replicate_average))","v":""},{"$f":"IF(OR(ISNUMBER(Absorbance_A),ISNUMBER(Absorbance_B)),Average_absorbance,\"\")","v":""},0.05,1.6,10,20,{"$f":"IF(OR(ISBLANK(Sample_volume_mL),ISBLANK(Total_volume_assay_mL),ISBLANK(Incubation_time_min),ISBLANK(Dilution_fold),Average_absorbance=\"\",Dilution_fold=0),\"\",( Average_absorbance*1/Incubation_time_min*Total_volume_assay_mL/Sample_volume_mL*1/18.1*Dilution_fold))","v":""},{"$f":"IF(OR(ISNUMBER(Absorbance_A),ISNUMBER(Absorbance_B)),Analyte_Units_L,\"\")","v":""},null,0.5,10,"",{"$f":"IF(OR(ISNUMBER(Absorbance_A),ISNUMBER(Absorbance_B)),Analyte_Units_g,\"\")","v":""}]
[null,null,3,{"$nulls":3},"","",0.05,1.6,10,20,{"$f":"IF(OR(ISBLANK(Sample_volume_mL),ISBLANK(Total_volume_assay_mL),ISBLANK(Incubation_time_min),ISBLANK(Dilution_fold),Average_absorbance=\"\",Dilution_fold=0),\"\",( Average_absorbance*1/Incubation_time_min*Total_volume_assay_mL/Sample_volume_mL*1/18.1*Dilution_fold))","v":""},"",null,0.5,10,"",""]
[null,null,4,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,5,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,6,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,7,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,8,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,9,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,10,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,11,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,12,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,13,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,14,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,15,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,16,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,17,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,18,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,19,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,20,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,21,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,22,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,23,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,24,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,25,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,26,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,27,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,28,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,29,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,30,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,31,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,32,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,33,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,34,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,35,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,36,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,37,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,38,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,39,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]
[null,null,40,{"$nulls":3},"","",0.05,1.6,10,20,"","",null,0.5,10,"",""]