{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Notes on Use","Maturity","WhiteWine","RedWine","TA","SO2","SO2titr","FAN","NH4","Glu-Fru","Malic acid","Acetic acid","K+","Colour-Red grapes","Red Flow chart f4","Colour-RedWine","PhenolicsWhite","Total phenols","Tannins","Ebulliometry","Sheet14"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":13,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Notes on Use","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Data entry - not protected (however range not checked)."]
[null,null,"Contains an expression - protected but visible."]
[null,null,"Heading - protected"]
[null,null,"Heading - protected"]

{"sheet":"Maturity","index":1,"n_rows":28,"n_cols":23,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"SAMPLES"]
["Information","Value","Units",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,"Person"]
[null,"Date"]
[null,"Cultivar"]
[null,"Block/Unit"]
["Sample"]
[null,"Bunches (y) or berries (n)?","y/n","y"]
[null,"Weight","kg",16]
[null,"Sample Bunch count","count",25]
[null,"Bunch wt","g",{"$f":"IF(OR(D8=\"\",D9=\"\",D10=\"\"),\"\",D9*1000/D10)","v":640},{"$f":"IF(OR(E8=\"\",E9=\"\",E10=\"\"),\"\",E9*1000/E10)","v":""},"","","","","","","","","","","","","","","","","",""]
["Subsample"]
[null,"Berry number/sample","count",200]
[null,"Berry sample weight","g",205]
[null,"Av. berry weight","g",{"$f":"IF(OR(D13=\"\",D14=\"\"),\"\",D14/D13)","v":1.0249999999999999},{"$f":"IF(OR(E13=\"\",E14=\"\"),\"\",E14/E13)","v":""},"","","","","","","","","","","","","","","","","",""]
["Temp Corrected","°Brix"]
[null,"°Baumé",null,12.5,11.3]
[null,"Juice Temperature °C",null,25,23]
[null,"°Baumé - corrected",null,{"$f":"IF(D17=\"\",\"\",IF(OR(D18<15,D18>25,D18=\"\"),\"Temp  outside range\",(D17+(-1+D18*0.05))))","v":12.75},{"$f":"IF(E17=\"\",\"\",IF(OR(E18<15,E18>25,E18=\"\"),\"T ??\",(E17+(-1+E18*0.05))))","v":11.450000000000001},{"$f":"IF(F17=\"\",\"\",IF(OR(F18<15,F18>25,F18=\"\"),\"T ??\",(F17+(-1+F18*0.05))))","v":""},"","","","","","","","","","","","","","","","",""]
[null,"pH"]
["A","Titratable acidity",{"$f":"IF(A21=\"\",\"\",IF(A21=\"A\",\"g tartaric acid/L\",IF(A21=\"B\",\"g tartaric acid /100 mL\",IF(A21=\"C\",\"g H2SO4  eq./L\",\"Error\"))))","v":"g tartaric acid/L"},{"$f":"IF($A$21=\"\",\"Enter method code\",IF($A$21=\"A\",TA!$I2,IF($A$21=\"B\",TA!$J2,IF($A$21=\"C\",TA!$K2,\"A, B or C?\"))))","v":8.625},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I3,IF($A$21=\"B\",TA!$J3,IF($A$21=\"C\",TA!$K3,\"A, B or C?\"))))","v":6.4500000000000011},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I4,IF($A$21=\"B\",TA!$J4,IF($A$21=\"C\",TA!$K4,\"A, B or C?\"))))","v":""},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I5,IF($A$21=\"B\",TA!$J5,IF($A$21=\"C\",TA!$K5,\"A, B or C?\"))))","v":""},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I6,IF($A$21=\"B\",TA!$J6,IF($A$21=\"C\",TA!$K6,\"A, B or C?\"))))","v":""},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I7,IF($A$21=\"B\",TA!$J7,IF($A$21=\"C\",TA!$K7,\"A, B or C?\"))))","v":""},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I8,IF($A$21=\"B\",TA!$J8,IF($A$21=\"C\",TA!$K8,\"A, B or C?\"))))","v":""},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I9,IF($A$21=\"B\",TA!$J9,IF($A$21=\"C\",TA!$K9,\"A, B or C?\"))))","v":""},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I10,IF($A$21=\"B\",TA!$J10,IF($A$21=\"C\",TA!$K10,\"A, B or C?\"))))","v":""},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I11,IF($A$21=\"B\",TA!$J11,IF($A$21=\"C\",TA!$K11,\"A, B or C?\"))))","v":""},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I12,IF($A$21=\"B\",TA!$J12,IF($A$21=\"C\",TA!$K12,\"A, B or C?\"))))","v":""},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I13,IF($A$21=\"B\",TA!$J13,IF($A$21=\"C\",TA!$K13,\"A, B or C?\"))))","v":""},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I14,IF($A$21=\"B\",TA!$J14,IF($A$21=\"C\",TA!$K14,\"A, B or C?\"))))","v":""},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I15,IF($A$21=\"B\",TA!$J15,IF($A$21=\"C\",TA!$K15,\"A, B or C?\"))))","v":""},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I16,IF($A$21=\"B\",TA!$J16,IF($A$21=\"C\",TA!$K16,\"A, B or C?\"))))","v":""},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I17,IF($A$21=\"B\",TA!$J17,IF($A$21=\"C\",TA!$K17,\"A, B or C?\"))))","v":""},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I18,IF($A$21=\"B\",TA!$J18,IF($A$21=\"C\",TA!$K18,\"A, B or C?\"))))","v":""},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I19,IF($A$21=\"B\",TA!$J19,IF($A$21=\"C\",TA!$K19,\"A, B or C?\"))))","v":""},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I20,IF($A$21=\"B\",TA!$J20,IF($A$21=\"C\",TA!$K20,\"A, B or C?\"))))","v":""},{"$f":"IF($A$21=\"\",\"Enter Code\",IF($A$21=\"A\",TA!$I21,IF($A$21=\"B\",TA!$J21,IF($A$21=\"C\",TA!$K21,\"A, B or C?\"))))","v":""}]
["Press sample"]
[null,"Press sample wt","kg",85]
[null,"Juice wt","kg",45]
[null,"Juice volume","L",{"$f":"IF(OR(D24=\"\",D17=\"\"),\"\",D24/(0.9982+0.008412*D19))","v":40.707293751973175},{"$f":"IF(OR(E24=\"\",E17=\"\"),\"\",E24/(0.9904+0.008367*E19))","v":""},"","","","","","","","","","","","","","","","","",""]
[null,"Yield (L/1000 kg)",null,{"$f":"IF(OR(D23=\"\",D24=\"\"),\"\",D24*1000/D23)","v":529.41176470588232},{"$f":"IF(OR(E23=\"\",E24=\"\"),\"\",E24*1000/E23)","v":""},"","","","","","","","","","","","","","","","","",""]
[]
[null,"Comments"]

{"sheet":"WhiteWine","index":2,"n_rows":37,"n_cols":22,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,7,0,8]]}
["White wines",null,null,"Ideal values"]
["Date",null,null,null,"2013-04-12","2013-04-15"]
["Day",null,null,null,0,{"$f":"IF(OR(E2=\"\",F2=\"\"),\"\",F2-E2)","v":3},{"$f":"IF(OR(F2=\"\",G2=\"\"),\"\",G2-F2)","v":""},"","","","","","","","","","","","","","",""]
["Time",null,"00:00:00"]
["Cultivar"]
["Ferment code"]
[]
["pH",null,null,"3.1 to 3.4"]
["Temp",null," (°C)",">15,<20",16]
["°Brix ",null,"(ref)","22.5 to 24.5"]
["°Be ",null,"(hydr)","12.5 to 14.0",7]
["°Be ",null,"(calc)",null,{"$f":"IF(OR(E9=\"\",E11=\"\"),\"\",E11+(-1+E9*0.05))","v":6.8},{"$f":"IF(OR(F9=\"\",F11=\"\"),\"\",F11+(-1+F9*0.05))","v":""},"","","","","","","","","","",{"$f":"IF(OR(Q9=\"\",Q11=\"\"),\"\",Q11+(-1+Q9*0.05))","v":""},{"$f":"IF(OR(R9=\"\",R11=\"\"),\"\",R11+(-1+R9*0.05))","v":""},{"$f":"IF(OR(S9=\"\",S11=\"\"),\"\",S11+(-1+S9*0.05))","v":""},{"$f":"IF(OR(T9=\"\",T11=\"\"),\"\",T11+(-1+T9*0.05))","v":""},{"$f":"IF(OR(U9=\"\",U11=\"\"),\"\",U11+(-1+U9*0.05))","v":""},{"$f":"IF(OR(V9=\"\",V11=\"\"),\"\",V11+(-1+V9*0.05))","v":""}]
["TA ","A",{"$f":"IF(B13=\"\",\"\",IF(B13=\"A\",\"g/ L\",IF(B13=\"B\",\"g/100mL\",IF(B13=\"C\",\"g/L Eu\",\"Value?\"))))","v":"g/ L"},"5.5 to 7.0",{"$f":"IF($B$13=\"A\",TA!$I2,IF($B$13=\"B\",TA!$J2,IF($B$13=\"C\",TA!$K2,\"Enter code\")))","v":8.625},{"$f":"IF($B$13=\"A\",TA!$I3,IF($B$13=\"B\",TA!$J3,IF($B$13=\"C\",TA!$K3,\"Enter code\")))","v":6.4500000000000011},{"$f":"IF($B$13=\"A\",TA!$I4,IF($B$13=\"B\",TA!$J4,IF($B$13=\"C\",TA!$K4,\"Enter code\")))","v":""},{"$f":"IF($B$13=\"A\",TA!$I5,IF($B$13=\"B\",TA!$J5,IF($B$13=\"C\",TA!$K5,\"Enter code\")))","v":""},{"$f":"IF($B$13=\"A\",TA!$I6,IF($B$13=\"B\",TA!$J6,IF($B$13=\"C\",TA!$K6,\"Enter code\")))","v":""},{"$f":"IF($B$13=\"A\",TA!$I7,IF($B$13=\"B\",TA!$J7,IF($B$13=\"C\",TA!$K7,\"Enter code\")))","v":""},{"$f":"IF($B$13=\"A\",TA!$I8,IF($B$13=\"B\",TA!$J8,IF($B$13=\"C\",TA!$K8,\"Enter code\")))","v":""},{"$f":"IF($B$13=\"A\",TA!$I9,IF($B$13=\"B\",TA!$J9,IF($B$13=\"C\",TA!$K9,\"Enter code\")))","v":""},{"$f":"IF($B$13=\"A\",TA!$I10,IF($B$13=\"B\",TA!$J10,IF($B$13=\"C\",TA!$K10,\"Enter code\")))","v":""},{"$f":"IF($B$13=\"A\",TA!$I12,IF($B$13=\"B\",TA!$J12,IF($B$13=\"C\",TA!$K12,\"Enter code\")))","v":""},{"$f":"IF($B$13=\"A\",TA!$I13,IF($B$13=\"B\",TA!$J13,IF($B$13=\"C\",TA!$K13,\"Enter code\")))","v":""},{"$f":"IF($B$13=\"A\",TA!$I14,IF($B$13=\"B\",TA!$J14,IF($B$13=\"C\",TA!$K14,\"Enter code\")))","v":""},{"$f":"IF($B$13=\"A\",TA!$I15,IF($B$13=\"B\",TA!$J15,IF($B$13=\"C\",TA!$K15,\"Enter code\")))","v":""},{"$f":"IF($B$13=\"A\",TA!$I16,IF($B$13=\"B\",TA!$J16,IF($B$13=\"C\",TA!$K16,\"Enter code\")))","v":""},{"$f":"IF($B$13=\"A\",TA!$I17,IF($B$13=\"B\",TA!$J17,IF($B$13=\"C\",TA!$K17,\"Enter code\")))","v":""},{"$f":"IF($B$13=\"A\",TA!$I18,IF($B$13=\"B\",TA!$J18,IF($B$13=\"C\",TA!$K18,\"Enter code\")))","v":""},{"$f":"IF($B$13=\"A\",TA!$I19,IF($B$13=\"B\",TA!$J19,IF($B$13=\"C\",TA!$K19,\"Enter code\")))","v":""},{"$f":"IF($B$13=\"A\",TA!$I20,IF($B$13=\"B\",TA!$J20,IF($B$13=\"C\",TA!$K20,\"Enter code\")))","v":""}]
["Free    SO2",null,"(mg L-1)",35]
["Bound SO2 ",null,"(mg L-1)","65 to 85"]
["Total   SO2",null,"(mg L-1)","100 to 120",{"$f":"IF(OR(E15=\"\",E14=\"\"),\"\",E15+E14)","v":""},{"$f":"IF(OR(F15=\"\",F14=\"\"),\"\",F15+F14)","v":""},"","","","","","","","","","",{"$f":"IF(OR(Q15=\"\",Q14=\"\"),\"\",Q15+Q14)","v":""},"","","","",""]
["NH4+",null,"(mg L-1)",140]
["FAN",null,"(mg L-1)",165]
["Phenols/Tannins",null,"(mg L-1)"]
["Malic Acid",null,"(mg L-1)"]
["Tartaric : Malic",null,"ratio","2:1 to 4:1",{"$f":"IF(OR(E20=\"\",0),\"\",(E13-E20)/E20)","v":""},{"$f":"IF(OR(F20=\"\",0),\"\",(F13-F20)/F20)","v":""},"","","","","","","","","","",{"$f":"IF(OR(Q20=\"\",0),\"\",(Q13-Q20)/Q20)","v":""},"","","","",""]
["K+",null,"(mg L-1)"]
[]
["Additions"]
["Tartaric acid",null,"(mg L-1)"]
["Malic acid",null,"(mg L-1)"]
["Citric acid",null,"(mg L-1)"]
["Ascorbic acid",null,"(mg L-1)"]
["Bentonite",null,"(mg L-1)"]
["Copper",null,"(mg L-1)"]
["PVPP",null,"(mg L-1)"]
["Other",null,"(mg L-1)"]
["Yeast",null,"(mg L-1)"]
["Malolactic culture",null,"(mg L-1)"]
[]
["Sensory",null," "]
["Comments"]

