{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Sheet1","index":0,"n_rows":64,"n_cols":21,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,1,2,13],[7,18,9,20],[30,17,30,20],[63,18,63,20]]}
[]
[null,"Journey Planner and Budgeting Tool"]
[]
[]
[]
[null,null,"Departure Date",null,null,"Estimated Return",null,null,null,null,null,"Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,"Food:","(Weekly)",null,"Vehicle:","(Monthly)",null,"Fuel",null,{"$f":"S7*1.25","v":0},{"$f":"T7/F11","v":{"$error":"#DIV/0!"}}]
[null,null,"DD/MM/YYYY",null,null,"DD/MM/YYYY",null,null,null,null,null,"Groceries",null,{"$f":"M8/7","v":0},"Maintenance",null,null,{"$f":"(P8*12)/365","v":0},"FUEL: go to www.petrolcostcalculator.com.au and fill in the details. In the cell above, insert the dollar amount shown beside TRIP COST"]
[null,null,null,null,null,null,null,null,null,null,null,"Takeaway",null,{"$f":"M9/7","v":0},"Repairs",null,null,{"$f":"(P9*12)/365","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Dining out",null,0,"Rego",null,null,{"$f":"(P10*12)/365","v":0}]
[null,null,"Estimated journey length:",null,null,{"$f":"F7-C7","v":0},"days",null,null,null,null,"Alcohol",null,0,"Insurance",null,null,0]
[]
[null,null,"Total cost of trip",null,null,{"$f":"H13*-1","v":{"$error":"#DIV/0!"}},null,{"$f":"D44*F11","v":{"$error":"#DIV/0!"}},null,null,null,"Other (specify)","(Weekly)",null,"Clothing:","(Monthly)"]
[]
[null,null,"Actual Budget Required",null,null,{"$f":"F13+H64","v":{"$error":"#DIV/0!"}},null,"(income - expenses)",null,null,null,null,null,{"$f":"M15/7","v":0},"New Clothes",null,null,{"$f":"(P15*12)/365","v":0}]
[]
[null,null,"Daily Budget","Out of pocket = ",null,{"$f":"F15/F11","v":{"$error":"#DIV/0!"}},null,"(spare after costs)",null,null,null,null,null,{"$f":"M17/7","v":0},"Laundry",null,null,{"$f":"(P17*12)/365","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M19/7","v":0}]
[null,"Costs at a glance:",null,"Daily",null,"Weekly",null,"Monthly"]
[null,null,"Food & Drink",{"$f":"SUM(N8:N10)","v":0},null,{"$f":"(SUM(N8:N10)*7)","v":0},null,{"$f":"(SUM(N8:N10)*365)/12","v":0},null,null,null,"Entertainment:","(Weekly)",null,"Miscellaneous:","(Monthly)"]
[]
[null,null,"Alcohol",{"$f":"M11/7","v":0},null,{"$f":"M11","v":0},null,{"$f":"((M11/7)*365)/12","v":0},null,null,null,"Tours",null,{"$f":"M23/7","v":0},"Phone & Net",null,null,{"$f":"(P23*12)/365","v":0}]
[]
[null,null,"Accommodation",{"$f":"SUM(S37,S39)","v":0},null,{"$f":"SUM(S37,S39)*7","v":0},null,{"$f":"(SUM(S37,S39)*365)/12","v":0},null,null,null,"Ferry’s",null,{"$f":"M25/7","v":0},"Gas refills",null,null,{"$f":"(P25*12)/365","v":0}]
[]
[null,null,"Vehicle(s)",{"$f":"SUM(R8,R9,R10,R11)","v":0},null,{"$f":"SUM(R8,R9,R10,R11)*7","v":0},null,{"$f":"(SUM(R8,R9,R10,R11)*365)/12","v":0},null,null,null,"National Parks",null,0,"Medical",null,null,{"$f":"(P27*12)/365","v":0}]
[]
[null,null,"Fuel",{"$f":"U7","v":{"$error":"#DIV/0!"}},null,{"$f":"U7*7","v":{"$error":"#DIV/0!"}},null,{"$f":"((U7*365)/12)","v":{"$error":"#DIV/0!"}},null,null,null,"Fishing",null,{"$f":"M29/7","v":0},"Pets",null,null,{"$f":"(P29*12)/365","v":0}]
[]
[null,null,"Entertainment",{"$f":"SUM(N23:N29)","v":0},null,{"$f":"(SUM(M23:M29)*7)","v":0},null,{"$f":"(SUM(N23:N29)*365)/12","v":0}]
[]
[null,null,"Phones & Internet",{"$f":"R23","v":0},null,{"$f":"(((P23*12)/365)*7)","v":0},null,{"$f":"P23","v":0},null,null,null,"Accomodation Calculations"]
[]
[null,null,"Clothes",{"$f":"SUM(R15+R17)","v":0},null,{"$f":"(((SUM(P15,P17)*12)/365)*7)","v":0},null,{"$f":"SUM(P15+P17)","v":0},null,null,null,"Type of Accom","No. nights/week",null,"Avg cost/night",null,null,"Total",null,"% of total accom costs"]
[]
[null,null,"Gas",{"$f":"R25","v":0},null,{"$f":"(((P25*12)/365)*7)","v":0},null,{"$f":"P25","v":0},null,null,null,"Caravan Parks",null,null,null,null,null,{"$f":"M37*O37","v":0},{"$f":"R37/7","v":0},{"$f":"R37/R41","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Pets",{"$f":"R29","v":0},null,{"$f":"(((P29*12)/365)*7)","v":0},null,{"$f":"P29","v":0},null,null,null,"Campgrounds",null,null,null,null,null,{"$f":"M39*O39","v":0},{"$f":"R39/7","v":0},{"$f":"R39/R41","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Medical",{"$f":"R27","v":0},null,{"$f":"(((P27*12)/365)*7)","v":0},null,{"$f":"P27","v":0},null,null,null,"Free stays",null,null,"Free ",null,null,{"$f":"SUM(R37,R39)","v":0}]
[]
[null,null,"Other",{"$f":"SUM(N15,N17,N19)","v":0},null,{"$f":"(SUM(N15,N17,N19)*7)","v":0},null,{"$f":"(SUM(N15,N17,N19)*365)/12","v":0},null,null,null,"Must equal 7 --->",{"$f":"SUM(M37,M39,M41)","v":0},null,{"$f":"SUM(O37:O39)","v":0}]
[null,null,"TOTALS",{"$f":"SUM(D21:D43)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(F21:F43)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(H21:H43)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Debts whilst travelling",null,"(Enter amounts as cost per month)"]
[null,null,"Mortgage",null,null,{"$f":"H53/F11","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Vehicle",null,null,"(lease/loan repayments)"]
[]
[null,null,"Caravan/Camper/MH",null,null,"(lease/loan repayments)"]
[]
[null,null,"Other debts",null,null,"total debts=",null,{"$f":"SUM(D47:D53)","v":0}]
[]
[null,"Income whilst travelling",null,"(Enter amounts as monthly income)"]
[null,null,"Work",null,null,"(Salary/estimated on the road income)"]
[]
[null,null,"Rent",null,null,"(Rental income if you're renting your home out)"]
[]
[null,null,"Govt. payment",null,null,"(Family benefits/Pension/Govt. assistance)"]
[]
[null,null,"Savings",null,null,"(Funds you have saved for the trip - bank balance)"]
[null,null,"dailyincome",{"$f":"H63/F11","v":{"$error":"#DIV/0!"}},null,"total income=",null,{"$f":"SUM(D56:D62)","v":0}]
[null,null,{"$f":"H64/F11","v":{"$error":"#DIV/0!"}},{"$f":"D63-F47","v":{"$error":"#DIV/0!"}},null,"totalinc-totalexp",null,{"$f":"H63-H53","v":0},null,null,null,null,null,null,null,null,null,null,"©Jireh Consulting Pty Ltd & Indefinite Leave 2018"]