{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["指南","每年現金流量","每月現金流量","每日現金流量"],"not_rendered":{"charts":4,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"指南","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[4,1,5,5]]}
[]
[]
[]
[null,"個人現金流量"]
[null,"本工作表具備 每年、 每月 與 每日 現金流量工作表。請選擇最適合自己的現金流量類型，或全部套用以協助瞭解您的個人現金流量。"]
[]
[]
[]
[null,"每年現金流量",null,"每月現金流量",null,"每日現金流量"]
[]
[null,"輸入各方面的年度現金流量金額。查看每月細目並比較各個項目，最重要的是掌握每年與每月數據的損益底線。",null,"請輸入每月所發生的每月現金流量，或對其他月份加以評估，以瞭解該年度中各個月份的預估現金流量。",null,"請輸入每日所發生的估計現金流量金額，並查看估計的每月與年度總計。請使用本工作表瞭解您在經過一個月或一年的時間後所呈現的每日消費習慣。"]

{"sheet":"每年現金流量","index":1,"n_rows":48,"n_cols":16,"rows_kept":48,"merged":[[1,1,1,5],[1,7,1,15],[5,2,5,3],[5,6,5,7],[5,10,5,11],[5,14,5,15],[16,1,16,3],[25,2,25,3],[25,6,25,7],[25,10,25,11],[25,14,25,15]]}
[null,"個人現金流量"]
[null,{"$f":"AnnualCashFlowToDate","v":{"v":397500,"d":"NT$397,500.00"}},{"$nulls":5},"此為年度評估。若要檢視年度金額與每月估計值，請使用本工作表。\n若要將每日項目新增到表格中，請估計這些項目的年度金額/數值並輸入在 [每年] 欄位中。"]
[]
[]
[null,"收入摘要",{"$nulls":3},"支出摘要",{"$nulls":3},"裁量支出摘要",{"$nulls":3},"儲蓄摘要"]
[null,"年度總計：",{"$f":"tblIncome[[#Totals],[每年  ]]","v":{"v":1250000,"d":"NT$1,250,000.00"}},null,null,"年度總計：",{"$f":"tblExpenses[[#Totals],[每年  ]]","v":{"v":490000,"d":"NT$490,000.00"}},null,null,"年度總計：",{"$f":"tblDiscretionary[[#Totals],[每年  ]]","v":{"v":132500,"d":"NT$132,500.00"}},null,null,"年度總計：",{"$f":"tblSavings[[#Totals],[每年  ]]","v":{"v":230000,"d":"NT$230,000.00"}}]
{"$rows_empty":19}
[null,"每月總計：",{"$f":"tblIncome[[#Totals],[每月 ]]","v":{"v":104166.66666666667,"d":"NT$104,166.67"}},null,null,"每月總計：",{"$f":"tblExpenses[[#Totals],[每月 ]]","v":{"v":40833.33333333333,"d":"NT$40,833.33"}},null,null,"每月總計：",{"$f":"tblDiscretionary[[#Totals],[每月 ]]","v":{"v":11041.666666666668,"d":"NT$11,041.67"}},null,null,"每月總計：",{"$f":"tblSavings[[#Totals],[每月 ]]","v":{"v":19166.666666666668,"d":"NT$19,166.67"}}]
[]
[]
[null,"收入","每年  ","每月 ",null,"費用","每年  ","每月 ",null,"裁量支出","每年  ","每月 ",null,"存款","每年  ","每月 "]
[null,"薪資",{"v":900000,"d":"NT$900,000.00"},{"$f":"tblIncome[[#This Row],[每年  ]]/12","v":{"v":75000,"d":"NT$75,000.00"}},null,"所得稅/社會安全/醫療稅",{"v":150000,"d":"NT$150,000.00"},{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":12500,"d":"NT$12,500.00"}},null,"用餐",{"v":12000,"d":"NT$12,000.00"},{"$f":"tblDiscretionary[[#This Row],[每年  ]]/12","v":{"v":1000,"d":"NT$1,000.00"}},null,"預備金",{"v":50000,"d":"NT$50,000.00"},{"$f":"tblSavings[[#This Row],[每年  ]]/12","v":{"v":4166.666666666667,"d":"NT$4,166.67"}}]
[null,"佣金/獎金",{"v":50000,"d":"NT$50,000.00"},{"$f":"tblIncome[[#This Row],[每年  ]]/12","v":{"v":4166.666666666667,"d":"NT$4,166.67"}},null,"國家所得稅",{"v":25000,"d":"NT$25,000.00"},{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":2083.3333333333335,"d":"NT$2,083.33"}},null,"禮物",{"v":6000,"d":"NT$6,000.00"},{"$f":"tblDiscretionary[[#This Row],[每年  ]]/12","v":{"v":500,"d":"NT$500.00"}},null,"401(k)/Etc",{"v":120000,"d":"NT$120,000.00"},{"$f":"tblSavings[[#This Row],[每年  ]]/12","v":{"v":10000,"d":"NT$10,000.00"}}]
[null,"其他 1",{"v":300000,"d":"NT$300,000.00"},{"$f":"tblIncome[[#This Row],[每年  ]]/12","v":{"v":25000,"d":"NT$25,000.00"}},null,"車輛稅/費",{"v":2000,"d":"NT$2,000.00"},{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":166.66666666666666,"d":"NT$166.67"}},null,"旅遊",{"v":22500,"d":"NT$22,500.00"},{"$f":"tblDiscretionary[[#This Row],[每年  ]]/12","v":{"v":1875,"d":"NT$1,875.00"}},null,"儲蓄/投資",{"v":60000,"d":"NT$60,000.00"},{"$f":"tblSavings[[#This Row],[每年  ]]/12","v":{"v":5000,"d":"NT$5,000.00"}}]
[null,"其他 2",null,{"$f":"tblIncome[[#This Row],[每年  ]]/12","v":{"v":0,"d":"NT$0.00"}},null,"車貸",{"v":40000,"d":"NT$40,000.00"},{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":3333.3333333333335,"d":"NT$3,333.33"}},null,"娛樂",{"v":12000,"d":"NT$12,000.00"},{"$f":"tblDiscretionary[[#This Row],[每年  ]]/12","v":{"v":1000,"d":"NT$1,000.00"}},null,"其他 1",null,{"$f":"tblSavings[[#This Row],[每年  ]]/12","v":{"v":0,"d":"NT$0.00"}}]
[null,"其他 3",null,{"$f":"tblIncome[[#This Row],[每年  ]]/12","v":{"v":0,"d":"NT$0.00"}},null,"貸款/房租",{"v":150000,"d":"NT$150,000.00"},{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":12500,"d":"NT$12,500.00"}},null,"個人保健",{"v":3000,"d":"NT$3,000.00"},{"$f":"tblDiscretionary[[#This Row],[每年  ]]/12","v":{"v":250,"d":"NT$250.00"}},null,"其他 2",null,{"$f":"tblSavings[[#This Row],[每年  ]]/12","v":{"v":0,"d":"NT$0.00"}}]
[null,"其他 4",null,{"$f":"tblIncome[[#This Row],[每年  ]]/12","v":{"v":0,"d":"NT$0.00"}},null,"保險",{"v":2500,"d":"NT$2,500.00"},{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":208.33333333333334,"d":"NT$208.33"}},null,"購物",{"v":20000,"d":"NT$20,000.00"},{"$f":"tblDiscretionary[[#This Row],[每年  ]]/12","v":{"v":1666.6666666666667,"d":"NT$1,666.67"}},null," 合計",{"$f":"SUBTOTAL(109,tblSavings[[每年  ]])","v":{"v":230000,"d":"NT$230,000.00"}},{"$f":"SUBTOTAL(109,tblSavings[[每月 ]])","v":{"v":19166.666666666668,"d":"NT$19,166.67"}}]
[null," 合計",{"$f":"SUBTOTAL(109,tblIncome[[每年  ]])","v":{"v":1250000,"d":"NT$1,250,000.00"}},{"$f":"SUBTOTAL(109,tblIncome[[每月 ]])","v":{"v":104166.66666666667,"d":"NT$104,166.67"}},null,"電",{"v":12000,"d":"NT$12,000.00"},{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":1000,"d":"NT$1,000.00"}},null,"慈善",{"v":6000,"d":"NT$6,000.00"},{"$f":"tblDiscretionary[[#This Row],[每年  ]]/12","v":{"v":500,"d":"NT$500.00"}}]
[{"$nulls":5},"瓦斯",{"v":6000,"d":"NT$6,000.00"},{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":500,"d":"NT$500.00"}},null,"俱樂部/會員",{"v":3000,"d":"NT$3,000.00"},{"$f":"tblDiscretionary[[#This Row],[每年  ]]/12","v":{"v":250,"d":"NT$250.00"}}]
[{"$nulls":5},"水/汙水處理",{"v":6000,"d":"NT$6,000.00"},{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":500,"d":"NT$500.00"}},null,"居家修繕",{"v":48000,"d":"NT$48,000.00"},{"$f":"tblDiscretionary[[#This Row],[每年  ]]/12","v":{"v":4000,"d":"NT$4,000.00"}}]
[{"$nulls":5},"垃圾",{"v":1500,"d":"NT$1,500.00"},{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":125,"d":"NT$125.00"}},null,"其他 1",null,{"$f":"tblDiscretionary[[#This Row],[每年  ]]/12","v":{"v":0,"d":"NT$0.00"}}]
[{"$nulls":5},"電話",{"v":6000,"d":"NT$6,000.00"},{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":500,"d":"NT$500.00"}},null,"其他 2",null,{"$f":"tblDiscretionary[[#This Row],[每年  ]]/12","v":{"v":0,"d":"NT$0.00"}}]
[{"$nulls":5},"網路",{"v":6000,"d":"NT$6,000.00"},{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":500,"d":"NT$500.00"}},null," 合計",{"$f":"SUBTOTAL(109,tblDiscretionary[[每年  ]])","v":{"v":132500,"d":"NT$132,500.00"}},{"$f":"SUBTOTAL(109,tblDiscretionary[[每月 ]])","v":{"v":11041.666666666668,"d":"NT$11,041.67"}}]
[{"$nulls":5},"生活/殘障津貼",{"v":15000,"d":"NT$15,000.00"},{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":1250,"d":"NT$1,250.00"}}]
[{"$nulls":5},"食物",{"v":50000,"d":"NT$50,000.00"},{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":4166.666666666667,"d":"NT$4,166.67"}}]
[{"$nulls":5},"衣物",{"v":12000,"d":"NT$12,000.00"},{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":1000,"d":"NT$1,000.00"}}]
[{"$nulls":5},"醫療/牙醫/處方",{"v":6000,"d":"NT$6,000.00"},{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":500,"d":"NT$500.00"}}]
[{"$nulls":5},"其他 1",null,{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":0,"d":"NT$0.00"}}]
[{"$nulls":5},"其他 2",null,{"$f":"tblExpenses[[#This Row],[每年  ]]/12","v":{"v":0,"d":"NT$0.00"}}]
[{"$nulls":5}," 合計",{"$f":"SUBTOTAL(109,tblExpenses[[每年  ]])","v":{"v":490000,"d":"NT$490,000.00"}},{"$f":"SUBTOTAL(109,tblExpenses[[每月 ]])","v":{"v":40833.33333333333,"d":"NT$40,833.33"}}]

{"sheet":"每月現金流量","index":2,"n_rows":49,"n_cols":16,"rows_kept":49,"merged":[[1,1,1,5],[1,7,1,16],[49,1,49,15]]}
[null,"個人現金流量"]
[null,{"$f":"MonthlyCashFlowToDate","v":{"v":-1597057.5,"d":"-NT$1,597,057.50"}},{"$nulls":5},"注意：對於每日項目，請估計每月金額/數值並輸入在適當的月份欄位中。"]
[]
[]
[null,"類型","描述","一月","二月","三月","四月","五月","六月","七月","八月","九月","十月","十一月","十二月","合計"]
[null,"收入","薪資",{"v":75000,"d":"NT$75,000.00"},{"v":75000,"d":"NT$75,000.00"},{"v":75000,"d":"NT$75,000.00"},{"v":75000,"d":"NT$75,000.00"},{"v":75000,"d":"NT$75,000.00"},{"v":75000,"d":"NT$75,000.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":450000,"d":"NT$450,000.00"}}]
[null,"收入","佣金/獎金",{"v":4000,"d":"NT$4,000.00"},{"v":4000,"d":"NT$4,000.00"},{"v":5000,"d":"NT$5,000.00"},{"v":2000,"d":"NT$2,000.00"},{"v":0,"d":"NT$0.00"},{"v":6000,"d":"NT$6,000.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":21000,"d":"NT$21,000.00"}}]
[null,"收入","其他 1",{"v":25000,"d":"NT$25,000.00"},{"v":25000,"d":"NT$25,000.00"},{"v":25000,"d":"NT$25,000.00"},{"v":25000,"d":"NT$25,000.00"},{"v":25000,"d":"NT$25,000.00"},{"v":25000,"d":"NT$25,000.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":150000,"d":"NT$150,000.00"}}]
[null,"收入","其他 2",{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":0,"d":"NT$0.00"}}]
[null,"收入","其他 3",{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":0,"d":"NT$0.00"}}]
[null,"收入","其他 4",{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":0,"d":"NT$0.00"}}]
[null,"費用","所得稅/社會安全/醫療稅",{"v":1250,"d":"NT$1,250.00"},{"v":125000,"d":"NT$125,000.00"},{"v":12500,"d":"NT$12,500.00"},{"v":12500,"d":"NT$12,500.00"},{"v":12500,"d":"NT$12,500.00"},{"v":12500,"d":"NT$12,500.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":176250,"d":"NT$176,250.00"}}]
[null,"費用","國家所得稅",{"v":208.33333333333334,"d":"NT$208.33"},{"v":20833.333333333336,"d":"NT$20,833.33"},{"v":2083.3,"d":"NT$2,083.30"},{"v":2083.3,"d":"NT$2,083.30"},{"v":2083.3,"d":"NT$2,083.30"},{"v":2083.3,"d":"NT$2,083.30"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":29374.866666666665,"d":"NT$29,374.87"}}]
[null,"費用","車輛稅/費",{"v":16.666666666666668,"d":"NT$16.67"},{"v":1666.666666666667,"d":"NT$1,666.67"},{"v":166.70000000000002,"d":"NT$166.70"},{"v":166.70000000000002,"d":"NT$166.70"},{"v":166.70000000000002,"d":"NT$166.70"},{"v":166.70000000000002,"d":"NT$166.70"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":2350.1333333333337,"d":"NT$2,350.13"}}]
[null,"費用","車貸",{"v":333.3333333333333,"d":"NT$333.33"},{"v":33333.33333333333,"d":"NT$33,333.33"},{"v":3333.2999999999997,"d":"NT$3,333.30"},{"v":3333.2999999999997,"d":"NT$3,333.30"},{"v":3333.2999999999997,"d":"NT$3,333.30"},{"v":3333.2999999999997,"d":"NT$3,333.30"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":46999.866666666676,"d":"NT$46,999.87"}}]
[null,"費用","貸款/房租",{"v":1250,"d":"NT$1,250.00"},{"v":125000,"d":"NT$125,000.00"},{"v":12500,"d":"NT$12,500.00"},{"v":12500,"d":"NT$12,500.00"},{"v":12500,"d":"NT$12,500.00"},{"v":12500,"d":"NT$12,500.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":176250,"d":"NT$176,250.00"}}]
[null,"費用","保險",{"v":25,"d":"NT$25.00"},{"v":2500,"d":"NT$2,500.00"},{"v":250,"d":"NT$250.00"},{"v":250,"d":"NT$250.00"},{"v":250,"d":"NT$250.00"},{"v":250,"d":"NT$250.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":3525,"d":"NT$3,525.00"}}]
[null,"費用","電",{"v":100,"d":"NT$100.00"},{"v":10000,"d":"NT$10,000.00"},{"v":1000,"d":"NT$1,000.00"},{"v":1000,"d":"NT$1,000.00"},{"v":1000,"d":"NT$1,000.00"},{"v":1000,"d":"NT$1,000.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":14100,"d":"NT$14,100.00"}}]
[null,"費用","瓦斯",{"v":50,"d":"NT$50.00"},{"v":5000,"d":"NT$5,000.00"},{"v":500,"d":"NT$500.00"},{"v":500,"d":"NT$500.00"},{"v":500,"d":"NT$500.00"},{"v":500,"d":"NT$500.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":7050,"d":"NT$7,050.00"}}]
[null,"費用","水",{"v":50,"d":"NT$50.00"},{"v":5000,"d":"NT$5,000.00"},{"v":500,"d":"NT$500.00"},{"v":500,"d":"NT$500.00"},{"v":500,"d":"NT$500.00"},{"v":500,"d":"NT$500.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":7050,"d":"NT$7,050.00"}}]
[null,"費用","汙水處理",{"v":25,"d":"NT$25.00"},{"v":2500,"d":"NT$2,500.00"},{"v":250,"d":"NT$250.00"},{"v":250,"d":"NT$250.00"},{"v":250,"d":"NT$250.00"},{"v":250,"d":"NT$250.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":3525,"d":"NT$3,525.00"}}]
[null,"費用","垃圾",{"v":12.5,"d":"NT$12.50"},{"v":1250,"d":"NT$1,250.00"},{"v":125,"d":"NT$125.00"},{"v":125,"d":"NT$125.00"},{"v":125,"d":"NT$125.00"},{"v":125,"d":"NT$125.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":1762.5,"d":"NT$1,762.50"}}]
[null,"費用","電話",{"v":50,"d":"NT$50.00"},{"v":5000,"d":"NT$5,000.00"},{"v":500,"d":"NT$500.00"},{"v":500,"d":"NT$500.00"},{"v":500,"d":"NT$500.00"},{"v":500,"d":"NT$500.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":7050,"d":"NT$7,050.00"}}]
[null,"費用","網路",{"v":50,"d":"NT$50.00"},{"v":5000,"d":"NT$5,000.00"},{"v":500,"d":"NT$500.00"},{"v":500,"d":"NT$500.00"},{"v":500,"d":"NT$500.00"},{"v":500,"d":"NT$500.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":7050,"d":"NT$7,050.00"}}]
[null,"費用","生活/殘障津貼",{"v":125,"d":"NT$125.00"},{"v":12500,"d":"NT$12,500.00"},{"v":1250,"d":"NT$1,250.00"},{"v":1250,"d":"NT$1,250.00"},{"v":1250,"d":"NT$1,250.00"},{"v":1250,"d":"NT$1,250.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":17625,"d":"NT$17,625.00"}}]
[null,"費用","食物",{"v":400,"d":"NT$400.00"},{"v":40000,"d":"NT$40,000.00"},{"v":4500,"d":"NT$4,500.00"},{"v":4000,"d":"NT$4,000.00"},{"v":4500,"d":"NT$4,500.00"},{"v":4250,"d":"NT$4,250.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":57650,"d":"NT$57,650.00"}}]
[null,"費用","衣物",{"v":50,"d":"NT$50.00"},{"v":5000,"d":"NT$5,000.00"},{"v":1000,"d":"NT$1,000.00"},{"v":750,"d":"NT$750.00"},{"v":1250,"d":"NT$1,250.00"},{"v":750,"d":"NT$750.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":8800,"d":"NT$8,800.00"}}]
[null,"費用","醫療/牙醫/處方",{"v":50,"d":"NT$50.00"},{"v":5000,"d":"NT$5,000.00"},{"v":250,"d":"NT$250.00"},{"v":250,"d":"NT$250.00"},{"v":200,"d":"NT$200.00"},{"v":700,"d":"NT$700.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":6450,"d":"NT$6,450.00"}}]
[null,"費用","公車",{"v":30,"d":"NT$30.00"},{"v":3000,"d":"NT$3,000.00"},{"v":300,"d":"NT$300.00"},{"v":200,"d":"NT$200.00"},{"v":300,"d":"NT$300.00"},{"v":300,"d":"NT$300.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":4130,"d":"NT$4,130.00"}}]
[null,"費用","其他 2",{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":0,"d":"NT$0.00"}}]
[null,"費用","其他 3",{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":0,"d":"NT$0.00"}}]
[null,"費用","其他 4",{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":0,"d":"NT$0.00"}}]
[null,"裁量","用餐",{"v":50,"d":"NT$50.00"},{"v":5000,"d":"NT$5,000.00"},{"v":1000,"d":"NT$1,000.00"},{"v":500,"d":"NT$500.00"},{"v":1500,"d":"NT$1,500.00"},{"v":1000,"d":"NT$1,000.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":9050,"d":"NT$9,050.00"}}]
[null,"裁量","禮物",{"v":25,"d":"NT$25.00"},{"v":2500,"d":"NT$2,500.00"},{"v":500,"d":"NT$500.00"},{"v":250,"d":"NT$250.00"},{"v":750,"d":"NT$750.00"},{"v":500,"d":"NT$500.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":4525,"d":"NT$4,525.00"}}]
[null,"裁量","旅遊",{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":10000,"d":"NT$10,000.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":10000,"d":"NT$10,000.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":20000,"d":"NT$20,000.00"}}]
[null,"裁量","娛樂",{"v":50,"d":"NT$50.00"},{"v":5000,"d":"NT$5,000.00"},{"v":1000,"d":"NT$1,000.00"},{"v":500,"d":"NT$500.00"},{"v":1500,"d":"NT$1,500.00"},{"v":1000,"d":"NT$1,000.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":9050,"d":"NT$9,050.00"}}]
[null,"裁量","個人保健",{"v":15,"d":"NT$15.00"},{"v":1500,"d":"NT$1,500.00"},{"v":350,"d":"NT$350.00"},{"v":150,"d":"NT$150.00"},{"v":250,"d":"NT$250.00"},{"v":350,"d":"NT$350.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":2615,"d":"NT$2,615.00"}}]
[null,"裁量","購物",{"v":100,"d":"NT$100.00"},{"v":10000,"d":"NT$10,000.00"},{"v":1500,"d":"NT$1,500.00"},{"v":1750,"d":"NT$1,750.00"},{"v":1500,"d":"NT$1,500.00"},{"v":1750,"d":"NT$1,750.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":16600,"d":"NT$16,600.00"}}]
[null,"裁量","慈善",{"v":50,"d":"NT$50.00"},{"v":5000,"d":"NT$5,000.00"},{"v":500,"d":"NT$500.00"},{"v":500,"d":"NT$500.00"},{"v":500,"d":"NT$500.00"},{"v":500,"d":"NT$500.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":7050,"d":"NT$7,050.00"}}]
[null,"裁量","俱樂部/會員",{"v":25,"d":"NT$25.00"},{"v":2500,"d":"NT$2,500.00"},{"v":250,"d":"NT$250.00"},{"v":250,"d":"NT$250.00"},{"v":250,"d":"NT$250.00"},{"v":250,"d":"NT$250.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":3525,"d":"NT$3,525.00"}}]
[null,"裁量","居家修繕",{"v":400,"d":"NT$400.00"},{"v":40000,"d":"NT$40,000.00"},{"v":4000,"d":"NT$4,000.00"},{"v":4000,"d":"NT$4,000.00"},{"v":4000,"d":"NT$4,000.00"},{"v":4000,"d":"NT$4,000.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":56400,"d":"NT$56,400.00"}}]
[null,"裁量","其他 1",{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":0,"d":"NT$0.00"}}]
[null,"裁量","其他 2",{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":0,"d":"NT$0.00"}}]
[null,"存款","預備金",{"v":416.6666666666667,"d":"NT$416.67"},{"v":41666.66666666667,"d":"NT$41,666.67"},{"v":4166.7,"d":"NT$4,166.70"},{"v":4166.7,"d":"NT$4,166.70"},{"v":4166.7,"d":"NT$4,166.70"},{"v":4166.7,"d":"NT$4,166.70"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":58750.133333333324,"d":"NT$58,750.13"}}]
[null,"存款","401(k)/Etc",{"v":1000,"d":"NT$1,000.00"},{"v":100000,"d":"NT$100,000.00"},{"v":10000,"d":"NT$10,000.00"},{"v":10000,"d":"NT$10,000.00"},{"v":10000,"d":"NT$10,000.00"},{"v":10000,"d":"NT$10,000.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":141000,"d":"NT$141,000.00"}}]
[null,"存款","儲蓄/投資帳戶",{"v":500,"d":"NT$500.00"},{"v":50000,"d":"NT$50,000.00"},{"v":5000,"d":"NT$5,000.00"},{"v":5000,"d":"NT$5,000.00"},{"v":5000,"d":"NT$5,000.00"},{"v":5000,"d":"NT$5,000.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":70500,"d":"NT$70,500.00"}}]
[null,"存款","其他 1",{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":0,"d":"NT$0.00"}}]
[null,"存款","其他 2",{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[一月]:[十二月]])","v":{"v":0,"d":"NT$0.00"}}]
[null," 合計",null,{"$f":"SUMIF(tblMontly[類型],\"Income\",tblMontly[一月])-SUMIF(tblMontly[類型],\"<>Income\",tblMontly[一月])","v":{"v":-110707.5,"d":"(NT$110,707.50)"}},{"$f":"SUMIF(tblMontly[類型],\"Income\",tblMontly[二月])-SUMIF(tblMontly[類型],\"<>Income\",tblMontly[二月])","v":{"v":-774749.9999999999,"d":"(NT$774,750.00)"}},{"$f":"SUMIF(tblMontly[類型],\"Income\",tblMontly[三月])-SUMIF(tblMontly[類型],\"<>Income\",tblMontly[三月])","v":{"v":-184775,"d":"(NT$184,775.00)"}},{"$f":"SUMIF(tblMontly[類型],\"Income\",tblMontly[四月])-SUMIF(tblMontly[類型],\"<>Income\",tblMontly[四月])","v":{"v":-169725,"d":"(NT$169,725.00)"}},{"$f":"SUMIF(tblMontly[類型],\"Income\",tblMontly[五月])-SUMIF(tblMontly[類型],\"<>Income\",tblMontly[五月])","v":{"v":-171125,"d":"(NT$171,125.00)"}},{"$f":"SUMIF(tblMontly[類型],\"Income\",tblMontly[六月])-SUMIF(tblMontly[類型],\"<>Income\",tblMontly[六月])","v":{"v":-185975,"d":"(NT$185,975.00)"}},{"$f":"SUMIF(tblMontly[類型],\"Income\",tblMontly[七月])-SUMIF(tblMontly[類型],\"<>Income\",tblMontly[七月])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIF(tblMontly[類型],\"Income\",tblMontly[八月])-SUMIF(tblMontly[類型],\"<>Income\",tblMontly[八月])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIF(tblMontly[類型],\"Income\",tblMontly[九月])-SUMIF(tblMontly[類型],\"<>Income\",tblMontly[九月])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIF(tblMontly[類型],\"Income\",tblMontly[十月])-SUMIF(tblMontly[類型],\"<>Income\",tblMontly[十月])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIF(tblMontly[類型],\"Income\",tblMontly[十一月])-SUMIF(tblMontly[類型],\"<>Income\",tblMontly[十一月])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIF(tblMontly[類型],\"Income\",tblMontly[十二月])-SUMIF(tblMontly[類型],\"<>Income\",tblMontly[十二月])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUMIF(tblMontly[類型],\"Income\",tblMontly[合計])-SUMIF(tblMontly[類型],\"<>Income\",tblMontly[合計])","v":{"v":-1597057.5,"d":"(NT$1,597,057.50)"}}]

{"sheet":"每日現金流量","index":3,"n_rows":56,"n_cols":8,"rows_kept":56,"merged":[[1,1,1,5],[1,7,1,16],[9,1,9,5]]}
[null,"個人現金流量"]
[null,{"$f":"DailyCashFlow","v":{"v":5778.400000000001,"d":"NT$5,778.40"}},{"$nulls":5},"NOTE: If you wish to add daily items to the Table, estimate their monthly amount/value and place value in the appropriate month column."]
[]
[null,"每日摘要"]
[null,"合計"," ","每日","每月","每年 "]
[null,"收入",null,{"$f":"SUMIF(tblDaily[類型],tblDailyTotals[[#This Row],[合計]],tblDaily[每日])","v":{"v":3424.7000000000003,"d":"NT$3,424.70"}},{"$f":"SUMIF(tblDaily[類型],tblDailyTotals[[#This Row],[合計]],tblDaily[每月])","v":{"v":104167.95833333333,"d":"NT$104,167.96"}},{"$f":"SUMIF(tblDaily[類型],tblDailyTotals[[#This Row],[合計]],tblDaily[每年])","v":{"v":1250015.5,"d":"NT$1,250,015.50"}}]
[null,"費用",null,{"$f":"SUMIF(tblDaily[類型],tblDailyTotals[[#This Row],[合計]],tblDaily[每日])","v":{"v":1360.6000000000004,"d":"NT$1,360.60"}},{"$f":"SUMIF(tblDaily[類型],tblDailyTotals[[#This Row],[合計]],tblDaily[每月])","v":{"v":41384.91666666667,"d":"NT$41,384.92"}},{"$f":"SUMIF(tblDaily[類型],tblDailyTotals[[#This Row],[合計]],tblDaily[每年])","v":{"v":496619,"d":"NT$496,619.00"}}]
[null,"裁量",null,{"$f":"SUMIF(tblDaily[類型],tblDailyTotals[[#This Row],[合計]],tblDaily[每日])","v":{"v":362.9,"d":"NT$362.90"}},{"$f":"SUMIF(tblDaily[類型],tblDailyTotals[[#This Row],[合計]],tblDaily[每月])","v":{"v":11038.208333333332,"d":"NT$11,038.21"}},{"$f":"SUMIF(tblDaily[類型],tblDailyTotals[[#This Row],[合計]],tblDaily[每年])","v":{"v":132458.5,"d":"NT$132,458.50"}}]
[null,"存款",null,{"$f":"SUMIF(tblDaily[類型],tblDailyTotals[[#This Row],[合計]],tblDaily[每日])","v":{"v":630.2,"d":"NT$630.20"}},{"$f":"SUMIF(tblDaily[類型],tblDailyTotals[[#This Row],[合計]],tblDaily[每月])","v":{"v":19168.583333333332,"d":"NT$19,168.58"}},{"$f":"SUMIF(tblDaily[類型],tblDailyTotals[[#This Row],[合計]],tblDaily[每年])","v":{"v":230023,"d":"NT$230,023.00"}}]
[]
[]
[null,"類型","描述","每日","每月","每年"]
[null,"收入","薪資",{"v":2465.8,"d":"NT$2,465.80"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":75001.41666666667,"d":"NT$75,001.42"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":900017.0000000001,"d":"NT$900,017.00"}}]
[null,"收入","佣金/獎金",{"v":137,"d":"NT$137.00"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":4167.083333333333,"d":"NT$4,167.08"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":50005,"d":"NT$50,005.00"}}]
[null,"收入","其他 1",{"v":821.9,"d":"NT$821.90"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":24999.458333333332,"d":"NT$24,999.46"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":299993.5,"d":"NT$299,993.50"}}]
[null,"收入","其他 2",{"v":0,"d":"NT$0.00"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":0,"d":"NT$0.00"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":0,"d":"NT$0.00"}}]
[null,"收入","其他 3",{"v":0,"d":"NT$0.00"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":0,"d":"NT$0.00"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":0,"d":"NT$0.00"}}]
[null,"收入","其他 4",{"v":0,"d":"NT$0.00"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":0,"d":"NT$0.00"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":0,"d":"NT$0.00"}}]
[null,"費用","所得稅/社會安全/醫療稅",{"v":411,"d":"NT$411.00"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":12501.25,"d":"NT$12,501.25"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":150015,"d":"NT$150,015.00"}}]
[null,"費用","國家所得稅",{"v":68.5,"d":"NT$68.50"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":2083.5416666666665,"d":"NT$2,083.54"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":25002.5,"d":"NT$25,002.50"}}]
[null,"費用","車輛稅/費",{"v":5.5,"d":"NT$5.50"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":167.29166666666666,"d":"NT$167.29"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":2007.5,"d":"NT$2,007.50"}}]
[null,"費用","車貸",{"v":109.60000000000001,"d":"NT$109.60"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":3333.6666666666665,"d":"NT$3,333.67"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":40004,"d":"NT$40,004.00"}}]
[null,"費用","貸款/房租",{"v":411,"d":"NT$411.00"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":12501.25,"d":"NT$12,501.25"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":150015,"d":"NT$150,015.00"}}]
[null,"費用","保險",{"v":6.800000000000001,"d":"NT$6.80"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":206.83333333333337,"d":"NT$206.83"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":2482.0000000000005,"d":"NT$2,482.00"}}]
[null,"費用","電",{"v":32.9,"d":"NT$32.90"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":1000.7083333333334,"d":"NT$1,000.71"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":12008.5,"d":"NT$12,008.50"}}]
[null,"費用","瓦斯",{"v":16.4,"d":"NT$16.40"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":498.83333333333326,"d":"NT$498.83"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":5985.999999999999,"d":"NT$5,986.00"}}]
[null,"費用","水",{"v":16.4,"d":"NT$16.40"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":498.83333333333326,"d":"NT$498.83"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":5985.999999999999,"d":"NT$5,986.00"}}]
[null,"費用","汙水處理",{"v":8.2,"d":"NT$8.20"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":249.41666666666663,"d":"NT$249.42"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":2992.9999999999995,"d":"NT$2,993.00"}}]
[null,"費用","垃圾",{"v":4.1,"d":"NT$4.10"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":124.70833333333331,"d":"NT$124.71"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":1496.4999999999998,"d":"NT$1,496.50"}}]
[null,"費用","電話",{"v":16.4,"d":"NT$16.40"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":498.83333333333326,"d":"NT$498.83"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":5985.999999999999,"d":"NT$5,986.00"}}]
[null,"費用","網路",{"v":16.4,"d":"NT$16.40"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":498.83333333333326,"d":"NT$498.83"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":5985.999999999999,"d":"NT$5,986.00"}}]
[null,"費用","生活/殘障津貼",{"v":41.1,"d":"NT$41.10"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":1250.125,"d":"NT$1,250.13"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":15001.5,"d":"NT$15,001.50"}}]
[null,"費用","食物",{"v":137,"d":"NT$137.00"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":4167.083333333333,"d":"NT$4,167.08"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":50005,"d":"NT$50,005.00"}}]
[null,"費用","衣物",{"v":32.9,"d":"NT$32.90"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":1000.7083333333334,"d":"NT$1,000.71"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":12008.5,"d":"NT$12,008.50"}}]
[null,"費用","醫療/牙醫/處方",{"v":16.4,"d":"NT$16.40"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":498.83333333333326,"d":"NT$498.83"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":5985.999999999999,"d":"NT$5,986.00"}}]
[null,"費用","公車",{"v":10,"d":"NT$10.00"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":304.1666666666667,"d":"NT$304.17"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":3650,"d":"NT$3,650.00"}}]
[null,"費用","其他 2",{"v":0,"d":"NT$0.00"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":0,"d":"NT$0.00"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":0,"d":"NT$0.00"}}]
[null,"費用","其他 3",{"v":0,"d":"NT$0.00"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":0,"d":"NT$0.00"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":0,"d":"NT$0.00"}}]
[null,"費用","其他 4",{"v":0,"d":"NT$0.00"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":0,"d":"NT$0.00"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":0,"d":"NT$0.00"}}]
[null,"裁量","用餐",{"v":32.9,"d":"NT$32.90"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":1000.7083333333334,"d":"NT$1,000.71"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":12008.5,"d":"NT$12,008.50"}}]
[null,"裁量","禮物",{"v":16.4,"d":"NT$16.40"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":498.83333333333326,"d":"NT$498.83"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":5985.999999999999,"d":"NT$5,986.00"}}]
[null,"裁量","旅遊",{"v":61.6,"d":"NT$61.60"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":1873.6666666666667,"d":"NT$1,873.67"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":22484,"d":"NT$22,484.00"}}]
[null,"裁量","娛樂",{"v":32.9,"d":"NT$32.90"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":1000.7083333333334,"d":"NT$1,000.71"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":12008.5,"d":"NT$12,008.50"}}]
[null,"裁量","個人保健",{"v":8.2,"d":"NT$8.20"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":249.41666666666663,"d":"NT$249.42"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":2992.9999999999995,"d":"NT$2,993.00"}}]
[null,"裁量","購物",{"v":54.800000000000004,"d":"NT$54.80"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":1666.8333333333333,"d":"NT$1,666.83"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":20002,"d":"NT$20,002.00"}}]
[null,"裁量","慈善",{"v":16.4,"d":"NT$16.40"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":498.83333333333326,"d":"NT$498.83"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":5985.999999999999,"d":"NT$5,986.00"}}]
[null,"裁量","俱樂部/會員",{"v":8.2,"d":"NT$8.20"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":249.41666666666663,"d":"NT$249.42"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":2992.9999999999995,"d":"NT$2,993.00"}}]
[null,"裁量","居家修繕",{"v":131.5,"d":"NT$131.50"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":3999.7916666666665,"d":"NT$3,999.79"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":47997.5,"d":"NT$47,997.50"}}]
[null,"裁量","其他 1",{"v":0,"d":"NT$0.00"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":0,"d":"NT$0.00"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":0,"d":"NT$0.00"}}]
[null,"裁量","其他 2",{"v":0,"d":"NT$0.00"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":0,"d":"NT$0.00"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":0,"d":"NT$0.00"}}]
[null,"存款","預備金",{"v":137,"d":"NT$137.00"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":4167.083333333333,"d":"NT$4,167.08"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":50005,"d":"NT$50,005.00"}}]
[null,"存款","401(k)/Etc",{"v":328.8,"d":"NT$328.80"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":10001,"d":"NT$10,001.00"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":120012,"d":"NT$120,012.00"}}]
[null,"存款","儲蓄/投資帳戶",{"v":164.4,"d":"NT$164.40"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":5000.5,"d":"NT$5,000.50"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":60006,"d":"NT$60,006.00"}}]
[null,"存款","其他 1",{"v":0,"d":"NT$0.00"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":0,"d":"NT$0.00"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":0,"d":"NT$0.00"}}]
[null,"存款","其他 2",{"v":0,"d":"NT$0.00"},{"$f":"tblDaily[[#This Row],[每年]]/12","v":{"v":0,"d":"NT$0.00"}},{"$f":"tblDaily[[#This Row],[每日]]*365","v":{"v":0,"d":"NT$0.00"}}]
[null," 合計 ",null,{"$f":"SUMIF(tblDaily[類型],\"Income\",tblDaily[每日])-SUMIF(tblDaily[類型],\"<>Income\",tblDaily[每日])","v":{"v":-5778.399999999997,"d":"-NT$5,778.40"}},{"$f":"SUMIF(tblDaily[類型],\"Income\",tblDaily[每月])-SUMIF(tblDaily[類型],\"<>Income\",tblDaily[每月])","v":{"v":-175759.66666666677,"d":"-NT$175,759.67"}},{"$f":"SUMIF(tblDaily[類型],\"Income\",tblDaily[每年])-SUMIF(tblDaily[類型],\"<>Income\",tblDaily[每年])","v":{"v":-2109116,"d":"-NT$2,109,116.00"}}]