{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Mr. Pearson's Class","Ms. Blankenship's Class","Ms. Kathryn's Class","Ms. Hay's Class","Comparison"],"not_rendered":{"charts":15},"read":"whole","date_system":"1900"}

{"sheet":"Mr. Pearson's Class","index":0,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[2,3,2,8]]}
[]
[]
[{"$nulls":3},"Number of Cans Collected in Mr. Pearson's Class"]
[]
[{"$nulls":3},"Students ","Fruit","Veggies","Meat ","Soups","Total # of Cans"]
[{"$nulls":3},"Girls",{"$nulls":4},{"$f":"(E6+F6+G6+H6)","v":0}]
[{"$nulls":3},"Boys",{"$nulls":4},{"$f":"(E7+F7+G7+H7)","v":0}]
[{"$nulls":3},"Total # of Cans",{"$f":"(E6+E7)","v":0},{"$f":"(F6+F7)","v":0},0,0,0]
[{"$nulls":3},"Weight of Cans",{"$f":"(0.6*E8)","v":0},{"$f":"(0.6*F8)","v":0},0,0,0]
[{"$nulls":3},"Average # of Cans",{"$f":"AVERAGE(E6:E7)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F6:F7)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]

{"sheet":"Ms. Blankenship's Class","index":1,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[2,3,2,8]]}
[]
[]
[{"$nulls":3},"Number of Cans Collected in Ms. Blankenship's Class"]
[]
[{"$nulls":3},"Students ","Fruit","Veggies","Meat ","Soups","Total # of Cans"]
[{"$nulls":3},"Girls",{"$nulls":4},{"$f":"(E6+F6+G6+H6)","v":0}]
[{"$nulls":3},"Boys",{"$nulls":4},{"$f":"(E7+F7+G7+H7)","v":0}]
[{"$nulls":3},"Total # of Cans",{"$f":"(E6+E7)","v":0},{"$f":"(F6+F7)","v":0},0,0,0]
[{"$nulls":3},"Weight of Cans",{"$f":"(0.6*E8)","v":0},{"$f":"(0.6*F8)","v":0},0,0,0]
[{"$nulls":3},"Average # of Cans",{"$f":"AVERAGE(E6:E7)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F6:F7)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]

{"sheet":"Ms. Kathryn's Class","index":2,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[2,3,2,8]]}
[]
[]
[{"$nulls":3},"Number of Cans Collected in Ms. Kathryn's Class"]
[]
[{"$nulls":3},"Students ","Fruit","Veggies","Meat ","Soups","Total # of Cans"]
[{"$nulls":3},"Girls",{"$nulls":4},{"$f":"(E6+F6+G6+H6)","v":0}]
[{"$nulls":3},"Boys",{"$nulls":4},{"$f":"(E7+F7+G7+H7)","v":0}]
[{"$nulls":3},"Total # of Cans",{"$f":"(E6+E7)","v":0},{"$f":"(F6+F7)","v":0},0,0,0]
[{"$nulls":3},"Weight of Cans",{"$f":"(0.6*E8)","v":0},{"$f":"(0.6*F8)","v":0},0,0,0]
[{"$nulls":3},"Average # of Cans",{"$f":"AVERAGE(E6:E7)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F6:F7)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]

{"sheet":"Ms. Hay's Class","index":3,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[2,3,2,8]]}
[]
[]
[{"$nulls":3},"Number of Cans Collected in Ms. Hay's Class"]
[]
[{"$nulls":3},"Students ","Fruit","Veggies","Meat ","Soups","Total # of Cans"]
[{"$nulls":3},"Girls",{"$nulls":4},{"$f":"(E6+F6+G6+H6)","v":0}]
[{"$nulls":3},"Boys",{"$nulls":4},{"$f":"(E7+F7+G7+H7)","v":0}]
[{"$nulls":3},"Total # of Cans",{"$f":"(E6+E7)","v":0},{"$f":"(F6+F7)","v":0},0,0,0]
[{"$nulls":3},"Weight of Cans",{"$f":"(0.6*E8)","v":0},{"$f":"(0.6*F8)","v":0},0,0,0]
[{"$nulls":3},"Average # of Cans",{"$f":"AVERAGE(E6:E7)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F6:F7)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]

{"sheet":"Comparison","index":4,"n_rows":10,"n_cols":8,"rows_kept":10,"merged":[[2,2,2,7]]}
[]
[]
[null,null,"Comparison of Cans Collected Between Classes"]
[]
[null,null,"Classrooms","Fruits","Veggies","Meats","Soups","# of Cans Collected"]
[null,null,"Ms. Hay's Class",{"$f":"'Ms. Hay''s Class'!E8","v":0},{"$f":"'Ms. Hay''s Class'!F8","v":0},{"$f":"'Ms. Hay''s Class'!G8","v":0},{"$f":"'Ms. Hay''s Class'!H8","v":0},{"$f":"'Ms. Hay''s Class'!I8","v":0}]
[null,null,"Ms. Blankenships's Class",{"$f":"'Ms. Blankenship''s Class'!E8","v":0},{"$f":"'Ms. Blankenship''s Class'!F8","v":0},{"$f":"'Ms. Blankenship''s Class'!G8","v":0},{"$f":"'Ms. Blankenship''s Class'!H8","v":0},{"$f":"'Ms. Blankenship''s Class'!I8","v":0}]
[null,null,"Mr. Pearson's Class",{"$f":"'Mr. Pearson''s Class'!E8","v":0},{"$f":"'Mr. Pearson''s Class'!F8","v":0},{"$f":"'Mr. Pearson''s Class'!G8","v":0},{"$f":"'Mr. Pearson''s Class'!H8","v":0},{"$f":"'Mr. Pearson''s Class'!I8","v":0}]
[null,null,"Ms. Kathryn's Class",{"$f":"'Ms. Kathryn''s Class'!E8","v":0},{"$f":"'Ms. Kathryn''s Class'!F8","v":0},{"$f":"'Ms. Kathryn''s Class'!G8","v":0},{"$f":"'Ms. Kathryn''s Class'!H8","v":0},{"$f":"'Ms. Kathryn''s Class'!I8","v":0}]
[null,null,"Total",{"$f":"(D6+D7+D8+D9)","v":0},{"$f":"(E6+E7+E8+E9)","v":0},{"$f":"(F6+F7+F8+F9)","v":0},{"$f":"(G6+G7+G8+G9)","v":0},{"$f":"(H6+H7+H8+H9)","v":0}]