{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["堆垛机","输送线"],"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":"堆垛机","index":0,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[15,0,15,3],[0,0,0,3]]}
["堆垛机PLC上报给WCS"]
["变量编码","变量名称","数据类型","数据描述"]
["To_wcs_Heartbeat","心跳","BOOL","间隔时间1秒。(0、1交替循环发送)"]
["SRM_Mode","工作模式","INT","0-维修；1-手动；2-单机自动；3-联机自动；4-不明。"]
[" SRM_Status","作业状态","INT","0-待机；1-运行中；2-故障；3-取货完成；4-放货完成；"]
["To_Wcs_Task_Num ","任务号","DINT","任务做完后到接收下一个任务，任务号保留不变，即使切换到维修、手动或单机自动，也不改变。\n32位Dint。手动任务号暂时不要。"]
["To_Wcs_fault ","故障报警","BYTE","0-无故障；1-货物超限；2-作业条件不满足；3-与输送线通讯故障；4-传送地址错；5-指定库位满入；6-空出；7-行走变频器报警；8-升降变频器报警；9-货叉变频器报警；10-行走超时；11-升降超时；12-货叉超时；13-水平测距出错；14-垂直测距出错；15-放货异常；16-浅货位有货；17-货叉数据出错； ",null,"后续报警码拆分，应对上报多个错误码的要求"]
["To_wcs_real_pai","作业排","INT","WCS下发的当前执行电报中的排号值。保留和触摸屏上显示的值一致即可。"]
["To_wcs_real_lie","行走位置","INT","当前堆垛机所处的列位置。"]
["To_wcs_real_ceng","载货台位置","INT","当前堆垛机载货台所处的层位置。"]
["TO_WCS_havegoods","载货台有货","BOOL","载货台有货"]
["TO_WCS_zero","原点信号","BOOL","货叉在原点"]
["TO_WCS_left_Scan","左探有货","BOOL","左探有货"]
["TO_WCS_right_Scan","右探有货","BOOL","右探有货"]
[]
["WCS下发给堆垛机PLC"]
["变量编码","变量名称","数据类型","数据描述"]
[" wcs_Heartbeat","心跳","bool","间隔时间1秒(0、1交替循环发送)"]
["WCS_WorkCmd ","作业指令","BYTE","\n1-取放货（空载行走到指定位置并伸叉取货，带货行走到指定位置并伸叉放货）；\n2-确认收到取放货任务完成；\n3-解警；\n4-急停；\n5-回原点；"]
["SRM_Task_Num","任务号","DINT","正常任务号1-60000循环；60001-65535约定为手动任务号\n32位Dint。手动任务号暂时不要。"]
["WCS_Auto_Fork_From_Row","起始作业地址排","INT","起始作业排"]
["WCS_Auto_Walk_From_Column","起始作业地址列","INT","起始作业列"]
[" WCS_Auto_Lift_From_Floor","起始作业地址层","INT","起始作业层"]
[" WCS_Auto_Fork_To_Row","终点作业地址排","INT","终点作业排（取放货指令时使用）"]
["WCS_Auto_Walk_To_Column ","终点作业地址列","INT","终点作业列（取放货指令时使用）"]
["WCS_Auto_Lift_To_Floor","终点作业地址层","INT","终点作业层（取放货指令时使用）"]

