{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["R16 Designs 4-5","R16 Designs 6-8","R16 Runs","Input","R16 4 factors FF","R16 5 factors V","R16 6-8 factors IV","Output"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"R16 Designs 4-5","index":0,"n_rows":58,"n_cols":24,"rows_kept":58,"cut":false,"hidden":false,"merged":[[54,14,54,22],[55,14,55,22],[56,14,56,22],[57,14,57,22],[48,14,48,22],[49,14,49,22],[50,14,50,22],[51,14,51,22],[52,14,52,22],[53,14,53,22],[47,14,47,22],[36,14,36,22],[37,14,37,22],[38,14,38,22],[39,14,39,22],[40,14,40,22],[41,14,41,22],[42,14,42,22],[43,14,43,22],[44,14,44,22],[45,14,45,22],[46,14,46,22],[35,14,35,22],[24,14,24,22],[25,14,25,22],[26,14,26,22],[27,14,27,22],[28,14,28,22],[29,14,29,22],[30,14,30,22],[31,14,31,22],[32,14,32,22],[33,14,33,22],[34,14,34,22],[23,14,23,22],[15,3,15,9],[10,3,10,9],[11,3,11,9],[12,3,12,9],[13,3,13,9],[14,3,14,9]]}
["DOE_R16_Beta",null,null,null,null,null,null,null,null,null,{"$f":"Input!AA1","v":"Author: Bo Svensmark, svensmark@plen.ku.dk, Analytical Chemistry, PLEN, 2015 - 2025"},null,null,null,null,null,null,null,"Grey cells are protected"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To unprotect: Review -> Unprotect Sheet"]
[null,"1) Fill in or correct the white cells in Table 1-5",null,null,null,null,null,null,null,null,null,"Table 1: Informations in free format"]
[null,"2) If you want to randomize click on Randomize design",null,null,null,null,null,null,null,null,null,"Table 2: Parameters that must be valid "]
[null,"3) When everything is ready click on  Make run tables",null,null,null,null,null,null,null,null,null,"Table 3: Factors and levels "]
[null,null,null,null,null,null,null,null,null,null,null,"Table 4: Assign group A-H to runs"]
[null,"4) After you finished the design copy the design save the spreadsheet with a new name Save As…",null,null,null,null,null,null,null,null,null,"Table 5: Comments in free format (1 line of any length)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Method must be in the list of methods"]
[]
[null,"Table 1: Informations about the design",null,null,null,null,null,null,null,null,null,"Table 2: Design parameters",null,null,"Valid input",null,null,"Methods"]
[null,"Group",null,null,null,null,null,null,null,null,{"$f":"IF(D11=\"\",\"Warning\",\"\")","v":"Warning"},"Method",null,null,"Methods",{"$f":"IF(ISNA(VLOOKUP(N11,R11:R19,1,FALSE)),\"Error\",\"\")","v":"Error"},null,"DH"]
[null,"Date",null,null,null,null,null,null,null,null,{"$f":"IF(D12=\"\",\"Warning\",\"\")","v":"Warning"},"Design no",null,null,"1-",{"$f":"IF(AND(N12>0, N12<10),\"\",\"Error\")","v":"Error"},null,"LLE"]
[null,"Resolution",null,null,null,null,null,null,null,null,"Warning","No of factors",null,null,"4-5",{"$f":"IF(OR(N13<4,N13>5),\"Error\",\"\")","v":"Error"},null,"DLL","DLLME"]
[null,"Design",null,null,null,null,null,null,null,null,"Warning","No of center points",null,null,"0 - 4",{"$f":"IF(OR(N14<0,N14>4),\"Error\",\"\")","v":""},null,"SBS"]
[null,null,null,null,null,null,null,null,null,null,null,"If 2 centre levels, each will be with n points",null,null,null,null,null,"QUE","QuECHers"]
[null,null,null,null,null,null,null,null,null,null,null,"4 Factors:     Resolution FF",null,null,null,null,null,"HLB","SPE-HLB"]
[null,null,null,null,null,null,null,null,null,null,null,"5 Factors:     Resolution V",null,null,null,null,null,"SPM","SPME"]
[null,"Table 3: Design factors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAX","SPE-MAX"]
["Design","Factor",1,2,3,4,5]
[null,"Name"]
[null,"Unit"]
[null,"Low"]
[null,"Center 1",null,null,null,null,null,null,null,null,"Table 4: Groups",null,null,null,"Table 5: Comments and constant factors"]
[null,"Center 2",null,null,null,null,null,null,null,null,"Group ",null,"Labels",null,null,null,null,null,null,null,null,null,null,"Text in the upper box is for all runs"]
[null,"High",null,null,null,null,null,null,null,null,"names"]
[null,"Run #",1,2,3,4,5,null,null,null,"A-B-C…","Replicat"]
["Corner",1,{"$f":"$C$22","v":0},{"$f":"$D$22","v":0},{"$f":"$E$22","v":0},{"$f":"$F$22","v":0},{"$f":"IF($G$25=\"\",\"\",$G$25)","v":""},null,null,null,null,null,{"$f":"IF(K27<>\"\",CONCATENATE($N$11,TEXT(($N$12*1000+$B27)+100,\"###\"),K27),\"\")","v":""},{"$f":"IF(L27<>\"\",CONCATENATE($N$25,TEXT(($N$12*1000+$B27)+200,\"###\"),L27),\"\")","v":""},null,null,null,null,null,null,null,null,null,"Text here is only for the run in the same line"]
["points",2,{"$f":"$C$25","v":0},{"$f":"$D$22","v":0},{"$f":"$E$22","v":0},0,{"$f":"IF($G$22=\"\",\"\",$G$22)","v":""},null,null,null,null,null,{"$f":"IF(K28<>\"\",CONCATENATE($N$11,TEXT(($N$12*1000+$B28)+100,\"###\"),K28),\"\")","v":""},{"$f":"IF(L28<>\"\",CONCATENATE($N$25,TEXT(($N$12*1000+$B28)+200,\"###\"),L28),\"\")","v":""}]
[null,3,{"$f":"$C$22","v":0},{"$f":"$D$25","v":0},{"$f":"$E$22","v":0},0,{"$f":"IF($G$22=\"\",\"\",$G$22)","v":""},null,null,null,null,null,"",""]
[null,4,{"$f":"$C$25","v":0},{"$f":"$D$25","v":0},{"$f":"$E$22","v":0},0,{"$f":"IF($G$25=\"\",\"\",$G$25)","v":""},null,null,null,null,null,"",""]
[null,5,{"$f":"$C$22","v":0},{"$f":"$D$22","v":0},{"$f":"$E$25","v":0},0,{"$f":"IF($G$22=\"\",\"\",$G$22)","v":""},null,null,null,null,null,"",""]
[null,6,{"$f":"$C$25","v":0},{"$f":"$D$22","v":0},{"$f":"$E$25","v":0},0,{"$f":"IF($G$25=\"\",\"\",$G$25)","v":""},null,null,null,null,null,"",""]
[null,7,{"$f":"$C$22","v":0},{"$f":"$D$25","v":0},{"$f":"$E$25","v":0},0,{"$f":"IF($G$25=\"\",\"\",$G$25)","v":""},null,null,null,null,null,"",""]
[null,8,{"$f":"$C$25","v":0},{"$f":"$D$25","v":0},{"$f":"$E$25","v":0},0,{"$f":"IF($G$22=\"\",\"\",$G$22)","v":""},null,null,null,null,null,"",""]
[null,9,{"$f":"$C$22","v":0},{"$f":"$D$22","v":0},{"$f":"$E$22","v":0},{"$f":"$F$25","v":0},{"$f":"IF($G$22=\"\",\"\",$G$22)","v":""},null,null,null,null,null,"",""]
[null,10,{"$f":"$C$25","v":0},{"$f":"$D$22","v":0},{"$f":"$E$22","v":0},0,{"$f":"IF($G$25=\"\",\"\",$G$25)","v":""},null,null,null,null,null,"",""]
[null,11,{"$f":"$C$22","v":0},{"$f":"$D$25","v":0},{"$f":"$E$22","v":0},0,{"$f":"IF($G$25=\"\",\"\",$G$25)","v":""},null,null,null,null,null,"",""]
[null,12,{"$f":"$C$25","v":0},{"$f":"$D$25","v":0},{"$f":"$E$22","v":0},0,{"$f":"IF($G$22=\"\",\"\",$G$22)","v":""},null,null,null,null,null,"",""]
[null,13,{"$f":"$C$22","v":0},{"$f":"$D$22","v":0},{"$f":"$E$25","v":0},0,{"$f":"IF($G$25=\"\",\"\",$G$25)","v":""},null,null,null,null,null,"",""]
[null,14,{"$f":"$C$25","v":0},{"$f":"$D$22","v":0},{"$f":"$E$25","v":0},0,{"$f":"IF($G$22=\"\",\"\",$G$22)","v":""},null,null,null,null,null,"",""]
[null,15,{"$f":"$C$22","v":0},{"$f":"$D$25","v":0},{"$f":"$E$25","v":0},0,{"$f":"IF($G$22=\"\",\"\",$G$22)","v":""},null,null,null,null,null,"",""]
[null,16,{"$f":"$C$25","v":0},{"$f":"$D$25","v":0},{"$f":"$E$25","v":0},0,{"$f":"IF($G$25=\"\",\"\",$G$25)","v":""},null,null,null,null,null,"",""]
["Center 1",17,{"$f":"IF($N$14>0,IF(C$23<>\"\",C$23,\"\"),\"\")","v":""},{"$f":"IF($N$14>0,IF(D$23<>\"\",D$23,\"\"),\"\")","v":""},"","","",null,null,null,null,null,"",""]
["points",18,{"$f":"IF($N$14>1,IF(C$23<>\"\",C$23,\"\"),\"\")","v":""},{"$f":"IF($N$14>1,IF(D$23<>\"\",D$23,\"\"),\"\")","v":""},"","","",null,null,null,null,null,"",""]
[null,19,{"$f":"IF($N$14>2,IF(C$23<>\"\",C$23,\"\"),\"\")","v":""},{"$f":"IF($N$14>2,IF(D$23<>\"\",D$23,\"\"),\"\")","v":""},"","","",null,null,null,null,null,"",""]
[null,20,{"$f":"IF($N$14>3,IF(C$23<>\"\",C$23,\"\"),\"\")","v":""},{"$f":"IF($N$14>3,IF(D$23<>\"\",D$23,\"\"),\"\")","v":""},"","","",null,null,null,null,null,"",""]
["Center 2",21,{"$f":"IF($N$14>0,IF(C$24<>\"\",C$24,\"\"),\"\")","v":""},{"$f":"IF($N$14>0,IF(D$24<>\"\",D$24,\"\"),\"\")","v":""},"","","",null,null,null,null,null,"",""]
["points",22,{"$f":"IF($N$14>1,IF(C$24<>\"\",C$24,\"\"),\"\")","v":""},{"$f":"IF($N$14>1,IF(D$24<>\"\",D$24,\"\"),\"\")","v":""},"","","",null,null,null,null,null,"",""]
[null,23,{"$f":"IF($N$14>2,IF(C$24<>\"\",C$24,\"\"),\"\")","v":""},{"$f":"IF($N$14>2,IF(D$24<>\"\",D$24,\"\"),\"\")","v":""},"","","",null,null,null,null,null,"",""]
[null,24,{"$f":"IF($N$14>3,IF(C$24<>\"\",C$24,\"\"),\"\")","v":""},{"$f":"IF($N$14>3,IF(D$24<>\"\",D$24,\"\"),\"\")","v":""},"","","",null,null,null,null,null,"",""]
["Extra",25,null,null,null,null,null,null,null,null,null,null,"",""]
["runs",26,null,null,null,null,null,null,null,null,null,null,"",""]
[null,27,null,null,null,null,null,null,null,null,null,null,"",""]
[null,28,null,null,null,null,null,null,null,null,null,null,"",""]
[null,29,null,null,null,null,null,null,null,null,null,null,"",""]
[null,30,null,null,null,null,null,null,null,null,null,null,"",""]
[null,31,null,null,null,null,null,null,null,null,null,null,"",""]
[null,32,null,null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"R16 Designs 6-8","index":1,"n_rows":58,"n_cols":24,"rows_kept":58,"cut":false,"hidden":false,"merged":[[54,14,54,22],[55,14,55,22],[56,14,56,22],[57,14,57,22],[48,14,48,22],[49,14,49,22],[50,14,50,22],[51,14,51,22],[52,14,52,22],[53,14,53,22],[47,14,47,22],[36,14,36,22],[37,14,37,22],[38,14,38,22],[39,14,39,22],[40,14,40,22],[41,14,41,22],[42,14,42,22],[43,14,43,22],[44,14,44,22],[45,14,45,22],[46,14,46,22],[35,14,35,22],[24,14,24,22],[25,14,25,22],[26,14,26,22],[27,14,27,22],[28,14,28,22],[29,14,29,22],[30,14,30,22],[31,14,31,22],[32,14,32,22],[33,14,33,22],[34,14,34,22],[23,14,23,22],[15,3,15,9],[10,3,10,9],[11,3,11,9],[12,3,12,9],[13,3,13,9],[14,3,14,9]]}
[{"$f":"'R16 Designs 4-5'!A1","v":"DOE_R16_Beta"},null,null,null,null,null,null,null,null,null,null,{"$f":"Input!AA1","v":"Author: Bo Svensmark, svensmark@plen.ku.dk, Analytical Chemistry, PLEN, 2015 - 2025"},null,null,null,null,null,null,"Grey cells are protected"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To unprotect: Review -> Unprotect Sheet"]
[null,"1) Fill in or correct the white cells in Table 1-5",null,null,null,null,null,null,null,null,null,"Table 1: Informations in free format"]
[null,"2) If you want to randomize click on Randomize design",null,null,null,null,null,null,null,null,null,"Table 2: Parameters that must be valid"]
[null,"3) When everything is ready click on  Make run tables",null,null,null,null,null,null,null,null,null,"Table 3: Factors and levels "]
[null,null,null,null,null,null,null,null,null,null,null,"Table 4: Assign group A-H to runs"]
[null,"4) After you finished the design copy the design and run sheet to a new spreadsheet",null,null,null,null,null,null,null,null,null,"Table 5: Comments in free format (1 line of any length)"]
[null,"5) Save the new sheet with a name like DoE_SPME_Group_X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Method must be in the list of methods"]
[]
[null,"Table 1: Informations about the design",null,null,null,null,null,null,null,null,null,"Table 2: Design parameters",null,null,"Valid input",null,null,"Methods"]
[null,"Group",null,null,null,null,null,null,null,null,{"$f":"IF(D11=\"\",\"Warning\",\"\")","v":"Warning"},"Method",null,null,"Methods",{"$f":"IF(ISNA(VLOOKUP(N11,R11:R19,1,FALSE)),\"Error\",\"\")","v":"Error"},null,"DH"]
[null,"Date",null,null,null,null,null,null,null,null,{"$f":"IF(D12=\"\",\"Warning\",\"\")","v":"Warning"},"Design no",null,null,"1-",{"$f":"IF(AND(N12>0, N12<10),\"\",\"Error\")","v":"Error"},null,"LLE"]
[null,"Resolution",null,null,null,null,null,null,null,null,"Warning","No of factors",null,null,"6-8",{"$f":"IF(OR(N13<6,N13>8),\"Error\",\"\")","v":"Error"},null,"DLL","DLLME"]
[null,"Design",null,null,null,null,null,null,null,null,"Warning","No of center points",null,null,"0 - 4",{"$f":"IF(OR(N14<0,N14>4),\"Error\",\"\")","v":""},null,"SBS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUE","QuECHers"]
[null,null,null,null,null,null,null,null,null,null,null,"If 2 centre levels, each will be with n points",null,null,null,null,null,"HLB","SPE-HLB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPM","SPME"]
[null,"Table 3: Design factors",null,null,null,null,null,null,null,null,null,"6-8 Factors: Resolution IV",null,null,null,null,null,"MAX","SPE-MAX"]
["Design","Factor",1,2,3,4,5,6,7,8]
[null,"Name"]
[null,"Unit"]
[null,"Low"]
[null,"Center 1",null,null,null,null,null,null,null,null,"Table 4: Groups",null,null,null,"Table 5: Comments and constant factors"]
[null,"Center 2",null,null,null,null,null,null,null,null,"To be run",null,"Labels",null,null,null,null,null,null,null,null,null,null,"Text in the upper box is for all runs"]
[null,"High",null,null,null,null,null,null,null,null,"by"]
[null,"Run #",1,2,3,4,5,6,7,8,"Group","Replicat"]
["Corner",1,{"$f":"C$22","v":0},{"$f":"D$22","v":0},{"$f":"E$22","v":0},0,0,{"$f":"H$22","v":0},{"$f":"I$22","v":0},0,null,null,{"$f":"IF(K27<>\"\",CONCATENATE($N$11,TEXT(($N$12*1000+$B27)+100,\"###\"),K27),\"\")","v":""},{"$f":"IF(L27<>\"\",CONCATENATE($N$25,TEXT(($N$12*1000+$B27)+200,\"###\"),L27),\"\")","v":""},null,null,null,null,null,null,null,null,null,"Text here is only for the run in the same line"]
["points",2,{"$f":"C$25","v":0},{"$f":"D$22","v":0},0,0,0,{"$f":"H$25","v":0},{"$f":"I$25","v":0},{"$f":"J$25","v":0},null,null,{"$f":"IF(K28<>\"\",CONCATENATE($N$11,TEXT(($N$12*1000+$B28)+100,\"###\"),K28),\"\")","v":""},""]
[null,3,{"$f":"C$22","v":0},{"$f":"D$25","v":0},0,0,{"$f":"G$25","v":0},{"$f":"H$22","v":0},{"$f":"IF(I$25=\"\",\"\",I$25)","v":""},{"$f":"J$25","v":0},null,null,"",""]
[null,4,{"$f":"C$25","v":0},{"$f":"D$25","v":0},0,0,0,0,{"$f":"I$22","v":0},0,null,null,"",""]
[null,5,{"$f":"C$22","v":0},{"$f":"D$22","v":0},{"$f":"E$25","v":0},0,0,0,{"$f":"I$25","v":0},{"$f":"J$22","v":0},null,null,"",""]
[null,6,{"$f":"C$25","v":0},0,0,0,0,{"$f":"H$22","v":0},{"$f":"I$22","v":0},{"$f":"J$25","v":0},null,null,"",""]
[null,7,{"$f":"C$22","v":0},{"$f":"D$25","v":0},0,0,0,{"$f":"H$25","v":0},0,{"$f":"J$25","v":0},null,null,"",""]
[null,8,{"$f":"C$25","v":0},{"$f":"D$25","v":0},0,0,0,{"$f":"H$22","v":0},{"$f":"I$25","v":0},{"$f":"J$22","v":0},null,null,"",""]
[null,9,{"$f":"$C$22","v":0},{"$f":"D$22","v":0},0,{"$f":"F$25","v":0},0,{"$f":"H$25","v":0},{"$f":"I$22","v":0},{"$f":"J$25","v":0},null,null,"",""]
[null,10,{"$f":"C$25","v":0},0,0,0,0,{"$f":"H$22","v":0},{"$f":"I$25","v":0},{"$f":"J$22","v":0},null,null,"",""]
[null,11,{"$f":"$C$22","v":0},{"$f":"D$25","v":0},0,0,{"$f":"G$22","v":0},{"$f":"H$25","v":0},{"$f":"I$25","v":0},0,null,null,"",""]
[null,12,{"$f":"C$25","v":0},{"$f":"D$25","v":0},0,0,0,0,{"$f":"I$22","v":0},{"$f":"J$25","v":0},null,null,"",""]
[null,13,{"$f":"$C$22","v":0},{"$f":"D$22","v":0},{"$f":"E$25","v":0},0,0,0,{"$f":"I$25","v":0},{"$f":"J$25","v":0},null,null,"",""]
[null,14,{"$f":"C$25","v":0},0,0,0,0,{"$f":"H$25","v":0},{"$f":"I$22","v":0},0,null,null,"",""]
[null,15,{"$f":"$C$22","v":0},{"$f":"D$25","v":0},0,0,0,{"$f":"H$22","v":0},0,0,null,null,"",""]
[null,16,{"$f":"C$25","v":0},{"$f":"D$25","v":0},0,0,0,{"$f":"H$25","v":0},{"$f":"I$25","v":0},{"$f":"J$25","v":0},null,null,"",""]
["Center 1",17,{"$f":"IF($N$14>0,IF(C$23<>\"\",C$23,\"\"),\"\")","v":""},"","","","","","","",null,null,"",""]
["points",18,{"$f":"IF($N$14>1,IF(C$23<>\"\",C$23,\"\"),\"\")","v":""},"","","","","","","",null,null,"",""]
[null,19,{"$f":"IF($N$14>2,IF(C$23<>\"\",C$23,\"\"),\"\")","v":""},"","","","","","","",null,null,"",""]
[null,20,{"$f":"IF($N$14>3,IF(C$23<>\"\",C$23,\"\"),\"\")","v":""},"","","","","","","",null,null,"",""]
["Center 2",21,{"$f":"IF($N$14>0,IF(C$24<>\"\",C$24,\"\"),\"\")","v":""},"","","","","","","",null,null,"",""]
["points",22,{"$f":"IF($N$14>1,IF(C$24<>\"\",C$24,\"\"),\"\")","v":""},"","","","","","","",null,null,"",""]
[null,23,{"$f":"IF($N$14>2,IF(C$24<>\"\",C$24,\"\"),\"\")","v":""},"","","","","","","",null,null,"",""]
[null,24,{"$f":"IF($N$14>3,IF(C$24<>\"\",C$24,\"\"),\"\")","v":""},"","","","","","","",null,null,"",""]
["Extra",25,null,null,null,null,null,null,null,null,null,null,"",""]
["runs",26,null,null,null,null,null,null,null,null,null,null,"",""]
[null,27,null,null,null,null,null,null,null,null,null,null,"",""]
[null,28,null,null,null,null,null,null,null,null,null,null,"",""]
[null,29,null,null,null,null,null,null,null,null,null,null,"",""]
[null,30,null,null,null,null,null,null,null,null,null,null,"",""]
[null,31,null,null,null,null,null,null,null,null,null,null,"",""]
[null,32,null,null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"R16 Runs","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[5,9,5,13],[0,9,0,13],[1,9,1,13],[2,9,2,13],[3,9,3,13],[4,9,4,13],[17,9,17,13],[6,9,6,13],[7,9,7,13],[8,9,8,13],[9,9,9,13],[10,9,10,13],[11,9,11,13],[12,9,12,13],[13,9,13,13],[14,9,14,13],[15,9,15,13],[16,9,16,13],[29,9,29,13],[18,9,18,13],[19,9,19,13],[20,9,20,13],[21,9,21,13],[22,9,22,13],[23,9,23,13],[24,9,24,13],[25,9,25,13],[26,9,26,13],[27,9,27,13],[28,9,28,13],[41,9,41,13],[30,9,30,13],[31,9,31,13],[32,9,32,13],[33,9,33,13],[34,9,34,13],[35,9,35,13],[36,9,36,13],[37,9,37,13],[38,9,38,13],[39,9,39,13],[40,9,40,13],[53,9,53,13],[42,9,42,13],[43,9,43,13],[44,9,44,13],[45,9,45,13],[46,9,46,13],[47,9,47,13],[48,9,48,13],[49,9,49,13],[50,9,50,13],[51,9,51,13],[52,9,52,13],[60,9,60,13],[61,9,61,13],[54,9,54,13],[55,9,55,13],[56,9,56,13],[57,9,57,13],[58,9,58,13],[59,9,59,13]]}

{"sheet":"Input","index":3,"n_rows":149,"n_cols":51,"rows_kept":149,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'R16 Designs 4-5'!A1","v":"DOE_R16_Beta"},"Normalize?","Analyte",{"$f":"IF(D100<>\"\",D100,\"\")","v":""},null,{"$f":"IF(F100<>\"\",F100,\"\")","v":""},null,{"$f":"IF(H100<>\"\",H100,\"\")","v":""},null,{"$f":"IF(J100<>\"\",J100,\"\")","v":""},null,{"$f":"IF(L100<>\"\",L100,\"\")","v":""},null,{"$f":"IF(N100<>\"\",N100,\"\")","v":""},null,{"$f":"IF(P100<>\"\",P100,\"\")","v":""},null,{"$f":"IF(R100<>\"\",R100,\"\")","v":""},null,{"$f":"IF(T100<>\"\",T100,\"\")","v":""},"","","","","","","Author: Bo Svensmark, svensmark@plen.ku.dk, Analytical Chemistry, PLEN, 2015 - 2025"]
[null,"Yes=1 No = 0",1,null,{"$f":"IF(E100<>\"\",E100,\"\")","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","","",{"$f":"IF(AA100<>\"\",AA100,\"\")","v":""},null,null,null,null,"","","","","","","","",{"$f":"IF(AN102<>\"\",AN102,\"\")","v":""},{"$f":"IF(AO102<>\"\",AO102,\"\")","v":""},{"$f":"IF(AP102<>\"\",AP102,\"\")","v":""},{"$f":"IF(AQ102<>\"\",AQ102,\"\")","v":""},"","","","","","","",""]
["Select (1/0) ?",0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,3]
["Max(mean)","Mean(area)",{"$f":"MAX(D4:Z4)","v":0},{"$f":"IF(D3>0,AVERAGE(D101:D177),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","In these columns you may add",null,null,null,null,"1) Copy the response data to the white cells surronded by yellow in cell C100:Z136 (2nd replicate to C141:Z176)"]
[null,"Max(area)",null,{"$f":"IF(D3>0,MAX(D101:D177),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","calculated variables to include in"]
[null,"Min(area)",null,{"$f":"IF(D3>0,MIN(D101:D177),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","the analysis. Could be harmonic or",null,null,null,null,"2) If you do not want to normalize data, change 1 in cell C3 to 0"]
[null,"Relative area",null,{"$f":"IF(D3>0,100*D4/$C$4,\"\")","v":""},{"$f":"IF(E3>0,100*E4/$C$4,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","geometric mean, or ???"]
[null,"Mean(norm)",null,{"$f":"IF(D3>0,MIN(D11:D46,D51:D86),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","Remember to put a name for the",null,null,null,null,"3) In row 3 white cells enter a 1 for compounds which should be selected for analysis - and 0 if you want to skip them"]
[null,"Min(norm)",null,{"$f":"IF(D3>0,AVERAGE(D11:D46,D51:D86),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","variable in the first row",null,null,null,null,null,"After analysis, 1 is changed to 2. "]
["Label","Max","Mean",{"$f":"IF(D100<>\"\",D100,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,null,"To re-analyse data, change 2 to 1 and repeat the analysis"]
[{"$f":"IF(C101<>\"\",C101,\"\")","v":""},{"$f":"IF(C101<>\"\",MAX(D11:Z11,D51:Z51),\"\")","v":""},{"$f":"IF(C101<>\"\",AVERAGE(D11:Z11),\"\")","v":""},{"$f":"IF(AND(D$3>0,$C101<>\"\"),IF(D$5>0,IF($C$2=1,100*D101/D$5,D101),0),\"\")","v":""},{"$f":"IF(AND(E$3>0,$C101<>\"\"),IF(E$5>0,IF($C$2=1,100*E101/E$5,E101),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","",""]
["",{"$f":"IF(C102<>\"\",MAX(D12:Z12,D52:Z52),\"\")","v":""},{"$f":"IF(C102<>\"\",AVERAGE(D12:Z12),\"\")","v":""},{"$f":"IF(AND(D$3>0,$C102<>\"\"),IF(D$5>0,IF($C$2=1,100*D102/D$5,D102),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,"4) You may add new variables in cells AA11:AC47"]
["","","",{"$f":"IF(AND(D$3>0,$C103<>\"\"),IF(D$5>0,IF($C$2=1,100*D103/D$5,D103),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C104<>\"\"),IF(D$5>0,IF($C$2=1,100*D104/D$5,D104),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,"5) Go to the appropriate sheet for analysis and click on the Start button "]
["","","",{"$f":"IF(AND(D$3>0,$C105<>\"\"),IF(D$5>0,IF($C$2=1,100*D105/D$5,D105),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C106<>\"\"),IF(D$5>0,IF($C$2=1,100*D106/D$5,D106),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,"6) Make the analysis and click Save and load next to continue - or click Save to just save the results"]
["","","",{"$f":"IF(AND(D$3>0,$C107<>\"\"),IF(D$5>0,IF($C$2=1,100*D107/D$5,D107),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C108<>\"\"),IF(D$5>0,IF($C$2=1,100*D108/D$5,D108),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,"Light blue table:",null,"Input to the analysis (may be normalized or not)"]
["","","",{"$f":"IF(AND(D$3>0,$C109<>\"\"),IF(D$5>0,IF($C$2=1,100*D109/D$5,D109),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,null,null,"Y(norm) = 100*Y/Y(max) for each analyte"]
["","","",{"$f":"IF(AND(D$3>0,$C110<>\"\"),IF(D$5>0,IF($C$2=1,100*D110/D$5,D110),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C111<>\"\"),IF(D$5>0,IF($C$2=1,100*D111/D$5,D111),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,"Dark blue table:",null,"Calculated max and average response for all analyts to be analyzed"]
["","","",{"$f":"IF(AND(D$3>0,$C112<>\"\"),IF(D$5>0,IF($C$2=1,100*D112/D$5,D112),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C113<>\"\"),IF(D$5>0,IF($C$2=1,100*D113/D$5,D113),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C114<>\"\"),IF(D$5>0,IF($C$2=1,100*D114/D$5,D114),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,"Green table:",null,"Statistcs for each respose"]
["","","",{"$f":"IF(AND(D$3>0,$C115<>\"\"),IF(D$5>0,IF($C$2=1,100*D115/D$5,D115),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C116<>\"\"),IF(D$5>0,IF($C$2=1,100*D116/D$5,D116),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,"White cells next to yellow cells:",null,null,"User input, data and parameters"]
["","","",{"$f":"IF(AND(D$3>0,$C117<>\"\"),IF(D$5>0,IF($C$2=1,100*D117/D$5,D117),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C118<>\"\"),IF(D$5>0,IF($C$2=1,100*D118/D$5,D118),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,"Structure of input in cell C100:Z136:"]
["","","",{"$f":"IF(AND(D$3>0,$C119<>\"\"),IF(D$5>0,IF($C$2=1,100*D119/D$5,D119),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C120<>\"\"),IF(D$5>0,IF($C$2=1,100*D120/D$5,D120),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,"First row:",null,"Analyte names"]
["","","",{"$f":"IF(AND(D$3>0,$C121<>\"\"),IF(D$5>0,IF($C$2=1,100*D121/D$5,D121),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,"First column: ",null,"Run number code. ",null,"The code MUST end with an extra character"]
["","","",{"$f":"IF(AND(D$3>0,$C122<>\"\"),IF(D$5>0,IF($C$2=1,100*D122/D$5,D122),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,null,null,null,null," (that will be discarded)"]
["","","",{"$f":"IF(AND(D$3>0,$C123<>\"\"),IF(D$5>0,IF($C$2=1,100*D123/D$5,D123),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C124<>\"\"),IF(D$5>0,IF($C$2=1,100*D124/D$5,D124),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,null,null,"Run #","Code","Example of valid codes"]
["","","",{"$f":"IF(AND(D$3>0,$C125<>\"\"),IF(D$5>0,IF($C$2=1,100*D125/D$5,D125),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,null,null,1,"1A","A-Z could be any valid character"]
["","","",{"$f":"IF(AND(D$3>0,$C126<>\"\"),IF(D$5>0,IF($C$2=1,100*D126/D$5,D126),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,null,null,2,"2B"]
["","","",{"$f":"IF(AND(D$3>0,$C127<>\"\"),IF(D$5>0,IF($C$2=1,100*D127/D$5,D127),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,null,null,3,"3C"]
["","","",{"$f":"IF(AND(D$3>0,$C128<>\"\"),IF(D$5>0,IF($C$2=1,100*D128/D$5,D128),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,null,null,4,"4w"]
["","","",{"$f":"IF(AND(D$3>0,$C129<>\"\"),IF(D$5>0,IF($C$2=1,100*D129/D$5,D129),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,null,null,5,"5w"]
["","","",{"$f":"IF(AND(D$3>0,$C130<>\"\"),IF(D$5>0,IF($C$2=1,100*D130/D$5,D130),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,null,null,6,"6x"]
["","","",{"$f":"IF(AND(D$3>0,$C131<>\"\"),IF(D$5>0,IF($C$2=1,100*D131/D$5,D131),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,null,null,7,"7y"]
["","","",{"$f":"IF(AND(D$3>0,$C132<>\"\"),IF(D$5>0,IF($C$2=1,100*D132/D$5,D132),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,null,null,8,"8Z"]
["","","",{"$f":"IF(AND(D$3>0,$C133<>\"\"),IF(D$5>0,IF($C$2=1,100*D133/D$5,D133),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C134<>\"\"),IF(D$5>0,IF($C$2=1,100*D134/D$5,D134),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,"D101:Z136",null,"Responses or blank cells"]
["","","",{"$f":"IF(AND(D$3>0,$C135<>\"\"),IF(D$5>0,IF($C$2=1,100*D135/D$5,D135),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,null,null,"Only numeric data, no not detected etc"]
["","","",{"$f":"IF(AND(D$3>0,$C136<>\"\"),IF(D$5>0,IF($C$2=1,100*D136/D$5,D136),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[]
[]
[]
["Run #","Replicate #","Mean "]
[{"$f":"IF(C101<>\"\",MID(C101,LEN(C101)-2,2),\"\")","v":""},{"$f":"IF(C141<>\"\",MID(C141,LEN(C141)-2,2),\"\")","v":""},{"$f":"IF(C141<>\"\",AVERAGE(D51:Z51),\"\")","v":""},{"$f":"IF(AND(D$3>0,$C141<>\"\"),IF(D$5>0,IF($C$2=1,100*D141/D$5,D141),0),\"\")","v":""},{"$f":"IF(AND(E$3>0,$C141<>\"\"),IF(E$5>0,IF($C$2=1,100*E141/E$5,E141),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF(C102<>\"\",MID(C102,LEN(C102)-2,2),\"\")","v":""},{"$f":"IF(C142<>\"\",MID(C142,LEN(C142)-2,2),\"\")","v":""},{"$f":"IF(C142<>\"\",AVERAGE(D52:Z52),\"\")","v":""},{"$f":"IF(AND(D$3>0,$C142<>\"\"),IF(D$5>0,IF($C$2=1,100*D142/D$5,D142),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C143<>\"\"),IF(D$5>0,IF($C$2=1,100*D143/D$5,D143),0),\"\")","v":""},{"$f":"IF(AND(E$3>0,$C143<>\"\"),IF(E$5>0,IF($C$2=1,100*E143/E$5,E143),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C144<>\"\"),IF(D$5>0,IF($C$2=1,100*D144/D$5,D144),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C145<>\"\"),IF(D$5>0,IF($C$2=1,100*D145/D$5,D145),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C146<>\"\"),IF(D$5>0,IF($C$2=1,100*D146/D$5,D146),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C147<>\"\"),IF(D$5>0,IF($C$2=1,100*D147/D$5,D147),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C148<>\"\"),IF(D$5>0,IF($C$2=1,100*D148/D$5,D148),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C149<>\"\"),IF(D$5>0,IF($C$2=1,100*D149/D$5,D149),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C150<>\"\"),IF(D$5>0,IF($C$2=1,100*D150/D$5,D150),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C151<>\"\"),IF(D$5>0,IF($C$2=1,100*D151/D$5,D151),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C152<>\"\"),IF(D$5>0,IF($C$2=1,100*D152/D$5,D152),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C153<>\"\"),IF(D$5>0,IF($C$2=1,100*D153/D$5,D153),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C154<>\"\"),IF(D$5>0,IF($C$2=1,100*D154/D$5,D154),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C155<>\"\"),IF(D$5>0,IF($C$2=1,100*D155/D$5,D155),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C156<>\"\"),IF(D$5>0,IF($C$2=1,100*D156/D$5,D156),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C157<>\"\"),IF(D$5>0,IF($C$2=1,100*D157/D$5,D157),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C158<>\"\"),IF(D$5>0,IF($C$2=1,100*D158/D$5,D158),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C159<>\"\"),IF(D$5>0,IF($C$2=1,100*D159/D$5,D159),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C160<>\"\"),IF(D$5>0,IF($C$2=1,100*D160/D$5,D160),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C161<>\"\"),IF(D$5>0,IF($C$2=1,100*D161/D$5,D161),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C162<>\"\"),IF(D$5>0,IF($C$2=1,100*D162/D$5,D162),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C163<>\"\"),IF(D$5>0,IF($C$2=1,100*D163/D$5,D163),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C164<>\"\"),IF(D$5>0,IF($C$2=1,100*D164/D$5,D164),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C165<>\"\"),IF(D$5>0,IF($C$2=1,100*D165/D$5,D165),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C166<>\"\"),IF(D$5>0,IF($C$2=1,100*D166/D$5,D166),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C167<>\"\"),IF(D$5>0,IF($C$2=1,100*D167/D$5,D167),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C168<>\"\"),IF(D$5>0,IF($C$2=1,100*D168/D$5,D168),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C169<>\"\"),IF(D$5>0,IF($C$2=1,100*D169/D$5,D169),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C170<>\"\"),IF(D$5>0,IF($C$2=1,100*D170/D$5,D170),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C171<>\"\"),IF(D$5>0,IF($C$2=1,100*D171/D$5,D171),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C172<>\"\"),IF(D$5>0,IF($C$2=1,100*D172/D$5,D172),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C173<>\"\"),IF(D$5>0,IF($C$2=1,100*D173/D$5,D173),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C174<>\"\"),IF(D$5>0,IF($C$2=1,100*D174/D$5,D174),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","","",{"$f":"IF(AND(D$3>0,$C175<>\"\"),IF(D$5>0,IF($C$2=1,100*D175/D$5,D175),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
["","",{"$f":"IF(C176<>\"\",AVERAGE(D86:Z86),\"\")","v":""},{"$f":"IF(AND(D$3>0,$C176<>\"\"),IF(D$5>0,IF($C$2=1,100*D176/D$5,D176),0),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[null,"N",null,{"$f":"COUNT(D101:D136,D141:D176)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Mean",null,{"$f":"IF(D94>0,AVERAGE(D101:D136,D141:D176),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Max",null,{"$f":"IF(D94>0,MAX(D101:D136,D141:D176),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Min",null,{"$f":"IF(D94>0,MIN(D101:D136,D141:D176),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[]
["Input 1st runs",null,"Label"]
[null,"Mean"]
["Labels in first",{"$f":"IF(C101<>\"\",AVERAGE(D101:Z101,D141:Z141),\"\")","v":""}]
["column",{"$f":"IF(C102<>\"\",AVERAGE(D102:Z102,D142:Z142),\"\")","v":""}]
[null,""]
["Analyte names ",""]
["in first row",""]
[null,""]
["Data first cell:",""]
["D101",""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[]
[]
[]
["Input 2nd runs",null,"Label"]
[]
["Labels in first"]
["column"]
[]
["No analyte names "]
["in first row!"]
[]
["Data first cell:"]
["D141"]

{"sheet":"R16 4 factors FF","index":4,"n_rows":127,"n_cols":37,"rows_kept":127,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Input!A1","v":"DOE_R16_Beta"},null,null,null,"2^4","Full factor design",null,"No confounding",null,null,"4 main effects",null,"11 interactions",null,null,null,null,null,null,null,null,{"$f":"Input!AA1","v":"Author: Bo Svensmark, svensmark@plen.ku.dk, Analytical Chemistry, PLEN, 2015 - 2025"}]
[]
[null,"1) Enter parameters in sheet \"R16 Designs 4-5\"",null,null,null,null,"(Input in white cells only)",null,null,null,null,"This design is for 4 main effects with all interactions",null,null,null,null,{"$f":"IF('R16 Designs 4-5'!N13=4,4,0)","v":0},null,"NO confounding",null,null,"This sheet can also be used in manual mode: "]
[null,"2) Enter all result in sheets \"Input\" and fill 1 or 0  in row 3 in \"Input\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter results of the runs in the table F18:I21 and F22:G29"]
[null,"3) Click on \"Start\" to load the first case.  Check that Next in cell K12 is 1",null,null,null,null,null,null,null,null,null,"Centerpoints may be omitted.",null,null,null,null,null,null,null,null,null,null,"Click on \"Update sheet\" to calculate results"]
[null,"4) See the results here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You may set confidense interval manually, see below"]
[null,"5) Set confidence intervals for effects manually (see notes --->)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click on \"Save\" to save results to sheet \"Output\""]
[null,"6) Click \"Save\" or \"Save and load next analyte\" to save results and proceed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Most cells are shown with 2 significant digits. You may want to cange that for small values"]
["Design","Factor",1,2,3,4,"No of center points:",null,{"$f":"'R16 Designs 4-5'!N14","v":0},null,{"$f":"IF(P16=\"No\",\"Results are NOT saved\",\"Results are saved in sheet Output\")","v":"Results are saved in sheet Output"}]
[null,"Name",{"$f":"IF($Q$3=4,'R16 Designs 4-5'!C20,\"\")","v":""},{"$f":"IF($Q$3=4,'R16 Designs 4-5'!D20,\"\")","v":""},{"$f":"IF($Q$3=4,'R16 Designs 4-5'!E20,\"\")","v":""},{"$f":"IF($Q$3=4,'R16 Designs 4-5'!F20,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Set the confidence interval for an effects manually (Manual limit):"]
[null,"Unit",{"$f":"IF($Q$3=4,'R16 Designs 4-5'!C21,\"\")","v":""},{"$f":"IF($Q$3=4,'R16 Designs 4-5'!D21,\"\")","v":""},{"$f":"IF($Q$3=4,'R16 Designs 4-5'!E21,\"\")","v":""},{"$f":"IF($Q$3=4,'R16 Designs 4-5'!F21,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If you do not have any replicate or centre points, you may enter a confidence interval manually (Manual limit)"]
[null,"Low",{"$f":"IF($Q$3=4,'R16 Designs 4-5'!C22,\"\")","v":""},{"$f":"IF($Q$3=4,'R16 Designs 4-5'!D22,\"\")","v":""},{"$f":"IF($Q$3=4,'R16 Designs 4-5'!E22,\"\")","v":""},{"$f":"IF($Q$3=4,'R16 Designs 4-5'!F22,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All effects of absolute magnitude higher than the manual limit will be marked as signficant (+, ++, +++ instead of *, **, ***)"]
[null,"Center 1",{"$f":"IF($Q$3=4,IF('R16 Designs 4-5'!C23=\"\",\"\",'R16 Designs 4-5'!C23),\"\")","v":""},{"$f":"IF($Q$3=4,IF('R16 Designs 4-5'!D23=\"\",\"\",'R16 Designs 4-5'!D23),\"\")","v":""},{"$f":"IF($Q$3=4,IF('R16 Designs 4-5'!E23=\"\",\"\",'R16 Designs 4-5'!E23),\"\")","v":""},{"$f":"IF($Q$3=4,IF('R16 Designs 4-5'!F23=\"\",\"\",'R16 Designs 4-5'!F23),\"\")","v":""},"Analyte:","Mean",null,null,null,"Rel. Area =",null,null,{"$f":"IF(ABS(SUM(C47:C61)-SUM(W44:W58))>0.000000000001,\"Please update sheet\",\"\")","v":""}]
[null,"Center 2",{"$f":"IF($Q$3=4,IF('R16 Designs 4-5'!C24=\"\",\"\",'R16 Designs 4-5'!C24),\"\")","v":""},{"$f":"IF($Q$3=4,IF('R16 Designs 4-5'!D24=\"\",\"\",'R16 Designs 4-5'!D24),\"\")","v":""},{"$f":"IF($Q$3=4,IF('R16 Designs 4-5'!E24=\"\",\"\",'R16 Designs 4-5'!E24),\"\")","v":""},{"$f":"IF($Q$3=4,IF('R16 Designs 4-5'!F24=\"\",\"\",'R16 Designs 4-5'!F24),\"\")","v":""},"Comm:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Even if you have an experimental determined statistical CI, you may want to play with the CI because:"]
[null,"High",{"$f":"IF($Q$3=4,'R16 Designs 4-5'!C25,\"\")","v":""},{"$f":"IF($Q$3=4,'R16 Designs 4-5'!D25,\"\")","v":""},{"$f":"IF($Q$3=4,'R16 Designs 4-5'!E25,\"\")","v":""},{"$f":"IF($Q$3=4,'R16 Designs 4-5'!F25,\"\")","v":""},"Results","Replicates",null,null,null,null,null,null,"Yes","Yes",null,null,null,null,null,null,"For your purpose, even statistically insignificant effects may be important"]
[null,"Run",1,2,3,4,1,2,3,4,"Mean","Stdev.","d.f.",null,"Index out",1,null,null,null,null,null,null,"You suspect that the experimentally determined uncertainty is wrong"]
["Corner",1,{"$f":"$C$13","v":""},{"$f":"$D$13","v":""},{"$f":"$E$13","v":""},{"$f":"$F$13","v":""},null,null,null,null,{"$f":"IF(G18<>\"\",AVERAGE(G18:J18),0)","v":0},{"$f":"IF(M18>0,_xlfn.STDEV.S(G18:J18),0)","v":0},{"$f":"IF(G18<>\"\",COUNT(G18:J18)-1,0)","v":0}]
["points",2,{"$f":"$C$16","v":""},{"$f":"$D$13","v":""},{"$f":"$E$13","v":""},"",null,null,null,null,0,{"$f":"IF(M19>0,_xlfn.STDEV.S(G19:J19),0)","v":0},{"$f":"IF(G19<>\"\",COUNT(G19:J19)-1,0)","v":0}]
[null,3,{"$f":"$C$13","v":""},{"$f":"$D$16","v":""},{"$f":"$E$13","v":""},"",null,null,null,null,0,0,0]
[null,4,{"$f":"$C$16","v":""},{"$f":"$D$16","v":""},{"$f":"$E$13","v":""},"",null,null,null,null,0,0,0]
[null,5,{"$f":"$C$13","v":""},{"$f":"$D$13","v":""},{"$f":"$E$16","v":""},"",null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,"Model optimization:"]
[null,6,{"$f":"$C$16","v":""},{"$f":"$D$13","v":""},{"$f":"$E$16","v":""},"",null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,"During the analysis of the results, statistical and scientific, you may have desided, which EFFECTS are important, and which are not"]
[null,7,{"$f":"$C$13","v":""},{"$f":"$D$16","v":""},{"$f":"$E$16","v":""},"",null,null,null,null,0,0,0]
[null,8,{"$f":"$C$16","v":""},{"$f":"$D$16","v":""},{"$f":"$E$16","v":""},"",null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,"In the model optimization, you can play with the FACTORS, and see"]
[null,9,{"$f":"$C$13","v":""},{"$f":"$D$13","v":""},{"$f":"$E$13","v":""},{"$f":"$F$16","v":""},null,null,null,null,0,0,0,null,null,null,null,null,null,null,null," ","Which factors you must control, and which you may negect"]
[null,10,{"$f":"$C$16","v":""},{"$f":"$D$13","v":""},{"$f":"$E$13","v":""},"",null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,"What level each factor must have in order to obtain the best result"]
[null,11,{"$f":"$C$13","v":""},{"$f":"$D$16","v":""},{"$f":"$E$13","v":""},"",null,null,null,null,0,0,0]
[null,12,{"$f":"$C$16","v":""},{"$f":"$D$16","v":""},{"$f":"$E$13","v":""},"",null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,"Please note, that main factors and interactions are linked in the model, i.e.:"]
[null,13,{"$f":"$C$13","v":""},{"$f":"$D$13","v":""},{"$f":"$E$16","v":""},"",null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,"You cannot keep an interaction without keeing the corresponding main factors in the model"]
[null,14,{"$f":"$C$16","v":""},{"$f":"$D$13","v":""},{"$f":"$E$16","v":""},"",null,null,null,null,0,0,0]
[null,15,{"$f":"$C$13","v":""},{"$f":"$D$16","v":""},{"$f":"$E$16","v":""},"",null,null,null,null,0,0,0]
[null,16,{"$f":"$C$16","v":""},{"$f":"$D$16","v":""},{"$f":"$E$16","v":""},"",null,null,null,null,0,0,0]
["Center 1",17,{"$f":"IF(C$14=\"\",\"\",IF($B34<$I$10+17,C$14,\"\"))","v":""},{"$f":"IF(D$14=\"\",\"\",IF($B34<$I$10+17,D$14,\"\"))","v":""},"","",null,null,null,null,{"$f":"IF(G34<>\"\",AVERAGE(G34:H37),0)","v":0},{"$f":"IF(M34>0,STDEV(G34:H37),0)","v":0},{"$f":"IF(G34<>\"\",COUNT(G34:H37)-1,0)","v":0},"All center points"]
["points",18,{"$f":"IF(C$14=\"\",\"\",IF($B35<$I$10+17,C$14,\"\"))","v":""},"","","",null,null,null,null,null,null,null,"Mean","d.f"]
[null,19,"","","","",null,null,null,null,null,null,null,{"$f":"IF(G34<>\"\",AVERAGE(G34:H41),\"\")","v":""},{"$f":"M34+M38","v":0}]
[null,20,"","","",""]
["Center 2",21,{"$f":"IF(C$15=\"\",\"\",IF($B38<$I$10+21,C$15,\"\"))","v":""},{"$f":"IF(D$15=\"\",\"\",IF($B38<$I$10+21,D$15,\"\"))","v":""},"","",null,null,null,null,{"$f":"IF(G38<>\"\",AVERAGE(G38:H41),0)","v":0},{"$f":"IF(M38>0,STDEV(G38:H41),0)","v":0},{"$f":"IF(G38<>\"\",COUNT(G38:H41)-1,0)","v":0},{"$f":"IF(O39>0,\"Statistics\",\"No statistics\")","v":"No statistics"}]
["points",22,{"$f":"IF(C$15=\"\",\"\",IF($B39<$I$10+21,C$15,\"\"))","v":""},"","","",null,null,null,null,null,null,null,"d.f.",{"$f":"SUM(M18:M38)","v":0}]
[null,23,"","","","",null,null,null,null,null,null,null,"s(pool)",{"$f":"IF(O39>0,SQRT(SUM(L18:L38^2*M18:M38)/O39),\"\")","v":""}]
[null,24,"","","","",null,null,null,null,null,null,null,"s(effect)",{"$f":"IF(O39>0,2*O40/SQRT(COUNT(G18:J33)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Extra runs"]
[null,"Enter manual Limit:",null,null,null,"95% Confidence interval for an effect, CI:",null,null,null,{"$f":"AK44","v":0},null,"Blue points:  not significant effects",null,null,null,null,null,null,null,null,null,"Terms","Effect","P","Noise",null,"Index","Fractile","Probit","IF",null,"Blue","Model",null,"CI(95%)","d.f.",{"$f":"IF(O41<>\"\",O39,4)","v":4}]
[null,null,null,null,null,null,null,null,"CI(exp) =",{"$f":"IF(O41<>\"\",O41*TINV(0.05,O39),\"na\")","v":"na"},null,"Red points:   significant effects",null,null,null,null,null,null,null,null,null,1,0,1,0,null,1,{"$f":"(AA44-0.375)/($W$59+0.25)","v":4.0983606557377046E-2},{"$f":"NORMSINV(AB44)","v":-1.7393841569195561},{"$f":"IF($AK$44<>\"\",IF(X44>=0.05,W44,\"\"),W44)","v":0},null,"line",null,null,null,"CI +/-",{"$f":"IF(D43>0,D43,IF(O41<>\"\",O41*TINV(0.05,AK43),0))","v":0}]
["Effects","Term","Effect","Coeff","P","Sign?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0,1,0,null,2,0.10655737704918032,-1.2450462387740626,{"$f":"IF($AK$44<>\"\",IF(X45>=0.05,W45,\"\"),W45)","v":0},null,null,"Slope",{"$f":"1/AK45","v":{"$error":"#DIV/0!"}},null,"s(effect)",{"$f":"AK44/TINV(0.05,AK43)","v":0}]
[null,"Mean",{"$f":"U93/16","v":0},{"$f":"C46","v":0},{"$f":"IF($AK$44>0,TDIST(ABS(C46)/$AK$45,$AK$43,2),1)","v":1},{"$f":"IF(E46<0.001,\"***\",IF(E46<0.01,\"**\",IF(E46<0.05,\"*\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0,1,0,null,3,0.1721311475409836,-0.94577708618931966,0,null,null,"X","Y","CI lines","X","Y"]
[null,1,{"$f":"U94/8","v":0},{"$f":"C47/2","v":0},1,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,1,0,null,4,0.23770491803278687,-0.7137046409102612,0,null,"Low",{"$f":"AH47/$AH$45","v":{"$error":"#DIV/0!"}},{"$f":"MIN(AC44:AC58)","v":-1.7393841569195561},"SV",{"$f":"-AK44","v":0},{"$f":"MIN(AC44:AC58)","v":-1.7393841569195561}]
[null,2,0,{"$f":"C48/2","v":0},1,"",null,{"$f":"V44","v":1},{"$f":"IF(Y44<>\"\",\"\",W44)","v":""},{"$f":"IF(Y44<>\"\",Y44,\"\")","v":0},null,null,null,null,null,null,null,null,null,null,null,12,0,1,0,null,5,0.30327868852459017,-0.51499376488951132,0,null,"High",{"$f":"AH48/$AH$45","v":{"$error":"#DIV/0!"}},{"$f":"MAX(AC44:AC58)","v":1.7393841569195554},"NV",{"$f":"-AK44","v":0},{"$f":"MAX(AC44:AC58)","v":1.7393841569195554}]
[null,3,0,0,1,"",null,2,"",0,null,null,null,null,null,null,null,null,null,null,null,13,0,1,0,null,6,0.36885245901639346,-0.33489417272961575,0,null,null,null,null,"SE",{"$f":"AK44","v":0},{"$f":"MIN(AC44:AC58)","v":-1.7393841569195561}]
[null,4,0,0,1,"",null,3,{"$f":"IF(Y46<>\"\",\"\",W46)","v":""},{"$f":"IF(Y46<>\"\",Y46,\"\")","v":0},null,null,null,null,null,null,null,null,null,null,null,14,0,1,0,null,7,{"$f":"(AA50-0.375)/($W$59+0.25)","v":0.4344262295081967},{"$f":"NORMSINV(AB50)","v":-0.16511628036201545},0,null,"s(pool)",{"$f":"AK45*SQRT(COUNT(G18:J33))/2","v":0},null,"NE",{"$f":"AK44","v":0},{"$f":"MAX(AC44:AC58)","v":1.7393841569195554}]
[null,12,0,0,1,"",null,4,"",0,null,null,null,null,null,null,null,null,null,null,null,23,0,1,0,null,8,0.5,0,0]
[null,13,0,0,1,"",null,12,"",0,null,null,null,null,null,null,null,null,null,null,null,24,0,1,0,null,9,0.56557377049180324,0.16511628036201531,0]
[null,14,0,{"$f":"C53/2","v":0},1,"",null,13,"",0,null,null,null,null,null,null,null,null,null,null,null,34,0,1,0,null,10,0.63114754098360659,0.33489417272961586,0]
[null,23,0,0,1,"",null,14,"",0,null,null,null,null,null,null,null,null,null,null,null,123,0,1,0,null,11,0.69672131147540983,0.51499376488951132,0]
[null,24,0,0,1,"",null,23,"",0,null,null,null,null,null,null,null,null,null,null,null,124,0,1,0,null,12,0.76229508196721307,0.71370464091026031,0]
[null,34,0,0,1,"",null,24,"",0,null,null,null,null,null,null,null,null,null,null,null,134,0,1,0,null,13,0.82786885245901642,0.94577708618931966,0]
[null,123,0,0,1,"",null,34,"",0,null,null,null,null,null,null,null,null,null,null,null,234,0,1,0,null,14,0.89344262295081966,1.2450462387740626,0]
[null,124,0,0,1,"",null,123,"",0,null,null,null,null,null,null,null,null,null,null,null,1234,0,1,0,null,15,{"$f":"(AA58-0.375)/($W$59+0.25)","v":0.95901639344262291},{"$f":"NORMSINV(AB58)","v":1.7393841569195554},0]
[null,134,0,0,1,"",null,124,"",0,null,null,null,null,null,null,null,null,null,null,null,"N =",{"$f":"COUNT(W44:W58)","v":15},"d.f.",{"$f":"COUNT(Y44:Y58)","v":15}]
[null,234,0,0,1,"",null,134,"",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"s(Noise)",{"$f":"SQRT(SUM(Y44:Y58^2)/COUNT(Y44:Y58))","v":0}]
[null,1234,0,0,1,"",null,234,"",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"CI(noise)",{"$f":"Y60*TINV(0.05,Y59)","v":0}]
[null,"Center p",{"$f":"IF(G34<>\"\",N36-C46,\"\")","v":""},{"$f":"C62","v":""},{"$f":"IF(C62<>\"\",IF(AK44>0,TDIST(ABS(C62)/(AG50*SQRT(1/(O36+1)+1/(COUNT(G18:J33)))),AK43,2),1),\"\")","v":""},"",null,1234,"",0]
[null,null,"Manual limit:",null,"Statistics:",null,null,null,"CI(Noise)",{"$f":"IF(Y59>0,Y61,\"\")","v":0}]
[null,null,"P<0.05","+","P<0.05","*"]
[null,null,"P<0.01","++","P<0.01","**"]
[null,null,"P<0.001","+++","P<0.001","***"]
[null,null,null,null,"If no s(effect) all  P=1"]
[null,"Model 1",null,null,null,null,"Model 2"]
[null,{"$f":"B45","v":"Term"},"X","Coeff","Value",null,{"$f":"B45","v":"Term"},"X","Coeff","Value",null,"Predict the respons and optimize"]
[null,"Mean",1,{"$f":"D46","v":0},{"$f":"C70*D70","v":0},null,"Mean",1,{"$f":"D46","v":0},{"$f":"H70*I70","v":0},null,"Model:"]
[null,1,1,0,{"$f":"C71*D71","v":0},null,1,0,0,{"$f":"H71*I71","v":0},null,"Y = C(Mean) + X1*C1 + X2*C2 + X3*C3 + X4*C4 + Interactions"]
[null,2,1,0,0,null,2,0,0,0,null,"X = -1, 0 or 1 (coded values)"]
[null,3,1,0,0,null,3,0,0,0,null,"C = Coefficients"]
[null,4,1,0,0,null,4,0,0,0]
[null,12,{"$f":"C71*C72","v":1},0,{"$f":"D75*C$71*C$72","v":0},null,12,0,0,{"$f":"IF(H75<>0,I75*H$71*H$72,0)","v":0},null,"Model 1: Calculates interactions automatically"]
[null,13,{"$f":"C71*C73","v":1},0,{"$f":"D76*C$71*C$73","v":0},null,13,0,0,{"$f":"IF(H76<>0,I76*H$71*H$73,0)","v":0}]
[null,14,{"$f":"C71*C74","v":1},0,{"$f":"D77*C$71*C$74","v":0},null,14,0,0,{"$f":"IF(H77<>0,I77*H$71*H$74,0)","v":0},null,"Model 2: X <> 0 interaction included, X = 0 interaction excluded"]
[null,23,{"$f":"C72*C73","v":1},0,{"$f":"D78*C$72*C$73","v":0},null,23,0,0,{"$f":"IF(H78<>0,I78*H$72*H$73,0)","v":0}]
[null,24,{"$f":"C72*C74","v":1},0,{"$f":"D79*C$72*C$74","v":0},null,24,0,0,{"$f":"IF(H79<>0,I79*H$72*H$74,0)","v":0}]
[null,34,{"$f":"C73*C74","v":1},0,{"$f":"D80*C$73*C$74","v":0},null,34,0,0,{"$f":"IF(H80<>0,I80*H$73*H$74,0)","v":0}]
[null,123,{"$f":"C71*C72*C73","v":1},0,{"$f":"D81*C$71*C$72*C$73","v":0},null,123,0,0,{"$f":"IF(H81<>0,I81*H$71*H$72*H$73,0)","v":0}]
[null,124,{"$f":"C71*C72*C74","v":1},0,{"$f":"D82*C$71*C$72*C$74","v":0},null,124,0,0,{"$f":"IF(H82<>0,I82*H$71*H$72*H$74,0)","v":0}]
[null,134,{"$f":"C71*C73*C74","v":1},0,{"$f":"D83*C$71*C$73*C$74","v":0},null,134,0,0,{"$f":"IF(H83<>0,I83*H$71*H$73*H$74,0)","v":0}]
[null,234,{"$f":"C72*C73*C74","v":1},0,{"$f":"D84*C$72*C$73*C$74","v":0},null,234,0,0,{"$f":"IF(H84<>0,I84*H$72*H$73*H$74,0)","v":0}]
[null,1234,{"$f":"C71*C72*C73*C74","v":1},0,{"$f":"D85*C$71*C$72*C$73*C$74","v":0},null,1234,0,0,{"$f":"IF(H85<>0,I85*H$71*H$72*H$73*H$74,0)","v":0}]
[null,"Y",null,null,{"$f":"SUM(E70:E85)","v":0},null,"Y",null,null,{"$f":"SUM(J70:J85)","v":0}]
[null,{"$f":"$B62","v":"Center p"},null,null,{"$f":"IF(D62<>\"\",D46+D62,\"\")","v":""},null,{"$f":"$B62","v":"Center p"},null,null,{"$f":"IF(D62<>\"\",D46+D62,\"\")","v":""}]
[]
[]
[]
["Design matrix",null,"2^3",null,null,"Factor"]
[null,null,"Run","Mean",1,2,3,4,12,13,14,23,24,34,123,124,134,234,1234,null,"Mmult"]
[null,null,1,1,-1,-1,-1,-1,{"$f":"E93*F93","v":1},{"$f":"E93*G93","v":1},{"$f":"E93*H93","v":1},{"$f":"F93*G93","v":1},{"$f":"F93*H93","v":1},{"$f":"G93*H93","v":1},{"$f":"E93*F93*G93","v":-1},{"$f":"E93*F93*H93","v":-1},{"$f":"E93*G93*H93","v":-1},{"$f":"F93*G93*H93","v":-1},{"$f":"E93*F93*G93*H93","v":1},null,{"$f":"MMULT($D$112:$S$127,$K$18:$K$33)","v":0}]
[null,null,2,1,1,-1,-1,-1,{"$f":"E94*F94","v":-1},{"$f":"E94*G94","v":-1},{"$f":"E94*H94","v":-1},{"$f":"F94*G94","v":1},{"$f":"F94*H94","v":1},{"$f":"G94*H94","v":1},{"$f":"E94*F94*G94","v":1},{"$f":"E94*F94*H94","v":1},{"$f":"E94*G94*H94","v":1},{"$f":"F94*G94*H94","v":-1},{"$f":"E94*F94*G94*H94","v":-1},null,0]
[null,null,3,1,-1,1,-1,-1,-1,1,1,-1,-1,1,1,1,-1,1,-1,null,0]
[null,null,4,1,1,1,-1,-1,1,-1,-1,-1,-1,1,-1,-1,1,1,1,null,0]
[null,null,5,1,-1,-1,1,-1,1,-1,1,-1,1,-1,1,-1,1,1,-1,null,0]
[null,null,6,1,1,-1,1,-1,-1,1,-1,-1,1,-1,-1,1,-1,1,1,null,0]
[null,null,7,1,-1,1,1,-1,-1,-1,1,1,-1,-1,-1,1,1,-1,1,null,0]
[null,null,8,1,1,1,1,-1,1,1,-1,1,-1,-1,1,-1,-1,-1,-1,null,0]
[null,null,9,1,-1,-1,-1,1,1,1,-1,1,-1,-1,-1,1,1,1,-1,null,0]
[null,null,10,1,1,-1,-1,1,-1,-1,1,1,-1,-1,1,-1,-1,1,1,null,0]
[null,null,11,1,-1,1,-1,1,-1,1,-1,-1,1,-1,1,-1,1,-1,1,null,0]
[null,null,12,1,1,1,-1,1,1,-1,1,-1,1,-1,-1,1,-1,-1,-1,null,0]
[null,null,13,1,-1,-1,1,1,1,-1,-1,-1,-1,1,1,1,-1,-1,1,null,0]
[null,null,14,1,1,-1,1,1,-1,1,1,-1,-1,1,-1,-1,1,-1,-1,null,0]
[null,null,15,1,-1,1,1,1,-1,-1,-1,1,1,1,-1,-1,-1,1,-1,null,0]
[null,null,16,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,0]
[]
["Matrix",null,null,"Transposed design matrix"]
[null,null,"Run",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16]
[null,null,"Mean",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,1,-1,1,-1,1,-1,1,-1,1,-1,1,-1,1,-1,1,-1,1]
[null,null,2,-1,-1,1,1,-1,-1,1,1,-1,-1,1,1,-1,-1,1,1]
[null,null,3,-1,-1,-1,-1,1,1,1,1,-1,-1,-1,-1,1,1,1,1]
[null,null,4,-1,-1,-1,-1,-1,-1,-1,-1,1,1,1,1,1,1,1,1]
[null,null,12,1,-1,-1,1,1,-1,-1,1,1,-1,-1,1,1,-1,-1,1]
[null,null,13,1,-1,1,-1,-1,1,-1,1,1,-1,1,-1,-1,1,-1,1]
[null,null,14,1,-1,1,-1,1,-1,1,-1,-1,1,-1,1,-1,1,-1,1]
[null,null,23,1,1,-1,-1,-1,-1,1,1,1,1,-1,-1,-1,-1,1,1]
[null,null,24,1,1,-1,-1,1,1,-1,-1,-1,-1,1,1,-1,-1,1,1]
[null,null,34,1,1,1,1,-1,-1,-1,-1,-1,-1,-1,-1,1,1,1,1]
[null,null,123,-1,1,1,-1,1,-1,-1,1,-1,1,1,-1,1,-1,-1,1]
[null,null,124,-1,1,1,-1,-1,1,1,-1,1,-1,-1,1,1,-1,-1,1]
[null,null,134,-1,1,-1,1,1,-1,1,-1,1,-1,1,-1,-1,1,-1,1]
[null,null,234,-1,-1,1,1,1,1,-1,-1,1,1,-1,-1,-1,-1,1,1]
[null,null,1234,1,-1,-1,1,-1,1,1,-1,-1,1,1,-1,1,-1,-1,1]

{"sheet":"R16 5 factors V","index":5,"n_rows":127,"n_cols":37,"rows_kept":127,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'R16 Designs 4-5'!A1","v":"DOE_R16_Beta"},null,null,null,"2^(5-1)","Fractional factor design",null,null,"Resolution V",null,"5 main effects",null,"10 interactions",null,null,null,"Generator: 5 = 1234",null,null,null,null,{"$f":"Input!AA1","v":"Author: Bo Svensmark, svensmark@plen.ku.dk, Analytical Chemistry, PLEN, 2015 - 2025"}]
[]
[null,"1) Enter parameters in sheet \"R16 Designs 4-5\"",null,null,null,null,"(Input in white cells only)",null,null,null,null,"This design is for 5 main effects and 2-factor interactions",null,null,null,null,{"$f":"IF('R16 Designs 4-5'!N13=5,5,0)","v":0},null,"Confounding:",null,null,"This sheet can also be used in manual mode: "]
[null,"2) Enter all result in sheets \"Input\" and fill 1 or 0  in row 3 in \"Input\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"See Effects Table",null,null,null,"Enter results of the runs in the table F18:I21 and F22:G29"]
[null,"3) Click on \"Start\" to load the first case.  Check that Next in cell K12 is 1",null,null,null,null,null,null,null,null,null,"Centerpoints may be omitted.",null,null,null,null,null,null,null,null,null,null,"Click on \"Update sheet\" to calculate results"]
[null,"4) See the results here",null,null,null,null,null,null,null,null,null,"With no replicates, no statistics is calculated",null,null,null,null,null,null,null,null,null,null,"You may set confidense interval manually, see below"]
[null,"5) Set confidence intervals for effects manually (see notes --->)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click on \"Save\" to save results to sheet \"Output\""]
[null,"6) Click \"Save\" or \"Save and load next analyte\" to save results and proceed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Most cells are shown with 2 significant digits. You may want to cange that for small values"]
["Design","Factor",1,2,3,4,5,"No of center points:",null,{"$f":"'R16 Designs 4-5'!N14","v":0},null,{"$f":"IF(Q16=\"No\",\"Results are NOT saved\",\"Results are saved in sheet Output\")","v":"Results are saved in sheet Output"}]
[null,"Name",{"$f":"IF($Q$3=5,'R16 Designs 4-5'!C20,\"\")","v":""},{"$f":"IF($Q$3=5,'R16 Designs 4-5'!D20,\"\")","v":""},{"$f":"IF($Q$3=5,'R16 Designs 4-5'!E20,\"\")","v":""},{"$f":"IF($Q$3=5,'R16 Designs 4-5'!F20,\"\")","v":""},{"$f":"IF($Q$3=5,'R16 Designs 4-5'!G20,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Set the confidence interval for an effects manually (Manual limit):"]
[null,"Unit",{"$f":"IF($Q$3=5,'R16 Designs 4-5'!C21,\"\")","v":""},{"$f":"IF($Q$3=5,'R16 Designs 4-5'!D21,\"\")","v":""},{"$f":"IF($Q$3=5,'R16 Designs 4-5'!E21,\"\")","v":""},{"$f":"IF($Q$3=5,'R16 Designs 4-5'!F21,\"\")","v":""},{"$f":"IF($Q$3=5,'R16 Designs 4-5'!G21,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If you do not have any replicate or centre points, you may enter a confidence interval manually (Manual limit)"]
[null,"Low",{"$f":"IF($Q$3=5,'R16 Designs 4-5'!C22,\"\")","v":""},{"$f":"IF($Q$3=5,'R16 Designs 4-5'!D22,\"\")","v":""},{"$f":"IF($Q$3=5,'R16 Designs 4-5'!E22,\"\")","v":""},{"$f":"IF($Q$3=5,'R16 Designs 4-5'!F22,\"\")","v":""},{"$f":"IF($Q$3=5,'R16 Designs 4-5'!G22,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All effects of absolute magnitude higher than the manual limit will be marked as signficant (+, ++, +++ instead of *, **, ***)"]
[null,"Center 1",{"$f":"IF($Q$3=5,IF('R16 Designs 4-5'!C23=\"\",\"\",'R16 Designs 4-5'!C23),\"\")","v":""},{"$f":"IF($Q$3=5,IF('R16 Designs 4-5'!D23=\"\",\"\",'R16 Designs 4-5'!D23),\"\")","v":""},{"$f":"IF($Q$3=5,IF('R16 Designs 4-5'!E23=\"\",\"\",'R16 Designs 4-5'!E23),\"\")","v":""},{"$f":"IF($Q$3=5,IF('R16 Designs 4-5'!F23=\"\",\"\",'R16 Designs 4-5'!F23),\"\")","v":""},{"$f":"IF($Q$3=5,IF('R16 Designs 4-5'!G23=\"\",\"\",'R16 Designs 4-5'!G23),\"\")","v":""},"Analyte:",null,null,null,null,"Rel. Area =",null,null,{"$f":"IF(ABS(SUM(C47:C61)-SUM(W44:W58))>0.000000000001,\"Please update sheet\",\"\")","v":""}]
[null,"Center 2",{"$f":"IF($Q$3=5,IF('R16 Designs 4-5'!C24=\"\",\"\",'R16 Designs 4-5'!C24),\"\")","v":""},{"$f":"IF($Q$3=5,IF('R16 Designs 4-5'!D24=\"\",\"\",'R16 Designs 4-5'!D24),\"\")","v":""},{"$f":"IF($Q$3=5,IF('R16 Designs 4-5'!E24=\"\",\"\",'R16 Designs 4-5'!E24),\"\")","v":""},{"$f":"IF($Q$3=5,IF('R16 Designs 4-5'!F24=\"\",\"\",'R16 Designs 4-5'!F24),\"\")","v":""},{"$f":"IF($Q$3=5,IF('R16 Designs 4-5'!G24=\"\",\"\",'R16 Designs 4-5'!G24),\"\")","v":""},"Comm:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Even if you have an experimental determined statistical CI, you may want to play with the CI because:"]
[null,"High",{"$f":"IF($Q$3=5,'R16 Designs 4-5'!C25,\"\")","v":""},{"$f":"IF($Q$3=5,'R16 Designs 4-5'!D25,\"\")","v":""},{"$f":"IF($Q$3=5,'R16 Designs 4-5'!E25,\"\")","v":""},{"$f":"IF($Q$3=5,'R16 Designs 4-5'!F25,\"\")","v":""},{"$f":"IF($Q$3=5,'R16 Designs 4-5'!G25,\"\")","v":""},"Results","Replicates",null,null,"Yes",null,null,null,"Saved?","Yes",null,null,null,null,null,"For your purpose, even statistically insignificant effects may be important"]
[null,"Run",1,2,3,4,5,1,2,3,4,"Mean","Stdev.","d.f.",null,"Index out",1,null,null,null,null,null,"You suspect that the experimentally determined uncertainty is wrong"]
["Corner",1,{"$f":"$C$13","v":""},{"$f":"$D$13","v":""},{"$f":"$E$13","v":""},{"$f":"$F$13","v":""},{"$f":"$G$16","v":""},null,null,null,null,{"$f":"IF(H18<>\"\",AVERAGE(H18:K18),0)","v":0},{"$f":"IF(N18>0,_xlfn.STDEV.S(H18:K18),0)","v":0},{"$f":"IF(H18<>\"\",COUNT(H18:K18)-1,0)","v":0}]
["points",2,{"$f":"$C$16","v":""},{"$f":"$D$13","v":""},{"$f":"$E$13","v":""},"",{"$f":"$G$13","v":""},null,null,null,null,0,{"$f":"IF(N19>0,_xlfn.STDEV.S(H19:K19),0)","v":0},{"$f":"IF(H19<>\"\",COUNT(H19:K19)-1,0)","v":0},null,"Generator:"]
[null,3,{"$f":"$C$13","v":""},{"$f":"$D$16","v":""},{"$f":"$E$13","v":""},"",{"$f":"$G$13","v":""},null,null,null,null,0,0,0,null,"5 = 1234"]
[null,4,{"$f":"$C$16","v":""},{"$f":"$D$16","v":""},{"$f":"$E$13","v":""},"",{"$f":"$G$16","v":""},null,null,null,null,0,0,0]
[null,5,{"$f":"$C$13","v":""},{"$f":"$D$13","v":""},{"$f":"$E$16","v":""},"",{"$f":"$G$13","v":""},null,null,null,null,0,0,0,null,null,null,null,null,null,null,"Model optimization:"]
[null,6,{"$f":"$C$16","v":""},{"$f":"$D$13","v":""},{"$f":"$E$16","v":""},"",{"$f":"$G$16","v":""},null,null,null,null,0,0,0,null,null,null,null,null,null,null,"During the analysis of the results, statistical and scientific, you may have desided, which EFFECTS are important, and which are not"]
[null,7,{"$f":"$C$13","v":""},{"$f":"$D$16","v":""},{"$f":"$E$16","v":""},"",{"$f":"$G$16","v":""},null,null,null,null,0,0,0]
[null,8,{"$f":"$C$16","v":""},{"$f":"$D$16","v":""},{"$f":"$E$16","v":""},"",{"$f":"$G$13","v":""},null,null,null,null,0,0,0,null,null,null,null,null,null,null,"In the model optimization, you can play with the FACTORS, and see"]
[null,9,{"$f":"$C$13","v":""},{"$f":"$D$13","v":""},{"$f":"$E$13","v":""},{"$f":"$F$16","v":""},{"$f":"$G$13","v":""},null,null,null,null,0,0,0,null,null,null,null,null,null,null," ","Which factors you must control, and which you may negect"]
[null,10,{"$f":"$C$16","v":""},{"$f":"$D$13","v":""},{"$f":"$E$13","v":""},"",{"$f":"$G$16","v":""},null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,"What level each factor must have in order to obtain the best result"]
[null,11,{"$f":"$C$13","v":""},{"$f":"$D$16","v":""},{"$f":"$E$13","v":""},"",{"$f":"$G$16","v":""},null,null,null,null,0,0,0]
[null,12,{"$f":"$C$16","v":""},{"$f":"$D$16","v":""},{"$f":"$E$13","v":""},"",{"$f":"$G$13","v":""},null,null,null,null,0,0,0,null,null,null,null,null,null,null,"Please note, that main factors and interactions are linked in the model, i.e.:"]
[null,13,{"$f":"$C$13","v":""},{"$f":"$D$13","v":""},{"$f":"$E$16","v":""},"",{"$f":"$G$16","v":""},null,null,null,null,0,0,0,null,null,null,null,null,null,null,"You cannot keep an interaction without keeing the corresponding main factors in the model"]
[null,14,{"$f":"$C$16","v":""},{"$f":"$D$13","v":""},{"$f":"$E$16","v":""},"",{"$f":"$G$13","v":""},null,null,null,null,0,0,0]
[null,15,{"$f":"$C$13","v":""},{"$f":"$D$16","v":""},{"$f":"$E$16","v":""},"",{"$f":"$G$13","v":""},null,null,null,null,0,0,0]
[null,16,{"$f":"$C$16","v":""},{"$f":"$D$16","v":""},{"$f":"$E$16","v":""},"",{"$f":"$G$16","v":""},null,null,null,null,0,0,0]
["Center 1",17,{"$f":"IF(C$14=\"\",\"\",IF($B34<$J$10+17,C$14,\"\"))","v":""},{"$f":"IF(D$14=\"\",\"\",IF($B34<$J$10+17,D$14,\"\"))","v":""},"","","",null,null,null,null,{"$f":"IF(H34<>\"\",AVERAGE(H34:I37),0)","v":0},{"$f":"IF(N34>0,STDEV(H34:I37),0)","v":0},{"$f":"IF(H34<>\"\",COUNT(H34:I37)-1,0)","v":0},"All center points"]
["points",18,{"$f":"IF(C$14=\"\",\"\",IF($B35<$J$10+17,C$14,\"\"))","v":""},"","","","",null,null,null,null,null,null,null,"Mean","d.f"]
[null,19,"","","","","",null,null,null,null,null,null,null,{"$f":"IF(H34<>\"\",AVERAGE(H34:I41),\"\")","v":""},{"$f":"N34+N38","v":0}]
[null,20,"","","","",""]
["Center 2",21,{"$f":"IF(C$15=\"\",\"\",IF($B38<$J$10+21,C$15,\"\"))","v":""},{"$f":"IF(D$15=\"\",\"\",IF($B38<$J$10+21,D$15,\"\"))","v":""},"","","",null,null,null,null,{"$f":"IF(H38<>\"\",AVERAGE(H38:I41),0)","v":0},{"$f":"IF(N38>0,STDEV(H38:I41),0)","v":0},{"$f":"IF(H38<>\"\",COUNT(H38:I41)-1,0)","v":0},{"$f":"IF(P39>0,\"Statistics\",\"No statistics\")","v":"No statistics"}]
["points",22,{"$f":"IF(C$15=\"\",\"\",IF($B39<$J$10+21,C$15,\"\"))","v":""},"","","","",null,null,null,null,null,null,null,"d.f.",{"$f":"SUM(N18:N38)","v":0}]
[null,23,"","","","","",null,null,null,null,null,null,null,"s(pool)",{"$f":"IF(P39>0,SQRT(SUM(M18:M38^2*N18:N38)/P39),\"\")","v":""}]
[null,24,"","","","","",null,null,null,null,null,null,null,"s(effect)",{"$f":"IF(P39>0,2*P40/SQRT(COUNT(H18:K33)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"Extra runs"]
[null,"Enter manual Limit:",null,null,null,"95% Confidence interval for an effect, CI:",null,null,null,{"$f":"AK44","v":0},null,"Blue points:  not significant effects",null,null,null,null,null,null,null,null,null,"Terms","Effect","P","Noise",null,"Index","Fractile","Probit","IF",null,"Blue","Model",null,"CI(95%)","d.f.",{"$f":"IF(P41<>\"\",P39,4)","v":4}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(P41<>\"\",P41*TINV(0.05,P39),\"na\")","v":"na"},null,"Red points:   significant effects",null,null,null,null,null,null,null,null,null,"1+2345",0,1,0,null,1,{"$f":"(AA44-0.375)/($W$59+0.25)","v":4.0983606557377046E-2},{"$f":"NORMSINV(AB44)","v":-1.7393841569195561},{"$f":"IF($AK$44<>\"\",IF(X44>=0.05,W44,\"\"),W44)","v":0},null,"line",null,null,null,"CI +/-",{"$f":"IF(D43>0,D43,IF(P41<>\"\",P41*TINV(0.05,AK43),0))","v":0}]
["Effects","Term","Effect","Coeff","P","Sign?",null,null,null,null,null,"Green lines: If <>0: 95 % confidence interval",null,null,null,null,null,null,null,null,null,"2+1345",0,1,0,null,2,0.10655737704918032,-1.2450462387740626,{"$f":"IF($AK$44<>\"\",IF(X45>=0.05,W45,\"\"),W45)","v":0},null,null,"Slope",{"$f":"1/AK45","v":{"$error":"#DIV/0!"}},null,"s(effect)",{"$f":"AK44/TINV(0.05,AK43)","v":0}]
[null,"Mean",{"$f":"U93/16","v":0},{"$f":"C46","v":0},{"$f":"IF($AK$44>0,TDIST(ABS(C46)/$AK$45,$AK$43,2),1)","v":1},{"$f":"IF(E46<0.001,\"***\",IF(E46<0.01,\"**\",IF(E46<0.05,\"*\",\"\")))","v":""},null,"Effectes sorted from low to high",null,null,null,"Blue line:    True noise factors should be on this line",null,null,null,null,null,null,null,null,null,"3+1245",0,1,0,null,3,0.1721311475409836,-0.94577708618931966,0,null,null,"X","Y","CI lines","X","Y"]
[null,"1+2345",{"$f":"U94/8","v":0},{"$f":"C47/2","v":0},1,"",null,"Term",{"$f":"W43","v":"Effect"},{"$f":"Y43","v":"Noise"},null,null,null,null,null,null,null,null,null,null,null,"4+1235",0,1,0,null,4,0.23770491803278687,-0.7137046409102612,0,null,"Low",{"$f":"AH47/$AH$45","v":{"$error":"#DIV/0!"}},{"$f":"MIN(AC44:AC58)","v":-1.7393841569195561},"SV",{"$f":"-AK44","v":0},{"$f":"MIN(AC44:AC58)","v":-1.7393841569195561}]
[null,"2+1345",0,{"$f":"C48/2","v":0},1,"",null,{"$f":"V44","v":"1+2345"},null,{"$f":"IF(Y44<>\"\",Y44,\"\")","v":0},null,null,null,null,null,null,null,null,null,null,null,"5+1234",0,1,0,null,5,0.30327868852459017,-0.51499376488951132,0,null,"High",{"$f":"AH48/$AH$45","v":{"$error":"#DIV/0!"}},{"$f":"MAX(AC44:AC58)","v":1.7393841569195554},"NV",{"$f":"-AK44","v":0},{"$f":"MAX(AC44:AC58)","v":1.7393841569195554}]
[null,"3+1245",0,0,1,"",null,"2+1345",null,{"$f":"IF(Y45<>\"\",Y45,\"\")","v":0},null,null,null,null,null,null,null,null,null,null,null,"12+345",0,1,0,null,6,0.36885245901639346,-0.33489417272961575,0,null,null,null,null,"SE",{"$f":"AK44","v":0},{"$f":"MIN(AC44:AC58)","v":-1.7393841569195561}]
[null,"4+1235",0,0,1,"",null,"3+1245",{"$f":"IF(Y46<>\"\",\"\",W46)","v":""},0,null,null,null,null,null,null,null,null,null,null,null,"13+245",0,1,0,null,7,0.4344262295081967,-0.16511628036201545,0,null,"s(pool)",{"$f":"AK45*SQRT(COUNT(H18:K33))/2","v":0},null,"NE",{"$f":"AK44","v":0},{"$f":"MAX(AC44:AC58)","v":1.7393841569195554}]
[null,"5+1234",0,0,1,"",null,"4+1235","",0,null,null,null,null,null,null,null,null,null,null,null,"14+235",0,1,0,null,8,0.5,0,0]
[null,"12+345",0,0,1,"",null,"5+1234","",0,null,null,null,null,null,null,null,null,null,null,null,"15+234",0,1,0,null,9,0.56557377049180324,0.16511628036201531,0]
[null,"13+245",0,0,1,"",null,"12+345","",0,null,null,null,null,null,null,null,null,null,null,null,"23+145",0,1,0,null,10,0.63114754098360659,0.33489417272961586,0]
[null,"14+235",0,0,1,"",null,"13+245","",0,null,null,null,null,null,null,null,null,null,null,null,"24+135",0,1,0,null,11,0.69672131147540983,0.51499376488951132,0]
[null,"15+234",0,0,1,"",null,"14+235","",0,null,null,null,null,null,null,null,null,null,null,null,"25+134",0,1,0,null,12,0.76229508196721307,0.71370464091026031,0]
[null,"23+145",0,0,1,"",null,"15+234","",0,null,null,null,null,null,null,null,null,null,null,null,"34+125",0,1,0,null,13,0.82786885245901642,0.94577708618931966,0]
[null,"24+135",0,0,1,"",null,"23+145","",0,null,null,null,null,null,null,null,null,null,null,null,"35+124",0,1,0,null,14,0.89344262295081966,1.2450462387740626,0]
[null,"25+134",0,0,1,"",null,"24+135","",0,null,null,null,null,null,null,null,null,null,null,null,"45+123",0,1,0,null,15,{"$f":"(AA58-0.375)/($W$59+0.25)","v":0.95901639344262291},{"$f":"NORMSINV(AB58)","v":1.7393841569195554},0]
[null,"34+125",0,0,1,"",null,"25+134","",0,null,null,null,null,null,null,null,null,null,null,null,"N =",{"$f":"COUNT(W44:W58)","v":15},"d.f.",{"$f":"COUNT(Y44:Y58)","v":15}]
[null,"35+124",0,0,1,"",null,"34+125","",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"s(Noise)",{"$f":"SQRT(SUM(Y44:Y58^2)/COUNT(Y44:Y58))","v":0}]
[null,"45+123",0,0,1,"",null,"35+124","",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"CI(noise)",{"$f":"Y60*TINV(0.05,Y59)","v":0}]
[null,"Center p",{"$f":"IF(H34<>\"\",O36-C46,\"\")","v":""},{"$f":"C62","v":""},{"$f":"IF(C62<>\"\",IF(AK44>0,TDIST(ABS(C62)/(AG50*SQRT(1/(P36+1)+1/(COUNT(H18:K33)))),AK43,2),1),\"\")","v":""},"",null,"45+123","",0]
[null,null,"Manual limit:",null,"Statistics:",null,null,null,"CI(Noise)",{"$f":"IF(Y59>0,Y61,\"\")","v":0}]
[null,null,"P<0.05","+","P<0.05","*"]
[null,null,"P<0.01","++","P<0.01","**"]
[null,null,"P<0.001","+++","P<0.001","***"]
[null,null,null,null,"If no s(effect) all  P=1"]
[null,"Model 2"]
[null,{"$f":"B45","v":"Term"},"X","Coeff","Value",null,"Predict the respons and optimize"]
[null,"Mean",1,{"$f":"D46","v":0},{"$f":"C70*D70","v":0},null,"Model:"]
[null,"1+2345",0,0,{"$f":"C71*D71","v":0},null,"Y = C(Mean) + X1*C1 + X2*C2 + X3*C3 + X4*C4 + X5*C5 + Interactions"]
[null,"2+1345",0,0,0,null,"X = -1, 0, 1 or -1.0 to 1.0 (coded values)"]
[null,"3+1245",0,0,0,null,"C = Coefficients"]
[null,"4+1235",0,0,0]
[null,"5+1234",0,0,0,null,"Interactions are almost impossible to estimate when X for main factors are different"]
[null,"12+345",0,0,{"$f":"C76+D76","v":0}]
[null,"13+245",0,0,{"$f":"C77+D77","v":0},null,"If the two interactions do not have the same sign, a value between -1.0 and 1.0 could be used"]
[null,"14+235",0,0,0,null,"but this it will be completely subjective"]
[null,"15+234",0,0,0]
[null,"23+145",0,0,0,null,"Use the model with care, mainly to exclude non-significant effects"]
[null,"24+135",0,0,0]
[null,"25+134",0,0,0]
[null,"34+125",0,0,0]
[null,"35+124",0,0,0]
[null,"45+123",0,0,0]
[null,"Y",null,null,{"$f":"SUM(E70:E85)","v":0}]
[null,{"$f":"$B62","v":"Center p"},null,null,{"$f":"IF(D62<>\"\",D46+D62,\"\")","v":""}]
[]
[]
[]
["Design matrix",null,"2^3",null,null,"Factor"]
[null,null,"Run","Mean","1+2345","2+1345","3+1245","4+1235","5+1234","12+345","13+245","14+235","15+234","23+145","24+135","25+134","34+125","35+124","45+123",null,"Mmult"]
[null,null,1,1,-1,-1,-1,-1,{"$f":"E93*F93*G93*H93","v":1},{"$f":"E93*F93","v":1},{"$f":"E93*G93","v":1},{"$f":"E93*H93","v":1},{"$f":"E93*I93","v":-1},{"$f":"F93*G93","v":1},{"$f":"F93*H93","v":1},{"$f":"F93*I93","v":-1},{"$f":"G93*H93","v":1},{"$f":"G93*I93","v":-1},{"$f":"H93*I93","v":-1},null,{"$f":"MMULT($D$112:$S$127,$L$18:$L$33)","v":0}]
[null,null,2,1,1,-1,-1,-1,{"$f":"E94*F94*G94*H94","v":-1},{"$f":"E94*F94","v":-1},{"$f":"E94*G94","v":-1},{"$f":"E94*H94","v":-1},{"$f":"E94*I94","v":-1},{"$f":"F94*G94","v":1},{"$f":"F94*H94","v":1},{"$f":"F94*I94","v":1},{"$f":"G94*H94","v":1},{"$f":"G94*I94","v":1},{"$f":"H94*I94","v":1},null,0]
[null,null,3,1,-1,1,-1,-1,-1,-1,1,1,1,-1,-1,-1,1,1,1,null,0]
[null,null,4,1,1,1,-1,-1,1,1,-1,-1,1,-1,-1,1,1,-1,-1,null,0]
[null,null,5,1,-1,-1,1,-1,-1,1,-1,1,1,-1,1,1,-1,-1,1,null,0]
[null,null,6,1,1,-1,1,-1,1,-1,1,-1,1,-1,1,-1,-1,1,-1,null,0]
[null,null,7,1,-1,1,1,-1,1,-1,-1,1,-1,1,-1,1,-1,1,-1,null,0]
[null,null,8,1,1,1,1,-1,-1,1,1,-1,-1,1,-1,-1,-1,-1,1,null,0]
[null,null,9,1,-1,-1,-1,1,-1,1,1,-1,1,1,-1,1,-1,1,-1,null,0]
[null,null,10,1,1,-1,-1,1,1,-1,-1,1,1,1,-1,-1,-1,-1,1,null,0]
[null,null,11,1,-1,1,-1,1,1,-1,1,-1,-1,-1,1,1,-1,-1,1,null,0]
[null,null,12,1,1,1,-1,1,-1,1,-1,1,-1,-1,1,-1,-1,1,-1,null,0]
[null,null,13,1,-1,-1,1,1,1,1,-1,-1,-1,-1,-1,-1,1,1,1,null,0]
[null,null,14,1,1,-1,1,1,-1,-1,1,1,-1,-1,-1,1,1,-1,-1,null,0]
[null,null,15,1,-1,1,1,1,-1,-1,-1,-1,1,1,1,-1,1,-1,-1,null,0]
[null,null,16,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,0]
[]
["Matrix",null,null,"Transposed design matrix"]
[null,null,"Run",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16]
[null,null,"Mean",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"1+2345",-1,1,-1,1,-1,1,-1,1,-1,1,-1,1,-1,1,-1,1]
[null,null,"2+1345",-1,-1,1,1,-1,-1,1,1,-1,-1,1,1,-1,-1,1,1]
[null,null,"3+1245",-1,-1,-1,-1,1,1,1,1,-1,-1,-1,-1,1,1,1,1]
[null,null,"4+1235",-1,-1,-1,-1,-1,-1,-1,-1,1,1,1,1,1,1,1,1]
[null,null,"5+1234",1,-1,-1,1,-1,1,1,-1,-1,1,1,-1,1,-1,-1,1]
[null,null,"12+345",1,-1,-1,1,1,-1,-1,1,1,-1,-1,1,1,-1,-1,1]
[null,null,"13+245",1,-1,1,-1,-1,1,-1,1,1,-1,1,-1,-1,1,-1,1]
[null,null,"14+235",1,-1,1,-1,1,-1,1,-1,-1,1,-1,1,-1,1,-1,1]
[null,null,"15+234",-1,-1,1,1,1,1,-1,-1,1,1,-1,-1,-1,-1,1,1]
[null,null,"23+145",1,1,-1,-1,-1,-1,1,1,1,1,-1,-1,-1,-1,1,1]
[null,null,"24+135",1,1,-1,-1,1,1,-1,-1,-1,-1,1,1,-1,-1,1,1]
[null,null,"25+134",-1,1,-1,1,1,-1,1,-1,1,-1,1,-1,-1,1,-1,1]
[null,null,"34+125",1,1,1,1,-1,-1,-1,-1,-1,-1,-1,-1,1,1,1,1]
[null,null,"35+124",-1,1,1,-1,-1,1,1,-1,1,-1,-1,1,1,-1,-1,1]
[null,null,"45+123",-1,1,1,-1,1,-1,-1,1,-1,1,1,-1,1,-1,-1,1]

{"sheet":"R16 6-8 factors IV","index":6,"n_rows":127,"n_cols":37,"rows_kept":127,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'R16 Designs 4-5'!A1","v":"DOE_R16_Beta"},null,null,null,"2^(8-4)","Fractional factor design",null,null,"Resolution IV",null,"6-8 main effects",null,"Interactions too confounded",null,null,"Generators: 5 = 234    6 = 134    7 = 123    8 = 124",null,null,null,null,null,null,{"$f":"Input!AA1","v":"Author: Bo Svensmark, svensmark@plen.ku.dk, Analytical Chemistry, PLEN, 2015 - 2025"}]
[]
[null,"1) Enter parameters in sheet \"R16 Designs 6-8\"",null,null,null,null,"(Input in white cells only)",null,null,null,null,"This design is for 6 to 8 main effects. ",null,null,null,null,{"$f":"IF(AND('R16 Designs 6-8'!N13>5,'R16 Designs 6-8'!N13<9),'R16 Designs 6-8'!N13,0)","v":0},null,null,null,null,null,"This sheet can also be used in manual mode: "]
[null,"2) Enter all result in sheets \"Input\" and fill 1 or 0  in row 3 in \"Input\"",null,null,null,null,null,null,null,null,null,"Intractions cannot be trusted",null,null,null,null,null,null,null,null,null,null,null,"Enter results of the runs in the table F18:I21 and F22:G29"]
[null,"3) Click on \"Start\" to load the first case.  Check that Next in cell K12 is 1",null,null,null,null,null,null,null,null,null,"Centerpoints may be omitted.",null,null,null,null,null,null,null,null,null,null,null,"Click on \"Update sheet\" to calculate results"]
[null,"4) See the results here",null,null,null,null,null,null,null,null,null,"With no replicates, no statistics is calculated",null,null,null,null,null,null,null,null,null,null,null,"You may set confidense interval manually, see below"]
[null,"5) Set confidence intervals for effects manually (see notes --->)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click on \"Save\" to save results to sheet \"Output\""]
[null,"6) Click \"Save\" or \"Save and load next analyte\" to save results and proceed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Most cells are shown with 2 significant digits. You may want to cange that for small values"]
["Design","Factor",1,2,3,4,5,6,7,8,"No of center points:",null,{"$f":"'R16 Designs 6-8'!N14","v":0},null,{"$f":"IF(T16=\"No\",\"Results are NOT saved\",\"Results are saved in sheet Output\")","v":"Results are saved in sheet Output"}]
[null,"Name",{"$f":"IF($Q$3>5,'R16 Designs 6-8'!C20,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!D20,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!E20,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!F20,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!G20,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!H20,\"\")","v":""},{"$f":"IF($Q$3>6,'R16 Designs 6-8'!I20,\"\")","v":""},{"$f":"IF($Q$3>7,'R16 Designs 6-8'!J20,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Set the confidence interval for an effects manually (Manual limit):"]
[null,"Unit",{"$f":"IF($Q$3>5,'R16 Designs 6-8'!C21,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!D21,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!E21,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!F21,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!G21,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!H21,\"\")","v":""},{"$f":"IF($Q$3>6,'R16 Designs 6-8'!I21,\"\")","v":""},{"$f":"IF($Q$3>7,'R16 Designs 6-8'!J21,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"If you do not have any replicate or centre points, you may enter a confidence interval manually (Manual limit)"]
[null,"Low",{"$f":"IF($Q$3>5,'R16 Designs 6-8'!C22,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!D22,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!E22,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!F22,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!G22,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!H22,\"\")","v":""},{"$f":"IF($Q$3>6,'R16 Designs 6-8'!I22,\"\")","v":""},{"$f":"IF($Q$3>7,'R16 Designs 6-8'!J22,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"All effects of absolute magnitude higher than the manual limit will be marked as signficant (+, ++, +++ instead of *, **, ***)"]
[null,"Center 1",{"$f":"IF($Q$3>5,IF('R16 Designs 6-8'!C23=\"\",\"\",'R16 Designs 6-8'!C23),\"\")","v":""},{"$f":"IF($Q$3>5,IF('R16 Designs 6-8'!D23=\"\",\"\",'R16 Designs 6-8'!D23),\"\")","v":""},{"$f":"IF($Q$3>5,IF('R16 Designs 6-8'!E23=\"\",\"\",'R16 Designs 6-8'!E23),\"\")","v":""},{"$f":"IF($Q$3>5,IF('R16 Designs 6-8'!F23=\"\",\"\",'R16 Designs 6-8'!F23),\"\")","v":""},{"$f":"IF($Q$3>5,IF('R16 Designs 6-8'!G23=\"\",\"\",'R16 Designs 6-8'!G23),\"\")","v":""},{"$f":"IF($Q$3>5,IF('R16 Designs 6-8'!H23=\"\",\"\",'R16 Designs 6-8'!H23),\"\")","v":""},{"$f":"IF($Q$3>6,IF('R16 Designs 6-8'!I23=\"\",\"\",'R16 Designs 6-8'!I23),\"\")","v":""},{"$f":"IF($Q$3>7,IF('R16 Designs 6-8'!J23=\"\",\"\",'R16 Designs 6-8'!J23),\"\")","v":""},"Analyte:",null,null,null,null,"Rel. Area =",null,null,{"$f":"IF(ABS(SUM(H39:H45)-SUM(AB35:AB41))>0.000000000001,\"Please update sheet\",\"\")","v":""}]
[null,"Center 2",{"$f":"IF($Q$3>5,IF('R16 Designs 6-8'!C24=\"\",\"\",'R16 Designs 6-8'!C24),\"\")","v":""},{"$f":"IF($Q$3>5,IF('R16 Designs 6-8'!D24=\"\",\"\",'R16 Designs 6-8'!D24),\"\")","v":""},{"$f":"IF($Q$3>5,IF('R16 Designs 6-8'!E24=\"\",\"\",'R16 Designs 6-8'!E24),\"\")","v":""},{"$f":"IF($Q$3>5,IF('R16 Designs 6-8'!F24=\"\",\"\",'R16 Designs 6-8'!F24),\"\")","v":""},{"$f":"IF($Q$3>5,IF('R16 Designs 6-8'!G24=\"\",\"\",'R16 Designs 6-8'!G24),\"\")","v":""},{"$f":"IF($Q$3>5,IF('R16 Designs 6-8'!H24=\"\",\"\",'R16 Designs 6-8'!H24),\"\")","v":""},{"$f":"IF($Q$3>6,IF('R16 Designs 6-8'!I24=\"\",\"\",'R16 Designs 6-8'!I24),\"\")","v":""},{"$f":"IF($Q$3>7,IF('R16 Designs 6-8'!J24=\"\",\"\",'R16 Designs 6-8'!J24),\"\")","v":""},"Comm:",null,null,null,null,null,null,null,null,null,null,null,"Even if you have an experimental determined statistical CI, you may want to play with the CI because:"]
[null,"High",{"$f":"IF($Q$3>5,'R16 Designs 6-8'!C25,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!D25,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!E25,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!F25,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!G25,\"\")","v":""},{"$f":"IF($Q$3>5,'R16 Designs 6-8'!H25,\"\")","v":""},{"$f":"IF($Q$3>6,'R16 Designs 6-8'!I25,\"\")","v":""},{"$f":"IF($Q$3>7,'R16 Designs 6-8'!J25,\"\")","v":""},"Results","Replicates",null,null,null,null,null,null,"Saved?","Yes",null,null,null,"For your purpose, even statistically insignificant effects may be important"]
[null,"Run",1,2,3,4,5,6,7,8,1,2,3,4,"Mean","Stdev.","d.f.",null,"Index out",1,null,null,null,"You suspect that the experimentally determined uncertainty is wrong"]
["Corner",1,{"$f":"$C$13","v":""},{"$f":"$D$13","v":""},{"$f":"$E$13","v":""},{"$f":"$F$13","v":""},{"$f":"$G$13","v":""},{"$f":"$H$13","v":""},{"$f":"$I$13","v":""},{"$f":"$J$13","v":""},null,null,null,null,{"$f":"IF(K18<>\"\",AVERAGE(K18:N18),0)","v":0},{"$f":"IF(Q18>0,_xlfn.STDEV.S(K18:N18),0)","v":0},{"$f":"IF(K18<>\"\",COUNT(K18:N18)-1,0)","v":0}]
["points",2,{"$f":"$C$16","v":""},{"$f":"$D$13","v":""},{"$f":"$E$13","v":""},"",{"$f":"$G$13","v":""},{"$f":"$H$16","v":""},{"$f":"$I$16","v":""},{"$f":"$J$16","v":""},null,null,null,null,0,{"$f":"IF(Q19>0,_xlfn.STDEV.S(K19:N19),0)","v":0},{"$f":"IF(K19<>\"\",COUNT(K19:N19)-1,0)","v":0},null,"Generators:"]
[null,3,{"$f":"$C$13","v":""},{"$f":"$D$16","v":""},{"$f":"$E$13","v":""},"",{"$f":"$G$16","v":""},{"$f":"$H$13","v":""},{"$f":"$I$16","v":""},{"$f":"$J$16","v":""},null,null,null,null,0,0,0,null,"5 = 234","7 = 123"]
[null,4,{"$f":"$C$16","v":""},{"$f":"$D$16","v":""},{"$f":"$E$13","v":""},"",{"$f":"$G$16","v":""},{"$f":"$H$16","v":""},{"$f":"$I$13","v":""},{"$f":"$J$13","v":""},null,null,null,null,0,0,0,null,"6 = 134","8 = 124"]
[null,5,{"$f":"$C$13","v":""},{"$f":"$D$13","v":""},{"$f":"$E$16","v":""},"",{"$f":"$G$16","v":""},{"$f":"$H$16","v":""},{"$f":"$I$16","v":""},{"$f":"$J$13","v":""},null,null,null,null,0,0,0,null,null,null,null,null,"Model optimization:"]
[null,6,{"$f":"$C$16","v":""},{"$f":"$D$13","v":""},{"$f":"$E$16","v":""},"",{"$f":"$G$16","v":""},{"$f":"$H$13","v":""},{"$f":"$I$13","v":""},{"$f":"$J$16","v":""},null,null,null,null,0,0,0,null,"Confounding:",null,null,null,"During the analysis of the results, statistical and scientific, you may have desided, which EFFECTS are important, and which are not"]
[null,7,{"$f":"$C$13","v":""},{"$f":"$D$16","v":""},{"$f":"$E$16","v":""},"",{"$f":"$G$13","v":""},{"$f":"$H$16","v":""},{"$f":"$I$13","v":""},{"$f":"$J$16","v":""},null,null,null,null,0,0,0,null,"Main factors confounde "]
[null,8,{"$f":"$C$16","v":""},{"$f":"$D$16","v":""},{"$f":"$E$16","v":""},"",{"$f":"$G$13","v":""},{"$f":"$H$13","v":""},{"$f":"$I$16","v":""},{"$f":"$J$13","v":""},null,null,null,null,0,0,0,null,"with 3-factor interactions",null,null,null,"In the model optimization, you can play with the FACTORS, and see"]
[null,9,{"$f":"$C$13","v":""},{"$f":"$D$13","v":""},{"$f":"$E$13","v":""},{"$f":"$F$16","v":""},{"$f":"$G$16","v":""},{"$f":"$H$16","v":""},{"$f":"$I$13","v":""},{"$f":"$J$16","v":""},null,null,null,null,0,0,0,null,null,null,null,null," ","Which factors you must control, and which you may negect"]
[null,10,{"$f":"$C$16","v":""},{"$f":"$D$13","v":""},{"$f":"$E$13","v":""},"",{"$f":"$G$16","v":""},{"$f":"$H$13","v":""},{"$f":"$I$16","v":""},{"$f":"$J$13","v":""},null,null,null,null,0,0,0,null,"Interactions marked a are",null,null,null,null,"What level each factor must have in order to obtain the best result"]
[null,11,{"$f":"$C$13","v":""},{"$f":"$D$16","v":""},{"$f":"$E$13","v":""},"",{"$f":"$G$13","v":""},{"$f":"$H$16","v":""},{"$f":"$I$16","v":""},{"$f":"$J$13","v":""},null,null,null,null,0,0,0,null,"heavily confounded"]
[null,12,{"$f":"$C$16","v":""},{"$f":"$D$16","v":""},{"$f":"$E$13","v":""},"",{"$f":"$G$13","v":""},{"$f":"$H$13","v":""},{"$f":"$I$13","v":""},{"$f":"$J$16","v":""},null,null,null,null,0,0,0,null,null,null,null,null,"Please note, that main factors and interactions are linked in the model, i.e.:"]
[null,13,{"$f":"$C$13","v":""},{"$f":"$D$13","v":""},{"$f":"$E$16","v":""},"",{"$f":"$G$13","v":""},{"$f":"$H$13","v":""},{"$f":"$I$16","v":""},{"$f":"$J$16","v":""},null,null,null,null,0,0,0,null,null,null,null,null,"You cannot keep an interaction without keeing the corresponding main factors in the model"]
[null,14,{"$f":"$C$16","v":""},{"$f":"$D$13","v":""},{"$f":"$E$16","v":""},"",{"$f":"$G$13","v":""},{"$f":"$H$16","v":""},{"$f":"$I$13","v":""},{"$f":"$J$13","v":""},null,null,null,null,0,0,0]
[null,15,{"$f":"$C$13","v":""},{"$f":"$D$16","v":""},{"$f":"$E$16","v":""},"",{"$f":"$G$16","v":""},{"$f":"$H$13","v":""},{"$f":"$I$13","v":""},{"$f":"$J$13","v":""},null,null,null,null,0,0,0,null,null,null,null,null,"For 6  main factors:  Effect #7 and #8  are confounded interactions like a effects"]
[null,16,{"$f":"$C$16","v":""},{"$f":"$D$16","v":""},{"$f":"$E$16","v":""},"",{"$f":"$G$16","v":""},{"$f":"$H$16","v":""},{"$f":"$I$16","v":""},{"$f":"$J$16","v":""},null,null,null,null,0,0,0]
["Center 1",17,{"$f":"IF(C$14=\"\",\"\",IF($B34<$M$10+17,C$14,\"\"))","v":""},{"$f":"IF(D$14=\"\",\"\",IF($B34<$M$10+17,D$14,\"\"))","v":""},"","","","","","",null,null,null,null,{"$f":"IF(K34<>\"\",AVERAGE(K34:L37),0)","v":0},{"$f":"IF(Q34>0,STDEV(K34:L37),0)","v":0},{"$f":"IF(K34<>\"\",COUNT(K34:L37)-1,0)","v":0},"All center points",null,null,null,null,"For 7  main factors:  Effect #8  is confounded interactions like a effects"]
["points",18,{"$f":"IF(C$14=\"\",\"\",IF($B35<$M$10+17,C$14,\"\"))","v":""},"","","","","","","",null,null,null,null,null,null,null,"Mean","d.f"]
[null,19,"","","","","","","","",null,null,null,null,null,null,null,{"$f":"IF(K34<>\"\",AVERAGE(K34:L41),\"\")","v":""},{"$f":"Q34+Q38","v":0}]
[null,20,"","","","","","","",""]
["Center 2",21,{"$f":"IF(C$15=\"\",\"\",IF($B38<$M$10+21,C$15,\"\"))","v":""},{"$f":"IF(D$15=\"\",\"\",IF($B38<$M$10+21,D$15,\"\"))","v":""},"","","","","","",null,null,null,null,{"$f":"IF(K38<>\"\",AVERAGE(K38:L41),0)","v":0},{"$f":"IF(Q38>0,STDEV(K38:L41),0)","v":0},{"$f":"IF(K38<>\"\",COUNT(K38:L41)-1,0)","v":0},{"$f":"IF(S39>0,\"Statistics\",\"No statistics\")","v":"No statistics"}]
["points",22,{"$f":"IF(C$15=\"\",\"\",IF($B39<$M$10+21,C$15,\"\"))","v":""},"","","","","","","",null,null,null,null,null,null,null,"d.f.",{"$f":"SUM(Q18:Q38)","v":0}]
[null,23,"","","","","","","","",null,null,null,null,null,null,null,"s(pool)",{"$f":"IF(S39>0,SQRT(SUM(P18:P38^2*Q18:Q38)/S39),\"\")","v":""}]
[null,24,"","","","","","","","",null,null,null,null,null,null,null,"s(effect)",{"$f":"IF(S39>0,2*S40/SQRT(COUNT(K18:N33)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Extra runs"]
[null,"Enter manual Limit:",null,null,null,"95% Confidence interval for an effect, CI:",null,null,null,{"$f":"AK44","v":0},null,"Blue points:  not significant effects",null,null,null,null,null,null,null,null,null,"Terms","Effect","P","Noise",null,"Index","Fractile","Probit","IF",null,"Blue","Model",null,"CI(95%)","d.f.",{"$f":"IF(S41<>\"\",S39,4)","v":4}]
[null,null,null,null,null,null,null,null,"CI(exp) =",{"$f":"IF(S41<>\"\",S41*TINV(0.05,S39),\"na\")","v":"na"},null,"Red points:   significant effects",null,null,null,null,null,null,null,null,null,1,0,1,0,null,1,{"$f":"(AA44-0.375)/($W$59+0.25)","v":4.0983606557377046E-2},{"$f":"NORMSINV(AB44)","v":-1.7393841569195561},{"$f":"IF($AK$44<>\"\",IF(X44>=0.05,W44,\"\"),W44)","v":0},null,"line",null,null,null,"CI +/-",{"$f":"IF(D43>0,D43,IF(S41<>\"\",S41*TINV(0.05,AK43),0))","v":0}]
["Effects","Term","Effect","Coeff","P","Sign?",null,null,null,null,null,"Green lines: If <>0: 95 % confidence interval",null,null,null,null,null,null,null,null,null,2,0,1,0,null,2,0.10655737704918032,-1.2450462387740626,{"$f":"IF($AK$44<>\"\",IF(X45>=0.05,W45,\"\"),W45)","v":0},null,null,"Slope",{"$f":"1/AK45","v":{"$error":"#DIV/0!"}},null,"s(effect)",{"$f":"AK44/TINV(0.05,AK43)","v":0}]
[null,"Mean",{"$f":"U93/16","v":0},{"$f":"C46","v":0},{"$f":"IF($AK$44>0,TDIST(ABS(C46)/$AK$45,$AK$43,2),1)","v":1},{"$f":"IF(E46<0.001,\"***\",IF(E46<0.01,\"**\",IF(E46<0.05,\"*\",\"\")))","v":""},null,"Effectes sorted from low to high",null,null,null,"Blue line:    True noise factors should be on this line",null,null,null,null,null,null,null,null,null,3,0,1,0,null,3,0.1721311475409836,-0.94577708618931966,0,null,null,"X","Y","CI lines","X","Y"]
[null,1,{"$f":"U94/8","v":0},{"$f":"C47/2","v":0},1,"",null,{"$f":"V43","v":"Terms"},{"$f":"W43","v":"Effect"},{"$f":"Y43","v":"Noise"},null,null,null,null,null,null,null,null,null,null,null,4,0,1,0,null,4,0.23770491803278687,-0.7137046409102612,0,null,"Low",{"$f":"AH47/$AH$45","v":{"$error":"#DIV/0!"}},{"$f":"MIN(AC44:AC58)","v":-1.7393841569195561},"SV",{"$f":"-AK44","v":0},{"$f":"MIN(AC44:AC58)","v":-1.7393841569195561}]
[null,2,0,{"$f":"C48/2","v":0},1,"",null,{"$f":"V44","v":1},{"$f":"IF(Y44<>\"\",\"\",W44)","v":""},{"$f":"IF(Y44<>\"\",Y44,\"\")","v":0},null,null,null,null,null,null,null,null,null,null,null,5,0,1,0,null,5,0.30327868852459017,-0.51499376488951132,0,null,"High",{"$f":"AH48/$AH$45","v":{"$error":"#DIV/0!"}},{"$f":"MAX(AC44:AC58)","v":1.7393841569195554},"NV",{"$f":"-AK44","v":0},{"$f":"MAX(AC44:AC58)","v":1.7393841569195554}]
[null,3,0,0,1,"",null,{"$f":"V45","v":2},{"$f":"IF(Y45<>\"\",\"\",W45)","v":""},{"$f":"IF(Y45<>\"\",Y45,\"\")","v":0},null,null,null,null,null,null,null,null,null,null,null,6,0,1,0,null,6,0.36885245901639346,-0.33489417272961575,0,null,null,null,null,"SE",{"$f":"AK44","v":0},{"$f":"MIN(AC44:AC58)","v":-1.7393841569195561}]
[null,4,0,0,1,"",null,3,"",0,null,null,null,null,null,null,null,null,null,null,null,7,0,1,0,null,7,0.4344262295081967,-0.16511628036201545,0,null,"s(pool)",{"$f":"AK45*SQRT(COUNT(K18:N33))/2","v":0},null,"NE",{"$f":"AK44","v":0},{"$f":"MAX(AC44:AC58)","v":1.7393841569195554}]
[null,5,0,0,1,"",null,4,"",0,null,null,null,null,null,null,null,null,null,null,null,8,0,1,0,null,8,0.5,0,0]
[null,6,0,0,1,"",null,5,"",0,null,null,null,null,null,null,null,null,null,null,null,"a",0,1,0,null,9,0.56557377049180324,0.16511628036201531,0]
[null,7,0,0,1,"",null,6,"",0,null,null,null,null,null,null,null,null,null,null,null,"a",0,1,0,null,10,0.63114754098360659,0.33489417272961586,0]
[null,8,0,0,1,"",null,7,"",0,null,null,null,null,null,null,null,null,null,null,null,"a",0,1,0,null,11,0.69672131147540983,0.51499376488951132,0]
[null,"a",0,0,1,"",null,8,"",0,null,null,null,null,null,null,null,null,null,null,null,"a",0,1,0,null,12,0.76229508196721307,0.71370464091026031,0]
[null,"a",0,0,1,"",null,"a","",0,null,null,null,null,null,null,null,null,null,null,null,"a",0,1,0,null,13,0.82786885245901642,0.94577708618931966,0]
[null,"a",0,0,1,"",null,"a","",0,null,null,null,null,null,null,null,null,null,null,null,"a",0,1,0,null,14,0.89344262295081966,1.2450462387740626,0]
[null,"a",0,0,1,"",null,"a","",0,null,null,null,null,null,null,null,null,null,null,null,"a",0,1,0,null,15,{"$f":"(AA58-0.375)/($W$59+0.25)","v":0.95901639344262291},{"$f":"NORMSINV(AB58)","v":1.7393841569195554},0]
[null,"a",0,0,1,"",null,"a","",0,null,null,null,null,null,null,null,null,null,null,null,"N =",{"$f":"COUNT(W44:W58)","v":15},"d.f.",{"$f":"COUNT(Y44:Y58)","v":15}]
[null,"a",0,0,1,"",null,"a","",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"s(Noise)",{"$f":"SQRT(SUM(Y44:Y58^2)/COUNT(Y44:Y58))","v":0}]
[null,"a",0,0,1,"",null,"a","",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"CI(noise)",{"$f":"Y60*TINV(0.05,Y59)","v":0}]
[null,"Center p",{"$f":"IF(K34<>\"\",R36-C46,\"\")","v":""},{"$f":"C62","v":""},{"$f":"IF(C62<>\"\",IF(AK44>0,TDIST(ABS(C62)/(AG50*SQRT(1/(S36+1)+1/(COUNT(K18:N33)))),AK43,2),1),\"\")","v":""},"",null,"a","",0]
[null,null,"Manual limit:",null,"Statistics:",null,null,null,"CI(Noise)",{"$f":"IF(Y59>0,Y61,\"\")","v":0}]
[null,null,"P<0.05","+","P<0.05","*"]
[null,null,"P<0.01","++","P<0.01","**"]
[null,null,"P<0.001","+++","P<0.001","***"]
[null,null,null,null,"If no s(effect) all  P=1"]
[null,"Model 2"]
[null,{"$f":"B45","v":"Term"},"X","Coeff","Value",null,"Predict the respons and optimize"]
[null,"Mean",1,{"$f":"D46","v":0},{"$f":"C70*D70","v":0},null,"Model:"]
[null,1,0,0,{"$f":"C71*D71","v":0},null,"Y = C(Mean) + X1*C1 + X2*C2 + X3*C3 + … X8*C8 + Interactions"]
[null,2,0,0,0,null,"X = -1, 0, 1 or -1.0 to 1.0 (coded values)"]
[null,3,0,0,0,null,"C = Coefficients"]
[null,4,0,0,0]
[null,5,0,0,0,null,"Interactions are heavily confounded !"]
[null,6,0,0,0]
[null,7,0,0,0,null,"Interactions are almost impossible to estimate when X for main factors are different"]
[null,8,0,0,0]
[null,"a",0,0,0,null,"Use the model with care, mainly to exclude non-significant effects"]
[null,"a",0,0,0]
[null,"a",0,0,0]
[null,"a",0,0,0]
[null,"a",0,0,0]
[null,"a",0,0,0]
[null,"a",0,0,0]
[null,"Y",null,null,{"$f":"SUM(E70:E85)","v":0}]
[null,{"$f":"$B62","v":"Center p"},null,null,{"$f":"IF(D62<>\"\",D46+D62,\"\")","v":""}]
[]
[]
[]
["Design matrix",null,"2^3",null,null,"Factor"]
[null,null,"Run","Mean","1+","2+","3+","4+","5+","6+","7+","8+","12+","13+","14+","15+","16+","17+","18+",null,"Mmult"]
[null,null,1,1,-1,-1,-1,-1,{"$f":"F93*G93*H93","v":-1},{"$f":"E93*G93*H93","v":-1},{"$f":"E93*F93*G93","v":-1},{"$f":"E93*F93*H93","v":-1},{"$f":"E93*F93","v":1},{"$f":"E93*G93","v":1},{"$f":"E93*H93","v":1},{"$f":"E93*I93","v":1},{"$f":"E93*J93","v":1},{"$f":"E93*K93","v":1},{"$f":"E93*L93","v":1},null,{"$f":"MMULT($D$112:$S$127,$O$18:$O$33)","v":0}]
[null,null,2,1,1,-1,-1,-1,{"$f":"F94*G94*H94","v":-1},{"$f":"E94*G94*H94","v":1},{"$f":"E94*F94*G94","v":1},{"$f":"E94*F94*H94","v":1},{"$f":"E94*F94","v":-1},{"$f":"E94*G94","v":-1},{"$f":"E94*H94","v":-1},{"$f":"E94*I94","v":-1},{"$f":"E94*J94","v":1},{"$f":"E94*K94","v":1},{"$f":"E94*L94","v":1},null,0]
[null,null,3,1,-1,1,-1,-1,1,-1,1,1,-1,1,1,-1,1,-1,-1,null,0]
[null,null,4,1,1,1,-1,-1,1,1,-1,-1,1,-1,-1,1,1,-1,-1,null,0]
[null,null,5,1,-1,-1,1,-1,1,1,1,-1,1,-1,1,-1,-1,-1,1,null,0]
[null,null,6,1,1,-1,1,-1,1,-1,-1,1,-1,1,-1,1,-1,-1,1,null,0]
[null,null,7,1,-1,1,1,-1,-1,1,-1,1,-1,-1,1,1,-1,1,-1,null,0]
[null,null,8,1,1,1,1,-1,-1,-1,1,-1,1,1,-1,-1,-1,1,-1,null,0]
[null,null,9,1,-1,-1,-1,1,1,1,-1,1,1,1,-1,-1,-1,1,-1,null,0]
[null,null,10,1,1,-1,-1,1,1,-1,1,-1,-1,-1,1,1,-1,1,-1,null,0]
[null,null,11,1,-1,1,-1,1,-1,1,1,-1,-1,1,-1,1,-1,-1,{"$f":"E103*L103","v":1},null,0]
[null,null,12,1,1,1,-1,1,-1,-1,-1,1,1,-1,1,-1,-1,-1,1,null,0]
[null,null,13,1,-1,-1,1,1,-1,-1,1,1,1,-1,-1,1,1,-1,-1,null,0]
[null,null,14,1,1,-1,1,1,-1,1,-1,-1,-1,1,1,-1,1,-1,-1,null,0]
[null,null,15,1,-1,1,1,1,1,-1,-1,-1,-1,-1,-1,-1,1,1,1,null,0]
[null,null,16,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,0]
[]
["Matrix",null,null,"Transposed design matrix"]
[null,null,"Run",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16]
[null,null,"Mean",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"1+",-1,1,-1,1,-1,1,-1,1,-1,1,-1,1,-1,1,-1,1]
[null,null,"2+",-1,-1,1,1,-1,-1,1,1,-1,-1,1,1,-1,-1,1,1]
[null,null,"3+",-1,-1,-1,-1,1,1,1,1,-1,-1,-1,-1,1,1,1,1]
[null,null,"4+",-1,-1,-1,-1,-1,-1,-1,-1,1,1,1,1,1,1,1,1]
[null,null,"5+",-1,-1,1,1,1,1,-1,-1,1,1,-1,-1,-1,-1,1,1]
[null,null,"6+",-1,1,-1,1,1,-1,1,-1,1,-1,1,-1,-1,1,-1,1]
[null,null,"7+",-1,1,1,-1,1,-1,-1,1,-1,1,1,-1,1,-1,-1,1]
[null,null,"8+",-1,1,1,-1,-1,1,1,-1,1,-1,-1,1,1,-1,-1,1]
[null,null,"12+",1,-1,-1,1,1,-1,-1,1,1,-1,-1,1,1,-1,-1,1]
[null,null,"13+",1,-1,1,-1,-1,1,-1,1,1,-1,1,-1,-1,1,-1,1]
[null,null,"14+",1,-1,1,-1,1,-1,1,-1,-1,1,-1,1,-1,1,-1,1]
[null,null,"15+",1,-1,-1,1,-1,1,1,-1,-1,1,1,-1,1,-1,-1,1]
[null,null,"16+",1,1,1,1,-1,-1,-1,-1,-1,-1,-1,-1,1,1,1,1]
[null,null,"17+",1,1,-1,-1,-1,-1,1,1,1,1,-1,-1,-1,-1,1,1]
[null,null,"18+",1,1,-1,-1,1,1,-1,-1,-1,-1,1,1,-1,-1,1,1]

{"sheet":"Output","index":7,"n_rows":72,"n_cols":16,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'R16 Designs 4-5'!A1","v":"DOE_R16_Beta"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!AA1","v":"Author: Bo Svensmark, svensmark@plen.ku.dk, Analytical Chemistry, PLEN, 2015 - 2025"}]
[]
[]
[]
[]
[null,null,null,null,null,"No"]
[null,null,null,null,null,"Analyte"]
[null,null,null,null,null,"Relative area"]
[null,null,null,null,null,"Comments"]
["Factor","Name","Unit","Low","C1","C2","High"]
["Mean"]
[1]
[2]
[3]
[4]
[12]
[13]
[14]
[23]
[24]
[34]
[123]
[124]
[134]
[234]
[1234]
["Center p"]
["Statistics"]
["Mean"]
[1]
[2]
[3]
[4]
[12]
[13]
[14]
[23]
[24]
[34]
[123]
[124]
[134]
[234]
[1234]
["Center p"]
["Responses"]
["Run #",null,null,null,null,"Corner",1]
[null,null,null,null,null,null,2]
[null,null,null,null,null,null,3]
[null,null,null,null,null,null,4]
[null,null,null,null,null,null,5]
[null,null,null,null,null,null,6]
[null,null,null,null,null,null,7]
[null,null,null,null,null,null,8]
[null,null,null,null,null,null,9]
[null,null,null,null,null,null,10]
[null,null,null,null,null,null,11]
[null,null,null,null,null,null,12]
[null,null,null,null,null,null,13]
[null,null,null,null,null,null,14]
[null,null,null,null,null,null,15]
[null,null,null,null,null,null,16]
[null,null,null,null,null,"Center 1","17-20"]
[null,null,null,null,null,"Center 2","21-24"]
[null,null,null,null,null,"Extra runs",25]
[null,null,null,null,null,null,26]
[null,null,null,null,null,null,27]
[null,null,null,null,null,null,28]
[null,null,null,null,null,null,29]
[null,null,null,null,null,null,30]
[null,null,null,null,null,null,31]
[null,null,null,null,null,null,32]