{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["建议租金","收入来源"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"建议租金","index":0,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"租金负担能力计算器",{"$nulls":3}," "]
[null,"税前每年总收入",{"$f":"Total_Income_From_Sources","v":{"v":0,"d":"¥0"}}]
[null," ","安全\n25%","尚可\n30%","进取型\n35%"]
[null,"建议的每月租金",{"$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,"估计公共事业费用",{"$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,"最大住房支出",{"$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,"目标搬迁存款",{"$f":"IFERROR(C4*3,\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(D4*3,\"\")","v":{"v":0,"d":"¥0"}},{"v":0,"d":"¥0"}]
[null,"免责声明： "]
[null,"所有计算都是建议。 "]
[null,"签署租约前，应考虑所有个人和财务因素。"]

{"sheet":"收入来源","index":1,"n_rows":4,"n_cols":5,"rows_kept":4}
[null,"收入来源",null,null," "]
[null,"税前每年总收入",null,{"$f":"SUMIF(Table2[频率],\"每年\",Table2[金额 (税前)])+SUMIF(Table2[频率],\"每月\",Table2[金额 (税前)])*12+SUMIF(Table2[频率],\"每周\",Table2[金额 (税前)])*72","v":{"v":0,"d":"¥0"}}]
[null,"来源","金额 (税前)","频率"]
[null,"添加收入来源",{"v":0,"d":"¥0"},"每年"]