{"text_format":"2","workbook":"xlsx","n_sheets":15,"sheets":["Sheet1","用电分项","用冷分项","用热分项","用水分项","用燃气分项","用燃油分项","用蒸汽分项","自控","信标","空间","设备组","租户","支路","仪表"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sheet1","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"用电分项","VOSe"]
[null,"用冷分项","VOSc"]
[null,"用热分项","VOSh"]
[null,"用水分项","VOSw"]
[null,"用燃气分项","VOSg"]
[null,"用燃油分项","VOSf"]
[null,"用蒸汽分项","VOSv"]
[]
[null,"虚拟建筑","VOBd"]
[null,"计算单元","VOCu"]
[null,"租户","VOTn"]
[null,"区域","VOZn"]
[null,"设备组","VOGp"]
[null,"自控","VOCt"]
[null,"信标","VOBc"]
[null,"支路","VOBr"]
[null,"仪表","VOMt"]

{"sheet":"用电分项","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,0,9,1],[10,0,10,1],[11,0,11,1],[8,0,8,1],[0,0,0,8],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,7,1]]}
["用电分项"]
["分级标签",null,"信息点","信息点编码","单位","类型","输入方式","字典选择"," 备注"]
[null,null,"分项ID","SubentryID",null,"Str","X"]
[null,null,"分项名称","SubentryName",null,"Str","X"]
["技术参数",null,"分项本地编码","SubentryLocalID",null,"Str","B1"]
[null,null,"分项本地名称","SubentryLocalName",null,"Str","B1"]
[null,null,"所属分项树","SubentryTree",null,"Tree","Y"]
[null,null,"分项描述","SubentryFunc",null,"Str","B1"]
["运行参数",null,"分项用电能耗","SubentryElec","kWh","Inst","L"]
["设定参数"]
["事件记录"]
["工单存档"]

{"sheet":"用冷分项","index":2,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,0,9,1],[10,0,10,1],[11,0,11,1],[0,0,0,8],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,7,1],[8,0,8,1]]}
["用冷分项"]
["分级标签",null,"信息点","信息点编码","单位","类型","输入方式","字典选择"," 备注"]
[null,null,"分项ID","SubentryID",null,"Str","X"]
[null,null,"分项名称","SubentryName",null,"Str","X"]
["技术参数",null,"分项本地编码","SubentryLocalID",null,"Str","B1"]
[null,null,"分项本地名称","SubentryLocalName",null,"Str","B1"]
[null,null,"所属分项树","SubentryTree",null,"Tree","Y"]
[null,null,"分项描述","SubentryFunc",null,"Str","B1"]
["运行参数",null,"分项用冷量","SubentryCooling","kWh","Inst","L"]
["设定参数"]
["事件记录"]
["工单存档"]

{"sheet":"用热分项","index":3,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,0,9,1],[10,0,10,1],[11,0,11,1],[0,0,0,8],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,7,1],[8,0,8,1]]}
["用热分项"]
["分级标签",null,"信息点","信息点编码","单位","类型","输入方式","字典选择"," 备注"]
[null,null,"分项ID","SubentryID",null,"Str","X"]
[null,null,"分项名称","SubentryName",null,"Str","X"]
["技术参数",null,"分项本地编码","SubentryLocalID",null,"Str","B1"]
[null,null,"分项本地名称","SubentryLocalName",null,"Str","B1"]
[null,null,"所属分项树","SubentryTree",null,"Tree","Y"]
[null,null,"分项描述","SubentryFunc",null,"Str","B1"]
["运行参数",null,"分项用热量","SubentryHeating","kWh","Inst","L"]
["设定参数"]
["事件记录"]
["工单存档"]

{"sheet":"用水分项","index":4,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,0,9,1],[10,0,10,1],[11,0,11,1],[0,0,0,8],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,7,1],[8,0,8,1]]}
["用水分项"]
["分级标签",null,"信息点","信息点编码","单位","类型","输入方式","字典选择"," 备注"]
[null,null,"分项ID","SubentryID",null,"Str","X"]
[null,null,"分项名称","SubentryName",null,"Str","X"]
["技术参数",null,"分项本地编码","SubentryLocalID",null,"Str","B1"]
[null,null,"分项本地名称","SubentryLocalName",null,"Str","B1"]
[null,null,"所属分项树","SubentryTree",null,"Tree","Y"]
[null,null,"分项描述","SubentryFunc",null,"Str","B1"]
["运行参数",null,"分项用水量","SubentryWater","m3","Inst","L"]
["设定参数"]
["事件记录"]
["工单存档"]

