{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["base","重构规划"],"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":"base","index":0,"n_rows":66,"n_cols":3,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["tablename","new_name","len"]
["seq_4g_siteinfo","cfg_0_4g_siteinfo",{"$f":"LEN(B2)","v":17}]
["seq_4g_siteinfo_deviate_white","cfg_0_4g_siteinfo_white",23]
["seq_5g_siteinfo","cfg_0_5g_siteinfo",17]
["sdr_flow_city_conf","cfg_0_city_conf",15]
["sdr_flow_city_conf2","cfg_1_city_conf",15]
["stats_4g_err_flag","rpt_0_4g_err_flag",17]
["stats_4g_cell_flow_48h_hour","rpt_0_4g_flow_cell_1d_hour",26]
["stats_4g_cell_flow_7d_day","rpt_0_4g_flow_cell_2d_day",25]
["stats_4g_cell_flow_2m_day","rpt_0_4g_flow_cell_7d_day",25]
["stats_4g_site_flow_48h_hour","rpt_0_4g_flow_enb_1d_hour",25]
["stats_4g_site_flow_7d_day","rpt_0_4g_flow_enb_2d_day",24]
["stats_4g_site_flow_2m_day","rpt_0_4g_flow_enb_7d_day",24]
["stats_has_flow_no_4g_gc","rpt_0_4g_flow_no_siteinfo",25]
["stats_4g_cell_lowflow_7d_day","rpt_0_4g_lowflow_cell_2d_day",28]
["stats_4g_site_lowflow_7d_day","rpt_0_4g_lowflow_enb_2d_day",27]
["stats_4g_deviate_summary_db","rpt_0_4g_mdt_deviate_db",23]
["stats_4g_deviate_summary_ql","rpt_0_4g_mdt_deviate_ql",23]
["seq_4g_siteinfo_backup","rpt_0_4g_siteinfo_backup",24]
["stats_4g_colleges_siteinfo","rpt_0_4g_siteinfo_colleges",26]
["stats_4g_error_siteinfo","rpt_0_4g_siteinfo_error",23]
["stats_5g_err_flag","rpt_0_5g_err_flag",17]
["stats_5g_cell_flow_48h_hour","rpt_0_5g_flow_cell_1d_hour",26]
["stats_5g_cell_flow_7d_day","rpt_0_5g_flow_cell_2d_day",25]
["stats_5g_cell_flow_2m_day","rpt_0_5g_flow_cell_7d_day",25]
["stats_5g_site_flow_48h_hour","rpt_0_5g_flow_gnb_1d_hour",25]
["stats_5g_site_flow_7d_day","rpt_0_5g_flow_gnb_2d_day",24]
["stats_5g_site_flow_2m_day","rpt_0_5g_flow_gnb_7d_day",24]
["stats_has_flow_no_5g_gc","rpt_0_5g_flow_no_siteinfo",25]
["stats_5g_physite_flow_48h_hour","rpt_0_5g_flow_site_1d_hour",26]
["stats_5g_physite_flow_7d_day","rpt_0_5g_flow_site_2d_day",25]
["stats_5g_physite_flow_2m_day","rpt_0_5g_flow_site_7d_day",25]
["stats_5g_physite_loflow_7d_day","rpt_0_5g_loflow_site_2d_day",27]
["stats_5g_cell_lowflow_7d_day","rpt_0_5g_lowflow_cell_2d_day",{"$f":"LEN(B34)","v":28}]
["stats_5g_site_lowflow_7d_day","rpt_0_5g_lowflow_gnb_2d_day",27]
["seq_5g_siteinfo_backup","rpt_0_5g_siteinfo_backup",24]
["stats_5g_colleges_siteinfo","rpt_0_5g_siteinfo_colleges",26]
["stats_5g_error_siteinfo","rpt_0_5g_siteinfo_error",23]
["stats1_5g_cell_flow_48h_hour","rpt_1_5g_flow_cell_1d_hour",26]
["stats1_5g_cell_flow_7d_day","rpt_1_5g_flow_cell_2d_day",25]
["stats1_5g_cell_flow_2m_day","rpt_1_5g_flow_cell_7d_day",25]
["stats1_5g_site_flow_48h_hour","rpt_1_5g_flow_gnb_1d_hour",25]
["stats1_5g_site_flow_7d_day","rpt_1_5g_flow_gnb_2d_day",24]
["stats1_5g_site_flow_2m_day","rpt_1_5g_flow_gnb_7d_day",24]
["stats1_has_flow_no_5g_gc","rpt_1_5g_flow_no_siteinfo",25]
["stats1_5g_psite_flow_48h_hour","rpt_1_5g_flow_site_1d_hour",26]
["stats1_5g_physite_flow_7d_day","rpt_1_5g_flow_site_2d_day",25]
["stats1_5g_psite_flow_7d_day","rpt_1_5g_flow_site_2d_day",25]
["stats1_5g_physite_flow_2m_day","rpt_1_5g_flow_site_7d_day",25]
["stats1_5g_psite_flow_2m_day","rpt_1_5g_flow_site_7d_day",25]
["stats1_5g_cell_lowflow_7d_day","rpt_1_5g_lowflow_cell_2d_day",28]
["stats1_5g_site_lowflow_7d_day","rpt_1_5g_lowflow_gnb_2d_day",27]
["stats1_5g_psite_loflow_7d_day","rpt_1_5g_lowflow_site_2d_day",28]
["sdr_flow_4g_cell_day","sdr_0_4g_flow_cell_day",22]
["sdr_flow_4g_cell_hour","sdr_0_4g_flow_cell_hour",23]
["sdr_flow_4g_enb_day","sdr_0_4g_flow_enb_day",21]
["sdr_flow_4g_enb_hour","sdr_0_4g_flow_enb_hour",22]
["seq_mdt_grid50_cell","sdr_0_4g_mdt_g50_cell_day",25]
["seq_mdt_grid50_dbscan","sdr_0_4g_mdt_g50_dbscan_cay",27]
["sdr_flow_cell_throughput","sdr_0_5g_flow_base_day",22]
["sdr_flow_5g_cell_day","sdr_0_5g_flow_cell_day",22]
["sdr_flow_5g_enb_day","sdr_0_5g_flow_enb_day",21]
["sdr1_flow_cell_throughput","sdr_1_5g_flow_base_day",22]
["sdr1_flow_5g_cell_day","sdr_1_5g_flow_cell_day",22]
["sdr_flow_5g_cell_day2","sdr_1_5g_flow_cell_day",22]
["sdr1_flow_5g_enb_day","sdr_1_5g_flow_enb_day",{"$f":"LEN(B66)","v":21}]

{"sheet":"重构规划","index":1,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["原表明",null,"新表名","len"]
["seq_4g_siteinfo","4G工参","cfg_0_4g_siteinfo",{"$f":"LEN(C2)","v":17},null,{"$f":"\"alter table \"&A2&\" rename to \"&C2&\";\"","v":"alter table seq_4g_siteinfo rename to cfg_0_4g_siteinfo;"}]
["seq_4g_siteinfo_deviate_white","白名单","cfg_0_4g_siteinfo_white",23,null,"alter table seq_4g_siteinfo_deviate_white rename to cfg_0_4g_siteinfo_white;"]
["seq_5g_siteinfo","5G工参","cfg_0_5g_siteinfo",17,null,"alter table seq_5g_siteinfo rename to cfg_0_5g_siteinfo;"]
["sdr_flow_city_conf","地市区县编码和地市区县对应关系","cfg_0_city_conf",15,null,"alter table sdr_flow_city_conf rename to cfg_0_city_conf;"]
["sdr_flow_city_conf2","地市和区号和地市编码对应关系","cfg_1_city_conf",15,null,"alter table sdr_flow_city_conf2 rename to cfg_1_city_conf;"]
["stats_4g_err_flag","存储过程生成","rpt_0_4g_err_flag",17,null,"alter table stats_4g_err_flag rename to rpt_0_4g_err_flag;"]
["stats_4g_cell_flow_48h_hour","存储过程生成","rpt_0_4g_flow_cell_1d_hour",26,null,"alter table stats_4g_cell_flow_48h_hour rename to rpt_0_4g_flow_cell_1d_hour;"]
["stats_4g_cell_flow_7d_day","存储过程生成","rpt_0_4g_flow_cell_2d_day",25,null,"alter table stats_4g_cell_flow_7d_day rename to rpt_0_4g_flow_cell_2d_day;"]
["stats_4g_cell_flow_2m_day","存储过程生成","rpt_0_4g_flow_cell_7d_day",25,null,"alter table stats_4g_cell_flow_2m_day rename to rpt_0_4g_flow_cell_7d_day;"]
["stats_4g_site_flow_48h_hour","存储过程生成","rpt_0_4g_flow_enb_1d_hour",25,null,"alter table stats_4g_site_flow_48h_hour rename to rpt_0_4g_flow_enb_1d_hour;"]
["stats_4g_site_flow_7d_day","存储过程生成","rpt_0_4g_flow_enb_2d_day",24,null,"alter table stats_4g_site_flow_7d_day rename to rpt_0_4g_flow_enb_2d_day;"]
["stats_4g_site_flow_2m_day","存储过程生成","rpt_0_4g_flow_enb_7d_day",24,null,"alter table stats_4g_site_flow_2m_day rename to rpt_0_4g_flow_enb_7d_day;"]
["stats_has_flow_no_4g_gc","存储过程生成","rpt_0_4g_flow_no_siteinfo",25,null,"alter table stats_has_flow_no_4g_gc rename to rpt_0_4g_flow_no_siteinfo;"]
["stats_4g_cell_lowflow_7d_day","存储过程生成","rpt_0_4g_lowflow_cell_2d_day",28,null,"alter table stats_4g_cell_lowflow_7d_day rename to rpt_0_4g_lowflow_cell_2d_day;"]
["stats_4g_site_lowflow_7d_day","存储过程生成","rpt_0_4g_lowflow_enb_2d_day",27,null,"alter table stats_4g_site_lowflow_7d_day rename to rpt_0_4g_lowflow_enb_2d_day;"]
["stats_4g_deviate_summary_db","存储过程生成","rpt_0_4g_mdt_deviate_db",23,null,"alter table stats_4g_deviate_summary_db rename to rpt_0_4g_mdt_deviate_db;"]
["stats_4g_deviate_summary_ql","存储过程生成","rpt_0_4g_mdt_deviate_ql",23,null,"alter table stats_4g_deviate_summary_ql rename to rpt_0_4g_mdt_deviate_ql;"]
["seq_4g_siteinfo_backup","4G工参备份","rpt_0_4g_siteinfo_backup",24,null,"alter table seq_4g_siteinfo_backup rename to rpt_0_4g_siteinfo_backup;"]
["stats_4g_colleges_siteinfo","4G校园边框（重装64的时候数据丢失，需重新画或重新获取）","rpt_0_4g_siteinfo_colleges",26,null,"alter table stats_4g_colleges_siteinfo rename to rpt_0_4g_siteinfo_colleges;"]
["stats_4g_error_siteinfo","存储过程生成","rpt_0_4g_siteinfo_error",23,null,"alter table stats_4g_error_siteinfo rename to rpt_0_4g_siteinfo_error;"]
["stats_5g_err_flag","存储过程生成，stats_开头是用厂家网管收集的业务量生成的表","rpt_0_5g_err_flag",17,null,"alter table stats_5g_err_flag rename to rpt_0_5g_err_flag;"]
["stats_5g_cell_flow_48h_hour","存储过程生成，stats_开头是用厂家网管收集的业务量生成的表","rpt_0_5g_flow_cell_1d_hour",26,null,"alter table stats_5g_cell_flow_48h_hour rename to rpt_0_5g_flow_cell_1d_hour;"]
["stats_5g_cell_flow_7d_day","存储过程生成，stats_开头是用厂家网管收集的业务量生成的表","rpt_0_5g_flow_cell_2d_day",25,null,"alter table stats_5g_cell_flow_7d_day rename to rpt_0_5g_flow_cell_2d_day;"]
["stats_5g_cell_flow_2m_day","存储过程生成，stats_开头是用厂家网管收集的业务量生成的表","rpt_0_5g_flow_cell_7d_day",25,null,"alter table stats_5g_cell_flow_2m_day rename to rpt_0_5g_flow_cell_7d_day;"]
["stats_5g_site_flow_48h_hour","存储过程生成，stats_开头是用厂家网管收集的业务量生成的表","rpt_0_5g_flow_gnb_1d_hour",25,null,"alter table stats_5g_site_flow_48h_hour rename to rpt_0_5g_flow_gnb_1d_hour;"]
["stats_5g_site_flow_7d_day","存储过程生成，stats_开头是用厂家网管收集的业务量生成的表","rpt_0_5g_flow_gnb_2d_day",24,null,"alter table stats_5g_site_flow_7d_day rename to rpt_0_5g_flow_gnb_2d_day;"]
["stats_5g_site_flow_2m_day","存储过程生成，stats_开头是用厂家网管收集的业务量生成的表","rpt_0_5g_flow_gnb_7d_day",24,null,"alter table stats_5g_site_flow_2m_day rename to rpt_0_5g_flow_gnb_7d_day;"]
["stats_has_flow_no_5g_gc","存储过程生成，stats_开头是用厂家网管收集的业务量生成的表","rpt_0_5g_flow_no_siteinfo",25,null,"alter table stats_has_flow_no_5g_gc rename to rpt_0_5g_flow_no_siteinfo;"]
["stats_5g_physite_flow_48h_hour","存储过程生成，stats_开头是用厂家网管收集的业务量生成的表","rpt_0_5g_flow_site_1d_hour",26,null,"alter table stats_5g_physite_flow_48h_hour rename to rpt_0_5g_flow_site_1d_hour;"]
["stats_5g_physite_flow_7d_day","存储过程生成，stats_开头是用厂家网管收集的业务量生成的表","rpt_0_5g_flow_site_2d_day",25,null,"alter table stats_5g_physite_flow_7d_day rename to rpt_0_5g_flow_site_2d_day;"]
["stats_5g_physite_flow_2m_day","存储过程生成，stats_开头是用厂家网管收集的业务量生成的表","rpt_0_5g_flow_site_7d_day",25,null,"alter table stats_5g_physite_flow_2m_day rename to rpt_0_5g_flow_site_7d_day;"]
["stats_5g_physite_loflow_7d_day","存储过程生成，stats_开头是用厂家网管收集的业务量生成的表","rpt_0_5g_loflow_site_2d_day",27,null,"alter table stats_5g_physite_loflow_7d_day rename to rpt_0_5g_loflow_site_2d_day;"]
["stats_5g_cell_lowflow_7d_day","存储过程生成，stats_开头是用厂家网管收集的业务量生成的表","rpt_0_5g_lowflow_cell_2d_day",{"$f":"LEN(C34)","v":28},null,{"$f":"\"alter table \"&A34&\" rename to \"&C34&\";\"","v":"alter table stats_5g_cell_lowflow_7d_day rename to rpt_0_5g_lowflow_cell_2d_day;"}]
["stats_5g_site_lowflow_7d_day","存储过程生成，stats_开头是用厂家网管收集的业务量生成的表","rpt_0_5g_lowflow_gnb_2d_day",27,null,"alter table stats_5g_site_lowflow_7d_day rename to rpt_0_5g_lowflow_gnb_2d_day;"]
["seq_5g_siteinfo_backup","5G工参备份","rpt_0_5g_siteinfo_backup",24,null,"alter table seq_5g_siteinfo_backup rename to rpt_0_5g_siteinfo_backup;"]
["stats_5g_colleges_siteinfo","5G校园边框（重装64的时候数据丢失，需重新画或重新获取）","rpt_0_5g_siteinfo_colleges",26,null,"alter table stats_5g_colleges_siteinfo rename to rpt_0_5g_siteinfo_colleges;"]
["stats_5g_error_siteinfo","存储过程生成，stats_开头是用厂家网管收集的业务量生成的表","rpt_0_5g_siteinfo_error",23,null,"alter table stats_5g_error_siteinfo rename to rpt_0_5g_siteinfo_error;"]
["stats1_5g_cell_flow_48h_hour","存储过程生成，stats1_开头是用SDR的业务量生成的表","rpt_1_5g_flow_cell_1d_hour",26,null,"alter table stats1_5g_cell_flow_48h_hour rename to rpt_1_5g_flow_cell_1d_hour;"]
["stats1_5g_cell_flow_7d_day","存储过程生成，stats1_开头是用SDR的业务量生成的表","rpt_1_5g_flow_cell_2d_day",25,null,"alter table stats1_5g_cell_flow_7d_day rename to rpt_1_5g_flow_cell_2d_day;"]
["stats1_5g_cell_flow_2m_day","存储过程生成，stats1_开头是用SDR的业务量生成的表","rpt_1_5g_flow_cell_7d_day",25,null,"alter table stats1_5g_cell_flow_2m_day rename to rpt_1_5g_flow_cell_7d_day;"]
["stats1_5g_site_flow_48h_hour","存储过程生成，stats1_开头是用SDR的业务量生成的表","rpt_1_5g_flow_gnb_1d_hour",25,null,"alter table stats1_5g_site_flow_48h_hour rename to rpt_1_5g_flow_gnb_1d_hour;"]
["stats1_5g_site_flow_7d_day","存储过程生成，stats1_开头是用SDR的业务量生成的表","rpt_1_5g_flow_gnb_2d_day",24,null,"alter table stats1_5g_site_flow_7d_day rename to rpt_1_5g_flow_gnb_2d_day;"]
["stats1_5g_site_flow_2m_day","存储过程生成，stats1_开头是用SDR的业务量生成的表","rpt_1_5g_flow_gnb_7d_day",24,null,"alter table stats1_5g_site_flow_2m_day rename to rpt_1_5g_flow_gnb_7d_day;"]
["stats1_has_flow_no_5g_gc","存储过程生成，stats1_开头是用SDR的业务量生成的表","rpt_1_5g_flow_no_siteinfo",25,null,"alter table stats1_has_flow_no_5g_gc rename to rpt_1_5g_flow_no_siteinfo;"]
["stats1_5g_psite_flow_48h_hour","存储过程生成，stats1_开头是用SDR的业务量生成的表","rpt_1_5g_flow_site_1d_hour",26,null,"alter table stats1_5g_psite_flow_48h_hour rename to rpt_1_5g_flow_site_1d_hour;"]
["stats1_5g_psite_flow_7d_day","存储过程生成，stats1_开头是用SDR的业务量生成的表","rpt_1_5g_flow_site_2d_day",25,null,"alter table stats1_5g_psite_flow_7d_day rename to rpt_1_5g_flow_site_2d_day;"]
["stats1_5g_physite_flow_2m_day","存储过程生成，stats1_开头是用SDR的业务量生成的表","rpt_1_5g_flow_site_7d_day",25,null,"alter table stats1_5g_physite_flow_2m_day rename to rpt_1_5g_flow_site_7d_day;"]
["stats1_5g_cell_lowflow_7d_day","存储过程生成，stats1_开头是用SDR的业务量生成的表","rpt_1_5g_lowflow_cell_2d_day",28,null,"alter table stats1_5g_cell_lowflow_7d_day rename to rpt_1_5g_lowflow_cell_2d_day;"]
["stats1_5g_site_lowflow_7d_day","存储过程生成，stats1_开头是用SDR的业务量生成的表","rpt_1_5g_lowflow_gnb_2d_day",27,null,"alter table stats1_5g_site_lowflow_7d_day rename to rpt_1_5g_lowflow_gnb_2d_day;"]
["stats1_5g_psite_loflow_7d_day","存储过程生成，stats1_开头是用SDR的业务量生成的表","rpt_1_5g_lowflow_site_2d_day",28,null,"alter table stats1_5g_psite_loflow_7d_day rename to rpt_1_5g_lowflow_site_2d_day;"]
["sdr_flow_4g_cell_day","通过SDR业务量每天汇聚","sdr_0_4g_flow_cell_day",22,null,"alter table sdr_flow_4g_cell_day rename to sdr_0_4g_flow_cell_day;"]
["sdr_flow_4g_cell_hour","不需要小时级的业务量不做汇聚","sdr_0_4g_flow_cell_hour",23,null,"alter table sdr_flow_4g_cell_hour rename to sdr_0_4g_flow_cell_hour;","小时不汇聚"]
["sdr_flow_4g_enb_day","需要SDR业务量每天汇聚（在cell_day)基础上汇聚就可以","sdr_0_4g_flow_enb_day",21,null,"alter table sdr_flow_4g_enb_day rename to sdr_0_4g_flow_enb_day;"]
["sdr_flow_4g_enb_hour","不需要小时级的业务量不做汇聚","sdr_0_4g_flow_enb_hour",22,null,"alter table sdr_flow_4g_enb_hour rename to sdr_0_4g_flow_enb_hour;"]
["seq_mdt_grid50_cell","mdt数据，每个月入库一次就可以","sdr_0_4g_mdt_g50_cell_day",25,null,"alter table seq_mdt_grid50_cell rename to sdr_0_4g_mdt_g50_cell_day;"]
["seq_mdt_grid50_dbscan","mdt数据，每个月入库一次就可以","sdr_0_4g_mdt_g50_dbscan_cay",27,null,"alter table seq_mdt_grid50_dbscan rename to sdr_0_4g_mdt_g50_dbscan_cay;"]
["sdr_flow_cell_throughput","厂家网管收集的5G业务量，目前已不用这种方式，但保留此功能","sdr_0_5g_flow_base_day",22,null,"alter table sdr_flow_cell_throughput rename to sdr_0_5g_flow_base_day;"]
["sdr_flow_5g_cell_day","这个表暂时不用","sdr_0_5g_flow_cell_day",22,null,"alter table sdr_flow_5g_cell_day rename to sdr_0_5g_flow_cell_day;"]
["sdr_flow_5g_enb_day","这个表用不到，5G是看的物理站，不通过gnbid看基站数","sdr_0_5g_flow_enb_day",21,null,"alter table sdr_flow_5g_enb_day rename to sdr_0_5g_flow_enb_day;"]
["sdr1_flow_cell_throughput","通过SDR业务量每天汇聚（这是第二次汇聚，根据gnbid范围添加地市和扇区归属运营商）","sdr_1_5g_flow_base_day",22,null,"alter table sdr1_flow_cell_throughput rename to sdr_1_5g_flow_base_day;"]
["sdr1_flow_5g_cell_day","存储过程生成","sdr_1_5g_flow_cell_day",22,null,"alter table sdr1_flow_5g_cell_day rename to sdr_1_5g_flow_cell_day;"]
["sdr_flow_5g_cell_day2","每天通过SDR业务量汇聚","sdr_2_5g_flow_cell_day",22,null,"alter table sdr_flow_5g_cell_day2 rename to sdr_2_5g_flow_cell_day;"]
["sdr1_flow_5g_enb_day","这个表暂时不用","sdr_1_5g_flow_enb_day",21,null,"alter table sdr1_flow_5g_enb_day rename to sdr_1_5g_flow_enb_day;"]