{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["ToC","Budget 2009","Budget 2010","Budget 2011","Data 2009","Data 2010","Data 2011","Calculation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":3},"unopened":[],"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":"ToC","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Budget 2009","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Budget 2010","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Budget 2011","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Data 2009","index":4,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Date","Item","Price"]
["2009-10-28","A",92.5]
["2009-04-18","B",23.9]
["2009-05-03","C",61.5]
["2009-11-10","A",60.2]
["2009-08-16","B",17.399999999999999]
["2009-01-05","C",23.8]
["2009-05-09","A",36.5]
["2009-11-22","B",32.200000000000003]
["2009-10-21","C",29.5]
["2009-09-28","A",47.4]
["2009-02-28","B",16.5]
["2009-02-12","C",70.400000000000006]
["2009-07-25","A",90.2]
["2009-03-04","B",69.599999999999994]
["2009-01-19","C",34.799999999999997]
["2009-08-10","A",13.7]

{"sheet":"Data 2010","index":5,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Date","Item","Price"]
[{"$f":"DATE(2009,1,1)+ROUND(RAND()*365,0)","v":"2009-12-13"},"A",{"$f":"ROUND(RAND()*100,1)","v":93.8}]
[{"$f":"DATE(2009,1,1)+ROUND(RAND()*365,0)","v":"2009-03-13"},"B",{"$f":"ROUND(RAND()*100,1)","v":74.7}]
["2009-12-23","C",10.5]
["2009-10-27","A",42.2]
["2009-08-28","B",73.5]
["2009-04-14","C",96.9]
["2009-02-19","A",70.400000000000006]
["2009-02-22","B",90.6]
["2009-07-11","C",9.6]
["2009-06-06","A",71]
["2009-11-15","B",28.5]
["2009-12-30","C",62.6]
["2009-10-01","A",69.900000000000006]
["2009-10-08","B",67.7]
["2009-11-12","C",70.900000000000006]
["2009-02-17","A",61.1]

{"sheet":"Data 2011","index":6,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Date","Item","Price"]
[{"$f":"DATE(2009,1,1)+ROUND(RAND()*365,0)","v":"2009-03-22"},"A",{"$f":"ROUND(RAND()*100,1)","v":31}]
[{"$f":"DATE(2009,1,1)+ROUND(RAND()*365,0)","v":"2009-11-22"},"B",{"$f":"ROUND(RAND()*100,1)","v":16.600000000000001}]
["2009-12-13","C",33.4]
["2009-04-12","A",82.6]
["2009-04-29","B",58.6]
["2009-08-11","C",39.700000000000003]
["2009-03-31","A",66.599999999999994]
["2009-07-20","B",25.5]
["2009-09-10","C",57.8]
["2009-07-27","A",7.1]
["2009-01-28","B",75.400000000000006]
["2009-03-15","C",97.9]
["2009-11-04","A",19.899999999999999]
["2009-01-12","B",55.9]
["2009-11-15","C",44]
["2009-03-29","A",55.7]

{"sheet":"Calculation","index":7,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Total 2009:",{"$f":"SUM(Table1[Price])","v":720.1}]
[null,"Total 2010:",{"$f":"SUM(Table2[Price])","v":993.90000000000009}]
[null,"Total 2011:",{"$f":"SUM(Table3[Price])","v":767.7}]