{"sheet":"用燃气分项","index":5,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,0,9,1],[10,0,10,1],[11,0,11,1],[0,0,0,8],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,7,1],[8,0,8,1]]}
["用燃气分项"]
["分级标签",null,"信息点","信息点编码","单位","类型","输入方式","字典选择"," 备注"]
[null,null,"分项ID","SubentryID",null,"Str","X"]
[null,null,"分项名称","SubentryName",null,"Str","X"]
["技术参数",null,"分项本地编码","SubentryLocalID",null,"Str","B1"]
[null,null,"分项本地名称","SubentryLocalName",null,"Str","B1"]
[null,null,"所属分项树","SubentryTree",null,"Tree","Y"]
[null,null,"分项描述","SubentryFunc",null,"Str","B1"]
["运行参数",null,"分项用燃气量","SubentryGas","m3","Inst","L"]
["设定参数"]
["事件记录"]
["工单存档"]

{"sheet":"用燃油分项","index":6,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,0,9,1],[10,0,10,1],[11,0,11,1],[0,0,0,8],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,7,1],[8,0,8,1]]}
["用燃油分项"]
["分级标签",null,"信息点","信息点编码","单位","类型","输入方式","字典选择"," 备注"]
[null,null,"分项ID","SubentryID",null,"Str","X"]
[null,null,"分项名称","SubentryName",null,"Str","X"]
["技术参数",null,"分项本地编码","SubentryLocalID",null,"Str","B1"]
[null,null,"分项本地名称","SubentryLocalName",null,"Str","B1"]
[null,null,"所属分项树","SubentryTree",null,"Tree","Y"]
[null,null,"分项描述","SubentryFunc",null,"Str","B1"]
["运行参数",null,"分项用燃油量","SubentryFuel","L","Inst","L"]
["设定参数"]
["事件记录"]
["工单存档"]

{"sheet":"用蒸汽分项","index":7,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,0,9,1],[10,0,10,1],[11,0,11,1],[0,0,0,8],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,7,1],[8,0,8,1]]}
["用蒸汽分项"]
["分级标签",null,"信息点","信息点编码","单位","类型","输入方式","字典选择"," 备注"]
[null,null,"分项ID","SubentryID",null,"Str","X"]
[null,null,"分项名称","SubentryName",null,"Str","X"]
["技术参数",null,"分项本地编码","SubentryLocalID",null,"Str","B1"]
[null,null,"分项本地名称","SubentryLocalName",null,"Str","B1"]
[null,null,"所属分项树","SubentryTree",null,"Tree","Y"]
[null,null,"分项描述","SubentryFunc",null,"Str","B1"]
["运行参数",null,"分项用蒸汽量","SubentryVapor","kg","Inst","L"]
["设定参数"]
["事件记录"]
["工单存档"]

{"sheet":"自控","index":8,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,0,8,1],[9,0,9,1],[10,0,10,1],[7,0,7,1],[0,0,0,8],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,6,1]]}
["自控"]
["分级标签",null,"信息点","信息点编码","单位","类型","输入方式","字典选择"," 备注"]
[null,null,"自控ID","ControlID",null,"Str","X"]
[null,null,"自控名称","ControlName",null,"Str","X"]
["技术参数",null,"自控本地编码","ControlLocalID",null,"Str","B1"]
[null,null,"自控本地名称","ControlLocalName",null,"Str","B1"]
[null,null,"自控描述","ControlFunc",null,"Str","B1"]
["运行参数"]
["设定参数"]
["事件记录"]
["工单存档"]

{"sheet":"信标","index":9,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,0,13,1],[14,0,14,1],[15,0,15,1],[12,0,12,1],[0,0,0,8],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,11,1]]}
["信标"]
["分级标签",null,"信息点","信息点编码","单位","类型","输入方式","字典选择"," 备注"]
[null,null,"信标ID","BeaconID",null,"Str","X"]
[null,null,"信标名称","BeaconName",null,"Str","X"]
["技术参数",null,"信标本地编码","BeaconLocalID",null,"Str","B1"]
[null,null,"信标本地名称","BeaconLocalName",null,"Str","B1"]
[null,null,"信标位置","BeaconSite",null,"Str","B1"]
[null,null,"信标类型","BeaconType",null,"Str","B1"]
[null,null,"信标照片","Pic",null,"Attachment","F2"]
[null,null,"二维码图片","BeaconQRCode",null,"Attachment","F2"]
[null,null,"BIM模型中编码","BIMID",null,"Str","B1"]
[null,null,"自控描述","ControlFunc",null,"Str","B1"]
["运行参数"]
["设定参数"]
["事件记录"]
["工单存档"]

