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

{"sheet":"DESIGN","index":0,"n_rows":32,"n_cols":8,"rows_kept":32,"merged":[[0,1,0,7],[1,1,1,7],[2,4,3,7],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7]]}
["Trial Name","2x2 Trial Name"]
["Trial Objective","2x2 Trial Objective"]
["FACTORS",null,"Factor A Description","Factor B Description","RUN ORDER"]
["LEVELS","-","A-","B-"]
[null,"+","A+","B+","REP 1","REP 2","REP 3","REP 4"]
["TREATMENT",null,"A","B"]
[1,null,"-","-"]
[2,null,"+","-"]
[3,null,"-","+"]
[4,null,"+","+"]
[]
[]
[]
[]
["Metrics"]
[]
[]
[]
[]
[]
[]
["Run Instructions"]
{"$rows_empty":9}
["Run Notes"]

{"sheet":"2X2X4","index":1,"n_rows":53,"n_cols":12,"rows_kept":53,"merged":[[0,1,0,5],[1,1,1,5],[1,6,1,9],[2,6,2,9],[28,8,28,10],[49,1,49,12],[50,1,50,12],[51,1,51,12],[52,1,52,12]]}
[{"$f":"DESIGN!A1","v":"Trial Name"},{"$f":"DESIGN!B1","v":"2x2 Trial Name"}]
[{"$f":"DESIGN!A2","v":"Trial Objective"},{"$f":"DESIGN!B2","v":"2x2 Trial Objective"},{"$nulls":4},"METRIC"]
["Factors",{"$f":"DESIGN!C3","v":"Factor A Description"},{"$f":"DESIGN!D3","v":"Factor B Description"}]
["-",{"$f":"DESIGN!C4","v":"A-"},{"$f":"DESIGN!D4","v":"B-"},{"$nulls":3},"REP 1","REP 2","REP 3","REP 4"]
["+",{"$f":"DESIGN!C5","v":"A+"},{"$f":"DESIGN!D5","v":"B+"}]
[{"$f":"DESIGN!A6","v":"TREATMENT"},"A","B","AB",null,"tc",{"$nulls":4},"SUM","MEAN"]
[{"$f":"DESIGN!A7","v":1},-1,-1,{"$f":"B7*C7","v":1},null,"(1)",{"$nulls":4},{"$f":"SUM(G7:J7)","v":0},{"$f":"AVERAGE(G7:J7)","v":{"$error":"#DIV/0!"}}]
[{"$f":"DESIGN!A8","v":2},1,-1,{"$f":"B8*C8","v":-1},null,"a",{"$nulls":4},{"$f":"SUM(G8:J8)","v":0},{"$f":"AVERAGE(G8:J8)","v":{"$error":"#DIV/0!"}}]
[{"$f":"DESIGN!A9","v":3},-1,1,{"$f":"B9*C9","v":-1},null,"b",{"$nulls":4},{"$f":"SUM(G9:J9)","v":0},{"$f":"AVERAGE(G9:J9)","v":{"$error":"#DIV/0!"}}]
[{"$f":"DESIGN!A10","v":4},1,1,{"$f":"B10*C10","v":1},null,"ab",{"$nulls":4},{"$f":"SUM(G10:J10)","v":0},{"$f":"AVERAGE(G10:J10)","v":{"$error":"#DIV/0!"}}]
[]
["Total Treatments",{"$f":"COUNT(B7:B10)","v":4},{"$nulls":3},"n",{"$f":"COUNT(G7:J7)","v":0}]
[{"$nulls":5},"N",{"$f":"COUNT(G7:J10)","v":0},{"$nulls":3},{"$f":"SUM(K7:K10)","v":0},{"$f":"AVERAGE(G7:J10)","v":{"$error":"#DIV/0!"}}]
[null,"A","B","AB","ERROR","TOTAL"]
["CONTRAST",{"$f":"(B$7*$K$7+B$8*$K$8+B$9*$K$9+B$10*$K$10)","v":0},{"$f":"(C$7*$K$7+C$8*$K$8+C$9*$K$9+C$10*$K$10)","v":0},{"$f":"(D$7*$K$7+D$8*$K$8+D$9*$K$9+D$10*$K$10)","v":0}]
["EFFECTS",{"$f":"2*B15/($B12*$G12)","v":{"$error":"#DIV/0!"}},{"$f":"2*C15/($B12*$G12)","v":{"$error":"#DIV/0!"}},{"$f":"2*D15/($B12*$G12)","v":{"$error":"#DIV/0!"}}]
["+ MEAN",{"$f":"SUM(IF(B7>0,$L7),IF(B8>0,$L8),IF(B9>0,$L9),IF(B10>0,$L10))/COUNTIF(B7:B10,\">0\")","v":{"$error":"#DIV/0!"}},{"$f":"SUM(IF(C7>0,$L7),IF(C8>0,$L8),IF(C9>0,$L9),IF(C10>0,$L10))/COUNTIF(C7:C10,\">0\")","v":{"$error":"#DIV/0!"}},{"$f":"SUM(IF(D7>0,$L7),IF(D8>0,$L8),IF(D9>0,$L9),IF(D10>0,$L10))/COUNTIF(D7:D10,\">0\")","v":{"$error":"#DIV/0!"}}]
["- MEAN",{"$f":"SUM(IF(B7<0,$L7),IF(B8<0,$L8),IF(B9<0,$L9),IF(B10<0,$L10))/COUNTIF(B7:B10,\"<0\")","v":{"$error":"#DIV/0!"}},{"$f":"SUM(IF(C7<0,$L7),IF(C8<0,$L8),IF(C9<0,$L9),IF(C10<0,$L10))/COUNTIF(C7:C10,\"<0\")","v":{"$error":"#DIV/0!"}},{"$f":"SUM(IF(D7<0,$L7),IF(D8<0,$L8),IF(D9<0,$L9),IF(D10<0,$L10))/COUNTIF(D7:D10,\"<0\")","v":{"$error":"#DIV/0!"}}]
["SUM OF SQUARES",{"$f":"B15^2/($B12*$G12)","v":{"$error":"#DIV/0!"}},{"$f":"C15^2/($B12*$G12)","v":{"$error":"#DIV/0!"}},{"$f":"D15^2/($B12*$G12)","v":{"$error":"#DIV/0!"}},{"$f":"F19-SUM(B19:D19)","v":{"$error":"#DIV/0!"}},{"$f":"F20*VAR(G7:J10)","v":{"$error":"#DIV/0!"}}]
["DF",1,1,1,{"$f":"F20-SUM(B20:D20)","v":-4},{"$f":"G13-1","v":-1}]
["MEAN SQUARES",{"$f":"B19/B20","v":{"$error":"#DIV/0!"}},{"$f":"C19/C20","v":{"$error":"#DIV/0!"}},{"$f":"D19/D20","v":{"$error":"#DIV/0!"}},{"$f":"E19/E20","v":{"$error":"#DIV/0!"}}]
["F RATIO",{"$f":"B21/$E21","v":{"$error":"#DIV/0!"}},{"$f":"C21/$E21","v":{"$error":"#DIV/0!"}},{"$f":"D21/$E21","v":{"$error":"#DIV/0!"}}]
["PROBABILITY",{"$f":"_xlfn.F.DIST.RT(B22,B20,$E20)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.F.DIST.RT(C22,C20,$E20)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.F.DIST.RT(D22,D20,$E20)","v":{"$error":"#DIV/0!"}}]
["SIGNIFICANCE",{"$f":"IF(B23<0.05,\"SSD\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(C23<0.05,\"SSD\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(D23<0.05,\"SSD\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[{"$nulls":8},"Residual Normal Probability"]
[{"$nulls":4},"Residual",null,"Pk",null,"Residual",null,"Pk"]
[null,"#","TR","TM","TR-TM","RANK(k)","(k-.5)/N",null,"TR-TM","RANK(k)","(k-.5)/N"]
[null,"1R1",{"$f":"IF(G7=\"\",\"\",G7)","v":""},{"$f":"IF(C32=\"\",\"\",L7)","v":""},{"$f":"IF(C32=\"\",\"\",C32-D32)","v":""},{"$f":"IF(C32=\"\",\"\",RANK(E32,E$32:E$47,1))","v":""},{"$f":"IF(C32=\"\",\"\",(F32-0.5)/COUNT(F$32:F$47))","v":""}]
[null,"2R1",{"$f":"IF(G8=\"\",\"\",G8)","v":""},{"$f":"IF(C33=\"\",\"\",L8)","v":""},{"$f":"IF(C33=\"\",\"\",C33-D33)","v":""},{"$f":"IF(C33=\"\",\"\",RANK(E33,E$32:E$47,1))","v":""},{"$f":"IF(C33=\"\",\"\",(F33-0.5)/COUNT(F$32:F$47))","v":""}]
[null,"3R1","","","","",""]
[null,"4R1","","","","",""]
[null,"1R2",{"$f":"IF(H7=\"\",\"\",H7)","v":""},{"$f":"IF(C36=\"\",\"\",L7)","v":""},"","",""]
[null,"2R2",{"$f":"IF(H8=\"\",\"\",H8)","v":""},{"$f":"IF(C37=\"\",\"\",L8)","v":""},"","",""]
[null,"3R2","",{"$f":"IF(C38=\"\",\"\",L8)","v":""},"","",""]
[null,"4R2","",{"$f":"IF(C39=\"\",\"\",L9)","v":""},"","",""]
[null,"1R3",{"$f":"IF(I7=\"\",\"\",I7)","v":""},{"$f":"IF(C40=\"\",\"\",L7)","v":""},"","",""]
[null,"2R3",{"$f":"IF(I8=\"\",\"\",I8)","v":""},{"$f":"IF(C41=\"\",\"\",L8)","v":""},"","",""]
[null,"3R3","","","","",""]
[null,"4R3","","","","",""]
[null,"1R4",{"$f":"IF(J7=\"\",\"\",J7)","v":""},{"$f":"IF(C44=\"\",\"\",L7)","v":""},"","",""]
[null,"2R4",{"$f":"IF(J8=\"\",\"\",J8)","v":""},{"$f":"IF(C45=\"\",\"\",L8)","v":""},"","",""]
[null,"3R4","","","","",""]
[null,"4R4","","","","",""]
[]
[]
[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."]