{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Documentation","Fundraiser Data","Fundraiser Chart"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Fundraiser Chart","index":2,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Documentation","index":0,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["OMG Cloggers"]
[]
["Author:"]
["Date:"]
["Purpose:","To analyze the annual holiday fruit fundraiser for the cloggers"]
[]
["Defined Names:"]
["ApplesOrdered","='Fundraiser Data'!$A$3"]
["ApplesSold","='Fundraiser Data'!$E$7"]
["GrapefruitOrdered","='Fundraiser Data'!$B$6"]
["GrapefruitSold","='Fundraiser Data'!$E$6"]
["OrangesSold","='Fundraiser Data'!$E$5"]
["ThreeFruitOrdered","='Fundraiser Data'!$B$9"]
["ThreeFruitSold","='Fundraiser Data'!$E$9"]
["TwoFruitOrdered","='Fundraiser Data'!$B$8"]
["TwoFruitSold","='Fundraiser Data'!$E$8"]

{"sheet":"Fundraiser Data","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["OMG Cloggers"]
["Holiday Fruit Fundraiser"]
[]
["Product","Quantity Ordered","Cost","Total Cost","Quantity   Sold","Price to Customer","Total $ Collected","Profit"]
["Oranges",1000,20,{"$f":"B5*C5","v":20000},995,25,{"$f":"OrangesSold*F5","v":24875},{"$f":"D5-G5","v":-4875}]
["Grapefruit",1000,20,{"$f":"B6*C6","v":20000},950,25,{"$f":"GrapefruitSold*F6","v":23750},{"$f":"D6-G6","v":-3750}]
["Apples",1000,30,30000,890,35,{"$f":"ApplesSold*F7","v":31150},-1150]
["Two Fruit (O/G)",500,30,15000,450,35,{"$f":"TwoFruitSold*F8","v":15750},-750]
["Three Fruit (O/G/A)",400,30,12000,375,35,{"$f":"ThreeFruitSold*F9","v":13125},-1125]
[null,null,null,{"$f":"SUM(D5:D9)","v":97000},null,null,{"$f":"SUM(G5:G9)","v":108650},{"$f":"SUM(H5:H9)","v":-11650}]