{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["线路配置","PLC行为码","任务匹配","任务依赖","表格显示","区域配置","任务状态","Tibco配置"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":54,"n_cols":21,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["库位号","仓库号","区域","库位组名称","活动站点","关联点1","关联点2","关联点3","行","列","源仓库","目标仓库","续接取货仓库","续接取货物料","续接放货仓库","判断续接任务","IP地址(PLC)","通讯协议(PLC)","独立通讯(PLC)","心跳信号(PLC)","心跳信号(AGV)"]
["翻包01","翻包区",null,null,29,19]
["翻包02","翻包区",null,null,30,20]
["翻包03","翻包区",null,null,31,21]
["翻包04","翻包区",null,null,32,22]
["翻包05","翻包区",null,null,33,23]
["翻包06","翻包区",null,null,24,19]
["翻包07","翻包区",null,null,25,20]
["翻包08","翻包区",null,null,26,21]
["翻包09","翻包区",null,null,27,22]
["翻包10","翻包区",null,null,28,23]
["翻包11","翻包区",null,null,14,4]
["翻包12","翻包区",null,null,15,5]
["翻包13","翻包区",null,null,16,6]
["翻包14","翻包区",null,null,17,7]
["翻包15","翻包区",null,null,18,8]
["翻包16","翻包区",null,null,9,4]
["翻包17","翻包区",null,null,10,5]
["翻包18","翻包区",null,null,11,6]
["翻包19","翻包区",null,null,12,7]
["翻包20","翻包区",null,null,13,8]
["翻包21","参观翻包",null,null,47,42]
["翻包22","参观翻包",null,null,48,43]
["翻包23","参观翻包",null,null,49,44]
["翻包24","参观翻包",null,null,50,45]
["翻包25","参观翻包",null,null,51,46]
["仓库01","仓库",null,null,34,38]
["仓库02","仓库",null,null,35,39]
["仓库03","仓库",null,null,36,40]
["仓库04","仓库",null,null,37,41]
["货架等待01","货架等待",null,null,2,2,{"$nulls":5},"货架A;货架B;翻包区;参观翻包",null,null,null,true]
["货架等待02","货架等待",null,null,1,1,{"$nulls":5},"货架A;货架B;翻包区;参观翻包",null,null,null,true]
["A01","货架A",null,null,52,52,{"$nulls":5},"货架A;翻包区;参观翻包",null,"满料车",null,true]
["A02","货架A",null,null,53,53,{"$nulls":5},"货架A;翻包区;参观翻包",null,"满料车",null,true]
["A03","货架A",null,null,54,54,{"$nulls":5},"货架A;翻包区;参观翻包",null,"满料车",null,true]
["A04","货架A",null,null,55,55,{"$nulls":5},"货架A;翻包区;参观翻包",null,"满料车",null,true]
["A05","货架A",null,null,56,56,{"$nulls":5},"货架A;翻包区;参观翻包",null,"满料车",null,true]
["A06","货架A",null,null,57,57,{"$nulls":5},"货架A;翻包区;参观翻包",null,"满料车",null,true]
["A07","货架A",null,null,58,58,{"$nulls":5},"货架A;翻包区;参观翻包",null,"满料车",null,true]
["A08","货架A",null,null,59,59,{"$nulls":5},"货架A;翻包区;参观翻包",null,"满料车",null,true]
["A09","货架A",null,null,60,60,{"$nulls":5},"货架A;翻包区;参观翻包",null,"满料车",null,true]
["A10","货架A",null,null,61,61,{"$nulls":5},"货架A;翻包区;参观翻包",null,"满料车",null,true]
["A11","货架A",null,null,62,62,{"$nulls":5},"货架A;翻包区;参观翻包",null,"满料车",null,true]
["B01","货架B",null,null,63,63,{"$nulls":5},"货架B;翻包区;参观翻包",null,"满料车",null,true]
["B02","货架B",null,null,64,64,{"$nulls":5},"货架B;翻包区;参观翻包",null,"满料车",null,true]
["B03","货架B",null,null,65,65,{"$nulls":5},"货架B;翻包区;参观翻包",null,"满料车",null,true]
["B04","货架B",null,null,66,66,{"$nulls":5},"货架B;翻包区;参观翻包",null,"满料车",null,true]
["B05","货架B",null,null,67,67,{"$nulls":5},"货架B;翻包区;参观翻包",null,"满料车",null,true]
["B06","货架B",null,null,68,68,{"$nulls":5},"货架B;翻包区;参观翻包",null,"满料车",null,true]
["B07","货架B",null,null,69,69,{"$nulls":5},"货架B;翻包区;参观翻包",null,"满料车",null,true]
["B08","货架B",null,null,70,70,{"$nulls":5},"货架B;翻包区;参观翻包",null,"满料车",null,true]
["B09","货架B",null,null,71,71,{"$nulls":5},"货架B;翻包区;参观翻包",null,"满料车",null,true]
["B10","货架B",null,null,72,72,{"$nulls":5},"货架B;翻包区;参观翻包",null,"满料车",null,true]
["B11","货架B",null,null,73,73,{"$nulls":5},"货架B;翻包区;参观翻包",null,"满料车",null,true]

{"sheet":"PLC行为码","index":1,"n_rows":1,"n_cols":14,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["行为码","DB地址写入","DB地址读取","DB地址最终写入","写入值","读取值","最终写入值","数据类型","IO透传","备注","模拟","异步执行类","异步执行步骤数","自定义执行类"]

{"sheet":"任务匹配","index":2,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["取货仓库","取货仓位","放货仓库","放货仓位","任务模板","指定小车","小车类型","优先级"]
["翻包区",null,"货架等待",null,"仓库-等待"]
["翻包区",null,"仓库",null,"翻包-仓库"]
["参观翻包",null,"货架等待",null,"仓库-等待"]
["仓库",null,"货架等待",null,"仓库-等待"]
["参观翻包",null,"仓库",null,"翻包-仓库"]
["货架A",null,"翻包区",null,"货架-翻包"]
["货架B",null,"翻包区",null,"货架-翻包"]
["货架A",null,"参观翻包",null,"货架-翻包"]
["货架B",null,"参观翻包",null,"货架-翻包"]
["货架等待",null,"货架A",null,"等待-货架"]
["货架等待",null,"货架B",null,"等待-货架"]

{"sheet":"任务依赖","index":3,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["新任务开始仓库","旧任务结束仓库"]

{"sheet":"表格显示","index":4,"n_rows":157,"n_cols":4,"rows_kept":157,"cut":false,"hidden":true,"merged":[]}
["Name","HeaderText","Format","Visible"]
["SystemErrorCode","系统错误码",null,false]
["SystemErrorMessage","系统错误消息",null,false]
["UserErrorCode","用户错误码",null,false]
["UserErrorMessage","用户错误消息",null,false]
["CreateTime","创建时间",null,true]
["StartTime","开始时间",null,true]
["ActualEndTime","结束时间",null,true]
["ExpectedEndTime","预计完成时间",null,false]
["CanCancel","可以取消",null,false]
["EarliestStartTime","最早开始时间",null,false]
["BindingAGVNumber","绑定AGV编号",null,true]
["reserved1","备用1",null,false]
["reserved2","备用2",null,false]
["reserved3","备用3",null,false]
["reserved4","备用4",null,false]
["reserved5","备用5",null,false]
["reserved6","备用6",null,false]
["reserved7","备用7",null,false]
["LatestCompletionTime","最后完成时间",null,false]
["CancelRequest","取消请求",null,false]
["Pausing","暂停中",null,false]
["Priority","优先级",null,true]
["ID","GUID",null,false]
["TaskID","任务号",null,true]
["ParentTaskID","父任务号",null,true]
["OrderID","订单号",null,false]
["Name","名称",null,false]
["TaskState","任务状态",null,true]
["TaskBook","任务模板",null,true]
["AllWarehouse","任务点",null,true]
["CurrentStepID","当前步骤号",null,true]
["IsException","是否异常",null,false]
["IsLastOrder","是否最后订单",null,false]
["DepenciesTaskIDEnd","任务依赖结束",null,false]
["DepenciesTaskIDStart","任务依赖开始",null,false]
["Carrier","小车",null,true]
["CarrierType","小车类型",null,true]
["Token","令牌",null,false]
["HasCarrier","有车",null,false]
["IsCarrierLoading","小车加载中",null,false]
["CarrierState","小车状态",null,false]
["reserved8","备用8",null,false]
["reserved9","备用9",null,false]
["ExpectedEndTime","预计结束时间",null,false]
["SendSignalSuccess","发信号成功",null,false]
["SendSignalFailTimes","发信号失败次数",null,false]
["LastSendSignalTime","上次发信号时间",null,false]
["ErrorCode","错误码",null,false]
["StepCanRun","步骤可以执行",null,false]
["AgvIsCanLeave","AGV可以离开",null,false]
["RemoveBinding","移除绑定",null,false]
["StepMoveName","步骤名称",null,true]
["StepStartUrlName","步骤开始Url",null,false]
["StepEndUrlName","步骤结束Url",null,false]
["IsNotice","通知",null,false]
["reserved1","备用1",null,false]
["reserved2","备用2",null,false]
["reserved3","备用3",null,false]
["reserved4","备用4",null,false]
["reserved5","备用5",null,false]
["reserved6","备用6",null,false]
["reserved7","备用7",null,false]
["ActualEndTime","结束时间",null,true]
["reserved8","备用8",null,false]
["StartTime","开始时间",null,true]
["PmsBehavior","PMS行为码",null,true]
["ID","GUID",null,false]
["StepID","步骤号",null,false]
["TemplateStepID","模板步骤号",null,true]
["TaskID","任务号",null,false]
["NextStepID","下个步骤号",null,false]
["IsLastStep","是否最后步骤",null,false]
["EndingFlag","结束标志",null,false]
["CarrierStepType","AGV步骤类型",null,false]
["CarrierStepState","AGV步骤状态",null,false]
["SystemStepState","系统步骤状态",null,true]
["UserStepState","用户步骤状态",null,false]
["WareHouseID","库位号",null,true]
["StationID","活动站点",null,true]
["VertexID","导航点",null,true]
["MusicID","音乐号",null,false]
["AgvBehavior","AGV行为码",null,true]
["Param1","参数1",null,true]
["Param2","参数2",null,true]
["Param3","参数3",null,true]
["CreateTime","创建时间",null,true]
["reserved9","备用9",null,false]
["DeviceId","设备ID",null,true]
["RemoteEndPoint","地址",null,true]
["FullTray","全满",null,true]
["FullEmpty","全空",null,true]
["CallButton","叫料按钮",null,true]
["Rotating1","滚筒转动1",null,true]
["Rotating2","滚筒转动2",null,true]
["Rotating3","滚筒转动3",null,true]
["Rotating4","滚筒转动4",null,true]
["Brake1","滚筒刹车1",null,true]
["Brake2","滚筒刹车2",null,true]
["Brake3","滚筒刹车3",null,true]
["Brake4","滚筒刹车4",null,true]
["OperationProgress","操作进度",null,true]
["LastUpdateTime","更新时间",null,true]
["DataValid","数据有效",null,true]
["Output","输出",null,true]
["Input","输入",null,true]
["Route","路线",null,true]
["Mark","地标",null,true]
["AgvId","AGV编号",null,true]
["Function","功能","X2",true]
["BoxCalled","已叫料",null,true]
["BoxCancelCall","取消叫料",null,true]
["BoxReleaseLightOn","放行盒灯亮",null,true]
["BoxReleaseAgv","放行盒已放行",null,true]
["AlarmLightStatus","报警灯状态",null,true]
["InStation","到站",null,true]
["Status","状态",null,true]
["StatusEnum","状态枚举",null,false]
["StatusText","状态文本",null,true]
["Alarm","报警",null,true]
["AlarmText","报警文本",null,true]
["BatteyPower","电池电量",null,true]
["BatteyVoltage","电池电压",null,true]
["BatteyCurrent","电池电流",null,true]
["BatteyTemperature","电池温度",null,true]
["SpeedLevel","速度等级",null,true]
["ScanMessage","扫描信息",null,true]
["WareHouseCode","仓库",null,true]
["LocationCode","仓位",null,true]
["TargetWareHouseCode","目标仓库",null,true]
["TargetLocationCode","目标仓位",null,true]
["MaterialId","物料ID",null,true]
["TaskStatus","任务类型",null,true]
["TaskType","任务类型",null,true]
["StepStatus","发车状态",null,true]
["StepMark","发车地标",null,true]
["StepRoute","发车路线",null,true]
["StepLocation","发车位置",null,true]
["LocationEx1","位置1",null,false]
["LocationEx2","位置2",null,false]
["LocationEx3","位置3",null,false]
["LocationEx4","位置4",null,false]
["Message","消息",null,true]
["CallTime","呼叫时间",null,true]
["EndTime","结束时间",null,true]
["CurrentWarehouse","当前点",null,true]
["WarehouseIndex","索引",null,false]
["Online","在线",null,true]
["GraphOffset","路段偏移",null,true]
["LogicBits","逻辑位",null,true]
["GraphEdge","路段",null,true]
["BatteryLevel","电量",null,true]
["TrafficBlocked","交通管制",null,true]
["MovementX","X坐标",null,true]
["MovementY","Y坐标",null,true]
["GraphVertex","导航点",null,true]
["Parameters","参数",null,false]

{"sheet":"区域配置","index":5,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["区域名称","导航点","路段"]
["A","100;1"]
["B","84;2"]

{"sheet":"任务状态","index":6,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["任务模板","步骤","状态","备注"]
["BOOK2",1,3,"前往上料点"]
["BOOK2",2,4,"到达上料点"]
["BOOK2",3,5,"上料完成并离开"]
["BOOK2",4,6,"到达下料点"]
["BOOK2",5,7,"下料完成"]

{"sheet":"Tibco配置","index":7,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Service","NetWork","Daemon","SubjectNameICS_MES","SubjectNameMES_ICS","FieldName","FactoryName"]
[8883,";225.8.9.3","tcp:172.23.7.25:7500","CSOT.HZ.MES.EDU.MOD.TEMsvr","CSOT.HZ.WCS.EDU.MOD.ICS","xmlData","MODULEB"]