{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Planner","Codes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"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":"Planner","index":0,"n_rows":60,"n_cols":13,"rows_kept":60,"cut":false,"hidden":false,"merged":[[1,10,1,12]]}
[]
[null,null,"Instructions: Complete $ amount and frequency for each category. ",null,null,null,null,null,null,null,"Category Totals"]
[null,"CATEGORY","SUB-CATEGORY",null,"$ AMOUNT",null,"FREQUENCY",null,"PER YEAR",null,"YEARLY",null,"WEEKLY"]
[]
[]
[null,"Income","Wages & salaries (after tax)",null,0,null,null,null,{"$f":"IF(E6=\"\",\"na\",Codes!G2*E6)","v":0},null,{"$f":"SUM(I6:I10)","v":0},null,{"$f":"K6/52","v":0}]
[null,null,"Centrelink/Family Benefit",null,0,null,null,null,{"$f":"IF(E7=\"\",\"na\",Codes!G3*E7)","v":0}]
[null,null,"Investment income",null,0,null,null,null,{"$f":"IF(E8=\"\",\"na\",Codes!G4*E8)","v":0}]
[null,null,"Other",null,0,null,null,null,{"$f":"IF(E9=\"\",\"na\",Codes!G5*E9)","v":0}]
[]
[null,"Expenses","Mortgage / Rent",null,0,null,null,null,{"$f":"IF(E11=\"\",\"na\",Codes!G7*E11)","v":0},null,{"$f":"SUM(I11:I16)","v":0},null,{"$f":"K11/52","v":0}]
[null," - Fixed Items","Council Rates/Body Corp.Fees",null,0,null,null,null,{"$f":"IF(E12=\"\",\"na\",Codes!G8*E12)","v":0}]
[null,null,"School fees / Childcare",750,0,null,null,null,{"$f":"SUM(I11:I12)","v":0}]
[null,null,"Investment loan payments",null,0,null,null,null,{"$f":"IF(E14=\"\",\"na\",Codes!G10*E14)","v":0}]
[null,null,"Other",null,null,null,null,null,{"$f":"IF(E15=\"\",\"na\",Codes!G11*E15)","v":"na"}]
[]
[null," - Discretionary","Groceries",null,0,null,null,null,{"$f":"IF(E17=\"\",\"na\",Codes!G13*E17)","v":0},null,{"$f":"SUM(I17:I32)","v":0},null,{"$f":"K17/52","v":0}]
[null,"    Items","Clothes",null,0,null,null,null,{"$f":"IF(E18=\"\",\"na\",Codes!G14*E18)","v":0}]
[null,null,"Shoes / Accessories",null,0,null,null,null,{"$f":"IF(E19=\"\",\"na\",Codes!G15*E19)","v":0}]
[null,null,"Books/Subscriptions",null,0,null,null,null,{"$f":"IF(E20=\"\",\"na\",Codes!G16*E20)","v":0}]
[null,null,"Video & DVD rental",null,0,null,null,null,{"$f":"IF(E21=\"\",\"na\",Codes!G17*E21)","v":0}]
[null,null,"Medical / Dental",50,0,null,null,null,{"$f":"IF(E22=\"\",\"na\",Codes!G18*E22)","v":0}]
[null,null,"Health & fitness",null,0,null,null,null,{"$f":"IF(E23=\"\",\"na\",Codes!G19*E23)","v":0}]
[null,null,"Hair, beauty & cosmetics",null,0,null,null,null,{"$f":"IF(E24=\"\",\"na\",Codes!G20*E24)","v":0}]
[null,null,"Professional services",null,0,null,null,null,{"$f":"IF(E25=\"\",\"na\",Codes!G21*E25)","v":0}]
[null,null,"Cleaning / Gardening",null,0,null,null,null,{"$f":"IF(E26=\"\",\"na\",Codes!G22*E26)","v":0}]
[null,null,"Repairs / Maintenance",null,0,null,null,null,{"$f":"IF(E27=\"\",\"na\",Codes!G23*E27)","v":0}]
[null,null,"Entertainment",null,0,null,null,null,{"$f":"IF(E28=\"\",\"na\",Codes!G24*E28)","v":0}]
[null,null,"Donations to charity",null,0,null,null,null,{"$f":"IF(E29=\"\",\"na\",Codes!G25*E29)","v":0}]
[null,null,"Spending/pocket money",2500,0,null,null,null,0]
[null,null,"Other",null,0,null,null,null,{"$f":"IF(E31=\"\",\"na\",Codes!G27*E31)","v":0}]
[]
[null," - Utilities","Electricity",null,0,null,null,null,{"$f":"IF(E33=\"\",\"na\",Codes!G29*E33)","v":0},null,{"$f":"SUM(I33:I39)","v":0},null,{"$f":"K33/52","v":0}]
[null,null,"Gas",null,0,null,null,null,{"$f":"IF(E34=\"\",\"na\",Codes!G30*E34)","v":0}]
[null,null,"Telephone",null,0,null,null,null,{"$f":"IF(E35=\"\",\"na\",Codes!G31*E35)","v":0}]
[null,null,"Mobiles",null,0,null,null,null,{"$f":"IF(E36=\"\",\"na\",Codes!G32*E36)","v":0}]
[null,null,"Pay-TV",null,0,null,null,null,{"$f":"IF(E37=\"\",\"na\",Codes!G33*E37)","v":0}]
[null,null,"Internet/Broadband",25,0,null,null,null,{"$f":"IF(E38=\"\",\"na\",Codes!G34*E38)","v":0}]
[]
[null," - Transport / Cars","Petrol",null,0,null,null,null,{"$f":"IF(E40=\"\",\"na\",Codes!G36*E40)","v":0},null,{"$f":"SUM(I40:I45)","v":0},null,{"$f":"K40/52","v":0}]
[null,null,"Registration",null,0,null,null,null,{"$f":"IF(E41=\"\",\"na\",Codes!G37*E41)","v":0}]
[null,null,"Insurance",null,0,null,null,null,{"$f":"IF(E42=\"\",\"na\",Codes!G38*E42)","v":0}]
[null,null,"Maintenance/Repairs",null,0,null,null,null,{"$f":"IF(E43=\"\",\"na\",Codes!G39*E43)","v":0}]
[null,null,"Public Transport",null,0,null,null,null,{"$f":"IF(E44=\"\",\"na\",Codes!G40*E44)","v":0}]
[]
[null," - Insurances","Personal Insurance Cover",null,0,null,null,null,{"$f":"IF(E46=\"\",\"na\",Codes!G42*E46)","v":0},null,{"$f":"SUM(I46:I52)","v":0},null,{"$f":"K46/52","v":0}]
[null,null,"Income protection",null,0,null,null,null,{"$f":"IF(E47=\"\",\"na\",Codes!G43*E47)","v":0}]
[null,null,"Private Health Insurance",null,0,null,null,null,{"$f":"IF(E48=\"\",\"na\",Codes!G44*E48)","v":0}]
[null,null,"House / Contents",null,0,null,null,null,{"$f":"IF(E49=\"\",\"na\",Codes!G45*E49)","v":0}]
[null,null,"Motor Vehicle",null,0,null,null,null,{"$f":"IF(E50=\"\",\"na\",Codes!G46*E50)","v":0}]
[null,null,"Other",null,0,null,null,null,{"$f":"IF(E51=\"\",\"na\",Codes!G47*E51)","v":0}]
[]
[null," - Holidays","All assoicated costs",null,0,null,null,null,{"$f":"IF(E53=\"\",\"na\",Codes!G49*E53)","v":0},null,{"$f":"SUM(I53:I54)","v":0},null,{"$f":"K53/52","v":0}]
[]
[]
[null,"Grand Total","Income",null,null,null,null,null,null,{"$f":"SUM(J6:J9)","v":0},{"$f":"SUM(K6:K9)","v":0},null,{"$f":"K56/52","v":0}]
[null,null,"Expenses",null,null,null,null,null,null,{"$f":"SUM(J11:J50)","v":0},{"$f":"SUM(K11:K53)","v":0},null,{"$f":"K57/52","v":0}]
[null,null,"Remaining Cash for Investment",null,null,null,null,null,null,{"$f":"J56-J57","v":0},{"$f":"K56-K57","v":0},null,{"$f":"K58/52","v":0}]
[]
[null,"Note: If the number for \"Remaining Cash for Investment\" is a negative number - you need to re-work your budget so that you have surplus cash."]

