{"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":[]}
["Standard Conc","Absorbance"]
[0,{"$f":"(2*A2+RAND()/10)/10","v":9.3278503811999765E-3},{"$f":"IF(A2=\"\",IF(B2<>\"\",(B2-F$30)/E$30,\"\"),\"\")","v":""}]
[1,{"$f":"(2*A3+RAND()/10)/10","v":0.2008259635448682},{"$f":"IF(A3=\"\",IF(B3<>\"\",(B3-F$30)/E$30,\"\"),\"\")","v":""}]
[2,0.40141478088461635,""]
[3,0.60776568792774943,""]
[null,0.15,0.72424274795948151]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,"",null,"m","b","sy","average","sx","table t (95%)","t sx"]
[null,null,"",null,{"$f":"SLOPE(B2:B35,A2:A35)","v":0.19959023299793965},{"$f":"INTERCEPT(B2:B35,A2:A35)","v":5.4482211876989983E-3},{"$f":"STEYX(B2:B35,A2:A35)","v":5.2775636055779167E-3},{"$f":"AVERAGE(C2:C32)","v":0.72424274795948151},{"$f":"G30/ABS(E30)*SQRT(1/H32+(I32*H30^2+SUMSQ(A2:A35)-2*H30*SUM(A2:A35))/G32)","v":3.0953624222007429E-2},{"$f":"TINV(0.05,COUNT(A2:A35)-2)","v":4.3026527297494637},{"$f":"J30*I30","v":0.13318269575445937}]
[null,null,"",null,"sm","sb","D","k","N","DF"]
[null,null,"",null,{"$f":"G30*SQRT(I32/G32)","v":2.3601981955302218E-3},{"$f":"G30*SQRT(SUMSQ(A2:A35)/G32)","v":4.415526506278091E-3},{"$f":"VARP(A2:A35)*I32^2","v":20},{"$f":"COUNT(C2:C32)","v":1},{"$f":"COUNT(A2:A35)","v":4},{"$f":"COUNT(A2:A35)-2","v":2}]
[null,null,null,null,null,null,"Dilution and unit conversion factor","average","sx","table t (95%)","t sx"]
[null,null,null,null,null,null,25,{"$f":"H30*G34","v":18.106068698987038},{"$f":"I30/H30*H34","v":0.77384060555018563},{"$f":"J30","v":4.3026527297494637},{"$f":"J34*I34","v":3.3295673938614843}]

{"sheet":"Sheet2","index":1,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Standard Conc","Absorbance","Sample conc"]
[0,{"$f":"(2*A2+RAND()/10)/10","v":1.136374846505318E-3},{"$f":"IF(A2=\"\",IF(B2<>\"\",(B2-F$30)/E$30,\"\"),\"\")","v":""}]
[1,{"$f":"(2*A3+RAND()/10)/10","v":0.20712902025585053},{"$f":"IF(A3=\"\",IF(B3<>\"\",(B3-F$30)/E$30,\"\"),\"\")","v":""}]
[2,0.40066685106681499,""]
[3,0.60792962098680559,""]
[null,0.15,0.73425134600809916]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,"",null,"m","b","sy","average","sx","table t (95%)","t sx"]
[null,null,"",null,{"$f":"SLOPE(B2:B35,A2:A35)","v":0.20139175692318653},{"$f":"INTERCEPT(B2:B35,A2:A35)","v":2.1278314042143531E-3},{"$f":"STEYX(B2:B35,A2:A35)","v":4.1636690116496145E-3},{"$f":"AVERAGE(C2:C32)","v":0.73425134600809916},{"$f":"G30/ABS(E30)*SQRT(1/H32+(I32*H30^2+SUMSQ(A2:A35)-2*H30*SUM(A2:A35))/G32)","v":2.4174768116922082E-2},{"$f":"TINV(0.05,COUNT(A2:A35)-2)","v":4.3026527297494637},{"$f":"J30*I30","v":0.1040156320293351}]
[null,null,"",null,"sm","sb","D","k","N","DF"]
[null,null,"",null,{"$f":"G30*SQRT(I32/G32)","v":1.8620493891715803E-3},{"$f":"G30*SQRT(SUMSQ(A2:A35)/G32)","v":3.4835754257658744E-3},{"$f":"VARP(A2:A35)*I32^2","v":20},{"$f":"COUNT(C2:C32)","v":1},{"$f":"COUNT(A2:A35)","v":4},{"$f":"COUNT(A2:A35)-2","v":2}]
[null,null,null,null,null,null,"Dilution and unit conversion factor","average","sx","table t (95%)","t sx"]
[null,null,null,null,null,null,25,{"$f":"H30*G34","v":18.356283650202478},{"$f":"I30/H30*H34","v":0.60436920292305207},{"$f":"J30","v":4.3026527297494637},{"$f":"J34*I34","v":2.6003908007333774}]
[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":0.58951324534622229}]

{"sheet":"Sheet3","index":2,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Standard Conc","Absorbance","Sample conc"]
[0,{"$f":"(2*A2+RAND()/10)/10","v":1.6103052372531256E-3},{"$f":"IF(A2=\"\",IF(B2<>\"\",(B2-F$30)/E$30,\"\"),\"\")","v":""}]
[1,{"$f":"(2*A3+RAND()/10)/10","v":0.20488547619519659},{"$f":"IF(A3=\"\",IF(B3<>\"\",(B3-F$30)/E$30,\"\"),\"\")","v":""}]
[2,0.40385589836337282,""]
[3,0.60422558135805016,""]
[null,0.15,0.73438772609177694]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,"",null,"m","b","sy","average","sx","table t (95%)","t sx"]
[null,null,"",null,{"$f":"SLOPE(B2:B35,A2:A35)","v":0.2006816250530567},{"$f":"INTERCEPT(B2:B35,A2:A35)","v":2.6218777088831136E-3},{"$f":"STEYX(B2:B35,A2:A35)","v":1.3669768398411695E-3},{"$f":"AVERAGE(C2:C32)","v":0.73438772609177694},{"$f":"G30/ABS(E30)*SQRT(1/H32+(I32*H30^2+SUMSQ(A2:A35)-2*H30*SUM(A2:A35))/G32)","v":7.9647972148055093E-3},{"$f":"TINV(0.05,COUNT(A2:A35)-2)","v":4.3026527297494637},{"$f":"J30*I30","v":3.4269756478183852E-2}]
[null,null,"",null,"sm","sb","D","k","N","DF"]
[null,null,"",null,{"$f":"G30*SQRT(I32/G32)","v":6.1133062751053951E-4},{"$f":"G30*SQRT(SUMSQ(A2:A35)/G32)","v":1.1436948790929796E-3},{"$f":"VARP(A2:A35)*I32^2","v":20},{"$f":"COUNT(C2:C32)","v":1},{"$f":"COUNT(A2:A35)","v":4},{"$f":"COUNT(A2:A35)-2","v":2}]
[null,null,null,null,null,null,"Dilution and unit conversion factor","average","sx","table t (95%)","t sx"]
[null,null,null,null,null,null,25,{"$f":"H30*G34","v":18.359693152294422},{"$f":"I30/H30*H34","v":0.19911993037013773},{"$f":"J30","v":4.3026527297494637},{"$f":"J34*I34","v":0.8567439119545962}]
[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":1.8064146146787026}]