{"sheet":"输送线","index":1,"n_rows":62,"n_cols":6,"rows_kept":62,"cut":false,"hidden":false,"merged":[[47,0,61,0],[33,0,46,0],[1,1,1,4],[15,1,15,4],[7,0,10,0],[11,0,13,0],[4,0,6,0],[18,0,32,0]]}
[]
[null,"WCS下发给输送线PLC"]
["设备名称","变量编码","变量名称","数据类型","数据描述"]
[null,"WCS_HeartBeat","心跳","bool","1-255循环下发。间隔时间1秒 (0、1交替循环发送)"]
["L1","Equipment_pctols[1].TaskType","作业指令","INT","1-执行任务;2-条码出错退回"]
[null,"Equipment_pctols[1].EndADD","目标地址","INT","目标站台号。\n（尽量使用电气命名的站台号，方便双方调试）"]
[null,"Equipment_pctols[1].TaskNumber","任务号","DINT","任务号"]
["…"]
[]
[]
[]
["L11","Equipment_pctols[11].TaskType","作业指令","INT","1-执行任务;2-条码出错退回"]
[null,"Equipment_pctols[11].EndADD","目标地址","INT","目标站台号。\n（尽量使用电气命名的站台号，方便双方调试）"]
[null,"Equipment_pctols[11].TaskNumber","任务号","DINT","任务号"]
[]
[null,"输送线PLC上报给WCS"]
["设备名称","变量编码","变量名称","数据类型","数据描述"]
[null,"xintiao","心跳","bool","间隔时间1秒 (0、1交替循环发送)"]
["L1","ToPCEquipment[1].MODE","工作状态","BYTE","0-脱机待机；1-脱机执行任务；2-联机待机；3-联机执行任务。"]
[null,"ToPCEquipment[1].ForStop",null,"BOOL","前端有货。\n按照前后端光电组合信号判断是否有货。"]
[null,"ToPCEquipment[1].ForChange",null,"BOOL","前端换速"]
[null,"ToPCEquipment[1].BackChange",null,"BOOL","后端换速"]
[null,"ToPCEquipment[1].BackStop",null,"BOOL","后端有货。\n按照前后端光电组合信号判断是否有货。"]
[null,"ToPCEquipment[1].DownStop",null,"BOOL","低位停准。暂时不使用。"]
[null,"ToPCEquipment[1].UpStop",null,"BOOL","高位停准。暂时不使用。"]
[null,"ToPCEquipment[1].RKQR",null,"BOOL","入库确认"]
[null,"ToPCEquipment[1].highover",null,"BOOL","超高"]
[null,"ToPCEquipment[1].weightover",null,"BOOL","超重。暂时不使用。"]
[null,"ToPCEquipment[1].spare3",null,"BOOL","未定义"]
[null,"ToPCEquipment[1].AlarmStatus",null,"BYTE","0-无报警；1-链条（辊道）运行超时;2-升降超时;3-链条（辊道）变频器报警;4-升降变频器报警;5-左端超限；6-右端超限；7-超高1；8-超宽2；9-超重3；10-未停准；11-前超限；12-后超限；13-光电开关异常；14-超重,15-超长，16-急停。"]
[null,"ToPCEquipment[1].TaskNumber",null,"DINT","任务号"]
[null,"ToPCEquipment[1].TargetLocNo",null,"DINT","目标站台号（起点到终点都需要跟踪）","新增"]
[null,"ToPCEquipment[1].PalletCode",null,"STRING","托盘号（只有在扫码点使用，其它点可以不跟踪）","新增"]
["…"]
{"$rows_empty":13}
["L11","ToPCEquipment[11].MODE","工作状态","BYTE","0-脱机待机；1-脱机执行任务；2-联机待机；3-联机执行任务。"]
[null,"ToPCEquipment[11].ForStop",null,"BOOL","前端有货"]
[null,"ToPCEquipment[11].ForChange",null,"BOOL","前端换速"]
[null,"ToPCEquipment[11].BackChange",null,"BOOL","后端换速"]
[null,"ToPCEquipment[11].BackStop",null,"BOOL","后端有货"]
[null,"ToPCEquipment[11].DownStop",null,"BOOL","低位停准"]
[null,"ToPCEquipment[11].UpStop",null,"BOOL","高位停准"]
[null,"ToPCEquipment[11].RKQR",null,"BOOL","入库确认"]
[null,"ToPCEquipment[1].highover",null,"BOOL","超高"]
[null,"ToPCEquipment[1].weightover",null,"BOOL","超重"]
[null,"ToPCEquipment[11].spare3",null,"BOOL","未定义"]
[null,"ToPCEquipment[11].AlarmStatus",null,"BYTE","0-无报警；1-链条（辊道）运行超时;2-升降超时;3-链条（辊道）变频器报警;4-升降变频器报警;5-左端超限；6-右端超限；7-超高1；8-超高2；9-超高3；10-未停准；11-前超限；12-后超限；13-光电开关异常；14-超重,15-超长，16-急停。"]
[null,"ToPCEquipment[11].TaskNumber",null,"DINT","任务号"]
[null,"ToPCEquipment[1].TargetLocNo",null,"DINT","目标站台号"]
[null,"ToPCEquipment[1].PalletCode",null,"STRING","托盘号"]