{"sheet":"RedWine","index":3,"n_rows":39,"n_cols":24,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Red cultivars",null,null,"Ideal values"]
["Person"]
["Date",null,null,null,"2013-05-15","2013-05-17"]
["Days",null,null,null,0,{"$f":"IF(OR(E3=\"\",F3=\"\"),\"\",F3-E3)","v":2},{"$f":"IF(OR(F3=\"\",G3=\"\"),\"\",G3-F3)","v":""},"","","","","","","","","","","","","","","","",""]
["Time",null,"00:00:00"]
["Cultivar"]
["Ferment code"]
[]
["pH",null,null,"3.3 to 3.5"]
["Temp",null," (°C)"]
["°Brix ",null,"(refr)","22.5 to 24.5"]
["°Be ",null,"(hydr)","12.5 to 14.0"]
["°Be ",null,"(calc)"]
["°Be ",null,"(table)"]
["TA [from TA sheet]","A",{"$f":"IF(B15=\"A\",\"(g /L)\",IF(B15=\"B\",\"(g/100mL)\",IF(B15=\"C\",\"(g/L Eu)\",\"Check code\")))","v":"(g /L)"},"5.5 to 7.0",{"$f":"IF($B$15=\"A\",TA!$I2,IF(B15=\"B\",TA!$J2,IF(B15=\"C\",TA!$K2,\"Enter code\")))","v":8.625},{"$f":"IF($B$15=\"A\",TA!$I3,IF(C15=\"B\",TA!$J3,IF(C15=\"C\",TA!$K3,\"Enter code\")))","v":6.4500000000000011},{"$f":"IF($B$15=\"A\",TA!$I4,IF(D15=\"B\",TA!$J4,IF(D15=\"C\",TA!$K4,\"Enter code\")))","v":""},{"$f":"IF($B$15=\"A\",TA!$I5,IF(E15=\"B\",TA!$J5,IF(E15=\"C\",TA!$K5,\"Enter code\")))","v":""},{"$f":"IF($B$15=\"A\",TA!$I6,IF(F15=\"B\",TA!$J6,IF(F15=\"C\",TA!$K6,\"Enter code\")))","v":""},{"$f":"IF($B$15=\"A\",TA!$I7,IF(G15=\"B\",TA!$J7,IF(G15=\"C\",TA!$K7,\"Enter code\")))","v":""},{"$f":"IF($B$15=\"A\",TA!$I8,IF(H15=\"B\",TA!$J8,IF(H15=\"C\",TA!$K8,\"Enter code\")))","v":""},{"$f":"IF($B$15=\"A\",TA!$I9,IF(I15=\"B\",TA!$J9,IF(I15=\"C\",TA!$K9,\"Enter code\")))","v":""},{"$f":"IF($B$15=\"A\",TA!$I10,IF(J15=\"B\",TA!$J10,IF(J15=\"C\",TA!$K10,\"Enter code\")))","v":""},{"$f":"IF($B$15=\"A\",TA!$I11,IF(K15=\"B\",TA!$J11,IF(K15=\"C\",TA!$K11,\"Enter code\")))","v":""},{"$f":"IF($B$15=\"A\",TA!$I12,IF(L15=\"B\",TA!$J12,IF(L15=\"C\",TA!$K12,\"Enter code\")))","v":""},{"$f":"IF($B$15=\"A\",TA!$I13,IF(M15=\"B\",TA!$J13,IF(M15=\"C\",TA!$K13,\"Enter code\")))","v":""},{"$f":"IF($B$15=\"A\",TA!$I14,IF(N15=\"B\",TA!$J14,IF(N15=\"C\",TA!$K14,\"Enter code\")))","v":""},{"$f":"IF($B$15=\"A\",TA!$I15,IF(O15=\"B\",TA!$J15,IF(O15=\"C\",TA!$K15,\"Enter code\")))","v":""},{"$f":"IF($B$15=\"A\",TA!$I16,IF(P15=\"B\",TA!$J16,IF(P15=\"C\",TA!$K16,\"Enter code\")))","v":""},{"$f":"IF($B$15=\"A\",TA!$I17,IF(Q15=\"B\",TA!$J17,IF(Q15=\"C\",TA!$K17,\"Enter code\")))","v":""},{"$f":"IF($B$15=\"A\",TA!$I18,IF(R15=\"B\",TA!$J18,IF(R15=\"C\",TA!$K18,\"Enter code\")))","v":""},{"$f":"IF($B$15=\"A\",TA!$I19,IF(S15=\"B\",TA!$J19,IF(S15=\"C\",TA!$K19,\"Enter code\")))","v":""},{"$f":"IF($B$15=\"A\",TA!$I20,IF(T15=\"B\",TA!$J20,IF(T15=\"C\",TA!$K20,\"Enter code\")))","v":""},{"$f":"IF($B$15=\"A\",TA!$I21,IF(U15=\"B\",TA!$J21,IF(U15=\"C\",TA!$K21,\"Enter code\")))","v":""}]
["Free SO2",null,"(mg L-1)",20]
["Bound SO2 ",null,"(mg L-1)","30 to 50"]
["Total   SO2",null,"(mg L-1)","50 to 70",{"$f":"IF(OR(E16=\"\",E17=\"\"),\"\",E17+E16)","v":""},{"$f":"IF(OR(F16=\"\",F17=\"\"),\"\",F17+F16)","v":""},"","","","","","","","","","",{"$f":"IF(OR(Q16=\"\",Q17=\"\"),\"\",Q17+Q16)","v":""},"","","","","","",""]
["NH4+",null,"(mg L-1)",50]
["FAN",null,"(mg L-1)",110]
["Antho",null,"(mg L-1)","1.1 to 2.0"]
["Malic Acid",null,"(mg L-1)"]
["Tartaric : Malic",null,"ratio","2:1 to 4:1",{"$f":"IF(OR(E22=\"\",0),\"\",(E15-E22)/E22)","v":""},{"$f":"IF(OR(F22=\"\",0),\"\",(F15-F22)/F22)","v":""},"","","","","","","","","","",{"$f":"IF(OR(Q22=\"\",0),\"\",(Q15-Q22)/Q22)","v":""},"","","","","","",""]
["K+",null,"(mg L-1)"]
[]
["Additions"]
["Tartaric acid",null,"(mg L-1)"]
["Malic acid",null,"(mg L-1)"]
["Citric acid",null,"(mg L-1)"]
["Ascorbic acid",null,"(mg L-1)"]
["Bentonite",null,"(mg L-1)"]
["Copper",null,"(mg L-1)"]
["PVPP",null,"(mg L-1)"]
["Other",null,"(mg L-1)"]
["Yeast",null,"(mg L-1)"]
["Malolactic culture",null,"(mg L-1)"]
[]
["Sensory"]
["Comments"]

{"sheet":"TA","index":4,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Person","Date","Sample","Sample volume (mL)","Start reading mL","End     mL","Titre mL","mol/L (NaOH)","TA g L-1","TA g/100 mL","TA g/L H2SO4"]
[null,null,null,10,null,11.5,{"$f":"IF(F2=0,\"\",F2-E2)","v":11.5},0.1,{"$f":"IF(OR($F2=\"\",0),\"\",75*$H2*$G2/$D2)","v":8.625},{"$f":"IF($I2=\"\",\"\",$I2/10)","v":0.86250000000000004},{"$f":"IF(OR($F2=\"\",0),\"\",49*$H2*$G2/$D2)","v":5.6349999999999998}]
[null,null,null,10,11.5,20.100000000000001,{"$f":"IF(F3=0,\"\",F3-E3)","v":8.6000000000000014},0.1,{"$f":"IF(OR($F3=\"\",0),\"\",75*$H3*$G3/$D3)","v":6.4500000000000011},{"$f":"IF($I3=\"\",\"\",$I3/10)","v":0.64500000000000013},{"$f":"IF(OR($F3=\"\",0),\"\",49*$H3*$G3/$D3)","v":4.2140000000000004}]
[null,null,null,10,null,null,"",0.1,"","",""]
[null,null,null,10,null,null,"",0.1,"","",""]
[null,null,null,10,null,null,"",0.1,"","",""]
[null,null,null,10,null,null,"",0.1,"","",""]
[null,null,null,10,null,null,"",0.1,"","",""]
[null,null,null,10,null,null,"",0.1,"","",""]
[null,null,null,10,null,null,"",0.1,"","",""]
[null,null,null,10,null,null,"",0.1,"","",""]
[null,null,null,10,null,null,{"$f":"IF(F12=0,\"\",F12-E12)","v":""},0.1,"","",""]
[null,null,null,10,null,null,"",0.1,"","",""]
[null,null,null,10,null,null,{"$f":"IF(F14=0,\"\",F14-E14)","v":""},0.1,"","",""]
[null,null,null,10,null,null,"",0.1,"","",""]
[null,null,null,10,null,null,"",0.1,"","",""]
[null,null,null,10,null,null,"",0.1,"","",""]
[null,null,null,10,null,null,"",0.1,"","",""]
[null,null,null,10,null,null,"",0.1,"","",""]
[null,null,null,10,null,null,"",0.1,"","",""]
[null,null,null,10,null,null,"",0.1,"","",""]

{"sheet":"SO2","index":5,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Date","Person","Sample","code","Initial vol","Final vol","Free Titre","Free SO2","Initial vol","Final vol","Bound Titre","Bound SO2","Total SO2"]
[null,null,null,null,0,0.5,{"$f":"IF(F2=\"\",\"\",F2-E2)","v":0.5},{"$f":"IF(G2=\"\",\"\",G2*16)","v":8},0.5,1.25,{"$f":"IF(J2=\"\",\"\",J2-I2)","v":0.75},{"$f":"IF(K2=\"\",\"\",K2*16)","v":12},{"$f":"IF(OR(H2=\"\",L2=\"\"),\"\",H2+L2)","v":20}]
[null,null,null,null,null,null,{"$f":"IF(F3=\"\",\"\",F3-E3)","v":""},{"$f":"IF(G3=\"\",\"\",G3*16)","v":""},null,null,{"$f":"IF(J3=\"\",\"\",J3-I3)","v":""},{"$f":"IF(K3=\"\",\"\",K3*16)","v":""},{"$f":"IF(OR(H3=\"\",L3=\"\"),\"\",H3+L3)","v":""}]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,{"$f":"IF(F13=\"\",\"\",F13-E13)","v":""},{"$f":"IF(G13=\"\",\"\",G13*16)","v":""},null,null,{"$f":"IF(J13=\"\",\"\",J13-I13)","v":""},{"$f":"IF(K13=\"\",\"\",K13*16)","v":""},""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]

{"sheet":"SO2titr","index":6,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Date","Person","Sample","code","Initial vol","Final vol","Free Titre","Free SO2","Initial vol","Final vol","Total Titre","Bound SO2","Total SO2"]
[null,null,null,null,0,1.5,{"$f":"IF(F2=\"\",\"\",F2-E2)","v":1.5},{"$f":"IF(G2=\"\",\"\",G2*12.8)","v":19.200000000000003},1.5,3.25,{"$f":"IF(J2=\"\",\"\",J2-I2)","v":1.75},{"$f":"IF(K2=\"\",\"\",M2-H2)","v":36.799999999999997},{"$f":"IF(K2=\"\",\"\",K2*32)","v":56}]
[null,null,null,null,null,null,{"$f":"IF(F3=\"\",\"\",F3-E3)","v":""},{"$f":"IF(G3=\"\",\"\",G3*12.8)","v":""},null,null,{"$f":"IF(J3=\"\",\"\",J3-I3)","v":""},{"$f":"IF(K3=\"\",\"\",M3-H3)","v":""},{"$f":"IF(K3=\"\",\"\",K3*32)","v":""}]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]
[null,null,null,null,null,null,"","",null,null,"","",""]

{"sheet":"FAN","index":7,"n_rows":23,"n_cols":23,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,2,1,7],[13,3,13,4],[13,5,13,6],[13,1,13,2],[13,7,13,8],[13,21,13,22],[13,9,13,10],[13,11,13,12],[13,13,13,14],[13,15,13,16],[13,17,13,18],[13,19,13,20]]}
[]
[null,"Blank","Amino N as L-isoleucine1 (mg/L)"]
[null,"Buffer","NOPA"]
["Solution (volume)",null,0,28,56,84,112,140]
["Distilled water (μL)",50,50,40,30,20,10,0]
["10 mM L-Isoeucine std (μL)","-","-",10,20,30,40,50]
["NOPA (mL)","-",3,3,3,3,3,3]
["Buffer (mL)",3,"-","-","-","-","-","-"]
["OD",0,2E-3,0.105,0.18,0.31,0.40799999999999997,0.50900000000000001]
["Corrected OD",null,0,{"$f":"D9-$C$9","v":0.10299999999999999},{"$f":"E9-$C$9","v":0.17799999999999999},0.308,0.40599999999999997,0.50700000000000001]
[null,null,"a","b","r2","<0.95?"]
["Equation","y=",{"$f":"INTERCEPT(C10:H10,C4:H4)","v":-4.9523809523809859E-3},{"$f":"SLOPE(C10:H10,C4:H4)","v":3.646938775510204E-3},{"$f":"(CORREL(C9:H9,C4:H4))^2","v":0.99692361964562792},{"$f":"IF(OR(E12<0.95,ABS(C12)-0.01>0),\"INVALID\",\"OK\")","v":"OK"}]
[]
["Solution","NOPA",null,"Sample 1",null,"Sample 2",null,"Sample 3",null,"Sample 4",null,"Sample 5",null,"Sample 6",null,"Sample 7",null,"Sample 8",null,"Sample 9",null,"Sample 10"]
[null,"blank","test","blank","test","blank","test","blank","test","blank","test","blank","test","blank","test","blank","test","blank","test","blank","test","blank","test"]
["Distilled water (μL)",null,50,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["Sample (μL)",null,"-",50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50]
["Buffer (mL)",null,"-",3,"-",3,"-",3,"-",3,"-",3,"-",3,"-",3,"-",3,"-",3,"-",3,"-"]
["NOPA (mL)",null,3,"-",3,"-",3,"-",3,"-",3,"-",3,"-",3,"-",3,"-",3,"-",3,"-",3]
["OD",null,0,5.0000000000000001E-3,3.4000000000000002E-2,7.0000000000000001E-3,0.317]
["Corrected OD",null,null,null,{"$f":"E20-D20","v":2.9000000000000001E-2},null,{"$f":"G20-F20","v":0.31},null,{"$f":"I20-H20","v":0},null,{"$f":"K20-J20","v":0},null,{"$f":"M20-L20","v":0},null,{"$f":"O20-N20","v":0},null,{"$f":"Q20-P20","v":0},null,{"$f":"S20-R20","v":0},null,{"$f":"U20-T20","v":0},null,{"$f":"W20-V20","v":0}]
["Dilution Factor",null,null,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1]
["Estimated Amino N (mg/L)",null,null,null,{"$f":"(E21/$D$12)*E22","v":7.9518746502518196},null,{"$f":"((G21-$C$12)/$D$12)*G22","v":86.360753590748004},null,{"$f":"((I21)/$D$12)*I22","v":0},null,{"$f":"((K21)/$D$12)*K22","v":0},null,{"$f":"((M21)/$D$12)*M22","v":0},null,{"$f":"((O21)/$D$12)*O22","v":0},null,{"$f":"((Q21)/$D$12)*Q22","v":0},null,{"$f":"((S21)/$D$12)*S22","v":0},null,{"$f":"((U21)/$D$12)*U22","v":0},null,{"$f":"((W21)/$D$12)*W22","v":0}]

{"sheet":"NH4","index":8,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[22,2,22,3],[6,7,6,10],[8,7,8,10],[16,7,16,10],[18,7,18,10],[22,5,22,7],[19,8,19,9]]}
[null,null,null,null,null,null,null,"Protocol - A: R-Biopharm"]
[null,null,null,null,null,null,null,"Pipette into cuvettes","Blank (mL)","Standard (mL)","Sample (mL)"]
[null,null,null,null,null,null,null,"Reaction mixture 2",1,1,1]
[null,null,null,null,null,null,null,"Sample solution","---","---",0.1]
[null,null,null,null,null,null,null,"Standard solution","---",0.1,"---"]
[null,null,null,null,null,null,null,"DI water",2,1.9,1.9]
[null,null,null,null,null,null,null,"Mix and read absorbances (A1) after 5 mins @ 20 - 25°C."]
[null,null,null,null,null,null,null,"Solution 3",0.02,0.02,0.02]
[null,null,null,null,null,null,null,"Mix and read absorbances (A2) after 20 mins."]
[]
[null,null,null,null,null,null,null," Protocol - B: Generic",null,"Nucleotide","NADPH"]
[null,null,null,null,null,null,null,"Pipette into cuvettes","Blank     (mL)","Standard (mL)","Sample   (mL)"]
[null,null,null,null,null,null,null,"Distilled water",2.1,2,2]
[null,null,null,null,null,null,null,"Sample solution","---",0.1,0.1]
[null,null,null,null,null,null,null,"Solution 1 (buffer)",0.3,0.3,0.3]
[null,null,null,null,null,null,null,"Solution 2 (NADPH)",0.2,0.2,0.2]
[null,null,null,null,null,null,null,"Mix and read absorbances (A1) after 2 mins @ 20 - 25°C."]
[null,null,null,null,null,null,null,"Solution 3",0.02,0.02,0.02]
[null,null,null,null,null,null,null,"Mix and read absorbances (A2) after 5 mins. If not stable, re-read at intervals until stable."]
[null,null,null,null,null,null,null,null,"Tube volume less sample = ",null,{"$f":"K13+K15+K16+K18","v":2.52}]
[]
[null,"Enter either 365 or 340",null,null,null,null,null,null,null,null,"Enter std NH3 value (mg/L)"]
["Wavelength",365,"Extinction coef. = ",null,{"$f":"IF(B23=340,6.3,IF(AND(A25=\"A\",B23=365),3.4,IF(AND(B23=365,K11=\"NADH\"),3.4,IF(AND(B23=365,K11=\"NADPH\"),3.5,\"ERROR\"))))","v":3.5},"Tube volume (less sample) =",null,null,{"$f":"IF($A$25=\"A\",2.92,IF(A25=\"B\",$K$20,\"?Protocol\"))","v":2.52},"Standard = ",41.5]
["Protocol: Enter         A or B","Date","Sample","Sample volume (mL)","Dilution (F)","A1","A2","(A1 - A2)","ΔA                               (A1 - A2)sample                       - (A1 - A2)blank","NH3 mg L-1","Corrected for dilution (mg/L)","Range of values too high?"]
["B",null,"Blank",null,null,1E-3,1E-3,{"$f":"F25-G25","v":0}]
[null,null,"Standard",0.1,1,0.5,0.16,{"$f":"F26-G26","v":0.33999999999999997},{"$f":"H26-$H$25","v":0.33999999999999997},{"$f":"IF($I26=\"\",\"\",IF(OR($A$25=\"A\",$A$25=\"B\"),($I26*($I$23+$D26)*17.03)/($D26*$E$23),\"?Protocol\"))","v":43.343782857142848},{"$f":"IF($J26=\"\",\"\",$J26*$E26)","v":43.343782857142848},{"$f":"CONCATENATE(\"Error = \",INT((($K26-$K$23)*100)/$K$23),\" %\")","v":"Error = 4 %"}]
[null,null,null,0.1,10,0.63400000000000001,0.45400000000000001,{"$f":"F27-G27","v":0.18},{"$f":"H27-$H$25","v":0.18},{"$f":"IF($I27=\"\",\"\",IF(OR($A$25=\"A\",$A$25=\"B\"),($I27*($I$23+$D27)*17.03)/($D27*$E$23),\"?Protocol\"))","v":22.946708571428573},{"$f":"IF($J27=\"\",\"\",$J27*$E27)","v":229.46708571428573},{"$f":"IF(H27=\"\",\"\",IF(AND($B$23=340,$H27>1),\"Dilute\",IF(AND($B$23=365,$H27>0.5), \"Dilute\",\"OK\")))","v":"OK"}]
[null,null,null,0.1,10,null,null,{"$f":"IF(OR(F28=\"\",0),\"\",F28-G28)","v":""},{"$f":"IF(H28=\"\",\"\",H28-$H$25)","v":""},"","",""]
[null,null,null,0.1,10,null,null,{"$f":"IF(OR(F29=\"\",0),\"\",F29-G29)","v":""},{"$f":"IF(H29=\"\",\"\",H29-$H$25)","v":""},"","",""]
[null,null,null,0.1,10,null,null,{"$f":"IF(OR(F30=\"\",0),\"\",F30-G30)","v":""},{"$f":"IF(H30=\"\",\"\",H30-$H$25)","v":""},"","",""]
[null,null,null,0.1,10,null,null,{"$f":"IF(OR(F31=\"\",0),\"\",F31-G31)","v":""},{"$f":"IF(H31=\"\",\"\",H31-$H$25)","v":""},"","",""]
[null,null,null,0.1,10,null,null,{"$f":"IF(OR(F32=\"\",0),\"\",F32-G32)","v":""},{"$f":"IF(H32=\"\",\"\",H32-$H$25)","v":""},"","",""]
[null,null,null,0.1,10,null,null,{"$f":"IF(OR(F33=\"\",0),\"\",F33-G33)","v":""},{"$f":"IF(H33=\"\",\"\",H33-$H$25)","v":""},"","",""]
[null,null,null,0.1,10,null,null,"","","","",""]
[null,null,null,0.1,10,null,null,"","","","",""]
[null,null,null,0.1,10,null,null,"","","","",""]
[null,null,null,0.1,10,null,null,"","","","",""]
[null,null,null,0.1,10,null,null,"","","","",""]
[null,null,null,0.1,10,null,null,"","","","",""]
[null,null,null,0.1,10,null,null,"","","","",""]
[null,null,null,0.1,10,null,null,"","","","",""]
[null,null,null,0.1,10,null,null,"","","","",""]
[null,null,null,0.1,10,null,null,"","","","",""]
[null,null,null,0.1,10,null,null,"","","","",""]
[null,null,null,0.1,10,null,null,"","","","",""]

