{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["DESIGN","2X3X4"],"not_rendered":{"charts":1,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"DESIGN","index":0,"n_rows":32,"n_cols":10,"rows_kept":32,"merged":[[0,1,0,5],[1,1,1,5],[2,6,3,9],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9]]}
["Trial Name","2X3 TRIAL"]
["Trial Objective","2X3 OBJECTIVE"]
["FACTORS",null,"A","B","C",null,"RUN ORDER"]
["LEVELS","-","A-","B-","C-"]
[null,"+","A+","B+","C+",null,"REP 1","REP 2","REP 3","REP 4"]
["SET UP ",null,"A","B","C"]
[1,null,"-","-","-"]
[2,null,"+","-","-"]
[3,null,"-","+","-"]
[4,null,"+","+","-"]
[5,null,"-","-","+"]
[6,null,"+","-","+"]
[7,null,"-","+","+"]
[8,null,"+","+","+"]
[9,null,"-","-","-"]
[10,null,"+","-","-"]
[11,null,"-","+","-"]
[12,null,"+","+","-"]
[13,null,"-","-","+"]
[14,null,"+","-","+"]
[15,null,"-","+","+"]
[16,null,"+","+","+"]
[]
[]
["Metrics"]
[]
[]
[]
[]
[]
[]
["Run Instructions"]

