{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Summary","Data Entry"],"not_rendered":{"charts":0,"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":"Summary","index":0,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Household Budget"]
[null,"www.piggybankbudget.com"]
[]
[null,"Balance"]
[null,"Balance ( Total Income - Expenses)",null,null,{"$f":"GETPIVOTDATA(\"$ / week\",$B$8)-GETPIVOTDATA(\"$ / week\",$E$8)","v":25.641838135582702}]
[]
[null,"Income","$ / week",null,"Expenses","$ / week"]
[null,"Jill's Work",423.07692307692309,null,"(blank)",0]
[null,"Annual Tax Return",48.07692307692308,null,"(blank)",0]
[null,"Net Pay",375,null,"Vehicles",142.63736263736266]
[null,"Jack's work",423.07692307692309,null,"Fuel",80]
[null,"Annual Tax Return",48.07692307692308,null,"Insurance",35.714285714285715]
[null,"Net Pay",375,null,"Maintenance",15.384615384615385]
[null,"Grand Total",846.15384615384619,null,"Registration",11.538461538461538]
[null,null,null,null,"Services",57.463400728945416]
[null,null,null,null,"Electricity",23.076923076923077]
[null,null,null,null,"Internet and landline",23.078698361412414]
[null,null,null,null,"Mobile Phone",11.307779290609927]
[null,null,null,null,"House",390.41124465195549]
[null,null,null,null,"Insurance",17.307692307692307]
[null,null,null,null,"Loan",346.18047542118626]
[null,null,null,null,"Rates",26.923076923076923]
[null,null,null,null,"Groceries",220]
[null,null,null,null,"Food",200]
[null,null,null,null,"Toiletries and cleaning",20]
[null,null,null,null,"Fun",10]
[null,null,null,null,"Weekly entertainment",10]
[null,null,null,null,"Grand Total",820.51200801826349]

{"sheet":"Data Entry","index":1,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,"Income"]
[null,"Category","Item","Amount","Frequency in Weeks","$/week"]
[null,"Jack's work","Net Pay",750,2,{"$f":"IF(Income[[#This Row],[Frequency in Weeks]]>0,Income[[#This Row],[Amount]]/Income[[#This Row],[Frequency in Weeks]],0)","v":375}]
[null,"Jack's work","Annual Tax Return",2500,52,{"$f":"IF(Income[[#This Row],[Frequency in Weeks]]>0,Income[[#This Row],[Amount]]/Income[[#This Row],[Frequency in Weeks]],0)","v":48.07692307692308}]
[null,"Jill's Work","Net Pay",750,2,{"$f":"IF(Income[[#This Row],[Frequency in Weeks]]>0,Income[[#This Row],[Amount]]/Income[[#This Row],[Frequency in Weeks]],0)","v":375}]
[null,"Jill's Work","Annual Tax Return",2500,52,{"$f":"IF(Income[[#This Row],[Frequency in Weeks]]>0,Income[[#This Row],[Amount]]/Income[[#This Row],[Frequency in Weeks]],0)","v":48.07692307692308}]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(109,Income[$/week])","v":846.15384615384619}]
[]
[null,"Expenses"]
[null,"Category","Item","Amount","Frequency in Weeks","$/week"]
[null,"Fun","Weekly entertainment",10,1,{"$f":"IF(Expenses[[#This Row],[Frequency in Weeks]]>0,Expenses[[#This Row],[Amount]]/Expenses[[#This Row],[Frequency in Weeks]],0)","v":10}]
[null,"Groceries","Food",200,1,{"$f":"IF(Expenses[[#This Row],[Frequency in Weeks]]>0,Expenses[[#This Row],[Amount]]/Expenses[[#This Row],[Frequency in Weeks]],0)","v":200}]
[null,"Groceries","Toiletries and cleaning",20,1,{"$f":"IF(Expenses[[#This Row],[Frequency in Weeks]]>0,Expenses[[#This Row],[Amount]]/Expenses[[#This Row],[Frequency in Weeks]],0)","v":20}]
[null,"House","Loan",1500,4.3330000000000002,{"$f":"IF(Expenses[[#This Row],[Frequency in Weeks]]>0,Expenses[[#This Row],[Amount]]/Expenses[[#This Row],[Frequency in Weeks]],0)","v":346.18047542118626}]
[null,"House","Rates",350,13,{"$f":"IF(Expenses[[#This Row],[Frequency in Weeks]]>0,Expenses[[#This Row],[Amount]]/Expenses[[#This Row],[Frequency in Weeks]],0)","v":26.923076923076923}]
[null,"House","Insurance",900,52,{"$f":"IF(Expenses[[#This Row],[Frequency in Weeks]]>0,Expenses[[#This Row],[Amount]]/Expenses[[#This Row],[Frequency in Weeks]],0)","v":17.307692307692307}]
[null,"Services","Electricity",300,13,{"$f":"IF(Expenses[[#This Row],[Frequency in Weeks]]>0,Expenses[[#This Row],[Amount]]/Expenses[[#This Row],[Frequency in Weeks]],0)","v":23.076923076923077}]
[null,"Services","Internet and landline",100,4.3330000000000002,{"$f":"IF(Expenses[[#This Row],[Frequency in Weeks]]>0,Expenses[[#This Row],[Amount]]/Expenses[[#This Row],[Frequency in Weeks]],0)","v":23.078698361412414}]
[null,"Services","Mobile Phone",49,4.3333000000000004,{"$f":"IF(Expenses[[#This Row],[Frequency in Weeks]]>0,Expenses[[#This Row],[Amount]]/Expenses[[#This Row],[Frequency in Weeks]],0)","v":11.307779290609927}]
[null,"Vehicles","Fuel",80,1,{"$f":"IF(Expenses[[#This Row],[Frequency in Weeks]]>0,Expenses[[#This Row],[Amount]]/Expenses[[#This Row],[Frequency in Weeks]],0)","v":80}]
[null,"Vehicles","Maintenance",200,13,{"$f":"IF(Expenses[[#This Row],[Frequency in Weeks]]>0,Expenses[[#This Row],[Amount]]/Expenses[[#This Row],[Frequency in Weeks]],0)","v":15.384615384615385}]
[null,"Vehicles","Insurance",500,14,{"$f":"IF(Expenses[[#This Row],[Frequency in Weeks]]>0,Expenses[[#This Row],[Amount]]/Expenses[[#This Row],[Frequency in Weeks]],0)","v":35.714285714285715}]
[null,"Vehicles","Registration",600,52,{"$f":"IF(Expenses[[#This Row],[Frequency in Weeks]]>0,Expenses[[#This Row],[Amount]]/Expenses[[#This Row],[Frequency in Weeks]],0)","v":11.538461538461538}]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(109,Expenses[$/week])","v":820.51200801826337}]
[]
[null,"Balance"]
[null,"Balance",null,null,null,"$/week"]
[null,"Total",null,null,null,{"$f":"Income[[#Totals],[$/week]]-Expenses[[#Totals],[$/week]]","v":25.641838135582816}]