{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["汇总","支出"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"汇总","index":0,"n_rows":10,"n_cols":15,"rows_kept":10,"merged":[[0,1,0,2]]}
[null,"个人预算"]
[null,null,"1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
[null,"总支出",{"$f":"支出[[#Totals],[1 月]]","v":{"v":0,"d":"¥0"}},{"$f":"支出[[#Totals],[2 月]]","v":{"v":0,"d":"¥0"}},{"$f":"支出[[#Totals],[3 月]]","v":{"v":0,"d":"¥0"}},{"$f":"支出[[#Totals],[4 月]]","v":{"v":0,"d":"¥0"}},{"$f":"支出[[#Totals],[5 月]]","v":{"v":0,"d":"¥0"}},{"$f":"支出[[#Totals],[6 月]]","v":{"v":0,"d":"¥0"}},{"$f":"支出[[#Totals],[7 月]]","v":{"v":0,"d":"¥0"}},{"$f":"支出[[#Totals],[8 月]]","v":{"v":0,"d":"¥0"}},{"$f":"支出[[#Totals],[9 月]]","v":{"v":0,"d":"¥0"}},{"$f":"支出[[#Totals],[10 月]]","v":{"v":0,"d":"¥0"}},{"$f":"支出[[#Totals],[11 月]]","v":{"v":0,"d":"¥0"}},{"$f":"支出[[#Totals],[12 月]]","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C3:N3)","v":{"v":0,"d":"¥0"}}]
[null,"现金不足/盈余",{"$f":"SUM(收入[[#Totals],[1 月]]-C3)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(收入[[#Totals],[2 月]]-D3)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(收入[[#Totals],[3 月]]-E3)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(收入[[#Totals],[4 月]]-F3)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(收入[[#Totals],[5 月]]-G3)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(收入[[#Totals],[6 月]]-H3)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(收入[[#Totals],[7 月]]-I3)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(收入[[#Totals],[8 月]]-J3)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(收入[[#Totals],[9 月]]-K3)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(收入[[#Totals],[10 月]]-L3)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(收入[[#Totals],[11 月]]-M3)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(收入[[#Totals],[12月]]-N3)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C4:N4)","v":{"v":0,"d":"¥0"}}]
[null,"收入"]
[null,"类别","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12月","年"]
[null,"工资",{"$nulls":12},{"$f":"SUM(收入[[#This Row],[1 月]:[12月]])","v":{"v":0,"d":"¥0"}}]
[null,"利息/红利",{"$nulls":12},{"$f":"SUM(收入[[#This Row],[1 月]:[12月]])","v":{"v":0,"d":"¥0"}}]
[null,"杂项",{"$nulls":12},{"$f":"SUM(收入[[#This Row],[1 月]:[12月]])","v":{"v":0,"d":"¥0"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,收入[1 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,收入[2 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,收入[3 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,收入[4 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,收入[5 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,收入[6 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,收入[7 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,收入[8 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,收入[9 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,收入[10 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,收入[11 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,收入[12月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,收入[年])","v":{"v":0,"d":"¥0"}}]

{"sheet":"支出","index":1,"n_rows":12,"n_cols":16,"rows_kept":12,"merged":[[0,1,0,2]]}
[null,"个人预算"]
[null,"支出"]
[null,"类别","子类别","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
[null,"住房","按揭费用/租金",{"$nulls":12},{"$f":"SUM(支出!$D4:$O4)","v":{"v":0,"d":"¥0"}}]
[null,"日常生活","日用杂货 ",{"$nulls":12},{"$f":"SUM(支出!$D5:$O5)","v":{"v":0,"d":"¥0"}}]
[null,"交通","燃气/燃油",{"$nulls":12},{"$f":"SUM(支出!$D6:$O6)","v":{"v":0,"d":"¥0"}}]
[null,"娱乐","有线电视",{"$nulls":12},{"$f":"SUM(支出!$D7:$O7)","v":{"v":0,"d":"¥0"}}]
[null,"健康","健身俱乐部会费",{"$nulls":12},{"$f":"SUM(支出!$D8:$O8)","v":{"v":0,"d":"¥0"}}]
[null,"度假","飞机票",{"$nulls":12},{"$f":"SUM(支出!$D9:$O9)","v":{"v":0,"d":"¥0"}}]
[null,"消遣","体育馆费用",{"$nulls":12},{"$f":"SUM(支出!$D10:$O10)","v":{"v":0,"d":"¥0"}}]
[null,"会费/订阅费","杂志",{"$nulls":12},{"$f":"SUM(支出!$D11:$O11)","v":{"v":0,"d":"¥0"}}]
[null,"汇总",null,{"$f":"SUBTOTAL(109,支出[1 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,支出[2 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,支出[3 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,支出[4 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,支出[5 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,支出[6 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,支出[7 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,支出[8 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,支出[9 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,支出[10 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,支出[11 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,支出[12 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,支出[年])","v":{"v":0,"d":"¥0"}}]