{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"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":"1904"}

{"sheet":"Sheet1","index":0,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Added concentration","Absorbance"]
[0,{"$f":"(2+2*A2+RAND())/10","v":0.2007567550582193}]
[1,{"$f":"(2+2*A3+RAND())/10","v":0.47316684448547164}]
[2,0.61372112663978817]
[3,0.82059499627226129]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"m","b","sy","sample conc","sx","table t (95%)","t sx"]
[null,null,null,null,{"$f":"SLOPE(B2:B34,A2:A34)","v":0.20000690057964424},{"$f":"INTERCEPT(B2:B34,A2:A34)","v":0.22704957974446871},{"$f":"STEYX(B2:B34,A2:A34)","v":3.8970651652782351E-2},{"$f":"F30/E30","v":1.1352087307310474},{"$f":"G30/ABS(E30)*SQRT(1/H32+AVERAGE(B2:B34)^2/E30^2/DEVSQ(A2:A34))","v":0.24943895579745451},{"$f":"TINV(0.05,COUNT(A2:A34)-2)","v":4.3026527297494637},{"$f":"J30*I30","v":1.0732492040677735}]
[null,null,null,null,"sm","sb","D","N","DF"]
[null,null,null,null,{"$f":"G30*SQRT(H32/G32)","v":1.7428205244617172E-2},{"$f":"G30*SQRT(SUMSQ(A2:A34)/G32)","v":3.2605186445867095E-2},{"$f":"VARP(A2:A34)*H32^2","v":20},{"$f":"COUNT(A2:A34)","v":4},{"$f":"H32-2","v":2}]
[null,null,null,null,null,null,"Dilution and unit conversion factor","sample conc","sx","table t (95%)","t sx"]
[null,null,null,null,null,null,25,{"$f":"H30*G34","v":28.380218268276185},{"$f":"I30/H30*H34","v":6.2359738949363628},{"$f":"J30","v":4.3026527297494637},{"$f":"J34*I34","v":26.831230101694338}]

{"sheet":"Sheet2","index":1,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Added concentration","Absorbance"]
[0,{"$f":"(2+2*A2+RAND())/10","v":0.29295568604797795}]
[1,{"$f":"(2+2*A3+RAND())/10","v":0.46688476712105764}]
[2,0.64580418382289573]
[3,0.84098299508701246]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"m","b","sy","sample conc","sx","table t (95%)","t sx"]
[null,null,null,null,{"$f":"SLOPE(B2:B34,A2:A34)","v":0.18230013438189416},{"$f":"INTERCEPT(B2:B34,A2:A34)","v":0.28820670644689478},{"$f":"STEYX(B2:B34,A2:A34)","v":7.721312801600334E-3},{"$f":"F30/E30","v":1.5809462095246769},{"$f":"G30/ABS(E30)*SQRT(1/H32+AVERAGE(B2:B34)^2/E30^2/DEVSQ(A2:A34))","v":6.208209584346365E-2},{"$f":"TINV(0.05,COUNT(A2:A34)-2)","v":4.3026527297494637},{"$f":"J30*I30","v":0.26711769914944672}]
[null,null,null,null,"sm","sb","D","N","DF"]
[null,null,null,null,{"$f":"G30*SQRT(H32/G32)","v":3.4530760599835388E-3},{"$f":"G30*SQRT(SUMSQ(A2:A34)/G32)","v":6.4601137734648329E-3},{"$f":"VARP(A2:A34)*H32^2","v":20},{"$f":"COUNT(A2:A34)","v":4},{"$f":"H32-2","v":2}]
[null,null,null,null,null,null,"Dilution and unit conversion factor","sample conc","sx","table t (95%)","t sx"]
[null,null,null,null,null,null,25,{"$f":"H30*G34","v":39.523655238116923},{"$f":"I30/H30*H34","v":1.5520523960865911},{"$f":"J30","v":4.3026527297494637},{"$f":"J34*I34","v":6.677942478736167}]
[null,null,null,null,null,null,null,"known","t-test"]
[null,null,null,null,null,null,null,18,{"$f":"IF(H36<>\"\",ABS((H34-H36)/I34),\"\")","v":13.867866376410715}]

{"sheet":"Sheet3","index":2,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Added concentration","Absorbance"]
[0,{"$f":"(2+2*A2+RAND())/10","v":0.24482428275687021}]
[1,{"$f":"(2+2*A3+RAND())/10","v":0.40831378147762348}]
[2,0.61903450907443225]
[3,0.85550912948931845]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"m","b","sy","sample conc","sx","table t (95%)","t sx"]
[null,null,null,null,{"$f":"SLOPE(B2:B34,A2:A34)","v":0.20427752677941538},{"$f":"INTERCEPT(B2:B34,A2:A34)","v":0.22550413553043802},{"$f":"STEYX(B2:B34,A2:A34)","v":2.6026628627082882E-2},{"$f":"F30/E30","v":1.1039106410072397},{"$f":"G30/ABS(E30)*SQRT(1/H32+AVERAGE(B2:B34)^2/E30^2/DEVSQ(A2:A34))","v":0.16146543834811683},{"$f":"TINV(0.05,COUNT(A2:A34)-2)","v":4.3026527297494637},{"$f":"J30*I30","v":0.69472970906871856}]
[null,null,null,null,"sm","sb","D","N","DF"]
[null,null,null,null,{"$f":"G30*SQRT(H32/G32)","v":1.1639462167059869E-2},{"$f":"G30*SQRT(SUMSQ(A2:A34)/G32)","v":2.1775439797727694E-2},{"$f":"VARP(A2:A34)*H32^2","v":20},{"$f":"COUNT(A2:A34)","v":4},{"$f":"H32-2","v":2}]
[null,null,null,null,null,null,"Dilution and unit conversion factor","sample conc","sx","table t (95%)","t sx"]
[null,null,null,null,null,null,25,{"$f":"H30*G34","v":27.597766025180992},{"$f":"I30/H30*H34","v":4.036635958702921},{"$f":"J30","v":4.3026527297494637},{"$f":"J34*I34","v":17.368242726717966}]
[null,null,null,null,null,null,null,"known","t-test"]
[null,null,null,null,null,null,null,18,{"$f":"IF(H36<>\"\",ABS((H34-H36)/I34),\"\")","v":2.3776645016720828}]