{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["baobiao_jf_yonghush","baobiao_ipduankou","kuandai_ftth"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"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":"baobiao_jf_yonghush","index":0,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["序号","字段英文名称","字段中文名称","create table sqmdb_cost.baobiao_jf_yonghush(",null,null,{"$f":"[1]!HY_UniStr(D2:D17,\"','\")","v":"kpi_code','kpi_name','month_id','prov_id','pro_name','grade','city_id','city_name','kpi_value','m_ly_value','preinfo1','preinfo2','preinfo3','preinfo4','preinfo5','preinfo6',"}]
[1,"KPI_CODE","指标编码\t","kpi_code","varchar,"]
[2,"KPI_NAME","指标名称","kpi_name","varchar,"]
[3,"MONTH_ID","账期","month_id","varchar,"]
[4,"PROV_ID","省分编码","prov_id","numeric,"]
[5,"PRO_NAME","省分","pro_name","varchar,"]
[6,"GRADE","地级市分档","grade","varchar,"]
[7,"CITY_ID","地市编码","city_id","varchar,"]
[8,"CITY_NAME","地市名称","city_name","varchar,"]
[9,"KPI_VALUE","本月到达","kpi_value","numeric,"]
[10,"M_LY_VALUE","上年同期","m_ly_value","numeric,"]
[11,"PREINFO1","备用字段1","preinfo1","varchar,"]
[12,"PREINFO2","备用字段2","preinfo2","varchar,"]
[13,"PREINFO3","备用字段3","preinfo3","varchar,"]
[14,"PREINFO4","备用字段4","preinfo4","varchar,"]
[15,"PREINFO5","备用字段5","preinfo5","varchar,"]
[16,"PREINFO6","备用字段6","preinfo6","varchar)"]

{"sheet":"baobiao_ipduankou","index":1,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["序号","字段英文名称","字段中文名称","create table sqmdb_cost.baobiao_ipduankou(",null,null,{"$f":"[1]!HY_UniStr(D2:D18,\"','\")","v":"kpi_code','kpi_name','month_id','pro_name','prov_id','grade','city_desc','area_no','kpi_value','m_ly_value','tongbi_daoda','by_szl','qn_szl','tongbi_szl\t','byjz','syjz','ljjz',"}]
[1,"KPI_CODE","指标编码\t","kpi_code","varchar,"]
[2,"KPI_NAME","指标名称","kpi_name","varchar,"]
[3,"MONTH_ID","账期","month_id","varchar,"]
[4,"PRO_NAME","省分","pro_name","varchar,"]
[5,"PROV_ID","省分编码","prov_id","numeric,"]
[6,"GRADE","地市分档","grade","varchar,"]
[7,"CITY_DESC","地市","city_desc","varchar,"]
[8,"AREA_NO","地市编码","area_no","varchar,"]
[9,"KPI_VALUE","本月到达","kpi_value","numeric,"]
[10,"M_LY_VALUE","上年同期","m_ly_value","numeric,"]
[11,"TONGBI_DAODA","同比(%)","tongbi_daoda","numeric,"]
[12,"BY_SZL","本月(%)实占率","by_szl","numeric,"]
[13,"QN_SZL","上年同期(%)实占率","qn_szl","numeric,"]
[14,"TONGBI_SZL\t","同比(%)实占率","tongbi_szl\t","numeric,"]
[15,"BYJZ","本月净增","byjz","numeric,"]
[16,"SYJZ","上月净增","syjz","numeric,"]
[17,"LJJZ","累计净增","ljjz","numeric)"]

{"sheet":"kuandai_ftth","index":2,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["字段名称","字段英文名称","create table sqmdb_cost.kuandai_ftth(",null,null,null,{"$f":"[1]!HY_UniStr(C2:C26,\"','\")","v":"local_net_name','area_name','areal_type_name','dslam_port_count','dslam_port_idle_count','dslam_port_p','fttb_port_count','fttb_port_sts_count','fttb_port_p','pon_ad_port_count','pon_ad_port_sts_count','pon_ad_port_p','pon_lan_port_count','pon_lan_port_sts_count','pon_lan_port_p','ftth_port_count','ftth_port_sts_count','ftth_port_p','ftth_zj_port_count','ftth_zj_port_sts_count','ftth_zj_port_p','ftth_hz_port_count','ftth_hz_port_sts_count','ftth_hz_port_p','sdate',"}]
["本地网","LOCAL_NET_NAME","local_net_name","varchar,","雄安新区"]
["服务区","AREA_NAME","area_name","varchar,","雄安中心局"]
["区域类型","AREAL_TYPE_NAME","areal_type_name","varchar,","城区"]
["DSLAM总端口数","DSLAM_PORT_COUNT","dslam_port_count","numeric,",0]
["DSLAM实占端口数","DSLAM_PORT_IDLE_COUNT","dslam_port_idle_count","numeric,",0]
["DSLAMC端口实占率","DSLAM_PORT_P","dslam_port_p","varchar,",0]
["FTTB/C总端口数","FTTB_PORT_COUNT","fttb_port_count","numeric,",0]
["FTTB/C实占端口数","FTTB_PORT_STS_COUNT","fttb_port_sts_count","numeric,",0]
["FTTB/C端口实占率","FTTB_PORT_P","fttb_port_p","varchar,",0]
["PON_AD总端口数","PON_AD_PORT_COUNT","pon_ad_port_count","numeric,",0]
["PON_AD实占端口数","PON_AD_PORT_STS_COUNT","pon_ad_port_sts_count","numeric,",0]
["PON_AD端口实占率","PON_AD_PORT_P","pon_ad_port_p","varchar,",0]
["PON_LAN总端口数","PON_LAN_PORT_COUNT","pon_lan_port_count","numeric,",0]
["PON_LAN实占端口数","PON_LAN_PORT_STS_COUNT","pon_lan_port_sts_count","numeric,",0]
["PON_LAN端口实占率","PON_LAN_PORT_P","pon_lan_port_p","varchar,",0]
["FTTH总端口数","FTTH_PORT_COUNT","ftth_port_count","numeric,",8152]
["FTTH实占端口数","FTTH_PORT_STS_COUNT","ftth_port_sts_count","numeric,",4086]
["FTTH端口实占率","FTTH_PORT_P","ftth_port_p","varchar,",0.50119999999999998]
["FTTH自建总端口数","FTTH_ZJ_PORT_COUNT","ftth_zj_port_count","numeric,",8152]
["FTTH自建实占端口数","FTTH_ZJ_PORT_STS_COUNT","ftth_zj_port_sts_count","numeric,",4086]
["FTTH自建端口实占率","FTTH_ZJ_PORT_P","ftth_zj_port_p","varchar,",0.50119999999999998]
["FTTH合作总端口数","FTTH_HZ_PORT_COUNT","ftth_hz_port_count","numeric,",0]
["FTTH合作实占端口数","FTTH_HZ_PORT_STS_COUNT","ftth_hz_port_sts_count","numeric,",0]
["FTTH合作端口实占率","FTTH_HZ_PORT_P","ftth_hz_port_p","varchar,",0]
[null,null,"sdate","timestamp)","2022-04-02"]