{"sheet":"Glu-Fru","index":9,"n_rows":48,"n_cols":15,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,8,0,12],[10,8,10,12],[15,8,15,9],[5,8,5,12],[9,8,9,12],[1,8,1,9],[2,8,2,9],[3,8,3,9],[6,8,6,9],[8,8,8,9],[4,8,4,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[21,10,21,11],[20,8,20,12],[16,8,16,12],[18,8,18,12],[7,8,7,12],[17,8,17,9],[19,8,19,9]]}
[null,null,null,null,null,null,null,null,"Protocol A: Boehringer Mannheim®"]
[null,null,null,null,null,null,null,null,"Pipette into cuvettes",null,"Blank","Standard","Sample volume "]
[null,null,null,null,null,null,null,null,"DI water",null,2,1.9,1.9]
[null,null,null,null,null,null,null,null,"Sample or std solution",null,"---","0.100",0.1]
[null,null,null,null,null,null,null,null,"Solution 1",null,1,1,1]
[null,null,null,null,null,null,null,null,"Mix and read absorbances (A1) after 3 mins @ 20 - 25°."]
[null,null,null,null,null,null,null,null,"Suspension 2",null,0.02,0.02,0.02]
[null,null,null,null,null,null,null,null,"Mix and read absorbances (A2) after 10 to 15 mins @ 20 - 25°."]
[null,null,null,null,null,null,null,null,"Suspension 3",null,0.02,0.02,0.02]
[null,null,null,null,null,null,null,null,"Mix and read absorbances (A3) after 10 to 15 mins."]
[null,null,null,null,null,null,null,null,"Protocol B: Generic"]
[null,null,null,null,null,null,null,null,"Pipette into cuvettes",null,"Blank","Standard","Sample volume "]
[null,null,null,null,null,null,null,null,"DI water",null,2,1.9,1.9]
[null,null,null,null,null,null,null,null,"Sample or std solution",null,"---","0.100",0.1]
[null,null,null,null,null,null,null,null,"Solution 1 (buffer)",null,0.1,0.1,0.1]
[null,null,null,null,null,null,null,null,"Solution 2 (NADP+/ATP",null,0.1,0.1,0.1]
[null,null,null,null,null,null,null,null,"Mix and read absorbances (A1) after 3 mins @ 20 - 25°."]
[null,null,null,null,null,null,null,null,"Suspension 3",null,0.02,0.02,0.02]
[null,null,null,null,null,null,null,null,"Mix and read absorbances (A2) after min. 5 mins @ 20 - 25°."]
[null,null,null,null,null,null,null,null,"Suspension 4",null,0.02,0.02,0.02]
[null,null,null,null,null,null,null,null,"Mix and read absorbances (A3) after 10 to 15 mins."]
[null,null,null,null,null,null,null,null,null,null,"Tube vol. less sample =",null,{"$f":"M13+M15+M16+M18+M20","v":2.14}]
[]
[]
[]
[null,"Enter value",null,null,null,"Tube volume less sample mL"]
["Wavelength",365,"Extinction coef.",{"$f":"IF(B27=365,3.5,IF(B27=340,6.3,\"?Wavelength\"))","v":3.5},"Glu. vol =",{"$f":"IF($A$29=\"A\",2.92,IF(A29=\"B\",$M$22-$M$20,\"Protocol?\"))","v":2.12},"Fru. vol. =",{"$f":"IF($A$29=\"A\",2.94,IF(A29=\"B\",$M$22,\"Protocol?\"))","v":2.14},"Std mg/L = ",0.49299999999999999]
["Protocol: Enter         A or B","Date","Sample","Sample volume (mL)","Dilution (DF)","A1","A2","A3","(A2 - A1)","(A3 - A2)","Glucose g/L","Fructose g/L","Total g/L","Fraction as glucose"]
["B",null,"Blank",null,null,0,1E-3,6.8000000000000005E-2,{"$f":"IF(OR(F29=\"\",G29=\"\"),\"\",G29-F29)","v":1E-3},{"$f":"IF(OR(G29=\"\",H29=\"\"),\"\",H29-G29)","v":6.7000000000000004E-2}]
[null,null,"std (0.5g/L)",0.1,1,0,0.42,0.47,{"$f":"IF(OR(F30=\"\",G30=\"\"),\"\",(G30-F30)-I$29)","v":0.41899999999999998},{"$f":"IF(OR(G30=\"\",H30=\"\"),\"\",(H30-G30)-J$29)","v":-1.7000000000000015E-2},{"$f":"IF(I30=\"\",\"\",(I30*180.16*($F$27+$D30)*$E30)/($D$27*1000*$D30))","v":0.47880351085714284},{"$f":"IF(J30=\"\",\"\",(J30*180.16*($H$27+$D30)*$E30)/($D$27*1000*$D30))","v":-1.9601408000000018E-2},{"$f":"IF(AND(K30=\"\",L30=\"\"),\"\",K30+L30)","v":0.4592021028571428},{"$f":"IF(OR(K30=0,K30=\"\"),\"\",K30/(L30+K30))","v":1.042685797556328},{"$f":"CONCATENATE(\"Error = \",INT((($K30-$J$27)*100)/$J$27),\" %\")","v":"Error = -3 %"}]
[null,null,"2056-1",0.05,1,4.4999999999999998E-2,0.105,2.8639999999999999,5.8999999999999997E-2,{"$f":"IF(OR(G31=\"\",H31=\"\"),\"\",(H31-G31)-J$29)","v":2.6919999999999997},{"$f":"IF(I31=\"\",\"\",(I31*180.16*($F$27+$D31)*$E31)/($D$27*1000*$D31))","v":0.13180505599999998},{"$f":"IF(J31=\"\",\"\",(J31*180.16*($H$27+$D31)*$E31)/($D$27*1000*$D31))","v":6.0693124388571427},{"$f":"IF(AND(K31=\"\",L31=\"\"),\"\",K31+L31)","v":6.2011174948571428},{"$f":"IF(OR(K31=0,K31=\"\"),\"\",K31/(L31+K31))","v":2.1255048966466392E-2},{"$f":"IF(OR(G31>1,H31>1),\"Dilute\",\"OK\")","v":"Dilute"}]
[null,null,"2056-2",0.01,10,2.5000000000000001E-2,6.9000000000000006E-2,2.0190000000000001,4.3000000000000003E-2,1.8830000000000002,4.714529828571429,208.39107199999998,213.10560182857142,2.2122974657249692E-2,{"$f":"IF(OR(G32>1,H32>1),\"Dilute\",\"OK\")","v":"Dilute"}]
[null,null,"X16-1",0.03,1,2.9000000000000001E-2,0.104,2.5369999999999999,7.3999999999999996E-2,2.3659999999999997,0.27298529523809523,8.8093435733333312,9.0823288685714267,3.0056750772671975E-2,"Dilute"]
[null,null,"X16-2",0.1,1,-2.9000000000000001E-2,2.3E-2,0.55800000000000005,5.1000000000000004E-2,0.46800000000000003,5.8279186285714289E-2,0.53961523200000006,0.59789441828571432,9.7474043080737635E-2,"OK"]
[null,null,null,0.1,1,null,null,null,"","","","","","","OK"]
[null,null,null,0.1,1,null,null,null,"","","","","","","OK"]
[null,null,null,0.1,1,null,null,null,{"$f":"IF(OR(F37=\"\",G37=\"\"),\"\",(G37-F37)-I$29)","v":""},{"$f":"IF(OR(G37=\"\",H37=\"\"),\"\",(H37-G37)-J$29)","v":""},"","",{"$f":"IF(AND(K37=\"\",L37=\"\"),\"\",K37+L37)","v":""},"","OK"]
[null,null,null,0.1,1,null,null,null,"","","","","","","OK"]
[null,null,null,0.1,1,null,null,null,"","","","","","","OK"]
[null,null,null,0.1,1,null,null,null,"","","","","","","OK"]
[null,null,null,0.1,1,null,null,null,"","","","","","","OK"]
[null,null,null,0.1,1,null,null,null,"","","","","","","OK"]
[null,null,null,0.1,1,null,null,null,"","","","","","","OK"]
[null,null,null,0.1,1,null,null,null,"","","","","","","OK"]
[null,null,null,0.1,1,null,null,null,"","","","","","","OK"]
[null,null,null,0.1,1,null,null,null,"","","","","","","OK"]
[null,null,null,0.1,1,null,null,null,"","","","","","","OK"]
[null,null,null,0.1,1,null,null,null,"","","","","","","OK"]

