{"text_format":"2","workbook":"xlsx","n_sheets":4,"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":84,"n_cols":6,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
["月份","名称","型号","单价","数量","总价"]
[202303,"汽车","五菱",880,1,880]
["202303 汇总",{"$nulls":4},{"$f":"SUBTOTAL(9,F2:F2)","v":880}]
[202304,"汽车","五菱",2400,1,2400]
["202304 汇总",{"$nulls":4},{"$f":"SUBTOTAL(9,F4:F4)","v":2400}]
[202305,"围挡",null,13.95,2000,{"$f":"E6*D6","v":27900}]
[202305,"支架",null,4.6500000000000004,1210,{"$f":"E7*D7","v":5626.5}]
[202305,"挖掘机",360,38380,1,{"$f":"D8","v":38380}]
[202305,"挖掘机",360,38380,1,38380]
[202305,"挖掘机",220,25250,1,25250]
[202305,"挖掘机",220,25250,1,25250]
[202305,"挖掘机",75,19190,1,19190]
[202305,"铲车",50,14645,1,14645]
[202305,"汽车","五菱",2400,1,2400]
["202305 汇总",{"$nulls":4},{"$f":"SUBTOTAL(9,F6:F14)","v":197021.5}]
[202306,"汽车","五菱",2400,1,2400]
[202306,"围挡",null,13.5,2866,{"$f":"E17*D17","v":38691}]
[202306,"支架",null,4.5,1500,{"$f":"E18*D18","v":6750}]
[202306,"护栏",null,150,50,{"$f":"E19*D19","v":7500}]
[202306,"土方运输",null,22,16550,{"$f":"E20*D20","v":364100}]
[202306,"挖掘机",360,1515,24,{"$f":"E21*D21","v":36360}]
[202306,"挖掘机",360,1515,23,34845]
[202306,"挖掘机",360,1515,23,34845]
[202306,"挖掘机",360,1515,12,18180]
[202306,"挖掘机",360,1515,12,18180]
[202306,"挖掘机",220,1010,12,12120]
[202306,"挖掘机",220,1010,24,24240]
[202306,"挖掘机",75,808,12,9696]
[202306,"铲车",50,707,23,16261]
[202306,"铲车",30,606,23,13938]
[202306,"铲车","zl-946g",808,12,9696]
[202306,"发电机","etc-50",161.6,23,3716.7999999999997]
[202306,"钢板桩租赁","9米",120,600,{"$f":"E33*D33","v":72000}]
[202306,"工字钢租赁","9米",93,1309,{"$f":"E34*D34","v":121737}]
[202306,"钢板桩打拔","9米",100,600,{"$f":"E35*D35","v":60000}]
[202306,"工字钢打拔","9米",80,2035,{"$f":"E36*D36","v":162800}]
["202306 汇总",{"$nulls":4},{"$f":"SUBTOTAL(9,F16:F36)","v":1068055.8}]
[202307,"汽车","五菱",2400,1,2400]
[202307,"围挡",null,13.95,1254,{"$f":"E39*D39","v":17493.3}]
[202307,"支架",null,4.6500000000000004,627,2915.55]
[202307,"围挡","4天",1.8,246,442.8]
[202307,"支架","4天",0.6,123,73.8]
[202307,"土方运输",null,22,17300,380600]
[202307,"钢板桩租赁","9米",124,600,74400]
[202307,"工字钢租赁","9米",96.1,1300,124929.99999999999]
[202307,"钢板桩打拔","9米",600,100,60000]
[202307,"工字钢打拔","9米",80,952,76160]
[202307,"挖掘机",360,1515,40,60600]
[202307,"挖掘机",360,1515,35,53025]
[202307,"挖掘机",360,1515,25,37875]
[202307,"挖掘机",360,1515,25,37875]
[202307,"挖掘机",360,1515,25,37875]
[202307,"挖掘机",220,1010,25,25250]
[202307,"挖掘机",220,1010,35,35350]
[202307,"挖掘机",75,808,30,{"$f":"E55*D55","v":24240}]
[202307,"铲车",50,707,35,{"$f":"E56*D56","v":24745}]
[202307,"铲车",30,606,37,{"$f":"E57*D57","v":22422}]
[202307,"铲车","zl-946g",808,34,{"$f":"E58*D58","v":27472}]
[202307,"发电机","etc-50",161.6,37,{"$f":"E59*D59","v":5979.2}]
["202307 汇总",{"$nulls":4},{"$f":"SUBTOTAL(9,F38:F59)","v":1132123.6499999999}]
[202308,"汽车","五菱",2400,1,2400]
[202308,"挖掘机",360,1515,7,{"$f":"E62*D62","v":10605}]
[202308,"围挡",null,13.5,1300,{"$f":"E63*D63","v":17550}]
[202308,"支架",null,4.5,500,{"$f":"E64*D64","v":2250}]
[202308,"钢板桩租赁","9米",124,200,{"$f":"E65*D65","v":24800}]
["202308 汇总",{"$nulls":4},{"$f":"SUBTOTAL(9,F61:F65)","v":57605}]
[202309,"汽车","五菱",2400,1,2400]
[202309,"围挡",null,13.5,1300,{"$f":"E68*D68","v":17550}]
[202309,"支架",null,4.5,500,{"$f":"E69*D69","v":2250}]
[202309,"钢板桩租赁","12米",102,320,{"$f":"E70*D70","v":32640}]
[202309,"钢板桩租赁","9米",120,200,{"$f":"E71*D71","v":24000}]
[202309,"钢板桩打拔","12米",120,420,{"$f":"E72*D72","v":50400}]
[202309,"挖掘机",360,1515,22,{"$f":"E73*D73","v":33330}]
[202309,"挖掘机",360,1515,22,33330]
[202309,"挖掘机",360,1515,11,16665]
[202309,"挖掘机",360,1515,11,16665]
[202309,"挖掘机",220,1010,21,21210]
[202309,"挖掘机",75,808,8,6464]
[202309,"铲车",50,707,21,14847]
[202309,"铲车",30,606,9,5454]
[202309,"铲车","zl-946g",808,11,8888]
[202309,"发电机","etc-50",161.6,20,3232]
["202309 汇总",{"$nulls":4},{"$f":"SUBTOTAL(9,F67:F82)","v":289325}]
["总计",{"$nulls":4},{"$f":"SUBTOTAL(9,F2:F82)","v":2747410.95}]

{"sheet":"雪花路材料","index":1,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["月份","材料名称","型号","数量","单位","单价","金额"]
[202306,"中砂",null,8438,"立方米",76.5,{"$f":"F2*D2","v":645507}]
[202306,"承插口钢筋混凝土排水管","φ800*2000",412,"米",248,102176]
[202306,"承插口钢筋混凝土排水管","φ1000*2000",238,"米",378,89964]
[202306,"承插口钢筋混凝土排水管","φ1200*2000",642,"米",560,359520]
[202306,"企口钢筋混凝土排水管","φ1400*2000",272,"米",680,184960]
[202306,"企口钢筋混凝土排水管","φ1600*2500",510,"米",850,433500]
[202306,"企口钢筋混凝土排水管","φ1800*2500",175,"米",1080,189000]
[202306,"检查井盖","φ700重型",49,"套",1050,51450]
[202306,"混凝土","C30P6",225.5,"立方米",360,81180]
[202306,"混凝土","C30P8",20,"立方米",370,7400]
[202306,"杂品费",{"$nulls":4},30703.8]
["202306 汇总",{"$nulls":5},{"$f":"SUBTOTAL(9,G2:G12)","v":2175360.7999999998}]
[202307,"中砂",null,7444,"立方米",76.5,{"$f":"F14*D14","v":569466}]
[202307,"承插口钢筋混凝土排水管","φ800*2000",64,"米",248,15872]
[202307,"承插口钢筋混凝土排水管","φ1200*2000",90,"米",560,50400]
[202307,"企口钢筋混凝土排水管","φ1400*2000",330,"米",680,224400]
[202307,"混凝土","C30P6",215.6,"立方米",360,77616]
[202307,"检查井盖","φ700重型",51,"套",1050,53550]
[202307,"企口钢筋混凝土排水管","φ1600*2500",75,"米",850,63750]
[202307,"企口钢筋混凝土排水管","φ1800*2500",25,"米",1080,27000]
[202307,"3PE钢管","φ400*8",12,"米",580,6960]
[202307,"3PE钢管","φ200*8",84,"米",263,22092]
[202307,"3PE钢管","φ300*7",24,"米",390,9360]
[202307,"钢套管","φ600*8",11,"米",570,6270]
[202307,"钢套管","φ500*8",12,"米",625,7500]
[202307,"钢套管","φ400*8",36,"米",450,16200]
[202307,"弯头（铁）","DN300*22.5°",4,"个",220,880]
[202307,"弯头（铁）","DN300*22.5°",8,"个",206,1648]
[202307,"压兰甲","DN300*22.5°",6,"个",850,5100]
[202307,"焊接法兰","DN200",11,"片",90,990]
["202307 汇总",{"$nulls":5},{"$f":"SUBTOTAL(9,G14:G31)","v":1159054}]
[202308,"中砂",null,1168,"立方米",76.5,{"$f":"F33*D33","v":89352}]
[202308,"大圈-调节块","φ700*100*360",33,"个",195,6435]
[202308,"大圈-调节块","φ700*100*240",27,"个",175,4725]
[202308,"大圈-调节块","φ700*100*180",20,"个",155,3100]
[202308,"钢筋","西钢三级φ12",42,"个",3870,162540]
[202308,"钢筋","西钢三级φ14",25,"吨",3800,95000]
[202308,"钢筋","西钢三级φ16",7,"吨",3800,26600]
[202308,"钢筋","西钢三级φ18",4,"吨",3750,15000]
[202308,"钢筋盘圆","8 300",3,"吨",3960,11880]
[202308,"杂品费",{"$nulls":4},9728.7999999999993]
["202308 汇总",{"$nulls":5},{"$f":"SUBTOTAL(9,G33:G42)","v":424360.8}]
[202309,"重型盖板","1500*1500",25,"块",450,{"$f":"F44*D44","v":11250}]
[202309,"承插口钢筋混凝土排水管","φ300*2000",544,"米",65,{"$f":"F45*D45","v":35360}]
[202309,"承插口钢筋混凝土排水管","φ1200*2000",16,"米",560,{"$f":"F46*D46","v":8960}]
[202309,"企口钢筋混凝土排水管","φ1400*2000",2,"米",680,{"$f":"F47*D47","v":1360}]
[202309,"86式雨水井",null,76,"套",450,{"$f":"F48*D48","v":34200}]
[202309,"杂品费",{"$nulls":4},8413]
[202309,"中砂",null,658,"立方米",76.5,{"$f":"F50*D50","v":50337}]
[202309,"级配碎石",null,959,"立方米",139,133301]
[202309,"二灰碎石",null,167,"立方米",1457,243319]
[202309,"三灰碎石",null,177,"立方米",1457,257889]
[202309,"混凝土","C30P6",22,"立方米",360,7920]
[202309,"混凝土","C20",120,"立方米",320,38400]
["202309 汇总",{"$nulls":5},{"$f":"SUBTOTAL(9,G44:G55)","v":830709}]
["总计",{"$nulls":5},{"$f":"SUBTOTAL(9,G2:G55)","v":4589484.5999999996}]

{"sheet":"雪花路人工","index":2,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["月份","工种","工数","单价","总价"]
[202305,"水暖工",120,400,{"$f":"D2*C2","v":48000}]
[202305,"木工",360,400,{"$f":"D3*C3","v":144000}]
[202305,"钢筋工",240,300,{"$f":"D4*C4","v":72000}]
[202305,"电工",48,300,{"$f":"D5*C5","v":14400}]
[202305,"力工",1008,180,{"$f":"D6*C6","v":181440}]
["202305 汇总",null,null,null,{"$f":"SUBTOTAL(9,E2:E6)","v":459840}]
[202306,"管道工",143,400,{"$f":"C8*D8","v":57200}]
[202306,"木工",220,400,88000]
[202306,"钢筋工",187,300,56100]
[202306,"电工",66,300,19800]
[202306,"振捣工",33,320,10560]
[202306,"力工",616,180,110880]
["202306 汇总",null,null,null,{"$f":"SUBTOTAL(9,E8:E13)","v":342540}]
[202307,"管道工",156,400,{"$f":"D15*C15","v":62400}]
[202307,"木工",240,400,96000]
[202307,"钢筋工",272,300,81600]
[202307,"电工",16,300,4800]
[202307,"力工",999,180,179820]
[202307,"振捣工",45,320,14400]
["202307 汇总",null,null,null,{"$f":"SUBTOTAL(9,E15:E20)","v":439020}]
[202308,"力工",162,180,{"$f":"C22*D22","v":29160}]
["202308 汇总",null,null,null,{"$f":"SUBTOTAL(9,E22:E22)","v":29160}]
[202309,"管道工",72,400,{"$f":"D24*C24","v":28800}]
[202309,"木工",60,400,24000]
[202309,"钢筋工",96,300,28800]
[202309,"电工",16,300,4800]
[202309,"力工",272,180,48960]
[202309,"振捣工",42,320,13440]
["202309 汇总",null,null,null,{"$f":"SUBTOTAL(9,E24:E29)","v":148800}]
["总计",null,null,null,{"$f":"SUBTOTAL(9,E2:E29)","v":1419360}]

{"sheet":"报表","index":3,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[[14,2,14,14],[15,2,15,14],[7,2,7,14],[8,2,8,14],[9,2,9,14],[0,15,0,16],[0,0,0,14],[10,2,10,14],[11,2,11,14],[12,2,12,14],[13,2,13,14]]}
["财务",{"$nulls":14},"现场"]
["序号","部门","营业收入","营业成本","税金及附加","研发费用","安全生产费","管理费用","财务费用","营业外收入","营业外支出","利润总额","所得税","净利润","利润率"]
[1,"公司",2656.21,2278.3200000000011,21.21,190.75,2.16,905.83,-57.94,1.45,109.25,{"$f":"C3-D3-E3-F3-G3-H3-I3+J3-K3","v":-791.92000000000098},227.62,{"$f":"L3-M3","v":-1019.540000000001},{"$f":"N3/C3","v":-0.3838326035968545}]
[2,"一分公司",5109.5863849999987,4613.0202019999997,23.247073,132.12133499999999,1.0227580000000001,null,null,1,null,{"$f":"C4-D4-E4-F4-G4-H4-I4+J4-K4","v":341.175016999999},null,{"$f":"L4-M4","v":341.175016999999},{"$f":"N4/C4","v":6.6771552781957538E-2}]
[3,"二分公司",1613.1,1538.62,6.77,7.1,0.49,{"$nulls":4},{"$f":"C5-D5-E5-F5-G5-H5-I5+J5-K5","v":60.120000000000019},null,60.120000000000019,3.7269853077924506E-2]
[4,"三分公司",1227.705524,834.43039999999996,6.8449710000000001,222.4819,{"$nulls":5},163.94825300000002,null,163.94825300000002,0.13354037250385462]
[4.0999999999999996,"哈尔滨新区利民片区排水设施和管网改造项目雪花路排水改造施工",992.81873199999995,834.43039999999996,{"$nulls":7},{"$f":"C7-D7-E24-F7","v":151.543361},null,null,{"$f":"L7/C7","v":0.15263950620142008},"哈尔滨新区利民片区排水设施和管网改造项目雪花路排水改造施工"]
["4.1.1","人工",137.80194299999999,{"$nulls":12},"人工",{"$f":"雪花路人工!E31/10000","v":141.93600000000001}]
["4.1.2","机械",218.627522,{"$nulls":12},"机械",{"$f":"雪花路机械!F84/10000","v":274.74109500000003}]
["4.1.3","材料",438.65604100000002,{"$nulls":12},"材料",{"$f":"雪花路材料!G57/10000","v":458.94845999999995}]
["4.1.4","其他直接费",38.375931000000001,{"$nulls":12},"其他直接费"]
["4.1.5","间接费",0.96898099999999998,{"$nulls":12},"间接费"]
["4.1.6","研发费用",222.481945,{"$nulls":12},"合计",{"$f":"SUM(Q8:Q12)","v":875.62555499999996}]
["4.1.7","安全生产费"]
["4.1.8","合计",{"$f":"SUM(C8:O14)","v":1056.9123629999999}]
["4.1.9","暂估余额",103.78]
[4.2,"哈建设发展集团有限责任公司协同办公系统采购项目",61.132075,{"$nulls":8},{"$f":"C17-D17-E17-F17","v":61.132075},null,null,{"$f":"L17/C17","v":1}]
[4.3,"哈建设发展集团有限责任公司智慧工地管理系统采购项目",32.877358000000001,{"$nulls":8},{"$f":"C18-D18-E18-F18","v":32.877358000000001},null,null,1]
[4.4000000000000004,"哈建设发展集团有限责任公司资产经营管理系统采购项目",28.094339999999999,{"$nulls":8},28.094339999999999,null,null,1]
[4.5,"哈建设发展集团有限责任公司AI智能监控平台采购项目",18.679245000000002,{"$nulls":8},18.679245000000002,null,null,1]
[4.5999999999999996,"哈建设发展集团有限责任公司市政项目管理系统采购项目",47.028301999999996,{"$nulls":8},47.028301999999996,null,null,1]
[4.7,"哈尔滨建设发展集团数字化转型支持类软件服务采购项目",47.075471999999998,{"$nulls":8},47.075471999999998,null,null,1]
[4.8,"研发费用",null,null,null,222.4819,{"$nulls":5},-222.4819]
[null,"合计",{"$f":"SUM(C17:C23)+C7","v":1227.705524},{"$f":"SUM(D7:D23)","v":834.43039999999996},6.8449710000000001,{"$f":"SUM(F7:F23)","v":222.4819},{"$nulls":5},{"$f":"SUM(L7:L23)","v":163.94825299999997},{"$f":"SUM(M7:M23)","v":0},{"$f":"SUM(N7:N23)","v":0},{"$f":"L24/C24","v":0.13354037250385456}]
[5,"直属分公司",14648.38,13759.72,34.619999999999997,78.78,0.94,{"$nulls":4},774.31999999999982,null,774.31999999999982,5.2860452828230826E-2]
[6,"环保新能源分公司",109.245615,108.982242,1.07403,0,{"$nulls":5},-0.81065699999999863,null,-0.81065699999999863,-7.4204992117990146E-3]
[7,"宾县分公司",5928.8274419999998,5521.0039049999996,32.670864000000002,33.289963999999998,3.3767,null,-6.25,null,0.35,344.38600900000017,null,344.38600900000017,5.8086697980170389E-2]
[8,"松北分公司",49.584713000000001,49.198606000000005,0.34605200000000003,0,null,null,-19.32,null,0.04,19.320054999999996,null,19.320054999999996,0.38963732632676518]
[9,"新区子公司",1437.4893850000001,1367.345599,3.43,0,2.1005500000000001,40.369999999999997,-3.19,null,null,27.43323600000009,1.6,25.833236000000088,1.7971079487310502E-2]
[10,"华光",{"$nulls":6},0.04,null,null,{"$f":"C30-D30-E30-F30-G30-H30-I30+J30-K30","v":-0.04},null,-0.04]
[null,"合并抵销差额",318.01,318.01,{"$nulls":7},0,null,0]
[null,"合    计",{"$f":"C3+C4+C5+C6+C25+C26+C27+C28+C29-C31","v":32462.119063999995},{"$f":"D3+D4+D5+D6+D25+D26+D27+D28+D29-D31","v":29752.630954},{"$f":"SUM(E25:E31)+SUM(E3:E6)","v":130.21298999999999},{"$f":"SUM(F25:F31)+SUM(F3:F6)","v":664.52319899999998},10.090008000000001,946.2,-86.66,2.4500000000000002,109.64,937.93191299999808,229.22,{"$f":"L32-M32","v":708.71191299999805},{"$f":"N32/C32","v":2.1831967026020461E-2}]