{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Plastic","Cans","Paper","Comparison"],"not_rendered":{"charts":11},"read":"whole","date_system":"1900"}

{"sheet":"Plastic","index":0,"n_rows":9,"n_cols":8,"rows_kept":9,"merged":[[1,1,1,6]]}
[]
[null,"Recycling Competition- Plastic"]
[null,null,"Week 1","Week 2","Week 3","Week 4","Total"]
[null,"Miss Ashton",{"$nulls":4},{"$f":"SUM(C4:F4)","v":0},{"$f":"SUM(C4:F4)","v":0}]
[null,"Miss Tori",{"$nulls":4},{"$f":"C5+D5+E5+F5","v":0}]
[null,"Miss Kattie",{"$nulls":4},{"$f":"SUM(C6:F6)","v":0}]
[null,"Miss Nelly ",{"$nulls":4},{"$f":"(C7+D7+E7+F7)","v":0}]
[null,"Total",{"$f":"SUM(C4:C7)","v":0},{"$f":"SUM(D4:D7)","v":0},{"$f":"SUM(E4:E7)","v":0},{"$f":"F4+F5+F6+F7","v":0}]
[null,"Average ",{"$f":"(C4+C5+C6+C7)/4","v":0},{"$f":"(D4+D5+D6+D7)/4","v":0},{"$f":"AVERAGE(E4:E7)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F4:F7)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Cans","index":1,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[1,1,1,6]]}
[]
[null,"Recycling Competition- Cans"]
[null,null,"Week 1","Week 2","Week 3","Week 4","Total"]
[null,"Miss Ashton",{"$nulls":4},{"$f":"SUM(C4:F4)","v":0}]
[null,"Miss Tori",{"$nulls":4},{"$f":"SUM(C5:F5)","v":0}]
[null,"Miss Kattie",{"$nulls":4},{"$f":"C6+D6+E6+F6","v":0}]
[null,"Miss Nelly ",{"$nulls":4},{"$f":"(C7+D7+E7+F7)","v":0}]
[null,"Total",{"$f":"SUM(C4:C7)","v":0},{"$f":"SUM(D4:D7)","v":0},{"$f":"SUM(E4:E7)","v":0},{"$f":"F4+F5+F6+F7","v":0}]
[null,"Average ",{"$f":"(C4+C5+C6+C7)/4","v":0},{"$f":"(D4+D5+D6+D7)/4","v":0},{"$f":"AVERAGE(E4:E7)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F4:F7)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Paper","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[1,1,1,6]]}
[]
[null,"Recycling Competition- Paper"]
[null,null,"Week 1","Week 2","Week 3","Week 4","Total"]
[null,"Miss Ashton",{"$nulls":4},{"$f":"SUM(C4:F4)","v":0}]
[null,"Miss Tori",{"$nulls":4},{"$f":"SUM(C5:F5)","v":0}]
[null,"Miss Kattie",{"$nulls":4},{"$f":"C6+D6+E6+F6","v":0}]
[null,"Miss Nelly ",{"$nulls":4},{"$f":"(C7+D7+E7+F7)","v":0}]
[null,"Total",{"$f":"SUM(C4:C7)","v":0},{"$f":"SUM(D4:D7)","v":0},{"$f":"SUM(E4:E7)","v":0},{"$f":"F4+F5+F6+F7","v":0}]
[null,"Average ",{"$f":"(C4+C5+C6+C7)/4","v":0},{"$f":"(D4+D5+D6+D7)/4","v":0},{"$f":"AVERAGE(E4:E7)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F4:F7)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Comparison","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[3,1,3,5]]}
[]
[]
[]
[null,"Comparision of Totals"]
[null,null,"Plastic","Cans","Paper","Total"]
[null,"Miss Ashton ",{"$nulls":3},{"$f":"C6+D6+E6","v":0}]
[null,"Miss Tori",{"$nulls":3},{"$f":"C7+D7+E7","v":0}]
[null,"Miss Kattie",{"$nulls":3},{"$f":"SUM(C8:E8)","v":0}]
[null,"Miss Nelly",{"$nulls":3},{"$f":"SUM(C9:E9)","v":0}]
[null,"Average:",{"$f":"(C6+C7+C8+C9)/4","v":0},{"$f":"AVERAGE(D6:D9)","v":{"$error":"#DIV/0!"}},{"$f":"(E6+E7+E8+E9)/4","v":0}]