{"sheet":"Codes","index":1,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[null,"Code","Factor",null,null,"Total","Factor"]
["How often?",1,null,null,{"$f":"Planner!C6","v":"Wages & salaries (after tax)"},1,{"$f":"VLOOKUP(F2,$B$2:$C$8,2,FALSE)","v":0}]
["Daily",2,365,null,{"$f":"Planner!C7","v":"Centrelink/Family Benefit"},1,{"$f":"VLOOKUP(F3,$B$2:$C$8,2,FALSE)","v":0}]
["Weekly",3,52,null,{"$f":"Planner!C8","v":"Investment income"},1,0]
["Monthly",4,12,null,{"$f":"Planner!C9","v":"Other"},1,0]
["Quarterly",5,4]
["6 monthly",6,2,null,{"$f":"Planner!C11","v":"Mortgage / Rent"},1,0]
["Yearly",7,1,null,{"$f":"Planner!C12","v":"Council Rates/Body Corp.Fees"},1,0]
[null,null,null,null,{"$f":"Planner!C13","v":"School fees / Childcare"},1,0]
[null,null,null,null,{"$f":"Planner!C14","v":"Investment loan payments"},1,0]
[null,null,null,null,{"$f":"Planner!C15","v":"Other"},1,0]
[]
[null,null,null,null,{"$f":"Planner!C17","v":"Groceries"},1,0]
[null,null,null,null,{"$f":"Planner!C18","v":"Clothes"},1,0]
[null,null,null,null,{"$f":"Planner!C19","v":"Shoes / Accessories"},1,0]
[null,null,null,null,{"$f":"Planner!C20","v":"Books/Subscriptions"},1,0]
[null,null,null,null,{"$f":"Planner!C21","v":"Video & DVD rental"},1,0]
[null,null,null,null,{"$f":"Planner!C22","v":"Medical / Dental"},1,0]
[null,null,null,null,{"$f":"Planner!C23","v":"Health & fitness"},1,0]
[null,null,null,null,{"$f":"Planner!C24","v":"Hair, beauty & cosmetics"},1,0]
[null,null,null,null,{"$f":"Planner!C25","v":"Professional services"},1,0]
[null,null,null,null,{"$f":"Planner!C26","v":"Cleaning / Gardening"},1,0]
[null,null,null,null,{"$f":"Planner!C27","v":"Repairs / Maintenance"},1,0]
[null,null,null,null,{"$f":"Planner!C28","v":"Entertainment"},1,0]
[null,null,null,null,{"$f":"Planner!C29","v":"Donations to charity"},1,0]
[null,null,null,null,{"$f":"Planner!C30","v":"Spending/pocket money"},1,0]
[null,null,null,null,{"$f":"Planner!C31","v":"Other"},1,0]
[]
[null,null,null,null,{"$f":"Planner!C33","v":"Electricity"},1,0]
[null,null,null,null,{"$f":"Planner!C34","v":"Gas"},1,0]
[null,null,null,null,{"$f":"Planner!C35","v":"Telephone"},1,0]
[null,null,null,null,{"$f":"Planner!C36","v":"Mobiles"},1,0]
[null,null,null,null,{"$f":"Planner!C37","v":"Pay-TV"},1,0]
[null,null,null,null,{"$f":"Planner!C38","v":"Internet/Broadband"},1,0]
[]
[null,null,null,null,{"$f":"Planner!C40","v":"Petrol"},1,0]
[null,null,null,null,{"$f":"Planner!C41","v":"Registration"},1,0]
[null,null,null,null,{"$f":"Planner!C42","v":"Insurance"},1,0]
[null,null,null,null,{"$f":"Planner!C43","v":"Maintenance/Repairs"},1,0]
[null,null,null,null,{"$f":"Planner!C44","v":"Public Transport"},1,0]
[]
[null,null,null,null,{"$f":"Planner!C46","v":"Personal Insurance Cover"},1,0]
[null,null,null,null,{"$f":"Planner!C47","v":"Income protection"},1,0]
[null,null,null,null,{"$f":"Planner!C48","v":"Private Health Insurance"},1,0]
[null,null,null,null,{"$f":"Planner!C49","v":"House / Contents"},1,0]
[null,null,null,null,{"$f":"Planner!C50","v":"Motor Vehicle"},1,0]
[null,null,null,null,{"$f":"Planner!C51","v":"Other"},1,0]
[]
[null,null,null,null,{"$f":"Planner!C53","v":"All assoicated costs"},1,0]