{"sheet":"Malic acid","index":10,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[[24,2,24,3],[21,6,21,9],[0,6,0,9],[11,6,11,9],[24,5,24,6],[8,6,8,9],[10,6,10,9],[19,6,19,9]]}
[null,null,null,null,null,null,"Protocol A: R-Biopharm®"]
[null,null,null,null,null,null,"Pipette into cuvettes","Blank (mL)","Standard (mL)","Sample (mL)"]
[null,null,null,null,null,null,"DI water",1,0.9,0.9]
[null,null,null,null,null,null,"Solution 1",1,1,1]
[null,null,null,null,null,null,"Solution 2",0.2,0.2,0.2]
[null,null,null,null,null,null,"Suspension 3",0.01,0.01,0.01]
[null,null,null,null,null,null,"Sample solution","---","---",0.1]
[null,null,null,null,null,null,"Standard solution","---",0.1,"---"]
[null,null,null,null,null,null,"Mix and read absorbances (A1) after 3 mins @ 20 - 25°."]
[null,null,null,null,null,null,"Solution 4",0.01,0.01,0.01,null,null," "]
[null,null,null,null,null,null,"Mix and read absorbances (A2) after 5 - 10 mins."]
[null,null,null,null,null,null,"Protocol B: Generic (e.g. Megazyme®)"]
[null,null,null,null,null,null,"Pipette into cuvettes","Blank (mL)","Standard (mL)","Sample (mL)"]
[null,null,null,null,null,null,"DI water",2.1,2,2]
[null,null,null,null,null,null,"Solution 1",0.1,0.1,0.1]
[null,null,null,null,null,null,"Solution 2",0.1,0.1,0.1]
[null,null,null,null,null,null,"Suspension 3",0.02,0.02,0.02]
[null,null,null,null,null,null,"Sample solution","---","---",0.1]
[null,null,null,null,null,null,"Standard solution","---",0.1,"---"]
[null,null,null,null,null,null,"Mix and read absorbances (A1) after 3 mins @ 20 - 25°."]
[null,null,null,null,null,null,"Suspension 4",0.02,0.02,0.02]
[null,null,null,null,null,null,"Mix and read absorbances (A2) after 5 - 10 mins."]
[null,null,null,null,null,null,null,"Tube vol. less sample","=",{"$f":"SUM($J$14:$J$21)-$J$18","v":2.2400000000000002}]
[null,"Enter value",null,null,null,null,null,null,null,"Enter value"]
["Wavelength",340,"Extinction coef. =",null,{"$f":"IF(B25=365,3.4,IF(B25=340,6.3,\"?Wavelength\"))","v":6.3},"Tube volume (mL) =            (less sample)",null,{"$f":"IF(A27=\"A\",2.22,IF(A27=\"B\",$J$23,\"Protocol?\"))","v":2.2200000000000002},"Std mg/L =",0.19700000000000001]
["Protocol: Enter           A or B","Date","Sample","Sample volume (mL)","Dilution (DF)","less sample vol.","A2","DA                      (A2 - A1)sample - (A2 - A1)blank","Malic acid      (g L-1)","Corrected for dilution"]
["A",null,"Blank",null,null,2.7E-2,0.04]
[null,null,"std (0.2g/L)",0.1,1,0.05,0.46,{"$f":"IF(OR(F28=\"\",G28=\"\"),\"\",($G28-$F28)-($G$27-$F$27))","v":0.39700000000000002},{"$f":"IF(H28=\"\",\"\",(($H$25+$D28)*134.09*$H28/($E$25*$D28*1000)))","v":0.19603532317460323},{"$f":"IF(I28=\"\",\"\",I28*E28)","v":0.19603532317460323},{"$f":"IF($J28=\"\",\"\",CONCATENATE(\"Error = \",INT((($J28-$J$25)*100)/$J$25),\" %\"))","v":"Error = -1 %"}]
[null,null,null,0.1,10,0.65500000000000003,0.73499999999999999,{"$f":"IF(OR(F29=\"\",G29=\"\"),\"\",($G29-$F29)-($G$27-$F$27))","v":6.6999999999999962E-2},{"$f":"IF(H29=\"\",\"\",(($H$25+$D29)*134.09*$H29/($E$25*$D29*1000)))","v":3.3084046984126966E-2},{"$f":"IF(I29=\"\",\"\",I29*E29)","v":0.33084046984126969},{"$f":"IF($I33=\"\",\"\",IF($I33>0.2,\"Dilute\",\"OK\"))","v":""}]
[null,null,null,0.01,1,0.38700000000000001,0.42699999999999999,2.6999999999999979E-2,0.12815172857142848,0.12815172857142848,{"$f":"IF($I34=\"\",\"\",IF($I34>0.2,\"Dilute\",\"OK\"))","v":""}]
[null,null,null,null,1,null,null,{"$f":"IF(OR(F31=\"\",G31=\"\"),\"\",($G31-$F31)-($G$27-$F$27))","v":""},"","",""]
[null,null,null,null,1,null,null,"","","",""]
[null,null,null,null,1,null,null,"","","",""]
[null,null,null,null,1,null,null,"","","",""]
[null,null,null,null,1,null,null,"","","",""]
[null,null,null,null,1,null,null,"","","",""]
[null,null,null,null,1,null,null,"","","",""]
[null,null,null,null,1,null,null,"","","",""]
[null,null,null,null,1,null,null,"","","",""]
[null,null,null,null,1,null,null,"","","",""]
[null,null,null,null,1,null,null,"","","",""]
[null,null,null,null,1,null,null,"","","",""]
[null,null,null,null,1,null,null,"","","",""]
[null,null,null,null,1,null,null,"","","",""]
[null,null,null,null,1,null,null,"","","",""]
[null,null,null,null,1,null,null,"","","",""]
[null,null,null,null,1,null,null,"","","",""]

