{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Time-Drifting Sensor","Sheet2"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":0,"defined_names":19,"comments":1,"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":"Time-Drifting Sensor","index":0,"n_rows":116,"n_cols":44,"rows_kept":116,"cut":false,"hidden":false,"merged":[[2,2,2,4],[2,11,2,12],[3,14,3,15]]}
[]
[null,"  Calibration for time-drifting sensor with weighted quadratic fit."]
[null,null,"Enter calibration data here",null,null,null,null,null,null,null,null,"Application to unknowns",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calibration curves for each unknown sample",null,null,null,null,{"$f":"MAX(AK6:AK52)","v":5},{"$f":"MAX(AL6:AL53)","v":24.999999999999996},{"$f":"MAX(AM6:AM52)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(AN6:AN52)","v":{"$error":"#DIV/0!"}},"Normalized weights (Copy/Paste to Column M)"]
[null,null,"Date/Time","Pre-calibration","Post-calibration",null,null,null,null,null,null,null,null," ","Warnings",null,null,null,null,"X and Y products for POST calibration",null,null,null,null," ","X and Y products for PRE calibration",null,null,null,null,null,"Coefficients for each equation",null,null,"Peak of parabola"]
[null,"Weights","Concentration of standards",null,null,null,null,null,null,"X post","X pre","MM-DD-YY HH:MM:SS","Reading of the unknowns","Calculated concentrations","Instrument reading above maximum of calibration curve","Calculated concentration above maximum standard concentration","elapsed time,hours","X","Y","X*Y","X*X","X^3","X^4","X^2y","Y","X*Y","X*X","X^3","X^4","X^2y","Y","a","b","c","max x","max y","1/X","1/X^2","1/Y","1/Y^2","1/X","1/X^2","1/Y","1/Y^2"]
[null,1,0.1,0.2,null,null,null,null,null,{"$f":"IF(COUNT(E6)=1,C6,0)","v":0},{"$f":"IF(COUNT(D6)=1,C6,0)","v":0.1},null,null,{"$f":"IF(COUNT(L6:M6)=2,(-AG6+SQRT(AG6*AG6-4*AF6*(AH6-M6)))/(2*AF6),\"\")","v":""},{"$f":"IF(COUNT(L6:M6)=2,IF(M6>AJ6,\"Instrument reading too high\",\" \"),\"\")","v":""},{"$f":"IF(COUNT(L6:M6)=2,IF(N6>MAX($C$6:$C$25),\"Above maximum standard\",\" \"),\"\")","v":""},{"$f":"IF(COUNT(L6)=1,(L6-$D$5)*24,\"\")","v":""},{"$f":"IF(COUNT($C6:$D6)=2,C6*$B6,0)","v":0.1},{"$f":"IF(COUNT($C6:$D6)=2,E6*$B6,0)","v":0},{"$f":"IF(COUNT($C6:$D6)=2,R6*S6*$B6,0)","v":0},{"$f":"IF(COUNT($C6:$D6)=2,R6*R6*$B6,0)","v":1.0000000000000002E-2},{"$f":"IF(COUNT($C6:$D6)=2,R6^3*$B6,0)","v":1.0000000000000002E-3},{"$f":"IF(COUNT($C6:$D6)=2,R6^4*$B6,0)","v":1.0000000000000005E-4},{"$f":"IF(COUNT($C6:$D6)=2,S6*R6^2*$B6,0)","v":0},{"$f":"IF(COUNT(D6)=1,$E6,0)","v":0},{"$f":"IF(COUNT($C6:$D6)=2,R6*AE6*$B6,0)","v":2.0000000000000004E-2},{"$f":"IF(COUNT($C6:$D6)=2,R6*R6*$B6,0)","v":1.0000000000000002E-2},{"$f":"IF(COUNT($C6:$D6)=2,R6^3*$B6,0)","v":1.0000000000000002E-3},{"$f":"IF(COUNT($C6:$D6)=2,R6^4*$B6,0)","v":1.0000000000000005E-4},{"$f":"IF(COUNT($C6:$D6)=2,AE6*R6^2*$B6,0)","v":2.0000000000000005E-3},{"$f":"IF(COUNT(J6)=1,$D6,0)","v":0.2},{"$f":"IF(COUNT(L6:M6)=2,($L6-$D$5)/($E$5-$D$5)*($U$62-$AE$62)+$AE$62,\"\")","v":""},{"$f":"IF(COUNT(L6:M6)=2,($L6-$D$5)/($E$5-$D$5)*($U$63-$AE$63)+$AE$63,\"\")","v":""},{"$f":"IF(COUNT(L6:M6)=2,($L6-$D$5)/($E$5-$D$5)*($U$64-$AE$64)+$AE$64,\"\")","v":""},{"$f":"IF(COUNT(L6:M6)=2,-AG6/(2*AF6),\"\")","v":""},{"$f":"IF(COUNT(L6:M6)=2,AF6*AI6^2+AG6*AI6+AH6,\"\")","v":""},{"$f":"IF(COUNT($C6:$D6)=2,1/D6,\"\")","v":5},{"$f":"IF(COUNT($C6:$D6)=2,1/(D6*D6),\"\")","v":24.999999999999996},{"$f":"IF(COUNT($C6:$D6)=2,1/E6,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT($C6:$D6)=2,1/(E6*E6),\"\")","v":{"$error":"#DIV/0!"}},{"$f":"AK6/AK$3","v":1},{"$f":"AL6/AL$3","v":1},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,0.2,0.3,null,null,null,null,null,0,0.2,null,null,"","","","",{"$f":"IF(COUNT($C7:$D7)=2,C7*$B7,0)","v":0},{"$f":"IF(COUNT($C7:$D7)=2,E7*$B7,0)","v":0},{"$f":"IF(COUNT($C7:$D7)=2,R7*S7*$B7,0)","v":0},{"$f":"IF(COUNT($C7:$D7)=2,R7*R7*$B7,0)","v":0},{"$f":"IF(COUNT($C7:$D7)=2,R7^3*$B7,0)","v":0},{"$f":"IF(COUNT($C7:$D7)=2,R7^4*$B7,0)","v":0},{"$f":"IF(COUNT($C7:$D7)=2,S7*R7^2*$B7,0)","v":0},{"$f":"IF(COUNT(D7)=1,$E7,0)","v":0},{"$f":"IF(COUNT($C7:$D7)=2,R7*AE7*$B7,0)","v":0},{"$f":"IF(COUNT($C7:$D7)=2,R7*R7*$B7,0)","v":0},{"$f":"IF(COUNT($C7:$D7)=2,R7^3*$B7,0)","v":0},{"$f":"IF(COUNT($C7:$D7)=2,R7^4*$B7,0)","v":0},{"$f":"IF(COUNT($C7:$D7)=2,AE7*R7^2*$B7,0)","v":0},{"$f":"IF(COUNT(D7)=1,$D7,0)","v":0.3},{"$f":"IF(COUNT(L7:M7)=2,($L7-$D$5)/($E$5-$D$5)*($U$62-$AE$62)+$AE$62,\"\")","v":""},"","","","",{"$f":"IF(COUNT($C7:$D7)=2,1/D7,\"\")","v":3.3333333333333335},{"$f":"IF(COUNT($C7:$D7)=2,1/(D7*D7),\"\")","v":11.111111111111111},{"$f":"IF(COUNT($C7:$D7)=2,1/E7,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT($C7:$D7)=2,1/(E7*E7),\"\")","v":{"$error":"#DIV/0!"}},{"$f":"AK7/AK$3","v":0.66666666666666674},0.44444444444444448,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,0.3,0.4,null,null,null,null,null,0,0.3,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0.4,"","","","","",2.5,6.2499999999999991,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0.5,0.25,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,"","","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null," Pre-calibration R2 =",{"$f":"$AJ$91","v":0.26720647772876283}," Post-calibration R2 =",null,{"$f":"Z91","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null," "," ",null," "," "," "," "," "," "," "," "," ",null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,{"$f":"__xlfnodf.DAYS(E5, D5)*24","v":{"$error":"#NAME?"}}," hours between pre- and post-calibrations.",null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Warning: Math follows....",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Summary of equations:",null,null,{"$f":"T65","v":"y="},1E-10,"X^2","+",0,"x","+",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"  B28","n=number of x,y data points",null,{"$f":"AD65","v":"y="},6.0000000000999965,"X^2","+",1.3999999999999997,"x","+",-4.2351647362714978E-18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"  B27","sumx=Σx",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"  C27","sumy=Σy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"  D27","sumxy=Σx*y",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"  E27","sumx2=Σx*x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"  F27","sumx3=Σx^3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"  G27","sumx3=Σx^4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"  H27","sumx2y=Σ(x^2)*y",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"  B30","D=n*sumx2*sumx4+2*sumx*sumx2*sumx3-sumx2^3-sumx^2*sumx4-n*sumx3^2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"  B31","a=(n*sumx2*sumx2y+sumx*sumx3*sumy+sumx*sumx2*sumxy-sumx2^2*sumy-sumx^2*sumx2y-n*sumx3*sumxy)/D",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"  B32","b=(n*sumx4*sumxy+sumx*sumx2*sumx2y+sumx2*sumx3*sumy-sumx2^2*sumxy-sumx*sumx4*sumy-n*sumx3*sumx2y)/D",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"  B33","c=(sumx2*sumx4*sumy+sumx2*sumx3*sumxy+sumx*sumx3*sumx2y-sumx2^2*sumx2y-sumx*sumx4*sumxy-sumx3^2*sumy)/D",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Off-screen calculation are on the right ==>"]
[null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,"Post-calibration",null,null,null,null,null,null,null,null,null,"Pre-calibration"]
[null,"Calculations of the coefficients a,b, and c of the best-fit parabola y=ax^2+bx+c",null,null,null,null,null,null,null,null,null,null,null,null,"Note: The if( ) functions in some of the cells",null,null,null,null,"Calculations of the coefficients a,b, and c of the best-fit parabola y=ax^2+bx+c for the LAST calibration (END)",null,null,null,null,null,null,null,null,null,"Calculations of the coefficients a,b, and c of the best-fit parabola y=ax^2+bx+c for the FIRST calibration (START)"]
[null,"sums","sumx",null,"sumy","sumxy","sumx2","ssy","ssr","sumx2y",null,null,null,null,"are not part of the actual numerical calculation. ",null,null,null,null,"sums","sumx","sumy","sumxy","sumx2","ssy","ssr","sumx2y",null,null,"sums","sumx","sumy","sumxy","sumx2","ssy","ssr","sumx2y"]
[null,null,"ΣX",null,"ΣY","Σ(X*Y)","Σ(X*X)","Σ(X^3)","Σ(X^4)","Σ(X^2)*y",null,null,null,null,"Their purpose is simply to blank out or zero",null,null,null,null,null,"ΣX","ΣY","Σ(X*Y)","Σ(X*X)","Σ(X^3)","Σ(X^4)","Σ(X^2)*y",null,null,null,"ΣX","ΣY","Σ(X*Y)","Σ(X*X)","Σ(X^3)","Σ(X^4)","Σ(X^2)*y"]
[null," ",{"$f":"SUM(C6:C25)","v":0.60000000000000009},null,{"$f":"SUM(E6:E25)","v":0},{"$f":"SUM(T6:T25)","v":0},{"$f":"SUM(U6:U25)","v":1.0000000000000002E-2},{"$f":"SUM(V6:V25)","v":1.0000000000000002E-3},{"$f":"SUM(W6:W25)","v":1.0000000000000005E-4},{"$f":"SUM(X6:X25)","v":0},null,null,null,null,"out cells that are not being used at the moment",null,null,null,null," ",{"$f":"SUM(J6:J25)","v":0},{"$f":"SUM(Y6:Y25)","v":0},{"$f":"SUM(T6:T25)","v":0},{"$f":"SUM(U6:U25)","v":1.0000000000000002E-2},{"$f":"SUM(V6:V25)","v":1.0000000000000002E-3},{"$f":"SUM(W6:W25)","v":1.0000000000000005E-4},{"$f":"SUM(X6:X25)","v":0},null,null," ",{"$f":"SUM(K6:K25)","v":0.60000000000000009},{"$f":"SUM(AE6:AE25)","v":0.9},{"$f":"SUM(Z6:Z25)","v":2.0000000000000004E-2},{"$f":"SUM(AA6:AA25)","v":1.0000000000000002E-2},{"$f":"SUM(AB6:AB25)","v":1.0000000000000002E-3},{"$f":"SUM(AC6:AC25)","v":1.0000000000000005E-4},{"$f":"SUM(AD6:AD25)","v":2.0000000000000005E-3}]
[null,"n",{"$f":"COUNT(E6:E25)","v":0},null,"(number of points (n)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n",{"$f":"COUNT(E6:E25)","v":0},"(number of points (n)",null,null,null,null,null,null,null,"n",{"$f":"COUNT(D6:D25)","v":3},"(number of points (n)"]
[]
[null,"D",{"$f":"n*sumx2*sumx4+2*sumx*sumx2*sumx3-sumx2^3-sumx^2*sumx4-n*sumx3^2","v":-1.0000000000000006E-6},null,"Denominator (D)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",{"$f":"U59*X58*Z58+2*U58*X58*Y58-X58^3-U58^2*Z58-U59*Y58^2","v":-1.0000000000000006E-6},"Denominator (D)",null,null,null,null,null,null,null,"D",{"$f":"AE59*AH58*AJ58+2*AE58*AH58*AI58-AH58^3-AE58^2*AJ58-$AE$59*AI58^2","v":-2.5000000000000022E-5},"Denominator (D)"]
[null,"a=",{"$f":"(n*sumx2*sumx2y+sumx*sumx3*sumy+sumx*sumx2*sumxy-sumx2^2*sumy-sumx^2*sumx2y-n*sumx3*sumxy)/D","v":0},null," (coefficient of the X2 term; equals zero if best-fit line is straight)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a=",{"$f":"10^-10+(U59*sumx2*sumx2y+sumx*sumx3*sumy+sumx*sumx2*sumxy-sumx2^2*sumy-sumx^2*sumx2y-U59*sumx3*sumxy)/D","v":1E-10}," (coefficient of the X2 term; equals zero if best-fit line is straight)",null,null,null,null,null,null,null,"a=",{"$f":"10^-10+(AE59*AH58*AK58+AE58*AI58*AF58+AE58*AH58*AG58-AH58^2*AF58-AE58^2*AK58-AE59*AI58*AG58)/AE61","v":6.0000000000999965}," (coefficient of the X2 term; equals zero if best-fit line is straight)"]
[null,"b=",{"$f":"(n*sumx4*sumxy+sumx*sumx2*sumx2y+sumx2*sumx3*sumy-sumx2^2*sumxy-sumx*sumx4*sumy-n*sumx3*sumx2y)/D","v":0},null," (coefficient of the X term, like the slope)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b=",{"$f":"(U59*sumx4*sumxy+sumx*sumx2*sumx2y+sumx2*sumx3*sumy-sumx2^2*sumxy-sumx*sumx4*sumy-U59*sumx3*sumx2y)/D","v":0}," (coefficient of the X term, like the slope)",null,null,null,null,null,null,null,"b=",{"$f":"(AE59*AJ58*AG58+AE58*AH58*AK58+AH58*AI58*AF58-AH58^2*AG58-AE58*AJ58*AF58-AE59*AI58*AK58)/AE61","v":1.3999999999999997}," (coefficient of the X term, like the slope)"]
[null,"c=",{"$f":"(sumx2*sumx4*sumy+sumx2*sumx3*sumxy+sumx*sumx3*sumx2y-sumx2^2*sumx2y-sumx*sumx4*sumxy-sumx3^2*sumy)/D","v":0},null," (the constant, like the intercept)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c=",{"$f":"(sumx2*sumx4*sumy+sumx2*sumx3*sumxy+sumx*sumx3*sumx2y-sumx2^2*sumx2y-sumx*sumx4*sumxy-sumx3^2*sumy)/D","v":0}," (the constant, like the intercept)",null,null,null,null,null,null,null,"c=",{"$f":"(AH58*AJ58*AF58+AH58*AI58*AG58+AE58*AI58*AK58-AH58^2*AK58-AE58*AJ58*AG58-AI58^2*AF58)/AE61","v":-4.2351647362714978E-18}," (the constant, like the intercept)"]
[null,"y=",{"$f":"a","v":1E-10},null,"X^2","+",{"$f":"b","v":0},"x","+",{"$f":"_c","v":0},null,null,null,null,null,null,"Equation of best fit (POST) =>",null,null,"y=",{"$f":"a","v":1E-10},"X^2","+",{"$f":"b","v":0},"x","+",{"$f":"_c","v":0},null,"Equation of best fit (PRE) =>","y=",{"$f":"AE62","v":6.0000000000999965},"X^2","+",{"$f":"AE63","v":1.3999999999999997},"x","+",{"$f":"AE64","v":-4.2351647362714978E-18}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculation of post-calibration R2 ",null,null,null,null,null,null,null,null,null,"Calculation of pre-calibration R2 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Σ(Y-meany)^2","PredY",null,"Σ(Y-PredY)^2",null,"Σ(meanY-PredY)^2",null,null,null,null,"Σ(Y-meany)^2","PredY",null,"Σ(Y-PredY)^2",null,"Σ(meanY-PredY)^2"]
[null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(E6)=1,(Y6-$V$58/$U$59)^2,0)","v":0},{"$f":"IF(COUNT(E6)=1,a*J6^2+b*J6+_c,0)","v":0},null,{"$f":"IF(COUNT(E6)=1,(Y6-V70)^2,0)","v":0},null,{"$f":"IF(COUNT(E6)=1,($V$58/$U$59-V70)^2,0)","v":0}," ",null,null,null,{"$f":"IF(COUNT(D6)=1,(AE6-$AF$58/$AE$59)^2,0)","v":9.999999999999995E-3},{"$f":"IF(COUNT(D6)=1,$AE$62*K6^2+$AE$63*K6+$AE$64,0)","v":0.20000000000099996},null,{"$f":"IF(COUNT(D6)=1,(AE6-AF70)^2,0)","v":9.9990024789627036E-25},null,{"$f":"IF(COUNT(D6)=1,($AF$58/$AE$59-AF70)^2,0)","v":9.9999999998000057E-3}," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0.52000000000399993,null,4.8400000001759973E-2,null,4.8400000001759973E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,1.0000000000000007E-2,0.96000000000899943,null,0.31360000001007932,null,0.43560000001187921]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,null,0,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U70:U89)","v":0},{"$f":"SUM(V70:V89)","v":0}," ",{"$f":"SUM(X70:X89)","v":0}," ",{"$f":"SUM(Z70:Z89)","v":0},null,null,null,null,{"$f":"SUM(AE70:AE89)","v":2.0000000000000004E-2},{"$f":"SUM(AF70:AF89)","v":1.6800000000139992}," ",{"$f":"SUM(AH70:AH89)","v":0.3620000000118393}," ",{"$f":"SUM(AJ70:AJ89)","v":0.49400000001343919}]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R2=",{"$f":"1-(X90/Z90)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"R2=",{"$f":"1-(AH90/AJ90)","v":0.26720647772876283}]
[null,null," "]
[]
[]
[null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "," "]

{"sheet":"Sheet2","index":1,"n_rows":65,"n_cols":8,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["Post-calibration"]
["Data for fitted curve plot",null,null,null,"Post-calibration Residuals"]
["point","X","Ypredicted",null,"Concentrations of the standards","Predicted readings","Actual-predicted","Residuals (% of max reading)"]
[1,{"$f":"MIN('Time-Drifting Sensor'!C6:C25)","v":0.1},{"$f":"a*B4^2+b*B4+_c","v":1.0000000000000002E-12},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E6)=1,'Time-Drifting Sensor'!C6)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E6)=1,a*E4^2+b*E4+_c)","v":false},{"$f":"F4-'Time-Drifting Sensor'!E6","v":0},{"$f":"IF(COUNT($E4)=1,-G4/MAX($F$4:$F$23),\"\")","v":""}]
[2,{"$f":"$B$4+(A4*($B$32-$B$4)/29)","v":0.10689655172413794},1.1426872770511297E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E7)=1,'Time-Drifting Sensor'!C7)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E7)=1,a*E5^2+b*E5+_c)","v":false},{"$f":"F5-'Time-Drifting Sensor'!E7","v":0},""]
[3,0.11379310344827587,1.2948870392390013E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E8)=1,'Time-Drifting Sensor'!C8)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E8)=1,a*E6^2+b*E6+_c)","v":false},{"$f":"F6-'Time-Drifting Sensor'!E8","v":0},""]
[4,0.1206896551724138,1.4565992865636151E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E9)=1,'Time-Drifting Sensor'!C9)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E9)=1,a*E7^2+b*E7+_c)","v":false},{"$f":"F7-'Time-Drifting Sensor'!E9","v":0},""]
[5,0.12758620689655173,1.6278240190249704E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E10)=1,'Time-Drifting Sensor'!C10)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E10)=1,a*E8^2+b*E8+_c)","v":false},{"$f":"F8-'Time-Drifting Sensor'!E10","v":0},""]
[6,0.13448275862068965,1.8085612366230676E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E11)=1,'Time-Drifting Sensor'!C11)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E11)=1,a*E9^2+b*E9+_c)","v":false},{"$f":"F9-'Time-Drifting Sensor'!E11","v":0},""]
[7,0.14137931034482759,1.9988109393579072E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E12)=1,'Time-Drifting Sensor'!C12)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E12)=1,a*E10^2+b*E10+_c)","v":false},{"$f":"F10-'Time-Drifting Sensor'!E12","v":0},""]
[8,0.14827586206896554,2.1985731272294894E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E13)=1,'Time-Drifting Sensor'!C13)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E13)=1,a*E11^2+b*E11+_c)","v":false},{"$f":"F11-'Time-Drifting Sensor'!E13","v":0},""]
[9,0.15517241379310345,2.4078478002378124E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E14)=1,'Time-Drifting Sensor'!C14)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E14)=1,a*E12^2+b*E12+_c)","v":false},{"$f":"F12-'Time-Drifting Sensor'!E14","v":0},""]
[10,0.16206896551724137,2.6266349583828771E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E15)=1,'Time-Drifting Sensor'!C15)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E15)=1,a*E13^2+b*E13+_c)","v":false},{"$f":"F13-'Time-Drifting Sensor'!E15","v":0},""]
[11,0.16896551724137931,2.8549346016646853E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E16)=1,'Time-Drifting Sensor'!C16)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E16)=1,a*E14^2+b*E14+_c)","v":false},{"$f":"F14-'Time-Drifting Sensor'!E16","v":0},""]
[12,0.17586206896551723,3.0927467300832339E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E17)=1,'Time-Drifting Sensor'!C17)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E17)=1,a*E15^2+b*E15+_c)","v":false},{"$f":"F15-'Time-Drifting Sensor'!E17","v":0},""]
[13,0.18275862068965518,3.3400713436385262E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E18)=1,'Time-Drifting Sensor'!C18)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E18)=1,a*E16^2+b*E16+_c)","v":false},{"$f":"F16-'Time-Drifting Sensor'!E18","v":0},""]
[14,0.18965517241379309,3.5969084423305585E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E19)=1,'Time-Drifting Sensor'!C19)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E19)=1,a*E17^2+b*E17+_c)","v":false},{"$f":"F17-'Time-Drifting Sensor'!E19","v":0},""]
[15,0.19655172413793104,3.8632580261593343E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E20)=1,'Time-Drifting Sensor'!C20)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E20)=1,a*E18^2+b*E18+_c)","v":false},{"$f":"F18-'Time-Drifting Sensor'!E20","v":0},""]
[16,0.20344827586206896,4.139120095124851E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E21)=1,'Time-Drifting Sensor'!C21)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E21)=1,a*E19^2+b*E19+_c)","v":false},{"$f":"F19-'Time-Drifting Sensor'!E21","v":0},""]
[17,0.21034482758620687,4.4244946492271097E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E22)=1,'Time-Drifting Sensor'!C22)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E22)=1,a*E20^2+b*E20+_c)","v":false},{"$f":"F20-'Time-Drifting Sensor'!E22","v":0},""]
[18,0.21724137931034482,4.719381688466112E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E23)=1,'Time-Drifting Sensor'!C23)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E23)=1,a*E21^2+b*E21+_c)","v":false},{"$f":"F21-'Time-Drifting Sensor'!E23","v":0},""]
[19,0.22413793103448276,5.0237812128418555E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E24)=1,'Time-Drifting Sensor'!C24)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E24)=1,a*E22^2+b*E22+_c)","v":false},{"$f":"F22-'Time-Drifting Sensor'!E24","v":0},""]
[20,0.23103448275862068,5.3376932223543394E-12,null,{"$f":"IF(COUNT('Time-Drifting Sensor'!E25)=1,'Time-Drifting Sensor'!C25)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!E25)=1,a*E23^2+b*E23+_c)","v":false},{"$f":"F23-'Time-Drifting Sensor'!E25","v":0},""]
[21,0.23793103448275862,5.661117717003567E-12,null,null,null,null,{"$f":"IF(COUNT(E24)=1,a*E24^2+b*E24+_c,\"\")","v":""}]
[22,0.24482758620689654,5.9940546967895357E-12,null,null,null,null,{"$f":"IF(COUNT(E25)=1,a*E25^2+b*E25+_c,\"\")","v":""}]
[23,0.25172413793103443,6.3365041617122449E-12,null,null,null,null,{"$f":"IF(COUNT(E26)=1,a*E26^2+b*E26+_c,\"\")","v":""}]
[24,0.25862068965517238,6.6884661117716992E-12,null,null,null,null,{"$f":"IF(COUNT(E27)=1,a*E27^2+b*E27+_c,\"\")","v":""}]
[25,0.26551724137931032,7.049940546967894E-12,null,null,null,null,{"$f":"IF(COUNT(E28)=1,a*E28^2+b*E28+_c,\"\")","v":""}]
[26,0.27241379310344827,7.4209274673008324E-12]
[27,0.27931034482758621,7.8014268727705112E-12]
[28,0.28620689655172415,8.1914387633769336E-12]
[29,{"$f":"MAX('Time-Drifting Sensor'!C6:C25)","v":0.3},8.9999999999999996E-12]
[]
["Pre-calibration"]
["Data for fitted curve plot",null,null,null,"Pre-calibration Residuals"]
["point","X","Ypredicted",null,"Concentrations of the standards","Predicted readings","Actual-predicted","Residuals (% of max reading)"]
[1,{"$f":"MIN('Time-Drifting Sensor'!C6:C25)","v":0.1},{"$f":"'Time-Drifting Sensor'!$AE$62*B37^2+'Time-Drifting Sensor'!$AE$63*B37+'Time-Drifting Sensor'!$AE$64","v":0.20000000000099996},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D6)=1,'Time-Drifting Sensor'!C6)","v":0.1},{"$f":"IF(COUNT('Time-Drifting Sensor'!D6)=1,'Time-Drifting Sensor'!$AE$62*E37^2+'Time-Drifting Sensor'!$AE$63*E37+'Time-Drifting Sensor'!$AE$64)","v":0.20000000000099996},{"$f":"F37-'Time-Drifting Sensor'!D6","v":9.9995012270426287E-13},{"$f":"IF(COUNT($E37)=1,-G37/MAX($F$4:$F$23),\"\")","v":{"$error":"#DIV/0!"}}]
[2,{"$f":"$B$37+(A37*($B$32-$B$4)/29)","v":0.10689655172413794},{"$f":"'Time-Drifting Sensor'!$AE$62*B38^2+'Time-Drifting Sensor'!$AE$63*B38+'Time-Drifting Sensor'!$AE$64","v":0.21821640903800352},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D7)=1,'Time-Drifting Sensor'!C7)","v":0.2},{"$f":"IF(COUNT('Time-Drifting Sensor'!D7)=1,'Time-Drifting Sensor'!$AE$62*E38^2+'Time-Drifting Sensor'!$AE$63*E38+'Time-Drifting Sensor'!$AE$64)","v":0.52000000000399993},{"$f":"F38-'Time-Drifting Sensor'!D7","v":0.22000000000399994},{"$error":"#DIV/0!"}]
[3,0.11379310344827587,{"$f":"'Time-Drifting Sensor'!$AE$62*B39^2+'Time-Drifting Sensor'!$AE$63*B39+'Time-Drifting Sensor'!$AE$64","v":0.2370035671832211},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D8)=1,'Time-Drifting Sensor'!C8)","v":0.3},{"$f":"IF(COUNT('Time-Drifting Sensor'!D8)=1,'Time-Drifting Sensor'!$AE$62*E39^2+'Time-Drifting Sensor'!$AE$63*E39+'Time-Drifting Sensor'!$AE$64)","v":0.96000000000899943},{"$f":"F39-'Time-Drifting Sensor'!D8","v":0.56000000000899941},{"$error":"#DIV/0!"}]
[4,0.1206896551724138,{"$f":"'Time-Drifting Sensor'!$AE$62*B40^2+'Time-Drifting Sensor'!$AE$63*B40+'Time-Drifting Sensor'!$AE$64","v":0.25636147443665275},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D9)=1,'Time-Drifting Sensor'!C9)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!D9)=1,'Time-Drifting Sensor'!$AE$62*E40^2+'Time-Drifting Sensor'!$AE$63*E40+'Time-Drifting Sensor'!$AE$64)","v":false},{"$f":"F40-'Time-Drifting Sensor'!D9","v":0},""]
[5,0.12758620689655173,{"$f":"'Time-Drifting Sensor'!$AE$62*B41^2+'Time-Drifting Sensor'!$AE$63*B41+'Time-Drifting Sensor'!$AE$64","v":0.27629013079829839},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D10)=1,'Time-Drifting Sensor'!C10)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!D10)=1,'Time-Drifting Sensor'!$AE$62*E41^2+'Time-Drifting Sensor'!$AE$63*E41+'Time-Drifting Sensor'!$AE$64)","v":false},{"$f":"F41-'Time-Drifting Sensor'!D10","v":0},""]
[6,0.13448275862068965,{"$f":"'Time-Drifting Sensor'!$AE$62*B42^2+'Time-Drifting Sensor'!$AE$63*B42+'Time-Drifting Sensor'!$AE$64","v":0.29678953626815802},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D11)=1,'Time-Drifting Sensor'!C11)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!D11)=1,'Time-Drifting Sensor'!$AE$62*E42^2+'Time-Drifting Sensor'!$AE$63*E42+'Time-Drifting Sensor'!$AE$64)","v":false},{"$f":"F42-'Time-Drifting Sensor'!D11","v":0},""]
[7,0.14137931034482759,{"$f":"'Time-Drifting Sensor'!$AE$62*B43^2+'Time-Drifting Sensor'!$AE$63*B43+'Time-Drifting Sensor'!$AE$64","v":0.31785969084623178},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D12)=1,'Time-Drifting Sensor'!C12)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!D12)=1,'Time-Drifting Sensor'!$AE$62*E43^2+'Time-Drifting Sensor'!$AE$63*E43+'Time-Drifting Sensor'!$AE$64)","v":false},{"$f":"F43-'Time-Drifting Sensor'!D12","v":0},""]
[8,0.14827586206896554,{"$f":"'Time-Drifting Sensor'!$AE$62*B44^2+'Time-Drifting Sensor'!$AE$63*B44+'Time-Drifting Sensor'!$AE$64","v":0.33950059453251957},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D13)=1,'Time-Drifting Sensor'!C13)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!D13)=1,'Time-Drifting Sensor'!$AE$62*E44^2+'Time-Drifting Sensor'!$AE$63*E44+'Time-Drifting Sensor'!$AE$64)","v":false},{"$f":"F44-'Time-Drifting Sensor'!D13","v":0},""]
[9,0.15517241379310345,{"$f":"'Time-Drifting Sensor'!$AE$62*B45^2+'Time-Drifting Sensor'!$AE$63*B45+'Time-Drifting Sensor'!$AE$64","v":0.36171224732702129},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D14)=1,'Time-Drifting Sensor'!C14)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!D14)=1,'Time-Drifting Sensor'!$AE$62*E45^2+'Time-Drifting Sensor'!$AE$63*E45+'Time-Drifting Sensor'!$AE$64)","v":false},{"$f":"F45-'Time-Drifting Sensor'!D14","v":0},""]
[10,0.16206896551724137,{"$f":"'Time-Drifting Sensor'!$AE$62*B46^2+'Time-Drifting Sensor'!$AE$63*B46+'Time-Drifting Sensor'!$AE$64","v":0.38449464922973703},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D15)=1,'Time-Drifting Sensor'!C15)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!D15)=1,'Time-Drifting Sensor'!$AE$62*E46^2+'Time-Drifting Sensor'!$AE$63*E46+'Time-Drifting Sensor'!$AE$64)","v":false},{"$f":"F46-'Time-Drifting Sensor'!D15","v":0},""]
[11,0.16896551724137931,{"$f":"'Time-Drifting Sensor'!$AE$62*B47^2+'Time-Drifting Sensor'!$AE$63*B47+'Time-Drifting Sensor'!$AE$64","v":0.40784780024066691},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D16)=1,'Time-Drifting Sensor'!C16)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!D16)=1,'Time-Drifting Sensor'!$AE$62*E47^2+'Time-Drifting Sensor'!$AE$63*E47+'Time-Drifting Sensor'!$AE$64)","v":false},{"$f":"F47-'Time-Drifting Sensor'!D16","v":0},""]
[12,0.17586206896551723,{"$f":"'Time-Drifting Sensor'!$AE$62*B48^2+'Time-Drifting Sensor'!$AE$63*B48+'Time-Drifting Sensor'!$AE$64","v":0.43177170035981072},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D17)=1,'Time-Drifting Sensor'!C17)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!D17)=1,'Time-Drifting Sensor'!$AE$62*E48^2+'Time-Drifting Sensor'!$AE$63*E48+'Time-Drifting Sensor'!$AE$64)","v":false},{"$f":"F48-'Time-Drifting Sensor'!D17","v":0},""]
[13,0.18275862068965518,{"$f":"'Time-Drifting Sensor'!$AE$62*B49^2+'Time-Drifting Sensor'!$AE$63*B49+'Time-Drifting Sensor'!$AE$64","v":0.45626634958716866},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D18)=1,'Time-Drifting Sensor'!C18)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!D18)=1,'Time-Drifting Sensor'!$AE$62*E49^2+'Time-Drifting Sensor'!$AE$63*E49+'Time-Drifting Sensor'!$AE$64)","v":false},{"$f":"F49-'Time-Drifting Sensor'!D18","v":0},""]
[14,0.18965517241379309,{"$f":"'Time-Drifting Sensor'!$AE$62*B50^2+'Time-Drifting Sensor'!$AE$63*B50+'Time-Drifting Sensor'!$AE$64","v":0.48133174792274058},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D19)=1,'Time-Drifting Sensor'!C19)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!D19)=1,'Time-Drifting Sensor'!$AE$62*E50^2+'Time-Drifting Sensor'!$AE$63*E50+'Time-Drifting Sensor'!$AE$64)","v":false},{"$f":"F50-'Time-Drifting Sensor'!D19","v":0},""]
[15,0.19655172413793104,{"$f":"'Time-Drifting Sensor'!$AE$62*B51^2+'Time-Drifting Sensor'!$AE$63*B51+'Time-Drifting Sensor'!$AE$64","v":0.50696789536652653},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D20)=1,'Time-Drifting Sensor'!C20)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!D20)=1,'Time-Drifting Sensor'!$AE$62*E51^2+'Time-Drifting Sensor'!$AE$63*E51+'Time-Drifting Sensor'!$AE$64)","v":false},{"$f":"F51-'Time-Drifting Sensor'!D20","v":0},""]
[16,0.20344827586206896,{"$f":"'Time-Drifting Sensor'!$AE$62*B52^2+'Time-Drifting Sensor'!$AE$63*B52+'Time-Drifting Sensor'!$AE$64","v":0.53317479191852646},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D21)=1,'Time-Drifting Sensor'!C21)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!D21)=1,'Time-Drifting Sensor'!$AE$62*E52^2+'Time-Drifting Sensor'!$AE$63*E52+'Time-Drifting Sensor'!$AE$64)","v":false},{"$f":"F52-'Time-Drifting Sensor'!D21","v":0},""]
[17,0.21034482758620687,{"$f":"'Time-Drifting Sensor'!$AE$62*B53^2+'Time-Drifting Sensor'!$AE$63*B53+'Time-Drifting Sensor'!$AE$64","v":0.55995243757874058},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D22)=1,'Time-Drifting Sensor'!C22)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!D22)=1,'Time-Drifting Sensor'!$AE$62*E53^2+'Time-Drifting Sensor'!$AE$63*E53+'Time-Drifting Sensor'!$AE$64)","v":false},{"$f":"F53-'Time-Drifting Sensor'!D22","v":0},""]
[18,0.21724137931034482,{"$f":"'Time-Drifting Sensor'!$AE$62*B54^2+'Time-Drifting Sensor'!$AE$63*B54+'Time-Drifting Sensor'!$AE$64","v":0.58730083234716857},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D23)=1,'Time-Drifting Sensor'!C23)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!D23)=1,'Time-Drifting Sensor'!$AE$62*E54^2+'Time-Drifting Sensor'!$AE$63*E54+'Time-Drifting Sensor'!$AE$64)","v":false},{"$f":"F54-'Time-Drifting Sensor'!D23","v":0},""]
[19,0.22413793103448276,{"$f":"'Time-Drifting Sensor'!$AE$62*B55^2+'Time-Drifting Sensor'!$AE$63*B55+'Time-Drifting Sensor'!$AE$64","v":0.61521997622381075},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D24)=1,'Time-Drifting Sensor'!C24)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!D24)=1,'Time-Drifting Sensor'!$AE$62*E55^2+'Time-Drifting Sensor'!$AE$63*E55+'Time-Drifting Sensor'!$AE$64)","v":false},{"$f":"F55-'Time-Drifting Sensor'!D24","v":0},""]
[20,0.23103448275862068,{"$f":"'Time-Drifting Sensor'!$AE$62*B56^2+'Time-Drifting Sensor'!$AE$63*B56+'Time-Drifting Sensor'!$AE$64","v":0.64370986920866669},null,{"$f":"IF(COUNT('Time-Drifting Sensor'!D25)=1,'Time-Drifting Sensor'!C25)","v":false},{"$f":"IF(COUNT('Time-Drifting Sensor'!D25)=1,'Time-Drifting Sensor'!$AE$62*E56^2+'Time-Drifting Sensor'!$AE$63*E56+'Time-Drifting Sensor'!$AE$64)","v":false},{"$f":"F56-'Time-Drifting Sensor'!D25","v":0},""]
[21,0.23793103448275862,{"$f":"'Time-Drifting Sensor'!$AE$62*B57^2+'Time-Drifting Sensor'!$AE$63*B57+'Time-Drifting Sensor'!$AE$64","v":0.67277051130173704},null,null,null,null,{"$f":"IF(COUNT(E57)=1,a*E57^2+b*E57+_c,\"\")","v":""}]
[22,0.24482758620689654,{"$f":"'Time-Drifting Sensor'!$AE$62*B58^2+'Time-Drifting Sensor'!$AE$63*B58+'Time-Drifting Sensor'!$AE$64","v":0.70240190250302104},null,null,null,null,{"$f":"IF(COUNT(E58)=1,a*E58^2+b*E58+_c,\"\")","v":""}]
[23,0.25172413793103443,{"$f":"'Time-Drifting Sensor'!$AE$62*B59^2+'Time-Drifting Sensor'!$AE$63*B59+'Time-Drifting Sensor'!$AE$64","v":0.73260404281251912},null,null,null,null,{"$f":"IF(COUNT(E59)=1,a*E59^2+b*E59+_c,\"\")","v":""}]
[24,0.25862068965517238,{"$f":"'Time-Drifting Sensor'!$AE$62*B60^2+'Time-Drifting Sensor'!$AE$63*B60+'Time-Drifting Sensor'!$AE$64","v":0.7633769322302314},null,null,null,null,{"$f":"IF(COUNT(E60)=1,a*E60^2+b*E60+_c,\"\")","v":""}]
[25,0.26551724137931032,{"$f":"'Time-Drifting Sensor'!$AE$62*B61^2+'Time-Drifting Sensor'!$AE$63*B61+'Time-Drifting Sensor'!$AE$64","v":0.79472057075615765},null,null,null,null,{"$f":"IF(COUNT(E61)=1,a*E61^2+b*E61+_c,\"\")","v":""}]
[26,0.27241379310344827,{"$f":"'Time-Drifting Sensor'!$AE$62*B62^2+'Time-Drifting Sensor'!$AE$63*B62+'Time-Drifting Sensor'!$AE$64","v":0.8266349583902981}]
[27,0.27931034482758621,{"$f":"'Time-Drifting Sensor'!$AE$62*B63^2+'Time-Drifting Sensor'!$AE$63*B63+'Time-Drifting Sensor'!$AE$64","v":0.85912009513265253}]
[28,0.28620689655172415,{"$f":"'Time-Drifting Sensor'!$AE$62*B64^2+'Time-Drifting Sensor'!$AE$63*B64+'Time-Drifting Sensor'!$AE$64","v":0.89217598098322082}]
[29,{"$f":"MAX('Time-Drifting Sensor'!C6:C25)","v":0.3},{"$f":"'Time-Drifting Sensor'!$AE$62*B65^2+'Time-Drifting Sensor'!$AE$63*B65+'Time-Drifting Sensor'!$AE$64","v":0.96000000000899943}]