{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["現金流量","月收入","月支出","圖表資料"],"not_rendered":{"charts":1,"images":3,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"現金流量","index":0,"n_rows":14,"n_cols":6,"rows_kept":14}
[{"$nulls":5}," "]
[]
[null," 姓氏"]
[null,"家庭預算"]
[null,{"$f":"\" 以下月份: \" & TEXT(TODAY(),\"yyyy 年 m 月\")","v":" 以下月份: 2021 年 9 月"}]
[]
[]
[null,"現金流量分析"]
[]
[]
[null," ","預計","實際","差異"]
[{"$f":"收入[[#Totals],[變異金額]]","v":{"v":300,"d":"NT$300"}},"總收入",{"$f":"收入[[#Totals],[預計]]","v":{"v":5700,"d":"NT$5,700"}},{"$f":"收入[[#Totals],[實際]]","v":{"v":6000,"d":"NT$6,000"}},{"$f":"A12","v":{"v":300,"d":"NT$300"}}]
[{"$f":"支出[[#Totals],[差額]]","v":{"v":-52,"d":"(NT$52.00)"}},"支出總額",{"$f":"支出[[#Totals],[預計]]","v":{"v":3603,"d":"NT$3,603"}},{"$f":"支出[[#Totals],[實際]]","v":{"v":3655,"d":"NT$3,655"}},{"$f":"A13","v":{"v":-52,"d":"(NT$52)"}}]
[null,"現金總額",{"$f":"C12-C13","v":{"v":2097,"d":"NT$2,097"}},{"$f":"D12-D13","v":{"v":2345,"d":"NT$2,345"}},{"$f":"SUBTOTAL(109,現金流量[差異])","v":{"v":248,"d":"NT$248"}}]

{"sheet":"月收入","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[{"$nulls":5}," "]
[null,"月收入"]
[]
[]
[null," ","預計","實際","變異金額"]
[null,"收入 1",{"v":4000,"d":"NT$4,000.00"},{"v":4000,"d":"NT$4,000.00"},{"$f":"收入[[#This Row],[實際]]-收入[[#This Row],[預計]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"收入 2",{"v":1400,"d":"NT$1,400.00"},{"v":1500,"d":"NT$1,500.00"},{"$f":"收入[[#This Row],[實際]]-收入[[#This Row],[預計]]","v":{"v":100,"d":"NT$100.00"}}]
[null,"其他收入",{"v":300,"d":"NT$300.00"},{"v":500,"d":"NT$500.00"},{"$f":"收入[[#This Row],[實際]]-收入[[#This Row],[預計]]","v":{"v":200,"d":"NT$200.00"}}]
[null,"收入總額",{"$f":"SUBTOTAL(109,收入[預計])","v":{"v":5700,"d":"NT$5,700"}},{"$f":"SUBTOTAL(109,收入[實際])","v":{"v":6000,"d":"NT$6,000"}},{"$f":"SUBTOTAL(109,收入[變異金額])","v":{"v":300,"d":"NT$300"}}]

{"sheet":"月支出","index":2,"n_rows":26,"n_cols":6,"rows_kept":26}
[{"$nulls":5}," "]
[null,"月支出"]
[]
[]
[null," ","預計","實際","差額"]
[null,"住宅",{"v":1500,"d":"NT$1,500.00"},{"v":1500,"d":"NT$1,500.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"雜貨",{"v":250,"d":"NT$250.00"},{"v":280,"d":"NT$280.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":-30,"d":"(NT$30.00)"}}]
[null,"電話",{"v":38,"d":"NT$38.00"},{"v":38,"d":"NT$38.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"電費 / 瓦斯",{"v":65,"d":"NT$65.00"},{"v":78,"d":"NT$78.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":-13,"d":"(NT$13.00)"}}]
[null,"水費 / 汙水處理 / 垃圾",{"v":25,"d":"NT$25.00"},{"v":21,"d":"NT$21.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":4,"d":"NT$4.00"}}]
[null,"有線電視",{"v":75,"d":"NT$75.00"},{"v":83,"d":"NT$83.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":-8,"d":"(NT$8.00)"}}]
[null,"網際網路",{"v":60,"d":"NT$60.00"},{"v":60,"d":"NT$60.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"保養 / 維修",{"v":0,"d":"NT$0.00"},{"v":60,"d":"NT$60.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":-60,"d":"(NT$60.00)"}}]
[null,"托兒",{"v":180,"d":"NT$180.00"},{"v":150,"d":"NT$150.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":30,"d":"NT$30.00"}}]
[null,"學費",{"v":250,"d":"NT$250.00"},{"v":250,"d":"NT$250.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"寵物",{"v":75,"d":"NT$75.00"},{"v":80,"d":"NT$80.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":-5,"d":"(NT$5.00)"}}]
[null,"交通",{"v":280,"d":"NT$280.00"},{"v":260,"d":"NT$260.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":20,"d":"NT$20.00"}}]
[null,"個人保健",{"v":75,"d":"NT$75.00"},{"v":65,"d":"NT$65.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":10,"d":"NT$10.00"}}]
[null,"保險",{"v":255,"d":"NT$255.00"},{"v":255,"d":"NT$255.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"信用卡",{"v":100,"d":"NT$100.00"},{"v":100,"d":"NT$100.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"貸款",{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"稅金",{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"禮物 / 慈善",{"v":150,"d":"NT$150.00"},{"v":150,"d":"NT$150.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"儲蓄",{"v":225,"d":"NT$225.00"},{"v":225,"d":"NT$225.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"其他",{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$f":"支出[[#This Row],[預計]]-支出[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"總計",{"$f":"SUBTOTAL(109,支出[預計])","v":{"v":3603,"d":"NT$3,603.00"}},{"$f":"SUBTOTAL(109,支出[實際])","v":{"v":3655,"d":"NT$3,655.00"}},{"$f":"SUBTOTAL(109,支出[差額])","v":{"v":-52,"d":"(NT$52.00)"}}]

{"sheet":"圖表資料","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"hidden":true}
[]
[null,"圖表資料"]
[]
[null,null,"預計","實際"]
[null,"月收入",{"$f":"收入[[#Totals],[預計]]","v":5700},{"$f":"收入[[#Totals],[實際]]","v":6000}]
[null,"月支出",{"$f":"支出[[#Totals],[預計]]","v":3603},{"$f":"支出[[#Totals],[實際]]","v":3655}]
[null,"現金流量",{"$f":"現金流量[[#Totals],[預計]]","v":2097},{"$f":"現金流量[[#Totals],[實際]]","v":2345}]