{"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":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,0,6,0],[7,0,10,0],[11,0,14,0],[15,0,18,0]]}
["最小单元","数据类型","对应表","对应字段","备注",null,null,"风场对应",null,"期次对应"]
["气象天气预报","风速、温度、风向、湿度、气压","wf_nwp_data",{"$nulls":4},"牛首山",1,"牛首山一二期工程",1]
["风场","实际功率","wf_stat_period_data","P0",null,null,null,"青山",2,"牛首山三期工程",2]
[null,"实际风速","wf_stat_period_data","AVG_WIND_SPEED",null,null,null,"石板泉",3,"青山一二期工程",3]
[null,"预测风速","wf_nwp_data","WIND_SPEED","NWP_TYPE为7的数据",null,null,"香山",4,"青山三期工程",4]
[null,"短期预测功率","noscale_wf_da_pf_period_data","VALUE","其中model_no为一个数字，要转化为模型名称的话，\n短期模型读取ENUM_MENU_ITEM中menu为120的数据，\n超短期读取menu为123的数据",null,null,"麻黄山",5,"石板泉一期工程",5]
[null,"超短期预测功率","WF_USP_TS_PERIOD_DATA","MOD_POWER",null,null,null,"麻六",6,"石板泉二三期工程",6]
["期次","实际功率","wf_yc_history_data1","YC_VAL","先从windplantproject表中获取遥测号analog_no,\n然后通过遥测号去wf_yc_history_data1表中获取数据",null,null,"宋六",7,"石板泉四期工程",7]
[null,"实际风速","wf_project_stat_period_data","AVG_WIND_SPEED",null,null,null,"星六",8,"香山一二期工程",8]
[null,"短期预测功率","NOSCALE_PR_DA_PF_PERIOD_DATA","VALUE",null,null,null,"牛五",9,"麻黄山一二期工程",9]
[null,"超短期预测功率","PROJECT_USP_TS_PERIOD_DATA","MOD_POWER",{"$nulls":5},"麻六一二期工程",10]
["集电线","实际功率","wf_yc_history_data1","YC_VAL","先从collectorwireproject表中获取遥测号analog_no,\n然后通过遥测号去wf_yc_history_data1表中获取数据",{"$nulls":4},"宋六三期工程",11]
[null,"实际风速","wf_project_stat_period_data","AVG_WIND_SPEED",{"$nulls":5},"星六一期工程",12]
[null,"短期预测功率","noscale_cw_da_pf_period_data","VALUE",{"$nulls":5},"牛五二三期工程",13]
[null,"超短期预测功率","--","--",{"$nulls":5},"牛五四期工程",14]
["风机","实际功率","wf_yc_history_data1","YC_VAL","从mv表中根据风场和wtur_no(风机）及measurementtype_no=1获取遥测号，再去wf_yc_history_data1表中获取数据\n"]
[null,"实际风速","wf_yc_history_data1","YC_VAL","从mv表中根据风场和wtur_no(风机）及measurementtype_no=9获取遥测号，再去wf_yc_history_data1表中获取数据\n"]
[null,"短期预测功率","noscale_wtg_da_pf_period_data","VALUE"]
[null,"超短期预测功率","--","--"]