{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Standard Addition"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"1900"}

{"sheet":"Standard Addition","index":0,"n_rows":60,"n_cols":60,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Standard_Addition_1.0.xlsm",null,null,null,null,null,null,null,null,"Author: Bo Svensmark, svensmark@plen.ku.dk, Analytical Chemistry, PLEN, 2023",null,null,null,null,null,null,null,null,"Instructions:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delete all values in  Table 1 & 2 and the blue and green tables ",null,null,null,null,null,"Vo:","Volume of sample",null,null,null,null,"The sheet is protected - to Unprotect go to Review (no password needed)"]
["Date and headings:",null,null,null,null,null,null,null,null,"Confidence Interval %",null,95,null,null,null,null,null,null,"Enter data in Table 1  (the Name is optional)   --------------->",null,null,null,null,null,"Vtotal:","Volume of sample + Standards"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter response in Table 2",null,null,null,null,null,null,"Constant volume: Vtotal>0; for increasing volumes set Vtotal = 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,"If the confidence interval for an unknown koncentration",null,null,null,null,null,"Press Update",null,null,null,null,null,"Cs:","Conc. of standard stock solution"]
[null,null,null,null,null,null,null,null,null,null,null,null,"includes zero, the concentration is given as n.d., not detected",null,null,null,null,null,null,null,null,null,null,null,"Vs1-12","The volume of standard added"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(The calculated concentration is given in Xo-raw anyway)",null,null,null,null,null,"The response may be checked in the graph using the Sample # and the buttons Plot data and Plot Next"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G43=G42,\"          Ok\",\"Please Update calculations\")","v":"          Ok"}]
[null,null,null,null,null,null,"Sample #",5,null,"Sample #",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
[null,null,null,null,null,null,null,null,null,"Name",{"$f":"IF(K23=\"\",\"\",K23)","v":"Test 1"},{"$f":"IF(L23=\"\",\"\",L23)","v":"Test 2"},"Test 3","Test 4","Test 5","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BH23=\"\",\"\",BH23)","v":""}]
[null,null,null,null,null,null,null,null,null,"Xo",8.0000000000000002E-3,8.0000000000000002E-3,"n.d.","n.d.","n.d."]
[null,null,null,null,null,null,null,null,null,"sXo",1.6999999999999999E-3,1.6999999999999999E-3,2.2000000000000001E-3,0.82,1]
[null,null,null,null,null,null,null,null,null,"RSD %",21,21,43,43,50]
[null,null,null,null,null,null,null,null,null,"CI",4.3E-3,4.3E-3,5.7000000000000002E-3,2,2.2999999999999998]
[null,null,null,null,null,null,null,null,null,"Xo-raw",7.8630000000000002E-3,7.8630000000000002E-3,5.1479999999999998E-3,1.9039999999999999,2.0859999999999999]
[]
[null,null,null,null,null,null,null,null,null,"Intercept",1.518,3.036,1.1220000000000001,4.3890000000000002,0.1933]
[null,null,null,null,null,null,null,null,null,"Slope",193,386.1,217.9,2.3050000000000002,9.2670000000000002E-2]
[null,null,null,null,null,null,null,null,null,"R2",0.99780000000000002,0.99780000000000002,0.99580000000000002,0.91959999999999997,0.97460000000000002]
[null,null,null,null,null,null,null,null,null,"N",7,7,7,8,12]
[null,null,null,null,null,null,null,null,null,"s(y/x)",0.43280000000000002,0.86570000000000003,0.66969999999999996,1.966,0.18329999999999999]
[null,null,null,null,null,null,null,null,null,"Table 1"]
[null,null,null,null,null,null,null,null,null,"Name","Test 1","Test 2","Test 3","Test 4","Test 5"]
[null,null,null,null,null,null,null,null,null,"Vo",100,100,100,1,1]
[null,null,null,null,null,null,null,null,null,"Vtotal",100,200,0,1,1]
[null,"Sample",null,null,null,"Xo","n.d.",null,null,"Cs",1,1,1,1,1]
[null,"Run","X","Y",null,"sXo",1,null,null,"Vs1",0,0,0,0,0]
[null,0,0,0.1,null,"RSD %",50,null,null,"Vs2",2,2,2,2,0]
[null,1,0,0.2,null,"CI",2.2999999999999998,null,null,"Vs3",4,4,4,3,0]
[null,2,0,0.3,null,"Xo-raw",2.0859999999999999,null,null,"Vs4",6,6,6,4,10]
[null,3,10,1.1000000000000001,null,null,null,null,null,"Vs5",8,8,8,5,10]
[null,4,10,1,null,"Intercept",0.1933,null,null,"Vs6",10,10,10,6,10]
[null,5,10,0.9,null,"Slope",9.2670000000000002E-2,null,null,"Vs7",12,12,12,7,20]
[null,6,20,2.4,null,"R2",0.97460000000000002,null,null,"Vs8",null,null,null,8,20]
[null,7,20,2.2999999999999998,null,"N",12,null,null,"Vs9",null,null,null,null,20]
[null,8,20,2.1,null,"s(y/x)",0.18329999999999999,null,null,"Vs10",null,null,null,null,30]
[null,9,30,2.8,null,"c1",0.40842459792396341,null,null,"Vs11",null,null,null,null,30]
[null,10,30,2.8,null,"c2",8.3333333333333329E-2,null,null,"Vs12",null,null,null,null,30]
[null,11,30,3,null,"c3",15,null,null,"Table 2"]
[null,12,null,null,null,"c4",1500,null,null,"Y1",2.1,2.1,2.1,7,0.1]
[null,null,null,null,null,null,null,null,null,"Y2",5,5,5,8.8000000000000007,0.2]
[null,"Line","X","Y",null,"Cheksum",1359.8999999999996,null,null,"Y3",9,9,9,10,0.3]
[null,"Min",{"$f":"-G30","v":-2.0859999999999999},0,null,"New sum",{"$f":"SUM(K23:BH52)","v":1359.8999999999996},null,null,"Y4",12.6,12.6,12.6,12,1.1000000000000001]
[null,"Max",{"$f":"MAX(C28:C40)","v":30},{"$f":"G32+C44*G33","v":2.9733999999999998},null,null,null,null,null,"Y5",17.3,17.3,17.3,14,1]
[null,null,null,null,null,null,null,null,null,"Y6",21,21,21,17,0.9]
[null,null,"Confidence interval for the line",null,null,null,null,null,null,"Y7",24.7,24.7,24.7,22,2.4]
[null,"#","CI","CI-","CI+",null,null,null,null,"Y8",null,null,null,25,2.2999999999999998]
[null,0,{"$f":"IF(C28=\"\",\"\",$G$37*SQRT($G$38+(C28-$G$39)^2/$G$40))","v":0.19728782403090314},{"$f":"IF(C48=\"\",\"\",$G$32+C28*$G$33-C48)","v":-3.9878240309031421E-3},{"$f":"IF(C48=\"\",\"\",$G$32+C28*$G$33+C48)","v":0.39058782403090314},null,null,null,null,"Y9",null,null,null,null,2.1]
[null,1,0.19728782403090314,-3.9878240309031421E-3,0.39058782403090314,null,null,null,null,"Y10",null,null,null,null,2.8]
[null,2,0.19728782403090314,-3.9878240309031421E-3,0.39058782403090314,null,null,null,null,"Y11",null,null,null,null,2.8]
[null,3,0.1291551981878202,0.99084480181217993,1.2491551981878204,null,null,null,null,"Y12",null,null,null,null,3]
[null,4,0.1291551981878202,0.99084480181217993,1.2491551981878204]
[null,5,0.1291551981878202,0.99084480181217993,1.2491551981878204]
[null,6,0.1291551981878202,1.9175448018121797,2.1758551981878202]
[null,7,0.1291551981878202,1.9175448018121797,2.1758551981878202]
[null,8,0.1291551981878202,1.9175448018121797,2.1758551981878202]
[null,9,0.19728782403090314,2.7761121759690965,3.1706878240309031]
[null,10,0.19728782403090314,2.7761121759690965,3.1706878240309031]
[null,11,0.19728782403090314,2.7761121759690965,3.1706878240309031]
[null,12,"","",""]