{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Personal Budget","chart_calcs"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":27,"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":"Personal Budget","index":0,"n_rows":111,"n_cols":19,"rows_kept":111,"cut":false,"hidden":false,"merged":[[102,3,102,4],[40,3,40,4],[39,3,39,4],[31,3,31,4],[59,3,59,4],[75,3,75,4],[91,3,91,4],[50,3,50,4],[68,3,68,4],[84,3,84,4]]}
[null,"Monthly Budget"]
[]
[]
[]
[null,{"$f":"chart_calcs!$D$6","v":"january income:"},null,null,null,null,null,{"$f":"chart_calcs!$D$7","v":"january expenses:"},null,null,null,null,null,null,null,{"$f":"chart_calcs!$D$8","v":"january cash flow:"}]
[null,{"$f":"\" \"&chart_calcs!$F$6","v":" "},null,null,null,null,null,{"$f":"\" \"&chart_calcs!$F$7","v":" "},null,null,null,null,null,null,null,{"$f":"\" \"&chart_calcs!$F$8","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"JAN"," Select First Budget Month"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SelectedPeriod","v":"JAN "}]
[null,"Monthly Cash After Expenses",null,null,null,{"$f":"FirstMonth","v":"JAN "},{"$f":"NextMonth","v":"FEB "},"MAR ","APR ","MAY ","JUN ","JUL ","AUG ","SEP ","OCT ","NOV ","DEC ","YEAR  ","% INC "]
[null,"Cashflow",null,null,null,{"$f":"F38-F111","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F29:Q29)","v":0},{"$f":"IFERROR(INDEX($F29:$R29,,SelectedPeriodColumn)/INDEX($F$38:$R$38,,SelectedPeriodColumn),0)","v":0}]
[null,"Cumulative Cash Flow",null,null,null,{"$f":"SUM($F$29:F$29)","v":0},{"$f":"SUM($F$29:G$29)","v":0},{"$f":"SUM($F$29:H$29)","v":0},{"$f":"SUM($F$29:I$29)","v":0},{"$f":"SUM($F$29:J$29)","v":0},{"$f":"SUM($F$29:K$29)","v":0},{"$f":"SUM($F$29:L$29)","v":0},{"$f":"SUM($F$29:M$29)","v":0},{"$f":"SUM($F$29:N$29)","v":0},{"$f":"SUM($F$29:O$29)","v":0},{"$f":"SUM($F$29:P$29)","v":0},{"$f":"SUM($F$29:Q$29)","v":0}]
[]
[null,"MONTHLY INCOME",null,"PAYMENT FREQUENCY",null,{"$f":"FirstMonth","v":"JAN "},{"$f":"NextMonth","v":"FEB "},"MAR ","APR ","MAY ","JUN ","JUL ","AUG ","SEP ","OCT ","NOV ","DEC ","YEAR  ","% INC "]
[null,null,"Salary / Wages","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F33:Q33)","v":0},{"$f":"IFERROR(INDEX($F33:$R33,,SelectedPeriodColumn)/INDEX($F$38:$R$38,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Interest","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F34:$R34,,SelectedPeriodColumn)/INDEX($F$38:$R$38,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Dividends","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F35:$R35,,SelectedPeriodColumn)/INDEX($F$38:$R$38,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Rental income","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F36:$R36,,SelectedPeriodColumn)/INDEX($F$38:$R$38,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Other income","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F37:$R37,,SelectedPeriodColumn)/INDEX($F$38:$R$38,,SelectedPeriodColumn),0)","v":0}]
[null,null,"TOTAL INCOME",null,null,{"$f":"SUM(F33:F37)","v":0},{"$f":"SUM(G33:G37)","v":0},{"$f":"SUM(H33:H37)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F38:$R38,,SelectedPeriodColumn)/INDEX($F$38:$R$38,,SelectedPeriodColumn),0)","v":0}]
[]
[null,"MONTHLY EXPENSES"]
[null,"Housing",null,"Payment Frequency",null,"Jan ","Feb ","Mar ","Apr ","May ","Jun ","Jul ","Aug ","Sep ","Oct","Nov ","Dec ","Year ","% inc "]
[null,null,"Mortgage / rent / board","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F42:Q42)","v":0},{"$f":"IFERROR(INDEX($F42:$R42,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Rates","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F43:Q43)","v":0},{"$f":"IFERROR(INDEX($F43:$R43,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Water rates","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F44:Q44)","v":0},{"$f":"IFERROR(INDEX($F44:$R44,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Repairs and maintenance","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F45:Q45)","v":0},{"$f":"IFERROR(INDEX($F45:$R45,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Phone / internet","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F46:$R46,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Electricity / Gas","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F47:$R47,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Other","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F48:$R48,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Total housing expenses",null,null,{"$f":"SUM(F42:F48)","v":0},{"$f":"SUM(G42:G48)","v":0},{"$f":"SUM(H41:H48)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(F49:Q49)","v":0},{"$f":"IFERROR(INDEX($F49:$R49,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[]
[null,"Insurance",null,"Payment Frequency",null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Year","% inc"]
[null,null,"House / contents","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F52:Q52)","v":0},{"$f":"IFERROR(INDEX($F52:$R52,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Health","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F53:Q53)","v":0},{"$f":"IFERROR(INDEX($F53:$R53,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Life","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F54:$R54,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Vehicle","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F55:$R55,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Pet","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F56:$R56,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Other","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F57:$R57,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Total insurance",null,null,{"$f":"SUM(F51:F57)","v":0},{"$f":"SUM(G51:G57)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F58:Q58)","v":0},{"$f":"IFERROR(INDEX($F58:$R58,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[]
[null,"Transport",null,"Payment Frequency",null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Year","% inc"]
[null,null,"Vehicle loan repayments","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F61:Q61)","v":0},{"$f":"IFERROR(INDEX($F61:$R61,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Fuel","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F62:Q62)","v":0},{"$f":"IFERROR(INDEX($F62:$R62,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Registration","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F63:Q63)","v":0},{"$f":"IFERROR(INDEX($F63:$R63,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Repairs / maintenance","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F64:$R64,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Public transport","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F65:$R65,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Other","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F66:$R66,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Total transport expenses",null,null,{"$f":"SUM(F61:F66)","v":0},{"$f":"SUM(G61:G66)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F67:$R67,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[]
[null,"Food",null,"Payment Frequency",null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Year","% inc"]
[null,null,"Groceries","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F70:Q70)","v":0},{"$f":"IFERROR(INDEX($F70:$R70,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Dining out","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F71:Q71)","v":0},{"$f":"IFERROR(INDEX($F71:$R71,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Takeaways","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F72:Q72)","v":0},{"$f":"IFERROR(INDEX($F72:$R72,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Other","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F73:Q73)","v":0},{"$f":"IFERROR(INDEX($F73:$R73,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Total food expenses",null,null,{"$f":"SUM(F70:F73)","v":0},{"$f":"SUM(G70:G73)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F74:Q74)","v":0},{"$f":"IFERROR(INDEX($F74:$R74,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[]
[null,"Children",null,"Payment Frequency",null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Year","% inc"]
[null,null,"Childcare","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F77:Q77)","v":0},{"$f":"IFERROR(INDEX($F77:$R77,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Education","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F78:$R78,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Clothing","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F79:$R79,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Pocket money","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F80:$R80,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Sports / hobbies","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F81:$R81,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Child support","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F82:$R82,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Total children expenses",null,null,{"$f":"SUM(F77:F82)","v":0},{"$f":"SUM(G77:G82)","v":0},0,0,0,0,0,{"$f":"SUM(M77:M82)","v":0},0,0,0,0,{"$f":"SUM(F83:Q83)","v":0},{"$f":"IFERROR(INDEX($F83:$R83,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[]
[null,"Medical",null,"Payment Frequency",null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Year","% inc"]
[null,null,"Doctor","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F86:Q86)","v":0},{"$f":"IFERROR(INDEX($F86:$R86,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Dentist","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F87:Q87)","v":0},{"$f":"IFERROR(INDEX($F87:$R87,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Chemist","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F88:Q88)","v":0},{"$f":"IFERROR(INDEX($F88:$R88,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Other","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F89:Q89)","v":0},{"$f":"IFERROR(INDEX($F89:$R89,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Total medical expenses",null,null,{"$f":"SUM(F85:F89)","v":0},{"$f":"SUM(G85:G89)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F90:Q90)","v":0},{"$f":"IFERROR(INDEX($F90:$R90,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[]
[null,"Lifestyle",null,"Payment Frequency",null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Year","% inc"]
[null,null,"Clothing","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F93:Q93)","v":0},{"$f":"IFERROR(INDEX($F93:$R93,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Grooming","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F94:$R94,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Holidays","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F95:$R95,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Entertainment","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F96:$R96,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Gifts","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F97:$R97,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Donations","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F98:$R98,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Memberships/subscriptions","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F99:$R99,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Other","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F100:$R100,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Total lifestyle expenses",null,null,{"$f":"SUM(F92:F100)","v":0},{"$f":"SUM(G92:G100)","v":0},{"$f":"SUM(H92:H100)","v":0},{"$f":"SUM(I92:I100)","v":0},{"$f":"SUM(J92:J100)","v":0},{"$f":"SUM(K92:K100)","v":0},{"$f":"SUM(L92:L100)","v":0},{"$f":"SUM(M92:M100)","v":0},{"$f":"SUM(N92:N100)","v":0},{"$f":"SUM(O92:O100)","v":0},{"$f":"SUM(P92:P100)","v":0},{"$f":"SUM(Q92:Q100)","v":0},0,{"$f":"IFERROR(INDEX($F101:$R101,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[]
[null,"Debt Repayments",null,"Payment Frequency",null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Year","% inc"]
[null,null,"Student loan","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F104:Q104)","v":0},{"$f":"IFERROR(INDEX($F104:$R104,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Bank loan","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F105:Q105)","v":0},{"$f":"IFERROR(INDEX($F105:$R105,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Credit card","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F106:$R106,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Hire purchase","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F107:$R107,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Other debt","Monthly",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(INDEX($F108:$R108,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[null,null,"Total debt repayments",null,null,{"$f":"SUM(F104:F108)","v":0},{"$f":"SUM(G104:G108)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F109:Q109)","v":0},{"$f":"IFERROR(INDEX($F109:$R109,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]
[]
[null,null,"TOTAL EXPENSES",null,null,{"$f":"SUM(F49,F58,F67,F74,F83,F90,F101,F109)","v":0},{"$f":"SUM(G49,G58,G67,G74,G83,G90,G101,G109)","v":0},{"$f":"SUM(H49,H58,H67,H74,H83,H90,H101,H109)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(F111:Q111)","v":0},{"$f":"IFERROR(INDEX($F111:$R111,,SelectedPeriodColumn)/INDEX($F$111:$R$111,,SelectedPeriodColumn),0)","v":0}]

{"sheet":"chart_calcs","index":1,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["***This sheet should remain HIDDEN***"]
[]
[null,null,null,{"$f":"IFERROR(LOWER(TEXT(VALUE(SelectedPeriod&\" 1\"),\"mmmm\")),\"year\")","v":"january"}]
[]
[null,null,null,"Dynamic Chart Titles"]
[null,null,null,{"$f":"D3&\" income:\"","v":"january income:"},null,{"$f":"TEXT(INDEX('Personal Budget'!$F$38:$R$38,,SelectedPeriodColumn),\"#,###\")","v":""}]
[null,null,null,{"$f":"D3&\" expenses:\"","v":"january expenses:"},null,{"$f":"TEXT(INDEX('Personal Budget'!$F$111:$R$111,,SelectedPeriodColumn),\"#,###\")","v":""}]
[null,null,null,{"$f":"D3&\" cash flow:\"","v":"january cash flow:"},{"$f":"INDEX('Personal Budget'!F29:R29,ScrollBarValue)","v":0},{"$f":"TEXT(E8,\"#,###\")","v":""}]
[]
[]
[]
[null,null,null,{"$f":"LOWER('Personal Budget'!F28)","v":"jan "},{"$f":"LOWER('Personal Budget'!G28)","v":"feb "},{"$f":"LOWER('Personal Budget'!H28)","v":"mar "},{"$f":"LOWER('Personal Budget'!I28)","v":"apr "},{"$f":"LOWER('Personal Budget'!J28)","v":"may "},{"$f":"LOWER('Personal Budget'!K28)","v":"jun "},{"$f":"LOWER('Personal Budget'!L28)","v":"jul "},{"$f":"LOWER('Personal Budget'!M28)","v":"aug "},{"$f":"LOWER('Personal Budget'!N28)","v":"sep "},{"$f":"LOWER('Personal Budget'!O28)","v":"oct "},{"$f":"LOWER('Personal Budget'!P28)","v":"nov "},{"$f":"LOWER('Personal Budget'!Q28)","v":"dec "},{"$f":"LOWER('Personal Budget'!R28)","v":"year  "}]
[null,null,"Scroll Bar Value: ",1]
[null,null,"Cash Flow Chart: ",{"$f":"IF(SelectedPeriod='Personal Budget'!F$32,IF('Personal Budget'!$F$29:$R$29>=0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#VALUE!"}},{"$f":"IF(SelectedPeriod='Personal Budget'!G$32,IF('Personal Budget'!$F$29:$R$29>=0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!H$32,IF('Personal Budget'!$F$29:$R$29>=0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!I$32,IF('Personal Budget'!$F$29:$R$29>=0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!J$32,IF('Personal Budget'!$F$29:$R$29>=0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!K$32,IF('Personal Budget'!$F$29:$R$29>=0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!L$32,IF('Personal Budget'!$F$29:$R$29>=0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!M$32,IF('Personal Budget'!$F$29:$R$29>=0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!N$32,IF('Personal Budget'!$F$29:$R$29>=0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!O$32,IF('Personal Budget'!$F$29:$R$29>=0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!P$32,IF('Personal Budget'!$F$29:$R$29>=0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!Q$32,IF('Personal Budget'!$F$29:$R$29>=0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!R$32,IF('Personal Budget'!$F$29:$R$29>=0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,"Cumulative: ",{"$f":"IF(SelectedPeriod='Personal Budget'!F$32,IF('Personal Budget'!$F$29:$R$29<0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#VALUE!"}},{"$f":"IF(SelectedPeriod='Personal Budget'!G$32,IF('Personal Budget'!$F$29:$R$29<0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!H$32,IF('Personal Budget'!$F$29:$R$29<0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!I$32,IF('Personal Budget'!$F$29:$R$29<0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!J$32,IF('Personal Budget'!$F$29:$R$29<0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!K$32,IF('Personal Budget'!$F$29:$R$29<0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!L$32,IF('Personal Budget'!$F$29:$R$29<0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!M$32,IF('Personal Budget'!$F$29:$R$29<0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!N$32,IF('Personal Budget'!$F$29:$R$29<0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!O$32,IF('Personal Budget'!$F$29:$R$29<0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!P$32,IF('Personal Budget'!$F$29:$R$29<0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!Q$32,IF('Personal Budget'!$F$29:$R$29<0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Personal Budget'!R$32,IF('Personal Budget'!$F$29:$R$29<0,'Personal Budget'!$F$29:$R$29,NA()),NA())","v":{"$error":"#N/A"}}]
[]
[]
[null,null,"INCOME CHART DATA"]
[null,null,"Salary / Wages",{"$f":"'Personal Budget'!S33","v":0}]
[null,null,"Interest",{"$f":"'Personal Budget'!S34","v":0}]
[null,null,"Dividends",{"$f":"'Personal Budget'!S35","v":0}]
[null,null,"Rental income",{"$f":"'Personal Budget'!S36","v":0}]
[null,null,"Other income",{"$f":"'Personal Budget'!S37","v":0}]
[]
[]
["Manual"]
["Weekly"]
["Fortnightly"]
["Monthly"]
["Annually"]