{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":14,"n_cols":22,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,21]]}
["物联网气象站设备质检表格"]
["任务单号","1","检验时间","23-08-29 20:00:00","23-08-30 10:00:00","报告日期","23-08-30 17:26:22","合格数","0","          ","          ","          ","          ","          ","          ","          ","          ","          ","          ","          ","          ","          "]
["ID","检验项目","电压","信号强度","经度","纬度","固件版本号","sim卡信息","上传数据条数","二氧化碳","光照度","土壤含水率","土壤含水率","土壤温度","土壤温度","热通量","热通量","盐分","盐分","位置信息","热通量","单台合格数"]
["/","判定标准","合格条件(绿色)：\n11~15","合格条件(绿色)：\n>14","合格条件(绿色)：\n113°46′13″±30″范围内","合格条件(绿色)：\n35°1′45″±30″范围内","合格条件(绿色)：\n用检验时的输入作为导入的标准.\n/ 无法显示,替换为 -","合格条件(绿色)：\n1、大于等于180天单元格显示绿色\n2、小于180天大于等于30天单元格显示黄色、\n3、小于30天单元格显示为红色","合格条件(绿色)：\n1、大于7条\n2、两条数据时间间隔小于20分钟的出现频次2次以内、两条数据间隔大于40分钟出现频率2次以内","合格条件(绿色)：\n1、400<示值<1500\n2、有1条合格即可","合格条件(绿色)：\n1、0<示值<200000\n2、有1条合格即可","合格条件(绿色)：\n1、0<示值<=100\n2、有1条合格即可","合格条件(绿色)：\n1、0<示值<=100\n2、有1条合格即可","合格条件(绿色)：\n1.≠0且在-5~35°C之间\n2、有1条合格即可","合格条件(绿色)：\n1.≠0且在-5~35°C之间\n2、有1条合格即可","无判定条件","无判定条件","合格条件(绿色)：\n1、0<示值<1000#2、有1条合格即可","合格条件(绿色)：\n1、0<示值<1000#2、有1条合格即可","合格条件(绿色)：显示河南省新乡市原阳县为合格,否则不合格","无判定条件","合格条件(绿色)：\n所有显示数值全部在合格范围内，则判定为合格"]
["864865060471399","864865060471399","最大值:12.3,最小值:12.3","最大值:24.0,最小值:21.0","经度为: 113.77678","纬度为: 35.02782","设备:2.3.3 2023-08-25-08-49, 输入:1","有效期剩余336天","数据量：28,间隔<20分钟：0,间隔>40分钟：0","最大值:506.0,最小值:448.0","最大值:610.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","无数据","无数据","最大值:69.0,最小值:0.0","最大值:65.0,最小值:0.0","河南省新乡市原阳县","无数据","不合格: 5"]
["861551053388187","861551053388187","最大值:12.2,最小值:12.1","最大值:25.0,最小值:22.0","经度为: 113.77685","纬度为: 35.02788","设备:2.3.3 2023-08-25-08-49, 输入:1","有效期剩余62天","数据量：28,间隔<20分钟：0,间隔>40分钟：0","最大值:522.0,最小值:413.0","最大值:700.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","无数据","无数据","最大值:60.0,最小值:0.0","最大值:42.0,最小值:0.0","河南省新乡市原阳县","无数据","不合格: 5"]
["861551053390613","861551053390613","最大值:12.0,最小值:11.9","最大值:27.0,最小值:25.0","经度为: 113.77675","纬度为: 35.02788","设备:2.3.3 2023-08-25-08-49, 输入:1","有效期剩余1天","数据量：28,间隔<20分钟：0,间隔>40分钟：0","最大值:544.0,最小值:432.0","最大值:40.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","无数据","无数据","最大值:44.0,最小值:0.0","最大值:79.0,最小值:0.0","河南省新乡市原阳县","无数据","不合格: 5"]
["864865060475309","864865060475309","最大值:12.5,最小值:12.4","最大值:24.0,最小值:21.0","经度为: 113.77642","纬度为: 35.02771","设备:2.3.3 2023-08-25-08-49, 输入:1","有效期剩余336天","数据量：28,间隔<20分钟：0,间隔>40分钟：0","最大值:548.0,最小值:468.0","最大值:1030.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","无数据","无数据","最大值:113.0,最小值:0.0","最大值:99.0,最小值:0.0","河南省新乡市原阳县","无数据","不合格: 5"]
["864865060470326","864865060470326","最大值:12.5,最小值:12.4","最大值:20.0,最小值:14.0","经度为: 113.77681","纬度为: 35.0278","设备:2.3.3 2023-08-25-08-49, 输入:1","有效期剩余336天","数据量：28,间隔<20分钟：0,间隔>40分钟：0","最大值:602.0,最小值:483.0","最大值:1210.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","无数据","无数据","最大值:56.0,最小值:0.0","最大值:58.0,最小值:0.0","河南省新乡市原阳县","无数据","不合格: 5"]
["864865060474351","864865060474351","最大值:12.5,最小值:12.3","最大值:22.0,最小值:20.0","经度为: 113.77687","纬度为: 35.0279","设备:2.3.3 2023-08-25-08-49, 输入:1","有效期剩余336天","数据量：28,间隔<20分钟：0,间隔>40分钟：0","最大值:570.0,最小值:494.0","最大值:1390.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","无数据","无数据","最大值:57.0,最小值:0.0","最大值:54.0,最小值:0.0","河南省新乡市原阳县","无数据","不合格: 5"]
["864865060467983","864865060467983","最大值:12.6,最小值:12.5","最大值:23.0,最小值:21.0","经度为: 113.77681","纬度为: 35.02786","设备:2.3.3 2023-08-25-08-49, 输入:1","有效期剩余336天","数据量：28,间隔<20分钟：0,间隔>40分钟：0","最大值:512.0,最小值:411.0","最大值:1500.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","无数据","无数据","最大值:46.0,最小值:0.0","最大值:45.0,最小值:0.0","河南省新乡市原阳县","无数据","不合格: 5"]
["864865060473833","864865060473833","最大值:12.7,最小值:12.5","最大值:13.0,最小值:11.0","经度为: 113.77686","纬度为: 35.02787","设备:2.3.3 2023-08-25-08-49, 输入:1","有效期剩余336天","数据量：28,间隔<20分钟：0,间隔>40分钟：0","最大值:558.0,最小值:497.0","最大值:800.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","无数据","无数据","最大值:45.0,最小值:0.0","最大值:44.0,最小值:0.0","河南省新乡市原阳县","无数据","不合格: 6"]
["864865060481539","864865060481539","最大值:12.6,最小值:12.5","最大值:21.0,最小值:19.0","经度为: 113.77663","纬度为: 35.02828","设备:2.3.3 2023-08-25-08-49, 输入:1","有效期剩余305天","数据量：28,间隔<20分钟：0,间隔>40分钟：0","最大值:510.0,最小值:416.0","最大值:1470.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","无数据","无数据","最大值:50.0,最小值:0.0","最大值:47.0,最小值:0.0","河南省新乡市原阳县","无数据","不合格: 5"]
["864865060469773","864865060469773","最大值:12.6,最小值:12.5","最大值:20.0,最小值:17.0","经度为: 113.77665","纬度为: 35.02788","设备:2.3.3 2023-08-25-08-49, 输入:1","有效期剩余336天","数据量：28,间隔<20分钟：0,间隔>40分钟：0","最大值:518.0,最小值:418.0","最大值:470.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","最大值:0.0,最小值:0.0","无数据","无数据","最大值:55.0,最小值:0.0","最大值:50.0,最小值:0.0","河南省新乡市原阳县","无数据","不合格: 5"]