{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["PLC协议","PLC数据结构"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"PLC协议","index":0,"n_rows":91,"n_cols":10,"rows_kept":91,"merged":[[0,0,0,6],[3,6,14,6],[18,6,29,6],[33,2,50,2],[33,6,50,6],[54,6,65,6],[79,6,90,6]],"flags":["formulas_cached_only"]}
["天通凯立项目输送线与WCS通讯协议(Ethernet/IP)"]
[{"$nulls":5},"注：黄色区域由WCS写入，白色区域WCS只读"]
["信息","PLC地址","业务ITEM_NO","业务ITEM_GRP","数据格式","备注","对应输送机"]
["请求条码",null,null,"WCS_LPN","DINT（双整数）","0：默认","B21\nC5"]
["去向",null,null,"WCS_TO","DINT（双整数）","0：默认，1：C7（成品1#巷道），2：B1（原料2#巷道）"]
["备用",{"$nulls":3},"DINT（双整数）"]
["到位条码",null,null,"PLC_LPN","STRING","默认为0，空托盘为1，必须等事件报告清0后再清0"]
["去向",null,null,"PLC_TO","DINT（双整数）","必须等事件报告清0后再清0"]
["事件报告",null,null,"EVENT","DINT（双整数）","0：无托盘，1：到达位置申请分配巷道，2：托盘输送中（WCS条码和去向都清0时再清0）"]
["托盘类型",null,null,"PLC_TYPE","DINT（双整数）","0：无托盘，1：空托盘，2：实物（原料和成品能区分的话更好）"]
["托盘层数",null,null,"PLC_LAYER","DINT（双整数）","默认为0，实物为1，空托盘垛按照实际数量给"]
["故障",null,null,"ERR","DINT（双整数）","0：无故障，1：有故障"]
["工作模式",null,null,"WORK_MODE","DINT（双整数）","0：手动，1：联机自动"]
["工作状态",null,null,"TASK_ST","DINT（双整数）","0：无任务 1：任务中"]
["备用",{"$nulls":3},"DINT（双整数）"]
[]
[]
["信息","PLC地址","业务ITEM_NO","业务ITEM_GRP","数据格式","备注","对应输送机"]
["请求条码",null,null,"WCS_LPN","DINT（双整数）","0：默认","D28\n"]
["去向",null,null,"WCS_TO","DINT（双整数）","0：默认，1：D1（成品1#巷道），2：D3（原料2#巷道）"]
["备用",{"$nulls":3},"DINT（双整数）"]
["到位条码",null,null,"PLC_LPN","STRING","默认为0，空托盘为1，必须等事件报告清0后再清0"]
["去向",null,null,"PLC_TO","DINT（双整数）","必须等事件报告清0后再清0"]
["事件报告",null,null,"PLC_EVENT","DINT（双整数）","0：无托盘，1：到达位置申请分配巷道，2：托盘输送中（WCS条码和去向都清0时再清0）"]
["托盘类型",null,null,"PLC_TYPE","DINT（双整数）","0：无托盘，1：空托盘，2：实物（原料和成品能区分的话更好）"]
["托盘层数",null,null,"PLC_LAYER","DINT（双整数）","默认为0，实物为1，空托盘垛按照实际数量给"]
["故障",null,null,"ERR","DINT（双整数）","0：无故障，1：有故障"]
["工作模式",null,null,"WORK_MODE","DINT（双整数）","0：手动，1：联机自动"]
["工作状态",null,null,"TASK_ST","DINT（双整数）","0：无任务 1：任务中"]
["备用",{"$nulls":3},"DINT（双整数）"]
[]
["注：所有点按照下边这个结构来，不需要交互的点直接置0即可，数据类型用sint，标签序号参照右侧对应表"]
["信息","PLC地址","区域","标签","数据格式","备注","对应输送机"]
["请求条码",null,"LIKU_A\n","A01_WCS_LPN","STRING","0：默认，空托盘为1","C7\nB1\nD1\nD3\nA21\nA22"]
["去向",null,null,"A01_WCS_TO","SINT"]
["堆垛机放下",null,null,"A01_WCS_PUT","SINT"]
["堆垛机取走",null,null,"A01_WCS_TAKE","SINT","0：默认，1：已取走"]
["托盘类型",null,null,"A01_WCS_TYPE","SINT"]
["托盘层数",null,null,"A01_WCS_LAYER","SINT"]
["备用",null,null,"A01_BAK","SINT"]
["到位条码",null,null,"A01_PLC_LPN","STRING","默认为0，空托盘为1，必须等事件报告清0后再清0"]
["去向",null,null,"A01_PLC_TO","SINT"]
["堆垛机放下",null,null,"A01_PLC_PUT","SINT"]
["堆垛机取走（）",null,null,"A01_PLC_TAKE","SINT","0：默认，1：已取走（必须等事件报告清0后再清0）",null,null,1]
["事件报告",null,null,"A01_PLC_EVENT","SINT"," ",{"$nulls":3},1]
["托盘类型",null,null,"A01_PLC_TYPE","SINT","0：无托盘，1：空托盘，2：实物（原料和成品能区分的话更好）"]
["托盘层数",null,null,"A01_PLC_LAYER","SINT","默认为0，实物为1，空托盘垛按照实际数量给"]
["故障",null,null,"A01_ERR","SINT","0：无故障，1：有故障"]
["工作模式",null,null,"A01_WORK_MODE","SINT","0：手动，1：联机自动",{"$nulls":3},24]
["工作状态",null,null,"A01_TASK_ST","SINT","0：无任务 1：任务中",{"$nulls":3},1]
["备用",null,null,"WCS_BAK","SINT"]
[]
[]
["信息","PLC地址","业务ITEM_NO","业务ITEM_GRP","数据格式","备注","对应输送机"]
["请求条码",null,null,"WCS_LPN","DINT（双整数）","0：默认，空托盘为1","D2\nD4\nC3\nB2\nA1\n",null,null,16]
["堆垛机放下",null,null,"WCS_PUT","DINT（双整数）","0：默认，1：已放下"]
["托盘类型","取货点",null,"WCS_TYPE","DINT（双整数）","0：默认，1：空托盘，2：实物"]
["托盘层数","去向",null,"WCS_LAYER","DINT（双整数）","默认为0，实物为1，空托盘垛按照实际数量给"]
["备用",null,null,"WCS_BAK","DINT（双整数）","清除叫料信号"]
["到位条码",null,null,"PLC_LPN","STRING","默认为0，空托盘为1"]
["堆垛机放下(判断出库口是否有空托)",null,null,"PLC_PUT","DINT（双整数）","0：默认，1：已放下"]
["事件报告",null,null,"PLC_EVENT","DINT（双整数）","0：无托盘，1：有托盘"]
["故障",null,null,"ERR","DINT（双整数）","0：无故障，1：有故障"]
["工作模式",null,null,"WORK_MODE","DINT（双整数）","0：手动，1：联机自动"]
["工作状态",null,null,"TASK_ST","DINT（双整数）","0：无任务 1：任务中"]
["备用",null,null,"PLC_BAK","DINT（双整数）","数量"]
["通讯协议：Ethernet/IP"]
[]
[]
[{"$nulls":8},"D2",1]
[]
[{"$nulls":8},"D4",2]
[]
[]
[{"$nulls":4},2]
[]
[]
[]
[]
["请求条码",null,null,"WCS_LPN","DINT（双整数）","0：默认，空托盘为1","D2\nD4\n\n"]
["堆垛机放下",null,null,"WCS_PUT","DINT（双整数）","0：默认，1：已放下"]
["托盘类型",null,null,"WCS_TYPE","DINT（双整数）","0：默认，1：空托盘，2：实物"]
["托盘层数",null,null,"WCS_LAYER","DINT（双整数）","默认为0，实物为1，空托盘垛按照实际数量给"]
["备用(接收到信号，进行清除)",null,null,"WCS_BAK","DINT（双整数）","清除叫料信号"]
["到位条码",null,null,"PLC_LPN","STRING","默认为0，空托盘为1"]
["堆垛机放下(判断出库口是否有空托)",null,null,"PLC_PUT","DINT（双整数）","0：默认，1：已放下"]
["事件报告",null,null,"PLC_EVENT","DINT（双整数）","1:申请，0默认"]
["故障",null,null,"ERR","DINT（双整数）","0：无故障，1：有故障"]
["工作模式",null,null,"WORK_MODE","DINT（双整数）","0：手动，1：联机自动"]
["工作状态",null,null,"TASK_ST","DINT（双整数）","0：无任务 1：任务中"]
["备用",null,null,"PLC_BAK","DINT（双整数）","数量"]

{"sheet":"PLC数据结构","index":1,"n_rows":50,"n_cols":8,"rows_kept":50,"merged":[[2,2,19,2],[2,6,19,6]],"flags":["formulas_cached_only"]}
["注：所有点按照下边这个结构来，不需要交互的点直接置0即可，数据类型用sint，标签序号参照右侧对应表"]
["信息","PLC地址","区域","标签","数据格式","备注","对应输送机"]
["请求条码",null,"LIKU_A\n","A01_WCS_LPN","STRING","0：默认，空托盘为1","C7\nB1\nD1\nD3\nA21\nA22"]
["去向",null,null,"A01_WCS_TO","SINT",null,null,"通道号"]
["堆垛机放下",null,null,"A01_WCS_PUT","SINT"]
["堆垛机取走",null,null,"A01_WCS_TAKE","SINT","0：默认，1：已取走"]
["托盘类型",null,null,"A01_WCS_TYPE","SINT"]
["托盘层数",null,null,"A01_WCS_LAYER","SINT"]
["备用",null,null,"A01_BAK","SINT"]
["到位条码",null,null,"A01_PLC_LPN","STRING","默认为0，空托盘为1，必须等事件报告清0后再清0"]
["去向",null,null,"A01_PLC_TO","SINT"]
["堆垛机放下",null,null,"A01_PLC_PUT","SINT"]
["堆垛机取走",null,null,"A01_PLC_TAKE","SINT","0：默认，1：已取走（必须等事件报告清0后再清0）"]
["事件报告",null,null,"A01_PLC_EVENT","SINT","0：无托盘，1：到达位置申请堆垛机叉取入库，2：托盘输送中（WCS条码和堆垛机取走信号都清0时再清0）"]
["托盘类型",null,null,"A01_PLC_TYPE","SINT","0：无托盘，1：空托盘，2：实物（原料和成品能区分的话更好）"]
["托盘层数",null,null,"A01_PLC_LAYER","SINT","默认为0，实物为1，空托盘垛按照实际数量给"]
["故障",null,null,"A01_ERR","SINT","0：无故障，1：有故障"]
["工作模式",null,null,"A01_WORK_MODE","SINT","0：手动，1：联机自动"]
["工作状态",null,null,"A01_TASK_ST","SINT","0：无任务 1：任务中"]
["备用",null,null,"A01_PLC_BAK","SINT"]
[]
["标签前缀","实际输送机",{"$nulls":3},"原料入库PLC:10.50.11.18",1,"一楼"]
["A01","A1","原材料出库",null,"交互IP地址：","成品出库PLC:10.50.11.19",2,"U型弯"]
["A02","A21","空托入库",null,null,"原料出库PLC:10.50.11.17",5,"顶楼"]
["A03","A22","成品入库"]
["B01","B1","原料入库立库端"]
["B02","B2","空盘出库"]
["B03","B21","原料入库请求"]
["C01","C3","空盘出库","   "]
["C02","C5","成品入库请求","原料入库PLC:10.50.11.18","原料入库PLC:10.50.11.18","原料入库PLC:10.50.11.18"]
["C03","C7","成品入库","  "]
["D01","D1"]
["D02","D2"]
["D03","D3"]
["D04","D4"]
["D05","D28",{"$nulls":3},"举例读写："]
[{"$nulls":5},"读：  PCS_WCS_B._01_PLC_EVENT"]
["区域","实际输送机"]
["A","A开头",{"$nulls":3},"写：  WCS_PLC_B._01_WCS_LPN"]
["B","B开头"]
["C","C开头"]
["D","D开头"]
[]
[]
[]
[]
["成品库1楼出入库",null,"C3  空托出库","C7   成品入库"]
[]
[]
["原材料1楼出库库",null,"A1","B2  空托出库"]