{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Monthly_Statement","Budget","Actual Income","Actual Expense","Income Category","Expense Category","Users"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":2},"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":"Monthly_Statement","index":0,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Monthly Statement"]
["Beginning Date","2015-04-01"]
["Ending Date","2015-04-30"]
[]
[null,"Estimated","Actual"]
["Income",3000,{"$f":"GETPIVOTDATA(\"Amount\",$F$10,\"Date\",4)","v":3050}]
["Expenses",1000,{"$f":"GETPIVOTDATA(\"Amount\",$A$10,\"Date\",4)","v":201.02}]
["Saving",2000,2848.98]
[]
["Total Amount","Column Labels",null,null,"Total Amount","Column Labels"]
["Row Labels","Apr",null,null,"Row Labels","Apr"]
["Government Services",5,null,null,"Interest Income",50]
["Merchandise",61.9,null,null,"Salary",3000]
["Restaurants",24.740000000000002,null,null,"Grand Total",3050]
["Supermarkets",19.38]
["Travel/ Entertainment",90]
["Grand Total",201.02]

{"sheet":"Budget","index":1,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Beginning Date","Ending Date","Estimated Income","Estimated Expense","Estimated Saving"]
["2015-04-01","2015-04-30",3000,1000,2000]

{"sheet":"Actual Income","index":2,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Date","Description","Amount","Category","Earned By"]
["2015-04-14","Salary for April",3000,"Salary",1]
["2015-04-14","Bank Interest",50,"Interest Income",2]

{"sheet":"Actual Expense","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Date","Description","Amount","Category","Used By"]
["2015-04-01","soft drink",1.5,"Supermarkets",1]
["2015-04-02","NOODLE KING PROVO UT                    ",9.0299999999999994,"Restaurants"]
["2015-04-03","CINEMARK THEATRES 1041 OREM UT          ",46.25,"Travel/ Entertainment"]
["2015-04-04","MACEYS PROVO SSS PROVO UT               ",8.9499999999999993,"Supermarkets"]
["2015-04-04","PROVO UT RECREATION CE PROVO UT         ",5,"Government Services"]
["2015-04-07","MACEYS PROVO SSS PROVO UT               ",1.84,"Supermarkets"]
["2015-04-08","ASIAN MARKET PROVO UT                   ",7.09,"Supermarkets"]
["2015-04-08","CINEMARK THEATRES 1041 OREM UT          ",43.75,"Travel/ Entertainment"]
["2015-04-08","RICE GARDEN 052 PROVO UT                ",14.63,"Restaurants"]
["2015-04-09","HERFF JONES COLLEGE CHAMPAIGN IL        ",61.9,"Merchandise"]
["2015-04-09","MCDONALD'S F10437 PROVO UT              ",1.08,"Restaurants"]

{"sheet":"Income Category","index":4,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Category","Description"]
["Salary","Salary earned"]
["Interest Income","interest earned "]

{"sheet":"Expense Category","index":5,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Category","Description"]
["Restaurants"]
["Travel/ Entertainment"]
["Supermarkets"]
["Merchandise"]
["Government Services"]

{"sheet":"Users","index":6,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["UserID","Name"]
[1,"Ben Kou"]
[2,"Xiao Shao"]
[3,"Other"]