{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["项目概况","控制价分析表","成本分析清单"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"项目概况","index":0,"n_rows":19,"n_cols":9,"rows_kept":19,"hidden":true,"merged":[[0,0,0,8],[1,0,1,8],[2,1,2,8],[3,1,3,8],[4,1,4,8],[5,1,5,8],[6,0,6,8],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,7,5],[7,6,8,6],[7,7,8,7],[7,8,8,8],[10,4,12,4],[10,5,12,5],[10,6,12,6],[10,7,12,7],[10,8,12,8],[13,2,13,7],[14,2,14,7],[15,2,15,7],[16,2,16,7],[17,1,17,8],[18,1,18,8]]}
["项目成本测算信息一览表"]
["一、项目概况表"]
["项目（子项）名称：","隆润朗景台项目-基坑边坡支护工程专业分包"]
["建设内容："]
["项目类型："]
["估算成本"]
["二、成本分析表"]
["序号","内容","估算成本","成本控制价","其中（含税）",null,"税金","各项占比","备 注"]
[{"$nulls":4},"分项","金额"]
["一","建设工程控制总价","/",{"$f":"SUM(D11:D13)","v":1239848.85},"合计",{"$f":"SUM(F11:F13)","v":1239848.85},{"$f":"SUM(G11:G13)","v":{"v":102372.840825688,"d":"102372.84"}},{"$f":"SUM(H11:H13)","v":{"v":1,"d":"100.00%"}}]
[1,"分部分项工程","/",{"$f":"控制价分析表!J6","v":1239848.85},"专业分包",{"$f":"D11","v":1239848.85},{"$f":"F11/1.09*0.09","v":{"v":102372.840825688,"d":"102372.84"}},{"$f":"F11/$F$10","v":{"v":1,"d":"100.00%"}},"税率：9%"]
[2]
[3]
["二","估算成本",{"$f":"C10","v":"/"}]
["三","成本控制价",{"$f":"D10","v":1239848.85}]
["四","预计利润＝（成本控制价-估算成本）","/"]
["五","预计利润率（%）＝（预计利润/成本控制价）","/"]
["注：","/"]
["编制人员"]

