{"text_format":"2","workbook":"xlsx","n_sheets":9,"sheets":["合同","在建项目情况","采购","趋势","经营目标分解","已完工工程回款","产值计划表","经营指标","在建工程回款"],"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":"合同","index":0,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["企业新签合同汇总表"]
["所属公司","权属","工程名称","合同金额（万元）","开竣工日期","签订合同日期","建设单位"]
["市政一","三分公司","雪花路",5000,"2023-01-01","2022-12-31","哈尔滨XXX集团有限公司"]

{"sheet":"在建项目情况","index":1,"n_rows":3,"n_cols":16,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,15]]}
["在建项目汇总"]
["所属公司","权属","工程名","项目简称","项目简介","合同金额（万元）","来源","项目进度","状态","设计单位","施工单位","监理单位","建设单位","建设地点","计划开竣工时间","项目经理"]
["市政一","三分公司","雪花路","雪花路","呼兰区雪花路（K0+008.282~K0+720）：工程全长 711.718 米，红线宽度 40 米。包括道路、绿化、排水等附属工程。",5000,"中标",0.3,"在建","中国市政工程华北设计研究总院有限公司","哈尔滨市第一市政工程有限公司","哈尔滨执信建设项目管理咨询有限公司","市政一","哈尔滨综合保税区管理委员会","2022年08月31日--2023年08月30日","王飞"]

{"sheet":"采购","index":2,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["阳光采购分析（2023年二季度）"]
["公司名称","权属","采购项目名称","采购内容","采购方式","成交单位","项目预算金额（元）","中标金额（元）","节约金额（元）"]
["市政一","三分","雪花路混凝土采购","商品混凝土","集采","哈尔滨三一商品混凝土有限公司",680870,667620,{"$f":"G3-H3","v":13250}]
{"$rows_empty":9}
["填表说明：采购方式是委采、自采、集采等"]

{"sheet":"趋势","index":3,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["经营趋势汇总"]
["年度","营业收入（万元）","利润总额（万元）","净资产收益率","成本费用营收比率","资产负债率","全员劳动生产率","营业现金比率"]
[2022,91756.665399999998]
[2021,30527.524700000002]
[2020,30151.0664]

{"sheet":"经营目标分解","index":4,"n_rows":4,"n_cols":28,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,22,0,23],[0,24,0,25],[0,26,0,27],[0,0,1,0],[0,1,1,1],[0,12,0,13],[0,14,0,15],[0,16,0,17],[0,18,0,19],[0,20,0,21],[0,2,0,3],[0,4,0,5],[0,6,0,7],[0,8,0,9],[0,10,0,11]]}
["指标名称","预计全年完成营业收入\n（万元）","1月",null,"2月",null,"3月",null,"4月",null,"5月",null,"6月",null,"7月",null,"8月",null,"9月",null,"10月",null,"11月",null,"12月",null,"1-12月"]
[null,null,"已完成","占比%","已完成","占比%","已完成","占比%","预计完成","占比%","预计完成","占比%","预计完成","占比%","预计完成","占比%","预计完成","占比%","预计完成","占比%","预计完成","占比%","已完成数","占比%","预计完成","占比%","预计完成","占比%"]
["营业收入",84500,2139,{"$f":"C3/B3*100","v":2.5313609467455622}]
["利润总额",3380,156,{"$f":"C4/B4*100","v":4.6153846153846159}]

{"sheet":"已完工工程回款","index":5,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,9,2,9]]}
["已完工工程回款汇总"]
["所属公司","权属","项目名称","合同金额/结算金额","截止上月末累计已收款","本月收回应收账款","截至本月末累计已收款","累计收款比例","应收账款","备注"]
[null,null,null,"（1）","（2）","（3）","（4）=（2）+（3）","（5）=（4）/（1）","（6）=（1）-（4）"]

{"sheet":"产值计划表","index":6,"n_rows":3,"n_cols":18,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,17],[1,5,1,10],[1,11,1,16],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,17,2,17]]}
["产值计划表汇总"]
["所属公司","权属","工程项目名称","合同额（万元）","上年结\n转金额","已完产值",{"$nulls":5},"每月计划完成产值",{"$nulls":5},"预计结转下年金额"]
[{"$nulls":5},"1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月"]

{"sheet":"经营指标","index":7,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["经营指标数据"]
["指标","新签合同额（万元）","营业收入\n（万元）","利润总额\n（万元）","净资产收益率","成本费用营收比率","资产负债率","全员劳动生产率","营业现金比率"]
["值",5300,5000]
["同比状态","增长","增长"]
["同比值",0.31,0.7]
[]
["例如：营业收入已实现5000万元，同比增长70%"]

{"sheet":"在建工程回款","index":8,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,12,2,12],[1,13,2,13]]}
["在建工程回款汇总"]
["序号","公司名称","工程名称","合同（中标）/结算金额","合同约定\n付款比例","进度/竣工结算额","完工/完成\n百分比","本月收款","本月收款后\n累计收款额","累计收款额占进度/竣工结算额比例","合同约定\n应收账款","合同约定\n预收账款","政府类/非政府类","已结算/未结算"]
[null,null,null,"（1）","（2）","(3)","（4）=（3）/(1)","（5）","（6）=Σ（5）","（7)=(6)/(3)","(8)=(3)×（2）-(7)","(9)=(3)×（2）-(7)"]
[1,"市政一公司","雪花路",0,0,0,0,0,0,0,0,0]