{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Budget Planner"],"not_rendered":{"charts":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Budget Planner","index":0,"n_rows":21,"n_cols":6,"rows_kept":21}
[null,"Vacation budget planner"]
[]
[null,"BUDGET PER CATEGORY"]
[null,"Categories","Planned budget","Budget in detail","Available / (Over)"]
[null,"Transportation",{"v":750,"d":"$750"},{"$f":"SUMIF(Table2[Category],Table1[[#This Row],[Categories]],Table2[Amount])","v":{"v":720,"d":"$720"}},{"$f":"IFERROR(Table1[[#This Row],[Planned budget]]-Table1[[#This Row],[Budget in detail]],\"\")","v":{"v":30,"d":"$30"}}]
[null,"Lodging",{"v":250,"d":"$250"},{"$f":"SUMIF(Table2[Category],Table1[[#This Row],[Categories]],Table2[Amount])","v":{"v":300,"d":"$300"}},{"$f":"IFERROR(Table1[[#This Row],[Planned budget]]-Table1[[#This Row],[Budget in detail]],\"\")","v":{"v":-50,"d":"($50)"}}]
[null,"Food",{"v":100,"d":"$100"},{"$f":"SUMIF(Table2[Category],Table1[[#This Row],[Categories]],Table2[Amount])","v":{"v":80,"d":"$80"}},{"$f":"IFERROR(Table1[[#This Row],[Planned budget]]-Table1[[#This Row],[Budget in detail]],\"\")","v":{"v":20,"d":"$20"}}]
[null,"Activities",{"v":500,"d":"$500"},{"$f":"SUMIF(Table2[Category],Table1[[#This Row],[Categories]],Table2[Amount])","v":{"v":500,"d":"$500"}},{"$f":"IFERROR(Table1[[#This Row],[Planned budget]]-Table1[[#This Row],[Budget in detail]],\"\")","v":{"v":0,"d":"$0"}}]
[null,"Souvenirs",{"v":50,"d":"$50"},{"$f":"SUMIF(Table2[Category],Table1[[#This Row],[Categories]],Table2[Amount])","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(Table1[[#This Row],[Planned budget]]-Table1[[#This Row],[Budget in detail]],\"\")","v":{"v":50,"d":"$50"}}]
[null,"Others",{"v":50,"d":"$50"},{"$f":"SUMIF(Table2[Category],Table1[[#This Row],[Categories]],Table2[Amount])","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(Table1[[#This Row],[Planned budget]]-Table1[[#This Row],[Budget in detail]],\"\")","v":{"v":50,"d":"$50"}}]
[null,"Contingency fund",{"v":200,"d":"$200"},{"$f":"SUMIF(Table2[Category],Table1[[#This Row],[Categories]],Table2[Amount])","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(Table1[[#This Row],[Planned budget]]-Table1[[#This Row],[Budget in detail]],\"\")","v":{"v":200,"d":"$200"}}]
[null,"Total Budget",{"$f":"SUBTOTAL(109,Table1[Planned budget])","v":{"v":1900,"d":"$1,900"}},{"$f":"SUBTOTAL(109,Table1[Budget in detail])","v":{"v":1600,"d":"$1,600"}},{"$f":"SUBTOTAL(109,Table1[Available / (Over)])","v":{"v":300,"d":"$300"}}]
[]
[null,"EXPENSE DETAILS"]
[null,"Description","Category","Quantity","Unit cost","Amount"]
[null,"Airfare","Transportation",2,{"v":300,"d":"$300"},{"$f":"IFERROR(Table2[[#This Row],[Quantity]]*Table2[[#This Row],[Unit cost]],\"\")","v":{"v":600,"d":"$600"}}]
[null,"Bus & taxi, 2 days","Transportation",4,{"v":30,"d":"$30"},{"$f":"IFERROR(Table2[[#This Row],[Quantity]]*Table2[[#This Row],[Unit cost]],\"\")","v":{"v":120,"d":"$120"}}]
[null,"Hotel, 2 nights","Lodging",2,{"v":150,"d":"$150"},{"$f":"IFERROR(Table2[[#This Row],[Quantity]]*Table2[[#This Row],[Unit cost]],\"\")","v":{"v":300,"d":"$300"}}]
[null,"Food, 2 days","Food",2,{"v":40,"d":"$40"},{"$f":"IFERROR(Table2[[#This Row],[Quantity]]*Table2[[#This Row],[Unit cost]],\"\")","v":{"v":80,"d":"$80"}}]
[null,"Day 1, concert tickets","Activities",2,{"v":250,"d":"$250"},{"$f":"IFERROR(Table2[[#This Row],[Quantity]]*Table2[[#This Row],[Unit cost]],\"\")","v":{"v":500,"d":"$500"}}]
[null,"Type in other expense items",{"$nulls":3},{"$f":"IFERROR(Table2[[#This Row],[Quantity]]*Table2[[#This Row],[Unit cost]],\"\")","v":{"v":0,"d":"$0"}}]