{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet2","字段映射","指标解释"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,1,18,1],[19,1,26,1],[27,1,31,1]]}
["成本指标评价体系",{"$nulls":5},"地市","网格","北10",null,"精分联系秦亚伟"]
[" 序号","指标类别"," 指标名称","北十","地市","网格",null,null,null,"需确认","接口需求","具体数据","数据接口人"]
[1,"KEI类","网运成本占收比（集团口径）","√","√","√","网格无分母","成本占收比（集团口径）","report50003",null,null,null,"赵锋","esb 84.2 集团成本"]
[2,null,"网运成本占收比（省内口径）","√","√","√","网格无分母",{"$nulls":5},"赵锋"]
[3,null,"网运成本预算完成进度（集团口径）","√",{"$nulls":4},"report50002",null,null,null,"赵锋","esb 84.2 集团成本"]
[4,null,"网运成本预算完成进度（省内口径）",null,"√",{"$nulls":4},"分子：省内口径网运成本\n分母：静态数据/2022年预算v1.xlsx",null,null,"赵锋"]
[5,null,"百元资产网运成本（集团口径）","√","√",null,"集团成本总计/资产\n表九单位是：万元",null,null,"分母：表九、固定资产原值，2、固定资产原值-网络运营线，(期初（上年底）+本期末)/2",null,null,"赵锋"]
[6,null,"百元资产网运成本（省内口径）","√","√",null,"省内口径网运成本单位是（万元）",null,null,"分母同上，分子是省内口径的网运成本",null,null,"赵锋"]
[7,null,"净资产占收比（集团口径）--百元净资产网运成本","√","√",null,"网运成本/（资产-折旧）*100\n",null,"report80054\nreport80053","表九、固定资产原值-表八、折旧及摊销=净资产",null,null,"赵锋"]
[8,null,"网络能耗占收比","√","√","√",null,"百元收入网络能耗","report50010",null,null,null,"赵锋","esb 84.2 集团成本"]
[9,null,"百元资产修理维护费","√","√",null,"分子/分母*100",null,null,"分子：省内口径-其中：修理及运行维护费\n分母：资产同上",null,null,"赵锋"]
[10,null,"修理维护费占收比（省内口径）","√","√","√","无网格数据",null,null,"分子：省内口径-其中：修理及运行维护费",null,null,"赵锋","esb 84.2 集团成本"]
[11,null,"单业务量移网成本",null,"√","√",null,null,null,"分子：集团移网+核心网\n分母：载频载扇和业务量_202203.csv（载频载扇和业务量_202203_new.xlsx）由 载频载扇/网格载频载扇202203202112.xlsx整理而来，原始数据庞翀提供，经赵锋整理","打通无线网流量系统","庞翀提供原始数据\n表2：网运成本专业分解表（网格）_v2-更新3月.xlsx","庞翀"]
[12,null,"单端口网运成本（月）",null,"√","√","网格分子分母无法关联，创建字典关联",null,null,"所有成本-移网-核心网-IDC","打通驻地网系统","驻地网系统：地市、网格用户端口数，郑龙权","成本：赵锋\n端口数：郑龙权","端口数ftt（kuandai_ftth）"]
[13,null,"单端口能耗成本（月）","√","√","√","端口数没有北10的数据；网格分子分母无法关联，创建字典关联",null,null,"所有能耗-移网-核心网-IDC","打通驻地网系统","驻地网系统：地市、网格用户端口数，郑龙权","能耗：赵锋\n端口数：郑龙权","端口数ftt（kuandai_ftth）"]
[14,null,"单载频载扇能耗（月）","√没有5G，有多少算多少","√含5G，不含5G，出2个值","√",null,"单载频载扇能耗","庞翀","移动接入网(铁塔用电服务费+能耗)+移动核心网(能耗)=总能耗\n除 载频载扇数（上年底+本期末）/2/月数","协调庞翀打通系统","庞翀提供\n表2：网运成本专业分解表（网格）_v2-更新3月.xlsx","能耗：赵锋\n载频载扇数：庞翀"]
[15,null,"活动ONU单端口能耗（月）",null,"√","√","只到地市级别",null,null,"能耗=所有能耗-移网-核心网-IDC\n郑龙权提供端口数\n静态数据/activeOnu_20220407201053.csv","打通RM系统","接入网综合网管系统：地市、网格活动ONU数取日光衰总数，月数据按日平均数据，郑龙权","能耗：赵锋\n端口：郑龙权","这个数据  因为没有历史数据  我只能给你3月最后一天的数据"]
[16,null,"单站铁塔租赁费（月）","√","√","√","金辉","铁塔单站租赁费","report50016",null,"打通集团铁塔管理系统","集团铁塔管理系统：所有数据","赵金辉"]
[17,null,"户均装机料费",null,"√","√","省内口径无网格数据；工单数表后期需要增加字段（月份、地市编码、区县编码）",null,null,"总钱数/工单数\n\n省内口径：3.客户接入成本—料费","打通公客系统","成本：网上商城，电子超市、公开市场（需与物采确认），地市、网格纬度，量* 单价，出库数为准，取量和批次、单价。\n装机用户：公客系统装、移、修工单总数，地市、网格纬度。郑龙权。后期加入修机的权重。\n取数规则：按月累计","成本：赵锋\n工单数：郑龙权","公客系统：郑龙权，本周六\n可以的我先给你一般静态数据   后期我按你们要求定制加工"]
[18,"效益类","单皮长公里线路维护费（月）","√","√","√",null,null,null,"公里数：cat baobiao_jf_yonghush |grep 光缆线路总长度\n专业分解表：皮长公里\n公式：专业分解表：单皮长公里维护费",null,"cat baobiao_jf_yonghush |grep 光缆线路总长度","赵锋"]
[19,null,"无线成本占收比","√","√","√",null,"无线网成本占收比",{"$nulls":4},"赵锋"]
[20,null,"PUE超标率",null,"√","√","能耗团队推送",null,null,"超标>1.5","打通集团能耗系统","《河北PUETOP报告1》只到2021年9月，后面没有","李世凯"]
[21,null,"转供电占比",null,"√","√","能耗团队推送",null,null,"预提明细，后续需要走接口\n分子：从分母中筛选 结算类型为：转供手抄表\n分母：表计编号非空、表状态启用、局站类型 不包含（办公楼、办公用房、营业用房）","打通集团能耗系统","电费预提明细表","李世凯"]
[22,null,"超高电价占比",null,"√","√","能耗团队推送",null,null,"预提明细，后续需要走接口\n分子：分母中电费单价>0.8\n母：表计编号非空、表状态启用、局站类型 不包含（办公楼、办公用房、营业用房）","打通集团能耗系统","电费预提明细表","李世凯"]
[23,null,"铁塔共享率",null,"√","√","金辉",null,null,null,"打通集团铁塔管理系统","铁塔管理系统：所有数据，智能电表系统推送数据","赵金辉"]
[24,null,"租赁局站占比",null,"√","√",null,null,null,"使用局站表中产权类型为“租用铁塔”+“租用第三方”作为租赁局站数","打通资源管理系统","资源系统：地市、网格局站数量，郑龙权，按产权属性，局站数量","马亮","汉佳设备机房表，算法再咨询"]
[25,null,"基站单站运行成本效益",null,"√","√","网格分子分母无法关联，创建字典关联",null,null,"分子：无线接入网所有成本+移动核心网所有成本\n分母：基站数（3+4+5）物理站，按机房算数量\n机房设备表，只要机房有无线设备，就算一个基站，（期初+期末）/2\n1月或2月作为期初数","打通资源管理系统","资源系统：地市、网格局站数量，郑龙权","成本：赵锋\n基站数：马亮","汉佳设备机房表，算法再咨询"]
[26,"效率类","H端口实占率","√用经分数据","√","√","使用baobiao_ipduankou接口数据，无北10和网格",null,null,"baobiao_ipduankou","打通驻地网系统","驻地网系统：网格实占率，郑龙权","赵锋","驻地网端口H实占率"]
[27,null,"单OLT承载用户数","√","√","√","没有北10",null,null,"郑龙权\n静态数据/单OLT承载用户数.xlsx","打通综合接入网管","接入网综合网管系统：地市、网格OLT数量（取日数据，月数据按日平均数据），郑龙权","郑龙权"]
[28,null,"单OLT承载活动ONU数",null,"√","√","只到地市级别",null,null,"郑龙权\n静态数据/oltActive_20220407200455.csv","打通综合接入网管，RM系统","接入网综合网管系统：地市、网格OLT数量（取日数据，月数据按日平均数据），活动ONU数取日光衰总数，月数据按日平均数据，郑龙权","郑龙权"]
[29,null,"单公里承载用户数","√","√","√","只到地市级别",null,null,"专业分解表：单公里承载用户数",null,null,"赵锋"]
[30,null,"单载频载扇用户数","√","√","√","只到地市级别",null,null,"找庞翀确认\n专业分解表：单载频载扇承载用户数",null,"手工，庞翀，地市、网格唯独","庞翀"]
[31,null,"宽带用户光衰质差率",null,"√","√","只到地市级别",null,null,"郑龙权\n静态数据/宽带用户光衰质差率.xlsx",null,"接入网综合网管系统：郑龙权","郑龙权"]
["合计",null,null,18,30,25,null,null,null,"专业分解表所有指标都要体现"]
[{"$nulls":9},"成本类：当年累计、上年同期、当月、上月"]

{"sheet":"Sheet2","index":1,"n_rows":45,"n_cols":1,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["指标"]
["网运成本占收比（集团）"]
["网运成本占收比（集团-含账面人工）"]
["网运成本占收比_上年（集团）"]
["网运成本占收比_上年（集团-含账面人工）"]
["百元资产网运成本（集团）"]
["网运成本占收比"]
["百元资产网运成本"]
["网运成本占收比（省内-不含外包代维）"]
["网运成本占收比（省内-不含铁塔返包、外包代维）"]
["网运成本预算完成率"]
["网运成本预算完成率（省内-不含铁塔返包、外包代维）"]
["网络能耗占收比"]
["百元资产修理维护费"]
["修理维护费占收比"]
["单端口网运成本（月）"]
["单端口能耗成本（月）"]
["单载频载扇能耗（月）"]
["百元收入网络能耗"]
["百元资产网络能耗成本"]
["租赁费占收比（不含IDC/云计算结算）"]
["百元资产修理维护费"]
["铁塔租赁费占收比"]
["铁塔用电服务费占收比"]
["无线接入网非铁塔能耗占收比"]
["第三方基站租赁费占收比"]
["无线网代维成本占收比"]
["网优服务费占收比"]
["维保费占收比"]
["单皮长公里线路维护费（月）"]
["无线接入网成本占收比"]
["固网成本占收比"]
["H端口实占率"]
["单公里承载用户数"]
["单载频载扇用户数"]
["单站铁塔租赁费（月）"]
["单站址能耗成本（月）"]
["5G单站能耗成本（月）"]
["单站址修理维护费（月）"]
["单新增用户终端成本"]
["单新增用户工料费成本"]
["IDC&云计算网运成本占收比"]
["单OLT承载用户数"]
["单载频载扇能耗（月）-网格"]
["单端口能耗成本（月）-网格"]

{"sheet":"字段映射","index":2,"n_rows":121,"n_cols":6,"rows_kept":121,"cut":false,"hidden":false,"merged":[]}
[null,"一级表头","二级表头","三级表头","数据库字段","专业分解表合计公式"]
[{"$f":"C2&\"_\"&D2","v":"总计_总计"},"总计","总计","总计","column1",{"$error":"#N/A"}]
[{"$f":"C3&\"_\"&D3","v":"移动无线接入网_铁塔租赁费"},"移动业务","移动无线接入网","铁塔租赁费","column2","column2"]
["移动无线接入网_铁塔维护费","移动业务","移动无线接入网","铁塔维护费","column3","column3"]
["移动无线接入网_铁塔用电服务费","移动业务","移动无线接入网","铁塔用电服务费","column4","column4"]
["移动无线接入网_能耗","移动业务","移动无线接入网","能耗","column5","column5"]
["移动无线接入网_维保","移动业务","移动无线接入网","维保","column6","column6"]
["移动无线接入网_代维","移动业务","移动无线接入网","代维","column7","column7"]
["移动无线接入网_紧密型外包人工成本","移动业务","移动无线接入网","紧密型外包人工成本","column8","column8"]
["移动无线接入网_网优","移动业务","移动无线接入网","网优","column9","column9"]
["移动无线接入网_修理","移动业务","移动无线接入网","修理","column10","column10"]
["移动无线接入网_耗材","移动业务","移动无线接入网","耗材","column11","column11"]
["移动无线接入网_房屋及建筑物租赁费","移动业务","移动无线接入网","房屋及建筑物租赁费","column12","column12"]
["移动无线接入网_共建共享租赁费","移动业务","移动无线接入网","共建共享租赁费","column13","column13"]
["移动无线接入网_电路网元租赁费","移动业务","移动无线接入网","电路网元租赁费","column14","column14"]
["移动无线接入网_设备租赁费","移动业务","移动无线接入网","设备租赁费","column15","column15"]
["移动无线接入网_其他租赁费","移动业务","移动无线接入网","其他租赁费","column16","column16"]
["移动无线接入网_频占费","移动业务","移动无线接入网","频占费","column17","column17"]
["移动无线接入网_账面人工成本","移动业务","移动无线接入网","账面人工成本","column18",{"$error":"#N/A"}]
["移动核心网_能耗","移动业务","移动核心网","能耗","column19","column19"]
["移动核心网_维保","移动业务","移动核心网","维保","column20","column20"]
["移动核心网_代维","移动业务","移动核心网","代维","column21","column21"]
["移动核心网_紧密型外包人工成本","移动业务","移动核心网","紧密型外包人工成本","column22","column22"]
["移动核心网_修理","移动业务","移动核心网","修理","column23","column23"]
["移动核心网_耗材","移动业务","移动核心网","耗材","column24","column24"]
["移动核心网_租赁费","移动业务","移动核心网","租赁费","column25","column25"]
["移动核心网_账面人工成本","移动业务","移动核心网","账面人工成本","column26",{"$error":"#N/A"}]
["宽带接入_能耗","固话宽带业务","宽带接入","能耗","column27","column27"]
["宽带接入_维保","固话宽带业务","宽带接入","维保","column28","column28"]
["宽带接入_代维","固话宽带业务","宽带接入","代维","column29","column29"]
["宽带接入_紧密型外包人工成本","固话宽带业务","宽带接入","紧密型外包人工成本","column30","column30"]
["宽带接入_修理","固话宽带业务","宽带接入","修理","column31","column31"]
["宽带接入_耗材","固话宽带业务","宽带接入","耗材","column32","column32"]
["宽带接入_装维工料费","固话宽带业务","宽带接入","装维工料费","column33","column33"]
["宽带接入_终端成本","固话宽带业务","宽带接入","终端成本","column34","column34"]
["宽带接入_房屋及建筑物租赁费","固话宽带业务","宽带接入","房屋及建筑物租赁费","column35","column35"]
["宽带接入_共建共享租赁费","固话宽带业务","宽带接入","共建共享租赁费","column36","column36"]
["宽带接入_电路网元租赁费","固话宽带业务","宽带接入","电路网元租赁费","column37","column37"]
["宽带接入_设备租赁费","固话宽带业务","宽带接入","设备租赁费","column38","column38"]
["宽带接入_其他租赁费","固话宽带业务","宽带接入","其他租赁费","column39","column39"]
["宽带接入_账面人工成本","固话宽带业务","宽带接入","账面人工成本","column40",{"$error":"#N/A"}]
["固话语音网（含核心网）_能耗","固话宽带业务","固话语音网（含核心网）","能耗","column41","column41"]
["固话语音网（含核心网）_维保","固话宽带业务","固话语音网（含核心网）","维保","column42","column42"]
["固话语音网（含核心网）_代维","固话宽带业务","固话语音网（含核心网）","代维","column43","column43"]
["固话语音网（含核心网）_紧密型外包人工成本","固话宽带业务","固话语音网（含核心网）","紧密型外包人工成本","column44","column44"]
["固话语音网（含核心网）_修理","固话宽带业务","固话语音网（含核心网）","修理","column45","column45"]
["固话语音网（含核心网）_耗材","固话宽带业务","固话语音网（含核心网）","耗材","column46","column46"]
["固话语音网（含核心网）_租赁费","固话宽带业务","固话语音网（含核心网）","租赁费","column47","column47"]
["固话语音网（含核心网）_账面人工成本","固话宽带业务","固话语音网（含核心网）","账面人工成本","column48",{"$error":"#N/A"}]
["IP/数据_能耗","共用基础网络","IP/数据","能耗","column49","column49"]
["IP/数据_维保","共用基础网络","IP/数据","维保","column50","column50"]
["IP/数据_代维","共用基础网络","IP/数据","代维","column51","column51"]
["IP/数据_紧密型外包人工成本","共用基础网络","IP/数据","紧密型外包人工成本","column52","column52"]
["IP/数据_日修","共用基础网络","IP/数据","日修","column53","column53"]
["IP/数据_耗材","共用基础网络","IP/数据","耗材","column54","column54"]
["IP/数据_租赁费","共用基础网络","IP/数据","租赁费","column55","column55"]
["IP/数据_账面人工成本","共用基础网络","IP/数据","账面人工成本","column56",{"$error":"#N/A"}]
["传输_能耗","共用基础网络","传输","能耗","column57","column57"]
["传输_维保","共用基础网络","传输","维保","column58","column58"]
["传输_代维","共用基础网络","传输","代维","column59","column59"]
["传输_紧密型外包人工成本","共用基础网络","传输","紧密型外包人工成本","column60","column60"]
["传输_日修","共用基础网络","传输","日修","column61","column61"]
["传输_耗材","共用基础网络","传输","耗材","column62","column62"]
["传输_租赁费","共用基础网络","传输","租赁费","column63","column63"]
["传输_账面人工成本","共用基础网络","传输","账面人工成本","column64",{"$error":"#N/A"}]
["线路(一干、二干、本地网)_代维","共用基础网络","线路(一干、二干、本地网)","代维","column65","column65"]
[{"$f":"C67&\"_\"&D67","v":"线路(一干、二干、本地网)_紧密型外包人工成本"},"共用基础网络","线路(一干、二干、本地网)","紧密型外包人工成本","column66","column66"]
["线路(一干、二干、本地网)_修理","共用基础网络","线路(一干、二干、本地网)","修理","column67","column67"]
["线路(一干、二干、本地网)_耗材","共用基础网络","线路(一干、二干、本地网)","耗材","column68","column68"]
["线路(一干、二干、本地网)_账面人工成本","共用基础网络","线路(一干、二干、本地网)","账面人工成本","column69",{"$error":"#N/A"}]
["业务平台_能耗","共用基础网络","业务平台","能耗","column70","column70"]
["业务平台_维保","共用基础网络","业务平台","维保","column71","column71"]
["业务平台_代维","共用基础网络","业务平台","代维","column72","column72"]
["业务平台_紧密型外包人工成本","共用基础网络","业务平台","紧密型外包人工成本","column73","column73"]
["业务平台_修理","共用基础网络","业务平台","修理","column74","column74"]
["业务平台_耗材","共用基础网络","业务平台","耗材","column75","column75"]
["业务平台_租赁费","共用基础网络","业务平台","租赁费","column76","column76"]
["业务平台_账面人工成本","共用基础网络","业务平台","账面人工成本","column77",{"$error":"#N/A"}]
["IT（OSS系统）_能耗","共用基础网络","IT（OSS系统）","能耗","column78","column78"]
["IT（OSS系统）_维保","共用基础网络","IT（OSS系统）","维保","column79","column79"]
["IT（OSS系统）_代维","共用基础网络","IT（OSS系统）","代维","column80","column80"]
["IT（OSS系统）_日修","共用基础网络","IT（OSS系统）","日修","column81","column81"]
["IT（OSS系统）_耗材","共用基础网络","IT（OSS系统）","耗材","column82","column82"]
["IT（OSS系统）_租赁费","共用基础网络","IT（OSS系统）","租赁费","column83","column83"]
["IT（OSS系统）_账面人工成本","共用基础网络","IT（OSS系统）","账面人工成本","column84",{"$error":"#N/A"}]
["IT（OSS系统）_紧密型外包人工成本","共用基础网络","IT（OSS系统）","紧密型外包人工成本","column85","column85"]
["配套设施_能耗","共用基础网络","配套设施","能耗","column86","column86"]
["配套设施_维保","共用基础网络","配套设施","维保","column87","column87"]
["配套设施_代维","共用基础网络","配套设施","代维","column88","column88"]
["配套设施_紧密型外包人工成本","共用基础网络","配套设施","紧密型外包人工成本","column89","column89"]
["配套设施_修理","共用基础网络","配套设施","修理","column90","column90"]
["配套设施_耗材","共用基础网络","配套设施","耗材","column91","column91"]
["配套设施_租赁费","共用基础网络","配套设施","租赁费","column92","column92"]
["配套设施_账面人工成本","共用基础网络","配套设施","账面人工成本","column93",{"$error":"#N/A"}]
["国际业务_能耗","共用基础网络","国际业务","能耗","column94","column94"]
["国际业务_租赁费（含国际互联网、国际漫游平台、OUTBOUND）\"","共用基础网络","国际业务","租赁费（含国际互联网、国际漫游平台、OUTBOUND）\"","column95","column95"]
["国际业务_维护费","共用基础网络","国际业务","维护费","column96","column96"]
["国际业务_紧密型外包人工成本","共用基础网络","国际业务","紧密型外包人工成本","column97","column97"]
["国际业务_账面人工成本","共用基础网络","国际业务","账面人工成本","column98",{"$error":"#N/A"}]
["其他成本费用_规费、行政办公费、办公差旅费、车辆使用费、物业管理费、业务材料费","共用基础网络","其他成本费用","规费、行政办公费、办公差旅费、车辆使用费、物业管理费、业务材料费","column99","column99"]
["非分摊共用_非分摊共用能耗成本","共用基础网络","非分摊共用","非分摊共用能耗成本","column100","column100"]
["非分摊共用_非分摊共用维保","共用基础网络","非分摊共用","非分摊共用维保","column101","column101"]
["非分摊共用_非分摊共用代维","共用基础网络","非分摊共用","非分摊共用代维","column102","column102"]
["非分摊共用_非分摊共用修理","共用基础网络","非分摊共用","非分摊共用修理","column103","column103"]
["非分摊共用_非分摊共用耗材","共用基础网络","非分摊共用","非分摊共用耗材","column104","column104"]
["非分摊共用_非分摊共用租赁费","共用基础网络","非分摊共用","非分摊共用租赁费","column105","column105"]
["非分摊共用_非分摊共用紧密型外包人工成本","共用基础网络","非分摊共用","非分摊共用紧密型外包人工成本","column106","column106"]
["非分摊共用_非分摊共用账面人工成本","共用基础网络","非分摊共用","非分摊共用账面人工成本","column107",{"$error":"#N/A"}]
["IDC业务/云计算_IDC能耗","集客业务","IDC业务/云计算","IDC能耗","column108","column108"]
["IDC业务/云计算_IDC维护费","集客业务","IDC业务/云计算","IDC维护费","column109","column109"]
["IDC业务/云计算_紧密型外包人工成本","集客业务","IDC业务/云计算","紧密型外包人工成本","column110","column110"]
["IDC业务/云计算_IDC租赁费","集客业务","IDC业务/云计算","IDC租赁费","column111","column111"]
["IDC业务/云计算_其他（IDC结算费用）","集客业务","IDC业务/云计算","其他（IDC结算费用）","column112","column112"]
["IDC业务/云计算_其他（云计算结算费用）","集客业务","IDC业务/云计算","其他（云计算结算费用）","column113","column113"]
["IDC业务/云计算_账面人工成本","集客业务","IDC业务/云计算","账面人工成本","column114",{"$error":"#N/A"}]
["专线_能耗","集客业务","专线","能耗","column115","column115"]
["专线_维护费","集客业务","专线","维护费","column116","column116"]
["专线_紧密型外包人工成本","集客业务","专线","紧密型外包人工成本","column117","column117"]
["专线_租赁费","集客业务","专线","租赁费","column118","column118"]
["专线_账面人工成本","集客业务","专线","账面人工成本","column119",{"$error":"#N/A"}]
["其他_其他","其他","其他","其他","column120","column120"]

{"sheet":"指标解释","index":3,"n_rows":74,"n_cols":7,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[" 指标编号","指标类别","指标名称","维度","分子来源","分母来源","公式"]
[1,"KEI类","网运成本占收比（集团口径）","北10","集团成本接口数据-31省占收比-report50003-column6（网络运维成本合计（含人工）本年累计）","集团成本接口数据-31省占收比-report50003-column14（主营业务收入本年累计）","分子/分母"]
[1,"KEI类","网运成本占收比（集团口径）","地市","集团成本接口数据-单表-report50-column1（网运成本合计）","集团成本接口数据-表1、分省主要指标-report80040-column4（一、主营业务收入-同比变动-本年累计）","分子/分母"]
[1,"KEI类","网运成本占收比（集团口径）","网格","集团成本接口数据-单表-report49-column1","暂无","分子/分母"]
[2,"KEI类","网运成本占收比（省内口径）","北10","财务报表-北十-网运成本","财务报表-北十-主营业务收入","分子/分母"]
[2,"KEI类","网运成本占收比（省内口径）","地市","财务报表-省内-网运成本","财务报表-省内-主营业务收入","分子/分母"]
[2,"KEI类","网运成本占收比（省内口径）","网格","暂无","暂无","分子/分母"]
[3,"KEI类","网运成本预算完成进度（集团口径）","北10","集团成本接口数据-31省预算完成率-report50002-column1（网运成本）","集团成本接口数据-31省预算完成率-report50002-column2（本年预算）","分子/分母"]
[4,"KEI类","网运成本预算完成进度（省内口径）","地市","财务报表-省内-网运成本","2022年预算v1.xlsx","分子/分母"]
[5,"KEI类","百元资产网运成本（集团口径）","北10","集团成本接口数据-单表-report50-column1（网运成本合计）","集团成本接口数据-表九、固定资产原值-report80054（(column7+column8)/2）（表九、固定资产原值-2、固定资产原值-网络运营线（上年底+本期末）/2)","分子/分母*100"]
[5,"KEI类","百元资产网运成本（集团口径）","地市","集团成本接口数据-单表-report50-column1（网运成本合计）","集团成本接口数据-表九、固定资产原值-report80054（(column7+column8)/2）（表九、固定资产原值-2、固定资产原值-网络运营线（上年底+本期末）/2)","分子/分母*100"]
[6,"KEI类","百元资产网运成本（省内口径）","北10","财务报表-北十-网运成本","集团成本接口数据-表九、固定资产原值-report80054（(column7+column8)/2）（表九、固定资产原值-2、固定资产原值-网络运营线（上年底+本期末）/2)","分子/分母*100"]
[6,"KEI类","百元资产网运成本（省内口径）","地市","财务报表-省内-网运成本","集团成本接口数据-表九、固定资产原值-report80054（(column7+column8)/2）（表九、固定资产原值-2、固定资产原值-网络运营线（上年底+本期末）/2)","分子/分母*100"]
[7,"KEI类","百元净资产网运成本","北10","集团成本接口数据-单表-report50-column1（网运成本合计）","集团成本接口数据(report80054.column7+report80054.column8)/2）-report80053.column16（表九、固定资产原值-表八、折旧及摊销）","分子/分母*100"]
[7,"KEI类","百元净资产网运成本","地市","集团成本接口数据-单表-report50-column1（网运成本合计）","集团成本接口数据(report80054.column7+report80054.column8)/2）-report80053.column16（表九、固定资产原值-表八、折旧及摊销）","分子/分母*100"]
[8,"KEI类","网络能耗占收比","北10","集团成本接口数据-百元收入网络能耗成本-report50010-column1（网络能耗成本合计本年累计）","集团成本接口数据-百元收入网络能耗成本-report50010-column5（主营业务收入本年累计）","分子/分母"]
[8,"KEI类","网络能耗占收比","地市","集团成本接口数据-单表-report50-（column5+column19+column27+column41+column49+column57+column70+column78+column86+column94+column100+column108+column115）（网络能耗成本合计本年累计）","集团成本接口数据-表1、分省主要指标-report80040-column4（一、主营业务收入-同比变动-本年累计）","分子/分母"]
[8,"KEI类","网络能耗占收比","网格","集团成本接口数据-单表-report49-（column5+column19+column27+column41+column49+column57+column70+column78+column86+column94+column100+column108+column115）（网络能耗成本合计本年累计）","暂无","分子/分母"]
[9,"KEI类","百元资产修理维护费","北10","财务报表-北十-其中：修理及运行维护费","集团成本接口数据-表九、固定资产原值-report80054（(column7+column8)/2）（表九、固定资产原值-2、固定资产原值-网络运营线（上年底+本期末）/2)","分子/分母*100"]
[9,"KEI类","百元资产修理维护费","地市","财务报表-省内-其中：修理及运行维护费","集团成本接口数据-表九、固定资产原值-report80054（(column7+column8)/2）（表九、固定资产原值-2、固定资产原值-网络运营线（上年底+本期末）/2)","分子/分母*100"]
[10,"KEI类","修理维护费占收比（省内口径）","北10","财务报表-北十-其中：修理及运行维护费","财务报表-北十-主营业务收入","分子/分母"]
[10,"KEI类","修理维护费占收比（省内口径）","地市","财务报表-省内-其中：修理及运行维护费","财务报表-省内-主营业务收入","分子/分母"]
[10,"KEI类","修理维护费占收比（省内口径）","网格","暂无","暂无","分子/分母"]
[11,"KEI类","单业务量移网成本","地市","集团成本接口数据移网+核心网成本","表2：网运成本专业分解表（网格）_v2-网格业务量汇聚成地市，（期初+期末）/2","分子/分母"]
[11,"KEI类","单业务量移网成本","网格","集团成本接口数据移网+核心网成本","表2：网运成本专业分解表（网格）_v2-网格业务量，（期初+期末）/2","分子/分母"]
[12,"KEI类","单端口网运成本（月）","地市","集团成本接口数据（所有成本-移网-核心网-IDC）","baobiao_ipduankou，端口数*端口实占率","分子/分母/月份"]
[12,"KEI类","单端口网运成本（月）","网格","集团成本接口数据（所有成本-移网-核心网-IDC）","kuandai_ftth，ftth_port_sts_count（FTTH实占端口数）","分子/分母/月份"]
[13,"KEI类","单端口能耗成本（月）","北10","集团成本接口数据（所有能耗-移网-核心网-IDC）","移动业务发展及业务量本月月报分省-IP接入端口总数，端口数*端口实占率","分子/分母/月份"]
[13,"KEI类","单端口能耗成本（月）","地市","集团成本接口数据（所有能耗-移网-核心网-IDC）","baobiao_ipduankou，端口数*端口实占率","分子/分母/月份"]
[13,"KEI类","单端口能耗成本（月）","网格","集团成本接口数据（所有能耗-移网-核心网-IDC）","kuandai_ftth，ftth_port_sts_count（FTTH实占端口数）","分子/分母/月份"]
[14,"KEI类","单载频载扇能耗（月）","北10","集团成本接口数据，移动接入网(铁塔用电服务费+能耗)+移动核心网(能耗)","通信能力主要指标分省月报-（GSM载频数(万个)+WCDMA载扇数量(万个)+LTE FDD基站载扇数量(个)/10000+TD-LTE基站载扇数量(个)/10000）,(期初+期末)/2","分子/分母/月份"]
[14,"KEI类","单载频载扇能耗（月）","地市","集团成本接口数据，移动接入网(铁塔用电服务费+能耗)+移动核心网(能耗)","表1：载频载扇数据－2022年V2，2345g载频载扇数量总和，(期初+期末)/2","分子/分母/月份"]
[14,"KEI类","单载频载扇能耗（月）","网格","集团成本接口数据，移动接入网(铁塔用电服务费+能耗)+移动核心网(能耗)","表2：网运成本专业分解表（网格）_v2，2345g载频载扇数量总和，(期初+期末)/2","分子/分母/月份"]
[15,"KEI类","活动ONU单端口能耗（月）","地市","集团成本接口数据（所有能耗-移网-核心网-IDC）","esb提供","分子/分母"]
[15,"KEI类","活动ONU单端口能耗（月）","网格","暂无","暂无","分子/分母"]
[16,"KEI类","单站铁塔租赁费（月）","北10","集团成本接口数据，本年单站铁塔租赁费-report50016-column2（本年累计铁塔租赁维护费）","集团成本接口数据，本年单站铁塔租赁费-report50016-column5（平均站址数）","分子/分母/月份"]
[16,"KEI类","单站铁塔租赁费（月）","地市","集团成本接口数据，column2（铁塔租赁费）+column3（铁塔维护费）","铁塔订单站址数（上年底+本期末）/2","分子/分母/月份"]
[16,"KEI类","单站铁塔租赁费（月）","网格","集团成本接口数据，column2（铁塔租赁费）+column3（铁塔维护费）","铁塔订单站址数（上年底+本期末）/2","分子/分母/月份"]
[17,"KEI类","户均装机料费","地市","财务报表-省内-客户接入成本—料费","esb提供","分子/分母"]
[17,"KEI类","户均装机料费","网格","暂无","esb提供","分子/分母"]
[18,"效益类","单皮长公里线路维护费（月）","北10","集团成本接口数据，线路维护费","通信能力主要指标分省月报-光缆总长度(万皮长公里)","分子/分母/月份"]
[18,"效益类","单皮长公里线路维护费（月）","地市","集团成本接口数据，线路维护费","接口数据baobiao_jf_yonghush-光缆总长度","分子/分母/月份"]
[18,"效益类","单皮长公里线路维护费（月）","网格","集团成本接口数据，线路维护费","暂无","分子/分母/月份"]
[19,"效益类","无线成本占收比","北10","集团成本接口数据，移动无线接入网全部成本（不含账面人工）","集团成本接口数据-表1、分省主要指标-report80040-column4（一、主营业务收入-同比变动-本年累计）","分子/分母"]
[19,"效益类","无线成本占收比","地市","集团成本接口数据，移动无线接入网全部成本（不含账面人工）","集团成本接口数据-表1、分省主要指标-report80040-column4（一、主营业务收入-同比变动-本年累计）","分子/分母"]
[19,"效益类","无线成本占收比","网格","集团成本接口数据，移动无线接入网全部成本（不含账面人工）","暂无","分子/分母"]
[20,"效益类","PUE超标率","地市","河北PUETOP报告1，pue>1.5数量","河北PUETOP报告1","分子/分母"]
[20,"效益类","PUE超标率","网格","河北PUETOP报告1，pue>1.5数量","河北PUETOP报告1","分子/分母"]
[21,"效益类","转供电占比","地市","预提明细局站级电量电费统计（不含办公楼、办公用房、营业用房）-转供手抄表 局站个数","预提明细局站级电量电费统计-全部局站（不含办公楼、办公用房、营业用房）","分子/分母"]
[21,"效益类","转供电占比","网格","预提明细局站级电量电费统计（不含办公楼、办公用房、营业用房）-转供手抄表 局站个数","预提明细局站级电量电费统计-全部局站（不含办公楼、办公用房、营业用房）","分子/分母"]
[22,"效益类","超高电价占比","地市","预提明细局站级电量电费统计（不含办公楼、办公用房、营业用房）(本期成本/本期电量)>0.8局站个数","预提明细局站级电量电费统计-全部局站（不含办公楼、办公用房、营业用房）","分子/分母"]
[22,"效益类","超高电价占比","网格","预提明细局站级电量电费统计（不含办公楼、办公用房、营业用房）(本期成本/本期电量)>0.8局站个数","预提明细局站级电量电费统计-全部局站（不含办公楼、办公用房、营业用房）","分子/分母"]
[23,"效益类","铁塔共享率","地市","铁塔订单（新建及共享改造、存量注入）共享站点","铁塔订单（新建及共享改造、存量注入）全部站点","分子/分母"]
[23,"效益类","铁塔共享率","网格","铁塔订单（新建及共享改造、存量注入）共享站点","铁塔订单（新建及共享改造、存量注入）全部站点","分子/分母"]
[24,"效益类","租赁局站占比","地市","资源系统租赁铁塔+租赁第三方局站个数","资源系统全量局站个数","分子/分母"]
[24,"效益类","租赁局站占比","网格","资源系统租赁铁塔+租赁第三方局站个数","资源系统全量局站个数","分子/分母"]
[25,"效益类","基站单站运行成本效益","地市","集团成本接口数据，无线接入网所有成本+移动核心网所有成本","汉佳设备表equip有无线设备的机房数量（期初+期末)/2","分子/分母/月份"]
[25,"效益类","基站单站运行成本效益","网格","集团成本接口数据，无线接入网所有成本+移动核心网所有成本","汉佳设备表equip有无线设备的机房数量（期初+期末)/2","分子/分母/月份"]
[26,"效率类","H端口实占率","北10","移动业务发展及业务量本月月报分省-IP接入端口总数，在用端口数","移动业务发展及业务量本月月报分省-IP接入端口总数，端口数","分子/分母"]
[26,"效率类","H端口实占率","地市","baobiao_ipduankou，在用端口数","baobiao_ipduankou，端口数","分子/分母"]
[26,"效率类","H端口实占率","网格","kuandai_ftth，ftth_port_sts_count（FTTH实占端口数）","kuandai_ftth，ftth_port_count（FTTH总端口数）","分子/分母"]
[27,"效率类","单OLT承载用户数","北10","暂无","暂无","暂无"]
[27,"效率类","单OLT承载用户数","地市","esb提供","esb提供","esb提供"]
[27,"效率类","单OLT承载用户数","网格","esb提供","esb提供","esb提供"]
[28,"效率类","单OLT承载活动ONU数","地市","esb提供","esb提供","esb提供"]
[28,"效率类","单OLT承载活动ONU数","网格","暂无","暂无","暂无"]
[29,"效率类","单公里承载用户数","北10","北10报表（固网用户数+移网用户数）","通信能力主要指标分省月报-光缆总长度(万皮长公里)((期初+期末)/2)","分子/分母"]
[29,"效率类","单公里承载用户数","地市","接口数据baobiao_jf_yonghush-宽带用户数+移网用户数","接口数据baobiao_jf_yonghush-光缆总长度((期初+期末)/2)","分子/分母"]
[29,"效率类","单公里承载用户数","网格","暂无","暂无","分子/分母"]
[30,"效率类","单载频载扇用户数","北10","北10报表（移网用户数）","通信能力主要指标分省月报-（GSM载频数(万个)+WCDMA载扇数量(万个)+LTE FDD基站载扇数量(个)/10000+TD-LTE基站载扇数量(个)/10000）,(期初+期末)/2","分子/分母"]
[30,"效率类","单载频载扇用户数","地市","接口数据baobiao_jf_yonghush-移网用户数","表1：载频载扇数据－2022年V2，2345g载频载扇数量总和，(期初+期末)/2","分子/分母"]
[30,"效率类","单载频载扇用户数","网格","暂无","暂无","分子/分母"]
[31,"效率类","宽带用户光衰质差率","地市","esb提供","esb提供","esb提供"]
[31,"效率类","宽带用户光衰质差率","网格","暂无","暂无","暂无"]