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

{"sheet":"DESIGN","index":0,"n_rows":43,"n_cols":10,"rows_kept":43,"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","2X4 TRIAL NAME"]
["Trial Objective","2X4 TRIAL OBJECTIVE"]
["FACTORS",null,"A DESCRIPTION","B DESCRIPTION","C DESCRIPTION","D DESCRIPTION","RUN ORDER"]
["LEVELS","-","A-","B-","C-","D-"]
[null,"+","A+","B+","C+","D+","REP 1","REP 2","REP 3","REP 4"]
["Treatment",null,"A","B","C","D"]
[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"]
{"$rows_empty":9}
["Run Notes"]

{"sheet":"2X4X4","index":1,"n_rows":110,"n_cols":24,"rows_kept":110,"merged":[[0,1,0,5],[1,1,1,5],[1,18,1,21],[2,18,2,21],[43,9,43,12],[78,13,78,24],[79,13,79,24],[80,13,80,24],[81,13,81,24]]}
[{"$f":"DESIGN!A1","v":"Trial Name"},{"$f":"DESIGN!B1","v":"2X4 TRIAL NAME"}]
[null,{"$f":"DESIGN!B2","v":"2X4 TRIAL OBJECTIVE"},{"$nulls":16},"METRIC"]
["Factors",{"$f":"DESIGN!C3","v":"A DESCRIPTION"},{"$f":"DESIGN!D3","v":"B DESCRIPTION"},null,{"$f":"DESIGN!E3","v":"C DESCRIPTION"},{"$nulls":3},{"$f":"DESIGN!F3","v":"D DESCRIPTION"}]
["-",{"$f":"DESIGN!C4","v":"A-"},{"$f":"DESIGN!D4","v":"B-"},null,{"$f":"DESIGN!E4","v":"C-"},{"$nulls":3},{"$f":"DESIGN!F4","v":"D-"},{"$nulls":9},"REP 1","REP 2","REP 3","REP 4"]
["+",{"$f":"DESIGN!C5","v":"A+"},{"$f":"DESIGN!D5","v":"B+"},null,{"$f":"DESIGN!E5","v":"C+"},{"$nulls":3},{"$f":"DESIGN!F5","v":"D+"}]
[{"$f":"DESIGN!A6","v":"Treatment"},"A","B","AB","C","AC","BC","ABC","D","AD","BD","ABD","CD","ACD","BCD","ABCD","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},-1,{"$f":"B7*I7","v":1},{"$f":"C7*I7","v":1},{"$f":"B7*C7*I7","v":-1},{"$f":"E7*I7","v":1},{"$f":"B7*E7*I7","v":-1},{"$f":"C7*E7*I7","v":-1},{"$f":"B7*C7*E7*I7","v":1},{"$f":"B7*C7*D7*E7*F7*G7*H7*I7*J7*K7*L7*M7*N7*O7*P7","v":1},"(1)",{"$nulls":4},{"$f":"SUM(S7:V7)","v":0},{"$f":"AVERAGE(S7:V7)","v":{"$error":"#DIV/0!"}}]
[{"$f":"DESIGN!A8","v":2},1,-1,-1,-1,-1,1,1,-1,-1,1,1,1,1,-1,-1,1,"a",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[{"$f":"DESIGN!A9","v":3},-1,1,-1,-1,1,-1,1,-1,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,-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,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,-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,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,-1,-1,-1,-1,-1,-1,-1,1,"abc",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[{"$f":"DESIGN!A15","v":9},-1,-1,1,-1,1,1,-1,1,-1,-1,1,-1,1,1,-1,1,"d",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[{"$f":"DESIGN!A16","v":10},1,-1,-1,-1,-1,1,1,1,1,-1,-1,-1,-1,1,1,1,"ad",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[{"$f":"DESIGN!A17","v":11},-1,1,-1,-1,1,-1,1,1,-1,1,-1,-1,1,-1,1,1,"bd",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[{"$f":"DESIGN!A18","v":12},1,1,1,-1,-1,-1,-1,1,1,1,1,-1,-1,-1,-1,1,"abd",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[{"$f":"DESIGN!A19","v":13},-1,-1,1,1,-1,-1,1,1,-1,-1,1,1,-1,-1,1,1,"cd",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[{"$f":"DESIGN!A20","v":14},1,-1,-1,1,1,-1,-1,1,1,-1,-1,1,1,-1,-1,1,"acd",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[{"$f":"DESIGN!A21","v":15},-1,1,-1,1,-1,1,-1,1,-1,1,-1,1,-1,1,-1,1,"bcd",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[{"$f":"DESIGN!A22","v":16},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"abcd",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[]
["Total Treatments",{"$f":"COUNT(B7:B22)","v":16},{"$nulls":15},"n",{"$f":"COUNT(S7:V7)","v":0}]
[{"$nulls":17},"N",{"$f":"COUNT(S7:V22)","v":0},{"$nulls":3},{"$f":"SUM(W7:W22)","v":0},{"$f":"AVERAGE(S7:V22)","v":{"$error":"#DIV/0!"}}]
[null,"A","B","AB","C","AC","BC","ABC","D","AD","BD","ABD","CD","ACD","BCD","ABCD","ERROR","TOTAL"]
["CONTRAST",{"$f":"(B$7*$W$7+B$8*$W$8+B$9*$W$9+B$10*$W$10+B$11*$W$11+B$12*$W$12+B$13*$W$13+B$14*$W$14+B$15*$W$15+B$16*$W$16+B$17*$W$17+B$18*$W$18+B$19*$W$19+B$20*$W$20+B$21*$W$21+B$22*$W$22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["EFFECTS",{"$f":"2*B27/($B24*$S24)","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!"},{"$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,$X7),IF(B8>0,$X8),IF(B9>0,$X9),IF(B10>0,$X10),IF(B11>0,$X11),IF(B12>0,$X12),IF(B13>0,$X13),IF(B14>0,$X14),IF(B15>0,$X15),IF(B16>0,$X16),IF(B17>0,$X17),IF(B18>0,$X18),IF(B19>0,$X19),IF(B20>0,$X20),IF(B21>0,$X21),IF(B22>0,$X22))/COUNTIF(B7:B22,\">0\")","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!"},{"$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,$X7),IF(B8<0,$X8),IF(B9<0,$X9),IF(B10<0,$X10),IF(B11<0,$X11),IF(B12<0,$X12),IF(B13<0,$X13),IF(B14<0,$X14),IF(B15<0,$X15),IF(B16<0,$X16),IF(B17<0,$X17),IF(B18<0,$X18),IF(B19<0,$X19),IF(B20<0,$X20),IF(B21<0,$X21),IF(B22<0,$X22))/COUNTIF(B7:B22,\"<0\")","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!"},{"$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":"B27^2/($B24*$S24)","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!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"R31-SUM(B31:P31)","v":{"$error":"#DIV/0!"}},{"$f":"R32*VAR(S7:V22)","v":{"$error":"#DIV/0!"}}]
["DF",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"R32-SUM(B32:P32)","v":-16},{"$f":"S25-1","v":-1}]
["MEAN SQUARES",{"$f":"B31/B32","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!"},{"$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":"B33/$Q33","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!"},{"$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(B34,B32,$Q32)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.F.DIST.RT(C34,C32,$Q32)","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!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["SIGNIFICANCE",{"$f":"IF(B35<0.05,\"SSD\",\"\")","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!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
{"$rows_empty":7}
[{"$nulls":9},"RESIDUALS NORMAL PROBABILITY"]
[{"$nulls":6},"Pk",{"$nulls":4},"Pk"]
[null,"#","TR","TM","RESIDUAL","RANK(k)","(k-.5)/N",null,null,"RESIDUAL","RANK(k)","(k-.5)/N"]
[null,"1R1",{"$f":"IF(S7=\"\",\"\",S7)","v":""},{"$f":"IF(C47=\"\",\"\",X7)","v":""},{"$f":"IF(C47=\"\",\"\",C47-D47)","v":""},{"$f":"IF(C47=\"\",\"\",RANK(E47,E$47:E$110,1))","v":""},{"$f":"IF(C47=\"\",\"\",(F47-0.5)/COUNT(F$47:F$110))","v":""}]
[null,"2R1",{"$f":"IF(S8=\"\",\"\",S8)","v":""},{"$f":"IF(C48=\"\",\"\",X8)","v":""},"",{"$f":"IF(C48=\"\",\"\",RANK(E48,E$47:E$110,1))","v":""},{"$f":"IF(C48=\"\",\"\",(F48-0.5)/COUNT(F$47:F$110))","v":""}]
[null,"3R1","","","","",""]
[null,"4R1","","","","",""]
[null,"5R1","","","","",""]
[null,"6R1","","","","",""]
[null,"7R1","","","","",""]
[null,"8R1","","","","",""]
[null,"9R1","","","","",""]
[null,"10R1","","","","",""]
[null,"11R1","","","","",""]
[null,"12R1","","","","",""]
[null,"13R1","","","","",""]
[null,"14R1","","","","",""]
[null,"15R1","","","","",""]
[null,"16R1","","","","",""]
[null,"1R2",{"$f":"IF(T7=\"\",\"\",T7)","v":""},{"$f":"IF(C63=\"\",\"\",X7)","v":""},"","",""]
[null,"2R2",{"$f":"IF(T8=\"\",\"\",T8)","v":""},{"$f":"IF(C64=\"\",\"\",X8)","v":""},"","",""]
[null,"3R2","","","","",""]
[null,"4R2","","","","",""]
[null,"5R2","","","","",""]
[null,"6R2","","","","",""]
[null,"7R2","","","","",""]
[null,"8R2","","","","",""]
[null,"9R2","","","","",""]
[null,"10R2","","","","",""]
[null,"11R2","","","","",""]
[null,"12R2","","","","",""]
[null,"13R2","","","","",""]
[null,"14R2","","","","",""]
[null,"15R2","","","","",""]
[null,"16R2","","","","",""]
[null,"1R3",{"$f":"IF(U7=\"\",\"\",U7)","v":""},{"$f":"IF(C79=\"\",\"\",X7)","v":""},"","","",{"$nulls":6},"Instructions for Plotting Residuals"]
[null,"2R3",{"$f":"IF(U8=\"\",\"\",U8)","v":""},{"$f":"IF(C80=\"\",\"\",X8)","v":""},"","","",{"$nulls":6},"1. Select the calculated Residual, Rank and Pk columns of data."]
[null,"3R3","","","","","",{"$nulls":6},"2. Paste special - values only - in the Residuals Normal Probability columns."]
[null,"4R3","","","","","",{"$nulls":6},"3. the data may be sorted by  rank if desired."]
[null,"5R3","","","","",""]
[null,"6R3","","","","",""]
[null,"7R3","","","","",""]
[null,"8R3","","","","",""]
[null,"9R3","","","","",""]
[null,"10R3","","","","",""]
[null,"11R3","","","","",""]
[null,"12R3","","","","",""]
[null,"13R3","","","","",""]
[null,"14R3","","","","",""]
[null,"15R3","","","","",""]
[null,"16R3","","","","",""]
[null,"1R4",{"$f":"IF(V7=\"\",\"\",V7)","v":""},{"$f":"IF(C95=\"\",\"\",X7)","v":""},"","",""]
[null,"2R4",{"$f":"IF(V8=\"\",\"\",V8)","v":""},{"$f":"IF(C96=\"\",\"\",X8)","v":""},"","",""]
[null,"3R4","","","","",""]
[null,"4R4","","","","",""]
[null,"5R4","","","","",""]
[null,"6R4","","","","",""]
[null,"7R4","","","","",""]
[null,"8R4","","","","",""]
[null,"9R4","","","","",""]
[null,"10R4","","","","",""]
[null,"11R4","","","","",""]
[null,"12R4","","","","",""]
[null,"13R4","","","","",""]
[null,"14R4","","","","",""]
[null,"15R4","","","","",""]
[null,"16R4","","","","",""]