{"sheet":"控制价分析表","index":1,"n_rows":31,"n_cols":16,"rows_kept":31,"hidden":true,"merged":[[1,0,1,15],[2,1,2,8],[2,9,4,9],[2,10,4,10],[2,11,4,11],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,3,7],[3,8,4,8],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15]]}
[]
["三、工程项目单价分析表"]
["项目名称","隆润朗景台项目-基坑边坡支护工程专业分包",{"$nulls":7},"成本合价\n（含税）","估算成本单价\n（含税）","估算成本总价","类型",{"$f":"项目概况!B5","v":0},null,"单位：（元）"]
["序号","子目名称","单位","数量","单价","单价组成",null,null,"成本单价\n（含税）",{"$nulls":3},"单项利润","单项盈亏比(利润/单项总利润)","项目单价(填写往期类似项目的控制单价)","备注（如单价差异较大,需说明具体原因）"]
[{"$nulls":5},"人工费","机械费","材料费"]
["一","分部分项工程",{"$nulls":4},{"$f":"SUMPRODUCT($D$7:$D$24,G7:G24)","v":{"v":0,"d":"0.00"}},{"$f":"SUMPRODUCT($D$7:$D$24,H7:H24)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J7:J27)","v":1239848.85},null,{"$f":"SUM(L7:L27)","v":{"v":1172534.0375232,"d":"1172534.04"}},{"$f":"J6-L6","v":{"v":67314.8124768001,"d":"67314.81"}},{"$f":"M6/L6","v":{"v":0.0574096873289857,"d":"5.74%"}}]
[1,"人工挖沟槽、基坑土石方","m3",230.16,{"$nulls":4},55.12,{"$f":"ROUND(D7*I7,2)","v":12686.42},{"v":40,"d":"40.00"},{"$f":"ROUND(K7*D7,2)","v":{"v":9206.4,"d":"9206.40"}},{"$f":"J7-L7","v":3480.02},{"$f":"M7/$L$6","v":{"v":0.00296794795599368,"d":"0.30%"}}]
[2,"机械整理边坡","m2",4984.98,{"$nulls":4},2.56,{"$f":"ROUND(D8*I8,2)","v":12761.55},{"v":2,"d":"2.00"},{"$f":"ROUND(K8*D8,2)","v":9969.96},{"$f":"J8-L8","v":2791.59},{"v":0.00238081787876863,"d":"0.24%"}]
[3,"现浇钢筋网片制安（HRB400 Φ8及以内）","t",5.13,{"$nulls":4},5954.12,30544.64,{"v":4078.03808187135,"d":"4078.04"},20920.34,{"v":9624.3,"d":"9624.30"},{"v":0.00820811992829638,"d":"0.82%"}]
[4,"网喷射混凝土、水泥砂浆  100mm厚 C25","m2",960.3,{"$nulls":4},119.38,114640.61,{"v":83.416,"d":"83.42"},80104.38,34536.23,{"v":0.0294543517670093,"d":"2.95%"}]
[5,"素喷喷射混凝土、水泥砂浆  80mm厚C25","m2",4024.68,{"$nulls":4},{"v":95.1,"d":"95.10"},382747.07,{"v":72.6968,"d":"72.70"},292581.36,90165.71,{"v":0.0768981599804654,"d":"7.69%"}]
[6,"泄水孔 塑料 孔径φ110mm","m",239,{"$nulls":4},71.78,17155.42,{"v":23.1,"d":"23.10"},{"v":5520.9,"d":"5520.90"},11634.52,{"v":0.00992254350634985,"d":"0.99%"}]
[7,"滤水包","m3",16,{"$nulls":4},267.98,4287.68,{"v":120,"d":"120.00"},{"v":1920,"d":"1920.00"},2367.68,{"v":0.00201928466400972,"d":"0.20%"}]
[8,"商品砼排水沟、截水沟  C25砼","m3",69.05,{"$nulls":4},583.54,40293.44,{"v":483,"d":"483.00"},33351.15,6942.29,{"v":0.00592075775869546,"d":"0.59%"}]
[9,"排水沟、截水沟  模板","m2",1380.98,{"$nulls":4},65.26,90122.75,55.25,76299.15,{"v":13823.6,"d":"13823.60"},{"v":0.0117895084983633,"d":"1.18%"}]
[10,"垫层-C15 商品砼","m3",57.54,{"$nulls":4},528.74,{"v":30423.7,"d":"30423.70"},{"v":440,"d":"440.00"},{"v":25317.6,"d":"25317.60"},{"v":5106.1,"d":"5106.10"},{"v":0.00435475631119917,"d":"0.44%"}]
[11,"垫层模板","m2",230.16,{"$nulls":4},55.54,12783.09,{"v":34,"d":"34.00"},7825.44,4957.65,{"v":0.00422815017845647,"d":"0.42%"}]
[12,"锚杆、锚索钻孔及灌浆（孔径110mm及以内）","m",565.74,{"$nulls":4},112.08,63408.14,{"v":90.181,"d":"90.18"},{"v":51019,"d":"51019.00"},12389.14,{"v":0.0105661239704138,"d":"1.06%"}]
[13,"非预应力锚杆、锚索 制安","t",2.18,{"$nulls":4},4913.09,10710.54,{"v":3520,"d":"3520.00"},{"v":7673.6,"d":"7673.60"},3036.94,{"v":0.00259006553567952,"d":"0.26%"}]
[14,"伸缩缝 缝宽30mm 沥青麻絮填充","m",300.42,{"$nulls":4},{"v":34.6,"d":"34.60"},10394.53,{"v":5,"d":"5.00"},{"v":1502.1,"d":"1502.10"},8892.43,{"$f":"M20/$L$6","v":{"v":0.00758394188605723,"d":"0.76%"}}]
[15,"安全护栏 h≥1.2m","m",575.41,{"$nulls":4},{"v":302.663127161502,"d":"302.66"},174155.39,{"v":155,"d":"155.00"},89188.55,84966.84,{"v":0.0724642844309062,"d":"7.25%"}]
[16,"坡顶及坡底硬化100mm厚硬化不小于3米 C25砼","m2",1726.23,{"$nulls":4},{"v":53.977,"d":"53.98"},93176.72,{"v":48.3,"d":"48.30"},83376.91,9799.81,{"v":0.00835780428233931,"d":"0.84%"}]
[17,"坡顶及坡底硬化100mm 模板","m2",116.28,{"$nulls":4},55.54,6458.19,{"v":34,"d":"34.00"},3953.52,2504.67,{"v":0.00213611709327495,"d":"0.21%"}]
[18,"脚手架","m2",4984.98,{"$nulls":4},{"v":26.7,"d":"26.70"},133098.97,{"v":26,"d":"26.00"},129609.48,{"v":3489.49000000001,"d":"3489.49"},{"v":0.00297602448059506,"d":"0.30%"}]
[19,"措施费  直接工程费的2%（安全文明施工费、二次转运、降排水措施、检测、监测、专家论证）","项",1,{"$nulls":6},{"$f":"E25*1.09261","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L7:L24)*2%+30000","v":{"v":48586.7968,"d":"48586.80"}}]
[20,"管理费及利润规费  按照直接工程费及措施费的10%","项",1,{"$nulls":6},{"$f":"E26*1.09261","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L7:L25)*10%","v":{"v":97792.66368,"d":"97792.66"}}]
[21,"税金 9%","项",1,{"$nulls":6},{"$f":"E27*1.09261","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L7:L26)*9%","v":{"v":96814.7370432,"d":"96814.74"}}]
["九","合计",{"$nulls":3},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"J6","v":1239848.85},null,{"$f":"L6","v":{"v":1172534.0375232,"d":"1172534.04"}},{"$f":"J28-L28","v":{"v":67314.8124768001,"d":"67314.81"}},{"$f":"1-L28/J28","v":{"v":0.0542927571185795,"d":"5.43%"}}]
[]
[{"$nulls":11},1692206.23]
[{"$nulls":11},{"$f":"L30-L28","v":519672.1924768}]

