{"text_format":"3","workbook":"xls","n_sheets":9,"sheets":["Story","Penny Sheet","Frank Sheet","Ruble Sheet","Directions","Penny's SS","Frank's SS","Ruble's SS","Price List"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Story","index":0,"n_rows":6,"n_cols":3,"rows_kept":6,"merged":[[0,1,0,4],[2,2,2,3],[3,2,4,2],[5,1,5,5]],"flags":["formulas_cached_only"]}
[null,"Once Upon a Silver Dollar"]
[]
[null,"By:","Type Name Here"]
[]
[]
[null,"Help the children figure out how well they did with their summer stands.  Fill in the blanks on the following pages; create a spreadsheet for each child and a graph to show what they sold."]

{"sheet":"Penny Sheet","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"merged":[[0,1,0,3],[1,1,1,9],[3,1,3,10]],"flags":["formulas_cached_only"]}
[null,"Type Name Here"]
[null,"Penny’s Perfect Ice Cold Drinks"]
[]
[null,"Penny sold ice cold drinks to people who were fishing and swimming at Sunshine Lake.  She sold a total of 187 drinks."]
[null,"(Fill in the number of each; your total must be 187 drinks.)"]
[]
[null,null,"Pink Lemonade:"]
[null,null,"Fruit Punch:"]
[null,null,"Orange Juice:"]
[null,null,"Bottled Water:"]
[null,null,"Iced Tea:"]
[null,null,"Grape Slush:"]
[]
[null,null,"TOTAL SOLD:",null,null,0]

{"sheet":"Frank Sheet","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"merged":[[0,1,0,3],[1,1,1,9],[3,1,3,10]],"flags":["formulas_cached_only"]}
[null,"Type Name Here"]
[null,"Frank’s Fantastic Foods"]
[]
[null,"Frank sold fantastic foods at Sunshine Lake to the people who were hungry from swimming and fishing.  He sold a total 192 items."]
[null,"(Fill in the number of each item he sold.  Your total must be 192 items.)"]
[]
[null,null,"Potato Chips:"]
[null,null,"Hot dogs:"]
[null,null,"Chilidogs:"]
[null,null,"Giant Pretzels:"]
[null,null,"Snow cones:"]
[null,null,"Popsicles:"]
[]
[null,null,"TOTAL SOLD:",null,null,0]

{"sheet":"Ruble Sheet","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"merged":[[0,1,0,3],[1,1,1,9],[3,1,3,10]],"flags":["formulas_cached_only"]}
[null,"Type Name Here"]
[null,"Ruble’s Rafts and Toys"]
[]
[null,"Ruble rented rafts and toys to everyone to use at Sunshine Lake while they were swimming.  She rented 244 toys."]
[null,"(Fill in the number of each item that Ruble rented; your total must be 244.)"]
[]
[null,null,"Tubes:"]
[null,null,"Flippers:"]
[null,null,"Snorkels:"]
[null,null,"Face Masks:"]
[null,null,"Bucket and Pail:"]
[null,null,"5-foot rafts:"]
[]
[null,null,"TOTAL SOLD:",null,null,0]

{"sheet":"Directions","index":4,"n_rows":11,"n_cols":2,"rows_kept":11,"merged":[[2,1,3,9],[10,1,12,9]],"flags":["formulas_cached_only"]}
[null,"DIRECTIONS:"]
[]
[1,"Create an Excel Spreadsheet for each stand to show each item and how many were sold to the people at Sunshine Lake."]
[]
[2,"Turn each spreadsheet into a graph."]
[]
[null,"Penny wants to use a bar graph."]
[null,"Frank wants to use a pie chart."]
[null,"Ruble wants to use a line graph."]
[]
[3,"Grandmother and Grandfather said they would give a shiny new silver dollar to the child who earns the most money.  Use a calculator to help you figure out who earned the most money.  The cost of each item is listed on the price sheet."]

{"sheet":"Penny's SS","index":5,"n_rows":15,"n_cols":5,"rows_kept":15,"flags":["formulas_cached_only"]}
[null,"Type Name Here"]
[null,"Penny's Perfect Ice Cold Drinks"]
[]
[null,"Drink Selection","# sold","Price","Total"]
[null,"Pink Lemonade"]
[null,"Fruit Punch"]
[null,"Orange Juice"]
[null,"Bottled Water"]
[null,"Iced Tea"]
[null,"Grape Slush"]
[]
[null,"Totals",0,null,{"v":0,"d":"$0.00"}]
[]
[]
[null,"Penny wants to use a bar graph."]

{"sheet":"Frank's SS","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"flags":["formulas_cached_only"]}
[null,"Type Name Here"]
[null,"Frank's Fantastic Foods"]
[]
[null,"Food Selection","# sold","Price","Total"]
[null,"Potato Chips"]
[null,"Hot Dogs"]
[null,"Chilidogs"]
[null,"Giant Pretzels"]
[null,"Snow Cones"]
[null,"Popsicles"]
[]
[null,"Totals",0,null,{"v":0,"d":"$0.00"}]
[]
[null,"Frank wants to use a pie chart."]

{"sheet":"Ruble's SS","index":7,"n_rows":15,"n_cols":5,"rows_kept":15,"flags":["formulas_cached_only"]}
[null,"Type Name Here"]
[null,"Ruble's Rafts and Toys"]
[]
[null,"Toy Selection","# sold","Price","Total"]
[null,"Tubes"]
[null,"Flippers"]
[null,"Snorkels"]
[null,"Face Masks"]
[null,"Bucket and Pail"]
[null,"5-foot rafts"]
[]
[null,"Totals",0,null,{"v":0,"d":"$0.00"}]
[]
[]
[null,"Ruble wants to use a line graph."]

{"sheet":"Price List","index":8,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[0,1,0,2],[8,4,9,5],[8,6,9,7],[11,4,12,5],[11,6,12,7],[14,4,15,5],[14,6,15,7],[17,3,18,9],[20,5,22,7]],"flags":["formulas_cached_only"]}
[null,"Type Name Here"]
[]
[null,"PRICE LIST"]
[]
[null,"Pink Lemonade","$1.00/glass"]
[null,"Fruit Punch","$1.00/glass"]
[null,"Orange Juice","$1.25/glass"]
[null,"Bottled Water","$1.50/bottle"]
[null,"Iced Tea","$1.00/glass",null,"Penny earned:"]
[null,"Grape Slush","$2.25/slush"]
[]
[null,"Potato Chips",".50/bag",null,"Frank earned:"]
[null,"Hot Dog","$1.00 each"]
[null,"Chilidog","$1.50 each"]
[null,"Giant Pretzel",".75 each",null,"Ruble earned:"]
[null,"Snow cones","$2.00 each"]
[null,"Popsicles","$1.00 each"]
[{"$nulls":3},"Who earned the silver dollar?"]
[null,"Tube","$2.00 each"]
[null,"Flippers","$1.00/pair"]
[null,"Snorkel","$1.00 each"]
[null,"Face Mask",".50 each"]
[null,"Bucket and Pail",".25 each"]
[null,"5-foot raft",".75 each"]
[null,"9-foot raft","$1.50 each"]