{"sheet":"Acetic acid","index":11,"n_rows":51,"n_cols":15,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,8,0,11],[21,8,21,11],[23,8,23,11],[25,8,25,11],[14,8,14,11],[7,8,7,11],[9,8,9,11],[11,8,11,11]]}
[null,null,null,null,null,null,null,null,"Protocol A: Megazyme®"]
[null,null,null,null,null,null,null,null,"Pipette into cuvettes","Blank (mL)","Standard (mL)","Sample (mL)"]
[null,null,null,null,null,null,null,null,"DI water",2.1,2,2]
[null,null,null,null,null,null,null,null,"Solution #1",0.5,0.5,0.5]
[null,null,null,null,null,null,null,null,"Solution #2",0.2,0.2,0.2]
[null,null,null,null,null,null,null,null,"Sample solution","---","---","\"0.100\""]
[null,null,null,null,null,null,null,null,"Standard solution","---",0.1,"---"]
[null,null,null,null,null,null,null,null,"Mix and read absorbances (A1) after 20 mins @ 20 - 25°C."]
[null,null,null,null,null,null,null,null,"Suspension #3",0.02,0.02,0.02]
[null,null,null,null,null,null,null,null,"Mix and read absorbances (A2) after 3 - 5 mins."]
[null,null,null,null,null,null,null,null,"Solution #4",0.02,0.02,0.02]
[null,null,null,null,null,null,null,null,"Mix and read absorb. (A3) afer 20 minutes @ 20 - 25°C.",null,null,null," "]
[]
[]
[null,null,null,null,null,null,null,null,"Protocol B: Generic e.g. R-Biopharm®"]
[null,null,null,null,null,null,null,null,"Pipette into cuvettes","Blank (mL)","Standard (mL)","Sample (mL)"]
[null,null,null,null,null,null,null,null,"DI water"]
[null,null,null,null,null,null,null,null,"Solution #1"]
[null,null,null,null,null,null,null,null,"Solution #2"]
[null,null,null,null,null,null,null,null,"Sample solution","---","---"]
[null,null,null,null,null,null,null,null,"Standard solution","---",null,"---"]
[null,null,null,null,null,null,null,null,"Mix and read absorbances (A1) after 20 mins @ 20 - 25°C."]
[null,null,null,null,null,null,null,null,"Suspension #3"]
[null,null,null,null,null,null,null,null,"Mix and read absorbances (A2) after 3 - 5 mins."]
[null,null,null,null,null,null,null,null,"Solution #4"]
[" ",null,null,null,null,null,null,null,"Mix and read absorb. (A3) afer 20 minutes @ 20 - 25°C."]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J17:J25)","v":0},{"$f":"SUM(K17:K25)","v":0},0]
[null,"Protocol      A or B","Enter wavelength 340 or 365",null,"Extinction coeff.",null,"Tube volume (mL)","Enter Std conc. (g/L) "]
[null,"A",365,null,{"$f":"IF(C29=365,3.4,IF(C29=340,6.3,\"?Wavelength\"))","v":3.4},null,{"$f":"IF($B$29=\"A\",2.74,IF($B$29=\"B\",$L$27,\"Protocol?\"))","v":2.74},0.20300000000000001]
["Person","Date","Sample","Sample volume (mL)","Dilution (F)","A1","A2","A3","(A2 - A1)","(A3 - A1)","DA","Acetic acid      (g L-1)","Corrected for dilution"]
[null,null,"Blank",null,null,9.7000000000000003E-2,0.41199999999999998,0.42299999999999999,{"$f":"IF(OR($F31=\"\",$G31=\"\"),\"\",$G31-$F31)","v":0.31499999999999995},{"$f":"IF(OR($F31=\"\",$H31=\"\"),\"\",$H31-$F31)","v":0.32599999999999996}]
[null,null,"Stardard",0.1,1,9.6000000000000002E-2,0.10199999999999999,0.51,{"$f":"IF(OR($F32=\"\",$G32=\"\"),\"\",$G32-$F32)","v":5.9999999999999915E-3},{"$f":"IF(OR($F32=\"\",$H32=\"\"),\"\",$H32-$F32)","v":0.41400000000000003},{"$f":"IF(OR($I32=\"\",$J32=\"\",$I$31=\"\",$J$31=\"\"),\"\",($J32-($I32*$I32/$J32))-(($J$31)-($I$31*$I$31/$J$31)))","v":0.39228420912243267},{"$f":"IF($K32=\"\",\"\",60.05*($G$29+$D32)*$K32/($D32*$E$29*1000))","v":0.19676745174164093},{"$f":"IF(L32=\"\",\"\",$L32*$E32)","v":0.19676745174164093},{"$f":"CONCATENATE(\"Error = \",INT(((M32-$H$29)*100)/$H$29),\" %\")","v":"Error = -4 %"}]
[null,null,"chardonnay",0.1,10,0.12,0.156,0.73099999999999998,3.6000000000000004E-2,0.61099999999999999,{"$f":"IF(OR($I33=\"\",$J33=\"\",$I$31=\"\",$J$31=\"\"),\"\",($J33-($I33*$I33/$J33))-(($J$31)-($I$31*$I$31/$J$31)))","v":0.58725005271454811},{"$f":"IF($K33=\"\",\"\",60.05*($G$29+$D33)*$K33/($D33*$E$29*1000))","v":0.29456117202954257},{"$f":"IF(L33=\"\",\"\",$L33*$E33)","v":2.9456117202954255},{"$f":"IF($L33=\"\",\"\",IF($L33>0.2,\"Dilute\",\"OK\"))","v":"Dilute"}," "]
[null,null,"chardonnay ",0.01,1,0.11,0.18,0.57899999999999996,6.9999999999999993E-2,0.46899999999999997,0.43692340445014188,2.1221305500701559,2.1221305500701559,{"$f":"IF($L34=\"\",\"\",IF($L34>0.2,\"Dilute\",\"OK\"))","v":"Dilute"}]
[null,null,"SB",0.1,1,0.04,0.13200000000000001,0.21,9.1999999999999998E-2,0.16999999999999998,9.8582930350054096E-2,4.9448617963996834E-2,4.9448617963996834E-2,"OK"]
[null,null,null,0.1,1,null,null,null,"","","","","",""]
[null,null,null,0.1,1,null,null,null,"","","","","",""]
[null,null,null,0.1,1,null,null,null,"","","","","",""]
[null,null,null,0.1,1,null,null,null,"","","","","",""]
[null,null,null,0.1,1,null,null,null,"","","","","",""]
[null,null,null,0.1,1,null,null,null,"","","","","",""]
[null,null,null,0.1,1,null,null,null,"","","","","",""]
[null,null,null,0.1,1,null,null,null,"","","","","",""]
[null,null,null,0.1,1,null,null,null,"","","","","",""]
[null,null,null,0.1,1,null,null,null,"","","","","",""]
[null,null,null,0.1,1,null,null,null,"","","","","",""]
[null,null,null,0.1,1,null,null,null,"","","","","",""]
[null,null,null,0.1,1,null,null,null,"","","","","",""]
[null,null,null,0.1,1,null,null,null,"","","","","",""]
[null,null,null,0.1,1,null,null,null,"","","","","",""]
[null,null,null,0.1,1,null,null,null,"","","","","",""]

