{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["仪表板","设备列表","透视数据"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":22,"comments":0,"pivot_tables":1},"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":"仪表板","index":0,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"仪表板"]
[]
[]
[null,null,null,null,null,"总计数"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"计数\",透视数据!$B$9)","v":3}]
[]
[null,null,null,null,null,"月度总成本"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"月度总成本\",透视数据!$B$9)","v":17655.943035068674}]
[]
[null,null,null,null,null,"运营成本"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"运营成本\",透视数据!$B$9)","v":6050}]
[]
[null,null,null,null,null,"月度折旧"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"月度折旧\",透视数据!$B$9)","v":6597.2222222222226}]
[]
[null,null,null,null,null,"付款金额"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"付款金额\",透视数据!$B$9)","v":11605.943035068674}]
[]
[null,null,null,null,null,"当前值"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"当前值 \",透视数据!$B$9)","v":369687.21461187216}]

{"sheet":"设备列表","index":1,"n_rows":9,"n_cols":20,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"设备列表"]
[]
[null,null,null,"月度付款小于该值时突出显示： ",20]
[]
[null,"资产或序列号","描述","位置","条件","供应商","剩余服务\n年限 ","初始值","预付定金","购买或租赁日期","贷款期限（年）","贷款\n利率","月度运营成本","合同终止时的预期值","剩余月度付款","月度付款","月度总成本","年度折旧（直线）","月度折旧（直线）","当前值"]
[null,123,"构造模型 1","主分支","良好","当地",5,300000,50000,"2011-01-15",4,0.1,2000,200000,{"$f":"IFERROR(SUMPRODUCT(--(DAY(ROW(OFFSET($A$1,,,DATE(YEAR(设备[[#This Row],[购买或租赁日期]])+设备[[#This Row],[贷款期限（年）]],MONTH(设备[[#This Row],[购买或租赁日期]])-1,DAY(设备[[#This Row],[购买或租赁日期]]))-TODAY()))+DATE(YEAR(设备[[#This Row],[购买或租赁日期]])+设备[[#This Row],[贷款期限（年）]],MONTH(设备[[#This Row],[购买或租赁日期]]),DAY(设备[[#This Row],[购买或租赁日期]]))-1)=DAY(设备[[#This Row],[购买或租赁日期]]))),0)","v":24},{"$f":"IFERROR(-(设备[初始值]>0)*(设备[初始值]<>设备[预付定金])*PMT(设备[贷款\n利率]/MonthsInYear,设备[贷款期限（年）]*MonthsInYear,设备[初始值]-设备[预付定金]),0)","v":6340.6458586867975},{"$f":"设备[[#This Row],[月度付款]]+设备[月度运营成本]","v":8340.6458586867975},{"$f":"IFERROR((设备[初始值]>0)*SLN(设备[初始值],设备[合同终止时的预期值],设备[贷款期限（年）]),0)","v":25000},{"$f":"IFERROR(设备[年度折旧（直线）]/MonthsInYear,0)","v":2083.3333333333335},{"$f":"IFERROR(设备[初始值]-(设备[年度折旧（直线）]*((TODAY()-设备[购买或租赁日期])/DaysInYear)),0)","v":251849.31506849316}]
[null,234,"构造模型 2","主分支","良好","当地",4,125000,15000,"2011-03-10",3,7.7499999999999999E-2,1200,30000,{"$f":"IFERROR(SUMPRODUCT(--(DAY(ROW(OFFSET($A$1,,,DATE(YEAR(设备[[#This Row],[购买或租赁日期]])+设备[[#This Row],[贷款期限（年）]],MONTH(设备[[#This Row],[购买或租赁日期]])-1,DAY(设备[[#This Row],[购买或租赁日期]]))-TODAY()))+DATE(YEAR(设备[[#This Row],[购买或租赁日期]])+设备[[#This Row],[贷款期限（年）]],MONTH(设备[[#This Row],[购买或租赁日期]]),DAY(设备[[#This Row],[购买或租赁日期]]))-1)=DAY(设备[[#This Row],[购买或租赁日期]]))),0)","v":14},{"$f":"IFERROR(-(设备[初始值]>0)*(设备[初始值]<>设备[预付定金])*PMT(设备[贷款\n利率]/MonthsInYear,设备[贷款期限（年）]*MonthsInYear,设备[初始值]-设备[预付定金]),0)","v":3434.3280007691897},{"$f":"设备[[#This Row],[月度付款]]+设备[月度运营成本]","v":4634.3280007691901},{"$f":"IFERROR((设备[初始值]>0)*SLN(设备[初始值],设备[合同终止时的预期值],设备[贷款期限（年）]),0)","v":31666.666666666668},{"$f":"IFERROR(设备[年度折旧（直线）]/MonthsInYear,0)","v":2638.8888888888891},{"$f":"IFERROR(设备[初始值]-(设备[年度折旧（直线）]*((TODAY()-设备[购买或租赁日期])/DaysInYear)),0)","v":68694.063926940638}]
[null,345,"构造模型 2","分支 1","一般","其他",1,100000,25000,"2010-09-15",4,0.08,2850,10000,{"$f":"IFERROR(SUMPRODUCT(--(DAY(ROW(OFFSET($A$1,,,DATE(YEAR(设备[[#This Row],[购买或租赁日期]])+设备[[#This Row],[贷款期限（年）]],MONTH(设备[[#This Row],[购买或租赁日期]])-1,DAY(设备[[#This Row],[购买或租赁日期]]))-TODAY()))+DATE(YEAR(设备[[#This Row],[购买或租赁日期]])+设备[[#This Row],[贷款期限（年）]],MONTH(设备[[#This Row],[购买或租赁日期]]),DAY(设备[[#This Row],[购买或租赁日期]]))-1)=DAY(设备[[#This Row],[购买或租赁日期]]))),0)","v":20},{"$f":"IFERROR(-(设备[初始值]>0)*(设备[初始值]<>设备[预付定金])*PMT(设备[贷款\n利率]/MonthsInYear,设备[贷款期限（年）]*MonthsInYear,设备[初始值]-设备[预付定金]),0)","v":1830.9691756126863},{"$f":"设备[[#This Row],[月度付款]]+设备[月度运营成本]","v":4680.9691756126867},{"$f":"IFERROR((设备[初始值]>0)*SLN(设备[初始值],设备[合同终止时的预期值],设备[贷款期限（年）]),0)","v":22500},{"$f":"IFERROR(设备[年度折旧（直线）]/MonthsInYear,0)","v":1875},{"$f":"IFERROR(设备[初始值]-(设备[年度折旧（直线）]*((TODAY()-设备[购买或租赁日期])/DaysInYear)),0)","v":49143.835616438351}]
[null,"总计",null,null,null,null,{"$f":"SUBTOTAL(101,设备[剩余服务\n年限 ])","v":3.3333333333333335},{"$f":"SUBTOTAL(109,设备[初始值])","v":525000},{"$f":"SUBTOTAL(109,设备[预付定金])","v":90000},null,{"$f":"SUBTOTAL(101,设备[贷款期限（年）])","v":3.6666666666666665},{"$f":"SUBTOTAL(101,设备[贷款\n利率])","v":8.5833333333333331E-2},{"$f":"SUBTOTAL(109,设备[月度运营成本])","v":6050},{"$f":"SUBTOTAL(109,设备[合同终止时的预期值])","v":240000},{"$f":"SUBTOTAL(101,设备[剩余月度付款])","v":19.333333333333332},{"$f":"SUBTOTAL(109,设备[月度付款])","v":11605.943035068674},{"$f":"SUBTOTAL(109,设备[月度总成本])","v":17655.943035068674},{"$f":"SUBTOTAL(101,设备[年度折旧（直线）])","v":26388.888888888891},{"$f":"SUBTOTAL(101,设备[月度折旧（直线）])","v":2199.0740740740744},{"$f":"SUBTOTAL(109,设备[当前值])","v":369687.21461187216}]

{"sheet":"透视数据","index":2,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"透视数据"]
[null,"此工作表应保持隐藏。 更改此工作表中的数据透视表结构可能导致仪表板切片器出错。"]
[null,"位置","(全部)"]
[null,"条件","(全部)"]
[null,"供应商","(全部)"]
[null,"剩余服务\n年限 ","(全部)"]
[null,"贷款期限（年）","(全部)"]
[]
[null,"行标签","计数","运营成本","付款金额","月度总成本 ","月度折旧","当前值 "]
[null,123,1,2000,6340.6458586867975,8340.6458586867975,2083.3333333333335,251849.31506849316]
[null,234,1,1200,3434.3280007691897,4634.3280007691901,2638.8888888888891,68694.063926940638]
[null,345,1,2850,1830.9691756126863,4680.9691756126867,1875,49143.835616438351]
[null,"总计",3,6050,11605.943035068674,17655.943035068674,6597.2222222222226,369687.21461187216]