{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Plant One","Plant Two","Plant Three","Comparison"],"not_rendered":{"charts":18},"read":"whole","date_system":"1900"}

{"sheet":"Plant One","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"merged":[[3,1,3,7],[13,1,13,7]]}
[]
[]
[]
[null,"Plant One Measurements (Week 1)"]
[]
[null,"Students","Day 1","Day 2","Day 3","Day 4","Day 5","Average Weekly Growth"]
[null,"Sally",{"$nulls":5},{"$f":"(C7+D7+E7+F7+G7)/5","v":{"v":0,"d":"0.00"}}]
[null,"John",{"$nulls":5},{"$f":"AVERAGE(C8:G8)","v":{"$error":"#DIV/0!"}}]
[null,"Jace",{"$nulls":5},{"$f":"AVERAGE(C9:G9)","v":{"$error":"#DIV/0!"}}]
[null,"Caroline",{"$nulls":5},{"$f":"AVERAGE(C10:G10)","v":{"$error":"#DIV/0!"}}]
[null,"Chandler",{"$nulls":5},{"$f":"AVERAGE(C11:G11)","v":{"$error":"#DIV/0!"}}]
[null,"Average Daily Growth (inches) ",{"$f":"(C7+C8+C9+C10+C11)/5","v":{"v":0,"d":"0.00"}},{"$f":"(D7+D8+D9+D10+D11)/5","v":{"v":0,"d":"0.00"}},{"$f":"AVERAGE(E7:E11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F7:F11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G7:G11)","v":{"$error":"#DIV/0!"}},{"$f":"(H7+H8+H9+H10+H11)/5","v":{"$error":"#DIV/0!"}}]
[]
[null,"Plant One Measurements (Week 2)"]
[]
[null,"Students","Day 1","Day 2","Day 3","Day 4","Day 5","Average Weekly Growth (inches)"]
[null,"Sally",{"$nulls":5},{"$f":"AVERAGE(C17:G17)","v":{"$error":"#DIV/0!"}}]
[null,"John",{"$nulls":5},{"$f":"AVERAGE(C18:G18)","v":{"$error":"#DIV/0!"}}]
[null,"Jace",{"$nulls":5},{"$f":"AVERAGE(C19:G19)","v":{"$error":"#DIV/0!"}}]
[null,"Caroline",{"$nulls":5},{"$f":"AVERAGE(C20:G20)","v":{"$error":"#DIV/0!"}}]
[null,"Chandler",{"$nulls":5},{"$f":"AVERAGE(C21:G21)","v":{"$error":"#DIV/0!"}}]
[null,"Average Daily Growth (Inches)",{"$f":"(C17+C18+C19+C20+C21)/5","v":0},{"$f":"(D17+D18+D19+D20+D21)/5","v":0},{"$f":"(E17+E18+E19+E20+E21)/5","v":0},{"$f":"(F17+F18+F19+F20+F21)/5","v":0},{"$f":"(G17+G18+G19+G20+G21)/5","v":0},{"$f":"AVERAGE(H17:H21)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Plant Two","index":1,"n_rows":22,"n_cols":8,"rows_kept":22,"merged":[[3,1,3,7],[13,1,13,7]]}
[]
[]
[]
[null,"Plant Two Measurements (Week 1)"]
[]
[null,"Students","Day 1","Day 2","Day 3","Day 4","Day 5","Average Weekly Growth"]
[null,"Olivia",{"$nulls":5},{"$f":"(C7+D7+E7+F7+G7)/5","v":{"v":0,"d":"0.00"}}]
[null,"Carinna",{"$nulls":5},{"$f":"AVERAGE(C8:G8)","v":{"$error":"#DIV/0!"}}]
[null,"Michaela",{"$nulls":5},{"$f":"AVERAGE(C9:G9)","v":{"$error":"#DIV/0!"}}]
[null,"Danny",{"$nulls":5},{"$f":"AVERAGE(C10:G10)","v":{"$error":"#DIV/0!"}}]
[null,"Sam",{"$nulls":5},{"$f":"AVERAGE(C11:G11)","v":{"$error":"#DIV/0!"}}]
[null,"Average Daily Growth (inches) ",{"$f":"(C7+C8+C9+C10+C11)/5","v":{"v":0,"d":"0.00"}},{"$f":"(D7+D8+D9+D10+D11)/5","v":{"v":0,"d":"0.00"}},{"$f":"AVERAGE(E7:E11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F7:F11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G7:G11)","v":{"$error":"#DIV/0!"}},{"$f":"(H7+H8+H9+H10+H11)/5","v":{"$error":"#DIV/0!"}}]
[]
[null,"Plant Two Measurements (Week 2)"]
[]
[null,"Students","Day 1","Day 2","Day 3","Day 4","Day 5","Average Weekly Growth (inches)"]
[null,"Olivia",{"$nulls":5},{"$f":"AVERAGE(C17:G17)","v":{"$error":"#DIV/0!"}}]
[null,"Carinna",{"$nulls":5},{"$f":"AVERAGE(C18:G18)","v":{"$error":"#DIV/0!"}}]
[null,"Michaela",{"$nulls":5},{"$f":"AVERAGE(C19:G19)","v":{"$error":"#DIV/0!"}}]
[null,"Danny",{"$nulls":5},{"$f":"AVERAGE(C20:G20)","v":{"$error":"#DIV/0!"}}]
[null,"Sam",{"$nulls":5},{"$f":"AVERAGE(C21:G21)","v":{"$error":"#DIV/0!"}}]
[null,"Average Daily Growth (Inches)",{"$f":"(C17+C18+C19+C20+C21)/5","v":0},{"$f":"(D17+D18+D19+D20+D21)/5","v":0},{"$f":"(E17+E18+E19+E20+E21)/5","v":0},{"$f":"(F17+F18+F19+F20+F21)/5","v":0},{"$f":"(G17+G18+G19+G20+G21)/5","v":0},{"$f":"AVERAGE(H17:H21)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Plant Three","index":2,"n_rows":22,"n_cols":8,"rows_kept":22,"merged":[[3,1,3,7],[13,1,13,7]]}
[]
[]
[]
[null,"Plant Three Measurements (Week 1)"]
[]
[null,"Students","Day 1","Day 2","Day 3","Day 4","Day 5","Average Weekly Growth"]
[null,"Corey",{"$nulls":5},{"$f":"(C7+D7+E7+F7+G7)/5","v":{"v":0,"d":"0.00"}}]
[null,"Jensen",{"$nulls":5},{"$f":"AVERAGE(C8:G8)","v":{"$error":"#DIV/0!"}}]
[null,"Dean",{"$nulls":5},{"$f":"AVERAGE(C9:G9)","v":{"$error":"#DIV/0!"}}]
[null,"Sara",{"$nulls":5},{"$f":"AVERAGE(C10:G10)","v":{"$error":"#DIV/0!"}}]
[null,"Erika",{"$nulls":5},{"$f":"AVERAGE(C11:G11)","v":{"$error":"#DIV/0!"}}]
[null,"Average Daily Growth (inches) ",{"$f":"(C7+C8+C9+C10+C11)/5","v":{"v":0,"d":"0.00"}},{"$f":"(D7+D8+D9+D10+D11)/5","v":{"v":0,"d":"0.00"}},{"$f":"AVERAGE(E7:E11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F7:F11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G7:G11)","v":{"$error":"#DIV/0!"}},{"$f":"(H7+H8+H9+H10+H11)/5","v":{"$error":"#DIV/0!"}}]
[]
[null,"Plant Three Measurements (Week 2)"]
[]
[null,"Students","Day 1","Day 2","Day 3","Day 4","Day 5","Average Weekly Growth (inches)"]
[null,"Corey",{"$nulls":5},{"$f":"AVERAGE(C17:G17)","v":{"$error":"#DIV/0!"}}]
[null,"Jensen",{"$nulls":5},{"$f":"AVERAGE(C18:G18)","v":{"$error":"#DIV/0!"}}]
[null,"Dean",{"$nulls":5},{"$f":"AVERAGE(C19:G19)","v":{"$error":"#DIV/0!"}}]
[null,"Sara",{"$nulls":5},{"$f":"AVERAGE(C20:G20)","v":{"$error":"#DIV/0!"}}]
[null,"Erika",{"$nulls":5},{"$f":"AVERAGE(C21:G21)","v":{"$error":"#DIV/0!"}}]
[null,"Average Daily Growth (Inches)",{"$f":"(C17+C18+C19+C20+C21)/5","v":0},{"$f":"(D17+D18+D19+D20+D21)/5","v":0},{"$f":"(E17+E18+E19+E20+E21)/5","v":0},{"$f":"(F17+F18+F19+F20+F21)/5","v":0},{"$f":"(G17+G18+G19+G20+G21)/5","v":0},{"$f":"AVERAGE(H17:H21)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Comparison","index":3,"n_rows":21,"n_cols":5,"rows_kept":21,"merged":[[3,1,3,5],[13,1,13,5]]}
[]
[]
[]
[null,"Weekly Average Comparison(Week One)"]
[null,null,"Plant One","Plant Two","Plant Three"]
[null,"Student 1",{"$f":" 'Plant One'!H7","v":{"v":0,"d":"0.00"}},{"$f":"'Plant Two'!H7","v":{"v":0,"d":"0.00"}},{"$f":"'Plant Three'!H7","v":{"v":0,"d":"0.00"}}]
[null,"Student 2",{"$f":"'Plant One'!H8","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Two'!H8","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Three'!H8","v":{"$error":"#DIV/0!"}}]
[null,"Student 3",{"$f":"'Plant One'!H9","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Two'!H9","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Three'!H9","v":{"$error":"#DIV/0!"}}]
[null,"Student 4",{"$f":"'Plant One'!H10","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Two'!H10","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Three'!H10","v":{"$error":"#DIV/0!"}}]
[null,"Student 5",{"$f":"'Plant One'!H11","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Two'!H11","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Three'!H11","v":{"$error":"#DIV/0!"}}]
[null,"Average of all averages",{"$f":"AVERAGE(C6:C10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D6:D10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E6:E10)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Weekly Average Comparison (Week Two)"]
[null,null,"Plant One","Plant Two","Plant Three"]
[null,"Student 1",{"$f":"'Plant One'!H17","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Two'!H17","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Three'!H17","v":{"$error":"#DIV/0!"}}]
[null,"Student 2",{"$f":"'Plant One'!H18","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Two'!H18","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Three'!H18","v":{"$error":"#DIV/0!"}}]
[null,"Student 3",{"$f":"'Plant One'!H19","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Two'!H19","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Three'!H19","v":{"$error":"#DIV/0!"}}]
[null,"Student 4",{"$f":"'Plant One'!H20","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Two'!H20","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Three'!H20","v":{"$error":"#DIV/0!"}}]
[null,"Student 5",{"$f":"'Plant One'!H21","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Two'!H21","v":{"$error":"#DIV/0!"}},{"$f":"'Plant Three'!H21","v":{"$error":"#DIV/0!"}}]
[null,"Average of all averages",{"$f":"AVERAGE(C16:C20)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D16:D20)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E16:E20)","v":{"$error":"#DIV/0!"}}]