{"sheet":"成本分析清单","index":2,"n_rows":24,"n_cols":8,"rows_kept":24,"merged":[[0,0,0,7],[1,0,1,7],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,2,6],[2,7,3,7],[23,0,23,7]]}
["控制价清单表"]
["隆润朗景台项目-基坑边坡支护工程专业分包控制价清单"]
["序号","工程或费用名称","工作内容","单位","工程数量","控制价（含税9%）",null,"备注"]
[{"$nulls":5},"综合单价","综合合价"]
[1,{"$f":"控制价分析表!B7","v":"人工挖沟槽、基坑土石方"},"1.土石方类别:综合考虑2.开挖方式：综合考虑3.开挖深度：综合考虑4.运输方式：综合考虑5.运输距离：场内运距综合考虑（包含多次转运）6.其他要求：满足设计、规范、施工、验收要求",{"$f":"控制价分析表!C7","v":"m3"},{"$f":"控制价分析表!D7","v":230.16},{"$f":"控制价分析表!I7","v":55.12},{"$f":"ROUND(F5*E5,2)","v":12686.42}]
[2,{"$f":"控制价分析表!B8","v":"机械整理边坡"},"1.土壤类别：综合考虑2.挖土深度：综合考虑3.开挖方式：综合考虑4.场内运距：综合考虑5.其他要求：满足设计、规范、施工、验收要求",{"$f":"控制价分析表!C8","v":"m2"},{"$f":"控制价分析表!D8","v":4984.98},{"$f":"控制价分析表!I8","v":2.56},{"$f":"ROUND(F6*E6,2)","v":12761.55}]
[3,{"$f":"控制价分析表!B9","v":"现浇钢筋网片制安（HRB400 Φ8及以内）"},"1.钢筋制作、运输2.钢筋安装3.绑扎、焊接4.钢筋种类、规格：HRB400 Φ8及以内5.连接方式:绑扎、焊接、机械连接综合考虑进单价6.其他要求：满足设计、规范、施工、验收要求",{"$f":"控制价分析表!C9","v":"t"},{"$f":"控制价分析表!D9","v":5.13},{"$f":"控制价分析表!I9","v":5954.12},30544.64]
[4,{"$f":"控制价分析表!B10","v":"网喷射混凝土、水泥砂浆  100mm厚 C25"},"1.混凝土(砂浆)制作、运输、喷射、养护2.边坡底部多余喷射砼的清除外运3.喷射施工平台搭设、拆除4.厚度：100mm厚5.材料种类：混凝土5.混凝土(砂浆)类别、强度等级：C25 6.有无钢筋(素喷/网喷)：有 7.其他要求：满足设计、规范、施工、验收要求",{"$f":"控制价分析表!C10","v":"m2"},{"$f":"控制价分析表!D10","v":{"v":960.3,"d":"960.30"}},{"$f":"控制价分析表!I10","v":119.38},114640.61]
[5,{"$f":"控制价分析表!B11","v":"素喷喷射混凝土、水泥砂浆  80mm厚C25"},"1.混凝土(砂浆)制作、运输、喷射、养护2.边坡底部多余喷射砼的清除外运3.喷射施工平台搭设、拆除4.厚度：80mm厚5.材料种类：混凝土5.混凝土(砂浆)类别、强度等级：C25 6.有无钢筋(素喷/网喷)：无 7.其他要求：满足设计、规范、施工、验收要求",{"$f":"控制价分析表!C11","v":"m2"},{"$f":"控制价分析表!D11","v":4024.68},{"$f":"控制价分析表!I11","v":{"v":95.1,"d":"95.10"}},382747.07]
[6,{"$f":"控制价分析表!B12","v":"泄水孔 塑料 孔径φ110mm"},"1.材质：塑料2.孔径：φ110mm 3.其他要求：满足设计、规范、施工、验收要求",{"$f":"控制价分析表!C12","v":"m"},{"$f":"控制价分析表!D12","v":{"v":239,"d":"239.00"}},{"$f":"控制价分析表!I12","v":71.78},17155.42]
[7,{"$f":"控制价分析表!B13","v":"滤水包"},"1.基层处理2.配料、铺筑、整形、场内运输3.滤水层材质、规格：材质(碎石等)综合、规格按图示要求4.其他要求：满足设计、规范、施工、验收要求",{"$f":"控制价分析表!C13","v":"m3"},{"$f":"控制价分析表!D13","v":{"v":16,"d":"16.00"}},{"$f":"控制价分析表!I13","v":267.98},4287.68]
[8,{"$f":"控制价分析表!B14","v":"商品砼排水沟、截水沟  C25砼"},"1.混凝土拌和、运输、浇筑2.整个沟身浇捣或砌筑3.材料：商品混凝土 C25 4.其他要求：满足设计、规范、施工、验收要求",{"$f":"控制价分析表!C14","v":"m3"},{"$f":"控制价分析表!D14","v":69.05},{"$f":"控制价分析表!I14","v":583.54},40293.44]
[9,{"$f":"控制价分析表!B15","v":"排水沟、截水沟  模板"},"1.模板制作、安装、拆除、整理、堆放2.模板粘接物及模内杂物清理、刷隔离剂3.模板场内外运输及维修4.构件类型：排、截水沟模板5.其他要求：满足设计、规范、施工、验收要求",{"$f":"控制价分析表!C15","v":"m2"},{"$f":"控制价分析表!D15","v":1380.98},{"$f":"控制价分析表!I15","v":65.26},90122.75]
[10,{"$f":"控制价分析表!B16","v":"垫层-C15 商品砼"},"1.原土打夯、清底2.混凝土制作、运输、浇筑、振捣、收光（如有）、养护3.混凝土等级：C15 4.混凝土种类：综合5.骨料配合比：综合考虑6.其他要求：满足设计、规范、施工、验收要求",{"$f":"控制价分析表!C16","v":"m3"},{"$f":"控制价分析表!D16","v":57.54},{"$f":"控制价分析表!I16","v":528.74},{"v":30423.7,"d":"30423.70"}]
[11,{"$f":"控制价分析表!B17","v":"垫层模板"},"1.模板制作、安装、拆除、整理、堆放2.模板粘接物及模内杂物清理、刷隔离剂3.模板场内外运输及维修4.构件类型：排、截水沟模板5.其他要求：满足设计、规范、施工、验收要求",{"$f":"控制价分析表!C17","v":"m2"},{"$f":"控制价分析表!D17","v":230.16},{"$f":"控制价分析表!I17","v":55.54},12783.09]
[12,{"$f":"控制价分析表!B18","v":"锚杆、锚索钻孔及灌浆（孔径110mm及以内）"},"1.钻孔定位、成孔清孔2.浆液制作、运输、压浆3.锚杆(锚索)施工平台搭设、拆除4.地层情况：综合考虑5.钻孔直径：110mm及以内6.浆液种类、强度等级：M25 6.其他要求：满足设计、规范、施工、验收要求",{"$f":"控制价分析表!C18","v":"m"},{"$f":"控制价分析表!D18","v":565.74},{"$f":"控制价分析表!I18","v":112.08},63408.14]
[13,{"$f":"控制价分析表!B19","v":"非预应力锚杆、锚索 制安"},"1.调直、下料、组合、安装等2.调直、切断、连接、安装、张拉、封锚等3.锚杆(锚索)施工平台搭设、拆除4.锚杆(索)类型部位：满足设计要求5.杆体材料品种规格数量：HRB400 φ25 6.其他要求：满足设计、规范、施工、验收要求",{"$f":"控制价分析表!C19","v":"t"},{"$f":"控制价分析表!D19","v":2.18},{"$f":"控制价分析表!I19","v":4913.09},10710.54]
[14,{"$f":"控制价分析表!B20","v":"伸缩缝 缝宽30mm 沥青麻絮填充"},"1.清缝、填缝、盖缝、留缝,嵌缝2.缝宽、缝深：详设计图3.填充材质：沥青麻絮4.其他要求：满足设计、规范、施工、验收要求",{"$f":"控制价分析表!C20","v":"m"},{"$f":"控制价分析表!D20","v":300.42},{"$f":"控制价分析表!I20","v":{"v":34.6,"d":"34.60"}},10394.53]
[15,{"$f":"控制价分析表!B21","v":"安全护栏 h≥1.2m"},"1.扶手材料种类、规格、品牌 ：栏杆高度及样式满足设计要求、满足规范要求2.栏杆的制作安装运输",{"$f":"控制价分析表!C21","v":"m"},{"$f":"控制价分析表!D21","v":575.41},{"$f":"控制价分析表!I21","v":{"v":302.663127161502,"d":"302.66"}},174155.39]
[16,{"$f":"控制价分析表!B22","v":"坡顶及坡底硬化100mm厚硬化不小于3米 C25砼"},"1.原土打夯、清底2.混凝土及模板制作、运输、浇筑、振捣、收光（如有）、养护3.混凝土等级：C25 4.混凝土种类：综合 5.骨料配合比：综合考虑6.其他要求：满足设计、规范、施工、验收要求",{"$f":"控制价分析表!C22","v":"m2"},{"$f":"控制价分析表!D22","v":1726.23},{"$f":"控制价分析表!I22","v":{"v":53.977,"d":"53.98"}},93176.72]
[17,{"$f":"控制价分析表!B23","v":"坡顶及坡底硬化100mm 模板"},"1.模板制作、安装、拆除、整理、堆放2.模板粘接物及模内杂物清理、刷隔离剂3.模板场内外运输及维修4.构件类型：排、截水沟模板5.其他要求：满足设计、规范、施工、验收要求",{"$f":"控制价分析表!C23","v":"m2"},{"$f":"控制价分析表!D23","v":116.28},{"$f":"控制价分析表!I23","v":55.54},6458.19]
[18,{"$f":"控制价分析表!B24","v":"脚手架"},"1.场内、场外材料搬运2.搭、拆脚手架、斜道、上料平台3.拆除脚手架后材料分类堆放1.高度：综合考虑2.搭设排数：双排\n3.脚手架搭设及租赁费4.其他要求：满足设计、规范、施工、验收要求",{"$f":"控制价分析表!C24","v":"m2"},{"$f":"控制价分析表!D24","v":4984.98},{"$f":"控制价分析表!I24","v":{"v":26.7,"d":"26.70"}},133098.97]
[19,"合计",{"$nulls":4},{"$f":"SUM(G5:G22)","v":1239848.85}]
["注：\n全费用合同单价中均已包括了乙方为实施和完成本合同工程所需的全部成本（除合同约定由甲方提供或承担外），包括但不限于人工、材料、机械、加工制作、运输、上下车、搬运及多次转运、安装、调试、试验、劳务用工、辅材、小型机具、周转材料、机械设备、质检（自检）、材料检测、验收检测、边坡的监测、施工临时用水用电、工人食宿、专家论证费、成品及半成品保护、安全文明生产施工费用、环境保护费用、冬雨季及夜间施工增加费、临时设施费、临时用地的征用及复耕、保险、规费、税金、垃圾清运、管理费、合理利润，以及为本工程修复缺陷的全部费用，承包本工程应承担的一切责任、义务和风险费用。"]