{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["預算規劃"],"not_rendered":{"charts":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"預算規劃","index":0,"n_rows":136,"n_cols":7,"rows_kept":136,"merged":[[15,1,15,5],[22,1,22,5],[36,2,36,5],[47,2,47,5],[54,2,54,5],[60,2,60,5],[72,2,72,5],[80,2,80,5],[90,2,90,5],[100,2,100,5],[109,2,109,5],[116,2,116,5],[123,2,123,5],[129,2,129,5],[136,2,136,5]]}
[{"$nulls":6}," "]
[{"$nulls":6}," "]
[]
[]
[]
[{"$nulls":6}," "]
[]
[]
[{"$nulls":6}," "]
[]
[]
[null,"  ","現金流","預計","實際值","差異"]
[null,null,"總收入",{"$f":"SUM(收入[預計])","v":{"v":5600,"d":"5,600"}},{"$f":"SUM(收入[實際值])","v":{"v":4700,"d":"4,700"}},{"$f":"SUM(收入[差異])","v":-900}]
[null,null,"總支出",{"$f":"totalExpenseProjected","v":{"v":1195,"d":"1,195"}},{"$f":"totalExpenseActual","v":736},{"$f":"現金流[[#This Row],[預計]]-現金流[[#This Row],[實際值]]","v":459}]
[null,null,"總現金流",{"$f":"D13-D14","v":{"v":4405,"d":"4,405"}},{"$f":"E13-E14","v":{"v":3964,"d":"3,964"}},{"$f":"現金流[[#This Row],[實際值]]-現金流[[#This Row],[預計]]","v":-441}]
[]
[null," ","月收入","預計","實際值","差異"]
[null,null,"收入 1",{"v":4000,"d":"4,000"},{"v":3000,"d":"3,000"},{"$f":"收入[[#This Row],[實際值]]-收入[[#This Row],[預計]]","v":{"v":-1000,"d":"-1,000"}}]
[null,null,"收入 2",{"v":1300,"d":"1,300"},{"v":1400,"d":"1,400"},{"$f":"收入[[#This Row],[實際值]]-收入[[#This Row],[預計]]","v":100}]
[null,null,"額外收入",300,300,{"$f":"收入[[#This Row],[實際值]]-收入[[#This Row],[預計]]","v":0}]
[null,null,"其他",null,null,{"$f":"收入[[#This Row],[實際值]]-收入[[#This Row],[預計]]","v":0}]
[null,null,"總收入",{"$f":"SUBTOTAL(109,收入[預計])","v":{"v":5600,"d":"5,600"}},{"$f":"SUBTOTAL(109,收入[實際值])","v":{"v":4700,"d":"4,700"}},{"$f":"SUBTOTAL(109,收入[差異])","v":-900}]
[]
[null,null,"住宅費用","預計","實際值","差異"]
[null,null,"貸款或租賃",{"v":1000,"d":"1,000"},500,{"$f":"住宅[[#This Row],[預計]]-住宅[[#This Row],[實際值]]","v":500}]
[null,null,"第二貸款或租賃",0,0,{"$f":"住宅[[#This Row],[預計]]-住宅[[#This Row],[實際值]]","v":0}]
[null,null,"電話",54,100,{"$f":"住宅[[#This Row],[預計]]-住宅[[#This Row],[實際值]]","v":-46}]
[null,null,"電",44,56,{"$f":"住宅[[#This Row],[預計]]-住宅[[#This Row],[實際值]]","v":-12}]
[null,null,"瓦斯",22,28,{"$f":"住宅[[#This Row],[預計]]-住宅[[#This Row],[實際值]]","v":-6}]
[null,null,"水費",8,8,{"$f":"住宅[[#This Row],[預計]]-住宅[[#This Row],[實際值]]","v":0}]
[null,null,"有線電視",34,34,{"$f":"住宅[[#This Row],[預計]]-住宅[[#This Row],[實際值]]","v":0}]
[null,null,"清潔費",10,10,{"$f":"住宅[[#This Row],[預計]]-住宅[[#This Row],[實際值]]","v":0}]
[null,null,"保養或維修",23,0,{"$f":"住宅[[#This Row],[預計]]-住宅[[#This Row],[實際值]]","v":23}]
[null,null,"用品",0,0,{"$f":"住宅[[#This Row],[預計]]-住宅[[#This Row],[實際值]]","v":0}]
[null,null,"其他",0,0,{"$f":"住宅[[#This Row],[預計]]-住宅[[#This Row],[實際值]]","v":0}]
[null,null,"總收入",{"$f":"SUBTOTAL(109,住宅[預計])","v":{"v":1195,"d":"1,195"}},{"$f":"SUBTOTAL(109,住宅[實際值])","v":736},{"$f":"SUBTOTAL(109,住宅[差異])","v":459}]
[]
[null,null,"交通","預計","實際值","差異"]
[null,null,"車輛 1 費用",null,null,{"$f":"交通[[#This Row],[預計]]-交通[[#This Row],[實際值]]","v":0}]
[null,null,"車輛 2 費用",null,null,{"$f":"交通[[#This Row],[預計]]-交通[[#This Row],[實際值]]","v":0}]
[null,null,"公車/計程車費",null,null,{"$f":"交通[[#This Row],[預計]]-交通[[#This Row],[實際值]]","v":0}]
[null,null,"保險",null,null,{"$f":"交通[[#This Row],[預計]]-交通[[#This Row],[實際值]]","v":0}]
[null,null,"授權",null,null,{"$f":"交通[[#This Row],[預計]]-交通[[#This Row],[實際值]]","v":0}]
[null,null,"油錢",null,null,{"$f":"交通[[#This Row],[預計]]-交通[[#This Row],[實際值]]","v":0}]
[null,null,"維護",null,null,{"$f":"交通[[#This Row],[預計]]-交通[[#This Row],[實際值]]","v":0}]
[null,null,"其他",null,null,{"$f":"交通[[#This Row],[預計]]-交通[[#This Row],[實際值]]","v":0}]
[null,null,"總收入",{"$f":"SUBTOTAL(109,交通[預計])","v":0},{"$f":"SUBTOTAL(109,交通[實際值])","v":0},{"$f":"SUBTOTAL(109,交通[差異])","v":0}]
[]
[null,null,"保險","預計","實際值","差異"]
[null,null,"回家",null,null,{"$f":"保險[[#This Row],[預計]]-保險[[#This Row],[實際值]]","v":0}]
[null,null,"保健",null,null,{"$f":"保險[[#This Row],[預計]]-保險[[#This Row],[實際值]]","v":0}]
[null,null,"壽險",null,null,{"$f":"保險[[#This Row],[預計]]-保險[[#This Row],[實際值]]","v":0}]
[null,null,"其他",null,null,{"$f":"保險[[#This Row],[預計]]-保險[[#This Row],[實際值]]","v":0}]
[null,null,"總收入",{"$f":"SUBTOTAL(109,保險[預計])","v":0},{"$f":"SUBTOTAL(109,保險[實際值])","v":0},{"$f":"SUBTOTAL(109,保險[差異])","v":0}]
[]
[null,null,"食物","預計","實際值","差異"]
[null,null,"日常雜貨",null,null,{"$f":"食物[[#This Row],[預計]]-食物[[#This Row],[實際值]]","v":0}]
[null,null,"外食",null,null,{"$f":"食物[[#This Row],[預計]]-食物[[#This Row],[實際值]]","v":0}]
[null,null,"其他",null,null,{"$f":"食物[[#This Row],[預計]]-食物[[#This Row],[實際值]]","v":0}]
[null,null,"總收入",{"$f":"SUBTOTAL(109,食物[預計])","v":0},{"$f":"SUBTOTAL(109,食物[實際值])","v":0},{"$f":"SUBTOTAL(109,食物[差異])","v":0}]
[]
[null,null,"子女","預計","實際值","差異"]
[null,null,"醫療",null,null,{"$f":"子女[[#This Row],[預計]]-子女[[#This Row],[實際值]]","v":0}]
[null,null,"衣物",null,null,{"$f":"子女[[#This Row],[預計]]-子女[[#This Row],[實際值]]","v":0}]
[null,null,"學費",null,null,{"$f":"子女[[#This Row],[預計]]-子女[[#This Row],[實際值]]","v":0}]
[null,null,"學校用品",null,null,{"$f":"子女[[#This Row],[預計]]-子女[[#This Row],[實際值]]","v":0}]
[null,null,"會費",null,null,{"$f":"子女[[#This Row],[預計]]-子女[[#This Row],[實際值]]","v":0}]
[null,null,"午餐費",null,null,{"$f":"子女[[#This Row],[預計]]-子女[[#This Row],[實際值]]","v":0}]
[null,null,"兒童託育費",null,null,{"$f":"子女[[#This Row],[預計]]-子女[[#This Row],[實際值]]","v":0}]
[null,null,"玩具/遊戲",null,null,{"$f":"子女[[#This Row],[預計]]-子女[[#This Row],[實際值]]","v":0}]
[null,null,"其他",null,null,{"$f":"子女[[#This Row],[預計]]-子女[[#This Row],[實際值]]","v":0}]
[null,null,"總收入",{"$f":"SUBTOTAL(109,子女[預計])","v":0},{"$f":"SUBTOTAL(109,子女[實際值])","v":0},{"$f":"SUBTOTAL(109,子女[差異])","v":0}]
[]
[null,null,"寵物","預計","實際值","差異"]
[null,null,"食物",null,null,{"$f":"寵物[[#This Row],[預計]]-寵物[[#This Row],[實際值]]","v":0}]
[null,null,"醫療",null,null,{"$f":"寵物[[#This Row],[預計]]-寵物[[#This Row],[實際值]]","v":0}]
[null,null,"飾品",null,null,{"$f":"寵物[[#This Row],[預計]]-寵物[[#This Row],[實際值]]","v":0}]
[null,null,"玩具",null,null,{"$f":"寵物[[#This Row],[預計]]-寵物[[#This Row],[實際值]]","v":0}]
[null,null,"其他",null,null,{"$f":"寵物[[#This Row],[預計]]-寵物[[#This Row],[實際值]]","v":0}]
[null,null,"總收入",{"$f":"SUBTOTAL(109,寵物[預計])","v":0},{"$f":"SUBTOTAL(109,寵物[實際值])","v":0},{"$f":"SUBTOTAL(109,寵物[差異])","v":0}]
[]
[null,null,"個人保健","預計","實際值","差異"]
[null,null,"醫療",null,null,{"$f":"個人照護[[#This Row],[預計]]-個人照護[[#This Row],[實際值]]","v":0}]
[null,null,"美容",null,null,{"$f":"個人照護[[#This Row],[預計]]-個人照護[[#This Row],[實際值]]","v":0}]
[null,null,"衣物",null,null,{"$f":"個人照護[[#This Row],[預計]]-個人照護[[#This Row],[實際值]]","v":0}]
[null,null,"乾洗",null,null,{"$f":"個人照護[[#This Row],[預計]]-個人照護[[#This Row],[實際值]]","v":0}]
[null,null,"運動",null,null,{"$f":"個人照護[[#This Row],[預計]]-個人照護[[#This Row],[實際值]]","v":0}]
[null,null,"會費",null,null,{"$f":"個人照護[[#This Row],[預計]]-個人照護[[#This Row],[實際值]]","v":0}]
[null,null,"其他",null,null,{"$f":"個人照護[[#This Row],[預計]]-個人照護[[#This Row],[實際值]]","v":0}]
[null,null,"總收入",{"$f":"SUBTOTAL(109,個人照護[預計])","v":0},{"$f":"SUBTOTAL(109,個人照護[實際值])","v":0},{"$f":"SUBTOTAL(109,個人照護[差異])","v":0}]
[]
[null,null,"娛樂","預計","實際值","差異"]
[null,null,"影片/DVD",null,null,{"$f":"娛樂[[#This Row],[預計]]-娛樂[[#This Row],[實際值]]","v":0}]
[null,null,"CD",null,null,{"$f":"娛樂[[#This Row],[預計]]-娛樂[[#This Row],[實際值]]","v":0}]
[null,null,"電影",null,null,{"$f":"娛樂[[#This Row],[預計]]-娛樂[[#This Row],[實際值]]","v":0}]
[null,null,"音樂會",null,null,{"$f":"娛樂[[#This Row],[預計]]-娛樂[[#This Row],[實際值]]","v":0}]
[null,null,"運動賽事",null,null,{"$f":"娛樂[[#This Row],[預計]]-娛樂[[#This Row],[實際值]]","v":0}]
[null,"c","即時電影院",null,null,{"$f":"娛樂[[#This Row],[預計]]-娛樂[[#This Row],[實際值]]","v":0}]
[null,null,"其他",null,null,{"$f":"娛樂[[#This Row],[預計]]-娛樂[[#This Row],[實際值]]","v":0}]
[null,null,"總收入","預計","實際值","差異"]
[]
[null,null,"貸款","預計","實際值","差異"]
[null,null,"個人",null,null,{"$f":"貸款[[#This Row],[預計]]-貸款[[#This Row],[實際值]]","v":0}]
[null,null,"學生",null,null,{"$f":"貸款[[#This Row],[預計]]-貸款[[#This Row],[實際值]]","v":0}]
[null,null,"信用卡",null,null,{"$f":"貸款[[#This Row],[預計]]-貸款[[#This Row],[實際值]]","v":0}]
[null,null,"信用卡",null,null,{"$f":"貸款[[#This Row],[預計]]-貸款[[#This Row],[實際值]]","v":0}]
[null,null,"信用卡",null,null,{"$f":"貸款[[#This Row],[預計]]-貸款[[#This Row],[實際值]]","v":0}]
[null,null,"其他",null,null,{"$f":"貸款[[#This Row],[預計]]-貸款[[#This Row],[實際值]]","v":0}]
[null,null,"總收入",{"$f":"SUBTOTAL(109,貸款[預計])","v":0},{"$f":"SUBTOTAL(109,貸款[實際值])","v":0},{"$f":"SUBTOTAL(109,貸款[差異])","v":0}]
[]
[null,null,"稅款","預計","實際值","差異"]
[null,null,"所得稅",null,null,{"$f":"稅款[[#This Row],[預計]]-稅款[[#This Row],[實際值]]","v":0}]
[null,null,"省/市",null,null,{"$f":"稅款[[#This Row],[預計]]-稅款[[#This Row],[實際值]]","v":0}]
[null,null,"地方稅",null,null,{"$f":"稅款[[#This Row],[預計]]-稅款[[#This Row],[實際值]]","v":0}]
[null,null,"其他",null,null,{"$f":"稅款[[#This Row],[預計]]-稅款[[#This Row],[實際值]]","v":0}]
[null,null,"總收入",{"$f":"SUBTOTAL(109,稅款[預計])","v":0},{"$f":"SUBTOTAL(109,稅款[實際值])","v":0},{"$f":"SUBTOTAL(109,稅款[差異])","v":0}]
[]
[null,null,"儲蓄或投資","預計","實際值","差異"]
[null,null,"退休帳戶",null,null,{"$f":"儲蓄[[#This Row],[預計]]-儲蓄[[#This Row],[實際值]]","v":0}]
[null,null,"投資帳戶",null,null,{"$f":"儲蓄[[#This Row],[預計]]-儲蓄[[#This Row],[實際值]]","v":0}]
[null,null,"大學",null,null,{"$f":"儲蓄[[#This Row],[預計]]-儲蓄[[#This Row],[實際值]]","v":0}]
[null,null,"其他",null,null,{"$f":"儲蓄[[#This Row],[預計]]-儲蓄[[#This Row],[實際值]]","v":0}]
[null,null,"總收入",{"$f":"SUBTOTAL(109,儲蓄[預計])","v":0},{"$f":"SUBTOTAL(109,儲蓄[實際值])","v":0},{"$f":"SUBTOTAL(109,儲蓄[差異])","v":0}]
[]
[null,null,"禮品和捐獻","預計","實際值","差異"]
[null,null,"慈善 1",null,null,{"$f":"禮物[[#This Row],[預計]]-禮物[[#This Row],[實際值]]","v":0}]
[null,null,"慈善 2",null,null,{"$f":"禮物[[#This Row],[預計]]-禮物[[#This Row],[實際值]]","v":0}]
[null,null,"慈善 3",null,null,{"$f":"禮物[[#This Row],[預計]]-禮物[[#This Row],[實際值]]","v":0}]
[null,null,"總收入",{"$f":"SUBTOTAL(109,禮物[預計])","v":0},{"$f":"SUBTOTAL(109,禮物[實際值])","v":0},{"$f":"SUBTOTAL(109,禮物[差異])","v":0}]
[]
[null,null,"法律費用","預計","實際值","差異"]
[null,null,"律師",null,null,{"$f":"法律費用[[#This Row],[預計]]-法律費用[[#This Row],[實際值]]","v":0}]
[null,null,"扶養/贍養",null,null,{"$f":"法律費用[[#This Row],[預計]]-法律費用[[#This Row],[實際值]]","v":0}]
[null,null,"訴訟費用",null,null,{"$f":"法律費用[[#This Row],[預計]]-法律費用[[#This Row],[實際值]]","v":0}]
[null,null,"其他",null,null,{"$f":"法律費用[[#This Row],[預計]]-法律費用[[#This Row],[實際值]]","v":0}]
[null,null,"總收入",{"$f":"SUBTOTAL(109,法律費用[預計])","v":0},{"$f":"SUBTOTAL(109,法律費用[實際值])","v":0},{"$f":"SUBTOTAL(109,法律費用[差異])","v":0}]