{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Suggested rent","Sources of income"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Suggested rent","index":0,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"Rent affordability calculator",{"$nulls":3}," "]
[null,"Total annual income before tax",{"$f":"Total_Income_From_Sources","v":{"v":0,"d":"£0"}}]
[null," ","Safe \n25%","Acceptable\n30%","Aggressive\n35%"]
[null,"Suggested monthly rent",{"$f":"IFERROR(Total_Income*0.25/12,\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(Total_Income*0.3/12,\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(Total_Income*0.35/12,\"\")","v":{"v":0,"d":"£0"}}]
[null,"Estimated utilities",{"$f":"IFERROR(C4*0.2,\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(D4*0.2,\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(E4*0.2,\"\")","v":{"v":0,"d":"£0"}}]
[null,"Maximum housing expense",{"$f":"IFERROR(C4+C5,\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(D4+D5,\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(E4+E5,\"\")","v":{"v":0,"d":"£0"}}]
[null,"Target savings to move out",{"$f":"IFERROR(C4*3,\"\")","v":{"v":0,"d":"£0"}},{"$f":"IFERROR(D4*3,\"\")","v":{"v":0,"d":"£0"}},{"v":0,"d":"£0"}]
[null,"DISCLAIMER: "]
[null,"All calculations are suggestions. "]
[null,"All personal and financial factors should be considered before signing a lease."]

{"sheet":"Sources of income","index":1,"n_rows":4,"n_cols":5,"rows_kept":4}
[null,"Sources of income",null,null," "]
[null,"Total annual income before tax",null,{"$f":"SUMIF(Table2[Frequency],\"Per Year\",Table2[Amount (before tax)])+SUMIF(Table2[Frequency],\"Per Month\",Table2[Amount (before tax)])*12+SUMIF(Table2[Frequency],\"Per Week\",Table2[Amount (before tax)])*72","v":{"v":0,"d":"£0"}}]
[null,"Sources","Amount (before tax)","Frequency"]
[null,"Add source of income",{"v":0,"d":"£0"},"per year"]