{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Budget Worksheet"],"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":"Budget Worksheet","index":0,"n_rows":159,"n_cols":11,"rows_kept":159,"cut":false,"hidden":false,"merged":[[0,1,0,2],[26,1,26,2],[15,4,25,4],[13,1,13,3],[12,0,12,1],[134,1,135,5],[133,1,133,3],[92,4,98,4],[100,4,116,4],[28,4,44,4],[46,4,55,4],[57,4,65,4],[67,4,77,4],[79,4,90,4],[1,2,1,5],[2,2,2,5]]}
[null,"BUDGET WORKSHEET | INCOME AND OUTGOINGS",null,"Enter your information in BLUE fields ONLY"]
[null,"Date:"]
[null,"Name:"]
[null,"Do you have any savings or investments of any sort?","Type","Description","Held with","Value $",null,null,null,"Select Frequency","-"]
[null,"  (eg Crypto, term deposits, bonds, shares, etc)",null,null,null,null,null,null,null,"Annually",1]
[null,null,null,null,null,null,null,null,null,"Fortnightly",26]
[null,null,null,null,null,null,null,null,null,"Monthly",12]
[null,"Do you have any physical assets?","Type","Address / Make / Model","Description / Age / Year","Value $",null,null,null,"Weekly",52]
[null," (eg. House, car, valuables over $5k, or such like, etc)"]
[]
[]
[]
[]
[null,"PLEASE USE THE DROP DOWNS UNDER \"FREQUENCY\" TO CONFIRM HOW OFTEN YOU MAKE PAYMENTS",null,null,"SELECT FREQUENCY","Weekly"]
[null,"Income","Amount $  ","Frequency","Any Comments ",{"$f":"SUM(F16:F26)","v":0}]
[null,"Your salary or wage - net amount after deductions",null,"Select Frequency",null,{"$f":"IFERROR(IF(D16=$J$4,$K$4,C16*VLOOKUP(D16,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Partner's salary or wage - net amount after deductions",null,"Select Frequency",null,{"$f":"IFERROR(IF(D17=$J$4,$K$4,C17*VLOOKUP(D17,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Benefit",null,"Select Frequency",null,{"$f":"IFERROR(IF(D18=$J$4,$K$4,C18*VLOOKUP(D18,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Superannuation / pension",null,"Select Frequency",null,{"$f":"IFERROR(IF(D19=$J$4,$K$4,C19*VLOOKUP(D19,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Child Support received",null,"Select Frequency",null,{"$f":"IFERROR(IF(D20=$J$4,$K$4,C20*VLOOKUP(D20,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Boarder / Rental income",null,"Select Frequency",null,{"$f":"IFERROR(IF(D21=$J$4,$K$4,C21*VLOOKUP(D21,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Other - detail below"]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D23=$J$4,$K$4,C23*VLOOKUP(D23,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D24=$J$4,$K$4,C24*VLOOKUP(D24,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D25=$J$4,$K$4,C25*VLOOKUP(D25,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D26=$J$4,$K$4,C26*VLOOKUP(D26,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Outgoings",null,null,null,{"$f":"+F28+F46+F57+F67+F79+F92+F100+F118","v":0}]
[null,"Household Costs","Amount $","Frequency","Any Comments",{"$f":"SUM(F29:F45)","v":0}]
[null,"Rent",null,"Select Frequency",null,{"$f":"IFERROR(IF(D29=$J$4,$K$4,C29*VLOOKUP(D29,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Mortgage",null,"Select Frequency",null,{"$f":"IFERROR(IF(D30=$J$4,$K$4,C30*VLOOKUP(D30,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Household Gas (not petrol)",null,"Select Frequency",null,{"$f":"IFERROR(IF(D31=$J$4,$K$4,C31*VLOOKUP(D31,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Electricity",null,"Select Frequency",null,{"$f":"IFERROR(IF(D32=$J$4,$K$4,C32*VLOOKUP(D32,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Water",null,"Select Frequency",null,{"$f":"IFERROR(IF(D33=$J$4,$K$4,C33*VLOOKUP(D33,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Phone / Mobile",null,"Select Frequency",null,{"$f":"IFERROR(IF(D34=$J$4,$K$4,C34*VLOOKUP(D34,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Internet",null,"Select Frequency",null,{"$f":"IFERROR(IF(D35=$J$4,$K$4,C35*VLOOKUP(D35,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Netflix / Sky / etc",null,"Select Frequency",null,{"$f":"IFERROR(IF(D36=$J$4,$K$4,C36*VLOOKUP(D36,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Spotify / Apple Music / etc",null,"Select Frequency",null,{"$f":"IFERROR(IF(D37=$J$4,$K$4,C37*VLOOKUP(D37,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"House and contents insurance",null,"Select Frequency",null,{"$f":"IFERROR(IF(D38=$J$4,$K$4,C38*VLOOKUP(D38,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Council rates",null,"Select Frequency",null,{"$f":"IFERROR(IF(D39=$J$4,$K$4,C39*VLOOKUP(D39,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"House repairs & maintenance",null,"Select Frequency",null,{"$f":"IFERROR(IF(D40=$J$4,$K$4,C40*VLOOKUP(D40,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Other - detail below"]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D42=$J$4,$K$4,C42*VLOOKUP(D42,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D43=$J$4,$K$4,C43*VLOOKUP(D43,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D44=$J$4,$K$4,C44*VLOOKUP(D44,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D45=$J$4,$K$4,C45*VLOOKUP(D45,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Insurance and other"," Amount $ ","Frequency","Any Comments",{"$f":"SUM(F47:F56)","v":0}]
[null,"Life insurance",null,"Select Frequency",null,{"$f":"IFERROR(IF(D47=$J$4,$K$4,C47*VLOOKUP(D47,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Health insurance",null,"Select Frequency",null,{"$f":"IFERROR(IF(D48=$J$4,$K$4,C48*VLOOKUP(D48,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Income protection insurance",null,"Select Frequency",null,{"$f":"IFERROR(IF(D49=$J$4,$K$4,C49*VLOOKUP(D49,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Savings",null,"Select Frequency",null,{"$f":"IFERROR(IF(D50=$J$4,$K$4,C50*VLOOKUP(D50,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Bank fees and charges",null,"Select Frequency",null,{"$f":"IFERROR(IF(D51=$J$4,$K$4,C51*VLOOKUP(D51,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Other - detail below"]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D53=$J$4,$K$4,C53*VLOOKUP(D53,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D54=$J$4,$K$4,C54*VLOOKUP(D54,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D55=$J$4,$K$4,C55*VLOOKUP(D55,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D56=$J$4,$K$4,C56*VLOOKUP(D56,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Food & Groceries"," Amount $ ","Frequency","Any Comments",{"$f":"SUM(F58:F66)","v":0}]
[null,"Groceries  ",null,"Select Frequency",null,{"$f":"IFERROR(IF(D58=$J$4,$K$4,C58*VLOOKUP(D58,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Takeouts",null,"Select Frequency",null,{"$f":"IFERROR(IF(D59=$J$4,$K$4,C59*VLOOKUP(D59,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Alcohol",null,"Select Frequency",null,{"$f":"IFERROR(IF(D60=$J$4,$K$4,C60*VLOOKUP(D60,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Smokes / Vapes",null,"Select Frequency",null,{"$f":"IFERROR(IF(D61=$J$4,$K$4,C61*VLOOKUP(D61,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Other - detail below"]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D63=$J$4,$K$4,C63*VLOOKUP(D63,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D64=$J$4,$K$4,C64*VLOOKUP(D64,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D65=$J$4,$K$4,C65*VLOOKUP(D65,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D66=$J$4,$K$4,C66*VLOOKUP(D66,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Transport and Travel"," Amount $ ","Frequency","Any Comments",{"$f":"SUM(F68:F78)","v":0}]
[null,"Bus / train / taxi fares",null,"Select Frequency",null,{"$f":"IFERROR(IF(D68=$J$4,$K$4,C68*VLOOKUP(D68,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Vehicle registration",null,"Select Frequency",null,{"$f":"IFERROR(IF(D69=$J$4,$K$4,C69*VLOOKUP(D69,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Petrol / Diesel",null,"Select Frequency",null,{"$f":"IFERROR(IF(D70=$J$4,$K$4,C70*VLOOKUP(D70,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Car insurance",null,"Select Frequency",null,{"$f":"IFERROR(IF(D71=$J$4,$K$4,C71*VLOOKUP(D71,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Maintenance / servicing",null,"Select Frequency",null,{"$f":"IFERROR(IF(D72=$J$4,$K$4,C72*VLOOKUP(D72,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Holidays / flights",null,"Select Frequency",null,{"$f":"IFERROR(IF(D73=$J$4,$K$4,C73*VLOOKUP(D73,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Other -detail below"]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D75=$J$4,$K$4,C75*VLOOKUP(D75,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D76=$J$4,$K$4,C76*VLOOKUP(D76,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D77=$J$4,$K$4,C77*VLOOKUP(D77,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D78=$J$4,$K$4,C78*VLOOKUP(D78,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Children"," Amount $ ","Frequency","Any Comments",{"$f":"SUM(F80:F91)","v":0}]
[null,"Maintenance / child support",null,"Select Frequency",null,{"$f":"IFERROR(IF(D80=$J$4,$K$4,C80*VLOOKUP(D80,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Childcare - daycare and after school",null,"Select Frequency",null,{"$f":"IFERROR(IF(D81=$J$4,$K$4,C81*VLOOKUP(D81,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"School fees and donations",null,"Select Frequency",null,{"$f":"IFERROR(IF(D82=$J$4,$K$4,C82*VLOOKUP(D82,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"School uniforms",null,"Select Frequency",null,{"$f":"IFERROR(IF(D83=$J$4,$K$4,C83*VLOOKUP(D83,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"School activities",null,"Select Frequency",null,{"$f":"IFERROR(IF(D84=$J$4,$K$4,C84*VLOOKUP(D84,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Pocket money",null,"Select Frequency",null,{"$f":"IFERROR(IF(D85=$J$4,$K$4,C85*VLOOKUP(D85,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Savings plan",null,"Select Frequency",null,{"$f":"IFERROR(IF(D86=$J$4,$K$4,C86*VLOOKUP(D86,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Other - detail below"]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D88=$J$4,$K$4,C88*VLOOKUP(D88,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D89=$J$4,$K$4,C89*VLOOKUP(D89,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D90=$J$4,$K$4,C90*VLOOKUP(D90,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D91=$J$4,$K$4,C91*VLOOKUP(D91,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Student"," Amount $ ","Frequency","Any Comments",{"$f":"SUM(F93:F99)","v":0}]
[null,"Tuition fees",null,"Select Frequency",null,{"$f":"IFERROR(IF(D93=$J$4,$K$4,C93*VLOOKUP(D93,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Student loan (not deducted from wages)",null,"Select Frequency",null,{"$f":"IFERROR(IF(D94=$J$4,$K$4,C94*VLOOKUP(D94,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Other - detail below"]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D96=$J$4,$K$4,C96*VLOOKUP(D96,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D97=$J$4,$K$4,C97*VLOOKUP(D97,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D98=$J$4,$K$4,C98*VLOOKUP(D98,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D99=$J$4,$K$4,C99*VLOOKUP(D99,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Other Outgoings"," Amount $ ","Frequency","Any Comments",{"$f":"SUM(F101:F117)","v":0}]
[null,"Charitable donations / church / tithing",null,"Select Frequency",null,{"$f":"IFERROR(IF(D101=$J$4,$K$4,C101*VLOOKUP(D101,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Clothing / Footwear",null,"Select Frequency",null,{"$f":"IFERROR(IF(D102=$J$4,$K$4,C102*VLOOKUP(D102,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Dentists",null,"Select Frequency",null,{"$f":"IFERROR(IF(D103=$J$4,$K$4,C103*VLOOKUP(D103,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Doctors & prescriptions",null,"Select Frequency",null,{"$f":"IFERROR(IF(D104=$J$4,$K$4,C104*VLOOKUP(D104,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Family support - money",null,"Select Frequency",null,{"$f":"IFERROR(IF(D105=$J$4,$K$4,C105*VLOOKUP(D105,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Gifts",null,"Select Frequency",null,{"$f":"IFERROR(IF(D106=$J$4,$K$4,C106*VLOOKUP(D106,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Hairdressing",null,"Select Frequency",null,{"$f":"IFERROR(IF(D107=$J$4,$K$4,C107*VLOOKUP(D107,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Lottery",null,"Select Frequency",null,{"$f":"IFERROR(IF(D108=$J$4,$K$4,C108*VLOOKUP(D108,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Opticians",null,"Select Frequency",null,{"$f":"IFERROR(IF(D109=$J$4,$K$4,C109*VLOOKUP(D109,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Personal cash / emergencies",null,"Select Frequency",null,{"$f":"IFERROR(IF(D110=$J$4,$K$4,C110*VLOOKUP(D110,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Pets",null,"Select Frequency",null,{"$f":"IFERROR(IF(D111=$J$4,$K$4,C111*VLOOKUP(D111,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Sports activities / gym membership",null,"Select Frequency",null,{"$f":"IFERROR(IF(D112=$J$4,$K$4,C112*VLOOKUP(D112,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Other - detail below"]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D114=$J$4,$K$4,C114*VLOOKUP(D114,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D115=$J$4,$K$4,C115*VLOOKUP(D115,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D116=$J$4,$K$4,C116*VLOOKUP(D116,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,null,null,"Select Frequency",null,{"$f":"IFERROR(IF(D117=$J$4,$K$4,C117*VLOOKUP(D117,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Debt Repayments"," Amount $ ","Frequency","Any Comments",{"$f":"SUM(F119:F133)","v":0}]
[null,"Insert Name of Creditor 1",null,"Select Frequency",null,{"$f":"IFERROR(IF(D119=$J$4,$K$4,C119*VLOOKUP(D119,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Insert Name of Creditor 2",null,"Select Frequency",null,{"$f":"IFERROR(IF(D120=$J$4,$K$4,C120*VLOOKUP(D120,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Insert Name of Creditor 3",null,"Select Frequency",null,{"$f":"IFERROR(IF(D121=$J$4,$K$4,C121*VLOOKUP(D121,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Insert Name of Creditor 4",null,"Select Frequency",null,{"$f":"IFERROR(IF(D122=$J$4,$K$4,C122*VLOOKUP(D122,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Insert Name of Creditor 5",null,"Select Frequency",null,{"$f":"IFERROR(IF(D123=$J$4,$K$4,C123*VLOOKUP(D123,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Insert Name of Creditor 6",null,"Select Frequency",null,{"$f":"IFERROR(IF(D124=$J$4,$K$4,C124*VLOOKUP(D124,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Insert Name of Creditor 7",null,"Select Frequency",null,{"$f":"IFERROR(IF(D125=$J$4,$K$4,C125*VLOOKUP(D125,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Insert Name of Creditor 8",null,"Select Frequency",null,{"$f":"IFERROR(IF(D126=$J$4,$K$4,C126*VLOOKUP(D126,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Insert Name of Creditor 9",null,"Select Frequency",null,{"$f":"IFERROR(IF(D127=$J$4,$K$4,C127*VLOOKUP(D127,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Insert Name of Creditor 10",null,"Select Frequency",null,{"$f":"IFERROR(IF(D128=$J$4,$K$4,C128*VLOOKUP(D128,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Insert Name of Creditor 11",null,"Select Frequency",null,{"$f":"IFERROR(IF(D129=$J$4,$K$4,C129*VLOOKUP(D129,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Insert Name of Creditor 12",null,"Select Frequency",null,{"$f":"IFERROR(IF(D130=$J$4,$K$4,C130*VLOOKUP(D130,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Insert Name of Creditor 13",null,"Select Frequency",null,{"$f":"IFERROR(IF(D131=$J$4,$K$4,C131*VLOOKUP(D131,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Insert Name of Creditor 14",null,"Select Frequency",null,{"$f":"IFERROR(IF(D132=$J$4,$K$4,C132*VLOOKUP(D132,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Insert Name of Creditor 15",null,"Select Frequency",null,{"$f":"IFERROR(IF(D133=$J$4,$K$4,C133*VLOOKUP(D133,$J$5:$K$8,2,FALSE)/VLOOKUP($F$14,$J$5:$K$8,2)),0)","v":"-"}]
[null,"Net Surplus / (Deficit)",null,null,null,{"$f":"+F15-F27","v":0}]
[null,"DEBT LIST"]
[]
[null,"Creditor Name"," Amount Owing ","Amount in Arrears","Whose Debt\r\n(Yours / Partners / Joint)"," Security (If Any) "]
[null,{"$f":"+B119","v":"Insert Name of Creditor 1"}]
[null,{"$f":"+B120","v":"Insert Name of Creditor 2"}]
[null,"Insert Name of Creditor 3"]
[null,"Insert Name of Creditor 4"]
[null,"Insert Name of Creditor 5"]
[null,"Insert Name of Creditor 6"]
[null,"Insert Name of Creditor 7"]
[null,"Insert Name of Creditor 8"]
[null,"Insert Name of Creditor 9"]
[null,"Insert Name of Creditor 10"]
[null,"Insert Name of Creditor 11"]
[null,"Insert Name of Creditor 12"]
[null,"Insert Name of Creditor 13"]
[null,"Insert Name of Creditor 14"]
[null,"Insert Name of Creditor 15"]
[null,"If no regular repayments, add further creditor details below"]
[null,"1)"]
[null,"2)"]
[null,"3)"]
[null,"4)"]
[null,"5)"]
[null,"TOTAL DEBTS",{"$f":"SUM(C138:C158)","v":0},{"$f":"SUM(D138:D158)","v":0}]