{"sheet":"K+","index":12,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[11,0,12,0],[1,1,1,3],[2,1,2,3],[3,1,3,5],[10,6,12,6],[6,1,6,2],[11,4,12,4]]}
[]
["Person"]
["Date"]
[null,"Standards (mg/L)"]
[null,0,2.5,5,7.5,10]
["Reading",0,24,49,77,99]
[null,{"$f":"\"y =\" & ROUND((INTERCEPT(B6:F6,B5:F5)),4) & \"+\" &ROUND((SLOPE(B6:F6,B5:F5)),4)&\"x\"","v":"y =-0.4+10.04x"},null,{"$f":"\"r^2 = \"&ROUND(CORREL(B5:F5,B6:F6)^2,3)","v":"r^2 = 0.999"},{"$f":"SLOPE(B6:F6,B5:F5)","v":10.039999999999999}]
[null,"where y = absorbance, x = std (mg/L)"]
[]
[null,null,null,null,"Enter C/NC",null,"mg/L","mmol/L","mg/g","mg/berry"]
["Instrument C or NC?","Sample","Berry","Sample Wt","NC",null,"Corrected for calibration curve","Wine","[Berry]","[Berry]"]
["Sample number","Type","count","g","Dilution","Reading",null,"Must"]
[null,null,null,null,null,null,null,"Juice"]
["shiraz","Wine",null,null,100,99,{"$f":"IF(OR(E14=\"\",F14=\"\"),\"\",F14*E14/$E$7)","v":986.05577689243034},{"$f":"IF(G14=\"\",\"\",G14/39.1)","v":25.218817823335815},{"$f":"IF(AND($B14=\"Berry\",C14<>\"\",$G14<>\"\"),$G14*50/(1000*D14),\"\")","v":""},{"$f":"IF(AND($B14=\"Berry\",D14<>\"\",$G14<>\"\"),$G14*50/(1000*C14),\"\")","v":""}]
[null,"Wine",null,null,100,72,{"$f":"IF(OR(E15=\"\",F15=\"\"),\"\",F15*E15/$E$7)","v":717.13147410358567},{"$f":"IF(G15=\"\",\"\",G15/39.1)","v":18.3409584169715},"",""]
[null,"Berry",5,7.2,50,77,383.46613545816734,9.8073180424083723,{"$f":"IF(AND($B16=\"Berry\",C16<>\"\",$G16<>\"\"),$G16*50/(1000*D16),\"\")","v":2.6629592740150509},{"$f":"IF(AND($B16=\"Berry\",D16<>\"\",$G16<>\"\"),$G16*50/(1000*C16),\"\")","v":3.8346613545816735}]
[null,"Berry",5,7.5,100,95,946.21513944223113,24.19987568905962,{"$f":"IF(AND($B17=\"Berry\",C17<>\"\",$G17<>\"\"),$G17*50/(1000*D17),\"\")","v":6.3081009296148745},{"$f":"IF(AND($B17=\"Berry\",D17<>\"\",$G17<>\"\"),$G17*50/(1000*C17),\"\")","v":9.4621513944223121}]
[null,"Must",null,null,100,null,"","","",""]
[null,null,null,null,100,null,"","","",""]
[null,null,null,null,100,null,"","","",""]
[null,null,null,null,100,null,"","","",""]
[null,null,null,null,100,null,"","","",""]
[null,null,null,null,100,null,"","","",""]
[null,null,null,null,100,null,"","","",""," "]
[null,null,null,null,100,null,"","","",""]
[null,null,null,null,100,null,"","","",""]
[null,null,null,null,100,null,"","","",""]
[null,null,null,null,100,null,"","","",""]
[null,null,null,null,100,null,"","","",""]
[null,null,null,null,100,null,"","","",""]
[null,null,null,null,100,null,"","","",""]
[null,null,null,null,100,null,"","","",""]
[null,null,null,null,100,null,"","","",""]

