{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["R8 Designs 3-4","R8 Designs 5-7","R8 Runs","Input","R8 3 factors FF","R8 4 factors IV)","R8 5-7 factors III","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":"R8 Designs 3-4","index":0,"n_rows":50,"n_cols":23,"rows_kept":50,"cut":false,"hidden":false,"merged":[[48,13,48,21],[49,13,49,21],[42,13,42,21],[43,13,43,21],[44,13,44,21],[45,13,45,21],[46,13,46,21],[47,13,47,21],[41,13,41,21],[30,13,30,21],[31,13,31,21],[32,13,32,21],[33,13,33,21],[34,13,34,21],[35,13,35,21],[36,13,36,21],[37,13,37,21],[38,13,38,21],[39,13,39,21],[40,13,40,21],[29,13,29,21],[10,3,10,8],[11,3,11,8],[12,3,12,8],[13,3,13,8],[14,3,14,8],[15,3,15,8],[24,13,24,21],[25,13,25,21],[26,13,26,21],[27,13,27,21],[28,13,28,21],[23,13,23,21]]}
["DOE_R8_1.0",null,null,null,null,null,null,null,null,"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,"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,"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,"Table 2: Parameters that must be valid  (Ok)"]
[null,"3) When everything is ready click on  Make run tables",null,null,null,null,null,null,null,null,"Table 3: Factors and levels "]
[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",null,null,null,null,null,null,null,null,"Table 5: Comments in free format (1 line of any length)"]
[null,"    (Use Save As...)",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,"Table 2: Design parameters",null,null,"Valid input",null,null,"Methods"]
[null,"Group",null,null,null,null,null,null,null,{"$f":"IF(D11=\"\",\"Warning\",\"\")","v":"Warning"},"Method",null,null,"Methods",{"$f":"IF(ISNA(VLOOKUP(M11,Q11:Q19,1,FALSE)),\"Error\",\"\")","v":"Error"},null,"SH","Static headspace"]
[null,"Date",null,null,null,null,null,null,null,{"$f":"IF(D12=\"\",\"Warning\",\"\")","v":"Warning"},"Design no",null,null,"1-",{"$f":"IF(AND(M12>0, M12<10),\"\",\"Error\")","v":"Error"},null,"DH","Dynamic headspace"]
[null,"Resolution",null,null,null,null,null,null,null,"Warning","No of factors",null,null,"2-3",{"$f":"IF(OR(M13<2,M13>3),\"Error\",\"\")","v":"Error"},null,"LLE","Liquid-liquid extraction"]
[null,"Design",null,null,null,null,null,null,null,"Warning","No of center points",null,null,"0 - 4",{"$f":"IF(OR(M14<0,M14>4),\"Error\",\"\")","v":""},null,"DLL","DLLME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SBS","SBSE"]
[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,null,null,null,null,null,"HLB","SPE-HLB"]
[null,"Table 3: Design factors",null,null,null,null,null,null,null,null,"3 Factors: Resolution FF",null,null,null,null,null,"SPM","SPME"]
["Design","Factor",1,2,3,4,null,null,null,null,"4 Factors: Resolution IV",null,null,null,null,null,"MAX","SPE-MAX"]
[null,"Name"]
[null,"Unit"]
[null,"Low"]
[null,"Center 1",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,"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,"names"]
[null,"Run #",1,2,3,4,null,null,null,"A-B-C…","Replicat"]
["Corner",1,{"$f":"IF(C$22<>\"\",C$22,\"\")","v":""},{"$f":"IF(D$22<>\"\",D$22,\"\")","v":""},{"$f":"IF(E$22<>\"\",E$22,\"\")","v":""},{"$f":"IF($F$22=\"\",\"\",$F$22)","v":""},null,null,null,null,null,{"$f":"IF(J27<>\"\",CONCATENATE($M$11,TEXT(($M$12*1000+$B27)+100,\"###\"),J27),\"\")","v":""},{"$f":"IF(K27<>\"\",CONCATENATE($M$25,TEXT(($M$12*1000+$B27)+200,\"###\"),K27),\"\")","v":""},null,null,null,null,null,null,null,null,null,"Text here is only for the run in the same line"]
["points",2,{"$f":"IF(C$25<>\"\",C$25,\"\")","v":""},{"$f":"IF(D$22<>\"\",D$22,\"\")","v":""},"",{"$f":"IF($F$25=\"\",\"\",$F$25)","v":""},null,null,null,null,null,{"$f":"IF(J28<>\"\",CONCATENATE($M$11,TEXT(($M$12*1000+$B28)+100,\"###\"),J28),\"\")","v":""},""]
[null,3,{"$f":"IF(C$22<>\"\",C$22,\"\")","v":""},{"$f":"IF(D$25<>\"\",D$25,\"\")","v":""},"",{"$f":"IF($F$25=\"\",\"\",$F$25)","v":""},null,null,null,null,null,"",""]
[null,4,{"$f":"IF(C$25<>\"\",C$25,\"\")","v":""},"","",{"$f":"IF($F$22=\"\",\"\",$F$22)","v":""},null,null,null,null,null,"",""]
[null,5,{"$f":"IF(C$22<>\"\",C$22,\"\")","v":""},{"$f":"IF(D$22<>\"\",D$22,\"\")","v":""},{"$f":"IF(E$25<>\"\",E$25,\"\")","v":""},{"$f":"IF($F$25=\"\",\"\",$F$25)","v":""},null,null,null,null,null,"",""]
[null,6,{"$f":"IF(C$25<>\"\",C$25,\"\")","v":""},{"$f":"IF(D$22<>\"\",D$22,\"\")","v":""},"",{"$f":"IF($F$22=\"\",\"\",$F$22)","v":""},null,null,null,null,null,"",""]
[null,7,{"$f":"IF(C$22<>\"\",C$22,\"\")","v":""},{"$f":"IF(D$25<>\"\",D$25,\"\")","v":""},"",{"$f":"IF($F$22=\"\",\"\",$F$22)","v":""},null,null,null,null,null,"",""]
[null,8,{"$f":"IF(C$25<>\"\",C$25,\"\")","v":""},"","",{"$f":"IF($F$25=\"\",\"\",$F$25)","v":""},null,null,null,null,null,"",""]
["Center 1",9,{"$f":"IF($M$14>0,IF(C$23<>\"\",C$23,\"\"),\"\")","v":""},"","","",null,null,null,null,null,"",""]
["points",10,{"$f":"IF($M$14>1,IF(C$23<>\"\",C$23,\"\"),\"\")","v":""},"","","",null,null,null,null,null,"",""]
[null,11,{"$f":"IF($M$14>2,IF(C$23<>\"\",C$23,\"\"),\"\")","v":""},"","","",null,null,null,null,null,"",""]
[null,12,{"$f":"IF($M$14>3,IF(C$23<>\"\",C$23,\"\"),\"\")","v":""},"","","",null,null,null,null,null,"",""]
["Center 2",13,{"$f":"IF($M$14>0,IF(C$24<>\"\",C$24,\"\"),\"\")","v":""},"","","",null,null,null,null,null,"",""]
["points",14,{"$f":"IF($M$14>1,IF(C$24<>\"\",C$24,\"\"),\"\")","v":""},"","","",null,null,null,null,null,"",""]
[null,15,{"$f":"IF($M$14>2,IF(C$24<>\"\",C$24,\"\"),\"\")","v":""},"","","",null,null,null,null,null,"",""]
[null,16,{"$f":"IF($M$14>3,IF(C$24<>\"\",C$24,\"\"),\"\")","v":""},"","","",null,null,null,null,null,"",""]
["Extra",17,null,null,null,null,null,null,null,null,null,"",""]
["runs",18,null,null,null,null,null,null,null,null,null,"",""]
[null,19,null,null,null,null,null,null,null,null,null,"",""]
[null,20,null,null,null,null,null,null,null,null,null,"",""]
[null,21,null,null,null,null,null,null,null,null,null,"",""]
[null,22,null,null,null,null,null,null,null,null,null,"",""]
[null,23,null,null,null,null,null,null,null,null,null,"",""]
[null,24,null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"R8 Designs 5-7","index":1,"n_rows":50,"n_cols":23,"rows_kept":50,"cut":false,"hidden":false,"merged":[[41,13,41,21],[30,13,30,21],[31,13,31,21],[32,13,32,21],[33,13,33,21],[34,13,34,21],[35,13,35,21],[36,13,36,21],[37,13,37,21],[38,13,38,21],[39,13,39,21],[40,13,40,21],[29,13,29,21],[10,3,10,8],[11,3,11,8],[12,3,12,8],[13,3,13,8],[14,3,14,8],[15,3,15,8],[24,13,24,21],[25,13,25,21],[26,13,26,21],[27,13,27,21],[28,13,28,21],[23,13,23,21]]}
[{"$f":"'R8 Designs 3-4'!A1","v":"DOE_R8_1.0"},null,null,null,null,null,null,null,null,{"$f":"'R8 Designs 3-4'!$J$1","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,"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,"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,"Table 2: Parameters that must be valid  (Ok)"]
[null,"3) When everything is ready click on  Make run tables",null,null,null,null,null,null,null,null,"Table 3: Factors and levels "]
[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,"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,"Method must be in the list of methods"]
[]
[null,"Table 1: Informations about the design",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,{"$f":"IF(D11=\"\",\"Warning\",\"\")","v":"Warning"},"Method",null,null,"Methods",{"$f":"IF(ISNA(VLOOKUP(M11,Q11:Q19,1,FALSE)),\"Error\",\"\")","v":"Error"},null,"SH","Static headspace"]
[null,"Date",null,null,null,null,null,null,null,{"$f":"IF(D12=\"\",\"Warning\",\"\")","v":"Warning"},"Design no",null,null,"1-",{"$f":"IF(AND(M12>0, M12<10),\"\",\"Error\")","v":"Error"},null,"DH","Dynamic headspace"]
[null,"Resolution",null,null,null,null,null,null,null,"Warning","No of factors",null,null,"5.7",{"$f":"IF(OR(M13<5,M13>7),\"Error\",\"\")","v":"Error"},null,"LLE","Liquid-liquid extraction"]
[null,"Design",null,null,null,null,null,null,null,"Warning","No of center points",null,null,"0 - 4",{"$f":"IF(OR(M14<0,M14>4),\"Error\",\"\")","v":""},null,"DLL","DLLME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SBS","SBSE"]
[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,null,null,null,null,null,"HLB","SPE-HLB"]
[null,"Table 3: Design factors",null,null,null,null,null,null,null,null,"5-7 Factors: Resolution III",null,null,null,null,null,"SPM","SPME"]
["Design","Factor",1,2,3,4,5,6,7,null,null,null,null,null,null,null,"MAX","SPE-MAX"]
[null,"Name"]
[null,"Unit"]
[null,"Low"]
[null,"Center 1",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,"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,"names"]
[null,"Run #",1,2,3,4,5,6,7,"A-B-C…","Replicat"]
["Corner",1,{"$f":"IF(C$22<>\"\",C$22,\"\")","v":""},{"$f":"IF(D$22<>\"\",D$22,\"\")","v":""},{"$f":"IF(E$22<>\"\",E$22,\"\")","v":""},{"$f":"IF(F$25<>\"\",F$25,\"\")","v":""},{"$f":"IF(G$25<>\"\",G$25,\"\")","v":""},{"$f":"IF(H$22<>\"\",H$22,\"\")","v":""},{"$f":"IF(I$25<>\"\",I$25,\"\")","v":""},null,null,{"$f":"IF(J27<>\"\",CONCATENATE($M$11,TEXT(($M$12*1000+$B27)+100,\"###\"),J27),\"\")","v":""},{"$f":"IF(K27<>\"\",CONCATENATE($M$25,TEXT(($M$12*1000+$B27)+200,\"###\"),K27),\"\")","v":""}]
["points",2,{"$f":"IF(C$25<>\"\",C$25,\"\")","v":""},{"$f":"IF(D$22<>\"\",D$22,\"\")","v":""},"","",{"$f":"IF(G$22<>\"\",G$22,\"\")","v":""},{"$f":"IF(H$25<>\"\",H$25,\"\")","v":""},"",null,null,{"$f":"IF(J28<>\"\",CONCATENATE($M$11,TEXT(($M$12*1000+$B28)+100,\"###\"),J28),\"\")","v":""},""]
[null,3,{"$f":"IF(C$22<>\"\",C$22,\"\")","v":""},{"$f":"IF(D$25<>\"\",D$25,\"\")","v":""},"","",{"$f":"IF(G$25<>\"\",G$25,\"\")","v":""},"",{"$f":"IF(I$22<>\"\",I$22,\"\")","v":""},null,null,"",""]
[null,4,{"$f":"IF(C$25<>\"\",C$25,\"\")","v":""},"","",{"$f":"IF(F$25<>\"\",F$25,\"\")","v":""},{"$f":"IF(G$22<>\"\",G$22,\"\")","v":""},{"$f":"IF(H$22<>\"\",H$22,\"\")","v":""},"",null,null,"",""]
[null,5,{"$f":"IF(C$22<>\"\",C$22,\"\")","v":""},{"$f":"IF(D$22<>\"\",D$22,\"\")","v":""},{"$f":"IF(E$25<>\"\",E$25,\"\")","v":""},"","",{"$f":"IF(H$25<>\"\",H$25,\"\")","v":""},"",null,null,"",""]
[null,6,{"$f":"IF(C$25<>\"\",C$25,\"\")","v":""},{"$f":"IF(D$22<>\"\",D$22,\"\")","v":""},"",{"$f":"IF(F$22<>\"\",F$22,\"\")","v":""},{"$f":"IF(G$25<>\"\",G$25,\"\")","v":""},{"$f":"IF(H$22<>\"\",H$22,\"\")","v":""},"",null,null,"",""]
[null,7,{"$f":"IF(C$22<>\"\",C$22,\"\")","v":""},{"$f":"IF(D$25<>\"\",D$25,\"\")","v":""},"","",{"$f":"IF(G$22<>\"\",G$22,\"\")","v":""},"",{"$f":"IF(I$25<>\"\",I$25,\"\")","v":""},null,null,"",""]
[null,8,{"$f":"IF(C$25<>\"\",C$25,\"\")","v":""},"","",{"$f":"IF(F$25<>\"\",F$25,\"\")","v":""},{"$f":"IF(G$25<>\"\",G$25,\"\")","v":""},{"$f":"IF(H$25<>\"\",H$25,\"\")","v":""},"",null,null,"",""]
["Center 1",9,{"$f":"IF($M$14>0,IF(C$23<>\"\",C$23,\"\"),\"\")","v":""},"","","","","","",null,null,"",""]
["points",10,{"$f":"IF($M$14>1,IF(C$23<>\"\",C$23,\"\"),\"\")","v":""},"","","","","","",null,null,"",""]
[null,11,{"$f":"IF($M$14>2,IF(C$23<>\"\",C$23,\"\"),\"\")","v":""},"","","","","","",null,null,"",""]
[null,12,{"$f":"IF($M$14>3,IF(C$23<>\"\",C$23,\"\"),\"\")","v":""},"","","","","","",null,null,"",""]
["Center 2",13,{"$f":"IF($M$14>0,IF(C$24<>\"\",C$24,\"\"),\"\")","v":""},"","","","","","",null,null,"",""]
["points",14,{"$f":"IF($M$14>1,IF(C$24<>\"\",C$24,\"\"),\"\")","v":""},"","","","","","",null,null,"",""]
[null,15,{"$f":"IF($M$14>2,IF(C$24<>\"\",C$24,\"\"),\"\")","v":""},"","","","","","",null,null,"",""]
[null,16,{"$f":"IF($M$14>3,IF(C$24<>\"\",C$24,\"\"),\"\")","v":""},"","","","","","",null,null,"",""]
["Extra",17,null,null,null,null,null,null,null,null,null,"",""]
["runs",18,null,null,null,null,null,null,null,null,null,"",""]
[null,19,null,null,null,null,null,null,null,null,null,"",""]
[null,20,null,null,null,null,null,null,null,null,null,"",""]
[null,21,null,null,null,null,null,null,null,null,null,"",""]
[null,22,null,null,null,null,null,null,null,null,null,"",""]
[null,23,null,null,null,null,null,null,null,null,null,"",""]
[null,24,null,null,null,null,null,null,null,null,null,"",""]

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

{"sheet":"Input","index":3,"n_rows":149,"n_cols":36,"rows_kept":149,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'R8 Designs 3-4'!A1","v":"DOE_R8_1.0"},"Normalize?",null,{"$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":""},"","","","","",null,{"$f":"'R8 Designs 3-4'!$J$1","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,{"$f":"IF(G100<>\"\",G100,\"\")","v":""},null,{"$f":"IF(I100<>\"\",I100,\"\")","v":""},null,{"$f":"IF(K100<>\"\",K100,\"\")","v":""},null,{"$f":"IF(M100<>\"\",M100,\"\")","v":""},null,{"$f":"IF(O100<>\"\",O100,\"\")","v":""},null,{"$f":"IF(Q100<>\"\",Q100,\"\")","v":""},null,"","","","","","","","",{"$f":"IF(AA100<>\"\",AA100,\"\")","v":""},null,null,null,null,{"$f":"IF(AF104<>\"\",AF104,\"\")","v":""}]
["Select (1/0) ?",0,1,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,3]
[null,"Mean(area)",{"$f":"MAX(D4:Z4)","v":0},{"$f":"IF(D3>0,AVERAGE(D101:D177),\"\")","v":""},"","",{"$f":"IF(G3>0,AVERAGE(G101:G177),\"\")","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":""},"","",{"$f":"IF(G3>0,MAX(G101:G177),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","calculated variables to include in"]
[null,"Min(area)",null,{"$f":"IF(D3>0,MIN(D101:D177),\"\")","v":""},"","",{"$f":"IF(G3>0,MIN(G101:G177),\"\")","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,AVERAGE(D11:D46,D51:D86),\"\")","v":""},{"$f":"IF(E3>0,AVERAGE(E11:E46,E51:E86),\"\")","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,MIN(D11:D46,D51:D86),\"\")","v":""},{"$f":"IF(E3>0,MIN(E11:E46,E51:E86),\"\")","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":""},"","",{"$f":"IF(G100<>\"\",G100,\"\")","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(AND(G$3>0,$C101<>\"\"),IF(G$5>0,IF($C$2=1,100*G101/G$5,G101),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(C104<>\"\",MAX(D14:Z14,D54:Z54),\"\")","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(P$3>0,$C110<>\"\"),IF(P$5>0,IF($C$2=1,100*P110/P$5,P110),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":""},"","","","","","","","",{"$f":"IF(AND(M$3>0,$C116<>\"\"),IF(M$5>0,IF($C$2=1,100*M116/M$5,M116),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":""},"","","","","","","","","","","",{"$f":"IF(AND(P$3>0,$C120<>\"\"),IF(P$5>0,IF($C$2=1,100*P120/P$5,P120),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":""},{"$f":"IF(AND(E$3>0,$C136<>\"\"),IF(E$5>0,IF($C$2=1,100*E136/E$5,E136),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(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(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,{"$f":"COUNT(G101:G136,G141:G176)","v":0},0,0,0,0,0,0,0,{"$f":"COUNT(O101:O136,O141:O176)","v":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":""},"","",{"$f":"IF(G94>0,AVERAGE(G101:G136,G141:G176),\"\")","v":""},"","","","","","","",{"$f":"IF(O94>0,AVERAGE(O101:O136,O141:O176),\"\")","v":""},"","","","","","","","","","",""]
[null,"Max",null,{"$f":"IF(D94>0,MAX(D101:D136,D141:D176),\"\")","v":""},"","",{"$f":"IF(G94>0,MAX(G101:G136,G141:G176),\"\")","v":""},"","","","","","","",{"$f":"IF(O94>0,MAX(O101:O136,O141:O176),\"\")","v":""},"","","","","","","","","","",""]
[null,"Min",null,{"$f":"IF(D94>0,MIN(D101:D136,D141:D176),\"\")","v":""},"","",{"$f":"IF(G94>0,MIN(G101:G136,G141:G176),\"\")","v":""},"","","","","","","",{"$f":"IF(O94>0,MIN(O101:O136,O141:O176),\"\")","v":""},"","","","","","","","","","",""]
[]
["Input 1st runs",null,"Label"]
[null,"Mean"]
["Labels in first",{"$f":"IF(C101<>\"\",AVERAGE(D101:Z101,M141:Z141),\"\")","v":""}]
["column",""]
[null,""]
["Analyte names ",""]
["in first row",""]
[null,""]
["Data first cell:",""]
["D101",""]
[null,""]
[null,{"$f":"IF(C110<>\"\",AVERAGE(D110:Z110,D150:Z150),\"\")","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(C115<>\"\",AVERAGE(D115:Z115,D155:Z155),\"\")","v":""}]
[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":"R8 3 factors FF","index":4,"n_rows":87,"n_cols":37,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'R8 Designs 3-4'!A1","v":"DOE_R8_1.0"},null,null,null,"2^3","Full factor design",null,"No confounding",null,"3 main effects",null,"4 interactions",null,null,null,null,null,null,null,null,null,{"$f":"'R8 Designs 3-4'!$J$1","v":"Author: Bo Svensmark, svensmark@plen.ku.dk, Analytical Chemistry, PLEN, 2015 - 2025"}]
[]
[null,"1) Enter parameters in sheet R8 Designs 3-4",null,null,null,null,"(Input in white cells only)",null,null,null,"This design is for 3 main effects and all interactions",null,null,null,null,{"$f":"IF('R8 Designs 3-4'!M13=3,3,0)","v":0},null,"No confounding",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,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,"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,"Only one replicate is needed.",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,"With only one replicate and less than 2 centerpoints",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,"no statistics is possible, but the effects will be calculated"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All cells not intended for user input are locked. To unlock go to Review and click Unprotect Sheet"]
["Design","Factor",1,2,3,"No of center points:",null,{"$f":"'R8 Designs 3-4'!M14","v":0},null,{"$f":"IF(O16=\"No\",\"Results are NOT saved\",\"Results are saved in sheet Output\")","v":"Results are saved in sheet Output"},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"]
[null,"Name",{"$f":"IF($P$3=3,'R8 Designs 3-4'!C20,\"\")","v":""},{"$f":"IF($P$3=3,'R8 Designs 3-4'!D20,\"\")","v":""},{"$f":"IF($P$3=3,'R8 Designs 3-4'!E20,\"\")","v":""}]
[null,"Unit",{"$f":"IF($P$3=3,'R8 Designs 3-4'!C21,\"\")","v":""},{"$f":"IF($P$3=3,'R8 Designs 3-4'!D21,\"\")","v":""},{"$f":"IF($P$3=3,'R8 Designs 3-4'!E21,\"\")","v":""},null,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,"Low",{"$f":"IF($P$3=3,'R8 Designs 3-4'!C22,\"\")","v":""},{"$f":"IF($P$3=3,'R8 Designs 3-4'!D22,\"\")","v":""},{"$f":"IF($P$3=3,'R8 Designs 3-4'!E22,\"\")","v":""},null,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,"Center 1",{"$f":"IF($P$3<>3,\"\",IF('R8 Designs 3-4'!C23=\"\",\"\",'R8 Designs 3-4'!C23))","v":""},{"$f":"IF($P$3<>3,\"\",IF('R8 Designs 3-4'!D23=\"\",\"\",'R8 Designs 3-4'!D23))","v":""},{"$f":"IF($P$3<>3,\"\",IF('R8 Designs 3-4'!E23=\"\",\"\",'R8 Designs 3-4'!E23))","v":""},"Analyte:",null,null,null,null,"Rel. Area =",null,null,{"$f":"IF(ABS(SUM(C39:C45)-SUM(W35:W41))>0.000000000001,\"Please update sheet\",\"\")","v":""},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 2",{"$f":"IF($P$3<>3,\"\",IF('R8 Designs 3-4'!C24=\"\",\"\",'R8 Designs 3-4'!C24))","v":""},{"$f":"IF($P$3<>3,\"\",IF('R8 Designs 3-4'!D24=\"\",\"\",'R8 Designs 3-4'!D24))","v":""},{"$f":"IF($P$3<>3,\"\",IF('R8 Designs 3-4'!E24=\"\",\"\",'R8 Designs 3-4'!E24))","v":""},"Comm:"]
[null,"High",{"$f":"IF($P$3=3,'R8 Designs 3-4'!C25,\"\")","v":""},{"$f":"IF($P$3=3,'R8 Designs 3-4'!D25,\"\")","v":""},{"$f":"IF($P$3=3,'R8 Designs 3-4'!E25,\"\")","v":""},"Results","Replicates",null,null,null,null,"Yes",null,"Saved?","Yes",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,"Run",1,2,3,1,2,3,4,"Mean","Stdev","d.f.",null,"Index out",1,null,null,null,null,null,null,null,"For your purpose, even statistically insignificant effects may be important"]
["Corner",1,{"$f":"$C$13","v":""},{"$f":"$D$13","v":""},{"$f":"$E$13","v":""},null,null,null,null,{"$f":"IF(F18<>\"\",AVERAGE(F18:I18),0)","v":0},{"$f":"IF(L18>0,STDEV(F18:I18),0)","v":0},{"$f":"IF(F18<>\"\",COUNT(F18:I18)-1,0)","v":0},null,null,null,null,null,null,null,null,null,null,"You suspect that the experimentally determined uncertainty is wrong"]
["points",2,{"$f":"$C$16","v":""},{"$f":"$D$13","v":""},{"$f":"$E$13","v":""},null,null,null,null,0,{"$f":"IF(L19>0,STDEV(F19:I19),0)","v":0},{"$f":"IF(F19<>\"\",COUNT(F19:I19)-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,6,{"$f":"$C$16","v":""},{"$f":"$D$13","v":""},{"$f":"$E$16","v":""},null,null,null,null,0,0,0]
[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]
["Center 1",9,{"$f":"IF(C$14=\"\",\"\",IF($B26<$H$10+9,C$14,\"\"))","v":""},{"$f":"IF(D$14=\"\",\"\",IF($B26<$H$10+9,D$14,\"\"))","v":""},"",null,null,null,null,{"$f":"IF(F26<>\"\",AVERAGE(F26:G29),0)","v":0},{"$f":"IF(L26>0,STDEV(F26:G29),0)","v":0},{"$f":"IF(F26<>\"\",COUNT(F26:G29)-1,0)","v":0},"All center points"]
["points",10,{"$f":"IF(C$14=\"\",\"\",IF($B27<$H$10+9,C$14,\"\"))","v":""},"","",null,null,null,null,null,null,null,"Mean","d.f"]
[null,11,"","","",null,null,null,null,null,null,null,{"$f":"IF(F26<>\"\",AVERAGE(F26:G33),\"\")","v":""},{"$f":"L26+L30","v":0}]
[null,12,"","","",null,null,null,null,null,null,null,null,null,null,"Blue points:  not significant effects"]
["Center 2",13,{"$f":"IF(C$15=\"\",\"\",IF($B30<$H$10+13,C$15,\"\"))","v":""},{"$f":"IF(D$15=\"\",\"\",IF($B30<$H$10+13,D$15,\"\"))","v":""},"",null,null,null,null,{"$f":"IF(F30<>\"\",AVERAGE(F30:G33),0)","v":0},{"$f":"IF(L30>0,STDEV(F30:G33),0)","v":0},{"$f":"IF(F30<>\"\",COUNT(F30:G33)-1,0)","v":0},{"$f":"IF(N31>0,\"Statistics\",\"No statistics\")","v":"No statistics"},null,null,"Red points:   significant effects"]
["points",14,{"$f":"IF(C$15=\"\",\"\",IF($B31<$H$10+13,C$15,\"\"))","v":""},"","",null,null,null,null,null,null,null,"d.f.",{"$f":"SUM(L18:L30)","v":0},null,"Green lines: If <>0: 95 % confidence interval"]
[null,15,"","","",null,null,null,null,null,null,null,"s(pool)",{"$f":"IF(N31>0,SQRT(SUM(K18:K30^2*L18:L30)/N31),\"\")","v":""},null,"Blue line:    True noise factors should be on  this line"]
[null,16,"","","",null,null,null,null,null,null,null,"s(effect)",{"$f":"IF(N31>0,2*N32/SQRT(COUNT(F18:I25)),\"\")","v":""}]
[null,null,null,null,null,null,null,"Extra runs",null,null,null,null,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(N33<>\"\",N31,999)","v":999}]
[null,"Enter manual Limit:",null,null,null,"95% Confidence interval for an effect, CI:",null,null,null,{"$f":"AK35","v":0},{"$f":"IF(D35<>\"\",\"Set manually\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,1,0,1,0,null,1,{"$f":"(AA35-0.375)/($W$42+0.25)","v":8.6206896551724144E-2},{"$f":"NORMSINV(AB35)","v":-1.3644887481703289},{"$f":"IF($AK$35<>\"\",IF(X35>=0.05,W35,\"\"),W35)","v":0},null,"line",null,null,null,"CI +/-",{"$f":"IF(D35>0,D35,IF(N33<>\"\",N33*TINV(0.05,AK34),0))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(N33<>\"\",N33*TINV(0.05,N31),\"na\")","v":"na"},null,null,null,null,null,null,null,null,null,null,null,2,0,1,0,null,2,0.22413793103448276,-0.75829255699115117,{"$f":"IF($AK$35<>\"\",IF(X36>=0.05,W36,\"\"),W36)","v":0},null,null,"Slope",{"$f":"1/AK36","v":{"$error":"#DIV/0!"}},null,"s(effect)",{"$f":"AK35/TINV(0.05,AK34)","v":0}]
["Effects","Term","Effect","Coeff","P","Sign?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0,1,0,null,3,0.36206896551724138,-0.35293398612691645,0,null,null,"X","Y","CI lines","X","Y"]
[null,"Mean",{"$f":"M68/8","v":0},{"$f":"C38","v":0},{"$f":"IF(AK35>0,TDIST(2*ABS(C38)/$AK$36,$AK$34,2),1)","v":1},{"$f":"IF(D$35=\"\",IF(E38<0.001,\"***\",IF(E38<0.01,\"**\",IF(E38<0.05,\"*\",\"\"))),IF(E38<0.001,\"+++\",IF(E38<0.01,\"++\",IF(E38<0.05,\"+\",\"\"))))","v":""},null,"Effectes sorted from low to high",null,null,null,null,null,null,null,null,null,null,null,null,null,12,0,1,0,null,4,0.5,0,0,null,"Low",{"$f":"AH38/$AH$36","v":{"$error":"#DIV/0!"}},{"$f":"MIN(AC35:AC41)","v":-1.3644887481703289},"SV",{"$f":"-AK35","v":0},{"$f":"MIN(AC35:AC41)","v":-1.3644887481703289}]
[null,1,{"$f":"M69/4","v":0},{"$f":"C39/2","v":0},{"$f":"IF($AK$35>0,TDIST(ABS(C39)/$AK$36,$AK$34,2),1)","v":1},{"$f":"IF(D$35=\"\",IF(E39<0.001,\"***\",IF(E39<0.01,\"**\",IF(E39<0.05,\"*\",\"\"))),IF(E39<0.001,\"+++\",IF(E39<0.01,\"++\",IF(E39<0.05,\"+\",\"\"))))","v":""},null,{"$f":"V34","v":"Terms"},{"$f":"W34","v":"Effect"},{"$f":"Y34","v":"Noise"},null,null,null,null,null,null,null,null,null,null,null,13,0,1,0,null,5,0.63793103448275867,0.35293398612691662,0,null,"High",{"$f":"AH39/$AH$36","v":{"$error":"#DIV/0!"}},{"$f":"MAX(AC35:AC41)","v":1.3644887481703283},"NV",{"$f":"-AK35","v":0},{"$f":"MAX(AC35:AC41)","v":1.3644887481703283}]
[null,2,0,{"$f":"C40/2","v":0},1,"",null,{"$f":"V35","v":1},{"$f":"IF(Y35<>\"\",\"\",W35)","v":""},{"$f":"IF(Y35<>\"\",Y35,\"\")","v":0},null,null,null,null,null,null,null,null,null,null,null,23,0,1,0,null,6,0.77586206896551724,0.75829255699115117,0,null,null,null,null,"SE",{"$f":"AK35","v":0},{"$f":"MIN(AC35:AC41)","v":-1.3644887481703289}]
[null,3,0,0,1,"",null,2,"",0,null,null,null,null,null,null,null,null,null,null,null,123,0,1,0,null,7,0.91379310344827591,1.3644887481703283,0,null,"s(pool)",{"$f":"AK36*SQRT(COUNT(F18:I25))/2","v":0},null,"NE",{"$f":"AK35","v":0},{"$f":"MAX(AC35:AC41)","v":1.3644887481703283}]
[null,12,0,0,1,"",null,3,"",0,null,null,null,null,null,null,null,null,null,null,null,"N =",{"$f":"COUNT(W35:W41)","v":7},"d.f.",{"$f":"COUNT(Y35:Y41)","v":7}]
[null,13,0,0,1,"",null,12,"",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"s(Noise)",{"$f":"SQRT(SUM(Y35:Y41^2)/COUNT(Y35:Y41))","v":0}]
[null,23,0,0,1,"",null,13,"",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"CI(noise)",{"$f":"Y43*TINV(0.05,Y42)","v":0}]
[null,123,0,0,1,"",null,23,"",0]
[null,"Center p",{"$f":"IF(F26<>\"\",M28-C38,\"\")","v":""},{"$f":"C46","v":""},{"$f":"IF(C46<>\"\",IF(AK35>0,TDIST(ABS(C46)/(AG41*SQRT(1/(N28+1)+1/(COUNT(F18:I25)))),AK34,2),1),\"\")","v":""},"",null,123,"",0]
[null,"Manual","P<0.05","+","P<0.05","*",null,null,"CI(Noise)",{"$f":"IF(Y42>0,Y44,\"\")","v":0}]
[null,"limit","P<0.01","++","P<0.01","**"]
[null,"<> blank:","P<0.001","+++","P<0.001","***"]
[null,null,"If no s(effect) all  P=1",null,"If no s(effect) all  P=1"]
[]
[null,"Model 1",null,null,null,null,"Model 2"]
[null,{"$f":"B37","v":"Term"},"X","Coeff","Value",null,{"$f":"B37","v":"Term"},"X","Coeff","Value",null,"Predict the respons and optimize"]
[null,"Mean",1,{"$f":"D38","v":0},{"$f":"C54*D54","v":0},null,"Mean",1,{"$f":"D38","v":0},{"$f":"H54*I54","v":0},null,"Model:"]
[null,1,1,0,{"$f":"C55*D55","v":0},null,1,0,0,{"$f":"H55*I55","v":0},null,"Y = C(Mean) + X1*C1 + X2*C2 + X3*C3 + X1*X2*C12 + X1*X3*C13 + X2*X3*C23 + X1*X2*X3*C123"]
[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,12,{"$f":"C55*C56","v":1},0,0,null,12,0,0,{"$f":"IF(H58<>0,I58*H$55*H$56,0)","v":0}]
[null,13,{"$f":"C55*C57","v":1},0,0,null,13,0,0,{"$f":"IF(H59<>0,I59*H$55*H$57,0)","v":0},null,"Model 1: Interactions are calculated automatically"]
[null,23,{"$f":"C56*C57","v":1},0,0,null,23,0,0,{"$f":"IF(H60<>0,I60*H$56*H$57,0)","v":0},null,"Model 2: X <> 0 include interaction, X = 0 exclude interaction"]
[null,123,{"$f":"C55*C56*C57","v":1},0,0,null,123,0,0,{"$f":"IF(H61<>0,I61*H$55*H$56*H$57,0)","v":0}]
[null,"Y",null,null,{"$f":"SUM(E54:E61)","v":0},null,"Y",null,null,{"$f":"SUM(J54:J61)","v":0}]
[]
[null,{"$f":"B46","v":"Center p"},null,null,{"$f":"IF(D46<>\"\",D38+D46,\"\")","v":""},null,{"$f":"B46","v":"Center p"},null,null,{"$f":"IF(D46<>\"\",D38+D46,\"\")","v":""}]
[]
[]
["Design matrix",null,"2^3",null,"Factor",null,null,null,null,null,null,null,"Mmult"]
[null,null,"Run","M",1,2,3,12,13,23,123,null,{"$f":"MMULT($D$80:$K$87,$J$18:$J$25)","v":0}]
[null,null,1,1,-1,-1,-1,{"$f":"E69*F69","v":1},{"$f":"E69*G69","v":1},{"$f":"F69*G69","v":1},{"$f":"E69*F69*G69","v":-1},null,0]
[null,null,2,1,1,-1,-1,{"$f":"E70*F70","v":-1},{"$f":"E70*G70","v":-1},{"$f":"F70*G70","v":1},{"$f":"E70*F70*G70","v":1},null,0]
[null,null,3,1,-1,1,-1,-1,1,-1,1,null,0]
[null,null,4,1,1,1,-1,1,-1,-1,-1,null,0]
[null,null,5,1,-1,-1,1,1,-1,-1,1,null,0]
[null,null,6,1,1,-1,1,-1,1,-1,-1,null,0]
[null,null,7,1,-1,1,1,-1,-1,1,-1,null,0]
[null,null,8,1,1,1,1,1,1,1,1]
[]
["Matrix",null,null,"Transposed design matrix"]
[null,null,"Run",1,2,3,4,5,6,7,8]
[null,null,"M",1,1,1,1,1,1,1,1]
[null,null,1,-1,1,-1,1,-1,1,-1,1]
[null,null,2,-1,-1,1,1,-1,-1,1,1]
[null,null,3,-1,-1,-1,-1,1,1,1,1]
[null,null,12,{"$f":"D81*D82","v":1},-1,-1,1,1,-1,-1,1]
[null,null,13,{"$f":"D81*D83","v":1},-1,1,-1,-1,1,-1,1]
[null,null,23,{"$f":"D82*D83","v":1},1,-1,-1,-1,-1,1,1]
[null,null,123,{"$f":"D81*D82*D83","v":-1},1,1,-1,1,-1,-1,1]

{"sheet":"R8 4 factors IV)","index":5,"n_rows":88,"n_cols":37,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'R8 Designs 3-4'!A1","v":"DOE_R8_1.0"},null,null,null,"2^(4-1)","Half fraction design",null,"Resolution IV",null,"3 main effects",null,"Main effects confounded with 3-factor interactions",null,null,null,null,null,null,null,null,null,{"$f":"'R8 Designs 3-4'!$J$1","v":"Author: Bo Svensmark, svensmark@plen.ku.dk, Analytical Chemistry, PLEN, 2015 - 2025"}]
[]
[null,"1) Enter parameters in sheet R8 Designs 3-4",null,null,null,null,"(Input in white cells only)",null,null,null,"This design is for 4 main effects and some interactions",null,null,null,null,{"$f":"IF('R8 Designs 3-4'!M13=4,4,0)","v":0},null,"Confounding:",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,null,null,null,null,null,null,"Mean = 1234",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,"Centerpoints may be omitted.",null,null,null,null,null,null,"1 = 234",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,"Only one replicate is needed.",null,null,null,null,null,null,"2 = 134",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,"With only one replicate and less than 2 centerpoints",null,null,null,null,null,null,"3 = 124",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,"no statistics is possible, but the effects will be calculated",null,null,null,null,null,null,"4 = 123"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12 = 34",null,null,null,"All cells not intended for user input are locked. To unlock go to Review and click Unprotect Sheet"]
["Design","Factor",1,2,3,4,"No of center points:",null,{"$f":"'R8 Designs 3-4'!M14","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,null,null,null,null,null,"13 = 24",null,null,null,"Most cells are shown with 2 significant digits. You may want to cange that for small values"]
[null,"Name",{"$f":"IF($P$3=4,'R8 Designs 3-4'!C20,\"\")","v":""},{"$f":"IF($P$3=4,'R8 Designs 3-4'!D20,\"\")","v":""},{"$f":"IF($P$3=4,'R8 Designs 3-4'!E20,\"\")","v":""},{"$f":"IF($P$3=4,'R8 Designs 3-4'!F20,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"23 = 14"]
[null,"Unit",{"$f":"IF($P$3=4,'R8 Designs 3-4'!C21,\"\")","v":""},{"$f":"IF($P$3=4,'R8 Designs 3-4'!D21,\"\")","v":""},{"$f":"IF($P$3=4,'R8 Designs 3-4'!E21,\"\")","v":""},{"$f":"IF($P$3=4,'R8 Designs 3-4'!F21,\"\")","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,"Low",{"$f":"IF($P$3=4,'R8 Designs 3-4'!C22,\"\")","v":""},{"$f":"IF($P$3=4,'R8 Designs 3-4'!D22,\"\")","v":""},{"$f":"IF($P$3=4,'R8 Designs 3-4'!E22,\"\")","v":""},{"$f":"IF($P$3=4,'R8 Designs 3-4'!F22,\"\")","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,"Center 1",{"$f":"IF($P$3<>4,\"\",IF('R8 Designs 3-4'!C23=\"\",\"\",'R8 Designs 3-4'!C23))","v":""},{"$f":"IF($P$3<>4,\"\",IF('R8 Designs 3-4'!D23=\"\",\"\",'R8 Designs 3-4'!D23))","v":""},{"$f":"IF($P$3<>4,\"\",IF('R8 Designs 3-4'!E23=\"\",\"\",'R8 Designs 3-4'!E23))","v":""},{"$f":"IF($P$3<>4,\"\",IF('R8 Designs 3-4'!F23=\"\",\"\",'R8 Designs 3-4'!F23))","v":""},"Analyte:",null,null,null,null,"Rel. Area =",null,null,{"$f":"IF(ABS(SUM(C39:C45)-SUM(W35:W41))>0.000000000001,\"Please update sheet\",\"\")","v":""},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 2",{"$f":"IF($P$3<>4,\"\",IF('R8 Designs 3-4'!C24=\"\",\"\",'R8 Designs 3-4'!C24))","v":""},{"$f":"IF($P$3<>4,\"\",IF('R8 Designs 3-4'!D24=\"\",\"\",'R8 Designs 3-4'!D24))","v":""},{"$f":"IF($P$3<>4,\"\",IF('R8 Designs 3-4'!E24=\"\",\"\",'R8 Designs 3-4'!E24))","v":""},{"$f":"IF($P$3<>4,\"\",IF('R8 Designs 3-4'!F24=\"\",\"\",'R8 Designs 3-4'!F24))","v":""},"Comm:"]
[null,"High",{"$f":"IF($P$3=4,'R8 Designs 3-4'!C25,\"\")","v":""},{"$f":"IF($P$3=4,'R8 Designs 3-4'!D25,\"\")","v":""},{"$f":"IF($P$3=4,'R8 Designs 3-4'!E25,\"\")","v":""},{"$f":"IF($P$3=4,'R8 Designs 3-4'!F25,\"\")","v":""},"Results","Replicates",null,null,null,null,null,null,"Saved?","Yes",null,null,null,null,null,"Even if you have an experimental determined statistical CI, you may want to play with the CI because:"]
[null,"Run",1,2,3,4,1,2,3,4,"Mean","Stdev","d.f.",null,"Index out",1,null,null,null,null,null,null,"For your purpose, even statistically insignificant effects may be important"]
["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,STDEV(G18:J18),0)","v":0},{"$f":"IF(G18<>\"\",COUNT(G18:J18)-1,0)","v":0},null,null,null,null,null,null,null,null,null,"You suspect that the experimentally determined uncertainty is wrong"]
["points",2,{"$f":"$C$16","v":""},{"$f":"$D$13","v":""},{"$f":"$E$13","v":""},{"$f":"$F$16","v":""},null,null,null,null,0,{"$f":"IF(M19>0,STDEV(G19:J19),0)","v":0},{"$f":"IF(G19<>\"\",COUNT(G19:J19)-1,0)","v":0},null,"Generator:"]
[null,3,{"$f":"$C$13","v":""},{"$f":"$D$16","v":""},{"$f":"$E$13","v":""},{"$f":"$F$16","v":""},null,null,null,null,0,0,0,null,"4 = 123"]
[null,4,{"$f":"$C$16","v":""},{"$f":"$D$16","v":""},{"$f":"$E$13","v":""},{"$f":"$F$13","v":""},null,null,null,null,0,0,0]
[null,5,{"$f":"$C$13","v":""},{"$f":"$D$13","v":""},{"$f":"$E$16","v":""},{"$f":"$F$16","v":""},null,null,null,null,0,0,0]
[null,6,{"$f":"$C$16","v":""},{"$f":"$D$13","v":""},{"$f":"$E$16","v":""},{"$f":"$F$13","v":""},null,null,null,null,0,0,0]
[null,7,{"$f":"$C$13","v":""},{"$f":"$D$16","v":""},{"$f":"$E$16","v":""},{"$f":"$F$13","v":""},null,null,null,null,0,0,0]
[null,8,{"$f":"$C$16","v":""},{"$f":"$D$16","v":""},{"$f":"$E$16","v":""},{"$f":"$F$16","v":""},null,null,null,null,0,0,0]
["Center 1 ",9,{"$f":"IF(C$14=\"\",\"\",IF($B26<$I$10+9,C$14,\"\"))","v":""},{"$f":"IF(D$14=\"\",\"\",IF($B26<$I$10+9,D$14,\"\"))","v":""},"","",null,null,null,null,{"$f":"IF(G26<>\"\",AVERAGE(G26:H29),0)","v":0},{"$f":"IF(M26>0,STDEV(G26:H29),0)","v":0},{"$f":"IF(G26<>\"\",COUNT(G26:H29)-1,0)","v":0},"All center points"]
["points",10,{"$f":"IF(C$14=\"\",\"\",IF($B27<$I$10+9,C$14,\"\"))","v":""},"","","",null,null,null,null,null,null,null,"Mean","d.f"]
[null,11,"","","","",null,null,null,null,null,null,null,{"$f":"IF(G26<>\"\",AVERAGE(G26:H33),\"\")","v":""},{"$f":"M26+M30","v":0}]
[null,12,"","","",""]
["Center 2 ",13,{"$f":"IF(C$15=\"\",\"\",IF($B30<$I$10+13,C$15,\"\"))","v":""},{"$f":"IF(D$15=\"\",\"\",IF($B30<$I$10+13,D$15,\"\"))","v":""},"","",null,null,null,null,{"$f":"IF(G30<>\"\",AVERAGE(G30:H33),0)","v":0},{"$f":"IF(M30>0,STDEV(G30:H33),0)","v":0},{"$f":"IF(G30<>\"\",COUNT(G30:H33)-1,0)","v":0},{"$f":"IF(O31>0,\"Statistics\",\"No statistics\")","v":"No statistics"}]
["points",14,{"$f":"IF(C$15=\"\",\"\",IF($B31<$I$10+13,C$15,\"\"))","v":""},"","","",null,null,null,null,null,null,null,"d.f.",{"$f":"SUM(M18:M30)","v":0}]
[null,15,"","","","",null,null,null,null,null,null,null,"s(pool)",{"$f":"IF(O31>0,SQRT(SUM(L18:L30^2*M18:M30)/O31),\"\")","v":""}]
[null,16,"","","","",null,null,null,null,null,null,null,"s(effect)",{"$f":"IF(O31>0,2*O32/SQRT(COUNT(G18:J25)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Extra runs",null,null,null,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(O33<>\"\",O31,999)","v":999}]
[null,"Enter manual Limit:",null,null,null,"95% Confidence interval for an effect, CI:",null,null,null,{"$f":"AK35","v":0},{"$f":"IF(D35<>\"\",\"Set manually\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,1,0,1,0,null,1,{"$f":"(AA35-0.375)/($W$42+0.25)","v":8.6206896551724144E-2},{"$f":"NORMSINV(AB35)","v":-1.3644887481703289},{"$f":"IF($AK$35<>\"\",IF(X35>=0.05,W35,\"\"),W35)","v":0},null,"line",null,null,null,"CI +/-",{"$f":"IF(D35>0,D35,IF(O33<>\"\",O33*TINV(0.05,AK34),0))","v":0}]
[null,null,null,null,null,null,null,null,"CI(exp) =",{"$f":"IF(O33<>\"\",O33*TINV(0.05,O31),\"na\")","v":"na"},null,null,null,null,null,null,null,null,null,null,null,2,0,1,0,null,2,0.22413793103448276,-0.75829255699115117,{"$f":"IF($AK$35<>\"\",IF(X36>=0.05,W36,\"\"),W36)","v":0},null,null,"Slope",{"$f":"1/AK36","v":{"$error":"#DIV/0!"}},null,"s(effect)",{"$f":"AK35/TINV(0.05,AK34)","v":0}]
["Effects","Term","Effect","Coeff","P","Sign?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0,1,0,null,3,0.36206896551724138,-0.35293398612691645,0,null,null,"X","Y","CI lines","X","Y"]
[null,"Mean",{"$f":"M69/8","v":0},{"$f":"C38","v":0},{"$f":"IF(AK35>0,TDIST(2*ABS(C38)/$AK$36,$AK$34,2),1)","v":1},{"$f":"IF(D$35=\"\",IF(E38<0.001,\"***\",IF(E38<0.01,\"**\",IF(E38<0.05,\"*\",\"\"))),IF(E38<0.001,\"+++\",IF(E38<0.01,\"++\",IF(E38<0.05,\"+\",\"\"))))","v":""},null,"Effectes sorted from low to high",null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,1,0,null,4,0.5,0,0,null,"Low",{"$f":"AH38/$AH$36","v":{"$error":"#DIV/0!"}},{"$f":"MIN(AC35:AC41)","v":-1.3644887481703289},"SV",{"$f":"-AK35","v":0},{"$f":"MIN(AC35:AC41)","v":-1.3644887481703289}]
[null,1,{"$f":"M70/4","v":0},{"$f":"C39/2","v":0},{"$f":"IF($AK$35>0,TDIST(ABS(C39)/$AK$36,$AK$34,2),1)","v":1},{"$f":"IF(E39<0.001,\"***\",IF(E39<0.01,\"**\",IF(E39<0.05,\"*\",\"\")))","v":""},null,{"$f":"V34","v":"Terms"},{"$f":"W34","v":"Effect"},{"$f":"Y34","v":"Noise"},null,null,null,null,null,null,null,null,null,null,null,"12+34",0,1,0,null,5,0.63793103448275867,0.35293398612691662,0,null,"High",{"$f":"AH39/$AH$36","v":{"$error":"#DIV/0!"}},{"$f":"MAX(AC35:AC41)","v":1.3644887481703283},"NV",{"$f":"-AK35","v":0},{"$f":"MAX(AC35:AC41)","v":1.3644887481703283}]
[null,2,0,{"$f":"C40/2","v":0},1,"",null,{"$f":"V35","v":1},{"$f":"IF(Y35<>\"\",\"\",W35)","v":""},{"$f":"IF(Y35<>\"\",Y35,\"\")","v":0},null,null,null,null,null,null,null,null,null,null,null,"13+24",0,1,0,null,6,0.77586206896551724,0.75829255699115117,0,null,null,null,null,"SE",{"$f":"AK35","v":0},{"$f":"MIN(AC35:AC41)","v":-1.3644887481703289}]
[null,3,0,0,1,"",null,2,"",0,null,null,null,null,null,null,null,null,null,null,null,"23+14",0,1,0,null,7,0.91379310344827591,1.3644887481703283,0,null,"s(pool)",{"$f":"AK36*SQRT(COUNT(G18:J25))/2","v":0},null,"NE",{"$f":"AK35","v":0},{"$f":"MAX(AC35:AC41)","v":1.3644887481703283}]
[null,4,0,0,1,"",null,3,"",0,null,null,null,null,null,null,null,null,null,null,null,"N =",{"$f":"COUNT(W35:W41)","v":7},"d.f.",{"$f":"COUNT(Y35:Y41)","v":7}]
[null,"12+34",0,0,1,"",null,4,"",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"s(Noise)",{"$f":"SQRT(SUM(Y35:Y41^2)/COUNT(Y35:Y41))","v":0}]
[null,"13+24",0,0,1,"",null,"12+34","",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"CI(noise)",{"$f":"Y43*TINV(0.05,Y42)","v":0}]
[null,"23+14",0,0,1,"",null,"13+24","",0]
[null,"Center  p",{"$f":"IF(G26<>\"\",N28-C38,\"\")","v":""},{"$f":"C46","v":""},{"$f":"IF(C46<>\"\",IF(AK35>0,TDIST(ABS(C46)/(AG41*SQRT(1/(O28+1)+1/(COUNT(G18:J25)))),AK34,2),1),\"\")","v":""},"",null,"23+14","",0]
[null,"Manual","P<0.05","+","P<0.05","*",null,null,"CI(Noise)",{"$f":"IF(Y42>0,Y44,\"\")","v":0}]
[null,"limit","P<0.01","++","P<0.01","**"]
[null,"<> blank:","P<0.001","+++","P<0.001","***"]
[null,null,"If no s(effect) all  P=1",null,"If no s(effect) all  P=1"]
[]
[null,"Model 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blue points:  not significant effects"]
[null,{"$f":"B37","v":"Term"},"X","Coeff","Value",null,"Predict and optimize  the respons",null,null,null,null,null,null,null,null,null,null,"Red points:   significant effects"]
[null,"Mean",1,{"$f":"D38","v":0},{"$f":"C54*D54","v":0},null,"Model:",null,null,null,null,null,null,null,null,null,null,"Green lines: If <>0: 95 % confidence interval"]
[null,1,1,0,{"$f":"C55*D55","v":0},null,"Y = C(Mean) + X1*C1 + X2*C2 + X3*C3 + X4*C4 +(interactions)",null,null,null,null,null,null,null,null,null,null,"Blue line:    True noise factors should be on  this line"]
[null,2,1,0,0,null,"X = -1, 0 , 1 or -1 to 1 (coded values)"]
[null,3,1,0,0,null,"C = Coefficients"]
[null,4,1,0,0]
[null,"12+34",1,0,{"$f":"C59*D59","v":0},null,"Interactions are almost impossible to estimate when X for main factors are different"]
[null,"13+24",1,0,0]
[null,"23+14",1,0,0,null,"If the two interactions do not have the same sign, a value between -1.0 and 1.0 could be used"]
[null,"Y",null,null,{"$f":"SUM(E54:E61)","v":0},null,"but this it will be completely subjective"]
[]
[null,{"$f":"B46","v":"Center  p"},null,null,{"$f":"IF(D46<>\"\",D38+D46,\"\")","v":""},null,"Use the model with care, mainly to exclude non-significant effects"]
[]
[]
[]
["Design matrix",null,"2^3",null,"Factor",null,null,null,null,null,null,null,"Mmult"]
[null,null,"Run","Mean",1,2,3,4,"12+34","13+24","23+14",null,{"$f":"MMULT($D$81:$K$88,$K$18:$K$25)","v":0}]
[null,null,1,1,-1,-1,-1,{"$f":"E70*F70*G70","v":-1},{"$f":"E70*F70","v":1},{"$f":"E70*G70","v":1},{"$f":"F70*G70","v":1},null,0]
[null,null,2,1,1,-1,-1,{"$f":"E71*F71*G71","v":1},{"$f":"E71*F71","v":-1},{"$f":"E71*G71","v":-1},{"$f":"F71*G71","v":1},null,0]
[null,null,3,1,-1,1,-1,1,-1,1,-1,null,0]
[null,null,4,1,1,1,-1,-1,1,-1,-1,null,0]
[null,null,5,1,-1,-1,1,1,1,-1,-1,null,0]
[null,null,6,1,1,-1,1,-1,-1,1,-1,null,0]
[null,null,7,1,-1,1,1,-1,-1,-1,1,null,0]
[null,null,8,1,1,1,1,1,1,1,1]
[]
["Matrix",null,null,"Transposed design matrix"]
[null,null,"Run",1,2,3,4,5,6,7,8]
[null,null,"Mean",1,1,1,1,1,1,1,1]
[null,null,1,-1,1,-1,1,-1,1,-1,1]
[null,null,2,-1,-1,1,1,-1,-1,1,1]
[null,null,3,-1,-1,-1,-1,1,1,1,1]
[null,null,4,{"$f":"D82*D83*D84","v":-1},1,1,-1,1,-1,-1,1]
[null,null,"12+34",{"$f":"D82*D83","v":1},-1,-1,1,1,-1,-1,1]
[null,null,"13+24",{"$f":"D82*D84","v":1},-1,1,-1,-1,1,-1,1]
[null,null,"23+14",{"$f":"D83*D84","v":1},1,-1,-1,-1,-1,1,1]

{"sheet":"R8 5-7 factors III","index":6,"n_rows":88,"n_cols":37,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'R8 Designs 3-4'!A1","v":"DOE_R8_1.0"},null,null,null,"2^(F#-X)","X fraction design",null,"Screening res III",null,"5-7main effects",null,"Main effects confounded with 2-factor interactions",null,null,null,null,null,null,null,null,null,{"$f":"'R8 Designs 3-4'!$J$1","v":"Author: Bo Svensmark, svensmark@plen.ku.dk, Analytical Chemistry, PLEN, 2015 - 2025"}]
[]
[null,"1) Enter parameters in sheet R8 Designs 5-7",null,null,null,null,"(Input in white cells only)",null,null,null,"This design may be used with 5, 6 or 7 factors",null,null,null,null,{"$f":"IF(AND('R8 Designs 5-7'!M13>4,'R8 Designs 5-7'!M13<8),'R8 Designs 5-7'!M13,0)","v":0},null,"Confounding:",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,"No interactions can be trusted",null,null,null,null,null,null,"All main effects are confounded",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,"Centerpoints may be omitted.",null,null,null,null,null,null,"with 2-factor interactions and ",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,"Only one replicate is needed.",null,null,null,null,null,null,"higher order interactions.",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,"With only one replicate and less than 2 centerpoints",null,null,null,null,null,null,"For 5, 6 and 7 main factors, the",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,"no statistics is possible, but the effects will be calculated",null,null,null,null,null,null,"confounding is with 1, 2 and 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-factor interactions respectively",null,null,null,"All cells not intended for user input are locked. To unlock go to Review and click Unprotect Sheet"]
["Design","Factor",1,2,3,4,5,6,7,"No of center points:",null,{"$f":"'R8 Designs 5-7'!M14","v":0},null,{"$f":"IF(S16=\"No\",\"Results are NOT saved\",\"Results are saved in sheet Output\")","v":"Results are saved in sheet Output"},null,null,null,null,null,null,null,"Most cells are shown with 2 significant digits. You may want to cange that for small values"]
[null,"Name",{"$f":"IF($P$3>4,'R8 Designs 5-7'!C20,\"\")","v":""},{"$f":"IF($P$3>4,'R8 Designs 5-7'!D20,\"\")","v":""},{"$f":"IF($P$3>4,'R8 Designs 5-7'!E20,\"\")","v":""},{"$f":"IF($P$3>4,'R8 Designs 5-7'!F20,\"\")","v":""},{"$f":"IF($P$3>4,'R8 Designs 5-7'!G20,\"\")","v":""},{"$f":"IF($P$3>5,'R8 Designs 5-7'!H20,\"\")","v":""},{"$f":"IF($P$3>6,'R8 Designs 5-7'!I20,\"\")","v":""}]
[null,"Unit",{"$f":"IF($P$3>4,'R8 Designs 5-7'!C21,\"\")","v":""},{"$f":"IF($P$3>4,'R8 Designs 5-7'!D21,\"\")","v":""},{"$f":"IF($P$3>4,'R8 Designs 5-7'!E21,\"\")","v":""},{"$f":"IF($P$3>4,'R8 Designs 5-7'!F21,\"\")","v":""},{"$f":"IF($P$3>4,'R8 Designs 5-7'!G21,\"\")","v":""},{"$f":"IF($P$3>5,'R8 Designs 5-7'!H21,\"\")","v":""},{"$f":"IF($P$3>6,'R8 Designs 5-7'!I21,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Set the confidence interval for an effects manually (Manual limit):"]
[null,"Low",{"$f":"IF($P$3>4,'R8 Designs 5-7'!C22,\"\")","v":""},{"$f":"IF($P$3>4,'R8 Designs 5-7'!D22,\"\")","v":""},{"$f":"IF($P$3>4,'R8 Designs 5-7'!E22,\"\")","v":""},{"$f":"IF($P$3>4,'R8 Designs 5-7'!F22,\"\")","v":""},{"$f":"IF($P$3>4,'R8 Designs 5-7'!G22,\"\")","v":""},{"$f":"IF($P$3>5,'R8 Designs 5-7'!H22,\"\")","v":""},{"$f":"IF($P$3>6,'R8 Designs 5-7'!I22,\"\")","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,"Center 1",{"$f":"IF($P$3>4,IF('R8 Designs 5-7'!C23=\"\",\"\",'R8 Designs 5-7'!C23),\"\")","v":""},{"$f":"IF($P$3>4,IF('R8 Designs 5-7'!D23=\"\",\"\",'R8 Designs 5-7'!D23),\"\")","v":""},{"$f":"IF($P$3>4,IF('R8 Designs 5-7'!E23=\"\",\"\",'R8 Designs 5-7'!E23),\"\")","v":""},{"$f":"IF($P$3>4,IF('R8 Designs 5-7'!F23=\"\",\"\",'R8 Designs 5-7'!F23),\"\")","v":""},{"$f":"IF($P$3>4,IF('R8 Designs 5-7'!G23=\"\",\"\",'R8 Designs 5-7'!G23),\"\")","v":""},{"$f":"IF($P$3>5,IF('R8 Designs 5-7'!H23=\"\",\"\",'R8 Designs 5-7'!H23),\"\")","v":""},{"$f":"IF($P$3>6,IF('R8 Designs 5-7'!I23=\"\",\"\",'R8 Designs 5-7'!I23),\"\")","v":""},"Analyte:",null,null,null,null,"Rel. Area =",null,null,{"$f":"IF(ABS(SUM(F39:F45)-SUM(Z35:Z41))>0.000000000001,\"Please update sheet\",\"\")","v":""},null,null,null,"All effects of absolute magnitude higher than the manual limit will be marked as signficant (+, ++, +++ instead of *, **, ***)"]
[null,"Center 2",{"$f":"IF($P$3>4,IF('R8 Designs 5-7'!C24=\"\",\"\",'R8 Designs 5-7'!C24),\"\")","v":""},{"$f":"IF($P$3>4,IF('R8 Designs 5-7'!D24=\"\",\"\",'R8 Designs 5-7'!D24),\"\")","v":""},{"$f":"IF($P$3>4,IF('R8 Designs 5-7'!E24=\"\",\"\",'R8 Designs 5-7'!E24),\"\")","v":""},{"$f":"IF($P$3>4,IF('R8 Designs 5-7'!F24=\"\",\"\",'R8 Designs 5-7'!F24),\"\")","v":""},{"$f":"IF($P$3>4,IF('R8 Designs 5-7'!G24=\"\",\"\",'R8 Designs 5-7'!G24),\"\")","v":""},{"$f":"IF($P$3>5,IF('R8 Designs 5-7'!H24=\"\",\"\",'R8 Designs 5-7'!H24),\"\")","v":""},{"$f":"IF($P$3>6,IF('R8 Designs 5-7'!I24=\"\",\"\",'R8 Designs 5-7'!I24),\"\")","v":""},"Comm:"]
[null,"High",{"$f":"IF($P$3>4,'R8 Designs 5-7'!C25,\"\")","v":""},{"$f":"IF($P$3>4,'R8 Designs 5-7'!D25,\"\")","v":""},{"$f":"IF($P$3>4,'R8 Designs 5-7'!E25,\"\")","v":""},{"$f":"IF($P$3>4,'R8 Designs 5-7'!F25,\"\")","v":""},{"$f":"IF($P$3>4,'R8 Designs 5-7'!G25,\"\")","v":""},{"$f":"IF($P$3>5,'R8 Designs 5-7'!H25,\"\")","v":""},{"$f":"IF($P$3>6,'R8 Designs 5-7'!I25,\"\")","v":""},"Results","Replicates",null,null,null,null,null,null,"No","Yes",null,null,"Even if you have an experimental determined statistical CI, you may want to play with the CI because:"]
[null,"Run",1,2,3,4,5,6,7,1,2,3,4,"Mean","Stdev","d.f.",null,"Index out",1,null,null,null,"For your purpose, even statistically insignificant effects may be important"]
["Corner",1,{"$f":"C$13","v":""},"","",{"$f":"F$16","v":""},"","","",null,null,null,null,{"$f":"IF(J18<>\"\",AVERAGE(J18:M18),0)","v":0},{"$f":"IF(P18>0,STDEV(J18:M18),0)","v":0},{"$f":"IF(J18<>\"\",COUNT(J18:M18)-1,0)","v":0},null,null,null,null,null,null,"You suspect that the experimentally determined uncertainty is wrong"]
["points",2,"","","","","","","",null,null,null,null,0,{"$f":"IF(P19>0,STDEV(J19:M19),0)","v":0},{"$f":"IF(J19<>\"\",COUNT(J19:M19)-1,0)","v":0},null,"Generators:"]
[null,3,"",{"$f":"D$16","v":""},"","","","","",null,null,null,null,0,0,0,null,"4 = 12"]
[null,4,"","","","",{"$f":"G$13","v":""},"","",null,null,null,null,0,0,0,null,"5 = 13",null,null,null,"For 5 and 6 main factors, the effect #6 and #7  is:"]
[null,5,"","",{"$f":"E$16","v":""},"","","","",null,null,null,null,0,0,0,null,"6 = 23",null,null,null,"5 Factors:","2^(5-2)","6 = 23 + 45 +125 + 134"]
[null,6,"","","","","","","",null,null,null,null,0,0,0,null,"7 = 123",null,null,null,null,null,"7 = 24 + 35 + 123 + 145"]
[null,7,"",{"$f":"D$16","v":""},"","","","","",null,null,null,null,0,0,0,null,null,null,null,null,"6 Factors:","2^(6-3)","7 = 16 + 24 + 35 + 123 + 145 + 246 + 356 + 123456"]
[null,8,{"$f":"C$16","v":""},"","","","","","",null,null,null,null,0,0,0]
["Center 1",9,{"$f":"IF(C$14=\"\",\"\",IF($B26<$L$10+9,C$14,\"\"))","v":""},{"$f":"IF(D$14=\"\",\"\",IF($B26<$L$10+9,D$14,\"\"))","v":""},"","","","","",null,null,null,null,{"$f":"IF(J26<>\"\",AVERAGE(J26:K29),0)","v":0},{"$f":"IF(P26>0,STDEV(J26:K29),0)","v":0},{"$f":"IF(J26<>\"\",COUNT(J26:K29)-1,0)","v":0},"All center points"]
["points",10,{"$f":"IF(C$14=\"\",\"\",IF($B27<$L$10+9,C$14,\"\"))","v":""},"","","","","","",null,null,null,null,null,null,null,"Mean","d.f"]
[null,11,"","","","","","","",null,null,null,null,null,null,null,{"$f":"IF(J26<>\"\",AVERAGE(J26:K33),\"\")","v":""},{"$f":"P26+P30","v":0}]
[null,12,"","","","","","",""]
["Center 2",13,{"$f":"IF(C$15=\"\",\"\",IF($B30<$L$10+13,C$15,\"\"))","v":""},"","","","","","",null,null,null,null,{"$f":"IF(J30<>\"\",AVERAGE(J30:K33),0)","v":0},{"$f":"IF(P30>0,STDEV(J30:K33),0)","v":0},{"$f":"IF(J30<>\"\",COUNT(J30:K33)-1,0)","v":0},{"$f":"IF(R31>0,\"Statistics\",\"No statistics\")","v":"No statistics"}]
["points",14,"","","","","","","",null,null,null,null,null,null,null,"d.f.",{"$f":"SUM(P18:P30)","v":0}]
[null,15,"","","","","","","",null,null,null,null,null,null,null,"s(pool)",{"$f":"IF(R31>0,SQRT(SUM(O18:O30^2*P18:P30)/R31),\"\")","v":""}]
[null,16,"","","","","","","",null,null,null,null,null,null,null,"s(effect)",{"$f":"IF(R31>0,2*R32/SQRT(COUNT(J18:M25)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Extra runs",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(R33<>\"\",R31,999)","v":999}]
[null,"Enter manual Limit:",null,null,null,"95% Confidence interval for an effect, CI:",null,null,null,{"$f":"AK35","v":0},{"$f":"IF(D35<>\"\",\"Set manually\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,1,0,1,0,null,1,{"$f":"(AA35-0.375)/($W$42+0.25)","v":8.6206896551724144E-2},{"$f":"NORMSINV(AB35)","v":-1.3644887481703289},{"$f":"IF($AK$35<>\"\",IF(X35>=0.05,W35,\"\"),W35)","v":0},null,"line",null,null,null,"CI +/-",{"$f":"IF(D35>0,D35,IF(R33<>\"\",R33*TINV(0.05,AK34),0))","v":0}]
[null,null,null,null,null,null,null,null,"CI(exp) =",{"$f":"IF(R31>0,R33*TINV(0.05,R31),\"na\")","v":"na"},null,null,null,null,null,null,null,null,null,null,null,2,0,1,0,null,2,0.22413793103448276,-0.75829255699115117,{"$f":"IF($AK$35<>\"\",IF(X36>=0.05,W36,\"\"),W36)","v":0},null,null,"Slope",{"$f":"1/AK36","v":{"$error":"#DIV/0!"}},null,"s(effect)",{"$f":"AK35/TINV(0.05,AK34)","v":0}]
["Effects","Term","Effect","Coeff","P","Sign?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0,1,0,null,3,0.36206896551724138,-0.35293398612691645,0,null,null,"X","Y","CI lines","X","Y"]
[null,"Mean",{"$f":"M69/8","v":0},{"$f":"C38","v":0},{"$f":"IF(AK35>0,TDIST(2*ABS(C38)/$AK$36,$AK$34,2),1)","v":1},{"$f":"IF(E38<0.001,\"***\",IF(E38<0.01,\"**\",IF(E38<0.05,\"*\",\"\")))","v":""},null,"Effectes sorted from low to high",null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,1,0,null,4,0.5,0,0,null,"Low",{"$f":"AH38/$AH$36","v":{"$error":"#DIV/0!"}},{"$f":"MIN(AC35:AC41)","v":-1.3644887481703289},"SV",{"$f":"-AK35","v":0},{"$f":"MIN(AC35:AC41)","v":-1.3644887481703289}]
[null,1,{"$f":"M70/4","v":0},{"$f":"C39/2","v":0},{"$f":"IF($AK$35>0,TDIST(ABS(C39)/$AK$36,$AK$34,2),1)","v":1},"",null,{"$f":"V34","v":"Terms"},{"$f":"W34","v":"Effect"},{"$f":"Y34","v":"Noise"},null,null,null,null,null,null,null,null,null,null,null,5,0,1,0,null,5,0.63793103448275867,0.35293398612691662,0,null,"High",{"$f":"AH39/$AH$36","v":{"$error":"#DIV/0!"}},{"$f":"MAX(AC35:AC41)","v":1.3644887481703283},"NV",{"$f":"-AK35","v":0},{"$f":"MAX(AC35:AC41)","v":1.3644887481703283}]
[null,2,0,{"$f":"C40/2","v":0},1,"",null,{"$f":"V35","v":1},{"$f":"IF(Y35<>\"\",\"\",W35)","v":""},{"$f":"IF(Y35<>\"\",Y35,\"\")","v":0},null,null,null,null,null,null,null,null,null,null,null,6,0,1,0,null,6,0.77586206896551724,0.75829255699115117,0,null,null,null,null,"SE",{"$f":"AK35","v":0},{"$f":"MIN(AC35:AC41)","v":-1.3644887481703289}]
[null,3,0,0,1,"",null,2,"",0,null,null,null,null,null,null,null,null,null,null,null,7,0,1,0,null,7,0.91379310344827591,1.3644887481703283,0,null,"s(pool)",{"$f":"AK36*SQRT(COUNT(J18:M25))/2","v":0},null,"NE",{"$f":"AK35","v":0},{"$f":"MAX(AC35:AC41)","v":1.3644887481703283}]
[null,4,0,0,1,"",null,3,"",0,null,null,null,null,null,null,null,null,null,null,null,"N =",{"$f":"COUNT(W35:W41)","v":7},1,{"$f":"COUNT(Y35:Y41)","v":7}]
[null,5,0,0,1,"",null,4,"",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"s(Noise)",{"$f":"SQRT(SUM(Y35:Y41^2)/COUNT(Y35:Y41))","v":0}]
[null,6,0,0,1,"",null,5,"",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"CI(noise)",{"$f":"Y43*TINV(0.05,Y42)","v":0}]
[null,7,0,0,1,"",null,6,"",0]
[null,"Center  p",{"$f":"IF(J26<>\"\",Q28-C38,\"\")","v":""},{"$f":"C46","v":""},{"$f":"IF(C46<>\"\",IF(AK35>0,TDIST(ABS(C46)/(AG41*SQRT(1/(R28+1)+1/(COUNT(J18:M25)))),AK34,2),1),\"\")","v":""},"",null,7,"",0]
[null,"Manual","P<0.05","+","P<0.05","*",null,null,"CI(Noise)",{"$f":"IF(Y42>0,Y44,\"\")","v":0}]
[null,"limit","P<0.01","++","P<0.01","**"]
[null,"<> blank:","P<0.001","+++","P<0.001","***"]
[null,null,"If no s(effect) all  P=1",null,"If no s(effect) all  P=1"]
[]
[null,"Model 1"]
[null,{"$f":"B37","v":"Term"},"X","Coeff","Value",null,"See V21 for explanation",null,null,null,null,"Blue points:  not significant effects"]
[null,"Mean",1,{"$f":"D38","v":0},{"$f":"C54*D54","v":0},null,"about effects #6 and #7",null,null,null,null,"Red points:   significant effects"]
[null,1,1,0,{"$f":"C55*D55","v":0},null,null,null,null,null,null,"Green lines: If <>0: 95 % confidence interval"]
[null,2,1,0,0,null,null,null,null,null,null,"Blue line:  True noise factors should be on  this line"]
[null,3,1,0,0]
[null,4,1,0,0,null,"Predict the respons and optimize"]
[null,5,1,0,0,null,"Model:"]
[null,6,1,0,0,null,"Y = C(Mean) + X1*C1 + X2*C2 + X3*C3 + X4*C4 + X5*C5 + X6*C6 + X7*C7"]
[null,7,1,0,0,null,"X = -1, 0 or 1 (coded values)"]
[null,"Y",null,null,{"$f":"SUM(E54:E61)","v":0},null,"C = Coefficients"]
[]
[null,{"$f":"B46","v":"Center  p"},null,null,{"$f":"IF(D46<>\"\",D38+D46,\"\")","v":""}]
[]
[]
[]
["Design matrix",null,"2^3",null,"Factor",null,null,null,null,null,null,null,"Mmult"]
[null,null,"Run","Mean",1,2,3,4,5,6,7,null,{"$f":"MMULT($D$81:$K$88,$N$18:$N$25)","v":0}]
[null,null,1,1,-1,-1,-1,{"$f":"E70*F70","v":1},{"$f":"E70*G70","v":1},{"$f":"F70*G70","v":1},{"$f":"E70*F70*G70","v":-1},null,0]
[null,null,2,1,1,-1,-1,{"$f":"E71*F71","v":-1},{"$f":"E71*G71","v":-1},{"$f":"F71*G71","v":1},{"$f":"E71*F71*G71","v":1},null,0]
[null,null,3,1,-1,1,-1,-1,1,-1,1,null,0]
[null,null,4,1,1,1,-1,1,-1,-1,-1,null,0]
[null,null,5,1,-1,-1,1,1,-1,-1,1,null,0]
[null,null,6,1,1,-1,1,-1,1,-1,-1,null,0]
[null,null,7,1,-1,1,1,-1,-1,1,-1,null,0]
[null,null,8,1,1,1,1,1,1,1,1]
[]
["Matrix",null,null,"Transposed design matrix"]
[null,null,"Run",1,2,3,4,5,6,7,8]
[null,null,"Mean",1,1,1,1,1,1,1,1]
[null,null,1,-1,1,-1,1,-1,1,-1,1]
[null,null,2,-1,-1,1,1,-1,-1,1,1]
[null,null,3,-1,-1,-1,-1,1,1,1,1]
[null,null,4,{"$f":"D82*D83","v":1},-1,-1,1,1,-1,-1,1]
[null,null,5,{"$f":"D82*D84","v":1},-1,1,-1,-1,1,-1,1]
[null,null,6,{"$f":"D83*D84","v":1},1,-1,-1,-1,-1,1,1]
[null,null,7,{"$f":"D82*D83*D84","v":-1},1,1,-1,1,-1,-1,1]

{"sheet":"Output","index":7,"n_rows":48,"n_cols":16,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Input!A1","v":"DOE_R8_1.0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'R8 Designs 3-4'!$J$1","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]
[12]
[13]
[23]
[123]
["Center p"]
["Statistics"]
["Mean"]
[1]
[2]
[3]
[12]
[13]
[23]
[123]
["Center p"]
["Response"]
["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,"Center 1","9-12"]
[null,null,null,null,null,"Center 2","13-16"]
[null,null,null,null,null,"Extra runs",17]
[null,null,null,null,null,null,18]
[null,null,null,null,null,null,19]
[null,null,null,null,null,null,20]
[null,null,null,null,null,null,21]
[null,null,null,null,null,null,22]
[null,null,null,null,null,null,23]
[null,null,null,null,null,null,24]