{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["COVER","功能码格式","遥信量(功能码04)","遥测量(功能码04)"],"not_rendered":{"defined_names":39,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"COVER","index":0,"n_rows":4,"n_cols":4,"rows_kept":4}
["Date","Changelog","DB Version","MTR FW Version"]
["2023-03-25","规划功能码",0.1]
["2023-07-27","添加工装测试数据，塔式机数据"]
["2023-07-28","模块数据改为地址索引"]

{"sheet":"功能码格式","index":1,"n_rows":29,"n_cols":12,"rows_kept":29,"merged":[[9,2,9,7],[14,2,15,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,7,15,7],[17,2,17,11],[18,6,18,7],[18,8,18,9],[19,6,19,7],[19,8,19,9],[24,2,25,2],[24,3,25,3],[24,4,25,4],[24,5,25,5],[24,7,25,7],[24,8,25,8],[24,9,25,9],[26,2,27,2],[26,3,27,3],[26,4,27,4],[26,5,27,5],[26,8,27,8],[26,9,27,9]]}
{"$rows_empty":9}
[null,null,"RTU模式请求帧信息为: "]
[{"$nulls":3},"地址","功能码","寄存器起始地址","寄存器个数","CRC校验"]
[null,null,"数据","0x**","0x04","0x0***","N(2个字节)","0x****"]
[null,null,"响应帧信息为: "]
[{"$nulls":3},"地址","功能码","返回数据字节数","数据内容","CRC校验"]
[null,null,"数据","0x**","0x04","2N（1个字节）","0x****, …","0x ****"]
[{"$nulls":6},"0x****"]
[]
[null,null,"ASCII模式请求帧信息为: "]
[{"$nulls":3},"起始","地址","功能码","寄存器起始地址",null,"寄存器个数",null,"LRC","LRC"]
[null,null,"数据",":","0x**","0x04","0x0***",null,"N(2个字节)",null,"0x**","0x**"]
[null,null,"ASCII","0x3A","0x****","0x3034","0x30**","0x****","0x****","0x****","0x****","0x****"]
[]
[]
[null,null,"响应帧信息为:"]
[{"$nulls":3},"起始","地址","功能码","返回数据","数据内容","LRC","结束"]
[{"$nulls":6},"字节数"]
[null,null,"数据",":","0x**","0x04","2N","0x****, … , 0x****","0x**","CRLF"]
[{"$nulls":6},"(1字节)","(2N 个字节)"]
[null,null,"ASCII","0x3A","0x****","0x3034","0x****","0x****,0x****, …, 0x****,0x****","0x****","0x0D0A"]

{"sheet":"遥信量(功能码04)","index":2,"n_rows":147,"n_cols":5,"rows_kept":147,"merged":[[3,0,18,0],[3,1,18,1],[3,2,18,2],[22,0,37,0],[22,1,37,1],[22,2,37,2],[38,0,53,0],[38,1,53,1],[38,2,53,2],[54,0,67,0],[54,1,67,1],[54,2,67,2],[68,0,70,0],[68,1,70,1],[68,2,70,2],[68,3,70,3],[71,0,73,0],[71,1,73,1],[71,2,73,2],[71,3,73,3],[75,0,76,0],[75,1,76,1],[75,2,76,2],[75,3,76,3],[78,0,79,0],[78,1,79,1],[78,2,79,2],[80,0,82,0],[80,1,82,1],[80,2,82,2],[90,0,90,4],[91,0,106,0],[91,1,106,1],[91,2,106,2],[107,0,122,0],[107,1,122,1],[107,2,122,2],[123,0,131,0],[123,1,131,1],[123,2,131,2]]}
["寄存器序号","名称","数据类型","位定义功能","值"]
[1,"供电方式","Unsigned int",null,"0：均不供电\n1：UPS供电\n2：旁路供电"]
[2,"电池状态","Unsigned int",null,"1：电池浮充\n2：电池均充\n3：电池放电\n0：电池未工作"]
[3,"机柜告警状态综合1","Unsigned int","bit0：电池连接状态","0：未连接\n1：已连接"]
[{"$nulls":3},"bit1：维修旁路空开状态","0：断开\n1：闭合"]
[{"$nulls":3},"bit2：EPO","0：无紧急关机\n1：紧急关机"]
[{"$nulls":3},"bit3：逆变器启动容量不足","0：逆变器启动容量足够\n1：逆变器启动容量不足"]
[{"$nulls":3},"bit4：发电机接入","0：断开\n1：接入"]
[{"$nulls":3},"bit5：交流输入故障","0：正常\n1：故障"]
[{"$nulls":3},"bit6：旁路相序故障","0：正常\n1：故障"]
[{"$nulls":3},"bit7：旁路电压故障","0：正常\n1：故障"]
[{"$nulls":3},"bit8：旁路故障","0：正常\n1：故障"]
[{"$nulls":3},"bit9：旁路过载","0：未过载\n1：过载"]
[{"$nulls":3},"bit10：旁路过载超时","0：正常\n1：过载超时"]
[{"$nulls":3},"bit11：旁路超跟踪","0：正常\n1：旁路超跟踪"]
[{"$nulls":3},"bit12：切换次数到","0：次数未到\n1：次数到"]
[{"$nulls":3},"bit13：输出短路","0：输出未短路\n1：输出短路"]
[{"$nulls":3},"bit14：电池EOD","0：电池未EOD\n1：电池EOD"]
[{"$nulls":3},"bit15：电池测试开始（保留）","0：无电池测试\n1：电池测试"]
[4,"电池自检状态","Unsigned int",null,"0：未自检\n1：成功\n2：失败\n3：自检中"]
[5,"电池手动自检开始","Unsigned int",null,"0：无电池测试\n1：电池测试"]
[6,"电池维护状态","Unsigned int",null,"0：未维护测试\n1：成功\n2：失败\n3：维护测试中"]
[7,"机柜告警状态综合2","Unsigned int","bit0：停止电池测试","0：正常\n1：发生"]
[{"$nulls":3},"bit1：故障清除","0：正常\n1：发生"]
[{"$nulls":3},"bit2：历史记录清除","0：正常\n1：发生"]
[{"$nulls":3},"禁止开机","0：允许开机\n1：禁止开机"]
[{"$nulls":3},"手动旁路","0：主路\n1：手动旁路"]
[{"$nulls":3},"电池低压","0：电池未低压\n1：电池低压"]
[{"$nulls":3},"电池接反","0：电池未接反\n1：电池接反"]
[{"$nulls":3},"输入N线断开","0：未断开\n1：断开"]
[{"$nulls":3},"旁路风扇故障","0：正常\n1：故障"]
[{"$nulls":3},"手动均充","0：正常\n1：发生"]
[{"$nulls":3},"手动浮充","0：正常\n1：发生"]
[{"$nulls":3},"排程关机","0：正常\n1：发生"]
[{"$nulls":3},"失去N+X冗余","0：未失去\n1：失去"]
[{"$nulls":3},"EOD系统禁止","0：未禁止\n1：禁止"]
[{"$nulls":3},"并机线故障","0：正常\n1：故障"]
[{"$nulls":3},"bit15：信号线故障","0：正常\n1：故障"]
[8,"机柜告警状态综合3","Unsigned int","bit0：环境过温","0：正常\n1：故障"]
[{"$nulls":3},"bit1：整流CAN故障","0：正常\n1：故障"]
[{"$nulls":3},"IO CAN故障","0：正常\n1：故障"]
[{"$nulls":3},"DATA CAN故障","0：正常\n1：故障"]
[{"$nulls":3},"手动切逆变","0：正常\n1：发生"]
[{"$nulls":3},"进风口过温","0：正常\n1：故障"]
[{"$nulls":3},"电池运行数据清除","0：正常\n1：发生"]
[{"$nulls":3},"旁路风扇运行时间清除","0：正常\n1：发生"]
[{"$nulls":3},"电池过温","0：正常\n1：发生"]
[{"$nulls":3},"旁路风扇维护期到","0：正常\n1：发生"]
[{"$nulls":3},"防尘网维护期到","0：正常\n1：发生"]
[{"$nulls":3},"电池维护期到","0：正常\n1：发生"]
[{"$nulls":3},"BMS禁止充电","0：正常\n1：发生"]
[{"$nulls":3},"BMS禁止放电","0：正常\n1：发生"]
[{"$nulls":3},"故障录波触发","0：正常\n1：发生"]
[{"$nulls":3},"bit15：旁路风扇故障","0：正常\n1：发生"]
[9,"机柜告警状态综合4","Unsigned int","bit0：旁路保险故障","0：正常\n1：发生"]
[{"$nulls":3},"bit1：系统设置错误","0：正常\n1：发生"]
[{"$nulls":3},"bit2：旁路SCR过温","0：正常\n1：发生"]
[{"$nulls":3},"bit3：功率模块个数错误","0：正常\n1：发生"]
[{"$nulls":3},"bit4：输出电压异常","0：正常\n1：发生"]
[{"$nulls":3},"bit5：LCD通讯失败","0：正常\n1：发生"]
[{"$nulls":3},"bit6：TF卡连接失败","0：正常\n1：发生"]
[{"$nulls":3},"bit7：输入空开断开","0：正常\n1：发生"]
[{"$nulls":3},"bit8：输出空开断开","0：正常\n1：发生"]
[{"$nulls":3},"bit9：旁路空开断开","0：正常\n1：发生"]
[{"$nulls":3},"bit10：联合供电","0：未发生\n1：发生"]
[{"$nulls":3},"bit11：监控辅助电源故障","0：正常\n1：发生"]
[{"$nulls":3},"bit12：干接点电源故障","0：正常\n1：发生"]
[{"$nulls":3},"bit13-15：保留"]
[10,"整流器状态","Unsigned int",null,"0000 : 关闭"]
[{"$nulls":4},"0001 : 软启动"]
[{"$nulls":4},"0010 : 正常工作"]
[11,"逆变器状态","Unsigned int",null,"0000 : 关闭"]
[{"$nulls":4},"0001 : 软启动"]
[{"$nulls":4},"0010 : 正常工作"]
[12,"保留"]
[13,"旁路可供电状态","Unsigned int",null,"0000 : 旁路不可供电"]
[{"$nulls":4},"0001 : 旁路可供电"]
["14~20","保留"]
[21,"机柜灯状态","Unsigned int","Bit0-2：整流灯状态\nBit3-5：逆变灯状态\nBit6-8：电池灯状态\nBit9-11：旁路灯状态\nBit12-14：输出灯状态","\n灯状态值\n0：都不亮\n1：绿灯亮\n2：红灯亮"]
[{"$nulls":3},"Bit15:静音","0：正常\n1：静音"]
[22,"综合告警","Unsigned int","Bit0","1 告警，0正常"]
[{"$nulls":3},"Bit1","1 故障，0正常"]
[{"$nulls":3},"Bit2-Bit15：保留"]
[23,"模块在线标识高位","Unsigned int","Bit15：模块32\nBit14：模块31\nBit13：模块30\n...\nBit0：模块17","对应位为1表示该模块在线，为0表示离线\n"]
[24,"模块在线标识低位","Unsigned int","Bit15：模块16\nBit14：模块15\n...\nBit0：模块1","\n对应位为1表示该模块在线，为0表示离线"]
[25,"模块1灯状态","Unsigned int","Bit0-2：整流灯状态\nBit3-5：逆变灯状态\nBit6-8：电池灯状态\nBit9-15：保留","灯状态值：\n0：都不亮\n1：绿灯亮\n2：红灯亮"]
[26,"模块2灯状态","Unsigned int","Bit0-2：整流灯状态\nBit3-5：逆变灯状态\nBit6-8：电池灯状态\nBit9-15：保留","灯状态值：\n0：都不亮\n1：绿灯亮\n2：红灯亮"]
["。。。","模块n灯状态"]
[56,"模块32灯状态","Unsigned int","Bit0-2：整流灯状态\nBit3-5：逆变灯状态\nBit6-8：电池灯状态\nBit9-15：保留","灯状态值：\n0：都不亮\n1：绿灯亮\n2：红灯亮"]
["57-100","保留"]
["201-320为1-32号功率模块告警量综合，按位定义，对应位为1表示告警发生，为0表示无告警，每个模块占用4个寄存器，共128，可以用一帧查询。"]
[201,"模块1综合告警1","Unsigned int","Bit0：整流故障"]
[{"$nulls":3},"Bit1：逆变故障"]
[{"$nulls":3},"Bit2：整流器过温"]
[{"$nulls":3},"Bit3：风扇故障"]
[{"$nulls":3},"Bit4：输出过载"]
[{"$nulls":3},"Bit5：过载超时"]
[{"$nulls":3},"Bit6：逆变器过温"]
[{"$nulls":3},"Bit7：逆变保护"]
[{"$nulls":3},"Bit8：手动关机"]
[{"$nulls":3},"Bit9：电池或充电器故障"]
[{"$nulls":3},"Bit10：均流异常"]
[{"$nulls":3},"Bit11：同步信号异常"]
[{"$nulls":3},"Bit12：输入电压检测异常"]
[{"$nulls":3},"Bit13：电池电压检测异常"]
[{"$nulls":3},"Bit14：输出电压检测异常"]
[{"$nulls":3},"Bit15：旁路电压检测异常"]
[202,"模块1综合告警2","Unsigned int","Bit0：逆变开路"]
[{"$nulls":3},"Bit1：出风温度异常"]
[{"$nulls":3},"Bit2：输入不均流"]
[{"$nulls":3},"Bit3：母线过压"]
[{"$nulls":3},"Bit4：整流软启动失败"]
[{"$nulls":3},"Bit5：逆变继电器开路"]
[{"$nulls":3},"Bit6：逆变开关短路"]
[{"$nulls":3},"Bit7：PWM跟踪信号异常"]
[{"$nulls":3},"Bit8：智能休眠"]
[{"$nulls":3},"Bit9：输入限流时间到"]
[{"$nulls":3},"Bit10：进风口探头异常"]
[{"$nulls":3},"Bit11：出风口探头异常"]
[{"$nulls":3},"Bit12：电容维护期到"]
[{"$nulls":3},"Bit13：风扇维护期到"]
[{"$nulls":3},"Bit14：对接端子连接故障"]
[{"$nulls":3},"Bit15：软件版本错误"]
[203,"模块1综合告警3","Unsigned int","Bit0：模块ID重复"]
[{"$nulls":3},"Bit1：输入SCR温度探头异常"]
[{"$nulls":3},"Bit2：输入SCR过温"]
[{"$nulls":3},"Bit3：额定容量设置超范围"]
[{"$nulls":3},"Bit4：母线低压"]
[{"$nulls":3},"Bit5：放电不均流"]
[{"$nulls":3},"Bit6：逆变电压检测异常"]
[{"$nulls":3},"Bit7: 模块退出"]
[{"$nulls":3},"Bit8- Bit15：保留"]
[204,"模块1综合告警4","Unsigned int","Reserved"]
["205-208","模块2综合告警1-4","Unsigned int","参照201-204"]
["209-212","模块3综合告警1-4","Unsigned int","参照201-204"]
["213-216","模块4综合告警","Unsigned int","参照201-204"]
["217-220","模块5综合告警","Unsigned int","参照201-204"]
["221-224","模块6综合告警","Unsigned int","参照201-204"]
["225-228","模块7综合告警","Unsigned int","参照201-204"]
["229-232","模块8综合告警","Unsigned int","参照201-204"]
["233-236","模块9综合告警","Unsigned int","参照201-204"]
["237-240","模块10综合告警","Unsigned int","参照201-204"]
["241-244","模块11综合告警","Unsigned int","参照201-204"]
["245-248","模块12综合告警","Unsigned int","参照201-204"]
["249-252","模块13综合告警","Unsigned int","参照201-204"]
["253-256","模块14综合告警","Unsigned int","参照201-204"]
["257-260","模块15综合告警","Unsigned int","参照201-204"]

{"sheet":"遥测量(功能码04)","index":3,"n_rows":102,"n_cols":7,"rows_kept":102}
["寄存器序号","名称","单位","数据类型","系数","位定义功能","选项"]
[20001,"交流旁路电压ph_A","伏特V","Unsigned int",0.1]
[20002,"交流旁路电压ph_B","伏特V","Unsigned int",0.1]
[20003,"交流旁路电压ph_C","伏特V","Unsigned int",0.1]
[20004,"交流旁路电流ph_A","安培A","Unsigned int",0.1]
[20005,"交流旁路电流ph_B","安培A","Unsigned int",0.1]
[20006,"交流旁路电流ph_C","安培A","Unsigned int",0.1]
[20007,"交流旁路频率ph_A","赫兹Hz","Unsigned int",0.01]
[20008,"交流旁路频率ph_B","赫兹Hz","Unsigned int",0.01]
[20009,"交流旁路频率ph_C","赫兹Hz","Unsigned int",0.01]
[20010,"交流旁路PF_A",null,"Unsigned int",0.01]
[20011,"交流旁路PF_B",null,"Unsigned int",0.01]
[20012,"交流旁路PF_C",null,"Unsigned int",0.01]
[20013,"交流输入电压ph_A","伏特V","Unsigned int",0.1]
[20014,"交流输入电压ph_B","伏特V","Unsigned int",0.1]
[20015,"交流输入电压ph_C","伏特V","Unsigned int",0.1]
[20016,"交流输入电流ph_A","安培A","Unsigned int",0.1]
[20017,"交流输入电流ph_B","安培A","Unsigned int",0.1]
[20018,"交流输入电流ph_C","安培A","Unsigned int",0.1]
[20019,"交流输入频率ph_A","赫兹Hz","Unsigned int",0.01]
[20020,"交流输入频率ph_B","赫兹Hz","Unsigned int",0.01]
[20021,"交流输入频率ph_C","赫兹Hz","Unsigned int",0.01]
[20022,"交流输入PF_A",null,"Unsigned int",0.01]
[20023,"交流输入PF_B",null,"Unsigned int",0.01]
[20024,"交流输入PF_C",null,"Unsigned int",0.01]
[20025,"交流输出电压ph_A","伏特V","Unsigned int",0.1]
[20026,"交流输出电压ph_B","伏特V","Unsigned int",0.1]
[20027,"交流输出电压ph_C","伏特V","Unsigned int",0.1]
[20028,"交流输出电流ph_A","安培A","Unsigned int",0.1]
[20029,"交流输出电流ph_B","安培A","Unsigned int",0.1]
[20030,"交流输出电流ph_C","安培A","Unsigned int",0.1]
[20031,"交流输出频率ph_A","赫兹Hz","Unsigned int",0.01]
[20032,"交流输出频率ph_B","赫兹Hz","Unsigned int",0.01]
[20033,"交流输出频率ph_C","赫兹Hz","Unsigned int",0.01]
[20034,"交流输出PF_A",null,"Unsigned int",0.01]
[20035,"交流输出PF_B",null,"Unsigned int",0.01]
[20036,"交流输出PF_C",null,"Unsigned int",0.01]
[20037,"输出视在功率ph_A","kVA/VA","Unsigned int","0.1/1"]
[20038,"输出视在功率ph_B","kVA","Unsigned int",0.1]
[20039,"输出视在功率ph_C","kVA","Unsigned int",0.1]
[20040,"输出有功功率ph_A","kW/W","Unsigned int","0.1/1"]
[20041,"输出有功功率ph_B","kW","Unsigned int",0.1]
[20042,"输出有功功率ph_C","kW","Unsigned int",0.1]
[20043,"输出无功功率ph_A","kVar/Var","Unsigned int","0.1/1"]
[20044,"输出无功功率ph_B","kVar","Unsigned int",0.1]
[20045,"输出无功功率ph_C","kVar","Unsigned int",0.1]
[20046,"负载百分数ph_A","百分数%","Unsigned int",0.1]
[20047,"负载百分数ph_B","百分数%","Unsigned int",0.1]
[20048,"负载百分数ph_C","百分数%","Unsigned int",0.1]
[20049,"环境温度","摄氏度℃","Unsigned int",0.1]
[20050,"正电池组电压","伏特V","Unsigned int",0.1]
[20051,"负电池组电压","伏特V","Unsigned int",0.1]
[20052,"正电池组电流","安培A","int",0.1]
[20053,"负电池组电流","安培A","int",0.1]
[20054,"电池温度","摄氏度℃","Unsigned int",0.1]
[20055,"电池剩余时间","分钟min","Unsigned int",0.1]
[20056,"电池容量","百分数%","Unsigned int",0.1]
[20057,"交流旁路线电压ph_A","伏特V","Unsigned int",0.1]
[20058,"交流旁路线电压ph_B","伏特V","Unsigned int",0.1]
[20059,"交流旁路线电压ph_C","伏特V","Unsigned int",0.1]
[20060,"交流主路线电压ph_A","伏特V","Unsigned int",0.1]
[20061,"交流主路线电压ph_B","伏特V","Unsigned int",0.1]
[20062,"交流主路线电压ph_C","伏特V","Unsigned int",0.1]
[20063,"交流输出线电压ph_A","伏特V","Unsigned int",0.1]
[20064,"交流输出线电压ph_B","伏特V","Unsigned int",0.1]
[20065,"交流输出线电压ph_C","伏特V","Unsigned int",0.1]
[20066,"旁路SCR温度1","摄氏度℃","Unsigned int",0.1]
[20067,"旁路SCR温度2","摄氏度℃","Unsigned int",0.1]
[20068,"旁路风扇运行时间","小时","Unsigned int",1]
[20069,"防尘网已使用天数","天","Unsigned int",1]
[20070,"电池总运行时间","天","Unsigned int",0.1]
[20071,"电池总放电时间","小时","Unsigned int",0.1]
[20072,"电池连续未放电时间","天","Unsigned int",1]
[20073,"电池放电次数","次","Unsigned int",1]
[20074,"保留"]
[20075,"保留"]
[20076,"保留"]
[20077,"保留"]
[20078,"保留"]
[20079,"保留"]
[20080,"保留"]
[20081,"软件系列号",null,"Unsigned int",1]
[20082,"软件大版本号",null,"Unsigned int",1]
[20083,"软件小版本号",null,"Unsigned int",1]
[20084,"UPS机型",null,"Unsigned int",1,"Bit0-Bit5：表示UPS机型\nBit6-Bit15:Reserved","1:ACM(10-600KVA)\n2:TT(10-40 KVA)\n3:SS(6-20 KVA)\n4:SS(1-3 KVA)"]
[20085,"UPS 类型",null,"Unsigned int",1,"Bit0-Bit2：表示输入输出相数\nBit3-Bit15:Reserved","1: 3in-3out\n2: 3in -1out\n3: 1in -1out\n4: 1in -3out\n5: 2in -2out"]
[20086,"保留"]
[20087,"保留"]
[20088,"保留"]
[20089,"保留"]
[20090,"保留"]
[20091,"保留"]
[20092,"保留"]
[20093,"保留"]
[20094,"保留"]
[20095,"保留"]
[20096,"额定输入电压","伏特V","Unsigned int",1]
[20097,"额定输入频率","赫兹Hz","Unsigned int",1]
[20098,"额定输出电压","伏特V","Unsigned int",1]
[20099,"额定输出频率","赫兹Hz","Unsigned int",1]
[20100,"机柜额定使用功率","kW","Unsigned int",0.1]
[20101,"模块额定使用功率","kW","Unsigned int",0.1]