{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"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":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":false,"merged":[[2,0,15,0],[16,0,32,0],[33,0,35,0]]}
[null,"前专业","前代码","前名称","现专业","现代码","现名称","备注","使用项目"]
[{"$nulls":8},"莞城万科城市广场","长安万科广场","虎门万科里","厚街万科城市广场","阿里巴巴滨江园区","工发新能源科技企业孵化器园区","武汉亚心总医院","清华大学","松湖万科生活广场"]
["设备","弱电WE","BANC","楼控网络控制器","弱电WE","BACU","楼控控制箱","更改编号，调整为同一种族",{"$nulls":4},"Pj3301080001",null,"Pj4201050001","Pj1101080005",null,"已修改"]
[null,"弱电WE","GMNC","车库网络控制器","弱电WE","GMCU","车库控制箱","更改编号，调整为同一种族",{"$nulls":9},"不需处理"]
[null,"其他OT","IDSP","蹲便器","土建CF","IDSP","蹲便器","更改专业代码，增加土建专业",null,null,null,"Pj4419000006",{"$nulls":5},"不需处理"]
[null,"其他OT","IDHD","干手机","土建CF","IDHD","干手机","更改专业代码，增加土建专业","Pj4419000005",{"$nulls":8},"不需处理"]
[null,"其他OT","IDWS","盥洗盆","土建CF","IDWS","盥洗盆","更改专业代码，增加土建专业","Pj4419000005",null,null,"Pj4419000006",{"$nulls":5},"不需处理"]
[null,"其他OT","IDUR","小便器","土建CF","IDUR","小便器","更改专业代码，增加土建专业","Pj4419000005",null,null,"Pj4419000006",{"$nulls":5},"不需处理"]
[null,"给排水WS","WSHP","水景水泵","给排水WS","WSPP","水景水泵","更改设备代码","Pj4419000005",{"$nulls":8},"已修改"]
[null,"给排水WS","DWHP","生活给水水泵","给排水WS","DWPP","生活给水水泵","更改设备代码","Pj4419000005","Pj4419000003","Pj4419000007","Pj4419000006",null,"Pj1102290002","Pj4201050001",null,null,"已修改"]
[null,"消防FF","EATS","温度探测器","消防FF","EALS","漏电探测器","合并设备类型",{"$nulls":9},"不需处理"]
[null,"消防FF","EAIS","电流探测器","消防FF","EALS","漏电探测器","合并设备类型",{"$nulls":9},"不需处理"]
[null,"弱电WE","PMSE","客流探测器","其他OT","SEPF","人流量传感器","合并设备类型",null,"Pj4419000003",{"$nulls":7},"已修改"]
[null,"弱电WE","PMEX","客流管理交换机","弱电WE","——","——","删除设备类型，若为交换机用LNEX，若为客流管理主机用PMHT",null,"Pj4419000003",{"$nulls":7},"已删除"]
[null,"强电SE","ELER","电梯救援设备","强电SE","——","——","删除设备类型，确认实例是什么设备",{"$nulls":4},"Pj3301080001",{"$nulls":4},"已删除"]
[null,"——","BAJG","——","——","——","——","自定义的类型",null,null,"Pj4419000007",{"$nulls":6},"已删除"]
["种族","——","CUC","伴热控制器","——","CUA","控制箱","合并为同一种族",{"$nulls":9},"已修改"]
[null,"——","CUB","水景控制器","——","CUA","控制箱","合并为同一种族",{"$nulls":9},"已修改"]
[null,"——","CUE","气体灭火控制器","——","CUA","控制箱","合并为同一种族",{"$nulls":9},"已修改"]
[null,"——","CUD","广播分区控制器","——","CUA","控制箱","合并为同一种族",{"$nulls":9},"已修改"]
[null,"——","CUG","门禁控制器","——","CUA","控制箱","合并为同一种族",{"$nulls":9},"已修改"]
[null,"——","NCA","网络控制器","——","CUA","控制箱","合并为同一种族",{"$nulls":9},"已修改"]
[null,"——","URA","小便器","——","URA","小便器","增加土建对象种族",{"$nulls":9},"不需处理"]
[null,"——","WSA","盥洗盆","——","WSA","盥洗盆","增加土建对象种族",{"$nulls":9},"不需处理"]
[null,"——","SPE","蹲便器","——","SPE","蹲便器","增加土建对象种族",{"$nulls":9},"不需处理"]
[null,"——","ISA","电流探测器","——","LSB","漏电探测器","设备类已合并，删除种族",{"$nulls":9},"已修改"]
[null,"——","TSB","温度探测器","——","LSB","漏电探测器","设备类已合并，删除种族",{"$nulls":9},"已修改"]
[null,"——","SEE","客流探测器","——","PFA","人流量传感器","设备类已合并，删除种族",{"$nulls":9},"已修改"]
[null,"——","VOA","室外机","——","OUA","室外机","更改种族代码",{"$nulls":9},"已修改"]
[null,"——","VIA","室内机","——","IUA","室内机","更改种族代码",{"$nulls":9},"已修改"]
[null,"——","CUF","巡更通讯座","——","CPD","巡更通讯座","更改种族代码，原代码有误",{"$nulls":9},"已修改"]
[null,"——","HAS","高压开关柜","——","HSA","高压开关柜","更改种族代码，原代码有误",{"$nulls":9},"已修改"]
[null,"——","ERA","电梯救援设备","——","——","——","设备类已删除，删除种族",{"$nulls":9},"已删除"]
["系统","其他OT","ID","室内装修","土建CF","ID","室内装修","更改专业代码，增加土建专业","Pj4419000005","Pj4419000003","Pj4419000007","Pj4419000006",{"$nulls":4},"Pj4419000008","不需处理"]
[null,"——","TJ","——","——","——","——","自定义类型","Pj4419000005","Pj4419000003","Pj4419000007","Pj4419000006",{"$nulls":4},"Pj4419000008","已删除"]
[null,"——","DR","——","——","——","——","自定义类型","Pj4419000005","Pj4419000003","Pj4419000007","Pj4419000006",{"$nulls":4},"Pj4419000008","已删除"]

{"sheet":"Sheet2","index":1,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,0,50,0],[1,1,2,1],[5,1,6,1],[8,1,13,1],[20,1,22,1],[23,1,31,1],[32,1,41,1],[42,1,44,1],[45,1,48,1],[49,1,50,1],[16,1,19,1],[8,4,10,4],[8,5,10,5],[8,6,10,6],[11,4,13,4],[11,5,13,5],[11,6,13,6]]}
["信息点","出处","前代码","前名称","现代码","现名称","备注","使用项目"]
[null,"设备通用","Mass","——","——","——","自定义信息点"]
[null,null,"EquipSerial","——","——","——","自定义信息点"]
[null,"FAAL, DWSU, KLSF, CCOP, CCGH, FASE, VTSF, CCCP","PowerType","电源类型","——","——","删除信息点"]
[null,"CHHP, ATFU, CCOP, ATAH, DHHP, FSHP, VTSF, CCCP, DWHP","IPGrade","防护等级","MotorIPGrade","电机防护等级","修改信息点名称和代码",null,"Pj4201050001"]
[null,"AEOV, AECV","ValveWirelessProtocol","无线协议","WirelessProtocol","无线协议","修改信息点代码"]
[null,null,"ValveMediumType","适用介质","MediumType","适用介质","修改信息点代码"]
[null,"AEFC","VFDInPhaseType","输入相数","InPhaseType","输入相数","修改信息点代码"]
[null,"STSP","APhaseI","A相电流","I","运行电流","合并信息点"]
[null,null,"BPhaseI","B相电流"]
[null,null,"CPhaseI","C相电流"]
[null,null,"APhaseU","A相电压","U","运行电压","合并信息点"]
[null,null,"BPhaseU","B相电压"]
[null,null,"CPhaseU","C相电压"]
[null,"CHBF","ComModeID","——","——","——","自定义信息点"]
[null,"TDLS\n低压开关柜","EquipLocalID2","本地编码2","——","——","删除信息点"]
[null,"VTIO\n通风风口","ValveOpening","——","——","——","自定义信息点"]
[null,null,"ValveSwitchStatus","——","——","——","自定义信息点"]
[null,null,"InCloudStatus","——","——","——","自定义信息点，已有RemoteStatus"]
[null,null,"ValveOpeningSet","——","——","——","自定义信息点"]
[null,"ATFC\n风机盘管","WaterValveSwitchStatus","盘管水阀开关状态","WaterValveOnOff","盘管水阀开关状态","修改信息点代码","Pj1101020002"]
[null,null,"InCloudStatus","——","——","——","自定义信息点，已有RemoteStatus","Pj1101020002",null,"Pj1101020001","Pj1101080251","Pj1101080001","Pj1101080002"]
[null,null,"WaterValveSwitchSet","——","——","——","自定义信息点","Pj1101020002"]
[null,"ATFU\n新风机组","FreshAirValveStatus","——","——","——","自定义信息点，已有FreshAirOpening","Pj1101020002"]
[null,null,"DValveStatus","——","——","——","自定义信息点","Pj1101020002"]
[null,null,"InCloudStatus","——","——","——","自定义信息点，已有RemoteStatus","Pj1101020002",{"$nulls":4},"Pj1101080002"]
[null,null,"FanStatus","——","——","——","自定义信息点，已有RunStatus","Pj1101020002"]
[null,null,"CtrlMode","控制模式","——","——","删除信息点",{"$nulls":5},"Pj1101080002"]
[null,null,"SupplyAirRHSet","——","——","——","自定义信息点","Pj1101020002"]
[null,null,"PrimFilterAlarm","——","——","——","自定义信息点，有FilterDetaPressAlarm","Pj1101020002"]
[null,null,"FrozenAlarm","——","——","——","自定义信息点","Pj1101020002"]
[null,null,"MedFilterAlarm","——","——","——","自定义信息点，有FilterDetaPressAlarm",null,"Pj4201050001"]
[null,"ATAH\n空调机组","FreshAirValveStatus","——","——","——","自定义信息点，已有FreshAirOpening",null,"Pj4201050001"]
[null,null,"DValveStatus","——","——","——","自定义信息点","Pj1101020002","Pj4201050001"]
[null,null,"InCloudStatus","——","——","——","自定义信息点，已有RemoteStatus","Pj1101020002","Pj4201050001"]
[null,null,"FanStatus","——","——","——","自定义信息点，已有RunStatus","Pj1101020002","Pj4201050001"]
[null,null,"DPManufacturerID","——","——","——","自定义信息点",null,"Pj4201050001"]
[null,null,"ReturnAirTempSet","——","——","——","自定义信息点，已有IndoorAirTempSet","Pj1101020002","Pj4201050001"]
[null,null,"SupplyAirRHSet","——","——","——","自定义信息点","Pj1101020002","Pj4201050001"]
[null,null,"PrimFilterAlarm","——","——","——","自定义信息点，有FilterDetaPressAlarm","Pj1101020002","Pj4201050001"]
[null,null,"FrozenAlarm","——","——","——","自定义信息点，有CoilAntifreezeAlarm","Pj1101020002","Pj4201050001"]
[null,null,"MedFilterAlarm","——","——","——","自定义信息点，有FilterDetaPressAlarm",null,"Pj4201050001"]
[null,"CC","CoolPumpCtrlMode","冷却泵控制模式","——","——","删除信息点"]
[null,null,"ChillPumpCtrlMode","冷冻泵控制模式","——","——","删除信息点"]
[null,null,"ChillerCtrlMode","冷机控制模式","——","——","删除信息点"]
[null,"空间","RoomSerial","——","——","——","自定义信息点"]
[null,null,"HCHO","——","——","——","自定义信息点"]
[null,null,"Area","——","——","——","自定义信息点，已有BuildArea建筑面积, NetArea使用面积"]
[null,null,"Length","——","——","——","自定义信息点，已有Width面宽, Depth进深"]
[null,"楼层","NetHeight","——","——","——","自定义信息点，已有Height楼层高度"]
[null,null,"FloorIdentity","——","——","——","自定义信息点"]