{"sheet":"空间","index":10,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[10,0,10,1],[11,0,11,1],[12,0,12,1],[9,0,9,1],[0,0,0,8],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,8,1]]}
["区域"]
["分级标签",null,"信息点","信息点编码","单位","类型","输入方式","字典选择"," 备注"]
[null,null,"区域ID","ZoneID",null,"Str","X"]
[null,null,"区域名称","ZoneName",null,"Str","X"]
["技术参数",null,"区域本地编码","ZoneLocalID",null,"Str","B1"]
[null,null,"区域本地名称","ZoneLocalName",null,"Str","B1"]
[null,null,"区域功能类型","ZoneFunc",null,"Str","B1"]
[null,null,"区域面积","ZoneArea","m2","Num","A2"]
[null,null,"区域常驻人数","ZonePermanentPeopleNum","人","Num","A2"]
["运行参数"]
["设定参数"]
["事件记录"]
["工单存档"]

{"sheet":"设备组","index":11,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,0,8,1],[9,0,9,1],[10,0,10,1],[7,0,7,1],[0,0,0,8],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,6,1]]}
["设备组"]
["分级标签",null,"信息点","信息点编码","单位","类型","输入方式","字典选择"," 备注"]
[null,null,"设备组ID","GroupID",null,"Str","X"]
[null,null,"设备组名称","GroupName",null,"Str","X"]
["技术参数",null,"设备组本地编码","GroupLocalID",null,"Str","B1"]
[null,null,"设备组本地名称","GroupLocalName",null,"Str","B1"]
[null,null,"设备组功能","GroupFunc",null,"Str","B1"]
["运行参数"]
["设定参数"]
["事件记录"]
["工单存档"]

{"sheet":"租户","index":12,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[42,0,42,1],[43,0,43,1],[44,0,44,1],[6,0,24,1],[25,0,41,1],[0,0,0,8],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,5,1]]}
["租户"]
["分级标签",null,"信息点","信息点编码","单位","类型","输入方式","字典选择"," 备注"]
[null,null,"租户ID","TenantID",null,"Str","X"]
[null,null,"租户名称","TenantName",null,"Str","X"]
["基本信息",null,"租户本地编码","TenantLocalID",null,"Str","B1"]
[null,null,"租户本地名称","TenantLocalName",null,"Str","B1"]
["租赁信息",null,"房间编号","RoomID",null,"Str","B1"]
[null,null,"激活时间","ActiveTime",null,"Time","C5"]
[null,null,"退租时间","SurrenderTime",null,"Time","C5"]
[null,null,"租赁业态类型","TenantType",null,"Enum","D1","见《9租赁业态类型》"]
[null,null,"联系人","TenantContactor",null,"Str","B1"]
[null,null,"联系电话","TenantPhone",null,"Str","B1"]
[null,null,"是否使用电系统","isElecSys",null,"Bool","E1","0. 否 1. 是"]
[null,null,"电付费类型","ElecPayType",null,"Enum","D1","1. 预付费-表充表扣 2. 预付费-软充表扣 3. 预付费-软充软扣 4. 后付费"]
[null,null,"电是否分时","isElecTimePrice",null,"Bool","E1","0. 否 1. 是"]
[null,null,"电价格方案","ElecPriceScheme",null,"Str","B1"]
[null,null,"是否使用水系统","isWaterSys",null,"Bool","E1","0. 否 1. 是"]
[null,null,"水付费类型","WaterPayType",null,"Enum","D1","1. 预付费-表充表扣 2. 预付费-软充表扣 3. 预付费-软充软扣 4. 后付费"]
[null,null,"水价格方案","WaterPriceScheme",null,"Str","B1"]
[null,null,"是否使用热水系统","isHotWaterSys",null,"Bool","E1","0. 否 1. 是"]
[null,null,"热水付费类型","HotWaterPayType",null,"Enum","D1","1. 预付费-表充表扣 2. 预付费-软充表扣 3. 预付费-软充软扣 4. 后付费"]
[null,null,"热水价格方案","HotWaterPriceScheme",null,"Str","B1"]
[null,null,"是否使用燃气系统","isGasSys",null,"Bool","E1","0. 否 1. 是"]
[null,null,"燃气付费类型","GasPayType",null,"Enum","D1","1. 预付费-表充表扣 2. 预付费-软充表扣 3. 预付费-软充软扣 4. 后付费"]
[null,null,"燃气价格方案","GasPriceScheme",null,"Str","B1"]
["能耗信息",null,"累计用电量","ElecAccConsum","kWh","Acc","L"]
[null,null,"累计分时用电量","ElecAccTimeConsum","kWh","Acc","L"]
[null,null,"累计用电金额","ElecAccCost","元","Acc","L"]
[null,null,"剩余电量","ElecSurplusConsum","kWh","Acc","L"]
[null,null,"剩余电金额","ElecSurplusCost","元","Acc","L"]
[null,null,"累计用水量","WaterAccConsum","m3","Acc","L"]
[null,null,"累计用水金额","WaterAccCost","元","Acc","L"]
[null,null,"剩余水量","WaterSurplusConsum","m3","Acc","L"]
[null,null,"剩余水金额","WaterSurplusCost","元","Acc","L"]
[null,null,"累计用热水量","HotWaterAccConsum","m3","Acc","L"]
[null,null,"累计用热水金额","HotWaterAccCost","元","Acc","L"]
[null,null,"剩余热水量","HotWaterSurplusConsum","m3","Acc","L"]
[null,null,"剩余热水金额","HotWaterSurplusCost","元","Acc","L"]
[null,null,"累计用燃气量","GasAccConsum","m3","Acc","L"]
[null,null,"累计用燃气金额","GasAccCost","元","Acc","L"]
[null,null,"剩余燃气量","GasSurplusConsum","m3","Acc","L"]
[null,null,"剩余燃气金额","GasSurplusCost","元","Acc","L"]
["设定参数"]
["事件记录"]
["工单存档"]

