{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Input","2 factors","3 factors","Box_Behnken","Output","Runs"],"not_rendered":{"charts":16,"images":0,"macros":1,"external_links":0,"defined_names":2229,"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":"Input","index":0,"n_rows":53,"n_cols":42,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Response_Surface_1.3.xlsm",null,null,null,null,null,null,null,"Author: Bo Svensmark, svensmark@plen.ku.dk, Analytical Chemistry,ECP, PLEN, University of Copenhagen 2024"]
["Table 1:","Normalize?","Yes","Yes/No",null,null,null,null,"The sheet is protected. To unprotect all cells: Review -> Unprotect Sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE31<>\"\",AE31,\"\")","v":""},"","","","","","","",{"$f":"IF(AM33<>\"\",AM33,\"\")","v":""},{"$f":"IF(AN33<>\"\",AN33,\"\")","v":""},{"$f":"IF(AO33<>\"\",AO33,\"\")","v":""},{"$f":"IF(AP33<>\"\",AP33,\"\")","v":""}]
["Select (1/0) ?",null,2,2,2,2,2,2,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Relative areas",null,{"$f":"IF(D3>0,100*D29/$C$29,\"\")","v":99.999999999999986},13.421146783717637,1.4477833200518064,7.0995743308945229,35.456511178276699,7.262084691560737E-2,"","","","","","","","","","","","","","","","","","geometric mean, or ???",null,null,null,"1) Copy results to Table 2 (the white cells surronded by yellow in cell C33:Z53)"]
["Run #","Label","Mean",{"$f":"IF(D33<>\"\",D33,\"\")","v":"Butyrolactone "},{"$f":"IF(E33<>\"\",E33,\"\")","v":"Phenylethyl alcohol "},"Ethyl hydrogen succinate ","Diethyl succinate ","Tyrosol ","Acetyl-1-tyrosol ","","","","","","","","","","","","","","","","",""]
[1,{"$f":"IF(C34=\"\",\"\",C34)","v":"QUE1101A"},{"$f":"IF(C34<>\"\",AVERAGE(D6:Z6),\"\")","v":73.13810377695917},{"$f":"IF(AND(D$3>0,$C34<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D34/D$30,D34),0),\"\")","v":82.576891184698454},85.256832256533841,100,83.696485820069142,87.298413400453583,0,"","","","","","","","","","","","","","","","","",null,null,null,null,"2) Write \"Yes\" or \"No\" in table 1 cell C2 to analyse normalized data (100 = max) or raw unnormalized data"]
[2,{"$f":"IF(C35=\"\",\"\",C35)","v":"QUE1102A"},57.08800134953767,{"$f":"IF(AND(D$3>0,$C35<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D35/D$30,D35),0),\"\")","v":81.613725205875397},79.866241512168557,35.561344839049575,77.95165071769145,67.535045822441035,0,"","","","","","","","","","","","","","","","",""]
[3,"QUE1103B",55.160582095462473,{"$f":"IF(AND(D$3>0,$C36<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D36/D$30,D36),0),\"\")","v":86.696634128518809},92.710858345423034,0,90.432707618404621,61.12329248042839,0,"","","","","","","","","","","","","","","","","",null,null,null,null,"3) In Table 1 row 3 white cells enter a 1 for compounds which should be selected for analysis - and 0 if you want to skip them"]
[4,"QUE1104B",51.041943912266937,{"$f":"IF(AND(D$3>0,$C37<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D37/D$30,D37),0),\"\")","v":78.750112025719588},87.485789640793172,0,82.221709155344683,57.794052651744238,0,"","","","","","","","","","","","","","","","","",null,null,null,null,null,"* 1 will be changed to 2 when the results of the analysis have been saved. "]
[5,"QUE1105C",52.590396458779146,{"$f":"IF(AND(D$3>0,$C38<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D38/D$30,D38),0),\"\")","v":79.426097481061149},86.605579237131877,0,82.578821289753449,66.931880744728417,0,"","","","","","","","","","","","","","","","",""]
[6,"QUE1106C",65.141874883693632,{"$f":"IF(AND(D$3>0,$C39<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D39/D$30,D39),0),\"\")","v":80.980193005708898},86.509523263701269,0,82.528241235428723,74.11186698070874,66.721424816614245,"","","","","","","","","","","","","","","","","",null,null,null,null,"4) Go to the appropriate sheet for analysis and click on the Start button "]
[7,"QUE1107D",68.968959018795857,{"$f":"IF(AND(D$3>0,$C40<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D40/D$30,D40),0),\"\")","v":81.514127241603717},79.254415907018611,0,80.448734498070792,72.596476466082024,100,"","","","","","","","","","","","","","","","",""]
[8,"QUE1108D",64.301476617952645,{"$f":"IF(AND(D$3>0,$C41<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D41/D$30,D41),0),\"\")","v":81.78174129905004},87.496825554070398,0,80.409974911131968,80.564483838407043,55.555834105056448,"","","","","","","","","","","","","","","","","",null,null,null,null,"5) Make the analysis and click Save and load next to continue - or click Save to just save the results"]
[9,"QUE1109E",66.453398741939324,{"$f":"IF(AND(D$3>0,$C42<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D42/D$30,D42),0),\"\")","v":98.720392451635959},100,0,100,100,0,"","","","","","","","","","","","","","","","",""]
[10,"QUE1110E",51.758626906584944,{"$f":"IF(AND(D$3>0,$C43<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D43/D$30,D43),0),\"\")","v":100},72.715068811431479,0,71.04911114609925,66.787581481978933,0,"","","","","","","","","","","","","","","","",""]
[11,"","",{"$f":"IF(AND(D$3>0,$C44<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D44/D$30,D44),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[12,"","",{"$f":"IF(AND(D$3>0,$C45<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D45/D$30,D45),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[13,"","",{"$f":"IF(AND(D$3>0,$C46<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D46/D$30,D46),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[14,"","",{"$f":"IF(AND(D$3>0,$C47<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D47/D$30,D47),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[15,"","",{"$f":"IF(AND(D$3>0,$C48<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D48/D$30,D48),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[16,"","",{"$f":"IF(AND(D$3>0,$C49<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D49/D$30,D49),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[17,"","",{"$f":"IF(AND(D$3>0,$C50<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D50/D$30,D50),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[18,"","",{"$f":"IF(AND(D$3>0,$C51<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D51/D$30,D51),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[19,"","",{"$f":"IF(AND(D$3>0,$C52<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D52/D$30,D52),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[20,"","",{"$f":"IF(AND(D$3>0,$C53<>\"\"),IF(D$30>0,IF($C$2=\"Yes\",100*D53/D$30,D53),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"If the Run # numbers do not match the label numbers please sort the input:"]
[]
[null,"N",null,{"$f":"COUNT(D35:D53)","v":9},{"$f":"COUNT(E35:E53)","v":9},9,9,9,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Mean",{"$f":"MAX(D29:Z29)","v":5555081.9602529686},{"$f":"IF(D28*D3>0,AVERAGE(D34:D53),\"\")","v":5555081.9602529686},{"$f":"IF(E28*E3>0,AVERAGE(E34:E53),\"\")","v":745555.70384136983},80425.550035749402,394387.17291027203,1969638.2561995261,4034.1475663918295,"","","","","","","","","","","","","","","","",{"$f":"IF(Z28*Z3>0,AVERAGE(Z34:Z53),\"\")","v":""}]
[null,"Max",{"$f":"MAX(D30:Z30)","v":6519590.7809099602},{"$f":"IF(D28>0,MAX(D34:D53),\"\")","v":6519590.7809099602},{"$f":"IF(E28>0,MAX(E34:E53),\"\")","v":869046.180072163},593277.90035749297,474412.24692934903,2680716.9371722401,18149.169132112798,"","","","","","","","","","","","","","","","",""]
[null,"Min",{"$f":"MIN(D31:Z31)","v":0},{"$f":"IF(D28>0,MIN(D34:D53),\"\")","v":5134185.0435850797},{"$f":"IF(E28>0,MIN(E34:E53),\"\")","v":631927.52784259},0,337065.68461154,1549294.95811355,0,"","","","","","","","","","","","","","","","",""]
["Table 2:",null,"Label",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]
["Analyte names ","Run#/analyte:",null,"Butyrolactone ","Phenylethyl alcohol ","Ethyl hydrogen succinate ","Diethyl succinate ","Tyrosol ","Acetyl-1-tyrosol "]
["in first row (40)",1,"QUE1101A",5383675.3848396502,740921.243975939,593277.90035749297,397066.37897989398,2340223.3539085998,0]
[null,2,"QUE1102A",5320880.9044794403,694074.52102870902,210977.600000001,369812.17768831801,1810423.4118892101,0]
["Labels in colum C",3,"QUE1103B",5652265.7660021503,805700.17296301306,0,429023.840171522,1638542.45408017,0]
[null,4,"QUE1104B",5134185.0435850797,760291.91297928104,0,390069.85786758497,1549294.95811355,0]
["Data first cell:",5,"QUE1105C",5178256.5290118204,752642.47808966495,0,391764.04156849103,1794254.2634918599,0]
["D41",6,"QUE1106C",5279577.1975632897,751807.70732183498,0,391524.083596271,1986729.3706064201,12109.3842373228]
[null,7,"QUE1107D",5314387.5247828104,688757.47397845006,0,381658.64895852399,1946106.0404165201,18149.169132112798]
[null,8,"QUE1108D",5331834.8662005002,760387.82016205299,0,381474.76873122703,2159705.7636015699,10082.9222944827]
[null,9,"QUE1109E",6436165.6051549902,869046.180072163,0,474412.24692934903,2680716.9371722401,0]
[null,10,"QUE1110E",6519590.7809099602,631927.52784259,0,337065.68461154,1790386.0087151199,0]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]

{"sheet":"2 factors","index":1,"n_rows":57,"n_cols":33,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Input!A1","v":"Response_Surface_1.3.xlsm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!$I$1","v":"Author: Bo Svensmark, svensmark@plen.ku.dk, Analytical Chemistry,ECP, PLEN, University of Copenhagen 2024"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The sheet is protected. To unprotect all cells: Review -> Unprotect Sheet"]
[null,"Table 1: Design parameters",null,null,null,"WHITE cells for user input",null,null,"Face centered design  a =  ",null,null,1,null,null,null,null,null,null,null,"1) Enter Design parameters in Table 1 and 2"]
[null,"a:",null,1,null,{"$f":"IF(OR(D5<2,D5>6),\"ERROR:\",\"\")","v":""},null,null,"Rotatable design         a =",null,null,{"$f":"4^(1/4)","v":1.4142135623730949},null,null,null,null,null,null,null,null,"Center is calcuated as the mean of High and Low",null,null,null,null,"Run # ",1,2,"1^2","2^2",12,"Block","Day"]
[null,"No of centre points",null,2,null,{"$f":"IF(OR(D5<2,D5>6),\"No must be 2 -  6\",\"1 to 6 center points\")","v":"1 to 6 center points"},null,null,"Orthogonal design      a =",null,null,{"$f":"SQRT((SQRT(4*(8+D5))-4)/2)","v":1.0780898200838276},null,null,null,null,null,null,null,"2) Enter Run parameters and groups in Table 3",null,null,null,null,null,1,{"$f":"(C16-C$13)","v":-50},{"$f":"(D16-D$13)","v":-50},{"$f":"AA5^2","v":2500},{"$f":"AB5^2","v":2500},{"$f":"AA5*AB5","v":2500},{"$f":"IF(D$6=1,0,IF(C42=\"\",0,IF(CODE(UPPER(C42))>68,1,-1)))","v":0},{"$f":"IF(C42=\"\",0,IF(CODE(UPPER(C42))>68,2,1))","v":1}]
[null,"Blocks:",null,1,null,"1 or 2 Blocks",null,null,null,null,null,null,null,null,null,null,null,null,null,"3) Press Copy Table 3 to Runs to create a sheet for experiments to run ",null,null,null,null,null,2,50,-50,2500,2500,-2500,{"$f":"IF(D$6=1,0,IF(C43=\"\",0,IF(CODE(UPPER(C43))>68,1,-1)))","v":0},{"$f":"IF(C43=\"\",0,IF(CODE(UPPER(C43))>68,2,1))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4) Run the experiments and enter results in Table 4 or in Sheet Input *)",null,null,null,null,null,3,-50,50,2500,2500,-2500,0,1]
[null,"Table 2:","Factor levels",null,"    See T4 for instructions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5) Coefficients for the model can then be seen in Table 5",null,null,null,null,null,4,50,50,2500,2500,2500,0,1]
[null,"Factor:",1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6) Go to Table 6 to find the optimum settings",null,null,null,null,null,5,-50,0,2500,0,0,0,2]
[null,"Name","C18e","PSA",null,"Saved?","Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,50,0,2500,0,0,0,2]
[null,"Unit","mg","mg",null,"Output #",8,null,null,null,null,null,null,null,null,null,null,null,null,"*) For results in Sheet Input:",null,null,null,null,null,7,0,-50,0,2500,0,0,2]
[null,"Low",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1) Follow the instructions in Sheet Input for the data",null,null,null,null,null,8,0,50,0,2500,0,0,2]
[null,"Center",{"$f":"(C14+C12)/2","v":50},{"$f":"(D14+D12)/2","v":50},"Analyte:","Rel.Area:",7.262084691560737E-2,null,"Comment:","first",null,null,null,null,null,null,null,null,null,"2) Press the button Start  to load data for the first dataset to analyze",null,null,null,null,null,9,0,0,0,0,0,0,1]
[null,"High",100,100,"Acetyl-1-tyrosol ",null,null,null,{"$f":"IF($J$29=\"Not updated\",\"Please press Maximum or Minimum\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"3) Press Save results or Save results and load next analyte",null,null,null,null,null,10,0,0,0,0,0,0,1]
[null,"Run #",{"$f":"C10","v":"C18e"},{"$f":"D10","v":"PSA"},"Table 4: Responses",null,"Mean","Residuals","Table 5: Coefficients",null,"SE","P",null,null,null,null,null,null,null,"4) The optimizer will automatically find the maximum",null,null,null,null,null,11,{"$f":"IF(C26=\"\",\"\",(C26-C$13))","v":""},{"$f":"IF(C26=\"\",\"\",(D26-D$13))","v":""},{"$f":"IF(AA15=\"\",\"\",AA15^2)","v":""},"",{"$f":"IF(AA15=\"\",\"\",AA15*AB15)","v":""},0,1]
[null,1,{"$f":"C$12","v":0},{"$f":"D$12","v":0},0,null,{"$f":"AVERAGE(E16:F16)","v":0},{"$f":"IF(C16=\"\",\"\",G16-($J$16+(C16-$C$13)*($J$17+(C16-$C$13)*$J$19+(D16-$D$13)*$J$21)+(D16-$D$13)*($J$18+(D16-$D$13)*$J$20)+AF5*$J$22))","v":-12.164070578888499},"Const",{"$f":"VLOOKUP($D5,$U$22:$AB$30,8,FALSE)","v":31.753894131667231},{"$f":"VLOOKUP($D$5&\"s\",$U$22:$AB$31,8,FALSE)","v":20.99141867437298},{"$f":"IF(K16=0,\"\",_xlfn.T.DIST.2T(ABS(J16/K16),COUNT($G$16:$G$29)-5-$D$6))","v":0.20490051025131251},null,null,null,null,null,null,null,"5) If you want to find the Minimum press this button",null,null,null,null,null,12,{"$f":"IF(C27=\"\",\"\",(C27-C$13))","v":""},{"$f":"IF(C27=\"\",\"\",(D27-D$13))","v":""},"","",{"$f":"IF(AA16=\"\",\"\",AA16*AB16)","v":""},0,2]
[null,2,{"$f":"C$14","v":100},{"$f":"D$12","v":0},0,null,0,{"$f":"IF(C17=\"\",\"\",G17-($J$16+(C17-$C$13)*($J$17+(C17-$C$13)*$J$19+(D17-$D$13)*$J$21)+(D17-$D$13)*($J$18+(D17-$D$13)*$J$20)+AF6*$J$22))","v":-34.404545517759942},1,{"$f":"VLOOKUP($D5,$U$22:$AB$31,7,FALSE)+J41","v":0.22240474938871435},{"$f":"VLOOKUP($D$5&\"s\",$U$22:$AB$31,7,FALSE)","v":0.28679737821859314},{"$f":"IF(K17=0,\"\",_xlfn.T.DIST.2T(ABS(J17/K17),COUNT($G$16:$G$29)-5-$D$6))","v":0.48135208042122424},null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"IF(C28=\"\",\"\",(C28-C$13))","v":""},{"$f":"IF(C28=\"\",\"\",(D28-D$13))","v":""},"","",{"$f":"IF(AA17=\"\",\"\",AA17*AB17)","v":""},0,2]
[null,3,{"$f":"C$12","v":0},{"$f":"D$14","v":100},0,null,0,2.6506513860926795,2,{"$f":"VLOOKUP($D5,$U$22:$AB$31,6,FALSE)","v":-0.14814721964981178},{"$f":"VLOOKUP($D$5&\"s\",$U$22:$AB$31,6,FALSE)","v":0.28679737821859302},0.63271082409565804,null,null,null,null,null,null,null,"Blocking: See instructions starting in cell AB43",null,null,null,null,null,14,{"$f":"IF(C29=\"\",\"\",(C29-C$13))","v":""},{"$f":"IF(C29=\"\",\"\",(D29-D$13))","v":""},"","",{"$f":"IF(AA18=\"\",\"\",AA18*AB18)","v":""},0,2]
[null,4,{"$f":"C$14","v":100},{"$f":"D$14","v":100},0,null,0,-19.589823552778753,"1^2",{"$f":"VLOOKUP($D5,$U$22:$AB$31,5,FALSE)","v":-1.2058830342010942E-2},{"$f":"VLOOKUP($D$5&\"s\",$U$22:$AB$31,5,FALSE)","v":9.1979788175914172E-3},0.26004526032381253]
[null,5,{"$f":"AE22","v":0},{"$f":"D$13","v":50},0,null,0,9.513419192795844,"2^2",{"$f":"VLOOKUP($D5,$U$22:$AB$31,4,FALSE)","v":5.7080515156775011E-3},{"$f":"VLOOKUP($D$5&\"s\",$U$22:$AB$31,4,FALSE)","v":9.1979788175914189E-3},0.56848819211506019,null,null,null,null,null,null,null,null,null,"Regression coefficients:",null,null,null,null,null,null,null,"Center",{"$f":"C13","v":50},{"$f":"D13","v":50}]
[null,6,{"$f":"AE23","v":100},{"$f":"D$13","v":50},66.721424816614245,null,66.721424816614245,53.994369070538653,12,{"$f":"VLOOKUP($D5,$U$22:$AB$31,3,FALSE)","v":-6.8678495935505185E-19},{"$f":"VLOOKUP($D$5&\"s\",$U$22:$AB$31,3,FALSE)","v":7.0250723620355129E-3},1,null,null,null,null,null,null,null,null,"Nc","Block",12,"2^2","1^2",2,1,"Const",null,"Range/2",{"$f":"(C14-C12)/2","v":50},{"$f":"(D14-D12)/2","v":50}]
[null,7,{"$f":"C$13","v":50},{"$f":"AF22","v":0},100,null,100,46.568616096648427,"Block",{"$f":"VLOOKUP($D5,$U$22:$AB$31,2,FALSE)","v":0},{"$f":"VLOOKUP($D$5&\"s\",$U$22:$AB$31,2,FALSE)","v":0},"",null,null,null,null,null,null,null,null,2,{"$f":"LINEST(G16:G25,AA5:AF14,TRUE,TRUE)","v":0},-6.8678495935505185E-19,5.7080515156775011E-3,-1.2058830342010942E-2,-0.14814721964981178,0.22240474938871435,31.753894131667231,null,"Axial -",{"$f":"AE$20-$D$4*AE21","v":0},{"$f":"AF$20-$D$4*AF21","v":0}]
[null,8,{"$f":"C$13","v":50},{"$f":"AF23","v":100},55.555834105056448,null,55.555834105056448,16.939172166686049,null,null,null,null,null,null,null,null,null,null,null,null,"2s",0,7.0250723620355129E-3,9.1979788175914189E-3,9.1979788175914172E-3,0.28679737821859302,0.28679737821859314,20.99141867437298,null,"Axial +",{"$f":"AE$20+$D$4*AE21","v":100},{"$f":"AF$20+$D$4*AF21","v":100}]
[null,9,{"$f":"C$13","v":50},{"$f":"D$13","v":50},0,null,0,-31.753894131667231,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(AA15=\"\",\"\",LINEST(G16:G26,AA5:AF15,TRUE,TRUE))","v":""},"","","","","",""]
[null,10,{"$f":"C$13","v":50},{"$f":"D$13","v":50},0,null,0,-31.753894131667231,"Table 6: Optimization and estimation",null,null,null,null,null,null,null,null,null,null,null,"3s","","","","","","","",null,null,"Day"]
[null,11,{"$f":"IF($D$5>2,C13,\"\")","v":""},{"$f":"IF($D$5>2,AF$20,\"\")","v":""},null,null,{"$f":"IF(E26=\"\",\"\",AVERAGE(E26:F26))","v":""},"","Factor","Name",null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(AA16=\"\",\"\",LINEST(G16:G27,AA5:AF16,TRUE,TRUE))","v":""},"","","","","","",null,"Run # ",1,2]
[null,12,{"$f":"IF($D$5>3,C13,\"\")","v":""},{"$f":"IF($D$5>3,AF$20,\"\")","v":""},null,null,{"$f":"IF(E27=\"\",\"\",AVERAGE(E27:F27))","v":""},"",1,{"$f":"C10","v":"C18e"},59.221655130758954,{"$f":"C11","v":"mg"},null,null,null,null,null,null,null,null,"4s","","","","","","","",null,1,{"$f":"IF(AG5=2,NA(),B16)","v":1},{"$f":"IF(AG5=2,B16,NA())","v":{"$error":"#N/A"}}]
[null,13,{"$f":"IF($D$5>4,C13,\"\")","v":""},{"$f":"IF($D$5>4,AF$20,\"\")","v":""},null,null,"","",2,{"$f":"D10","v":"PSA"},0,{"$f":"D11","v":"mg"},null,null,null,null,null,null,null,null,5,{"$f":"IF(AA17=\"\",\"\",LINEST(G16:G28,AA5:AF17,TRUE,TRUE))","v":""},"","","","","","",null,2,{"$f":"IF(AG6=2,NA(),B17)","v":2},{"$f":"IF(AG6=2,B17,NA())","v":{"$error":"#N/A"}}]
[null,14,{"$f":"IF($D$5>5,C13,\"\")","v":""},{"$f":"IF($D$5>5,AF$20,\"\")","v":""},null,null,"","","Response",{"$f":"Z56","v":"Max"},{"$f":"$J$16+($K27-$C$13)*($J$17+($K27-$C$13)*$J$19+(K$28-$D$13)*$J$21)+(K$28-$D$13)*($J$18+(K$28-$D$13)*$J$20)","v":54.456853852504373},null,null,null,null,null,null,null,null,null,"5s","","","","","","","",null,3,3,{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(AA18=\"\",\"\",LINEST(G16:G29,AA5:AF18,TRUE,TRUE))","v":""},"","","","","","",null,4,4,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6s","","","","","","","",null,5,{"$error":"#N/A"},5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$error":"#N/A"},6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Press the buttons to find the factor levels for Max or Min response",null,null,null,null,"Graph F1 & F2",null,null,null,"F1",null,null,null,null,7,{"$error":"#N/A"},7]
[null,"Table 3: Experiments",null,null,null,null,"Comments to the design:",null,null,null,null,null,null,null,null,"- or enter values for levels in the white cells in Table 5",null,null,null,null,null,null,{"$f":"AE$20-1*$D$4*AE$21","v":0},{"$f":"AE$20-0.5*$D$4*AE$21","v":25},{"$f":"AE$20","v":50},{"$f":"AE$20+0.5*$D$4*AE$21","v":75},{"$f":"AE$20+1*$D$4*AE$21","v":100},null,null,8,{"$error":"#N/A"},8]
[null,"Date:","2024-09-11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF$20-1*$D$4*AF$21","v":0},{"$f":"$J$16+(W$34-$C$13)*($J$17+(W$34-$C$13)*$J$19+($V35-$D$13)*$J$21)+($V35-$D$13)*($J$18+($V35-$D$13)*$J$20)","v":12.164070578888499},40.334496204876878,53.431383903351573,51.454733674312592,34.404545517759942,null,null,9,9,{"$error":"#N/A"}]
[null,"Group:","Bo",null,null,null,null,null,null,null,null,null,null,null,null,"OBS: Optimize Max and Min are limited to values in the design",null,null,null,null,null,{"$f":"AF$20-0.5*$D$4*AF$21","v":25},-2.2422065042521115,25.928219121736269,39.025106820210965,37.048456591171984,19.998268434619327,null,null,10,10,{"$error":"#N/A"}]
[null,"Method:","TST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F2",{"$f":"AF$20","v":50},-9.513419192795844,18.657006433192535,31.753894131667231,29.77724390262825,12.727055746075592,null,null,11,{"$f":"IF(G26=\"\",NA(),IF(AG15=2,NA(),B26))","v":{"$error":"#N/A"}},{"$f":"IF(G26=\"\",NA(),IF(AG15=2,B26,NA()))","v":{"$error":"#N/A"}}]
[null,"Design no:",1,null,null,null,null,null,null,null,null,null,null,null,null,"Optimizer:",null,null,null,null,null,{"$f":"AF$20+0.5*$D$4*AF$21","v":75},-9.6495674867427006,18.520858139245679,31.617745837720374,29.641095608681393,12.590907452128736,null,null,12,{"$f":"IF(G27=\"\",NA(),IF(AG16=2,NA(),B27))","v":{"$error":"#N/A"}},{"$f":"IF(G27=\"\",NA(),IF(AG16=2,B27,NA()))","v":{"$error":"#N/A"}}]
[null,"Free text:",null,null,null,null,null,null,null,null,null,null,null,null,null,"The blue curve shows the effect",null,null,null,null,null,{"$f":"AF$20+1*$D$4*AF$21","v":100},-2.6506513860926795,25.5197742398957,38.616661938370399,36.640011709331418,19.589823552778753,null,null,13,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Design:","2 factors",null,null,null,null,null,null,null,null,null,null,null,null,"of changing F2 when F1 is held",null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Run #","Group","Label",{"$f":"C10","v":"C18e"},{"$f":"D10","v":"PSA"},"Constant factors and comments",null,null,null,null,null,null,null,null,"at the position marked by the",null,null,null,null,"Factor",1,"Factor",2,"Data for Optimizer"]
[null,{"$f":"IF($C$16=\"\",\"\",$B$16)","v":1},"A",{"$f":"IF(OR(B42=\"\",C42=\"\"),\"\",$C$37&TEXT(C$38,\"0\")&\"1\"&TEXT(B42,\"00\")&C42)","v":"TST1101A"},{"$f":"C$16","v":0},{"$f":"D$16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE$20-1*$D$4*AE$21","v":0},{"$f":"$J$16+($U42-$C$13)*($J$17+($U42-$C$13)*$J$19+(K$28-$D$13)*$J$21)+(K$28-$D$13)*($J$18+(K$28-$D$13)*$J$20)","v":12.164070578888499},{"$f":"AF$20-1*$D$4*AF$21","v":0},{"$f":"$J$16+(K$27-$C$13)*($J$17+(K$27-$C$13)*$J$19+($W42-$D$13)*$J$21)+($W42-$D$13)*($J$18+($W42-$D$13)*$J$20)","v":54.456853852504373},{"$f":"MIN(0,MIN(V42:V52,X42:X52))","v":0},{"$f":"MAX(V42:V52,X42:X52)","v":54.456853852504373}]
[null,{"$f":"IF($C$17=\"\",\"\",$B$17)","v":2},"A",{"$f":"IF(OR(B43=\"\",C43=\"\"),\"\",$C$37&TEXT(C$38,\"0\")&\"1\"&TEXT(B43,\"00\")&C43)","v":"TST1102A"},{"$f":"C$17","v":100},{"$f":"D$17","v":0},null,null,null,null,null,null,null,null,null,"dotted red line - and vice versa",null,null,null,null,{"$f":"AE$20-0.8*$D$4*AE$21","v":10},25.241065380585489,{"$f":"AF$20-0.8*$D$4*AF$21","v":10},47.838135291896506,"X","Y",null,"Blocking design:"]
[null,{"$f":"IF($C$18=\"\",\"\",$B$18)","v":3},"A","TST1103A",{"$f":"C$18","v":0},{"$f":"D$18","v":100},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE$20-0.6*$D$4*AE$21","v":20},35.906294113880293,{"$f":"AF$20-0.6*$D$4*AF$21","v":20},42.361027034424133,{"$f":"K27","v":59.221655130758954},{"$f":"$Y$42","v":0},null,"All runs for group A, B, C and D will be run on Day 1 (Thursday)"]
[null,{"$f":"IF($C$19=\"\",\"\",$B$19)","v":4},"A","TST1104A",{"$f":"C$19","v":100},{"$f":"D$19","v":100},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE$20-0.4*$D$4*AE$21","v":30},44.159756778772909,{"$f":"AF$20-0.4*$D$4*AF$21","v":30},38.025529080087267,{"$f":"K27","v":59.221655130758954},{"$f":"$Z$42","v":54.456853852504373},null,"All runs for group E, F, G and H will be run on Day 2 (Friday)"]
[null,{"$f":"IF($C$20=\"\",\"\",$B$20)","v":5},"E","TST1105E",{"$f":"C$20","v":0},{"$f":"D$20","v":50},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE$20-0.2*$D$4*AE$21","v":40},50.001453375263338,{"$f":"AF$20-0.2*$D$4*AF$21","v":40},34.831641428885902,{"$f":"(K28-W42)*AE21/AF21+U42","v":0},{"$f":"$Y$42","v":0},null,"To block the design, Block 1 = Day 1 must contain:"]
[null,{"$f":"IF($C$21=\"\",\"\",$B$21)","v":6},"E","TST1106E",{"$f":"C$21","v":100},{"$f":"D$21","v":50},null,null,null,null,null,null,null,null,null,"The position of the dotted lines",null,null,null,null,{"$f":"AE$20","v":50},53.431383903351573,{"$f":"AF$20","v":50},32.779364080820031,{"$f":"Y46","v":0},{"$f":"$Z$42","v":54.456853852504373},null,null,"Corner points (Run 1-4) and 2 or 3 centre points"]
[null,{"$f":"IF($C$22=\"\",\"\",$B$22)","v":7},"E","TST1107E",{"$f":"C$22","v":50},{"$f":"D$22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE$20+0.2*$D$4*AE$21","v":60},54.449548363037621,{"$f":"AF$20+0.2*$D$4*AF$21","v":60},31.868697035889664,{"$f":"W34","v":0},{"$f":"$K$29","v":54.456853852504373},null,"Block 2 = Day 2 must contain:"]
[null,{"$f":"IF($C$23=\"\",\"\",$B$23)","v":8},"E","TST1108E",{"$f":"C$23","v":50},{"$f":"D$23","v":100},null,null,null,null,null,null,null,null,null,"are taken from Table 5, cells K24 and K25",null,null,null,null,{"$f":"AE$20+0.4*$D$4*AE$21","v":70},53.055946754321482,{"$f":"AF$20+0.4*$D$4*AF$21","v":70},32.099640294094797,{"$f":"AA34","v":100},{"$f":"$K$29","v":54.456853852504373},null,null,"Star points (Run 5-8) and 2 or 3 centre points"]
[null,{"$f":"IF($C$24=\"\",\"\",$B$24)","v":9},"A","TST1109A",{"$f":"C$24","v":50},{"$f":"D$24","v":50},null,null,null,null,null,null,null,null,null,"which can be changed manually",null,null,null,null,{"$f":"AE$20+0.6*$D$4*AE$21","v":80},49.250579077203156,{"$f":"AF$20+0.6*$D$4*AF$21","v":80},33.472193855435428]
[null,{"$f":"IF($C$25=\"\",\"\",$B$25)","v":10},"A","TST1110A",{"$f":"C$25","v":50},{"$f":"D$25","v":50},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE$20+0.8*$D$4*AE$21","v":90},43.033445331682643,{"$f":"AF$20+0.8*$D$4*AF$21","v":90},35.98635771991156,null,null,null,null,"Centre points could be (1:1), 2:2  or 3:3 "]
[null,{"$f":"IF($C$26=\"\",\"\",$B$26)","v":""},"A","",{"$f":"C$26","v":""},{"$f":"D$26","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE$20+1*$D$4*AE$21","v":100},34.404545517759942,{"$f":"AF$20+1*$D$4*AF$21","v":100},39.642131887523192,null,null,null,"Blocking analysis:"]
[null,{"$f":"IF($C$27=\"\",\"\",$B$27)","v":""},"E","",{"$f":"C$27","v":""},{"$f":"D$27","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min 1&2",{"$f":"MIN(W35:AA39)","v":-9.6495674867427006},null,null,null,null,null,"In Table 1 set Blocks = 2"]
[null,{"$f":"IF($C$28=\"\",\"\",$B$28)","v":""},"E","",{"$f":"C$28","v":""},{"$f":"D$28","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max 1&2",{"$f":"MAX(W35:AA39)","v":53.431383903351573},null,null,"Target","Max",null,"If P(Block) in Table 5 is > 0.05 and/or the residuals in the graph are"]
[null,{"$f":"IF($C$29=\"\",\"\",$B$29)","v":""},"E","",{"$f":"C$29","v":""},{"$f":"D$29","v":""},null,null,null,null,null,null,null,null,null,"If you change something, the optimization may be wrong, and two warnings is given:",null,null,null,null,null,null,null,null,"IF…",{"$f":"IF(SUM(J16:J22)<>Z57,_xlfn.TEXTSPLIT(\"-Not updated\",,\"-\",FALSE),_xlfn.TEXTSPLIT(\"-\"&Z54,,\"-\",FALSE))","v":""},null,"randomly distributed, it is recommend to set Blocks = 1 in Table 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red text in cell I14",null,null,null,null,null,null,null,"Result","Max",null,"When Blocks = 2 the effect of the blocks will be separated from the"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The text \"Not updated\" in Table 6",null,null,null,null,null,null,null,"Checksum",31.821800882579804,null,"other effects, but it should not be if the block effect is random noise."]

{"sheet":"3 factors","index":2,"n_rows":68,"n_cols":40,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Input!A1","v":"Response_Surface_1.3.xlsm"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!$I$1","v":"Author: Bo Svensmark, svensmark@plen.ku.dk, Analytical Chemistry,ECP, PLEN, University of Copenhagen 2024"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"The sheet is protected. To unprotect all cells: Review -> Unprotect Sheet"]
[null,"Table 1: Design parameters",null,null,null,"WHITE cells for user input",null,null,"Face centered design  a =  ",null,null,1]
[null,"a:",null,1.5249999999999999,null,null,null,null,"Rotatable design         a =",null,null,{"$f":"8^(1/4)","v":1.681792830507429},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 2: Factor levels to run",null,null,null,null,null,null,null,null,null,null,null,"1) Enter Design parameters in Table 1 and 2"]
[null,"No of centre points",null,4,{"$f":"IF(OR(D5<2,D5>6),\"ERROR:\",\"\")","v":""},{"$f":"IF(OR(C5<2,C5>6),\"No must be 2 -  6\",\"2 to 6 center points\")","v":"No must be 2 -  6"},null,null,"Orthogonal design      a =",null,null,{"$f":"SQRT((SQRT(8*(14+D5))-8)/2)","v":1.4142135623730951},null,null,null,null,null,null,null,null,null,null,null,null,null,"Run # ",1,2,3,"1^2","2^2","3^2",12,13,23,"Block","Day",null,null,"Center is calcuated as the mean of High and Low"]
[null,"Blocks:",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"(C16-C$13)","v":-1},{"$f":"(D16-D$13)","v":-1},{"$f":"(E16-E$13)","v":-1},{"$f":"AA6^2","v":1},1,1,{"$f":"AA6*AB6","v":1},{"$f":"AA6*AC6","v":1},{"$f":"AB6*AC6","v":1},{"$f":"IF(D$6=1,0,IF(C48=\"\",0,IF(CODE(UPPER(C48))>68,1,-1)))","v":-1},{"$f":"IF(C48=\"\",0,IF(CODE(UPPER(C48))>68,2,1))","v":1},null,"2) Enter Run parameters and groups in Table 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,2,1,-1,-1,1,1,1,-1,-1,1,-1,{"$f":"IF(C49=\"\",0,IF(CODE(UPPER(C49))>68,2,1))","v":1},null,"3) Press Copy Table 3 to Runs to create a sheet for experiments to run "]
[null,"Table 2:","Factor levels",null,null,"    See AL4 for instructions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,-1,1,-1,1,1,1,-1,1,-1,-1,1,null,"4) Run the experiments and enter results in Table 4 or in Sheet Input *)"]
[null,"Factor:",1,2,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,1,1,-1,1,1,1,1,-1,-1,-1,1,null,"5) Coefficients for the model can then be seen in Table 5"]
[null,"Name","Salt","Temp","Time",null,"Saved?","Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,-1,-1,1,1,1,1,1,-1,-1,-1,1,null,"6) Go to Table 6 to find the optimum settings"]
[null,"Unit","mg","ml","min",null,"Output #",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,1,-1,1,1,1,1,-1,1,-1,-1,1]
[null,"Low",-1,-1,-1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,-1,1,1,1,1,1,-1,-1,1,-1,1,null,"*) For results in Sheet Input:"]
[null,"Center",{"$f":"(C14+C12)/2","v":0},{"$f":"(D14+D12)/2","v":0},{"$f":"(E14+E12)/2","v":0},"Analyte:","Rel.Area:",100,null,"Comment:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,1,1,1,1,1,1,1,1,1,-1,1,null,"1) Follow the instructions in Sheet Input for the data"]
[null,"High",1,1,1,"3 F test",null,null,null,{"$f":"IF($K$35=\"Not updated\",\"Please press Maximum or Minimum\",\"\")","v":"Please press Maximum or Minimum"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,-1.5249999999999999,0,0,2.3256249999999996,0,0,0,0,0,1,2,null,"2) Press the button Start  to load data for the first dataset to analyze"]
[null,"Run #",{"$f":"C10","v":"Salt"},{"$f":"D10","v":"Temp"},{"$f":"E10","v":"Time"},"Table 4: Responses",null,"Mean","Residuals","Table 5: Coefficients",null,"SE","P",null,null,null,null,null,null,null,null,null,null,null,null,10,1.5249999999999999,0,0,2.3256249999999996,0,0,0,0,0,1,2,null,"3) Press Save results or Save results and load next analyte"]
[null,1,{"$f":"C$12","v":-1},{"$f":"D$12","v":-1},{"$f":"E$12","v":-1},50.741,null,{"$f":"IF(F16=\"\",\"\",AVERAGE(F16:G16))","v":50.741},{"$f":"IF(C16=\"\",\"\",H16-($K$16+(C16-$C$13)*($K$17+(C16-$C$13)*$K$20+(D16-$D$13)*$K$23+(E16-$E$13)*$K$24)+(D16-$D$13)*($K$18+(D16-$D$13)*$K$21+(E16-$E$13)*$K$25)+(E16-$E$13)*($K$19+(E16-$E$13)*$K$22)+AJ6*$K$26))","v":-0.98589708468867343},"Const",{"$f":"VLOOKUP($D$5,$Z$29:$AK$38,12,FALSE)","v":55.649687847305003},{"$f":"VLOOKUP($D$5&\"s\",$Z$29:$AK$38,12,FALSE)","v":2.0274723182157963},{"$f":"IF(L16=0,\"\",_xlfn.T.DIST.2T(ABS(K16/L16),COUNT($H$16:$H$35)-9-$D$6))","v":2.1863686791031459E-8},null,null,null,null,null,null,null,null,null,null,null,null,11,0,-1.5249999999999999,0,0,2.3256249999999996,0,0,0,0,1,2,null,"4) The optimizer will automatically find the maximum"]
[null,2,{"$f":"C$14","v":1},{"$f":"D$12","v":-1},{"$f":"E$12","v":-1},48.221000000000004,null,{"$f":"IF(F17=\"\",\"\",AVERAGE(F17:G17))","v":48.221000000000004},{"$f":"IF(C17=\"\",\"\",H17-($K$16+(C17-$C$13)*($K$17+(C17-$C$13)*$K$20+(D17-$D$13)*$K$23+(E17-$E$13)*$K$24)+(D17-$D$13)*($K$18+(D17-$D$13)*$K$21+(E17-$E$13)*$K$25)+(E17-$E$13)*($K$19+(E17-$E$13)*$K$22)+AJ7*$K$26))","v":-0.69177595041340822},1,{"$f":"VLOOKUP($D$5,$Z$29:$AK$38,11,FALSE)","v":-1.9470605671376326},{"$f":"VLOOKUP($D$5&\"s\",$Z$29:$AK$38,11,FALSE)","v":1.1684412632333894},{"$f":"IF(L17=0,\"\",_xlfn.T.DIST.2T(ABS(K17/L17),COUNT($H$16:$H$35)-9-$D$6))","v":0.13957871636792279},null,null,null,null,null,null,null,null,null,null,null,null,12,0,1.5249999999999999,0,0,2.3256249999999996,0,0,0,0,1,2,null,"5) If you want to find the Minimum press this button"]
[null,3,{"$f":"C$12","v":-1},{"$f":"D$14","v":1},{"$f":"E$12","v":-1},48.221000000000004,null,48.221000000000004,-1.2800182189639386,2,{"$f":"VLOOKUP($D$5,$Z$29:$AK$37,10,FALSE)","v":1.9470605671376342},{"$f":"VLOOKUP($D$5&\"s\",$Z$29:$AK$38,10,FALSE)","v":1.1684412632333896},0.13957871636792249,null,null,null,null,null,null,null,null,null,null,null,null,13,0,0,-1.5249999999999999,0,0,2.3256249999999996,0,0,0,1,2]
[null,4,{"$f":"C$14","v":1},{"$f":"D$14","v":1},{"$f":"E$12","v":-1},50.741,null,50.741,-0.98589708468867343,3,{"$f":"VLOOKUP($D$5,$Z$29:$AK$38,9,FALSE)","v":-1.3629423969963446},{"$f":"VLOOKUP($D$5&\"s\",$Z$29:$AK$38,9,FALSE)","v":1.1684412632333896},0.28162562801605034,null,null,null,null,null,null,null,null,null,null,null,null,14,0,0,1.5249999999999999,0,0,2.3256249999999996,0,0,0,1,2]
[null,5,{"$f":"C$12","v":-1},{"$f":"D$12","v":-1},{"$f":"E$14","v":1},48.220999999999997,null,48.220999999999997,-0.78001229069598566,"1^2",{"$f":"VLOOKUP($D$5,$Z$29:$AK$37,8,FALSE)","v":0.27916684051285451},{"$f":"VLOOKUP($D$5&\"s\",$Z$29:$AK$38,8,FALSE)","v":1.3327056395507981},0.84004429973563077,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0,{"$f":"IF(AA20=\"\",\"\",AA20^2)","v":0},0,0,{"$f":"IF(AA20=\"\",\"\",AA20*AB20)","v":0},{"$f":"IF(AA20=\"\",\"\",AA20*AC20)","v":0},{"$f":"IF(AB20=\"\",\"\",AB20*AC20)","v":0},-1,1,null,"Blocking design:"]
[null,6,{"$f":"C$14","v":1},{"$f":"D$12","v":-1},{"$f":"E$14","v":1},38.501000000000005,null,38.501000000000005,-0.48589115642072045,"2^2",{"$f":"VLOOKUP($D$5,$Z$29:$AK$38,7,FALSE)","v":-0.82083315948714741},{"$f":"VLOOKUP($D$5&\"s\",$Z$29:$AK$38,7,FALSE)","v":1.3327056395507983},0.5574389296907698,null,null,null,null,null,null,null,null,null,null,null,null,16,0,0,0,0,0,0,0,0,0,-1,1,null,"All runs for group A, B, C and D will be run on Day 1 (Thursday)"]
[null,7,{"$f":"C$12","v":-1},{"$f":"D$14","v":1},{"$f":"E$14","v":1},52.901000000000003,null,52.901000000000003,-1.0741334249712509,"3^2",{"$f":"VLOOKUP($D$5,$Z$29:$AK$38,6,FALSE)","v":-0.27083315948714154},{"$f":"VLOOKUP($D$5&\"s\",$Z$29:$AK$38,6,FALSE)","v":1.3327056395507986},0.84474376213932778,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF(C32=\"\",\"\",(C32-C$13))","v":0},0,0,0,0,0,0,0,0,-1,1,null,"All runs for group E, F, G and H will be run on Day 2 (Friday)"]
[null,8,{"$f":"C$14","v":1},{"$f":"D$14","v":1},{"$f":"E$14","v":1},48.220999999999997,null,48.220999999999997,-0.78001229069598566,12,{"$f":"VLOOKUP($D$5,$Z$29:$AK$38,5,FALSE)","v":1.2599999999999962},{"$f":"VLOOKUP($D$5&\"s\",$Z$29:$AK$38,5,FALSE)","v":1.469361346678655},0.41954762836145965,null,null,null,null,null,null,null,null,null,null,null,null,18,0,0,0,0,0,0,0,0,0,1,2,null,"To block the design, Block 1 = Day 1 must contain:"]
[null,9,{"$f":"AI$42","v":-1.5249999999999999},{"$f":"D$13","v":0},{"$f":"E$13","v":0},66.905812499999996,null,66.905812499999996,1.9043862231911532,13,{"$f":"VLOOKUP($D$5,$Z$29:$AK$38,4,FALSE)","v":-1.8000000000000003},{"$f":"VLOOKUP($D$5&\"s\",$Z$29:$AK$38,4,FALSE)","v":1.4693613466786555},0.260184574336909,null,null,null,null,null,null,null,null,null,null,null,null,19,"","","","","","","","","",1,2,null,null,"Corner points (Run 1-8) and 2 to 4 centre points"]
[null,10,{"$f":"AI$43","v":1.5249999999999999},{"$f":"D$13","v":0},{"$f":"E$13","v":0},60.195812500000002,null,60.195812500000002,1.1329209529609372,23,{"$f":"VLOOKUP($D$5,$Z$29:$AK$38,3,FALSE)","v":1.8000000000000003},{"$f":"VLOOKUP($D$5&\"s\",$Z$29:$AK$38,3,FALSE)","v":1.4693613466786555},0.260184574336909,null,null,null,null,null,null,null,null,null,null,null,null,20,"","","","","","","","","",1,2,null,"Block 2 = Day 2 must contain:"]
[null,11,{"$f":"C$13","v":0},{"$f":"AJ$42","v":-1.5249999999999999},{"$f":"E$13","v":0},57.637625,null,57.637625,1.1329209529609443,"Block",{"$f":"VLOOKUP($D5,$Z$29:$AK$38,2,FALSE)","v":5.7332336811512397},{"$f":"VLOOKUP($D$5&\"s\",$Z$29:$AK$38,2,FALSE)","v":1.0078340340382816},7.440210186455431E-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,"Star points (Run 9-14) and 2 to 4 centre points"]
[null,12,0,{"$f":"AJ$43","v":1.5249999999999999},{"$f":"E$13","v":0},64.347624999999994,null,64.347624999999994,1.9043862231911532,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regression coefficients:"]
[null,13,0,{"$f":"D$13","v":0},{"$f":"AK$42","v":-1.5249999999999999},64.620218750000006,null,64.620218750000006,1.7886664326566191,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nc","Block",23,13,12,"3^2","2^2","1^2",3,2,1,"Const",null,null,"Centre points could be (1:1), 2:2 , 3:3 or 2:4 or 4:2 "]
[null,14,0,{"$f":"D$13","v":0},{"$f":"AK$43","v":1.5249999999999999},59.923218750000011,null,59.923218750000011,1.2486407434954785,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"LINEST(H16:H31,AA6:AJ21,TRUE,TRUE)","v":6.5701562500000001},1.7999999999999989,-1.8000000000000003,1.2599999999999978,-1.3499999999999965,-1.9000000000000019,-0.80000000000000093,-1.3629423969963439,1.9470605671376351,-1.9470605671376335,58.84115624999999,null,"Blocking analysis:"]
[null,15,0,{"$f":"D$13","v":0},{"$f":"E$13","v":0},52.271000000000001,null,52.271000000000001,{"$f":"IF(C30=\"\",\"\",H30-($K$16+(C30-$C$13)*($K$17+(C30-$C$13)*$K$20+(D30-$D$13)*$K$23+(E30-$E$13)*$K$24)+(D30-$D$13)*($K$18+(D30-$D$13)*$K$21+(E30-$E$13)*$K$25)+(E30-$E$13)*($K$19+(E30-$E$13)*$K$22)+AJ20*$K$26))","v":2.3545458338462382},"Table 6: Optimization and estimation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2s",0.12508485561587129,0.17115625893848141,0.17115625893848146,0.17115625893848146,0.17526632682928805,0.17526632682928803,0.17526632682928803,0.13610405354437075,0.13610405354437077,0.13610405354437075,0.32631805738791003,null,"In Table 1 set Blocks = 2"]
[null,16,0,{"$f":"D$13","v":0},{"$f":"E$13","v":0},52.271000000000001,null,52.271000000000001,2.3545458338462382,"Factor","Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(AA22=\"\",\"\",LINEST(H16:H32,AA6:AJ22,TRUE,TRUE))","v":6.5701562499999993},1.8000000000000005,-1.7999999999999994,1.2599999999999978,-1.3499999999999968,-1.9000000000000019,-0.80000000000000082,-1.3629423969963439,1.9470605671376326,-1.9470605671376346,58.84115624999999,null,"If P(Block) in Table 5 is > 0.05 and/or the residuals in the graph are"]
[null,17,{"$f":"IF($D$5>2,C13,\"\")","v":0},{"$f":"IF($D$5>2,D13,\"\")","v":0},{"$f":"IF($D$5>2,E13,\"\")","v":0},52.271000000000001,null,52.271000000000001,2.3545458338462382,1,{"$f":"C10","v":"Salt"},-1.5123235088570512,{"$f":"C11","v":"mg"},null,null,null,null,null,null,null,null,null,null,null,null,"3s",0.11237137845933103,0.15624357313133577,0.15624357313133586,0.1562435731313358,0.14826317980584702,0.148263179805847,0.14826317980584702,0.12424543382357134,0.1242454338235713,0.12424543382357134,0.2511821401198146,null,"randomly distributed, it is recommend to set Blocks = 1 in Table 1"]
[null,18,{"$f":"IF($D$5>3,C13,\"\")","v":0},{"$f":"IF($D$5>3,D13,\"\")","v":0},{"$f":"IF($D$5>3,E13,\"\")","v":0},52.271000000000001,null,52.271000000000001,-9.1119215284562429,2,{"$f":"D10","v":"Temp"},0.30383520512410966,{"$f":"D11","v":"ml"},null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(AA23=\"\",\"\",LINEST(H16:H33,AA6:AJ23,TRUE,TRUE))","v":5.7332336811512397},1.8000000000000003,-1.8000000000000003,1.2599999999999962,-0.27083315948714154,-0.82083315948714741,0.27916684051285451,-1.3629423969963446,1.9470605671376342,-1.9470605671376326,55.649687847305003,null,"When Blocks = 2 the effect of the blocks will be separated from the"]
[null,19,{"$f":"IF($D$5>4,C13,\"\")","v":""},{"$f":"IF($D$5>4,D13,\"\")","v":""},{"$f":"IF($D$5>4,E13,\"\")","v":""},null,null,"","",3,{"$f":"E10","v":"Time"},0.65432947572884481,{"$f":"E11","v":"min"},null,null,null,null,null,null,null,null,null,null,null,null,"4s",1.0078340340382816,1.4693613466786555,1.4693613466786555,1.469361346678655,1.3327056395507986,1.3327056395507983,1.3327056395507981,1.1684412632333896,1.1684412632333896,1.1684412632333894,2.0274723182157963,null,"other effects, but it should not be if the block effect is random noise."]
[null,20,{"$f":"IF($D$5>5,C13,\"\")","v":""},{"$f":"IF($D$5>5,D13,\"\")","v":""},{"$f":"IF($D$5>5,E13,\"\")","v":""},null,null,"","","Response",{"$f":"R67","v":"Not updated"},{"$f":"$K$16+($L32-$C$13)*($K$17+($L32-$C$13)*$K$20+(L$33-$D$13)*$K$23+(L$34-$E$13)*$K$24)+(L$33-$D$13)*($K$18+(L$33-$D$13)*$K$21+(L$34-$E$13)*$K$25)+(L$34-$E$13)*($K$19+(L$34-$E$13)*$K$22)","v":60.300894641038006},null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(AA24=\"\",\"\",LINEST(H16:H34,AA6:AJ24,TRUE,TRUE))","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Press the buttons to find the factor levels for Max or Min response",null,null,null,null,null,null,null,null,"5s","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"- or enter values for the factors in the white cells in Table 5 ",null,null,null,null,null,null,null,null,6,{"$f":"IF(AA25=\"\",\"\",LINEST(H16:H35,AA6:AJ25,TRUE,TRUE))","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,"6s","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OBS: Optimize Max and Min are limited to values in the design"]
[null,"Table 3: Experiments",null,null,null,null,null,"Comments to the design:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Graph F1 & F2",null,null,null,"F1",null,null,null,"Center",{"$f":"C13","v":0},{"$f":"D13","v":0},{"$f":"E13","v":0}]
[null,"Date:","2024-09-11",null,null,null,null,null,null,null,null,null,null,null,null,null,"The contour and the optimizer plots shows the response with constant value from Table 5:",null,null,null,null,null,null,null,null,null,null,{"$f":"AI$40-1*$D$4*AI$41","v":-1.5249999999999999},{"$f":"AI$40-0.5*$D$4*AI$41","v":-0.76249999999999996},{"$f":"AI$40-0*$D$4*AI$41","v":0},{"$f":"AI$40+0.5*$D$4*AI$41","v":0.76249999999999996},{"$f":"AI$40+1*$D$4*AI$41","v":1.5249999999999999},null,"Range/2",{"$f":"(C14-C12)/2","v":1},{"$f":"(D14-D12)/2","v":1},{"$f":"(E14-E12)/2","v":1}]
[null,"Group:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In the contour plot of F1 & 2, F3 has the value given in Table 5 ",null,null,null,null,null,null,null,null,null,{"$f":"AJ$40-1*$D$4*AJ$41","v":-1.5249999999999999},{"$f":"$K$16+(AB$41-$C$13)*($K$17+(AB$41-$C$13)*$K$20+($AA42-$D$13)*$K$23+($L$34-$E$13)*$K$24)+($AA42-$D$13)*($K$18+($AA42-$D$13)*$K$21+($L$34-$E$13)*$K$25)+($L$34-$E$13)*($K$19+($L$34-$E$13)*$K$22)","v":56.312492808419847},{"$f":"$K$16+(AC$41-$C$13)*($K$17+(AC$41-$C$13)*$K$20+($AA42-$D$13)*$K$23+($L$34-$E$13)*$K$24)+($AA42-$D$13)*($K$18+($AA42-$D$13)*$K$21+($L$34-$E$13)*$K$25)+($L$34-$E$13)*($K$19+($L$34-$E$13)*$K$22)","v":51.977720132938792},47.967566149191583,44.282030857178228,40.921114256898733,null,"Axial -",{"$f":"C$13-$D$4*AI41","v":-1.5249999999999999},{"$f":"D$13-$D$4*AJ41","v":-1.5249999999999999},{"$f":"E$13-$D$4*AK41","v":-1.5249999999999999}]
[null,"Method:","SH",null,null,null,null,null,null,null,null,null,null,null,null,null,"In the optimizer plot, the curve for F1, F2 & F3 has the value given in Table 5",null,null,null,null,null,null,null,null,null,{"$f":"AJ$40-0.5*$D$4*AJ$41","v":-0.76249999999999996},{"$f":"$K$16+(AB$41-$C$13)*($K$17+(AB$41-$C$13)*$K$20+($AA43-$D$13)*$K$23+($L$34-$E$13)*$K$24)+($AA43-$D$13)*($K$18+($AA43-$D$13)*$K$21+($L$34-$E$13)*$K$25)+($L$34-$E$13)*($K$19+($L$34-$E$13)*$K$22)","v":58.66176253369936},55.059561733218302,51.781979624471091,48.829016207457734,46.200671482178237,null,"Axial +",{"$f":"C$13+$D$4*AI41","v":1.5249999999999999},{"$f":"D$13+$D$4*AJ41","v":1.5249999999999999},{"$f":"E$13+$D$4*AK41","v":1.5249999999999999}]
[null,"Design no:",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F2",{"$f":"AJ$40-0*$D$4*AJ$41","v":0},60.056557200712724,57.186928275231665,54.641918041484452,52.421526499471092,50.525753649191593]
[null,"Free text:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If you change something, the optimization may be wrong, and two warnings is given:",null,null,null,null,null,null,null,null,null,{"$f":"AJ$40+0.5*$D$4*AJ$41","v":0.76249999999999996},60.496876809459948,58.35981975897888,56.547381400231664,55.059561733218302,53.896360757938801,null,null,"Day"]
[null,"Design:","3 factors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red text in cell J14",null,null,null,null,null,null,null,null,{"$f":"AJ$40+1*$D$4*AJ$41","v":1.5249999999999999},59.982721359941017,58.578236184459946,57.498369700712729,56.743121908699365,56.312492808419861,null,"Run # ",1,2]
[null,"Run #","Group","Label",{"$f":"C10","v":"Salt"},{"$f":"D10","v":"Temp"},{"$f":"E10","v":"Time"},"Constant factors and comments",null,null,null,null,null,null,null,null,null,"The text \"Not updated\" in Table 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AK6=2,NA(),I16)","v":-0.98589708468867343},{"$f":"IF(AK6=1,NA(),I16)","v":{"$error":"#N/A"}}]
[null,{"$f":"IF($C$16=\"\",\"\",$B$16)","v":1},"A",{"$f":"IF(OR(B48=\"\",C48=\"\"),\"\",$C$43&TEXT(C$44,\"0\")&\"1\"&TEXT(B48,\"00\")&C48)","v":"SH1101A"},{"$f":"C$16","v":-1},{"$f":"D$16","v":-1},{"$f":"E$16","v":-1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Graph F2 & F3",null,null,null,"F3",null,null,null,2,-0.69177595041340822,{"$error":"#N/A"}]
[null,{"$f":"IF($C$17=\"\",\"\",$B$17)","v":2},"A",{"$f":"IF(OR(B49=\"\",C49=\"\"),\"\",$C$43&TEXT(C$44,\"0\")&\"1\"&TEXT(B49,\"00\")&C49)","v":"SH1102A"},{"$f":"C$17","v":1},{"$f":"D$17","v":-1},{"$f":"E$17","v":-1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK$40-1*$D$4*AK$41","v":-1.5249999999999999},{"$f":"AK$40-0.5*$D$4*AK$41","v":-0.76249999999999996},{"$f":"AK$40-0*$D$4*AK$41","v":0},{"$f":"AK$40+0.5*$D$4*AK$41","v":0.76249999999999996},{"$f":"AK$40+1*$D$4*AK$41","v":1.5249999999999999},null,3,-1.2800182189639386,{"$error":"#N/A"}]
[null,{"$f":"IF($C$18=\"\",\"\",$B$18)","v":3},"A","SH1103A",{"$f":"C$18","v":-1},{"$f":"D$18","v":1},{"$f":"E$18","v":-1},null,null,null,null,null,null,null,null,null,"Factor:",1,"Factor:",2,"Factor:",3,"Data for Optimizer",null,null,null,{"$f":"AJ$40-1*$D$4*AJ$41","v":-1.5249999999999999},{"$f":"$K$16+($L$32-$C$13)*($K$17+($L$32-$C$13)*$K$20+($AA50-$D$13)*$K$23+(AB$49-$E$13)*$K$24)+($AA50-$D$13)*($K$18+($AA50-$D$13)*$K$21+(AB$49-$E$13)*$K$25)+(AB$49-$E$13)*($K$19+(AB$49-$E$13)*$K$22)","v":58.7439019470836},{"$f":"$K$16+($L$32-$C$13)*($K$17+($L$32-$C$13)*$K$20+($AA50-$D$13)*$K$23+(AC$49-$E$13)*$K$24)+($AA50-$D$13)*($K$18+($AA50-$D$13)*$K$21+(AC$49-$E$13)*$K$25)+(AC$49-$E$13)*($K$19+(AC$49-$E$13)*$K$22)","v":58.159652160179405},57.26047419000907,56.046368036572581,54.517333699869972,null,4,-0.98589708468867343,{"$error":"#N/A"}]
[null,{"$f":"IF($C$19=\"\",\"\",$B$19)","v":4},"A","SH1104A",{"$f":"C$19","v":1},{"$f":"D$19","v":1},{"$f":"E$19","v":-1},null,null,null,null,null,null,null,null,null,{"$f":"AI$40-1*$D$4*AI$41","v":-1.5249999999999999},{"$f":"$K$16+($Q51-$C$13)*($K$17+($Q51-$C$13)*$K$20+(L$33-$D$13)*$K$23+(L$34-$E$13)*$K$24)+(L$33-$D$13)*($K$18+(L$33-$D$13)*$K$21+(L$34-$E$13)*$K$25)+(L$34-$E$13)*($K$19+(L$34-$E$13)*$K$22)","v":60.346402499783522},{"$f":"AJ$40-1*$D$4*AJ$41","v":-1.5249999999999999},{"$f":"$K$16+(L$32-$C$13)*($K$17+(L$32-$C$13)*$K$20+($S51-$D$13)*$K$23+(L$34-$E$13)*$K$24)+($S51-$D$13)*($K$18+($S51-$D$13)*$K$21+(L$34-$E$13)*$K$25)+(L$34-$E$13)*($K$19+(L$34-$E$13)*$K$22)","v":56.237774100941948},{"$f":"AK$40-1*$D$4*AK$41","v":-1.5249999999999999},{"$f":"$K$16+(L$32-$C$13)*($K$17+(L$32-$C$13)*$K$20+(L$33-$D$13)*$K$23+($U51-$E$13)*$K$24)+(L$33-$D$13)*($K$18+(L$33-$D$13)*$K$21+($U51-$E$13)*$K$25)+($U51-$E$13)*($K$19+($U51-$E$13)*$K$22)","v":55.63288044338001},{"$f":"MIN(0,MIN(R51:R61,T51:T61,V51:V61))","v":0},{"$f":"MAX(R51:R61,T51:T61,V51:V61)","v":61.446617472297739},null,null,{"$f":"AJ$40-0.5*$D$4*AJ$41","v":-0.76249999999999996},{"$f":"$K$16+($L$32-$C$13)*($K$17+($L$32-$C$13)*$K$20+($AA51-$D$13)*$K$23+(AB$49-$E$13)*$K$24)+($AA51-$D$13)*($K$18+($AA51-$D$13)*$K$21+(AB$49-$E$13)*$K$25)+(AB$49-$E$13)*($K$19+(AB$49-$E$13)*$K$22)","v":58.114220905790866},58.576502368886665,58.723855648716331,58.556280745279842,58.073777658577214,null,5,-0.78001229069598566,{"$error":"#N/A"}]
[null,{"$f":"IF($C$20=\"\",\"\",$B$20)","v":5},"A","SH1105A",{"$f":"C$20","v":-1},{"$f":"D$20","v":-1},{"$f":"E$20","v":1},null,null,null,null,null,null,null,null,null,{"$f":"AI$40-0.8*$D$4*AI$41","v":-1.22},{"$f":"$K$16+($Q52-$C$13)*($K$17+($Q52-$C$13)*$K$20+(L$33-$D$13)*$K$23+(L$34-$E$13)*$K$24)+(L$33-$D$13)*($K$18+(L$33-$D$13)*$K$21+(L$34-$E$13)*$K$25)+(L$34-$E$13)*($K$19+(L$34-$E$13)*$K$22)","v":59.276360555912234},{"$f":"AJ$40-0.8*$D$4*AJ$41","v":-1.22},{"$f":"$K$16+(L$32-$C$13)*($K$17+(L$32-$C$13)*$K$20+($S52-$D$13)*$K$23+(L$34-$E$13)*$K$24)+($S52-$D$13)*($K$18+($S52-$D$13)*$K$21+(L$34-$E$13)*$K$25)+(L$34-$E$13)*($K$19+(L$34-$E$13)*$K$22)","v":57.296890573591924},{"$f":"AK$40-0.8*$D$4*AK$41","v":-1.22},{"$f":"$K$16+(L$32-$C$13)*($K$17+(L$32-$C$13)*$K$20+(L$33-$D$13)*$K$23+($U52-$E$13)*$K$24)+(L$33-$D$13)*($K$18+(L$33-$D$13)*$K$21+($U52-$E$13)*$K$25)+($U52-$E$13)*($K$19+($U52-$E$13)*$K$22)","v":56.441002438223414},"X","Y",null,"F2",{"$f":"AJ$40-0*$D$4*AJ$41","v":0},56.530064806231977,58.038877519327777,59.232762049157444,60.111718395720956,60.675746559018336,null,6,-0.48589115642072045,{"$error":"#N/A"}]
[null,{"$f":"IF($C$21=\"\",\"\",$B$21)","v":6},"A","SH1106A",{"$f":"C$21","v":1},{"$f":"D$21","v":-1},{"$f":"E$21","v":1},null,null,null,null,null,null,null,null,null,{"$f":"AI$40-0.6*$D$4*AI$41","v":-0.91499999999999992},58.258257602718352,{"$f":"AJ$40-0.6*$D$4*AJ$41","v":-0.91499999999999992},58.203291036919325,{"$f":"AK$40-0.6*$D$4*AK$41","v":-0.91499999999999992},57.198735923744216,{"$f":"L32","v":-1.5123235088570512},{"$f":"$W$51","v":0},null,null,{"$f":"AJ$40+0.5*$D$4*AJ$41","v":0.76249999999999996},53.991433648406939,56.546777611502741,58.787193391332401,60.712680987895922,62.323240401193296,null,7,-1.0741334249712509,{"$error":"#N/A"}]
[null,{"$f":"IF($C$22=\"\",\"\",$B$22)","v":7},"A","SH1107A",{"$f":"C$22","v":-1},{"$f":"D$22","v":1},{"$f":"E$22","v":1},null,null,null,null,null,null,null,null,null,{"$f":"AI$40-0.4*$D$4*AI$41","v":-0.61},57.292093640201898,{"$f":"AJ$40-0.4*$D$4*AJ$41","v":-0.61},58.95697549092413,{"$f":"AK$40-0.4*$D$4*AK$41","v":-0.61},57.906080899942445,{"$f":"L32","v":-1.5123235088570512},{"$f":"$X$51","v":61.446617472297739},null,null,{"$f":"AJ$40+1*$D$4*AJ$41","v":1.5249999999999999},50.498327432315754,54.100202645411557,57.387149675241218,60.35916852180474,63.016259185102122,null,8,-0.78001229069598566,{"$error":"#N/A"}]
[null,{"$f":"IF($C$23=\"\",\"\",$B$23)","v":8},"A","SH1108A",{"$f":"C$23","v":1},{"$f":"D$23","v":1},{"$f":"E$23","v":1},null,null,null,null,null,null,null,null,null,{"$f":"AI$40-0.2*$D$4*AI$41","v":-0.30499999999999999},56.377868668362851,{"$f":"AJ$40-0.2*$D$4*AJ$41","v":-0.30499999999999999},59.55794393560636,{"$f":"AK$40-0.2*$D$4*AK$41","v":-0.30499999999999999},58.563037366818094,{"$f":"(L33-S51)*AI41/AJ41+Q51","v":0.30383520512410955},{"$f":"$W$51","v":0},null,null,null,null,null,null,null,null,null,9,{"$error":"#N/A"},1.9043862231911532]
[null,{"$f":"IF($C$24=\"\",\"\",$B$24)","v":9},"E","SH1109E",{"$f":"C$24","v":-1.5249999999999999},{"$f":"D$24","v":0},{"$f":"E$24","v":0},null,null,null,null,null,null,null,null,null,{"$f":"AI$40","v":0},55.515582687201224,{"$f":"AJ$40","v":0},60.006196370966002,{"$f":"AK$40","v":0},59.169605324371155,{"$f":"W55","v":0.30383520512410955},{"$f":"$X$51","v":61.446617472297739},null,"Graph F1 & F3",null,null,null,"F3",null,null,null,10,{"$error":"#N/A"},1.1329209529609372]
[null,{"$f":"IF($C$25=\"\",\"\",$B$25)","v":10},"E","SH1110E",{"$f":"C$25","v":1.5249999999999999},{"$f":"D$25","v":0},{"$f":"E$25","v":0},null,null,null,null,null,null,null,null,null,{"$f":"AI$40+0.2*$D$4*AI$41","v":0.30499999999999999},54.705235696717011,{"$f":"AJ$40+0.2*$D$4*AJ$41","v":0.30499999999999999},60.301732797003062,{"$f":"AK$40+0.2*$D$4*AK$41","v":0.30499999999999999},59.725784772601635,{"$f":"(L34-U51)*AI41/AK41+Q51","v":0.65432947572884492},{"$f":"$W$51","v":0},null,null,null,{"$f":"AK$40-1*$D$4*AK$41","v":-1.5249999999999999},{"$f":"AK$40-0.5*$D$4*AK$41","v":-0.76249999999999996},{"$f":"AK$40-0*$D$4*AK$41","v":0},{"$f":"AK$40+0.5*$D$4*AK$41","v":0.76249999999999996},{"$f":"AK$40+1*$D$4*AK$41","v":1.5249999999999999},null,11,{"$error":"#N/A"},1.1329209529609443]
[null,{"$f":"IF($C$26=\"\",\"\",$B$26)","v":11},"E","SH1111E",{"$f":"C$26","v":0},{"$f":"D$26","v":-1.5249999999999999},{"$f":"E$26","v":0},null,null,null,null,null,null,null,null,null,{"$f":"AI$40+0.4*$D$4*AI$41","v":0.61},53.946827696910219,{"$f":"AJ$40+0.4*$D$4*AJ$41","v":0.61},60.444553213717533,{"$f":"AK$40+0.4*$D$4*AK$41","v":0.61},60.231575711509535,{"$f":"W57","v":0.65432947572884492},{"$f":"$X$51","v":61.446617472297739},null,null,{"$f":"AI$40-1*$D$4*AI$41","v":-1.5249999999999999},{"$f":"$K$16+($AA58-$C$13)*($K$17+($AA58-$C$13)*$K$20+($L$33-$D$13)*$K$23+(AB$57-$E$13)*$K$24)+($L$33-$D$13)*($K$18+($L$33-$D$13)*$K$21+(AB$57-$E$13)*$K$25)+(AB$57-$E$13)*($K$19+(AB$57-$E$13)*$K$22)","v":55.628661050691569},{"$f":"$K$16+($AA58-$C$13)*($K$17+($AA58-$C$13)*$K$20+($L$33-$D$13)*$K$23+(AC$57-$E$13)*$K$24)+($L$33-$D$13)*($K$18+($L$33-$D$13)*$K$21+(AC$57-$E$13)*$K$25)+(AC$57-$E$13)*($K$19+(AC$57-$E$13)*$K$22)","v":57.571886066913912},59.200182899870114,60.513551549560162,61.511992015984085,null,12,{"$error":"#N/A"},1.9043862231911532]
[null,{"$f":"IF($C$27=\"\",\"\",$B$27)","v":12},"E","SH1112E",{"$f":"C$27","v":0},{"$f":"D$27","v":1.5249999999999999},{"$f":"E$27","v":0},null,null,null,null,null,null,null,null,null,{"$f":"AI$40+0.6*$D$4*AI$41","v":0.91499999999999992},53.240358687780841,{"$f":"AJ$40+0.6*$D$4*AJ$41","v":0.91499999999999992},60.43465762110943,{"$f":"AK$40+0.6*$D$4*AK$41","v":0.91499999999999992},60.686978141094848,{"$f":"AA58","v":-1.5249999999999999},{"$f":"$L$35","v":60.300894641038006},null,null,{"$f":"AI$40-0.5*$D$4*AI$41","v":-0.76249999999999996},{"$f":"$K$16+($AA59-$C$13)*($K$17+($AA59-$C$13)*$K$20+($L$33-$D$13)*$K$23+(AB$57-$E$13)*$K$24)+($L$33-$D$13)*($K$18+($L$33-$D$13)*$K$21+(AB$57-$E$13)*$K$25)+(AB$57-$E$13)*($K$19+(AB$57-$E$13)*$K$22)","v":56.042071503971336},56.93876527019367,57.520530853149872,57.787368252839926,57.73927746926384,null,13,{"$error":"#N/A"},1.7886664326566191]
[null,{"$f":"IF($C$28=\"\",\"\",$B$28)","v":13},"E","SH1113E",{"$f":"C$28","v":0},{"$f":"D$28","v":0},{"$f":"E$28","v":-1.5249999999999999},null,null,null,null,null,null,null,null,null,{"$f":"AI$40+0.8*$D$4*AI$41","v":1.22},52.585828669328883,{"$f":"AJ$40+0.8*$D$4*AJ$41","v":1.22},60.272046019178738,{"$f":"AK$40+0.8*$D$4*AK$41","v":1.22},61.09199206135758,{"$f":"AA62","v":1.5249999999999999},{"$f":"$L$35","v":60.300894641038006},null,"F1",{"$f":"AI$40-0*$D$4*AI$41","v":0},56.780100648984948,56.630263165207289,56.165497498163489,55.385803647853542,54.291181614277455,null,14,{"$error":"#N/A"},1.2486407434954785]
[null,{"$f":"IF($C$29=\"\",\"\",$B$29)","v":14},"E","SH1114E",{"$f":"C$29","v":0},{"$f":"D$29","v":0},{"$f":"E$29","v":1.5249999999999999},null,null,null,null,null,null,null,null,null,{"$f":"AI$40+1*$D$4*AI$41","v":1.5249999999999999},51.983237641554339,{"$f":"AJ$40+1*$D$4*AJ$41","v":1.5249999999999999},59.956718407925464,{"$f":"AK$40+1*$D$4*AK$41","v":1.5249999999999999},61.446617472297739,null,null,null,null,{"$f":"AI$40+0.5*$D$4*AI$41","v":0.76249999999999996},57.842748485732415,56.646379751954761,55.135082834910961,53.308857734601013,51.167704451024925,null,15,2.3545458338462382,{"$error":"#N/A"}]
[null,{"$f":"IF($C$30=\"\",\"\",$B$30)","v":15},"A","SH1115A",{"$f":"C$30","v":0},{"$f":"D$30","v":0},{"$f":"E$30","v":0},null,null,null,null,null,null,null,null,null,"Min 1&2",{"$f":"ROUND(MIN(AB42:AF46),3-LOG(MIN(AB42:AF46)))","v":40.9},"Min 1&3",{"$f":"ROUND(MIN(AB58:AF62),3-LOG(MIN(AB58:AF62)))","v":48.4},"Min 2&3",{"$f":"ROUND(MIN(AB50:AF54),3-LOG(MIN(AB50:AF54)))","v":50.5},null,null,null,null,{"$f":"AI$40+1*$D$4*AI$41","v":1.5249999999999999},59.230015014213741,56.98711503043608,54.429286863392285,51.556530513082336,48.368845979506247,null,16,2.3545458338462382,{"$error":"#N/A"}]
[null,{"$f":"IF($C$31=\"\",\"\",$B$31)","v":16},"A","SH1116A",{"$f":"C$31","v":0},{"$f":"D$31","v":0},{"$f":"E$31","v":0},null,null,null,null,null,null,null,null,null,"Max 1&2",{"$f":"ROUND(MAX(AB42:AF46),3-LOG(MAX(AB42:AF46)))","v":60.5},"Max 1&3",{"$f":"ROUND(MAX(AB58:AF62),3-LOG(MAX(AB58:AF62)))","v":61.5},"Max 2&3",{"$f":"ROUND(MAX(AB50:AF54),3-LOG(MAX(AB50:AF54)))","v":63},null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF(H32=\"\",NA(),IF(AK22=2,NA(),I32))","v":2.3545458338462382},{"$f":"IF(H32=\"\",NA(),IF(AK22=1,NA(),I32))","v":{"$error":"#N/A"}}]
[null,{"$f":"IF($C$32=\"\",\"\",$B$32)","v":17},"A","SH1117A",{"$f":"C$32","v":0},{"$f":"D$32","v":0},{"$f":"E$32","v":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,null,null,18,{"$f":"IF(H33=\"\",NA(),IF(AK23=2,NA(),I33))","v":{"$error":"#N/A"}},{"$f":"IF(H33=\"\",NA(),IF(AK23=1,NA(),I33))","v":-9.1119215284562429}]
[null,{"$f":"IF($C$33=\"\",\"\",$B$33)","v":18},"E","SH1118E",{"$f":"C$33","v":0},{"$f":"D$33","v":0},{"$f":"E$33","v":0},null,null,null,null,null,null,null,null,null,"Target","Max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"IF($C$34=\"\",\"\",B34)","v":""},"E","",{"$f":"C$34","v":""},{"$f":"D$34","v":""},{"$f":"E$34","v":""},null,null,null,null,null,null,null,null,null,"IF…",{"$f":"IF(SUM(K16:K26)<>R68,_xlfn.TEXTSPLIT(\"-Not updated\",,\"-\",FALSE),_xlfn.TEXTSPLIT(\"-\"&R65,,\"-\",FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"IF($C$35=\"\",\"\",$B$35)","v":""},"E","",{"$f":"C$35","v":""},{"$f":"D$35","v":""},{"$f":"E$35","v":""},null,null,null,null,null,null,null,null,null,"Result","Not updated"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Checksum",61.336464916750813]

{"sheet":"Box_Behnken","index":3,"n_rows":68,"n_cols":39,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Input!A1","v":"Response_Surface_1.3.xlsm"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!$I$1","v":"Author: Bo Svensmark, svensmark@plen.ku.dk, Analytical Chemistry,ECP, PLEN, University of Copenhagen 2024"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"The sheet is protected. To unprotect all cells: Review -> Unprotect Sheet"]
[null,"Table 1: Design parameters",null,null,null,"WHITE cells for user input"]
[null,"No of centre points",null,4,{"$f":"IF(OR(D4<2,D4>6),\"ERROR:\",\"\")","v":""},{"$f":"IF(OR(C3<2,C3>6),\"No must be 2 -  6\",\"2 to 6 center points\")","v":"No must be 2 -  6"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deaign matrix","Table 2: Factor levels to run",null,null,null,null,null,null,null,null,null,null,"1) Enter Design parameters in Table 1 and 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,"Run # ",1,2,3,"1^2","2^2","3^2",12,13,23,"Day",null,null,"Center is calcuated as the mean of High and Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"(C16-C$13)","v":-1},{"$f":"(D16-D$13)","v":-1},{"$f":"(E16-E$13)","v":0},{"$f":"AA6^2","v":1},1,0,{"$f":"AA6*AB6","v":1},{"$f":"AA6*AC6","v":0},{"$f":"AB6*AC6","v":0},{"$f":"IF(C48=\"\",0,IF(CODE(UPPER(C48))>68,2,1))","v":1},null,"2) Enter Run parameters and groups in Table 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,2,1,-1,0,1,1,0,{"$f":"AA7*AB7","v":-1},{"$f":"AA7*AC7","v":0},{"$f":"AB7*AC7","v":0},{"$f":"IF(C49=\"\",0,IF(CODE(UPPER(C49))>68,2,1))","v":1},null,"3) Press Copy Table 3 to Runs to create a sheet for experiments to run "]
[null,"Table 2:","Factor levels",null,null,"    See AL4 for instructions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,-1,1,0,1,1,0,-1,0,0,1,null,"4) Run the experiments and enter results in Table 4 or in Sheet Input *)"]
[null,"Factor:",1,2,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,1,1,0,1,1,0,1,0,0,1,null,"5) Coefficients for the model can then be seen in Table 5"]
[null,"Name","Temp","Vol","Time",null,"Saved?","Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,-1,0,-1,1,0,1,0,1,0,1,null,"6) Go to Table 6 to find the optimum settings"]
[null,"Unit","Degree","ml","min",null,"Output #",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,1,0,-1,1,0,1,0,-1,0,1]
[null,"Low",-1,-1,-1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,-1,0,1,1,0,1,0,-1,0,1,null,"*) For results in Sheet Input:"]
[null,"Center",{"$f":"(C14+C12)/2","v":0},{"$f":"(D14+D12)/2","v":0},{"$f":"(E14+E12)/2","v":0},"Analyte:","Rel.Area:",100,null,"Comment:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,1,0,1,1,0,1,0,1,0,1,null,"1) Follow the instructions in Sheet Input for the data"]
[null,"High",1,1,1,"B&B test",null,null,null,{"$f":"IF($K$35=\"Not updated\",\"Please press Maximum or Minimum\",\"\")","v":"Please press Maximum or Minimum"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,-1,-1,0,1,1,0,0,1,2,null,"2) Press the button Start  to load data for the first dataset to analyze"]
[null,"Run #",{"$f":"C10","v":"Temp"},{"$f":"D10","v":"Vol"},{"$f":"E10","v":"Time"},"Table 4: Responses",null,"Mean","Residuals","Table 5: Coefficients",null,"SE","P",null,null,null,null,null,null,null,null,null,null,null,null,10,0,1,-1,0,1,1,0,0,-1,2,null,"3) Press Save results or Save results and load next analyte"]
[null,1,{"$f":"C$12","v":-1},{"$f":"D$12","v":-1},{"$f":"E$13","v":0},56.595035990963126,null,{"$f":"AVERAGE(F16:G16)","v":56.595035990963126},{"$f":"IF(C16=\"\",\"\",H16-($K$16+(C16-$C$13)*($K$17+(C16-$C$13)*$K$20+(D16-$D$13)*($K$23+(E16-$E$13)*$K$26)+(E16-$E$13)*$K$24)+(D16-$D$13)*($K$18+(D16-$D$13)*$K$21+(E16-$E$13)*$K$25)+(E16-$E$13)*($K$19+(E16-$E$13)*$K$22)))","v":-0.27259085327811761},"Const",{"$f":"VLOOKUP($D$4,$Z$29:$AJ$38,11,FALSE)","v":59.42664613836768},{"$f":"VLOOKUP($D$4&\"s\",$Z$29:$AJ$38,11,FALSE)","v":0.29315569912537742},{"$f":"IF(L16=0,\"na\",_xlfn.T.DIST.2T(ABS(K16/L16),COUNT($C$16:$C$35)-10))","v":9.7238903757072789E-13},null,null,null,null,null,null,null,null,null,null,null,null,11,0,-1,1,0,1,1,0,0,-1,2,null,"4) The optimizer will automatically find the maximum"]
[null,2,{"$f":"C$14","v":1},{"$f":"D$12","v":-1},{"$f":"E$13","v":0},48.955802444817529,null,{"$f":"AVERAGE(F17:G17)","v":48.955802444817529},-0.40632498034205611,1,{"$f":"VLOOKUP($D$4,$Z$29:$AJ$38,10,FALSE)","v":-2.2817554944335345},{"$f":"VLOOKUP($D$4&\"s\",$Z$29:$AJ$38,10,FALSE)","v":0.20729238279503764},{"$f":"IF(L17=0,\"na\",_xlfn.T.DIST.2T(ABS(K17/L17),COUNT($C$16:$C$35)-10))","v":3.3423756413622956E-5},null,null,null,null,null,null,null,null,null,null,null,null,12,0,1,1,0,1,1,0,0,1,2,null,"5) If you want to find the Minimum press this button"]
[null,3,{"$f":"C$12","v":-1},{"$f":"D$14","v":1},{"$f":"E$13","v":0},59.169891480373309,null,59.169891480373309,0.4063249803420419,2,{"$f":"VLOOKUP($D$4,$Z$29:$AJ$38,9,FALSE)","v":2.4189640430023087},{"$f":"VLOOKUP($D$4&\"s\",$Z$29:$AJ$38,9,FALSE)","v":0.20729238279503759},2.3869582594791526E-5,null,null,null,null,null,null,null,null,null,null,null,null,13,0,0,0,0,0,0,0,0,0,1]
[null,4,{"$f":"C$14","v":1},{"$f":"D$14","v":1},{"$f":"E$13","v":0},57.414634794656891,null,57.414634794656891,0.2725908532781034,3,{"$f":"VLOOKUP($D$4,$Z$29:$AJ$38,8,FALSE)","v":-1.729966924430471},{"$f":"VLOOKUP($D$4&\"s\",$Z$29:$AJ$38,8,FALSE)","v":0.20729238279503759},1.607944348950467E-4,null,null,null,null,null,null,null,null,null,null,null,null,14,0,0,0,0,0,0,0,0,0,1]
[null,5,{"$f":"C$12","v":-1},{"$f":"D$13","v":0},{"$f":"E$12","v":-1},57.495943307008687,null,57.495943307008687,-3.719198137750368E-2,"1^2",{"$f":"VLOOKUP($D$4,$Z$29:$AJ$38,7,FALSE)","v":-1.6942665301269275},{"$f":"VLOOKUP($D$4&\"s\",$Z$29:$AJ$38,7,FALSE)","v":0.29315569912537742},1.1729359815603395E-3,null,null,null,null,null,null,null,null,null,null,null,null,15,{"$f":"IF(C30=\"\",\"\",C30-C$13)","v":0},0,0,{"$f":"IF(AA20=\"\",\"\",AA20^2)","v":0},0,0,{"$f":"IF(AA20=\"\",\"\",AA20*AB20)","v":0},{"$f":"IF(AA20=\"\",\"\",AA20*AC20)","v":0},{"$f":"IF(AB20=\"\",\"\",AB20*AC20)","v":0},2]
[null,6,{"$f":"C$14","v":1},{"$f":"D$13","v":0},{"$f":"E$12","v":-1},58.77906224643295,null,58.77906224643295,9.6542145686434822E-2,"2^2",{"$f":"VLOOKUP($D$4,$Z$29:$AJ$38,6,FALSE)","v":-2.1985384305380351},{"$f":"VLOOKUP($D$4&\"s\",$Z$29:$AJ$38,6,FALSE)","v":0.29315569912537742},2.9065963015068854E-4,null,null,null,null,null,null,null,null,null,null,null,null,16,0,0,0,0,0,0,{"$f":"IF(AA21=\"\",\"\",AA21*AB21)","v":0},{"$f":"IF(AA21=\"\",\"\",AA21*AC21)","v":0},{"$f":"IF(AB21=\"\",\"\",AB21*AC21)","v":0},2]
[null,7,{"$f":"C$12","v":-1},{"$f":"D$13","v":0},{"$f":"E$14","v":1},59.68955509506619,null,59.68955509506619,-9.6542145686449032E-2,"3^2",{"$f":"VLOOKUP($D$4,$Z$29:$AJ$38,5,FALSE)","v":-1.3545188381048725},{"$f":"VLOOKUP($D$4&\"s\",$Z$29:$AJ$38,5,FALSE)","v":0.29315569912537742},3.6135524312146962E-3,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF( C32=\"\",\"\",(C32-C$13))","v":""},{"$f":"IF( D32=\"\",\"\",(D32-D$13))","v":""},"","","","","","","",2]
[null,8,{"$f":"C$14","v":1},{"$f":"D$13","v":0},{"$f":"E$14","v":1},49.546882432035673,null,49.546882432035673,3.7191981377496575E-2,12,{"$f":"VLOOKUP($D$4,$Z$29:$AJ$38,4,FALSE)","v":1.4709942151072954},{"$f":"VLOOKUP($D$4&\"s\",$Z$29:$AJ$38,4,FALSE)","v":0.29315569912537742},2.4093333370916259E-3,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"IF( C33=\"\",\"\",(C33-C$13))","v":""},"","","","","","","","",2]
[null,9,{"$f":"C$13","v":0},{"$f":"D$12","v":-1},{"$f":"E$12","v":-1},58.112538459621689,null,58.112538459621689,0.30978283465559997,13,{"$f":"VLOOKUP($D$4,$Z$29:$AJ$38,3,FALSE)","v":-2.8564479006136967},{"$f":"VLOOKUP($D$4&\"s\",$Z$29:$AJ$38,3,FALSE)","v":0.29315569912537742},6.7146178161820702E-5]
[null,10,{"$f":"C$13","v":0},{"$f":"D$14","v":1},{"$f":"E$12","v":-1},57.035222964379841,null,57.035222964379841,-0.36913299896455953,23,{"$f":"VLOOKUP($D$4,$Z$29:$AJ$38,2,FALSE)","v":2.6181638738131521},{"$f":"VLOOKUP($D$4&\"s\",$Z$29:$AJ$38,2,FALSE)","v":0.29315569912537742},1.0993933504682602E-4]
[null,11,{"$f":"C$13","v":0},{"$f":"D$12","v":-1},{"$f":"E$14","v":1},49.475627027443387,null,49.475627027443387,0.36913299896454532]
[null,12,{"$f":"C$13","v":0},{"$f":"D$14","v":1},{"$f":"E$14","v":1},58.870967027454149,null,58.870967027454149,-0.30978283465561418,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regression coefficients:"]
[null,13,0,0,0,60.334073159624253,null,60.334073159624253,0.9074270212565736,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nc",23,13,12,"3^2","2^2","1^2",3,2,1,"Const"]
[null,14,0,0,0,59.124170464615482,null,59.124170464615482,-0.3024756737521983,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"LINEST(H16:H29,AA6:AI19,TRUE,TRUE)","v":2.6181638738131525},-2.856447900613694,1.4709942151072952,-1.5057566749809699,-2.3497762674141303,-1.845504367003022,-1.7299669244304712,2.4189640430023069,-2.2817554944335345,59.729121812119871]
[null,15,{"$f":"IF($D$4>2,C13,\"\")","v":0},{"$f":"IF($D$4>2,D13,\"\")","v":0},{"$f":"IF($D$4>2,E13,\"\")","v":0},59.124170464615482,null,{"$f":"IF(F30=\"\",\"\",AVERAGE(F30:G30))","v":59.124170464615482},-0.3024756737521983,"Table 6: Optimization and estimation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2s",0.32563401633056116,0.32563401633056116,0.32563401633056116,0.36406989815070578,0.36406989815070567,0.36406989815070567,0.23025802113235072,0.23025802113235072,0.2302580211323508,0.46051604226470161]
[null,16,{"$f":"IF($D$4>3,C13,\"\")","v":0},{"$f":"IF($D$4>3,D13,\"\")","v":0},{"$f":"IF($D$4>3,E13,\"\")","v":0},59.124170464615482,null,{"$f":"IF(F31=\"\",\"\",AVERAGE(F31:G31))","v":59.124170464615482},-0.3024756737521983,"Factor","Name","Value","Units",null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(AA20=\"\",\"\",LINEST(H16:H30,AA6:AI20,TRUE,TRUE))","v":2.6181638738131525},-2.8564479006136936,1.4709942151072959,-1.4049314503969061,-2.248951042830067,-1.7446791424189583,-1.7299669244304705,2.4189640430023087,-2.2817554944335341,59.527471362951751]
[null,17,{"$f":"IF($D$4>4,C13,\"\")","v":""},{"$f":"IF($D$4>4,D13,\"\")","v":""},{"$f":"IF($D$4>4,E13,\"\")","v":""},null,null,{"$f":"IF(F32=\"\",\"\",AVERAGE(F32:G32))","v":""},"",1,{"$f":"C10","v":"Temp"},-1,{"$f":"C11","v":"Degree"},null,null,null,null,null,null,null,null,null,null,null,null,"3s",0.31149459251834588,0.31149459251834588,0.31149459251834588,0.32421385113149914,0.32421385113149914,0.32421385113149914,0.22025993867266278,0.22025993867266283,0.22025993867266283,0.3596829736831596]
[null,18,{"$f":"IF($D$4>5,C13,\"\")","v":""},{"$f":"IF($D$4>5,D13,\"\")","v":""},{"$f":"IF($D$4>5,E13,\"\")","v":""},null,null,{"$f":"IF(F33=\"\",\"\",AVERAGE(F33:G33))","v":""},"",2,{"$f":"D10","v":"Vol"},0.89055140453711779,{"$f":"D11","v":"ml"},null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(AA21=\"\",\"\",LINEST(H16:H31,AA6:AI21,TRUE,TRUE))","v":2.6181638738131521},-2.8564479006136967,1.4709942151072954,-1.3545188381048725,-2.1985384305380351,-1.6942665301269275,-1.729966924430471,2.4189640430023087,-2.2817554944335345,59.42664613836768]
[null,null,null,null,null,null,null,null,null,3,{"$f":"E10","v":"Time"},1,{"$f":"E11","v":"min"},null,null,null,null,null,null,null,null,null,null,null,null,"4s",0.29315569912537742,0.29315569912537742,0.29315569912537742,0.29315569912537742,0.29315569912537742,0.29315569912537742,0.20729238279503759,0.20729238279503759,0.20729238279503764,0.29315569912537742]
[null,null,null,null,null,null,null,null,null,"Response",{"$f":"R67","v":"Not updated"},{"$f":"$K$16+($L32-$C$13)*($K$17+($L32-$C$13)*$K$20+(L$33-$D$13)*$K$23+(L$34-$E$13)*$K$24)+(L$33-$D$13)*($K$18+(L$33-$D$13)*$K$21+(L$34-$E$13)*$K$25)+(L$34-$E$13)*($K$19+(L$34-$E$13)*$K$22)","v":61.218301792651069},null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(AA22=\"\",\"\",LINEST(H16:H32,AA6:AI22,TRUE,TRUE))","v":""},"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Press the buttons to find the factor levels for Max or Min response",null,null,null,null,null,null,null,null,"5s","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"- or enter values for the factors in the white cells in Table 5 ",null,null,null,null,null,null,null,null,6,{"$f":"IF(AA23=\"\",\"\",LINEST(H16:H33,AA6:AI23,TRUE,TRUE))","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,"6s","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OBS: Optimize Max and Min are limited to values in the design"]
[null,"Table 3: Experiments",null,null,null,null,null,"Comments to the design:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Graph F1 & F2",null,null,null,"F1",null,null,null,"Center",{"$f":"C13","v":0},{"$f":"D13","v":0},{"$f":"E13","v":0}]
[null,"Date:","2024-09-11",null,null,null,null,null,null,null,null,null,null,null,null,null,"The contour and the optimizer plots shows the response with constant value from Table 5:",null,null,null,null,null,null,null,null,null,null,{"$f":"AI$40-1*AI$41","v":-1},{"$f":"AI$40-0.5*AI$41","v":-0.5},{"$f":"AI$40-0*AI$41","v":0},{"$f":"AI$40+0.5*AI$41","v":0.5},{"$f":"AI$40+1*AI$41","v":1},null,"Range/2",{"$f":"(C14-C12)/2","v":1},{"$f":"(D14-D12)/2","v":1},{"$f":"(E14-E12)/2","v":1}]
[null,"Group:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In the contour plot of F1 & 2, F3 has the value given in Table 5 ",null,null,null,null,null,null,null,null,null,{"$f":"AJ$40-1*AJ$41","v":-1},{"$f":"$K$16+(AB$41-$C$13)*($K$17+(AB$41-$C$13)*$K$20+($AA42-$D$13)*($K$23+($L$34-$E$13)*$K$26)+($L$34-$E$13)*$K$24)+($AA42-$D$13)*($K$18+($AA42-$D$13)*$K$21+($L$34-$E$13)*$K$25)+($L$34-$E$13)*($K$19+($L$34-$E$13)*$K$22)","v":54.021425108506435},51.987526201024373,49.106494028478842,45.378328590869849,40.803029888197386,null,"Min",{"$f":"C$13-AI41","v":-1},{"$f":"D$13-AJ41","v":-1},{"$f":"E$13-AK41","v":-1}]
[null,"Method:","TST",null,null,null,null,null,null,null,null,null,null,null,null,null,"In the optimizer plot, the curve for F1, F2 & F3 has the value given in Table 5",null,null,null,null,null,null,null,null,null,{"$f":"AJ$40-0.5*AJ$41","v":-0.5},57.453395782264046,55.787245428558805,53.273961809790094,49.913544925957922,45.705994777062287,null,"Max",{"$f":"C$13+AI41","v":1},{"$f":"D$13+AJ41","v":1},{"$f":"E$13+AK41","v":1}]
[null,"Design no:",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F2",{"$f":"AJ$40-0*AJ$41","v":0},59.786097240752639,58.487695440824218,56.342160375832336,53.349492045776991,49.509690450658177]
[null,"Free text:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If you change something, the optimization may be wrong, and two warnings is given:",null,null,null,null,null,null,null,null,null,{"$f":"AJ$40+0.5*AJ$41","v":0.5},61.019529483972214,60.088876237820621,58.311089726605559,55.686169950327034,52.214116908985048,null,null,"Day"]
[null,"Design:","Box_B.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red text in cell J14",null,null,null,null,null,null,null,null,{"$f":"AJ$40+1*AJ$41","v":1},61.153692511922763,60.590787819547998,59.180749862109764,56.923578639608067,53.819274152042901,null,"Run # ",1,2]
[null,"Run #","Group","Label",{"$f":"C10","v":"Temp"},{"$f":"D10","v":"Vol"},{"$f":"E10","v":"Time"},"Constant factors and comments to each run:",null,null,null,null,null,null,null,null,null,"The text \"Not updated\" in Table 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AJ6=1,I16,NA())","v":-0.27259085327811761},{"$f":"IF(AJ6=2,I16,NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"IF($C$16=\"\",\"\",$B$16)","v":1},"A",{"$f":"IF(OR(B48=\"\",C48=\"\"),\"\",$C$43&TEXT(C$44,\"0\")&\"1\"&TEXT(B48,\"00\")&C48)","v":"TST1101A"},{"$f":"$C$16","v":-1},{"$f":"$D$16","v":-1},{"$f":"$E$16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Graph F2 & F3",null,null,null,"F3",null,null,null,2,{"$f":"IF(AJ7=1,I17,NA())","v":-0.40632498034205611},{"$f":"IF(AJ7=2,I17,NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"IF($C$17=\"\",\"\",$B$17)","v":2},"A",{"$f":"IF(OR(B49=\"\",C49=\"\"),\"\",$C$43&TEXT(C$44,\"0\")&\"1\"&TEXT(B49,\"00\")&C49)","v":"TST1102A"},{"$f":"$C$17","v":1},{"$f":"$D$17","v":-1},{"$f":"$E$17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK$40-1*AK$41","v":-1},{"$f":"AK$40-0.5*AK$41","v":-0.5},{"$f":"AK$40-0*AK$41","v":0},{"$f":"AK$40+0.5*AK$41","v":0.5},{"$f":"AK$40+1*AK$41","v":1},null,3,0.4063249803420419,{"$error":"#N/A"}]
[null,{"$f":"IF($C$18=\"\",\"\",$B$18)","v":3},"A","TST1103A",{"$f":"$C$18","v":-1},{"$f":"$D$18","v":1},{"$f":"$E$18","v":0},null,null,null,null,null,null,null,null,null,"Factor:",1,"Factor:",2,"Factor:",3,"Data for Optimizer",null,null,null,{"$f":"AJ$40-1*AJ$41","v":-1},{"$f":"$K$16+($L$32-$C$13)*($K$17+($L$32-$C$13)*$K$20+($AA50-$D$13)*($K$23+(AB$49-$E$13)*$K$26)+(AB$49-$E$13)*$K$24)+($AA50-$D$13)*($K$18+($AA50-$D$13)*$K$21+(AB$49-$E$13)*$K$25)+(AB$49-$E$13)*($K$19+(AB$49-$E$13)*$K$22)","v":57.004790903766292},57.274838583529984,56.867626844241244,55.783155685900056,54.021425108506435,null,4,0.2725908532781034,{"$error":"#N/A"}]
[null,{"$f":"IF($C$19=\"\",\"\",$B$19)","v":4},"A","TST1104A",{"$f":"$C$19","v":1},{"$f":"$D$19","v":1},{"$f":"$E$19","v":0},null,null,null,null,null,null,null,null,null,{"$f":"AI$40-1*AI$41","v":-1},{"$f":"$K$16+($Q51-$C$13)*($K$17+($Q51-$C$13)*$K$20+(L$33-$D$13)*($K$23+(L$34-$E$13)*$K$26)+(L$34-$E$13)*$K$24)+(L$33-$D$13)*($K$18+(L$33-$D$13)*$K$21+(L$34-$E$13)*$K$25)+(L$34-$E$13)*($K$19+(L$34-$E$13)*$K$22)","v":61.218301792651069},{"$f":"AJ$40-1*AJ$41","v":-1},{"$f":"$K$16+(L$32-$C$13)*($K$17+(L$32-$C$13)*$K$20+($S51-$D$13)*($K$23+(L$34-$E$13)*$K$26)+(L$34-$E$13)*$K$24)+($S51-$D$13)*($K$18+($S51-$D$13)*$K$21+(L$34-$E$13)*$K$25)+(L$34-$E$13)*($K$19+(L$34-$E$13)*$K$22)","v":54.021425108506435},{"$f":"AK$40-1*AK$41","v":-1},{"$f":"$K$16+(L$32-$C$13)*($K$17+(L$32-$C$13)*$K$20+(L$33-$D$13)*($K$23+($U51-$E$13)*$K$26)+($U51-$E$13)*$K$24)+(L$33-$D$13)*($K$18+(L$33-$D$13)*$K$21+($U51-$E$13)*$K$25)+($U51-$E$13)*($K$19+($U51-$E$13)*$K$22)","v":54.302120810019332},{"$f":"MIN(0,MIN(R51:R61,T51:T61,V51:V61))","v":0},{"$f":"MAX(R51:R61,T51:T61,V51:V61)","v":61.231939606574834},null,null,{"$f":"AJ$40-0.5*AJ$41","v":-0.5},57.818597703710751,58.743186351927733,58.990515581092275,58.560585391204377,57.453395782264046,null,5,-3.719198137750368E-2,{"$error":"#N/A"}]
[null,{"$f":"IF($C$20=\"\",\"\",$B$20)","v":5},"A","TST1105A",{"$f":"$C$20","v":-1},{"$f":"$D$20","v":0},{"$f":"$E$20","v":-1},null,null,null,null,null,null,null,null,null,{"$f":"AI$40-0.8*AI$41","v":-0.8},61.06259625735327,{"$f":"AJ$40-0.8*AJ$41","v":-0.8},55.526125683841769,{"$f":"AK$40-0.8*AK$41","v":-0.8},55.481365690000253,"X","Y",null,"F2",{"$f":"AJ$40-0*AJ$41","v":0},57.533135288386191,59.112264905056456,60.014135102674288,60.23874588123968,59.786097240752639,null,6,9.6542145686434822E-2,{"$error":"#N/A"}]
[null,{"$f":"IF($C$21=\"\",\"\",$B$21)","v":6},"A","TST1106A",{"$f":"$C$21","v":1},{"$f":"$D$21","v":0},{"$f":"$E$21","v":-1},null,null,null,null,null,null,null,null,null,{"$f":"AI$40-0.6*AI$41","v":-0.6},60.771349399645324,{"$f":"AJ$40-0.6*AJ$41","v":-0.6},56.854943184734047,{"$f":"AK$40-0.6*AK$41","v":-0.6},56.552249062932795,{"$f":"L32","v":-1},{"$f":"$W$51","v":0},null,null,{"$f":"AJ$40+0.5*AJ$41","v":0.5},56.148403657792613,58.382074242916168,59.938485408987283,60.817637156005972,61.019529483972214,null,7,-9.6542145686449032E-2,{"$error":"#N/A"}]
[null,{"$f":"IF($C$22=\"\",\"\",$B$22)","v":7},"A","TST1107A",{"$f":"$C$22","v":-1},{"$f":"$D$22","v":0},{"$f":"$E$22","v":1},null,null,null,null,null,null,null,null,null,{"$f":"AI$40-0.4*AI$41","v":-0.4},60.344561219527215,{"$f":"AJ$40-0.4*AJ$41","v":-0.4},58.007877611183289,{"$f":"AK$40-0.4*AK$41","v":-0.4},57.514770928816944,{"$f":"L32","v":-1},{"$f":"$X$51","v":61.231939606574834},null,null,{"$f":"AJ$40+1*AJ$41","v":1},53.664402811930017,56.552614365506855,58.763566500031267,60.297259215503239,61.153692511922763,null,8,3.7191981377496575E-2,{"$error":"#N/A"}]
[null,{"$f":"IF($C$23=\"\",\"\",$B$23)","v":8},"A","TST1108A",{"$f":"$C$23","v":1},{"$f":"$D$23","v":0},{"$f":"$E$23","v":1},null,null,null,null,null,null,null,null,null,{"$f":"AI$40-0.2*AI$41","v":-0.2},59.782231716998957,{"$f":"AJ$40-0.2*AJ$41","v":-0.2},58.984928963189489,{"$f":"AK$40-0.2*AK$41","v":-0.2},58.368931287652707,{"$f":"(L33-S51)*AI41/AJ41+Q51","v":0.8905514045371179},{"$f":"$W$51","v":0},null,null,null,null,null,null,null,null,null,9,{"$error":"#N/A"},0.30978283465559997]
[null,{"$f":"IF($C$24=\"\",\"\",$B$24)","v":9},"E","TST1109E",{"$f":"$C$24","v":0},{"$f":"$D$24","v":-1},{"$f":"$E$24","v":-1},null,null,null,null,null,null,null,null,null,{"$f":"AI$40","v":0},59.084360892060545,{"$f":"AJ$40","v":0},59.786097240752639,{"$f":"AK$40","v":0},59.11473013944007,{"$f":"W55","v":0.8905514045371179},{"$f":"$X$51","v":61.231939606574834},null,"Graph F1 & F3",null,null,null,"F3",null,null,null,10,{"$error":"#N/A"},-0.36913299896455953]
[null,{"$f":"IF($C$25=\"\",\"\",$B$25)","v":10},"E","TST1110E",{"$f":"$C$25","v":0},{"$f":"$D$25","v":1},{"$f":"$E$25","v":-1},null,null,null,null,null,null,null,null,null,{"$f":"AI$40+0.2*AI$41","v":0.2},58.250948744711977,{"$f":"AJ$40+0.2*AJ$41","v":0.2},60.411382443872753,{"$f":"AK$40+0.2*AK$41","v":0.2},59.752167484179054,{"$f":"(L34-U51)*AI41/AK41+Q51","v":1},{"$f":"$W$51","v":0},null,null,null,{"$f":"AK$40-1*AK$41","v":-1},{"$f":"AK$40-0.5*AK$41","v":-0.5},{"$f":"AK$40-0*AK$41","v":0},{"$f":"AK$40+0.5*AK$41","v":0.5},{"$f":"AK$40+1*AK$41","v":1},null,11,{"$error":"#N/A"},0.36913299896454532]
[null,{"$f":"IF($C$26=\"\",\"\",$B$26)","v":11},"E","TST1111E",{"$f":"$C$26","v":0},{"$f":"$D$26","v":-1},{"$f":"$E$26","v":1},null,null,null,null,null,null,null,null,null,{"$f":"AI$40+0.4*AI$41","v":0.4},57.281995274953253,{"$f":"AJ$40+0.4*AJ$41","v":0.4},60.860784572549818,{"$f":"AK$40+0.4*AK$41","v":0.4},60.281243321869638,{"$f":"W57","v":1},{"$f":"$X$51","v":61.231939606574834},null,null,{"$f":"AI$40-1*AI$41","v":-1},{"$f":"$K$16+($AA58-$C$13)*($K$17+($AA58-$C$13)*$K$20+($L$33-$D$13)*($K$23+(AB$57-$E$13)*$K$26)+(AB$57-$E$13)*$K$24)+($L$33-$D$13)*($K$18+($L$33-$D$13)*$K$21+(AB$57-$E$13)*$K$25)+(AB$57-$E$13)*($K$19+(AB$57-$E$13)*$K$22)","v":54.302120810019332},57.047055184255917,59.11473013944007,60.505145675571796,61.218301792651069,null,12,{"$error":"#N/A"},-0.30978283465561418]
[null,{"$f":"IF($C$27=\"\",\"\",$B$27)","v":12},"E","TST1112E",{"$f":"$C$27","v":0},{"$f":"$D$27","v":1},{"$f":"$E$27","v":1},null,null,null,null,null,null,null,null,null,{"$f":"AI$40+0.6*AI$41","v":0.6},56.177500482784382,{"$f":"AJ$40+0.6*AJ$41","v":0.6},61.13430362678384,{"$f":"AK$40+0.6*AK$41","v":0.6},60.701957652511844,{"$f":"AA58","v":-1},{"$f":"$L$35","v":61.218301792651069},null,null,{"$f":"AI$40-0.5*AI$41","v":-0.5},56.5151648928695,58.545987291952663,59.899550271983387,60.575853832961684,60.574897974887541,null,13,0.9074270212565736,{"$error":"#N/A"}]
[null,{"$f":"IF($C$28=\"\",\"\",$B$28)","v":13},"A","TST1113A",{"$f":"$C$28","v":0},{"$f":"$D$28","v":0},{"$f":"$E$28","v":0},null,null,null,null,null,null,null,null,null,{"$f":"AI$40+0.8*AI$41","v":0.8},54.937464368205347,{"$f":"AJ$40+0.8*AJ$41","v":0.8},61.231939606574834,{"$f":"AK$40+0.8*AK$41","v":0.8},61.014310476105649,{"$f":"AA62","v":1},{"$f":"$L$35","v":61.218301792651069},null,"F1",{"$f":"AI$40-0*AI$41","v":0},57.881075710656198,59.19778613458594,59.837237139463241,59.799428725288116,59.084360892060545,null,14,-0.3024756737521983,{"$error":"#N/A"}]
[null,{"$f":"IF($C$29=\"\",\"\",$B$29)","v":14},"A","TST1114A",{"$f":"$C$29","v":0},{"$f":"$D$29","v":0},{"$f":"$E$29","v":0},null,null,null,null,null,null,null,null,null,{"$f":"AI$40+1*AI$41","v":1},53.561886931216165,{"$f":"AJ$40+1*AJ$41","v":1},61.153692511922763,{"$f":"AK$40+1*AK$41","v":1},61.218301792651069,null,null,null,null,{"$f":"AI$40+0.5*AI$41","v":0.5},58.399853263379434,59.002451712155754,58.927790741879633,58.17587035255108,56.746690544170086,null,15,{"$f":"IF(H30=\"\",NA(),IF(AJ20=1,I30,NA()))","v":{"$error":"#N/A"}},{"$f":"IF(H30=\"\",NA(),IF(AJ20=2,I30,NA()))","v":-0.3024756737521983}]
[null,{"$f":"IF($C$30=\"\",\"\",$B$30)","v":15},"E","TST1115E",{"$f":"$C$30","v":0},{"$f":"$D$30","v":0},{"$f":"$E$30","v":0},null,null,null,null,null,null,null,null,null,"Min 1&2",{"$f":"MIN(AB42:AF46)","v":40.803029888197386},"Min 1&3",{"$f":"MIN(AB58:AF62)","v":53.561886931216165},"Min 2&3",{"$f":"MIN(AB50:AF54)","v":53.664402811930017},null,null,null,null,{"$f":"AI$40+1*AI$41","v":1},58.071497551039208,57.959984024662106,57.171211079232556,55.705178714750581,53.561886931216165,null,16,{"$f":"IF(H31=\"\",NA(),IF(AJ21=1,I31,NA()))","v":{"$error":"#N/A"}},{"$f":"IF(H31=\"\",NA(),IF(AJ21=2,I31,NA()))","v":-0.3024756737521983}]
[null,{"$f":"IF($C$31=\"\",\"\",$B$31)","v":16},"E","TST1116E",{"$f":"$C$31","v":0},{"$f":"$D$31","v":0},{"$f":"$E$31","v":0},null,null,null,null,null,null,null,null,null,"Max 1&2",{"$f":"MAX(AB42:AF46)","v":61.153692511922763},"Max 1&3",{"$f":"MAX(AB58:AF62)","v":61.218301792651069},"Max 2&3",{"$f":"MAX(AB50:AF54)","v":61.153692511922763},null,null,null,null,null,null,null,null,null,null,null,17,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"IF($C$32=\"\",\"\",$B$32)","v":""},"E","",{"$f":"$C$32","v":""},{"$f":"$D$32","v":""},{"$f":"$E$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,18,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"IF($C$33=\"\",\"\",$B$33)","v":""},"E","",{"$f":"$C$33","v":""},{"$f":"$D$33","v":""},{"$f":"$E$33","v":""},null,null,null,null,null,null,null,null,null,"Target","Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF…",{"$f":"IF(SUM(K16:K26)<>R68,_xlfn.TEXTSPLIT(\"-Not updated\",,\"-\",FALSE),_xlfn.TEXTSPLIT(\"-\"&R65,,\"-\",FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Result","Not updated"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Checksum",54.015607176365179]

{"sheet":"Output","index":4,"n_rows":53,"n_cols":34,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Input!A1","v":"Response_Surface_1.3.xlsm"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!$I$1","v":"Author: Bo Svensmark, svensmark@plen.ku.dk, Analytical Chemistry,ECP, PLEN, University of Copenhagen 2024"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"The sheet is protected. To unprotect all cells: Review -> Unprotect Sheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Date:",null,null,null,null,null,null,null,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]
["Group:","2024-09-11",null,null,"Name","Units","Low","High","first","first","first","first","first","first","first"]
["Method:","Bo",null,"Analyte",null,null,null,null,"Mean","Butyrolactone ","Phenylethyl alcohol ","Ethyl hydrogen succinate ","Diethyl succinate ","Tyrosol ","Acetyl-1-tyrosol "]
["Design no:","TST",null,"Rel. Area",null,null,null,null,null,99.999999999999986,13.421146783717637,1.4477833200518064,7.0995743308945229,35.456511178276699,7.262084691560737E-2]
["Free text:",1,null,"F1","C18e","mg",0,100,25.86355711835041,45.881760490254557,0,0,0,36.383756144755857,59.221655130758954]
["Design:",null,null,"F2","PSA","mg",0,100,0,51.570774100991827,100,0,88.204340917678564,14.86895480623293,0]
["a:",1,null,"F3"]
["No centre:",2,null,"Response",null,null,null,null,70.361103891245691,93.723684297687527,91.566362734225152,78.491856731938725,87.569625993638269,84.04013564653367,54.456853852504373]
[null,null,null,"Target",null,null,null,null,"PSA","PSA","PSA","PSA","PSA","PSA","PSA"]
[null,null,null,"Blocks",null,null,null,null,1,1,1,1,1,1,1]
[null,null,null,"Const",null,null,null,null,61.1883507904884,93.669208412015351,85.570593587577363,-9.6829532027892604,83.776753306268304,82.042608508191407,31.753894131667231]
[null,null,null,1,null,null,null,null,-2.5390873952341835E-2,-2.4518641856581796E-2,-3.5705718074752542E-2,-0.21479551720316822,-4.6688045399207873E-2,-5.304207056905464E-2,0.22240474938871435]
[null,null,null,2,null,null,null,null,-9.5636871732035458E-2,5.0791460703695553E-3,7.7719946215218605E-2,-0.45187114946349854,3.6558402163499613E-2,-9.3160355727989905E-2,-0.14814721964981178]
[null,null,null,"1^2",null,null,null,null,-1.7618212341913135E-3,-3.1100301419310929E-3,7.0955939239103363E-4,7.7463625622314078E-3,2.0983208924164402E-4,-4.0678209650699161E-3,-1.2058830342010942E-2]
[null,null,null,"2^2",null,null,null,null,1.3458116246638301E-3,-2.5321145311543525E-3,-5.6321281555779426E-4,7.7463625622314052E-3,-6.3983853395423911E-4,-1.6443784492595377E-3,5.7080515156775011E-3]
[null,null,null,12,null,null,null,null,1.1931464244225964E-3,-6.983356123976156E-4,1.6552203973542324E-5,6.4438655160950443E-3,-2.4661633606822442E-4,1.6434127749328418E-3,-6.8678495935505185E-19]
[null,null,null,"Block",null,null,null,null,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(D30=\"\",\"\",\"P(\"&D30&\")\")","v":"P(Const)"},null,null,null,null,5.867226441313428E-4,3.9061443959504228E-5,2.2579968526861529E-4,0.38021695368997072,3.5531546029125014E-4,1.011467948478719E-3,0.20490051025131251]
[null,null,null,"P(1)",null,null,null,null,0.77886446141856425,0.72486043609020423,0.71919692760042275,0.18486956233159807,0.67007667277284988,0.70536721252162782,0.48135208042122424]
[null,null,null,"P(2)",null,null,null,null,0.32114342059600554,0.94139756761520132,0.448161732879928,2.8153930387452484E-2,0.73746312570133621,0.51496546760007966,0.63271082409565804]
[null,null,null,"P(1^2)",null,null,null,null,0.55122328160796608,0.20955335579999171,0.82275466742456405,0.14639541929984051,0.95180105267731596,0.38635734928173798,0.26004526032381253]
[null,null,null,"P(2^2)",null,null,null,null,0.64565051141793484,0.29078964066667734,0.85869911504170338,0.14639541929984068,0.85406795525762602,0.71458458653136847,0.56848819211506019]
[null,null,null,"P(12)",null,null,null,null,0.59533844236578104,0.68323848576408164,0.99452219831347022,0.12162756451496802,0.92591707066597417,0.63444992676764045,1]
[null,null,null,"P(Block)"]
[null,null,null,{"$f":"IF(D37=\"\",\"\",\"P(\"&D37&\")\")","v":""}]
[null,null,null,{"$f":"IF(D38=\"\",\"\",\"P(\"&D38&\")\")","v":""}]
[null,null,null,{"$f":"IF(D39=\"\",\"\",\"P(\"&D39&\")\")","v":""}]
[null,null,null,{"$f":"IF(D40=\"\",\"\",\"P(\"&D40&\")\")","v":""}]
[null,null,null,""]

{"sheet":"Runs","index":5,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'2 factors'!A1","v":"Response_Surface_1.3.xlsm"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!$I$1","v":"Author: Bo Svensmark, svensmark@plen.ku.dk, Analytical Chemistry,ECP, PLEN, University of Copenhagen 2024"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ony white cells are unprotected. To unprotect all cells: Review -> Unprotect Sheet"]
[]
[]
[]
["Table 3: Experiments",null,null,null,null,null,"Comments to the design:"]
["Date:","2024-09-11",null,null,null,null,1,null,null,2]
["Group:","Bo"]
["Method:","TST",null,null,null,null,null,null,null,"Dette er en lang tekst"]
["Design no:",1]
["Free text:"]
["Design:","2 factors",null,null,null,null,3,null,null,4]
["Run #","Group","Label","Temp","Vol","Time","Constant factors and comments to each run:"]
[1,"A","TST1101A",0,0,null,5,null,null,null,null,null,null,6]
[2,"A","TST1102A",100,0]
[3,"A","TST1103A",0,100]
[4,"A","TST1104A",100,100]
[5,"E","TST1105E",0,50]
[6,"E","TST1106E",100,50]
[7,"E","TST1107E",50,0]
[8,"E","TST1108E",50,100]
[9,"A","TST1109A",50,50]
[10,"A","TST1110A",50,50]
[null,"A","TST11A"]
[null,"E","TST11E"]
[null,"E","TST11E"]
[null,"E","TST11E",null,null,null,7,null,null,null,null,null,null,8]
[]
[]
[]
[]
[]
[]
[21]
[22]
[23]
[24]
[25]
[26]
[27,null,{"$f":"IF(B40=\"\",\"\",$B$9&TEXT(B$10,\"0\")&\"1\"&TEXT(A40,\"00\")&B40)","v":""}]
[28,null,{"$f":"IF(B41=\"\",\"\",$B$9&TEXT(B$10,\"0\")&\"1\"&TEXT(A41,\"00\")&B41)","v":""}]
[29,null,""]
[30,null,""]
[31,null,""]
[32,null,""]
[]
["Run 21-26 are EXTRA RUNS, where all factors must be entered manually. "]
["Remember to assign groups to the runs in cells B34:B39"]
["Labels will be generated automatically"]