{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["工作表1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"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":"工作表1","index":0,"n_rows":15,"n_cols":20,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[102404203,"郭香佐"]
[102404215,"丁書晴",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"直線法"]
[102404251,"王瑞琪",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年數合計法"]
[102404252,"劉曉君",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"定率遞減法"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"倍數餘額遞減法"]
[null,"2013-01-01"]
["目前日期：",{"$f":"NOW()","v":"2013-12-12T17:35:58.690"},2013,12,12]
["財產名稱","財產編號","類別","數量","購買日期","年","月","日","累計攤銷月","今年攤銷月","原始成本","耐用年限","殘值","折舊方法","本期折舊費用","累計折舊","帳面價值"]
["房屋","B1","建築物",1,"2013-01-01",2013,1,1,{"$f":"IF(($C$7-F9)*12+($D$7-G9)>L9*12,L9*12,IF(H9>15,($C$7-F9)*12+($D$7-G9),($C$7-F9)*12+($D$7-G9)+1))","v":12},{"$f":"IF(($C$7-F9)*12+($D$7-G9)>L9*12,IF((F9+L9)<$C$7,0,IF(I9>15,G9,G9-1)),IF(F9=$C$7,IF(H9>15,$D$7-G9,$D$7-G9+1),12))","v":12},3000000,20,500000,"直線法",{"$f":"IF(N9=\"直線法\",SLN(K9,M9,L9),IF(N9=\"年數合計法\",SYD(K9,M9,L9,($C$7-F9+1)/J9/12),IF(N9=\"定率遞減法\",DB(K9,M9,L9,($C$7-F9+1)/J9/12,12),IF(N9=\"倍數餘額遞減法\",DDB(K9,M9,L9,($C$7-F9+1)/J9/12)))))","v":125000},{"$f":"O9*I9/12","v":125000},{"$f":"K9-P9","v":2875000},{"$f":"SLN(K9,M9,L9)","v":125000}]
["小貨車","T1","運輸設備",1,"2012-12-03",2012,12,3,{"$f":"IF(($C$7-F10)*12+($D$7-G10)>L10*12,L10*12,IF(H10>15,($C$7-F10)*12+($D$7-G10),($C$7-F10)*12+($D$7-G10)+1))","v":13},{"$f":"IF(($C$7-F10)*12+($D$7-G10)>L10*12,IF((F10+L10)<$C$7,0,IF(I10>15,G10,G10-1)),IF(F10=$C$7,IF(H10>15,$D$7-G10,$D$7-G10+1),12))","v":12},500000,10,20000,"直線法",{"$f":"IF(N10=\"直線法\",SLN(K10,M10,L10),IF(N10=\"年數合計法\",SYD(K10,M10,L10,($C$7-F10+1)/J10/12),IF(N10=\"定率遞減法\",DB(K10,M10,L10,($C$7-F10+1)/J10/12,12),IF(N10=\"倍數餘額遞減法\",DDB(K10,M10,L10,($C$7-F10+1)/J10/12)))))","v":48000},{"$f":"O10*I10/12","v":52000},{"$f":"K10-P10","v":448000}]
["鋼琴","F1","娛樂設備",1,"2012-08-28",2012,8,28,{"$f":"IF(($C$7-F11)*12+($D$7-G11)>L11*12,L11*12,IF(H11>15,($C$7-F11)*12+($D$7-G11),($C$7-F11)*12+($D$7-G11)+1))","v":16},12,60000,8,3000,"直線法",7125,{"$f":"O11*I11/12","v":9500},50500]
["辦公椅","O1","辦公設備",30,"2012-06-05",2012,6,5,{"$f":"IF(($C$7-F12)*12+($D$7-G12)>L12*12,L12*12,IF(H12>15,($C$7-F12)*12+($D$7-G12),($C$7-F12)*12+($D$7-G12)+1))","v":19},12,60000,5,5000,"直線法",11000,{"$f":"O12*I12/12","v":17416.666666666668},42583.333333333328]
["汽車廠土地","L1","土地",1,"2011-05-01",2011,5,1,"-","-",5000000,"無限","略","直線法",null,null,5000000]
["辦公桌","O2","辦公設備",10,"2010-06-08",2010,6,8,{"$f":"IF(($C$7-F14)*12+($D$7-G14)>L14*12,L14*12,IF(H14>15,($C$7-F14)*12+($D$7-G14),($C$7-F14)*12+($D$7-G14)+1))","v":43},12,100000,10,5000,"直線法",{"$f":"IF(N14=\"直線法\",SLN(K14,M14,L14),IF(N14=\"年數合計法\",SYD(K14,M14,L14,($C$7-F14+1)/J14/12),IF(N14=\"定率遞減法\",DB(K14,M14,L14,($C$7-F14+1)/J14/12,12),IF(N14=\"倍數餘額遞減法\",DDB(K14,M14,L14,($C$7-F14+1)/J14/12)))))","v":9500},{"$f":"O14*I14/12","v":34041.666666666664},65958.333333333343]
["電腦","I1","資訊設備",5,"2010-06-01",2010,6,1,{"$f":"IF(($C$7-F15)*12+($D$7-G15)>L15*12,L15*12,IF(H15>15,($C$7-F15)*12+($D$7-G15),($C$7-F15)*12+($D$7-G15)+1))","v":43},12,200000,5,20000,"直線法",36000,{"$f":"O15*I15/12","v":129000},71000]