{"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":300000,"d":"¥300,000.00"},{"v":50000,"d":"¥50,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":6340.6458586867975,"d":"¥6,340.65"}},{"v":2000,"d":"¥2,000.00"},{"$f":"IFERROR(数据[[#This Row],[每月运营成本]]+数据[[#This Row],[每月还款]],\"\")","v":{"v":8340.645858686798,"d":"¥8,340.65"}},{"v":200000,"d":"¥200,000.00"},{"$f":"IFERROR(IF(数据[[#This Row],[原始价值]]>0,SLN(数据[[#This Row],[原始价值]],数据[[#This Row],[贷款期限结束时的预期价值]],数据[[#This Row],[剩余使用年限 ]]),0),0)","v":{"v":20000,"d":"¥20,000.00"}},{"$f":"IFERROR(数据[[#This Row],[每年直线折旧价值]]/12,0)","v":{"v":1666.6666666666667,"d":"¥1,666.67"}},{"$f":"IFERROR(数据[[#This Row],[原始价值]]-(数据[[#This Row],[每年直线折旧价值]]*((TODAY()-数据[[#This Row],[购买或租赁日期]])/365)),0)","v":{"v":250136.98630136985,"d":"¥250,136.99"}}]
[null,456,"品牌 型号","主要分支","非常好","当地",3,{"v":50000,"d":"¥50,000.00"},{"v":50000,"d":"¥50,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":"¥0.00"}},{"v":200,"d":"¥200.00"},{"$f":"IFERROR(数据[[#This Row],[每月运营成本]]+数据[[#This Row],[每月还款]],\"\")","v":{"v":200,"d":"¥200.00"}},null,{"$f":"IFERROR(IF(数据[[#This Row],[原始价值]]>0,SLN(数据[[#This Row],[原始价值]],数据[[#This Row],[贷款期限结束时的预期价值]],数据[[#This Row],[剩余使用年限 ]]),0),0)","v":{"v":16666.666666666668,"d":"¥16,666.67"}},{"$f":"IFERROR(数据[[#This Row],[每年直线折旧价值]]/12,0)","v":{"v":1388.888888888889,"d":"¥1,388.89"}},{"$f":"IFERROR(数据[[#This Row],[原始价值]]-(数据[[#This Row],[每年直线折旧价值]]*((TODAY()-数据[[#This Row],[购买或租赁日期]])/365)),0)","v":{"v":25159.81735159817,"d":"¥25,159.82"}}]
[null,789,"品牌 型号","东海岸","正常","当地",6,{"v":500000,"d":"¥500,000.00"},{"v":200000,"d":"¥200,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":5661.370093203281,"d":"¥5,661.37"}},{"v":400,"d":"¥400.00"},{"$f":"IFERROR(数据[[#This Row],[每月运营成本]]+数据[[#This Row],[每月还款]],\"\")","v":{"v":6061.370093203281,"d":"¥6,061.37"}},{"v":15000,"d":"¥15,000.00"},{"$f":"IFERROR(IF(数据[[#This Row],[原始价值]]>0,SLN(数据[[#This Row],[原始价值]],数据[[#This Row],[贷款期限结束时的预期价值]],数据[[#This Row],[剩余使用年限 ]]),0),0)","v":{"v":80833.33333333333,"d":"¥80,833.33"}},{"$f":"IFERROR(数据[[#This Row],[每年直线折旧价值]]/12,0)","v":{"v":6736.11111111111,"d":"¥6,736.11"}},{"$f":"IFERROR(数据[[#This Row],[原始价值]]-(数据[[#This Row],[每年直线折旧价值]]*((TODAY()-数据[[#This Row],[购买或租赁日期]])/365)),0)","v":{"v":500000,"d":"¥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":"¥0.00"}},null,{"$f":"IFERROR(数据[[#This Row],[每月运营成本]]+数据[[#This Row],[每月还款]],\"\")","v":{"v":0,"d":"¥0.00"}},null,{"$f":"IFERROR(IF(数据[[#This Row],[原始价值]]>0,SLN(数据[[#This Row],[原始价值]],数据[[#This Row],[贷款期限结束时的预期价值]],数据[[#This Row],[剩余使用年限 ]]),0),0)","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(数据[[#This Row],[每年直线折旧价值]]/12,0)","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(数据[[#This Row],[原始价值]]-(数据[[#This Row],[每年直线折旧价值]]*((TODAY()-数据[[#This Row],[购买或租赁日期]])/365)),0)","v":{"v":0,"d":"¥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":"¥0.00"}},null,{"$f":"IFERROR(数据[[#This Row],[每月运营成本]]+数据[[#This Row],[每月还款]],\"\")","v":{"v":0,"d":"¥0.00"}},null,{"$f":"IFERROR(IF(数据[[#This Row],[原始价值]]>0,SLN(数据[[#This Row],[原始价值]],数据[[#This Row],[贷款期限结束时的预期价值]],数据[[#This Row],[剩余使用年限 ]]),0),0)","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(数据[[#This Row],[每年直线折旧价值]]/12,0)","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(数据[[#This Row],[原始价值]]-(数据[[#This Row],[每年直线折旧价值]]*((TODAY()-数据[[#This Row],[购买或租赁日期]])/365)),0)","v":{"v":0,"d":"¥0.00"}}]