{"sheet":"2X3X4","index":1,"n_rows":75,"n_cols":16,"rows_kept":75,"merged":[[0,1,0,5],[1,1,1,5],[1,10,1,13],[2,10,2,13],[33,8,33,11],[71,1,71,12],[72,1,72,12],[73,1,73,12],[74,1,74,12]]}
[{"$f":"DESIGN!A1","v":"Trial Name"},{"$f":"DESIGN!B1","v":"2X3 TRIAL"}]
[{"$f":"DESIGN!A2","v":"Trial Objective"},{"$f":"DESIGN!B2","v":"2X3 OBJECTIVE"},{"$nulls":8},"METRIC"]
["Factors",{"$f":"DESIGN!C3","v":"A"},{"$f":"DESIGN!D3","v":"B"},null,{"$f":"DESIGN!E3","v":"C"}]
["-",{"$f":"DESIGN!C4","v":"A-"},{"$f":"DESIGN!D4","v":"B-"},null,{"$f":"DESIGN!E4","v":"C-"},{"$nulls":5},"REP 1","REP 2","REP 3","REP 4"]
["+",{"$f":"DESIGN!C5","v":"A+"},{"$f":"DESIGN!D5","v":"B+"},null,{"$f":"DESIGN!E5","v":"C+"}]
["TREATMENT","A","B","AB","C","AC","BC","ABC","I","tc",{"$nulls":4},"SUM","MEAN"]
[{"$f":"DESIGN!A7","v":1},-1,-1,{"$f":"B7*C7","v":1},-1,{"$f":"B7*E7","v":1},{"$f":"C7*E7","v":1},{"$f":"B7*C7*E7","v":-1},{"$f":"B7*C7*D7*E7*F7*G7*H7","v":1},"(1)",{"$nulls":4},{"$f":"SUM(K7:N7)","v":0},{"$f":"AVERAGE(K7:N7)","v":{"$error":"#DIV/0!"}}]
[{"$f":"DESIGN!A8","v":2},1,-1,-1,-1,-1,1,1,1,"a",{"$nulls":4},0,{"$f":"AVERAGE(K8:N8)","v":{"$error":"#DIV/0!"}}]
[{"$f":"DESIGN!A9","v":3},-1,1,-1,-1,1,-1,1,1,"b",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[{"$f":"DESIGN!A10","v":4},1,1,1,-1,-1,-1,-1,1,"ab",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[{"$f":"DESIGN!A11","v":5},-1,-1,1,1,-1,-1,1,1,"c",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[{"$f":"DESIGN!A12","v":6},1,-1,-1,1,1,-1,-1,1,"ac",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[{"$f":"DESIGN!A13","v":7},-1,1,-1,1,-1,1,-1,1,"bc",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[{"$f":"DESIGN!A14","v":8},1,1,1,1,1,1,1,1,"abc",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[]
["Total Treatments",{"$f":"COUNT(B7:B14)","v":8},{"$nulls":7},"n",{"$f":"COUNT(K7:N7)","v":0}]
[{"$nulls":9},"N",{"$f":"COUNT(K7:N14)","v":0},{"$nulls":3},{"$f":"SUM(O7:O14)","v":0},{"$f":"AVERAGE(K7:N14)","v":{"$error":"#DIV/0!"}}]
[null,"A","B","AB","C","AC","BC","ABC","ERROR","TOTAL"]
["CONTRAST",{"$f":"(B$7*$O$7+B$8*$O$8+B$9*$O$9+B$10*$O$10+B$11*$O$11+B$12*$O$12+B$13*$O$13+B$14*$O$14)","v":0},0,0,0,0,0,0]
["EFFECTS",{"$f":"2*B19/($B16*$K16)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["+ MEAN",{"$f":"SUM(IF(B7>0,$P7),IF(B8>0,$P8),IF(B9>0,$P9),IF(B10>0,$P10),IF(B11>0,$P11),IF(B12>0,$P12),IF(B13>0,$P13),IF(B14>0,$P14))/COUNTIF(B7:B14,\">0\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["- MEAN",{"$f":"SUM(IF(B7<0,$P7),IF(B8<0,$P8),IF(B9<0,$P9),IF(B10<0,$P10),IF(B11<0,$P11),IF(B12<0,$P12),IF(B13<0,$P13),IF(B14<0,$P14))/COUNTIF(B7:B14,\"<0\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["SUM OF SQUARES",{"$f":"B19^2/($B16*$K16)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"J23-SUM(B23:H23)","v":{"$error":"#DIV/0!"}},{"$f":"J24*VAR(K7:N14)","v":{"$error":"#DIV/0!"}}]
["DF",1,1,1,1,1,1,1,{"$f":"J24-SUM(B24:H24)","v":-8},{"$f":"K17-1","v":-1}]
["MEAN SQUARES",{"$f":"B23/B24","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["F RATIO",{"$f":"B25/$I25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["PROBABILITY",{"$f":"_xlfn.F.DIST.RT(B26,B24,$I24)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.F.DIST.RT(C26,C24,$I24)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["SIGNIFICANCE",{"$f":"IF(B27<0.05,\"SSD\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(C27<0.05,\"SSD\",\"\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[{"$nulls":8},"Residuals Normal Probability"]
[{"$nulls":6},"Pk",{"$nulls":3},"Pk"]
[null,"#","TR","TM","RESIDUAL","RANK(k)","(k-.5)/N",null,"RESIDUAL","RANK(k)","(k-.5)/N"]
[null,"1R1",{"$f":"IF(K7=\"\",\"\",K7)","v":""},{"$f":"IF(C37=\"\",\"\",P7)","v":""},{"$f":"IF(C37=\"\",\"\",C37-D37)","v":""},{"$f":"IF(C37=\"\",\"\",RANK(E37,E$37:E$68,1))","v":""},{"$f":"IF(C37=\"\",\"\",(F37-0.5)/COUNT(F$37:F$68))","v":""}]
[null,"2R1",{"$f":"IF(K8=\"\",\"\",K8)","v":""},{"$f":"IF(C38=\"\",\"\",P8)","v":""},"",{"$f":"IF(C38=\"\",\"\",RANK(E38,E$37:E$68,1))","v":""},{"$f":"IF(C38=\"\",\"\",(F38-0.5)/COUNT(F$37:F$68))","v":""}]
[null,"3R1","","","","",""]
[null,"4R1","","","","",""]
[null,"5R1","","","","",""]
[null,"6R1","","","","",""]
[null,"7R1","","","","",""]
[null,"8R1","","","","",""]
[null,"1R2",{"$f":"IF(L7=\"\",\"\",L7)","v":""},{"$f":"IF(C45=\"\",\"\",P7)","v":""},"","",""]
[null,"2R2",{"$f":"IF(L8=\"\",\"\",L8)","v":""},{"$f":"IF(C46=\"\",\"\",P8)","v":""},"","",""]
[null,"3R2","","","","",""]
[null,"4R2","","","","",""]
[null,"5R2","","","","",""]
[null,"6R2","","","","",""]
[null,"7R2","","","","",""]
[null,"8R2","","","","",""]
[null,"1R3",{"$f":"IF(M7=\"\",\"\",M7)","v":""},{"$f":"IF(C53=\"\",\"\",P7)","v":""},"","",""]
[null,"2R3",{"$f":"IF(M8=\"\",\"\",M8)","v":""},{"$f":"IF(C54=\"\",\"\",P8)","v":""},"","",""]
[null,"3R3","","","","",""]
[null,"4R3","","","","",""]
[null,"5R3","","","","",""]
[null,"6R3","","","","",""]
[null,"7R3","","","","",""]
[null,"8R3","","","","",""]
[null,"1R4",{"$f":"IF(N7=\"\",\"\",N7)","v":""},{"$f":"IF(C61=\"\",\"\",P7)","v":""},"","",""]
[null,"2R4",{"$f":"IF(N8=\"\",\"\",N8)","v":""},{"$f":"IF(C62=\"\",\"\",P8)","v":""},"","",""]
[null,"3R4","","","","",""]
[null,"4R4","","","","",""]
[null,"5R4","","","","",""]
[null,"6R4","","","","",""]
[null,"7R4","","","","",""]
[null,"8R4","","","","",""]
[]
[]
[]
[null,"Instructions for Plotting Residuals"]
[null,"1. Select the calculated Residual, Rank and Pk columns of data."]
[null,"2. Paste special - values only - in the Residuals Normal Probability columns."]
[null,"3. the data may be sorted by  rank if desired."]