{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["个人月度预算"],"read":"whole","date_system":"1900"}

{"sheet":"个人月度预算","index":0,"n_rows":63,"n_cols":10,"rows_kept":63,"merged":[[1,1,1,9],[2,1,2,3],[3,1,5,1],[3,2,3,3],[3,6,4,8],[3,9,4,9],[4,2,4,3],[5,2,5,3],[5,6,6,8],[5,9,6,9],[6,1,8,1],[6,2,6,3],[7,2,7,3],[7,6,8,8],[7,9,8,9],[8,2,8,3],[21,6,21,9],[22,1,22,4],[30,6,30,9],[32,1,32,4],[37,6,37,9],[39,1,39,4],[43,6,43,9],[45,1,45,4],[49,6,49,9],[53,1,53,4],[56,6,56,9],[57,6,58,8],[57,9,58,9],[59,6,60,8],[59,9,60,9],[61,6,62,8],[61,9,62,9]]}
[]
[null,"个人月度预算"]
[]
[null,"计划月收入","收入 1",null,{"v":2500,"d":"￥2,500"},null,"计划负债 (计划收入减计划支出)",null,null,{"$f":"E6-J58","v":null}]
[null,null,"额外收入",null,{"v":500,"d":"￥500"}]
[null,null,"月度总收入",null,{"$f":"SUM(E4:E5)","v":null},null,"实际负债 (实际收入减实际支出)",null,null,{"$f":"E9-J60","v":null}]
[null,"实际月收入","收入 1",null,{"v":2500,"d":"￥2,500"}]
[null,null,"额外收入",null,{"v":500,"d":"￥500"},null,"差额 (实际减计划)",null,null,{"$f":"J6-J4","v":null}]
[null,null,"月度总收入",null,{"$f":"SUM(E7:E8)","v":null}]
[]
[null,"供房","计划支出","实际支出","差额",null,"娱乐费","计划支出","实际支出","差额"]
[null,"押金或租金",{"v":1500,"d":"￥1,500"},{"v":1400,"d":"￥1,400"},{"$f":"[计划支出]-[实际支出]","v":null},null,"录像/DVD",{"v":0,"d":"￥0"},{"v":50,"d":"￥50"},{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"电话费",{"v":60,"d":"￥60"},{"v":100,"d":"￥100"},{"$f":"[计划支出]-[实际支出]","v":null},null,"CD",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"电费",{"v":50,"d":"￥50"},{"v":60,"d":"￥60"},{"$f":"[计划支出]-[实际支出]","v":null},null,"电影",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"燃气费",{"v":200,"d":"￥200"},{"v":180,"d":"￥180"},{"$f":"[计划支出]-[实际支出]","v":null},null,"音乐会",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"水费",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"运动",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"有线电视费",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"直播剧场",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"垃圾清理费",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"其他",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"维修费",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"其他",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"物品储备",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"其他",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"其他",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"总计",{"$f":"SUBTOTAL(109,[计划支出])","v":null},{"$f":"SUBTOTAL(109,[实际支出])","v":null},{"$f":"SUBTOTAL(109,[差额])","v":null}]
[null,"总计",{"$f":"SUBTOTAL(109,[计划支出])","v":null},{"$f":"SUBTOTAL(109,[实际支出])","v":null},{"$f":"SUBTOTAL(109,[差额])","v":null}]
[{"$nulls":6},"贷款","计划支出","实际支出","差额"]
[null,"交通费","计划支出","实际支出","差额",null,"个人",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"交通工具费用",{"v":250,"d":"￥250"},{"v":250,"d":"￥250"},{"$f":"[计划支出]-[实际支出]","v":null},null,"学生",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"公交车/出租车票费",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"信用卡",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"保险",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"信用卡",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"驾照",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"信用卡",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"燃料费",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"其他",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"维修",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"总计",{"$f":"SUBTOTAL(109,[计划支出])","v":null},{"$f":"SUBTOTAL(109,[实际支出])","v":null},{"$f":"SUBTOTAL(109,[差额])","v":null}]
[null,"其他",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"总计",{"$f":"SUBTOTAL(109,[计划支出])","v":null},{"$f":"SUBTOTAL(109,[实际支出])","v":null},{"$f":"SUBTOTAL(109,[差额])","v":null},null,"税款","计划支出","实际支出","差额"]
[{"$nulls":6},"个人所得税",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"保险费","计划支出","实际支出","差额",null,"车船使用税",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"家居保险",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"其他",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"健康保险",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"其他",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"人寿保险",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"总计",{"$f":"SUBTOTAL(109,[计划支出])","v":null},{"$f":"SUBTOTAL(109,[实际支出])","v":null},{"$f":"SUBTOTAL(109,[差额])","v":null}]
[null,"其他",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"总计",{"$f":"SUBTOTAL(109,[计划支出])","v":null},{"$f":"SUBTOTAL(109,[实际支出])","v":null},{"$f":"SUBTOTAL(109,[差额])","v":null},null,"储蓄或投资","计划支出","实际支出","差额"]
[{"$nulls":6},"退休帐户",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"饮食","计划支出","实际支出","差额",null,"投资帐户",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"日用杂货",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"其他",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"在外就餐",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"总计",{"$f":"SUBTOTAL(109,[计划支出])","v":null},{"$f":"SUBTOTAL(109,[实际支出])","v":null},{"$f":"SUBTOTAL(109,[差额])","v":null}]
[null,"其他",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"总计",{"$f":"SUBTOTAL(109,[计划支出])","v":null},{"$f":"SUBTOTAL(109,[实际支出])","v":null},{"$f":"SUBTOTAL(109,[差额])","v":null},null,"礼品和捐赠","计划支出","实际支出","差额"]
[{"$nulls":6},"慈善 1",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"宠物","计划支出","实际支出","差额",null,"慈善 2",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"饮食",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"慈善 3",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"医疗",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"总计",{"$f":"SUBTOTAL(109,[计划支出])","v":null},{"$f":"SUBTOTAL(109,[实际支出])","v":null},{"$f":"SUBTOTAL(109,[差额])","v":null}]
[null,"毛发清洁梳理",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"玩具",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"法律","计划支出","实际支出","差额"]
[null,"其他",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"律师代理费",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"总计",{"$f":"SUBTOTAL(109,[计划支出])","v":null},{"$f":"SUBTOTAL(109,[实际支出])","v":null},{"$f":"SUBTOTAL(109,[差额])","v":null},null,"赡养费",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[{"$nulls":6},"留置权支付或判决支付",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"个人护理","计划支出","实际支出","差额",null,"其他",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"医疗",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"总计",{"$f":"SUBTOTAL(109,[计划支出])","v":null},{"$f":"SUBTOTAL(109,[实际支出])","v":null},{"$f":"SUBTOTAL(109,[差额])","v":null}]
[null,"头发/指甲护理",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"服饰",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"计划支出总额",null,null,{"$f":"SUM(C22,C32,C39,C45,C53,C63,H21,H30,H37,H43,H49,H56)","v":null}]
[null,"干洗",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"保健俱乐部",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"实际支出总额",null,null,{"$f":"SUM(D22,D32,D39,D45,D53,D63,I21,I30,I37,I43,I49,I56)","v":null}]
[null,"组织会员费",null,null,{"$f":"[计划支出]-[实际支出]","v":null}]
[null,"其他",null,null,{"$f":"[计划支出]-[实际支出]","v":null},null,"总差额",null,null,{"$f":"SUM(E22,E32,E39,E45,E53,E63,J21,J30,J37,J43,J49,J56)","v":null}]
[null,"总计",{"$f":"SUBTOTAL(109,[计划支出])","v":null},{"$f":"SUBTOTAL(109,[实际支出])","v":null},{"$f":"SUBTOTAL(109,[差额])","v":null}]