{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Welcome","My Budgeting Dashboard","Money In","Money Out"],"not_rendered":{"charts":3,"images":4,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":1},"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":"Welcome","index":0,"n_rows":19,"n_cols":20,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"My Budgeting Dashboard","index":1,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[21,1,21,3],[0,1,0,2],[20,1,20,2],[2,1,2,2]]}
[null,"My Budget Dashboard"]
[]
[null,"Money in vs Money Out",null,null,null,"Money Spent by Category"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Percentage of Money Spent",null,{"$f":"TotalMoneyOut/TotalMoneyIn","v":0.41333333333333333}]
[]
[]
[null,"Money In","Money Out","Balance Available"]
[null,{"$f":"TotalMoneyIn","v":15000},{"$f":"TotalMoneyOut","v":6200},{"$f":"TotalMoneyIn-TotalMoneyOut","v":8800}]

{"sheet":"Money In","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"Money In"]
[]
[null,"Description","Category","Amount"]
[null,"Salary","Misc",15000]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUBTOTAL(109,moneyIn[Amount])","v":15000}]

{"sheet":"Money Out","index":3,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"Money Out"]
[null,null,null,null,null,null,"Category Calculation"]
[null,"Description","Category","Amount",null,null,"Categories","Amount Spent"]
[null,"Gifts for Family","Gifts",3500,null,null,"Gifts",3600]
[null,"Concert Tickets ","Entertainment",200,null,null,"Entertainment",200]
[null,"Teacher Gifts","Gifts",100,null,null,"Travel",2400]
[null,"Petrol for Vacation","Travel",400,null,null,"Grand Total",6200]
[null,"Vacation accomadation","Travel",2000]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUBTOTAL(109,Moneyout[Amount])","v":6200}]