{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["說明","財產記錄","財產統計","巨集"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":1},"unopened":[{"sheet":"巨集","index":3,"reason":"part_missing"}],"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":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,2,5],[4,0,4,5],[9,0,9,5],[3,1,3,5],[5,1,5,5],[6,1,6,5],[7,0,7,5],[8,1,8,7],[33,2,33,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[13,1,13,5],[28,2,28,5],[29,2,29,5],[30,1,30,5],[32,2,32,5],[34,2,34,5],[35,2,35,5],[41,1,41,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[36,2,36,5]]}
["固定資產管理"]
[]
["操作指引："]
[null,"您可按垂直捲軸，依序往下捲動各項內容，或依您所需選按各項按鈕。"]
["模式目的："]
[null,"(1).登錄企業各項財產並計算折舊及帳面價值。"]
[null,"(2).編制財產統計表。"]
["應用時機："]
[null,"以列表方式登錄企業機構的財產資料並以樞鈕分析進行財產彙算作業。"]
["模式使用："]
[null,"(1).請於『財產記錄』工作表中字型為紅色的儲存格內輸入資料，"]
[null,"      藍色儲存格為分析計算結果，您勿需做任何設定或改變。"]
[null,"(2).為便利模式之分析及解讀，模式內大量使用範圍名稱。"]
[null,"     茲將各項名稱列表如下："]
[]
[null,null,"範圍名稱","參照位置"]
[null,null,"本期攤提","=財產記錄!$J$5:$J$120"]
[null,null,"耐用年限","=財產記錄!$H$5:$H$120"]
[null,null,"原始成本","=財產記錄!$G$5:$G$120"]
[null,null,"財產名稱","=財產記錄!$C$5:$L$120"]
[null,null,"財產編號","=財產記錄!$C$5:$C$120"]
[null,null,"帳面價值","=財產記錄!$L$5:$L$120"]
[null,null,"累積折舊","=財產記錄!$K$5:$K$120"]
[null,null,"殘值","=財產記錄!$I$5:$I$120"]
[null,null,"數量","=財產記錄!$E$5:$E$120"]
[null,null,"購買日期","=財產記錄!$F$5:$F$120"]
[null,null,"類別","=財產記錄!$D$5:$D$120"]
[]
[null,null,"本模式假設使用者之財產資料最多為120列，使用者如欲擴充"]
[null,null,"使用，則可重新定義範圍並複製相對應之公式。"]
[null,"(3).『財產記錄』工作表中各欄位公式如下："]
[]
[null,"欄位","公式"]
[null,"殘值 ","=IF(ISERR(原始成本/耐用年限),\"\",原始成本/耐用年限)"]
[null,"本期攤提","=IF(殘值<>\"\",IF(YEAR(購買日期)=YEAR(NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(購買日期,NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(DATE(YEAR(NOW()),1,1),NOW())),\"\")"]
[null,"累積折舊","=IF(殘值<>\"\",SLN(原始成本,殘值,耐用年限-1)/365*(DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-DATE(YEAR(購買日期),MONTH(購買日期),DAY(購買日期))),\"\")"]
[null,"帳面價值","=IF(ISERR(原始成本-累積折舊),\"\",(原始成本-累積折舊))"]
[]
[null,"(4).在『財產記錄』工作表中，您尚可按欄位名稱列旁之『下拉方塊』鈕"]
[null,"     來進行查詢作業。係使用 Excel 的樞紐分析表功能。"]
[null,"(5).『財產統計』係使用 Excel 的樞紐分析表功能。"]
[null,"(6).『財產記錄』工作表內之折舊係以直線法來進行攤提。"]

{"sheet":"財產記錄","index":1,"n_rows":120,"n_cols":12,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"目前日期：",{"$f":"NOW()","v":"2008-03-26T22:27:06.840"}]
[null,"財產名稱","財產編號","類別","數量","購買日期","原始成本","耐用年限","殘值 ","本期攤提","累積折舊","帳面價值"]
[null,"影印機","OA1004586","辦公設備",3,"1996-01-10",240000,4,{"$f":"IF(ISERR(原始成本/耐用年限),\"\",原始成本/耐用年限)","v":60000},{"$f":"IF(殘值<>\"\",IF(YEAR(購買日期)=YEAR(NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(購買日期,NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(DATE(YEAR(NOW()),1,1),NOW())),\"\")","v":13972.602739726026},{"$f":"IF(殘值<>\"\",SLN(原始成本,殘值,耐用年限-1)/365*(DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-DATE(YEAR(購買日期),MONTH(購買日期),DAY(購買日期))),\"\")","v":732986.30136986298},{"$f":"IF(ISERR(原始成本-累積折舊),\"\",(原始成本-累積折舊))","v":-492986.30136986298}]
[null,"雷射印表機","OA1004587","辦公設備",4,"1995-03-05",270000,3,90000,20958.904109589042,1176164.383561644,-906164.383561644]
[null,"貨車","TP3987618","運輸設備",2,"1995-02-12",1200000,6,200000,46575.342465753427,2625205.4794520549,-1425205.4794520549]
[null,"冷氣機","OA2308341","辦公設備",4,"1995-01-04",150000,3,50000,11643.835616438357,661643.8356164383,-511643.8356164383]
[null,"辦公大樓","BD6541087","建築物",1,"1994-03-12",6000000,30,200000,46575.342465753427,2809863.01369863,3190136.98630137]
[null,"廠房","BD6165241","建築物",1,"1994-06-08",4000000,40,100000,23287.671232876713,1380821.9178082191,2619178.0821917811]
[null,"堆高機","MA4562562","機器設備",1,"1994-07-12",360000,8,45000,10479.452054794521,617178.08219178091,-257178.08219178091]
[null,"衝壓機","MA5745774","機器設備",1,"1994-04-08",850000,8,106250,24743.150684931508,1484880.1369863015,-634880.13698630151]
[null,"裁切機","MA7567575","機器設備",1,"1993-04-10",620000,8,77500,{"$f":"IF(殘值<>\"\",IF(YEAR(購買日期)=YEAR(NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(購買日期,NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(DATE(YEAR(NOW()),1,1),NOW())),\"\")","v":18047.945205479453},{"$f":"IF(殘值<>\"\",SLN(原始成本,殘值,耐用年限-1)/365*(DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-DATE(YEAR(購買日期),MONTH(購買日期),DAY(購買日期))),\"\")","v":1160164.3835616438},-540164.38356164377]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(殘值<>\"\",IF(YEAR(購買日期)=YEAR(NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(購買日期,NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(DATE(YEAR(NOW()),1,1),NOW())),\"\")","v":""},{"$f":"IF(殘值<>\"\",SLN(原始成本,殘值,耐用年限-1)/365*(DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-DATE(YEAR(購買日期),MONTH(購買日期),DAY(購買日期))),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(原始成本/耐用年限),\"\",原始成本/耐用年限)","v":""},"","",""]
[null,null,null,null,null,null,null,null,"","","",{"$f":"IF(ISERR(原始成本-累積折舊),\"\",(原始成本-累積折舊))","v":""}]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(殘值<>\"\",IF(YEAR(購買日期)=YEAR(NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(購買日期,NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(DATE(YEAR(NOW()),1,1),NOW())),\"\")","v":""},{"$f":"IF(殘值<>\"\",SLN(原始成本,殘值,耐用年限-1)/365*(DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-DATE(YEAR(購買日期),MONTH(購買日期),DAY(購買日期))),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(原始成本/耐用年限),\"\",原始成本/耐用年限)","v":""},"","",""]
[null,null,null,null,null,null,null,null,"","","",{"$f":"IF(ISERR(原始成本-累積折舊),\"\",(原始成本-累積折舊))","v":""}]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(殘值<>\"\",IF(YEAR(購買日期)=YEAR(NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(購買日期,NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(DATE(YEAR(NOW()),1,1),NOW())),\"\")","v":""},{"$f":"IF(殘值<>\"\",SLN(原始成本,殘值,耐用年限-1)/365*(DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-DATE(YEAR(購買日期),MONTH(購買日期),DAY(購買日期))),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(原始成本/耐用年限),\"\",原始成本/耐用年限)","v":""},"","",""]
[null,null,null,null,null,null,null,null,"","","",{"$f":"IF(ISERR(原始成本-累積折舊),\"\",(原始成本-累積折舊))","v":""}]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(殘值<>\"\",IF(YEAR(購買日期)=YEAR(NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(購買日期,NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(DATE(YEAR(NOW()),1,1),NOW())),\"\")","v":""},{"$f":"IF(殘值<>\"\",SLN(原始成本,殘值,耐用年限-1)/365*(DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-DATE(YEAR(購買日期),MONTH(購買日期),DAY(購買日期))),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(原始成本/耐用年限),\"\",原始成本/耐用年限)","v":""},"","",""]
[null,null,null,null,null,null,null,null,"","","",{"$f":"IF(ISERR(原始成本-累積折舊),\"\",(原始成本-累積折舊))","v":""}]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(殘值<>\"\",IF(YEAR(購買日期)=YEAR(NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(購買日期,NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(DATE(YEAR(NOW()),1,1),NOW())),\"\")","v":""},{"$f":"IF(殘值<>\"\",SLN(原始成本,殘值,耐用年限-1)/365*(DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-DATE(YEAR(購買日期),MONTH(購買日期),DAY(購買日期))),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(原始成本/耐用年限),\"\",原始成本/耐用年限)","v":""},"","",""]
[null,null,null,null,null,null,null,null,"","","",{"$f":"IF(ISERR(原始成本-累積折舊),\"\",(原始成本-累積折舊))","v":""}]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(殘值<>\"\",IF(YEAR(購買日期)=YEAR(NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(購買日期,NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(DATE(YEAR(NOW()),1,1),NOW())),\"\")","v":""},{"$f":"IF(殘值<>\"\",SLN(原始成本,殘值,耐用年限-1)/365*(DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-DATE(YEAR(購買日期),MONTH(購買日期),DAY(購買日期))),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(原始成本/耐用年限),\"\",原始成本/耐用年限)","v":""},"","",""]
[null,null,null,null,null,null,null,null,"","","",{"$f":"IF(ISERR(原始成本-累積折舊),\"\",(原始成本-累積折舊))","v":""}]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(殘值<>\"\",IF(YEAR(購買日期)=YEAR(NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(購買日期,NOW()),SLN(原始成本,殘值,耐用年限-1)/365*DAYS360(DATE(YEAR(NOW()),1,1),NOW())),\"\")","v":""},{"$f":"IF(殘值<>\"\",SLN(原始成本,殘值,耐用年限-1)/365*(DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-DATE(YEAR(購買日期),MONTH(購買日期),DAY(購買日期))),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(原始成本/耐用年限),\"\",原始成本/耐用年限)","v":""},"","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(原始成本/耐用年限),\"\",原始成本/耐用年限)","v":""},"","",{"$f":"IF(ISERR(原始成本-累積折舊),\"\",(原始成本-累積折舊))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(原始成本/耐用年限),\"\",原始成本/耐用年限)","v":""},"","",{"$f":"IF(ISERR(原始成本-累積折舊),\"\",(原始成本-累積折舊))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(原始成本/耐用年限),\"\",原始成本/耐用年限)","v":""},"","",{"$f":"IF(ISERR(原始成本-累積折舊),\"\",(原始成本-累積折舊))","v":""}]

{"sheet":"財產統計","index":2,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"類別","資料","小計"]
[null,"建築物","加總項目:本期攤提",87945.205479452052]
[null,null,"加總項目:累積折舊",907123.28767123283]
[null,null,"加總項目:帳面價值",9092876.7123287674]
[null,"運輸設備","加總項目:本期攤提",58630.136986301368]
[null,null,"加總項目:累積折舊",436164.38356164383]
[null,null,"加總項目:帳面價值",763835.61643835623]
[null,"機器設備","加總項目:本期攤提",67058.219178082189]
[null,null,"加總項目:累積折舊",758506.84931506857]
[null,null,"加總項目:帳面價值",1071493.1506849313]
[null,"辦公設備","加總項目:本期攤提",58630.136986301375]
[null,null,"加總項目:累積折舊",381753.42465753423]
[null,null,"加總項目:帳面價值",278246.57534246577]
[null,"加總項目:本期攤提 的加總",null,272263.69863013702]
[null,"加總項目:累積折舊 的加總",null,2483547.9452054794]
[null,"加總項目:帳面價值 的加總",null,11206452.05479452]