{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["aim","stragegy","target","zoom_in","fire_door_param"],"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":"aim","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5],[2,0,2,5]]}
["表名称","aim"]
["表描述","巡检目标瞄准控制参数表(控制信息，AGV在远景状态下瞄准巡检目标的云台控制参数)"]
[]
["字段","类型","长度","NotNull","注释","备注"]
["id","long",null,"Y","与巡检目标编号对应"]
["roll","double",null,"Y","云台滚转角"]
["pitch","double",null,"Y","云台俯仰角"]
["yaw","double",null,"Y","云台方位角"]
["height","double",null,"Y","云台高度"]
["focus","int",null,"Y","云台焦距"]
["ratio","double",null,"Y","云台放大倍数"]
["aperture","int",null,"Y","云台光圈大小"]
["topleft_x","int",null,"Y","目标框选左上角X坐标"]
["topleft_y","int",null,"Y","目标框选左上角Y坐标"]
["botright_x","int",null,"Y","目标框选右下角X坐标"]
["botright_y","int",null,"Y","目标框选右下角Y坐标"]

{"sheet":"stragegy","index":1,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5],[2,0,2,5]]}
["表名称","stragegy"]
["表描述","巡检策略参数表(算法信息，包含目标识别算法需要的所有参数)"]
[]
["字段","类型","长度","NotNull","注释","备注"]
["id","int",null,"Y","编号"]
["target_id","int",null,"Y","巡检目标编号"]
["algorithm","int",null,"N","算法种类"]
["range_min","double",null,"N","量程下限"]
["range_max","double",null,"N","量程上限"]
["scale","double",null,"N","量程范围"]
["matrix","varchar",null,"N","阵列式巡检目标类型矩阵"]
["aim_pic","varchar",null,"N","瞄准图片模板"]
["zoomin_pic","varchar",null,"N","抵近图片模板"]
["param_0","varchar",null,"N","通用参数"]
["param_1","varchar",null,"N","通用参数"]
["param_2","varchar",null,"N","通用参数"]
["param_3","varchar",null,"N","通用参数"]
["param_4","varchar",null,"N","通用参数"]
["param_5","varchar",null,"N","通用参数"]
["param_6","varchar",null,"N","通用参数"]
["param_7","varchar",null,"N","通用参数"]
["param_8","varchar",null,"N","通用参数"]
["param_9","varchar",null,"N","通用参数"]
["param_10","varchar",null,"N","通用参数"]
["param_11","varchar",null,"N","通用参数"]
["param_12","varchar",null,"N","通用参数"]
["param_13","varchar",null,"N","通用参数"]
["param_14","varchar",null,"N","通用参数"]
["param_15","varchar",null,"N","通用参数"]
["param_16","varchar",null,"N","通用参数"]
["param_17","varchar",null,"N","通用参数"]
["param_18","varchar",null,"N","通用参数"]
["param_19","varchar",null,"N","通用参数"]

{"sheet":"target","index":2,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5],[2,0,2,5]]}
["表名称","target"]
["表描述","巡检目标信息表(描述信息，巡检目标物理信息及描述信息)"]
[]
["字段","类型","长度","NotNull","注释","备注"]
["id","int",null,"Y","编号"]
["point_id","int",null,"Y","停靠点编号 与停靠点编号对应"]
["name","varchar",null,"N","巡检目标名称"]
["unit","varchar",null,"N","数据单位"]
["info_0","int",null,"N","通用描述信息"]
["info_1","int",null,"N","通用描述信息"]
["info_2","int",null,"N","通用描述信息"]
["info_3","int",null,"N","通用描述信息"]
["info_4","int",null,"N","通用描述信息"]
["info_5","int",null,"N","通用描述信息"]
["info_6","int",null,"N","通用描述信息"]
["info_7","int",null,"N","通用描述信息"]
["info_8","int",null,"N","通用描述信息"]
["info_9","int",null,"N","通用描述信息"]
["info_10","int",null,"N","通用描述信息"]
["info_11","int",null,"N","通用描述信息"]
["info_12","int",null,"N","通用描述信息"]
["info_13","int",null,"N","通用描述信息"]
["info_14","int",null,"N","通用描述信息"]
["info_15","int",null,"N","通用描述信息"]
["info_16","int",null,"N","通用描述信息"]
["info_17","int",null,"N","通用描述信息"]
["info_18","int",null,"N","通用描述信息"]
["info_19","int",null,"N","通用描述信息"]

{"sheet":"zoom_in","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5],[2,0,2,5]]}
["表名称","zoom_in"]
["表描述","巡检目标抵近控制参数表(控制信息，AGV在远景状态下瞄准巡检目标的云台控制参数。)"]
[]
["字段","类型","长度","NotNull","注释","备注*10"]
["id","long",null,"Y","与巡检目标编号对应"]
["roll","double",null,"Y","云台滚转角"]
["pitch","double",null,"Y","云台俯仰角","elevation"]
["yaw","double",null,"Y","云台方位角","azimuth超过1800需-3600"]
["height","double",null,"Y","云台高度"]
["focus","int",null,"Y","云台焦距"]
["ratio","double",null,"Y","云台放大倍数","absoluteZoom"]
["aperture","int",null,"Y","云台光圈大小"]
["topleft_x","int",null,"Y","目标框选左上角X坐标"]
["topleft_y","int",null,"Y","目标框选左上角Y坐标"]
["botright_x","int",null,"Y","目标框选右下角X坐标"]
["botright_y","int",null,"Y","目标框选右下角Y坐标"]

{"sheet":"fire_door_param","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5],[2,0,2,5]]}
["表名称","fire_door_param"]
["表描述","防火门参数"]
[]
["字段","类型","长度","NotNull","注释","备注"]
["no","int",null,"Y","与巡检目标编号对应"]
["ip","varchar",null,"Y","ip"]
["port","int",null,"Y","端口"]
["def_state","int",null,"Y","默认状态(0: 关, 1: 开)"]
["def_ang","int",null,"Y","默认角度,预留(0°~180°"]
["Name","varchar",null,"Y","名称(位置)"]