{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Spending Plan Worksheet","Tracking Sheet"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Spending Plan Worksheet","index":0,"n_rows":83,"n_cols":11,"rows_kept":83,"cut":false,"hidden":false,"merged":[[1,4,2,8],[1,9,6,10],[69,8,82,10],[68,9,68,10],[66,8,66,10],[4,1,4,2],[5,1,5,2],[4,3,4,4],[5,3,5,4],[76,1,76,4],[36,8,36,9],[37,8,37,9],[38,8,38,9],[39,8,39,9],[71,1,71,4],[59,1,59,4],[61,1,61,4],[62,1,62,4],[6,3,6,4],[6,1,6,2],[78,1,78,4],[79,1,79,4],[80,1,80,4],[81,1,81,4],[45,1,45,4],[46,1,46,4],[47,1,47,4],[48,1,48,4],[49,1,49,4],[82,1,82,4],[72,1,72,4],[73,1,73,4],[74,1,74,4],[75,1,75,4],[50,1,50,4],[77,1,77,4],[51,1,51,4],[52,1,52,4],[70,1,70,4],[53,1,53,4],[54,1,54,4],[55,1,55,4],[56,1,56,4],[57,1,57,4],[58,1,58,4],[60,1,60,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[39,1,39,4],[40,1,40,4],[41,1,41,4],[42,1,42,4],[43,1,43,4],[44,1,44,4],[27,1,27,4],[28,1,28,4],[29,1,29,4],[30,1,30,4],[31,1,31,4],[32,1,32,4],[33,1,33,4],[34,1,34,4],[35,1,35,4],[21,1,21,4],[22,1,22,4],[18,8,18,9],[19,8,19,9],[20,8,20,9],[23,1,23,4],[24,1,24,4],[25,1,25,4],[26,1,26,4],[11,8,11,9],[27,8,27,9],[25,8,25,9],[17,8,17,10],[22,8,22,10],[23,8,23,9],[15,8,15,9],[8,1,8,4],[9,1,9,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[9,8,9,9],[17,1,17,4],[8,8,8,10],[18,1,18,4],[19,1,19,4],[20,1,20,4],[12,8,12,9],[13,8,13,9],[14,8,14,9],[10,8,10,9],[65,8,65,10],[33,8,33,9],[35,8,35,9],[30,8,30,9],[40,8,40,9],[24,8,24,9],[26,8,26,9],[29,8,29,9],[28,8,28,9],[34,8,34,9],[31,8,31,9],[32,8,32,9]]}
[]
[null,null,null,null,"       Spending Plan Worksheet"]
[]
[]
[null,"Name:"]
[null,"Date:"]
[null,"File Number:"]
[]
[null,"LIVING EXPENSES",null,null,null,"Monthly","Annually",null,"MONTHLY INCOME"]
[null,"Housing",null,null,null,null,null,null,"Income After Tax and Deductions"]
[null,"Home-1st Mortgage","Present Value","Amount Owed","Description/Creditor",null,null,null,"Rental income"]
[null,"Home-1st Mortgage",null,null,"  ",null,null,null,"CCTB"]
[null,"Rent",null,null,null,null,null,null,"Child / Spousal Income"]
[null,"Property Taxes",null,null,null,null,null,null,"Other Regular Monthly Income"]
[null,"Maintenance / Tools / Plants"]
[null,"Condo Fees / Community Fees",null,null,null,null,null,null,"TOTAL INCOME   ",null,{"$f":"SUM(K10:K15)","v":0}]
[null,"Household Incidentals"]
[null,"Alarm System",null,null,null,null,null,null,"PAYMENT ABILITY"]
[null,null,null,null,null,null,null,null,"Total Monthly Net Income",null,{"$f":"SUM(K16)","v":0}]
[null,null,null,null,null,null,null,null,"Total Monthly Living Expenses",null,{"$f":"F83","v":0}]
[null,"Utilities",null,null,null,null,null,null,"ABILITY",null,{"$f":"K19-K20","v":0}]
[null,"Electricity"]
[null,"Internet Telephone / Cell",null,null,null,null,null,null,"BUDGET SUMMARY"]
[null,"Water / Sewer",null,null,null,null,null,null,"Housing (less insurance)",null,{"$f":"SUM(F12:F20)+(SUM(G12:G20)/12)","v":0}]
[null,"Natural Gas",null,null,null,null,null,null,"Utilities",null,{"$f":"SUM(F22:F26)+(SUM(G22:G26)/12)","v":0}]
[null,"Cable TV / Internet / ",null,null,null,null,null,null,"Food",null,{"$f":"F27+(G27/12)","v":0}]
[null,"Food (Groceries)",null,null,null,null,null,null,"Incidentals",null,{"$f":"SUM(F29:F31)+(SUM(G29:G31)/12)","v":0}]
[null,"Incidentals",null,null,null,null,null,null,"Insurance (Home / Vehicle / Life)",null,{"$f":"SUM(F33:F36)+(SUM(G33:G36)/12)","v":0}]
[null," Bank Service Fees",null,null,null,null,null,null,"Transportation (less License / Registration)",null,{"$f":"SUM(F38:F42)+(SUM(G38:G42)/12)-F40","v":0}]
[null,"Laundromat / Dry Cleaning",null,null,null,null,null,null,"Income Tax",null,{"$f":"SUM(F43)+(SUM(G43)/12)","v":0}]
[null,"Newspaper / Mags",null,null,null,null,null,null,"Personal Allowances",null,{"$f":"SUM(F45:F48)+(SUM(G45:G48)/12)","v":0}]
[null,"Insurance",null,null,null,null,null,null,"Medical Expenses",null,{"$f":"SUM(F50:F52)+(SUM(G50:G52)/12)","v":0}]
[null,"Life",null,null,null,null,null,null,"Recreation",null,{"$f":"SUM(F54:F55)+(SUM(G54:G55)/12)","v":0}]
[null,"Home",null,null,null,null,null,null,"Contributions & Donations",null,{"$f":"(F56+(G56)/12)","v":0}]
[null," Car / Vehicle",null,null,null,null,null,null,"Other Monthly Expenses",null,{"$f":"SUM(F58:F62)+(SUM(G58:G62)/12)","v":0}]
[null,"Health",null,null,null,null,null,null,"Secured Creditors",null,{"$f":"SUM(F65:F70)+(SUM(G65:G70)/12)","v":0}]
[null,"Transportation",null,null,null,null,null,null,"Clothing",null,{"$f":"SUM(G72:G74)/12","v":0}]
[null,"Gasoline",null,null,null,null,null,null,"Education",null,{"$f":"G75/12","v":0}]
[null,"Maintenance",null,null,null,null,null,null,"Gifts & Festivities",null,{"$f":"SUM(G77:G78)/12","v":0}]
[null,"Vehicle License / Registration",null,null,null,{"$f":"G40/12","v":0},null,null,"Travel",null,{"$f":"G79/12","v":0}]
[null,"Bus Fare / Passes",null,null,null,null,null,null,"TOTAL PER MONTH",null,{"$f":"SUM(K24:K40)","v":0}]
[null,"Parking"]
[null,"Income Taxes",null,null,null,null,null,null,"DEBTS","Balance","Min Monthly"]
[null,"Personal Allowances"]
[null,"Smoking/Alcohol   "]
[null," Lotteries / VLT / Casino"]
[null," Restaurant Meals / Beverages"]
[null,"Spa / Beauty Supplies / Haircuts"]
[null,"Medical Expenses"]
[null,"Prescription Medicine"]
[null,"Supplements / Vitamins"]
[null,"Optical / Dental / Chiro / Massage"]
[null,"Recreation / Entertainment"]
[null,"Movies / Electronics / Activities / Hobby"]
[null,"Sports / Fitness"]
[null,"Contributions / Donations"]
[null,"Other Monthly Expenses"]
[null,"Pets (Food / Treats / Vet / Licence)"]
[null,"Emergency Fund / Allowance"]
[null,"Child Care / Child Support / Alimony"]
[null,"Stock Purchase and RRSP"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J44:J61)","v":0},{"$f":"SUM(K44:K61)","v":0}]
[null,"Secured Creditors",null,null,null,null,null,null,"APPROX OPD @ 4 YEARS",{"$f":"SUM(J62/43.5)","v":0}]
[null,"Present Value","amount owed","Descripton/Creditor","PIF date"]
[]
[null,null,null,null,null,null,null,null,"Client Notes:"]
[null,null,null,null,null,null,null,null,"408 per week in the first 6 weeks (13.60 x 30 hours) "]
[]
[]
[]
[null,"Clothing / Shoes "]
[null,"Back  to School ",null,null,null,{"$f":"G72/12","v":0}]
[null,"Yearly",null,null,null,0]
[null,null,null,null,null,0]
[null,"Education / Accreditations",null,null,null,0]
[null,"Gifts / Festivities"]
[null,"Christmas",null,null,null,0]
[null,"Special occasion",null,null,null,0]
[null,"Travel / Vacations / Camping",null,null,null,0]
[null,"Total Monthly Expenses",null,null,null,{"$f":"SUM(F12:F70)-F40","v":0}]
[null,"Total Irregular and Annual",null,null,null,null,{"$f":"SUM(G12:G79)","v":0}]
[null,"Monthly Irregular and Annual",null,null,null,{"$f":"G81/12","v":0}]
[null,"TOTAL MONTHLY EXPENSES",null,null,null,{"$f":"F80+F82","v":0}]

{"sheet":"Tracking Sheet","index":1,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,10,0,11],[0,14,0,15]]}
["Spending Tracker for :",null,null,"Today","to","day 31"]
["Budgeted amount",{"$f":"(SUM('Spending Plan Worksheet'!$F12:$F20))","v":0},{"$f":"(SUM('Spending Plan Worksheet'!$F22:$F26))","v":0},{"$f":"'Spending Plan Worksheet'!$F27","v":0},{"$f":"(SUM('Spending Plan Worksheet'!$F29:$F31))","v":0},{"$f":"(SUM('Spending Plan Worksheet'!$F33:$F36))","v":0},{"$f":"(SUM('Spending Plan Worksheet'!$F38:$F42))","v":0},{"$f":"'Spending Plan Worksheet'!$F43","v":0},{"$f":"(SUM('Spending Plan Worksheet'!$F45:$F48))","v":0},{"$f":"(SUM('Spending Plan Worksheet'!$F50:$F52))","v":0},{"$f":"(SUM('Spending Plan Worksheet'!$F54:$F55))","v":0},{"$f":"'Spending Plan Worksheet'!$F56","v":0},{"$f":"(SUM('Spending Plan Worksheet'!$F58:$F62))","v":0},{"$f":"(SUM('Spending Plan Worksheet'!$F65:$F70))","v":0},{"$f":"'Spending Plan Worksheet'!$F82","v":0},{"$f":"SUM(B2:O2)","v":0}]
["Amount Left",{"$f":"B2-SUM(B5:B35)","v":0},{"$f":"C2-SUM(C5:C35)","v":0},{"$f":"D2-SUM(D5:D35)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Date",{"$f":"'Spending Plan Worksheet'!I24","v":"Housing (less insurance)"},{"$f":"'Spending Plan Worksheet'!I25","v":"Utilities"},{"$f":"'Spending Plan Worksheet'!I26","v":"Food"},{"$f":"'Spending Plan Worksheet'!I27","v":"Incidentals"},"Insurance","Tranportation",{"$f":"'Spending Plan Worksheet'!I30","v":"Income Tax"},{"$f":"'Spending Plan Worksheet'!I31","v":"Personal Allowances"},{"$f":"'Spending Plan Worksheet'!I32","v":"Medical Expenses"},{"$f":"'Spending Plan Worksheet'!I33","v":"Recreation"},"Contribution and Donations",{"$f":"'Spending Plan Worksheet'!I35","v":"Other Monthly Expenses"},{"$f":"'Spending Plan Worksheet'!I36","v":"Secured Creditors"},"Irregular Expenses","TOTAL"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B5:O5)","v":0}]
[{"$f":"1+A5","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B6:O6)","v":0}]
[{"$f":"1+A6","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]