{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Candy","Ice Cream","Pizza","Comparison"],"not_rendered":{"charts":11},"read":"whole","date_system":"1900"}

{"sheet":"Candy","index":0,"n_rows":12,"n_cols":7,"rows_kept":12,"merged":[[3,1,3,6],[4,1,4,6]]}
[]
[]
[]
[null,"Favorite 3rd Grade Halloween Candies"]
[]
[null,"Classes","M&Ms","KitKat","Air Heads","Snickers","Total # of Students"]
[{"$nulls":6},{"$f":"C7+D7+E7+F7","v":0}]
[{"$nulls":6},{"$f":"SUM(C8,D8,E8,F8)","v":0}]
[{"$nulls":6},{"$f":"C9+D9+E9+F9","v":0}]
[{"$nulls":6},{"$f":"C10+D10+E10+F10","v":0}]
[null,"Total",{"$f":"SUM(C7:C10)","v":0},{"$f":"SUM(D7:D10)","v":0},0,0,0]
[null,"Percentages",{"$f":"C11/G11","v":{"$error":"#DIV/0!"}},{"$f":"D11/G11","v":{"$error":"#DIV/0!"}},{"$f":"E11/G11","v":{"$error":"#DIV/0!"}},{"$f":"F11/G11","v":{"$error":"#DIV/0!"}}]

{"sheet":"Ice Cream","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"merged":[[3,1,3,6],[4,1,4,6]]}
[]
[]
[]
[null,"Favorite 3rd Grade Ice Cream Flavors"]
[]
[null,"Classes","Chocolate","Strawberry","Vanilla","Cookies and Cream","Total # of Students"]
[{"$nulls":6},{"$f":"C7+D7+E7+F7","v":0}]
[{"$nulls":6},{"$f":"SUM(C8,D8,E8,F8)","v":0}]
[{"$nulls":6},{"$f":"C9+D9+E9+F9","v":0}]
[{"$nulls":6},{"$f":"C10+D10+E10+F10","v":0}]
[null,"Total",{"$f":"SUM(C7:C10)","v":0},{"$f":"SUM(D7:D10)","v":0},0,0,0]
[null,"Percentages",{"$f":"C11/G11","v":{"$error":"#DIV/0!"}},{"$f":"D11/G11","v":{"$error":"#DIV/0!"}},{"$f":"E11/G11","v":{"$error":"#DIV/0!"}},{"$f":"F11/G11","v":{"$error":"#DIV/0!"}}]

{"sheet":"Pizza","index":2,"n_rows":12,"n_cols":7,"rows_kept":12,"merged":[[3,1,3,6],[4,1,4,6]]}
[]
[]
[]
[null,"Favorite 3rd Grade Pizza Toppings"]
[]
[null,"Classes","Pepperoni","Sausage","Cheese","Beef","Total # of Students"]
[{"$nulls":6},{"$f":"C7+D7+E7+F7","v":0}]
[{"$nulls":6},{"$f":"SUM(C8,D8,E8,F8)","v":0}]
[{"$nulls":6},{"$f":"C9+D9+E9+F9","v":0}]
[{"$nulls":6},{"$f":"C10+D10+E10+F10","v":0}]
[null,"Total",{"$f":"SUM(C7:C10)","v":0},{"$f":"SUM(D7:D10)","v":0},0,0,0]
[null,"Percentages",{"$f":"C11/G11","v":{"$error":"#DIV/0!"}},{"$f":"D11/G11","v":{"$error":"#DIV/0!"}},{"$f":"E11/G11","v":{"$error":"#DIV/0!"}},{"$f":"F11/G11","v":{"$error":"#DIV/0!"}}]

{"sheet":"Comparison","index":3,"n_rows":15,"n_cols":5,"rows_kept":15,"merged":[[3,1,3,4],[10,1,10,4]]}
[]
[]
[]
[null,"Most Popular Foods of 3rd Graders"]
[]
[null,"Foods","Pepperoni Pizza","Strawberry Ice Cream","M&Ms"]
[null,"# of Students",{"$f":"Pizza!C11","v":0},{"$f":"'Ice Cream'!D11","v":0},{"$f":"Candy!C11","v":0}]
[null,"Difference from total students",{"$f":"91-C7","v":91},{"$f":"91-D7","v":91},91]
[]
[]
[null,"Least Popular Foods of 3rd Graders"]
[]
[null,"Foods","Beef Pizza","Vanilla Ice Cream","Snickers"]
[null,"# of Students",{"$f":"Pizza!F11","v":0},{"$f":"'Ice Cream'!E11","v":0},{"$f":"Candy!F11","v":0}]
[null,"Difference from total students",{"$f":"91-C14","v":91},{"$f":"91-D14","v":91},91]