{"sheet":"支路","index":13,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[11,0,11,1],[12,0,12,1],[13,0,13,1],[4,0,9,1],[0,0,0,8],[1,0,1,1],[2,0,2,1],[3,0,3,1],[10,0,10,1]]}
["支路"]
["分级标签",null,"信息点","信息点编码","单位","类型","输入方式","字典选择"," 备注"]
[null,null,"支路ID","BranchID",null,"Str","X"]
[null,null,"支路名称","BranchName",null,"Str","X"]
["技术参数",null,"支路本地编码","BranchLocalID",null,"Str","B1"]
[null,null,"支路本地名称","BranchLocalName",null,"Str","B1"]
[null,null,"柜号","CabID",null,"Str","B1"]
[null,null,"线号","LineID",null,"Str","B1"]
[null,null,"支路类型","BranchType",null,"Enum","D1","1. 高压进线柜 2. 高压出线柜 3. 低压进线柜 4. 低压出线柜 5. 母联柜 6. 双电源开关柜 7. 末端配电柜 8. 无功补偿柜 9. 综合电表 10. 计量柜 11. 计费电表 12. 滤波装置 13. 电压调节装置 14. 水支路 99. 其他"]
[null,null,"备注信息","Remark",null,"Str","B1"]
["运行参数"]
["设定参数"]
["事件记录"]
["工单存档"]

{"sheet":"仪表","index":14,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[21,0,21,1],[22,0,22,1],[23,0,23,1],[0,0,0,8],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,19,1],[20,0,20,1]]}
["仪表"]
["分级标签",null,"信息点","信息点编码","单位","类型","输入方式","字典选择"," 备注"]
[null,null,"仪表ID","MeterID",null,"Str","X"]
[null,null,"仪表名称","MeterName",null,"Str","X"]
["技术参数",null,"仪表本地编码","MeterLocalID",null,"Str","B1"]
[null,null,"仪表本地名称","MeterLocalName",null,"Str","B1"]
[null,null,"采集器网关MAC地址","CollectorGatewayMAC",null,"Str","B1"]
[null,null,"采集器网关IP","CollectorGatewayIP",null,"Str","B1"]
[null,null,"采集器子网掩码","CollectorNetmask",null,"Str","B1"]
[null,null,"采集器网关","CollectorGateway",null,"Str","B1"]
[null,null,"采集频率","CollectFreq","min","Num","A2"]
[null,null,"总线端口号","BusportID",null,"Str","B1"]
[null,null,"仪表地址码","MeterAddressID",null,"Str","B1"]
[null,null,"仪表号-功能号","MeterIDFuncID",null,"Str","B1"]
[null,null,"仪表位置","MeterPosition",null,"Str","B1"]
[null,null,"点位类型","DataType",null,"Enum","D1","1. 累计量Acc 2. 瞬时量Inst 3. 通断变量Boolv 4. 状态变量Enumv 99. 其他"]
[null,null,"来源系统","SystemSource",null,"Str","B1"]
[null,null,"数据来源","DataSource",null,"Str","B1"]
[null,null,"数据单位","DataUnit",null,"Str","B1"]
[null,null,"备注信息","Remark",null,"Str","B1"]
["运行参数"]
["设定参数"]
["事件记录"]
["工单存档"]