{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["儀表板","支出與收入","預算報表","資料清單","類別樞紐分析表"],"not_rendered":{"charts":3,"defined_names":18,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"儀表板","index":0,"n_rows":21,"n_cols":16,"rows_kept":21,"merged":[[5,2,5,3],[8,9,8,10],[9,9,9,10],[10,9,10,10]]}
[]
[null,null,"半月式家用預算",{"$nulls":12},"儀表板"]
[]
[]
[]
[null,null,{"$f":"CHOOSE(MonthNumber,\"一月\",\"二月\",\"三月\",\"四月\",\"五月\",\"六月\",\"七月\",\"八月\",\"九月\",\"十月\",\"十一月\",\"十二月\")","v":"九月"},null,9,{"$nulls":5},2012]
[]
[]
[null,null,"月總計","月總計",{"$nulls":5},"年度總計",null,"年度總計"]
[null,null,"收入","支出",{"$f":"SUMIF(Expenditures[日期],\"<=\"&DateMonthEnd,Expenditures[金額])-SUMIF(Expenditures[日期],\"<\"&DateMonthStart,Expenditures[金額])","v":{"v":0,"d":"NT$0.00"}},{"$nulls":4},"收入",null,"支出",{"$f":"SUM(IF(YEAR(Expenditures[日期])=K6,Expenditures[金額]))","v":{"v":0,"d":"NT$0.00"}}]
[null,null,"支出","收入",{"$f":"SUMIF(Income[日期],\"<=\"&DateMonthEnd,Income[金額])-SUMIF(Income[日期],\"<\"&DateMonthStart,Income[金額])","v":{"v":0,"d":"NT$0.00"}},{"$nulls":4},"支出",null,"收入",{"$f":"SUM(IF(YEAR(Income[日期])=K6,Income[金額]))","v":{"v":381000,"d":"NT$381,000.00"}}]
[]
[]
[]
[]
[]
[{"$nulls":3},"一月","二月","三月","四月","五月","六月","七月","八月","九月","十月","十一月","十二月"]
[null,null,"收入 1-15",{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtMiddle,Income[描述],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtMiddle,Income[描述],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtMiddle,Income[描述],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtMiddle,Income[描述],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtMiddle,Income[描述],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtMiddle,Income[描述],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtMiddle,Income[描述],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtMiddle,Income[描述],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtMiddle,Income[描述],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtMiddle,Income[描述],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtMiddle,Income[描述],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtMiddle,Income[描述],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}}]
[null,null,"收入 16-月底",{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtEnd,Income[描述],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtEnd,Income[描述],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtEnd,Income[描述],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtEnd,Income[描述],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtEnd,Income[描述],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtEnd,Income[描述],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtEnd,Income[描述],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtEnd,Income[描述],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtEnd,Income[描述],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtEnd,Income[描述],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtEnd,Income[描述],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Income[金額],Income[描述],\"<=\"&DtEnd,Income[描述],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}}]
[null,null,"支出 1-15",{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtMiddle,Expenditures[日期],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtStart)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtStart)","v":{"v":33750,"d":"NT$33,750.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtStart)","v":{"v":163500,"d":"NT$163,500.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtStart)","v":{"v":64110,"d":"NT$64,110.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtStart)","v":{"v":42900,"d":"NT$42,900.00"}}]
[null,null,"支出 16-月底",{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtMiddle+1)","v":{"v":33750,"d":"NT$33,750.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtMiddle+1)","v":{"v":160500,"d":"NT$160,500.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtMiddle+1)","v":{"v":40860,"d":"NT$40,860.00"}},{"$f":"SUMIFS(Expenditures[金額],Expenditures[日期],\"<=\"&DtEnd,Expenditures[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"NT$0.00"}}]

{"sheet":"支出與收入","index":1,"n_rows":40,"n_cols":10,"rows_kept":40}
[]
[null,null,"半月式家用預算",{"$nulls":6},"收入與支出"]
[]
[]
[]
[null,null,"收入",{"$nulls":3},"支出"]
[]
[null,null,"日期","描述","金額",null,"日期","類別","描述","金額"]
[null,null,{"$f":"NOW()-14","v":"2012-12-25T12:11:15.530"},"丹尼的薪水",{"v":39000,"d":"NT$39,000.00"},null,{"$f":"NOW()-7","v":"2013-01-01T12:11:15.530"},"家庭","房貸",{"v":30000,"d":"NT$30,000.00"}]
[null,null,{"$f":"NOW()-14","v":"2012-12-25T12:11:15.530"},"克汀的薪水",{"v":39000,"d":"NT$39,000.00"},null,{"$f":"NOW()-7","v":"2013-01-01T12:11:15.530"},"家庭","電費",{"v":3000,"d":"NT$3,000.00"}]
[null,null,{"$f":"NOW()-28","v":"2012-12-11T12:11:15.530"},"丹尼的薪水",{"v":45000,"d":"NT$45,000.00"},null,"2013-01-01T12:11:15.530","家庭","水費",{"v":1500,"d":"NT$1,500.00"}]
[null,null,"2012-12-11T12:11:15.530","克汀的薪水",{"v":48000,"d":"NT$48,000.00"},null,"2013-01-01T12:11:15.530","家庭","垃圾",{"v":750,"d":"NT$750.00"}]
[null,null,{"$f":"NOW()-42","v":"2012-11-27T12:11:15.530"},"丹尼的薪水",{"v":39000,"d":"NT$39,000.00"},null,"2013-01-01T12:11:15.530","家庭","手機",{"v":3000,"d":"NT$3,000.00"}]
[null,null,"2012-11-27T12:11:15.530","克汀的薪水",{"v":39000,"d":"NT$39,000.00"},null,"2013-01-01T12:11:15.530","家庭","住家電話",{"v":900,"d":"NT$900.00"}]
[null,null,{"$f":"NOW()-56","v":"2012-11-13T12:11:15.530"},"丹尼的薪水",{"v":45000,"d":"NT$45,000.00"},null,"2013-01-01T12:11:15.530","家庭","網際網路",{"v":1500,"d":"NT$1,500.00"}]
[null,null,"2012-11-13T12:11:15.530","克汀的薪水",{"v":48000,"d":"NT$48,000.00"},null,"2013-01-01T12:11:15.530","家庭","電視",{"v":1500,"d":"NT$1,500.00"}]
[null,null,{"$f":"NOW()-70","v":"2012-10-30T12:11:15.530"},"丹尼的薪水",{"v":39000,"d":"NT$39,000.00"},null,"2013-01-01T12:11:15.530","家庭","保養/維修",{"v":750,"d":"NT$750.00"}]
[{"$nulls":6},{"$f":"NOW()-8","v":"2012-12-31T12:11:15.530"},"家庭","信用卡 1 ",{"v":3000,"d":"NT$3,000.00"}]
[{"$nulls":6},{"$f":"NOW()-9","v":"2012-12-30T12:11:15.530"},"娛樂","電影",{"v":1110,"d":"NT$1,110.00"}]
[{"$nulls":6},{"$f":"NOW()-10","v":"2012-12-29T12:11:15.530"},"食物","雜貨",{"v":10500,"d":"NT$10,500.00"}]
[{"$nulls":6},{"$f":"NOW()-11","v":"2012-12-28T12:11:15.530"},"食物","外食",{"v":2250,"d":"NT$2,250.00"}]
[{"$nulls":6},{"$f":"NOW()-12","v":"2012-12-27T12:11:15.530"},"子女","午餐費",{"v":4500,"d":"NT$4,500.00"}]
[{"$nulls":6},{"$f":"NOW()-13","v":"2012-12-26T12:11:15.530"},"投資帳戶","儲蓄",{"v":7500,"d":"NT$7,500.00"}]
[{"$nulls":6},{"$f":"NOW()-14","v":"2012-12-25T12:11:15.530"},"投資帳戶","投資帳戶",{"v":7500,"d":"NT$7,500.00"}]
[{"$nulls":6},{"$f":"NOW()-15","v":"2012-12-24T12:11:15.530"},"個人","健身俱樂部",{"v":3000,"d":"NT$3,000.00"}]
[{"$nulls":6},{"$f":"NOW()-16","v":"2012-12-23T12:11:15.530"},"寵物","食物",{"v":1500,"d":"NT$1,500.00"}]
[{"$nulls":6},{"$f":"NOW()-20","v":"2012-12-19T12:11:15.530"},"寵物","美容",{"v":1500,"d":"NT$1,500.00"}]
[{"$nulls":6},{"$f":"NOW()-20","v":"2012-12-19T12:11:15.530"},"寵物","其他",{"v":1500,"d":"NT$1,500.00"}]
[{"$nulls":6},{"$f":"NOW()-25","v":"2012-12-14T12:11:15.530"},"交通","汽車 1 車貸 ",{"v":9000,"d":"NT$9,000.00"}]
[{"$nulls":6},{"$f":"NOW()-25","v":"2012-12-14T12:11:15.530"},"交通","汽車 2 車貸 ",{"v":10500,"d":"NT$10,500.00"}]
[{"$nulls":6},{"$f":"NOW()-25","v":"2012-12-14T12:11:15.530"},"交通","汽車保險",{"v":1500,"d":"NT$1,500.00"}]
[{"$nulls":6},{"$f":"NOW()-30","v":"2012-12-09T12:11:15.530"},"交通","油資",{"v":1500,"d":"NT$1,500.00"}]
[{"$nulls":6},{"$f":"NOW()-31","v":"2012-12-08T12:11:15.530"},"交通","油資",{"v":750,"d":"NT$750.00"}]
[{"$nulls":6},{"$f":"NOW()-42","v":"2012-11-27T12:11:15.530"},"交通","保養/維修",{"v":4500,"d":"NT$4,500.00"}]
[{"$nulls":6},{"$f":"NOW()-45","v":"2012-11-24T12:11:15.530"},"家庭","房貸",{"v":150000,"d":"NT$150,000.00"}]
[{"$nulls":6},{"$f":"NOW()-50","v":"2012-11-19T12:11:15.530"},"家庭","生活用品",{"v":6000,"d":"NT$6,000.00"}]
[{"$nulls":6},{"$f":"NOW()-65","v":"2012-11-04T12:11:15.530"},"家庭","住家電話",{"v":3000,"d":"NT$3,000.00"}]
[{"$nulls":6},{"$f":"NOW()-70","v":"2012-10-30T12:11:15.530"},"家庭","垃圾",{"v":1500,"d":"NT$1,500.00"}]
[{"$nulls":6},{"$f":"NOW()-75","v":"2012-10-25T12:11:15.530"},"家庭","房貸",{"v":30000,"d":"NT$30,000.00"}]
[{"$nulls":6},{"$f":"NOW()-78","v":"2012-10-22T12:11:15.530"},"娛樂","電影",{"v":2250,"d":"NT$2,250.00"}]

{"sheet":"預算報表","index":2,"n_rows":41,"n_cols":8,"rows_kept":41}
[]
[null,null,"半月式家用預算",{"$nulls":4},"預算報表"]
{"$rows_empty":10}
[null,null,"支出",null,null,"類別總計"]
[]
[null,null,"描述","合計"]
[null,null,"午餐費",{"v":4500,"d":"NT$4,500"}]
[null,null,"手機",{"v":3000,"d":"NT$3,000"}]
[null,null,"水費",{"v":1500,"d":"NT$1,500"}]
[null,null,"外食",{"v":2250,"d":"NT$2,250"}]
[null,null,"生活用品",{"v":6000,"d":"NT$6,000"}]
[null,null,"住家電話",{"v":3900,"d":"NT$3,900"}]
[null,null,"投資帳戶",{"v":7500,"d":"NT$7,500"}]
[null,null,"汽車 1 車貸 ",{"v":9000,"d":"NT$9,000"}]
[null,null,"汽車 2 車貸 ",{"v":10500,"d":"NT$10,500"}]
[null,null,"汽車保險",{"v":1500,"d":"NT$1,500"}]
[null,null,"其他",{"v":1500,"d":"NT$1,500"}]
[null,null,"垃圾",{"v":2250,"d":"NT$2,250"}]
[null,null,"房貸",{"v":210000,"d":"NT$210,000"}]
[null,null,"油資",{"v":2250,"d":"NT$2,250"}]
[null,null,"保養/維修",{"v":5250,"d":"NT$5,250"}]
[null,null,"信用卡 1 ",{"v":3000,"d":"NT$3,000"}]
[null,null,"美容",{"v":1500,"d":"NT$1,500"}]
[null,null,"食物",{"v":1500,"d":"NT$1,500"}]
[null,null,"健身俱樂部",{"v":3000,"d":"NT$3,000"}]
[null,null,"電視",{"v":1500,"d":"NT$1,500"}]
[null,null,"電費",{"v":3000,"d":"NT$3,000"}]
[null,null,"電影",{"v":3360,"d":"NT$3,360"}]
[null,null,"網際網路",{"v":1500,"d":"NT$1,500"}]
[null,null,"儲蓄",{"v":7500,"d":"NT$7,500"}]
[null,null,"雜貨",{"v":10500,"d":"NT$10,500"}]
[null,null,"合計",{"v":307260,"d":"NT$307,260"}]

{"sheet":"資料清單","index":3,"n_rows":20,"n_cols":14,"rows_kept":20}
[]
[null,null,"半月式家用預算",{"$nulls":10},"資料清單"]
[]
[]
[null,null,"設定         以下的類別資料會填入 [支出與收入] 工作表 [支出] 表中的下拉式清單。修改各類別下方的類別名稱或描述，即可更新清單。"]
[]
[null,null,"家庭","娛樂","食物","禮物/捐贈","子女","投資帳戶","醫療","其他","個人","寵物","稅款/法律","交通"]
[null,null,"房貸","電影","雜貨","慈善 1","衣物","個人退休帳戶","醫生/診所","其他","衣物","食物","所得稅","汽車 1 車貸 "]
[null,null,"電費","錄影帶/影片","外食","慈善 2","玩具/遊戲","儲蓄","保險","會費","頭髮/指甲","生活用品","土地/房屋","汽車 2 車貸 "]
[null,null,"水費","音樂",null,"慈善 3","午餐費","支票",null,null,"乾洗","醫療","燃料/牌照","汽車保險"]
[null,null,"垃圾","音樂會/電影院",null,"禮物","稅金/服務費","退休",null,null,"健身俱樂部","美容","其他","牌照/註冊"]
[null,null,"手機","體育賽事",null,null,"學校用品","投資帳戶",null,null,"購物","其他","律師費","油資"]
[null,null,"住家電話","其他",null,null,"其他","大學",null,null,"其他",null,"子女撫養","保養/維修"]
[null,null,"網際網路",{"$nulls":3},"洗衣","貸款",{"$nulls":4},"扶養/贍養","大眾運輸"]
[null,null,"電視",{"$nulls":4},"助學貸款",{"$nulls":4},"其他"]
[null,null,"保養/維修"]
[null,null,"生活用品"]
[null,null,"有線電視/網際網路/電話"]
[null,null,"信用卡 1 "]
[null,null,"信用卡 2 "]

{"sheet":"類別樞紐分析表","index":4,"n_rows":16,"n_cols":14,"rows_kept":16,"hidden":true}
[]
[null,null,"半月式家用預算",{"$nulls":10},"類別樞紐分析表"]
[]
[]
[null,"此樞紐分析表為 [預算報表] 中 [類別總計] 樞紐分析圖的資料夾源。 "]
[]
[null,null,"列標籤","加總 - 金額"]
[null,null,"子女",{"v":4500,"d":"NT$4,500.00"}]
[null,null,"交通",{"v":27750,"d":"NT$27,750.00"}]
[null,null,"投資帳戶",{"v":15000,"d":"NT$15,000.00"}]
[null,null,"食物",{"v":12750,"d":"NT$12,750.00"}]
[null,null,"個人",{"v":3000,"d":"NT$3,000.00"}]
[null,null,"娛樂",{"v":3360,"d":"NT$3,360.00"}]
[null,null,"家庭",{"v":236400,"d":"NT$236,400.00"}]
[null,null,"寵物",{"v":4500,"d":"NT$4,500.00"}]
[null,null,"總計",{"v":307260,"d":"NT$307,260.00"}]