{"sheet":"Colour-Red grapes","index":13,"n_rows":24,"n_cols":23,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,3,0],[1,1,3,1],[1,2,3,2],[1,3,3,3],[1,4,3,4],[1,5,3,5],[1,8,1,11],[1,12,1,18],[2,14,2,15],[2,16,2,17],[1,6,1,7]]}
["Note: Abbreviations as per Figure 4, Chapter 11 [sheet: Ref Flow f4]"]
["Date","Cultivar","Block ID","Sample Person","Analyst","Sample wt (kg)","Weight 200 berry subsamples  (g)",null,"Subsample (Ss) 1",null,null,null,"Subsample (Ss) 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pH 1.0",null,"pH 3.2"]
[null,null,null,null,null,null,"Ss1","Ss2","Juice wt (g)","°Brix","Density","ml/kg","pH","TA ","A520","A'520","B520","B'520","B280","ΔA520","PA (mg/L)","EA %","Ps %"]
[null,null,null,null,null,null,220,null,130,20,{"$f":"IF(J5=\"\",\"\",0.9984+0.004653*$J5)","v":1.0914599999999999},{"$f":"IF(OR(G5=\"\",I5=\"\",K5=\"\"),\"\",I5*K5*1000/G5)","v":644.95363636363629},null,null,0.51,0.31,0.21,0.11,0.35,{"$f":"IF(OR($O5=\"\",$P5=\"\"),\"\",$O5-$P5)","v":0.2},{"$f":"IF($T5=\"\",\"\",$T5*1078)","v":215.60000000000002},{"$f":"IF(OR($O5=\"\",$P5=\"\",$Q5=\"\",$R5=\"\"),\"\",(($O5-$P5)-($Q5-$R5))/($O5-$P5))","v":0.50000000000000011},{"$f":"IF(OR(Q5=\"\",R5=\"\",S5=\"\"),\"\",S5-((Q5-R5)*0.04))","v":0.34599999999999997}]
[null,null,null,null,null,null,201,null,105,24.3,{"$f":"IF(J6=\"\",\"\",0.9984+0.004653*$J6)","v":1.1114679000000001},{"$f":"IF(OR(G6=\"\",I6=\"\",K6=\"\"),\"\",I6*K6*1000/G6)","v":580.61755970149261},null,null,null,null,null,null,null,{"$f":"IF(OR($O6=\"\",$P6=\"\"),\"\",$O6-$P6)","v":""},{"$f":"IF($T6=\"\",\"\",$T6*1078)","v":""},{"$f":"IF(OR($O6=\"\",$P6=\"\",$Q6=\"\",$R6=\"\"),\"\",(($O6-$P6)-($Q6-$R6))/($O6-$P6))","v":""},{"$f":"IF(OR(Q6=\"\",R6=\"\",S6=\"\"),\"\",S6-((Q6-R6)*0.04))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","","",""]

{"sheet":"Red Flow chart f4","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Colour-RedWine","index":15,"n_rows":42,"n_cols":17,"rows_kept":42,"cut":false,"hidden":false,"merged":[[30,1,30,7],[30,8,30,10],[15,10,15,16],[15,2,15,9],[16,14,16,15],[16,12,16,13],[14,4,14,8],[16,10,16,11],[16,2,16,4],[16,6,16,7],[16,8,16,9],[14,1,14,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Enter data here"]
["Date",null,null,"Person",null,null,null,null,null,"pH",3.5]
[null,null,"Raw wine",null,null,null,null,null,null,null,{"$f":"\"Wine adjusted to pH \"&K15","v":"Wine adjusted to pH 3.5"}]
["Sample",null,null,null,null,"HCl","Wine - SO2",null,"Wine + SO2",null,"pH3.5",null,"pH3.5 - SO2",null,"pH3.5 +SO2",null,"HCl"]
[null,"DF","E280","E420","E520","E520","E420","E520","E420","E520","E420","E520","E420","E520","E420","E520","E520"]
["Record values here",10,0.5,0.21,0.63,0.56000000000000005,0.24,0.7,0.21,0.25,0.24,0.55000000000000004,0.245,0.56499999999999995,0.247,0.503,0.32]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Read results here","Control",null,null,null,null,null,null,{"$f":"\"Adjusted to pH \"&K15&\" less SO2\"","v":"Adjusted to pH 3.5 less SO2"}]
[null,"Density","- SO2","+ SO2","Hue","Red Pigments","% Red Pigments","Phenolics","Density","Hue","% Red Pigments"]
[{"$f":"IF($A19=\"\",\"\",$A19)","v":"Record values here"},{"$f":"IF(OR($D19=\"\",$E19=\"\",$B19=\"\"),\"\",($D19+$E19)*$B19)","v":8.4},{"$f":"IF(OR($G19=\"\",$H19=\"\",$B19=\"\"),\"\",($G19+$H19)*$B19)","v":9.3999999999999986},{"$f":"IF(OR($I19=\"\",J19=\"\"),\"\",($I19+$J19)*$B19)","v":4.5999999999999996},{"$f":"IF(OR($E19=\"\",$D19=\"\"),\"\",$D19/$E19)","v":0.33333333333333331},{"$f":"IF($F19=\"\",\"\",$F19*101)","v":56.56},{"$f":"IF(OR($F19=\"\",$E19=\"\",$F19=\"\"),\"\",(E19*B19)/($F19*101))","v":0.11138613861386137},{"$f":"IF(OR($B19=\"\",$C19=\"\"),\"\",($C19*101)-4)","v":46.5},{"$f":"IF(OR($M19=\"\",$N19=\"\",$B19=\"\"),\"\",($M19+$N19)*$B19)","v":8.1},{"$f":"IF(OR($M19=\"\",$N19=\"\"),\"\",$M19/$N19)","v":0.4336283185840708},{"$f":"IF(OR($P19=\"\",$Q19=\"\",$B19=\"\"),\"\",$N19*$B19/($Q19*101))","v":0.17481435643564355}]
[{"$f":"IF($A20=\"\",\"\",$A20)","v":""},{"$f":"IF(OR($D20=\"\",$E20=\"\",$B20=\"\"),\"\",($D20+$E20)*$B20)","v":""},{"$f":"IF(OR($G20=\"\",$H20=\"\",$B20=\"\"),\"\",($G20+$H20)*$B20)","v":""},{"$f":"IF(OR($I20=\"\",J20=\"\"),\"\",($I20+$J20)*$B20)","v":""},{"$f":"IF(OR($E20=\"\",$D20=\"\"),\"\",$D20/$E20)","v":""},{"$f":"IF($F20=\"\",\"\",$F20*101)","v":""},{"$f":"IF(OR($F20=\"\",$E20=\"\",$F20=\"\"),\"\",(E20*B20)/($F20*101))","v":""},{"$f":"IF(OR($B20=\"\",$C20=\"\"),\"\",($C20*101)-4)","v":""},{"$f":"IF(OR($M20=\"\",$N20=\"\",$B20=\"\"),\"\",($M20+$N20)*$B20)","v":""},{"$f":"IF(OR($M20=\"\",$N20=\"\"),\"\",$M20/$N20)","v":""},{"$f":"IF(OR($P20=\"\",$Q20=\"\",$B20=\"\"),\"\",$N20*$B20/($Q20*101))","v":""}]
["","","","","","","","","","",""]
["","","","","","","","","","",""]
["","","","","","","","","","",""]
["","","","","","","","","","",""]
["","","","","","","","","","",""]
["","","","","","","","","","",""]
["","","","","","","","","","",""]
["","","","","","","","","","",""]

{"sheet":"PhenolicsWhite","index":16,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[11,1,11,3],[12,1,12,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Person"]
["Date"]
["Sample","DF","A280","A280 pvpp","A320","A320 pvpp","A420","A420 pvpp","Total phenolics","Total CAE","Total flavonoids","Brown pigments","CAE eq. (mg/L)","Flavonoids (mg/L)"]
["cab sav xy",10,0.63,0.22,0.4,0.35,0.25,0.11,{"$f":"IF(OR(B15=\"\",C15=\"\",D15=\"\"),\"\",($C15-$D15)*$B15)","v":4.1000000000000005},{"$f":"IF(OR(B15=\"\",E15=\"\"),\"\",($E15*$B15)-1.4)","v":2.6},{"$f":"IF(OR($I15=\"\",$J15=\"\",$B15=\"\"),\"\",($I15-(0.6*$J15/0.9))*$B15)","v":23.666666666666671},{"$f":"IF(OR($B15=\"\",$G15=\"\",$H15=\"\"),\"\",($G15-$H15)*$B15)","v":1.4000000000000001},{"$f":"IF(OR($B15=\"\",$E15=\"\",$F15=\"\"),\"\",(($E15-$F15)*10/0.9)*$B15)","v":5.5555555555555607},{"$f":"IF(OR($B15=\"\",$C15=\"\",$D15=\"\",$E15=\"\",$F15=\"\"),\"\",((($C15-$D15)-($E15-$F15))*$B15)*(60/(0.9*0.14)))","v":1714.2857142857138}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(B16=\"\",C16=\"\",D16=\"\"),\"\",($C16-$D16)*$B16)","v":""},{"$f":"IF(OR(B16=\"\",E16=\"\"),\"\",($E16*$B16)-1.4)","v":""},{"$f":"IF(OR($I16=\"\",$J16=\"\",$B16=\"\"),\"\",($I16-(0.6*$J16/0.9))*$B16)","v":""},{"$f":"IF(OR($B16=\"\",$G16=\"\",$H16=\"\"),\"\",($G16-$H16)*$B16)","v":""},{"$f":"IF(OR($B16=\"\",$E16=\"\",$F16=\"\"),\"\",(($E16-$F16)*10/0.9)*$B16)","v":""},{"$f":"IF(OR($B16=\"\",$C16=\"\",$D16=\"\",$E16=\"\",$F16=\"\"),\"\",((($C16-$D16)-($E16-$F16))*$B16)*(60/(0.9*0.14)))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(B17=\"\",C17=\"\",D17=\"\"),\"\",($C17-$D17)*$B17)","v":""},{"$f":"IF(OR(B17=\"\",E17=\"\"),\"\",($E17*$B17)-1.4)","v":""},{"$f":"IF(OR($I17=\"\",$J17=\"\",$B17=\"\"),\"\",($I17-(0.6*$J17/0.9))*$B17)","v":""},{"$f":"IF(OR($B17=\"\",$G17=\"\",$H17=\"\"),\"\",($G17-$H17)*$B17)","v":""},{"$f":"IF(OR($B17=\"\",$E17=\"\",$F17=\"\"),\"\",(($E17-$F17)*10/0.9)*$B17)","v":""},{"$f":"IF(OR($B17=\"\",$C17=\"\",$D17=\"\",$E17=\"\",$F17=\"\"),\"\",((($C17-$D17)-($E17-$F17))*$B17)*(60/(0.9*0.14)))","v":""}]
[null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(B34=\"\",C34=\"\",D34=\"\"),\"\",($C34-$D34)*$B34)","v":""},{"$f":"IF(OR(B34=\"\",E34=\"\"),\"\",($E34*$B34)-1.4)","v":""},{"$f":"IF(OR($I34=\"\",$J34=\"\",$B34=\"\"),\"\",($I34-(0.6*$J34/0.9))*$B34)","v":""},{"$f":"IF(OR($B34=\"\",$G34=\"\",$H34=\"\"),\"\",($G34-$H34)*$B34)","v":""},{"$f":"IF(OR($B34=\"\",$E34=\"\",$F34=\"\"),\"\",(($E34-$F34)*10/0.9)*$B34)","v":""},{"$f":"IF(OR($B34=\"\",$C34=\"\",$D34=\"\",$E34=\"\",$F34=\"\"),\"\",((($C34-$D34)-($E34-$F34))*$B34)*(60/(0.9*0.14)))","v":""}]

{"sheet":"Total phenols","index":17,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[13,2,13,7],[16,2,16,4],[16,5,16,6],[19,2,19,4],[20,2,20,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Gallic acid standard curve mg/L"]
[null,null,0,50,100,150,250,500]
[null,"Absorbance",0,0.08,0.15,0.22,0.38,0.755]
[null,null,{"$f":"\"y = \"&ROUND(INTERCEPT(C16:H16,C15:H15),4)&\" + \"&ROUND(SLOPE(C16:H16,C15:H15),6)&\" x\"","v":"y = 0.0001 + 0.001509 x"},null,null,{"$f":"\"r^2 = \"&ROUND(CORREL(C15:H15,C16:H16)^2,4)","v":"r^2 = 0.9998"},null,{"$f":"SLOPE(C16:H16,C15:H15)","v":1.5091603053435114E-3}]
[null,null,"where y = Absorbance, x = Gallic Acid mg/L"]
[]
[null,"Person"]
[null,"Date"]
[null,"Sample","DF","OD765","Gallic acid eq. mg/L"]
[null,"syrah",10,0.35,{"$f":"IF(OR(C23=\"\",D23=\"\"),\"\",$D23*$C23/($H$17))","v":2319.1704602933737}]
[null,null,10,null,{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",$D24*$C24/($H$17*1000))","v":""}]
[null,null,10,null,"",null,"Wines",null,"mg/L"]
[null,null,10,null,"",null,"Thompson Seedless",null,230]
[null,null,10,null,"",null,"Tinta Madeira",null,741]
[null,null,10,null,"",null,"Zinfandel",null,3177]
[null,null,10,null,"",null,"Pinot noir",null,2082]
[null,null,10,null,"",null,"Calzin",null,2210]
[null,null,10,null,"",null,"Carignane",null,1385]
[null,null,10,null,""]
[null,null,10,null,""]
[null,null,10,null,""]
[null,null,10,null,""]
[null,null,10,null,""]
[null,null,10,null,""]
[null,null,10,null,""]
[null,null,10,null,""]
[null,null,10,null,""]
[null,null,10,null,""]
[null,null,10,null,""]

{"sheet":"Tannins","index":18,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":false,"merged":[[14,1,14,3],[14,4,14,5],[3,9,4,9],[5,9,6,9],[8,10,8,15],[11,10,11,12],[11,13,11,14],[13,1,13,3]]}
[]
[null,null,null,null,null,null,null,null,null,null,"Part","Sample","Methyl cellulose","(NH4)2SO4","DI water"]
[null,null,null,null,null,null,null,null,null,null,null,"mL","mL","mL","mL"]
[null,null,null,null,null,null,null,null,null,"Wine","Control",0.05,0,0.4,1.55]
[null,null,null,null,null,null,null,null,null,null,"Test",0.05,0.6,0.4,0.95]
[null,null,null,null,null,null,null,null,null,"Grape","Control",0.2,0,0.4,1.4]
[null,null,null,null,null,null,null,null,null,null,"Test",0.2,0.6,0.4,0.8]
[]
[null,null,null,null,null,null,null,null,null,null,"(-) epichatechin mg/L (µg/mL)"]
[null,null,null,null,null,null,null,null,null,null,0,50,100,150,200,250]
[null,null,null,null,null,null,null,null,null,"Reading",0,0.13900000000000001,0.28299999999999997,0.42099999999999999,0.56200000000000006,0.70499999999999996]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K11:P11=\"\",\"\",\"y = \"&ROUND(INTERCEPT(K11:P11,K10:P10),4)&\" + \"&ROUND(SLOPE(K11:P11,K10:P10),6)&\" x\")","v":"y = -0.0006 + 0.002818 x"},null,null,{"$f":"IF(K11:P11=\"\",\"\",\"r^2 = \"&ROUND(CORREL(K10:P10,K11:P11)^2,4))","v":"r^2 = 1"},null,{"$f":"SLOPE(K11:P11,K10:P10)","v":2.8182857142857146E-3}]
[null,null,null,null,null,null,null,null,null,null,"where y = OD, x = epicatchin µg/mL (mg/L)"]
["Person"]
["Date"]
["Sample","Type","Grape sample wt (g)","Grape sample volume (mL)","DF","OD280 blank","OD280 Methyl Cellulose","ΔOD280","Wine tannin g/L (-) epichatechin","Grape tannin mg/g"]
["syrah","wine",null,null,40,0.45,0.21,{"$f":"IF(OR($E17=\"\",$F17=\"\",$G17=\"\"),\"\",($F17-$G17)*$E17)","v":9.6000000000000014},{"$f":"IF(H17=\"\",\"\",IF(B17=\"Wine\",$H17/($P$12*1000),\"\"))","v":3.4063260340632606},{"$f":"IF(H17=\"\",\"\",IF(B17=\"berry\",$H17*$D17/$C17,\"\"))","v":""}]
["syrah","berry",250,150,10,0.65500000000000003,0.31,{"$f":"IF(OR($E18=\"\",$F18=\"\",$G18=\"\"),\"\",($F18-$G18)*$E18)","v":3.45},{"$f":"IF(H18=\"\",\"\",IF(B18=\"Wine\",H18/($P$12*1000),\"\"))","v":""},{"$f":"IF(H18=\"\",\"\",IF(B18=\"berry\",$H18*$D18/$C18,\"\"))","v":2.0699999999999998}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($E19=\"\",$F19=\"\",$G19=\"\"),\"\",($F19-$G19)*$E19)","v":""},{"$f":"IF(H19=\"\",\"\",IF(B19=\"Wine\",H19/(#REF!*1000),\"\"))","v":""},{"$f":"IF(H19=\"\",\"\",IF(B19=\"berry\",$H19*$D19/$C19,\"\"))","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(H20=\"\",\"\",IF(B20=\"Wine\",H20/(#REF!*1000),\"\"))","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(H21=\"\",\"\",IF(B21=\"Wine\",H21/(#REF!*1000),\"\"))","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(H22=\"\",\"\",IF(B22=\"Wine\",H22/(#REF!*1000),\"\"))","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(H23=\"\",\"\",IF(B23=\"Wine\",H23/(#REF!*1000),\"\"))","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(H24=\"\",\"\",IF(B24=\"Wine\",H24/(#REF!*1000),\"\"))","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(H25=\"\",\"\",IF(B25=\"Wine\",H25/(#REF!*1000),\"\"))","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(H26=\"\",\"\",IF(B26=\"Wine\",H26/(#REF!*1000),\"\"))","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(H27=\"\",\"\",IF(B27=\"Wine\",H27/(#REF!*1000),\"\"))","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(H28=\"\",\"\",IF(B28=\"Wine\",H28/(#REF!*1000),\"\"))","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(H29=\"\",\"\",IF(B29=\"Wine\",H29/(#REF!*1000),\"\"))","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(H30=\"\",\"\",IF(B30=\"Wine\",H30/(#REF!*1000),\"\"))","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(H31=\"\",\"\",IF(B31=\"Wine\",H31/(#REF!*1000),\"\"))","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(H32=\"\",\"\",IF(B32=\"Wine\",H32/(#REF!*1000),\"\"))","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(H33=\"\",\"\",IF(B33=\"Wine\",H33/(#REF!*1000),\"\"))","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(H34=\"\",\"\",IF(B34=\"Wine\",H34/(#REF!*1000),\"\"))","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(H35=\"\",\"\",IF(B35=\"Wine\",H35/(#REF!*1000),\"\"))","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(H36=\"\",\"\",IF(B36=\"Wine\",H36/(#REF!*1000),\"\"))","v":""},""]

{"sheet":"Ebulliometry","index":19,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[16,1,16,3],[17,1,17,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Person"]
["Date"]
["Sample","Dilution","T1 °C","T2  °C","ΔT","mL/100 mL"]
[null,2,97.2,100.5,{"$f":"IF(OR($C20=\"\",$D20=\"\"),\"\",$D20-$C20)","v":3.2999999999999972},{"$f":"IF(OR(B20=\"\",E20=\"\"),\"\",(0.0105+0.9189*E20+0.0502*E20*E20)*B20)","v":7.1790959999999933}]
[null,null,null,null,{"$f":"IF(OR($C21=\"\",$D21=\"\"),\"\",$D21-$C21)","v":""},{"$f":"IF(OR(B21=\"\",E21=\"\"),\"\",(0.0105+0.9189*E21+0.0502*E21*E21)*B21)","v":""}]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]

{"sheet":"Sheet14","index":20,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}