{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["工作表1","工作表2","工作表3"],"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":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"直線法"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年數和計法"]
[null,null,null,null,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":"NOW()","v":"2013-12-13T09:29:10.610"}]
["財產名稱","財產編號","類別","數量","購買日期","原始成本","耐用年限","殘值","折舊方法","本期折舊費用","累計折舊","帳面價值"]
[null,null,null,null,"2010-12-07",100000,10,20000,"直線法",{"$f":"IF(ROUNDUP((B7-E9)/365,0)<=G9,\nIF(ROUNDUP((B7-E9)/365,0)=1,\nIF(I9=\"直線法\",SLN(F9,H9,G9),\nIF(I9=\"倍數餘額遞減法\",DDB(F9,H9,G9,1),\nIF(I9=\"年數合計法\",SYD(F9,H9,G9,1),DB(F9,H9,G9,1))))*(IF(MID(TEXT(E9,\"yyyy/mm/dd\"),9,2)>15,(12-MID(TEXT(E9,\"yyyy/mm/dd\"),6,2)),(13-MID(TEXT(E9,\"yyyy/mm/dd\"),6,2)))/12),\n(IF(I9=\"直線法\",SLN(F9,H9,G9),IF(I9=\"倍數餘額遞減法\",DDB(F9,H9,G9,ROUNDUP((B7-E9)/365,0)),IF(I9=\"年數合計法\",SYD(F9,H9,G9,ROUNDUP((B7-E9)/365,0)),DB(F9,H9,G9,ROUNDUP((B7-E9)/365,0))))))\n),\"-\")","v":8000},null,{"$f":"F9-K9","v":100000}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"土地"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"不動產"]
[null,null,null,"IF(ROUNDUP((B7-E9)/365,0)<=G9,",null,null,null,null,null,null,null,null,null,null,"機器設備"]
[null,null,null,"IF(ROUNDUP((B7-E9)/365,0)=1,",null,null,null,null,null,null,null,null,null,null,"資訊設備"]
[null,null,null,"IF(I9=\"直線法\",SLN(F9,H9,G9),"]
[null,null,null,"IF(I9=\"倍數餘額遞減法\",DDB(F9,H9,G9,1),"]
[null,null,null,"IF(I9=\"年數合計法\",SYD(F9,H9,G9,1),DB(F9,H9,G9,1))))*(IF(MID(TEXT(E9,\"yyyy/mm/dd\"),9,2)>15,(12-MID(TEXT(E9,\"yyyy/mm/dd\"),6,2)),(13-MID(TEXT(E9,\"yyyy/mm/dd\"),6,2)))/12),"]
[null,null,null,"(IF(I9=\"直線法\",SLN(F9,H9,G9),IF(I9=\"倍數餘額遞減法\",DDB(F9,H9,G9,ROUNDUP((B7-E9)/365,0)),IF(I9=\"年數合計法\",SYD(F9,H9,G9,ROUNDUP((B7-E9)/365,0)),DB(F9,H9,G9,ROUNDUP((B7-E9)/365,0))))))"]
[null,null,null,"),\"-\")"]
[]
[null,null,null,"IF(ROUNDUP((B7-E9)/365,0)<=G9,\nIF(ROUNDUP((B7-E9)/365,0)=1,\nIF(I9=\"直線法\",SLN(F9,H9,G9),\nIF(I9=\"倍數餘額遞減法\",(F9-0)*2/G9,\nIF(I9=\"年數和計法\",SYD(F9,H9,G9,1),(1-(H9/F9)^(1/G9))*F9))))*\n(IF(MID(TEXT(E9,\"yyyy/mm/dd\"),9,2)>15,\n(12-MID(TEXT(E9,\"yyyy/mm/dd\"),6,2)),\n(13-MID(TEXT(E9,\"yyyy/mm/dd\"),6,2)))/12)))",null,"IF(ROUNDUP((B7-E9)/365,0)<=G9,"]
[null,null,null,null,null,"IF(ROUNDUP((B7-E9)/365,0)=1,"]
[null,null,null,null,null,"IF(I9=\"直線法\",SLN(F9,H9,G9),"]
[null,null,null,null,null,"IF(I9=\"倍數餘額遞減法\",(F9-0)*2/G9,"]
[null,null,null,null,null,"IF(I9=\"年數合計法\",SYD(F9,H9,G9,1),(1-(H9/F9)^(1/G9))*F9)))*(IF(MID(TEXT(E9,\"yyyy/mm/dd\"),9,2)>15,(12-MID(TEXT(E9,\"yyyy/mm/dd\"),6,2)),(13-MID(TEXT(E9,\"yyyy/mm/dd\"),6,2)))/12),"]
[null,null,null,null,null,"(IF(I9=\"直線法\",SLN(F9,H9,G9),IF(I9=\"倍數餘額遞減法\",DDB(F9,H9,G9,ROUNDUP((B7-E9)/365,0)),IF(I9=\"年數和計法\",SYD(F9,H9,G9,ROUNDUP((B7-E9)/365,0)),DB(F9,H9,G9,ROUNDUP((B7-E9)/365,0))))))"]
[null,null,null,null,null,"),\"-\")",null,null,null,null,null,"(1-((1^(1/G9))*(H9/F9))*(F9-0))"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"機器設備"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"辦公設備"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"資訊設備"]

{"sheet":"工作表2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"工作表3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}