{"sheet":"Sheet3","index":2,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[[8,6,13,6],[8,5,10,5],[11,5,13,5],[32,0,40,0],[41,0,43,0],[44,0,47,0],[48,0,49,0],[8,4,10,4],[11,4,13,4],[1,0,2,0],[5,0,6,0],[8,0,13,0],[16,0,19,0],[20,0,22,0],[23,0,31,0]]}
["出处","前代码"]
["设备通用","Mass",null,"自定义","删除",null,"已删除"]
[null,"EquipSerial",null,"自定义","删除",null,"已删除"]
["FAAL, DWSU, KLSF, CCOP, CCGH, FASE, VTSF, CCCP","PowerType",null,null,"删除",null,"SEEE，SETP，SEFL也有该信息"]
["CHHP, ATFU, CCOP, ATAH, DHHP, FSHP, VTSF, CCCP, DWHP","IPGrade",null,null,"改编码","MotorIPGrade","已更新","FSSP也有该信息"]
["AEOV, AECV","ValveWirelessProtocol",null,null,"改编码","WirelessProtocol","已更新，数据库全是空数组，删除了"]
[null,"ValveMediumType",null,null,"改编码","MediumType","已更新，数据库全是空数组，删除了"]
["AEFC","VFDInPhaseType",null,null,"改编码","InPhaseType","已更新，数据库中只有一条空数据，删除了"]
["STSP","APhaseI",null,null,"合并","I","不合并"]
[null,"BPhaseI"]
[null,"CPhaseI"]
[null,"APhaseU",null,null,"合并","U"]
[null,"BPhaseU"]
[null,"CPhaseU"]
["CHBF","ComModeID",null,"自定义","删除",null,"已删除"]
["TDLS","EquipLocalID2",null,null,"删除",null,"已删除"]
["VTIO","ValveOpening",null,"自定义","删除",null,"已删除"]
[null,"ValveSwitchStatus",null,"自定义","删除",null,"已删除"]
[null,"InCloudStatus",null,"自定义","删除",null,"暂不处理，[ATAH, VTIO, ATFU, ATFC]含有该信息点"]
[null,"ValveOpeningSet",null,"自定义","删除",null,"已删除"]
["ATFC","WaterValveSwitchStatus",null,null,"增加"]
[null,"InCloudStatus",null,null,"增加","统一3个信息点，多个设备"]
[null,"WaterValveSwitchSet",null,null,"增加"]
["ATFU","FreshAirValveStatus",null,null,"增加"]
[null,"DValveStatus",null,null,"增加","编码改为DStatus","已更新"]
[null,"InCloudStatus",null,null,"增加","统一3个信息点，多个设备"]
[null,"FanStatus",null,null,"增加","编码改为SupplyAirStatus","已更新"]
[null,"CtrlMode",null,null,"删除",null,"已删除"]
[null,"SupplyAirRHSet",null,null,"增加"]
[null,"PrimFilterAlarm",null,null,"增加"]
[null,"FrozenAlarm",null,null,"增加"]
[null,"MedFilterAlarm",null,null,"增加"]
["ATAH","FreshAirValveStatus",null,null,"增加"]
[null,"DValveStatus",null,null,"增加","编码改为DStatus","已更新"]
[null,"InCloudStatus",null,null,"增加","统一3个信息点，多个设备"]
[null,"FanStatus",null,null,"增加","编码改为SupplyAirStatus","已更新"]
[null,"ReturnAirTempSet",null,null,"更改","IndoorAirTempSet改","已更新"]
[null,"SupplyAirRHSet",null,null,"增加"]
[null,"PrimFilterAlarm",null,null,"增加"]
[null,"FrozenAlarm",null,null,"增加"]
[null,"MedFilterAlarm",null,null,"增加"]
["CC","CoolPumpCtrlMode",null,null,"删除",null,"已删除"]
[null,"ChillPumpCtrlMode",null,null,"删除",null,"已删除"]
[null,"ChillerCtrlMode",null,null,"删除",null,"已删除"]
["空间","RoomSerial",null,"自定义","删除",null,"已删除"]
[null,"HCHO",null,null,"增加"]
[null,"Area",null,"自定义","删除",null,"已删除"]
[null,"Length",null,"自定义","删除",null,"已删除"]
["楼层","NetHeight",null,"自定义","删除",null,"已删除"]
[null,"FloorIdentity",null,"自定义","删除",null,"已删除"]
[]
["数据字典添加界面改密码"]