{"text_format":"2","workbook":"xlsx","n_sheets":5,"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":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,6],[8,1,8,6],[15,1,15,6]]}
[]
[null,"低频原始数据original_month"]
[null,"列名","building","meter","funcid","receivetime","data"]
[null,"类型","String","String","Long","String","Double"]
[null,"主键","√","√","√","√"]
[null,"说明","项目10位编码","仪表编号","功能号","数据时间","数据值"]
[null,"备注",null,null,null,"yyyyMMddHHmmss"]
[]
[null,"高频原始数据original_day"]
[null,"列名","building","meter","funcid","receivetime","data"]
[null,"类型","String","String","Long","String","Double"]
[null,"主键","√","√","√","√"]
[null,"说明","项目10位编码","仪表编号","功能号","数据时间","数据值"]
[null,"备注",null,null,null,"yyyyMMddHHmmss"]
[]
[null,"原始数据当前值original_present"]
[null,"列名","building","meter","funcid","receivetime","data"]
[null,"类型","String","String","Long","String","Double"]
[null,"主键","√","√","√"]
[null,"说明","项目10位编码","仪表编号","功能号","数据时间","数据值"]
[null,"备注",null,null,null,"yyyyMMddHHmmss"]

{"sheet":"填报数据","index":1,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"填报原始数据originalreport_data"]
[null,"列名","building","meter","funcid","receivetime","data"]
[null,"类型","String","String","Long","String","Double"]
[null,"主键","√","√","√","√"]
[null,"说明","项目10位编码","仪表编号","功能号","数据时间","数据值"]
[null,"备注",null,null,null,"yyyyMMddHHmmss"]

{"sheet":"控制指令","index":2,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,8],[8,1,8,8]]}
[]
[null,"控制指令数据originalset"]
[null,"列名","building","meter","funcid","receivetime","data","status","endtime"]
[null,"类型","String","String","Long","String","Double","String","String"]
[null,"主键","√","√","√","√"]
[null,"说明","项目10位编码","仪表编号","功能号","指令时间","指令值","指令状态","指令结束时间"]
[null,"备注",null,null,null,"yyyyMMddHHmmss",null,"开始执行start:sent，成功结束finish:success，失败结束finish:xxx"]
[]
[null,"控制指令当前值originalsetpresent"]
[null,"列名","building","meter","funcid","receivetime","data","status","endtime"]
[null,"类型","String","String","Long","String","Double","String","String"]
[null,"主键","√","√","√"]
[null,"说明","项目10位编码","仪表编号","功能号","指令时间","指令值","指令状态","指令结束时间"]
[null,"备注",null,null,null,"yyyyMMddHHmmss",null,"开始执行start:sent，成功结束finish:success，失败结束finish:xxx"]

{"sheet":"分精度","index":3,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,7],[8,1,8,7],[15,1,15,7],[22,1,22,7],[29,1,29,8]]}
[]
[null,"分精度临近值fjd_0_near_15min（15min代表15分钟，还有1min、5min、1h、1d）"]
[null,"列名","building","meter","funcid","data_time","data_value","data_flag"]
[null,"类型","String","String","Long","String","Double","Long"]
[null,"主键","√","√","√","√"]
[null,"说明","项目10位编码","仪表编号","功能号","数据时间","数据值","数据标记"]
[null,"备注",null,null,null,"yyyyMMddHHmmss",null,"0正常，其他正整数为异常"]
[]
[null,"自动修复分精度临近值fjd_1_near_15min（15min代表15分钟，还有1min、5min、1h、1d）"]
[null,"列名","building","meter","funcid","data_time","data_value","data_flag"]
[null,"类型","String","String","Long","String","Double","Long"]
[null,"主键","√","√","√","√"]
[null,"说明","项目10位编码","仪表编号","功能号","数据时间","数据值","数据标记"]
[null,"备注",null,null,null,"yyyyMMddHHmmss",null,"0正常，其他正整数为异常"]
[]
[null,"人工修复分精度临近值fjd_2_near_15min（15min代表15分钟，还有1min、5min、1h、1d）"]
[null,"列名","building","meter","funcid","data_time","data_value","data_flag"]
[null,"类型","String","String","Long","String","Double","Long"]
[null,"主键","√","√","√","√"]
[null,"说明","项目10位编码","仪表编号","功能号","数据时间","数据值","数据标记"]
[null,"备注",null,null,null,"yyyyMMddHHmmss",null,"0正常，其他正整数为异常"]
[]
[null,"专家修复分精度临近值fjd_3_near_15min（15min代表15分钟，还有1min、5min、1h、1d）"]
[null,"列名","building","meter","funcid","data_time","data_value","data_flag"]
[null,"类型","String","String","Long","String","Double","Long"]
[null,"主键","√","√","√","√"]
[null,"说明","项目10位编码","仪表编号","功能号","数据时间","数据值","数据标记"]
[null,"备注",null,null,null,"yyyyMMddHHmmss",null,"0正常，其他正整数为异常"]
[]
[null,"枚举量分精度比例值fjd_0_rate_15min（15min代表15分钟，还有1min、5min、1h、1d）"]
[null,"列名","building","meter","funcid","data_time","status_value","data_flag","status_ratio"]
[null,"类型","String","String","Long","String","Double","Long","Double"]
[null,"主键","√","√","√","√"]
[null,"说明","项目10位编码","仪表编号","功能号","数据时间","枚举值","数据标记","此枚举值时间比例"]
[null,"备注",null,null,null,"yyyyMMddHHmmss",null,"0正常，其他正整数为异常"]

{"sheet":"仪表能耗","index":4,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6],[8,1,8,6],[9,1,9,6]]}
[]
[null,"仪表能耗data_servicedata_15min（15min代表15分钟，还有1min、5min、1h、1d）"]
[null,"列名","building","meter","funcid","data_time","data_value"]
[null,"类型","String","String","Long","String","Double"]
[null,"主键","√","√","√","√"]
[null,"说明","项目10位编码","仪表编号","功能号","数据时间","差分值"]
[null,"备注",null,null,null,"yyyyMMddHHmmss"]
[]
[null,"仪表能耗最大值data_servicedata_max_1h（1h代表小时，还有1d、1m、1y）"]
[null,"1m和1y需要开启servicedata_max计算任务"]
[null,"列名","building","meter","funcid","data_time","data_value"]
[null,"类型","String","String","Long","String","Double"]
[null,"主键","√","√","√","√"]
[null,"说明","项目10位编码","仪表编号","功能号","数据时间","差分值"]
[null,"备注",null,null,null,"yyyyMMddHHmmss"]