{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["設備財產目錄清單"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"設備財產目錄清單","index":0,"n_rows":9,"n_cols":19,"rows_kept":9,"merged":[[0,1,0,5],[0,6,0,9],[0,10,0,12],[0,13,0,14],[2,1,2,6],[2,7,2,18]]}
[null,"設備財產目錄清單"]
[]
[null,"保存狀況",{"$nulls":5},"財務狀態"]
[null,"資產編號或序號","項目描述 (製造商與型號)","地點","物況","供應商","剩餘服務年限 ","初始值","頭期款","購買或租用日期","貸款年限","貸款利率","每月還款金額","每月營運成本","每月總成本","貸款期限結束時的期望值","年度直線折舊","每月直線折舊","現值"]
[null,123,"製造商型號","總行","良好","當地",5,{"v":900000,"d":"NT$900,000.00"},{"v":150000,"d":"NT$150,000.00"},{"$f":"DATE(YEAR(TODAY())-2, 1,1)","v":"2016-01-01"},4,{"v":0.1,"d":"10.00%"},{"$f":"IFERROR(IF(AND(資料[[#This Row],[初始值]]>0,資料[[#This Row],[初始值]]<>資料[[#This Row],[頭期款]]),-1*PMT(資料[[#This Row],[貸款利率]]/12,資料[[#This Row],[貸款年限]]*12,資料[[#This Row],[初始值]]-資料[[#This Row],[頭期款]]),0),0)","v":{"v":19021.937576060394,"d":"NT$19,021.94"}},{"v":6000,"d":"NT$6,000.00"},{"$f":"IFERROR(資料[[#This Row],[每月營運成本]]+資料[[#This Row],[每月還款金額]],\"\")","v":{"v":25021.937576060394,"d":"NT$25,021.94"}},{"v":600000,"d":"NT$600,000.00"},{"$f":"IFERROR(IF(資料[[#This Row],[初始值]]>0,SLN(資料[[#This Row],[初始值]],資料[[#This Row],[貸款期限結束時的期望值]],資料[[#This Row],[剩餘服務年限 ]]),0),0)","v":{"v":60000,"d":"NT$60,000.00"}},{"$f":"IFERROR(資料[[#This Row],[年度直線折舊]]/12,0)","v":{"v":5000,"d":"NT$5,000.00"}},{"$f":"IFERROR(資料[[#This Row],[初始值]]-(資料[[#This Row],[年度直線折舊]]*((TODAY()-資料[[#This Row],[購買或租用日期]])/365)),0)","v":{"v":750410.9589041095,"d":"NT$750,410.96"}}]
[null,456,"製造商型號","總行","極佳","當地",3,{"v":150000,"d":"NT$150,000.00"},{"v":150000,"d":"NT$150,000.00"},{"$f":"DATE(YEAR(TODAY())-1, 1,1)","v":"2017-01-01"},null,null,{"$f":"IFERROR(IF(AND(資料[[#This Row],[初始值]]>0,資料[[#This Row],[初始值]]<>資料[[#This Row],[頭期款]]),-1*PMT(資料[[#This Row],[貸款利率]]/12,資料[[#This Row],[貸款年限]]*12,資料[[#This Row],[初始值]]-資料[[#This Row],[頭期款]]),0),0)","v":{"v":0,"d":"NT$0.00"}},{"v":600,"d":"NT$600.00"},{"$f":"IFERROR(資料[[#This Row],[每月營運成本]]+資料[[#This Row],[每月還款金額]],\"\")","v":{"v":600,"d":"NT$600.00"}},null,{"$f":"IFERROR(IF(資料[[#This Row],[初始值]]>0,SLN(資料[[#This Row],[初始值]],資料[[#This Row],[貸款期限結束時的期望值]],資料[[#This Row],[剩餘服務年限 ]]),0),0)","v":{"v":50000,"d":"NT$50,000.00"}},{"$f":"IFERROR(資料[[#This Row],[年度直線折舊]]/12,0)","v":{"v":4166.666666666667,"d":"NT$4,166.67"}},{"$f":"IFERROR(資料[[#This Row],[初始值]]-(資料[[#This Row],[年度直線折舊]]*((TODAY()-資料[[#This Row],[購買或租用日期]])/365)),0)","v":{"v":75479.45205479451,"d":"NT$75,479.45"}}]
[null,789,"製造商型號","東岸","一般","當地",6,{"v":1500000,"d":"NT$1,500,000.00"},{"v":600000,"d":"NT$600,000.00"},{"$f":"TODAY()","v":"2018-06-29"},5,{"v":0.05,"d":"5.00%"},{"$f":"IFERROR(IF(AND(資料[[#This Row],[初始值]]>0,資料[[#This Row],[初始值]]<>資料[[#This Row],[頭期款]]),-1*PMT(資料[[#This Row],[貸款利率]]/12,資料[[#This Row],[貸款年限]]*12,資料[[#This Row],[初始值]]-資料[[#This Row],[頭期款]]),0),0)","v":{"v":16984.110279609842,"d":"NT$16,984.11"}},{"v":1200,"d":"NT$1,200.00"},{"$f":"IFERROR(資料[[#This Row],[每月營運成本]]+資料[[#This Row],[每月還款金額]],\"\")","v":{"v":18184.110279609842,"d":"NT$18,184.11"}},{"v":45000,"d":"NT$45,000.00"},{"$f":"IFERROR(IF(資料[[#This Row],[初始值]]>0,SLN(資料[[#This Row],[初始值]],資料[[#This Row],[貸款期限結束時的期望值]],資料[[#This Row],[剩餘服務年限 ]]),0),0)","v":{"v":242500,"d":"NT$242,500.00"}},{"$f":"IFERROR(資料[[#This Row],[年度直線折舊]]/12,0)","v":{"v":20208.333333333332,"d":"NT$20,208.33"}},{"$f":"IFERROR(資料[[#This Row],[初始值]]-(資料[[#This Row],[年度直線折舊]]*((TODAY()-資料[[#This Row],[購買或租用日期]])/365)),0)","v":{"v":1500000,"d":"NT$1,500,000.00"}}]
[{"$nulls":12},{"$f":"IFERROR(IF(AND(資料[[#This Row],[初始值]]>0,資料[[#This Row],[初始值]]<>資料[[#This Row],[頭期款]]),-1*PMT(資料[[#This Row],[貸款利率]]/12,資料[[#This Row],[貸款年限]]*12,資料[[#This Row],[初始值]]-資料[[#This Row],[頭期款]]),0),0)","v":{"v":0,"d":"NT$0.00"}},null,{"$f":"IFERROR(資料[[#This Row],[每月營運成本]]+資料[[#This Row],[每月還款金額]],\"\")","v":{"v":0,"d":"NT$0.00"}},null,{"$f":"IFERROR(IF(資料[[#This Row],[初始值]]>0,SLN(資料[[#This Row],[初始值]],資料[[#This Row],[貸款期限結束時的期望值]],資料[[#This Row],[剩餘服務年限 ]]),0),0)","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(資料[[#This Row],[年度直線折舊]]/12,0)","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(資料[[#This Row],[初始值]]-(資料[[#This Row],[年度直線折舊]]*((TODAY()-資料[[#This Row],[購買或租用日期]])/365)),0)","v":{"v":0,"d":"NT$0.00"}}]
[{"$nulls":12},{"$f":"IFERROR(IF(AND(資料[[#This Row],[初始值]]>0,資料[[#This Row],[初始值]]<>資料[[#This Row],[頭期款]]),-1*PMT(資料[[#This Row],[貸款利率]]/12,資料[[#This Row],[貸款年限]]*12,資料[[#This Row],[初始值]]-資料[[#This Row],[頭期款]]),0),0)","v":{"v":0,"d":"NT$0.00"}},null,{"$f":"IFERROR(資料[[#This Row],[每月營運成本]]+資料[[#This Row],[每月還款金額]],\"\")","v":{"v":0,"d":"NT$0.00"}},null,{"$f":"IFERROR(IF(資料[[#This Row],[初始值]]>0,SLN(資料[[#This Row],[初始值]],資料[[#This Row],[貸款期限結束時的期望值]],資料[[#This Row],[剩餘服務年限 ]]),0),0)","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(資料[[#This Row],[年度直線折舊]]/12,0)","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(資料[[#This Row],[初始值]]-(資料[[#This Row],[年度直線折舊]]*((TODAY()-資料[[#This Row],[購買或租用日期]])/365)),0)","v":{"v":0,"d":"NT$0.00"}}]