{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["儀表板","設備清單","樞紐分析資料"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":22,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"儀表板","index":0,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"儀表板"]
[]
[]
[null,null,null,null,null,"總數"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"計數\",樞紐分析資料!$B$11)","v":3}]
[]
[null,null,null,null,null,"每月成本總計"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"每月成本總計\",樞紐分析資料!$B$11)","v":52967.829105206023}]
[]
[null,null,null,null,null,"營運成本"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"營運成本\",樞紐分析資料!$B$11)","v":18150}]
[]
[null,null,null,null,null,"月折舊"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"月折舊\",樞紐分析資料!$B$11)","v":19791.666666666668}]
[]
[null,null,null,null,null,"付款金額"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"付款金額\",樞紐分析資料!$B$11)","v":34817.829105206023}]
[]
[null,null,null,null,null,"現值"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"現值\",樞紐分析資料!$B$11)","v":1111664.3835616438}]

{"sheet":"設備清單","index":1,"n_rows":9,"n_cols":20,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"設備清單"]
[]
[null,null,null,"若剩餘月付期數小於以下數字時即醒目提示： ",20]
[]
[null,"資產編號或\n序號","項目描述\n(廠牌和型號)","地點","狀況","廠商","剩餘\n服務年限 ","初始值","頭期款","購買或租借\n日期","貸款\n年限","貸款利率","每月\n營運成本","約滿期望值","剩餘\n月付期數","月付金額","每月\n成本總計","年折舊\n(直線法)","月折舊\n(直線法)","現值"]
[null,123,"廠牌型號 1","總行","良好","當地",5,900000,150000,"2011-01-15",4,0.1,6000,600000,{"$f":"IFERROR(SUMPRODUCT(--(DAY(ROW(OFFSET($A$1,,,DATE(YEAR(設備[[#This Row],[購買或租借\n日期]])+設備[[#This Row],[貸款\n年限]],MONTH(設備[[#This Row],[購買或租借\n日期]])-1,DAY(設備[[#This Row],[購買或租借\n日期]]))-TODAY()))+DATE(YEAR(設備[[#This Row],[購買或租借\n日期]])+設備[[#This Row],[貸款\n年限]],MONTH(設備[[#This Row],[購買或租借\n日期]]),DAY(設備[[#This Row],[購買或租借\n日期]]))-1)=DAY(設備[[#This Row],[購買或租借\n日期]]))),0)","v":24},{"$f":"IFERROR(-(設備[初始值]>0)*(設備[初始值]<>設備[頭期款])*PMT(設備[貸款利率]/MonthsInYear,設備[貸款\n年限]*MonthsInYear,設備[初始值]-設備[頭期款]),0)","v":19021.937576060394},{"$f":"設備[[#This Row],[月付金額]]+設備[每月\n營運成本]","v":25021.937576060394},{"$f":"IFERROR((設備[初始值]>0)*SLN(設備[初始值],設備[約滿期望值],設備[貸款\n年限]),0)","v":75000},{"$f":"IFERROR(設備[年折舊\n(直線法)]/MonthsInYear,0)","v":6250},{"$f":"IFERROR(設備[初始值]-(設備[年折舊\n(直線法)]*((TODAY()-設備[購買或租借\n日期])/DaysInYear)),0)","v":756369.8630136986}]
[null,234,"廠牌型號 2","總行","良好","當地",4,375000,45000,"2011-03-10",3,7.7499999999999999E-2,3600,90000,{"$f":"IFERROR(SUMPRODUCT(--(DAY(ROW(OFFSET($A$1,,,DATE(YEAR(設備[[#This Row],[購買或租借\n日期]])+設備[[#This Row],[貸款\n年限]],MONTH(設備[[#This Row],[購買或租借\n日期]])-1,DAY(設備[[#This Row],[購買或租借\n日期]]))-TODAY()))+DATE(YEAR(設備[[#This Row],[購買或租借\n日期]])+設備[[#This Row],[貸款\n年限]],MONTH(設備[[#This Row],[購買或租借\n日期]]),DAY(設備[[#This Row],[購買或租借\n日期]]))-1)=DAY(設備[[#This Row],[購買或租借\n日期]]))),0)","v":14},{"$f":"IFERROR(-(設備[初始值]>0)*(設備[初始值]<>設備[頭期款])*PMT(設備[貸款利率]/MonthsInYear,設備[貸款\n年限]*MonthsInYear,設備[初始值]-設備[頭期款]),0)","v":10302.984002307569},{"$f":"設備[[#This Row],[月付金額]]+設備[每月\n營運成本]","v":13902.984002307569},{"$f":"IFERROR((設備[初始值]>0)*SLN(設備[初始值],設備[約滿期望值],設備[貸款\n年限]),0)","v":95000},{"$f":"IFERROR(設備[年折舊\n(直線法)]/MonthsInYear,0)","v":7916.666666666667},{"$f":"IFERROR(設備[初始值]-(設備[年折舊\n(直線法)]*((TODAY()-設備[購買或租借\n日期])/DaysInYear)),0)","v":207123.28767123289}]
[null,345,"廠牌型號 2","分行 1","尚可","其他",1,300000,75000,"2010-09-15",4,0.08,8550,30000,{"$f":"IFERROR(SUMPRODUCT(--(DAY(ROW(OFFSET($A$1,,,DATE(YEAR(設備[[#This Row],[購買或租借\n日期]])+設備[[#This Row],[貸款\n年限]],MONTH(設備[[#This Row],[購買或租借\n日期]])-1,DAY(設備[[#This Row],[購買或租借\n日期]]))-TODAY()))+DATE(YEAR(設備[[#This Row],[購買或租借\n日期]])+設備[[#This Row],[貸款\n年限]],MONTH(設備[[#This Row],[購買或租借\n日期]]),DAY(設備[[#This Row],[購買或租借\n日期]]))-1)=DAY(設備[[#This Row],[購買或租借\n日期]]))),0)","v":21},{"$f":"IFERROR(-(設備[初始值]>0)*(設備[初始值]<>設備[頭期款])*PMT(設備[貸款利率]/MonthsInYear,設備[貸款\n年限]*MonthsInYear,設備[初始值]-設備[頭期款]),0)","v":5492.9075268380584},{"$f":"設備[[#This Row],[月付金額]]+設備[每月\n營運成本]","v":14042.907526838058},{"$f":"IFERROR((設備[初始值]>0)*SLN(設備[初始值],設備[約滿期望值],設備[貸款\n年限]),0)","v":67500},{"$f":"IFERROR(設備[年折舊\n(直線法)]/MonthsInYear,0)","v":5625},{"$f":"IFERROR(設備[初始值]-(設備[年折舊\n(直線法)]*((TODAY()-設備[購買或租借\n日期])/DaysInYear)),0)","v":148171.23287671231}]
[null,"合計",null,null,null,null,{"$f":"SUBTOTAL(101,設備[剩餘\n服務年限 ])","v":3.3333333333333335},{"$f":"SUBTOTAL(109,設備[初始值])","v":1575000},{"$f":"SUBTOTAL(109,設備[頭期款])","v":270000},null,{"$f":"SUBTOTAL(101,設備[貸款\n年限])","v":3.6666666666666665},{"$f":"SUBTOTAL(101,設備[貸款利率])","v":8.5833333333333331E-2},{"$f":"SUBTOTAL(109,設備[每月\n營運成本])","v":18150},{"$f":"SUBTOTAL(109,設備[約滿期望值])","v":720000},{"$f":"SUBTOTAL(101,設備[剩餘\n月付期數])","v":19.666666666666668},{"$f":"SUBTOTAL(109,設備[月付金額])","v":34817.829105206023},{"$f":"SUBTOTAL(109,設備[每月\n成本總計])","v":52967.829105206023},{"$f":"SUBTOTAL(101,設備[年折舊\n(直線法)])","v":79166.666666666672},{"$f":"SUBTOTAL(101,設備[月折舊\n(直線法)])","v":6597.2222222222226},{"$f":"SUBTOTAL(109,設備[現值])","v":1111664.3835616438}]

{"sheet":"樞紐分析資料","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[null,"樞紐分析資料"]
[null,"此工作表應保持隱藏。改變此工作表中樞紐分析表結構可能會導致儀表板交叉分析篩選器發生錯誤。"]
[]
[null,"項目描述\n(廠牌和型號)","(全部)"]
[null,"地點","(全部)"]
[null,"狀況","(全部)"]
[null,"廠商","(全部)"]
[null,"剩餘\n服務年限 ","(全部)"]
[null,"貸款\n年限","(全部)"]
[]
[null,"列標籤","計數","營運成本","付款金額","每月成本總計","月折舊","現值 "]
[null,123,1,6000,19021.937576060394,25021.937576060394,6250,756369.8630136986]
[null,234,1,3600,10302.984002307569,13902.984002307569,7916.666666666667,207123.28767123289]
[null,345,1,8550,5492.9075268380584,14042.907526838058,5625,148171.23287671231]
[null,"總計",3,18150,34817.829105206023,52967.829105206023,19791.666666666668,1111664.3835616438]