{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["中间屏","比自己","比别人","看异常","看趋准","更新记录"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"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":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["大类","小类","文件名","英文字段","中文字段"]
["预算进度","预算进度","chengben_center_city","smonth","月份"]
["预算进度","预算进度","chengben_center_city","city_name","地市"]
["预算进度","预算进度","chengben_center_city","total_cost","网运成本"]
["预算进度","预算进度","chengben_center_city","total_ys","总预算"]
["预算进度","预算进度","chengben_center_city","rate_ys","网运成本预算完成进度（省内口径）"]
["预算进度","预算进度","chengben_center_city","city_code","地市编码"]

{"sheet":"比自己","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["大类","小类","文件名","英文字段","中文字段"]
["预算进度","预算进度","chengben_self_1_b10","smonth","月份"]
["预算进度","预算进度","chengben_self_1_b10","sname","省份名称"]
["预算进度","预算进度","chengben_self_1_b10","total_cost","网运成本"]
["预算进度","预算进度","chengben_self_1_b10","total_ys","总预算"]
["预算进度","预算进度","chengben_self_1_b10","rate_ys","网运成本预算完成进度（北10）"]
["预算进度","预算进度","chengben_self_1_b10","prov_code","省份编码"]
["主要成本（万元）","主要成本（万元）","chengben_self_2_city","smonth","月份"]
["主要成本（万元）","主要成本（万元）","chengben_self_2_city","sname","地市"]
["主要成本（万元）","主要成本（万元）","chengben_self_2_city","cost_total_jt","总额（集团口径）"]
["主要成本（万元）","主要成本（万元）","chengben_self_2_city","cost_rental_tower_jt","铁塔租赁费"]
["主要成本（万元）","主要成本（万元）","chengben_self_2_city","cost_nenghao_jt","网络能耗"]
["主要成本（万元）","主要成本（万元）","chengben_self_2_city","cost_rental_3rd_jt","第三方租赁费"]
["主要成本（万元）","主要成本（万元）","chengben_self_2_city","cost_total_sn","总额（省内口径）"]
["主要成本（万元）","主要成本（万元）","chengben_self_2_city","cost_fix_sn","修理及运行维护费（省内）"]
["主要成本（万元）","主要成本（万元）","chengben_self_2_city","city_code","地市编码"]

{"sheet":"比别人","index":2,"n_rows":60,"n_cols":5,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["大类","小类","文件名","英文字段","中文字段"]
["成本占收比（省内口径）","成本占收比（省内口径）","chengben_other_1_city_b10","smonth","月份"]
["成本占收比（省内口径）","成本占收比（省内口径）","chengben_other_1_city_b10","stype","类型"]
["成本占收比（省内口径）","成本占收比（省内口径）","chengben_other_1_city_b10","sname","名称"]
["成本占收比（省内口径）","成本占收比（省内口径）","chengben_other_1_city_b10","cost_total","成本"]
["成本占收比（省内口径）","成本占收比（省内口径）","chengben_other_1_city_b10","income","累计收入"]
["成本占收比（省内口径）","成本占收比（省内口径）","chengben_other_1_city_b10","cost_income_rate","成本占收比"]
["成本占收比（省内口径）","成本占收比（省内口径）","chengben_other_1_city_b10","city_code","地市编码"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2(grid/city)","smonth","月份"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2(grid/city)","city_sname","地市名称"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2(grid)","grid_name","网格名称"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2(grid/city)","cost_yw","移网成本"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2(grid/city)","cost_hexin","核心网成本"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2(grid/city)","cost_total","移网+核心网成本"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2(grid/city)","zps_num_with5g","载频载扇数（含5g）"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2(grid/city)","zps_num_no5g","载频载扇数（不含5g）"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2(grid/city)","cost_zps_with5g","单载频载扇能耗（含5g)"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2(grid/city)","cost_zps_no5g","单载频载扇能耗（不含5g)"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2(grid/city)","city_code","地市编码"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2_grid","area_code","区县编码"]
["单端口能耗（元/月）","单端口能耗（元/月）","chengben_other_3(grid/city)","smonth","月份"]
["单端口能耗（元/月）","单端口能耗（元/月）","chengben_other_3(grid/city)","city_name","地市"]
["单端口能耗（元/月）","单端口能耗（元/月）","chengben_other_3(grid)","area_name","区县"]
["单端口能耗（元/月）","单端口能耗（元/月）","chengben_other_3(grid/city)","cost_nenghao","能耗成本"]
["单端口能耗（元/月）","单端口能耗（元/月）","chengben_other_3(grid/city)","ftth_port_count","端口数"]
["单端口能耗（元/月）","单端口能耗（元/月）","chengben_other_3(grid/city)","cost_port_nenghao","单端口能耗"]
["单端口能耗（元/月）","单端口能耗（元/月）","chengben_other_3(grid/city)","city_code","地市编码"]
["单端口能耗（元/月）","单端口能耗（元/月）","chengben_other_3(grid)","area_code","区县编码"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-北10","chengben_other_4_b10","smonth","月份"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-北10","chengben_other_4_b10","sname","省份"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-北10","chengben_other_4_b10","tower_cost_avg_b10","铁塔单站租赁费"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-北10","chengben_other_4_b10","prov_code","省份编码"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-地市","chengben_other_4_city","smonth","月份"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-地市","chengben_other_4_city","city_name","地市"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-地市","chengben_other_4_city","tower_cost_total","铁塔租费合计"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-地市","chengben_other_4_city","tower_num","铁塔数量"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-地市","chengben_other_4_city","tower_cost_avg_city","铁塔单站租赁费"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-地市","chengben_other_4_city","city_code","地市编码"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-网格","chengben_other_4_grid","sdate","月份"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-网格","chengben_other_4_grid","city_operator","地市"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-网格","chengben_other_4_grid","area_operator","区县"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-网格","chengben_other_4_grid","tower_cost_total","铁塔租费合计"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-网格","chengben_other_4_grid","tower_num","铁塔数量"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-网格","chengben_other_4_grid","tower_cost_avg_area","铁塔单站租赁费"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-网格","chengben_other_4_grid","city_code","地市编码"]
["铁塔单站租赁费（元/月）","铁塔单站租赁费-网格","chengben_other_4_grid","area_code","区县编码"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2_b10","smonth","月份"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2_b10","sname","省份"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2_b10","cost_yw","移网成本"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2_b10","cost_hexin","核心网成本"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2_b10","cost_total","移网+核心网成本"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2_b10","zps_num_no5g","载频载扇数（不含5g）"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2_b10","cost_zps_no5g","单载频载扇能耗（不含5g)"]
["单载频载扇能耗（元/月）","单载频载扇能耗（元/月）","chengben_other_2_b10","prov_code","省份编码"]
["单端口能耗（元/月）","单端口能耗（元/月）","chengben_other_3_b10","smonth","月份"]
["单端口能耗（元/月）","单端口能耗（元/月）","chengben_other_3_b10","sname","省份"]
["单端口能耗（元/月）","单端口能耗（元/月）","chengben_other_3_b10","cost_nenghao","能耗成本"]
["单端口能耗（元/月）","单端口能耗（元/月）","chengben_other_3_b10","ftth_port_count","端口数"]
["单端口能耗（元/月）","单端口能耗（元/月）","chengben_other_3_b10","cost_port_nenghao","单端口能耗"]
["单端口能耗（元/月）","单端口能耗（元/月）","chengben_other_3_b10","prov_code","省份编码"]

{"sheet":"看异常","index":3,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["大类","小类","文件名","英文字段","中文字段"]
["租赁费","租赁费","chengben_exception_1_grid","sdate","月份"]
["租赁费","租赁费","chengben_exception_1_grid","city_name","地市名称"]
["租赁费","租赁费","chengben_exception_1_grid","area_name","区县名称"]
["租赁费","租赁费","chengben_exception_1_grid","station_sid","局站ID"]
["租赁费","租赁费","chengben_exception_1_grid","station_sname","局站名称"]
["租赁费","租赁费","chengben_exception_1_grid","property_type","产权类型"]
["租赁费","租赁费","chengben_exception_1_grid","hetong_sid","合同ID"]
["租赁费","租赁费","chengben_exception_1_grid","cost_hetong","合同月租金"]
["租赁费","租赁费","chengben_exception_1_grid","tower_code","铁塔站址编码"]
["租赁费","租赁费","chengben_exception_1_grid","cost_tower","租赁费_铁塔"]
["租赁费","租赁费","chengben_exception_1_grid","cost_total","租赁费合计"]
["租赁费","租赁费","chengben_exception_1_grid","cbzx","成本中心"]
["租赁费","租赁费","chengben_exception_1_grid","cbzx_cost_avg","本单位铁塔单站租赁费"]
["租赁费","租赁费","chengben_exception_1_grid","cost_rate","实际租赁费与本单位租费比值"]
["租赁费","租赁费","chengben_exception_1_grid","city_code","地市编码"]
["租赁费","租赁费","chengben_exception_1_grid","area_code","区县编码"]
["电费单价","电费单价","chengben_exception_2_grid","smonth","月份"]
["电费单价","电费单价","chengben_exception_2_grid","city_name","地市名称"]
["电费单价","电费单价","chengben_exception_2_grid","area_name","区县名称"]
["电费单价","电费单价","chengben_exception_2_grid","station_sid","局站ID"]
["电费单价","电费单价","chengben_exception_2_grid","station_sname","局站名称"]
["电费单价","电费单价","chengben_exception_2_grid","meter_type_name","结算类型"]
["电费单价","电费单价","chengben_exception_2_grid","accrued_cost","本期成本"]
["电费单价","电费单价","chengben_exception_2_grid","accrued_power","本期电量"]
["电费单价","电费单价","chengben_exception_2_grid","eprice","电费单价"]
["电费单价","电费单价","chengben_exception_2_grid","cost_unit_name","成本中心"]
["电费单价","电费单价","chengben_exception_2_grid","city_code","地市编码"]
["电费单价","电费单价","chengben_exception_2_grid","area_code","区县编码"]
["局站功耗","局站功耗","chengben_exception_3_grid","smonth","月份"]
["局站功耗","局站功耗","chengben_exception_3_grid","city_code","地市编码"]
["局站功耗","局站功耗","chengben_exception_3_grid","area_code","区县编码"]
["局站功耗","局站功耗","chengben_exception_3_grid","station_sid","局站ID"]
["局站功耗","局站功耗","chengben_exception_3_grid","station_name","局站名称"]
["局站功耗","局站功耗","chengben_exception_3_grid","nh_total","实际功耗"]
["局站功耗","局站功耗","chengben_exception_3_grid","accrued_power","合理功耗"]
["局站功耗","局站功耗","chengben_exception_3_grid","cost_unit_name","成本中心"]

{"sheet":"看趋准","index":4,"n_rows":66,"n_cols":5,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["大类","小类","文件名","英文字段","中文字段"]
["考核指标","转供电+定额包干累计成本占比（%）","chengben_quzhun_1_a_grid","smonth","月份"]
["考核指标","转供电+定额包干累计成本占比（%）","chengben_quzhun_1_a_grid","city_name","地市"]
["考核指标","转供电+定额包干累计成本占比（%）","chengben_quzhun_1_a_grid","area_name","区县"]
["考核指标","转供电+定额包干累计成本占比（%）","chengben_quzhun_1_a_grid","total_cost","总成本"]
["考核指标","转供电+定额包干累计成本占比（%）","chengben_quzhun_1_a_grid","zgd_cost","转供电定额包干成本"]
["考核指标","转供电+定额包干累计成本占比（%）","chengben_quzhun_1_a_grid","zgd_cost_rate","转供电定额包干成本占比"]
["考核指标","转供电+定额包干累计成本占比（%）","chengben_quzhun_1_a_grid","city_code","地市编码"]
["考核指标","转供电+定额包干累计成本占比（%）","chengben_quzhun_1_a_grid","area_code","区县编码"]
["考核指标","铁塔独享站成本占比（%）","chengben_quzhun_1_b_grid","sdate","月份"]
["考核指标","铁塔独享站成本占比（%）","chengben_quzhun_1_b_grid","city_operator","地市"]
["考核指标","铁塔独享站成本占比（%）","chengben_quzhun_1_b_grid","area_operator","区县"]
["考核指标","铁塔独享站成本占比（%）","chengben_quzhun_1_b_grid","cost_total","总成本"]
["考核指标","铁塔独享站成本占比（%）","chengben_quzhun_1_b_grid","cost_du","独享站成本"]
["考核指标","铁塔独享站成本占比（%）","chengben_quzhun_1_b_grid","cost_du_rate","独享站成本占比"]
["考核指标","铁塔独享站成本占比（%）","chengben_quzhun_1_b_grid","city_code","地市编码"]
["考核指标","铁塔独享站成本占比（%）","chengben_quzhun_1_b_grid","area_code","区县编码"]
["考核指标","大于2倍铁塔单站租赁费三方站点占比（%）","chengben_quzhun_1_c_grid","sdate","月份"]
["考核指标","大于2倍铁塔单站租赁费三方站点占比（%）","chengben_quzhun_1_c_grid","city_name","地市"]
["考核指标","大于2倍铁塔单站租赁费三方站点占比（%）","chengben_quzhun_1_c_grid","area_name","区县"]
["考核指标","大于2倍铁塔单站租赁费三方站点占比（%）","chengben_quzhun_1_c_grid","cost_over2b_3rd_num","大于2倍铁塔单站租赁费三方站点数量"]
["考核指标","大于2倍铁塔单站租赁费三方站点占比（%）","chengben_quzhun_1_c_grid","station_num","大于2倍铁塔单站租赁费总数量"]
["考核指标","大于2倍铁塔单站租赁费三方站点占比（%）","chengben_quzhun_1_c_grid","over_rate_3rd","大于2倍铁塔单站租赁费三方站点占比"]
["考核指标","大于2倍铁塔单站租赁费三方站点占比（%）","chengben_quzhun_1_c_grid","city_code","地市编码"]
["考核指标","大于2倍铁塔单站租赁费三方站点占比（%）","chengben_quzhun_1_c_grid","area_code","区县编码"]
["考核指标","单载频载扇能耗（元/月）","chengben_quzhun_1_d(grid/city)","smonth","月份"]
["考核指标","单载频载扇能耗（元/月）","chengben_quzhun_1_d(grid/city)","city_sname","地市名称"]
["考核指标","单载频载扇能耗（元/月）","chengben_quzhun_1_d(grid)","grid_name","网格名称"]
["考核指标","单载频载扇能耗（元/月）","chengben_quzhun_1_d(grid/city)","cost_yw","移网成本"]
["考核指标","单载频载扇能耗（元/月）","chengben_quzhun_1_d(grid/city)","cost_hexin","核心网成本"]
["考核指标","单载频载扇能耗（元/月）","chengben_quzhun_1_d(grid/city)","cost_total","移网+核心网成本"]
["考核指标","单载频载扇能耗（元/月）","chengben_quzhun_1_d(grid/city)","zps_num_with5g","载频载扇数（含5g）"]
["考核指标","单载频载扇能耗（元/月）","chengben_quzhun_1_d(grid/city)","zps_num_no5g","载频载扇数（不含5g）"]
["考核指标","单载频载扇能耗（元/月）","chengben_quzhun_1_d(grid/city)","cost_zps_with5g","单载频载扇能耗（含5g)"]
["考核指标","单载频载扇能耗（元/月）","chengben_quzhun_1_d(grid/city)","cost_zps_no5g","单载频载扇能耗（不含5g)"]
["考核指标","单载频载扇能耗（元/月）","chengben_quzhun_1_d(grid/city)","city_code","地市编码"]
["考核指标","单载频载扇能耗（元/月）","chengben_quzhun_1_d_grid","area_code","区县编码"]
["考核指标","基站单站租金合理性","chengben_quzhun_1_e_grid","sdate","月份"]
["考核指标","基站单站租金合理性","chengben_quzhun_1_e_grid","city_name","地市名称"]
["考核指标","基站单站租金合理性","chengben_quzhun_1_e_grid","area_name","区县名称"]
["考核指标","基站单站租金合理性","chengben_quzhun_1_e_grid","station_num","租用局站数量"]
["考核指标","基站单站租金合理性","chengben_quzhun_1_e_grid","over2_num","超过2倍租费局站数量"]
["考核指标","基站单站租金合理性","chengben_quzhun_1_e_grid","over2_rate","超过2倍租费局站占比"]
["考核指标","基站单站租金合理性","chengben_quzhun_1_e_grid","city_code","地市编码"]
["考核指标","基站单站租金合理性","chengben_quzhun_1_e_grid","area_code","区县编码"]
["有合同无局站","有合同无局站","chengben_quzhun_2_city","sdate","月份"]
["有合同无局站","有合同无局站","chengben_quzhun_2_city","city","地市"]
["有合同无局站","有合同无局站","chengben_quzhun_2_city","sid","合同编号"]
["有合同无局站","有合同无局站","chengben_quzhun_2_city","sname","合同名称"]
["有合同无局站","有合同无局站","chengben_quzhun_2_city","cost_hetong","合同月租金（成本）"]
["有合同无局站","有合同无局站","chengben_quzhun_2_city","cbzx","成本中心"]
["有合同无局站","有合同无局站","chengben_quzhun_2_city","city_code","地市编码"]
["有能耗无局站","有能耗无局站","chengben_quzhun_3_city","smonth","月份"]
["有能耗无局站","有能耗无局站","chengben_quzhun_3_city","city_name","地市"]
["有能耗无局站","有能耗无局站","chengben_quzhun_3_city","build_code","局站编码"]
["有能耗无局站","有能耗无局站","chengben_quzhun_3_city","build_name","局站名称"]
["有能耗无局站","有能耗无局站","chengben_quzhun_3_city","accrued_cost","本期成本"]
["有能耗无局站","有能耗无局站","chengben_quzhun_3_city","cost_unit_name","成本中心"]
["有能耗无局站","有能耗无局站","chengben_quzhun_3_city","city_code","地市编码"]
["有铁塔订单无局站","有铁塔订单无局站","chengben_quzhun_4_city","sdate","月份"]
["有铁塔订单无局站","有铁塔订单无局站","chengben_quzhun_4_city","city_operator","地市"]
["有铁塔订单无局站","有铁塔订单无局站","chengben_quzhun_4_city","site_addr_id","铁塔站址编码"]
["有铁塔订单无局站","有铁塔订单无局站","chengben_quzhun_4_city","tower_name","铁塔站址名称"]
["有铁塔订单无局站","有铁塔订单无局站","chengben_quzhun_4_city","total_cost","铁塔费用（成本）"]
["有铁塔订单无局站","有铁塔订单无局站","chengben_quzhun_4_city","cbzx","成本中心"]
["有铁塔订单无局站","有铁塔订单无局站","chengben_quzhun_4_city","city_code","地市编码"]

{"sheet":"更新记录","index":5,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["时间","版本","更新内容"]
[20220415,"V1","初版"]
[20220417,"V1.1","【比别人】chengben_other_4_b10 增加“省份编码”字段：prov_code"]
[20220515,"V1.2","【比自己】chengben_self_2_city 增加“修理及运行维护费（省内）”字段：cost_fix_sn"]
[null,null,"【比别人】单载频载扇能耗 新增 北10 指标文件：chengben_other_2_b10"]
[null,null,"【比别人】单端口能耗 新增 北10 指标文件：chengben_other_3_b10"]
[null,null,"【比别人】铁塔单站租赁费 新增 地市 指标文件：chengben_other_4_city"]