预决算书自动生成表格.xls

1、建建 筑筑 安安 装装 工工 程程 结结 算算 书书合同编号：预结算编号：建设单位：建设规模：平方米工程名称：预（结）算造价：元366259.69结构类型：单位 造价：元/平方米编制单位：（公章）审核单位：（公章）编制人：（执、从业专用章）编制人：（执、从业专用章）审核人：（执业专用章）审核人：（执业专用章）2007年3月26日 年 月 日(二二)编编制制说说明明编编 制制 说说 明明一、工程概况二、编制依据三、其他说明建筑安装工程费用汇总表工程名称：XX智能化系统工程 第1页 共1页序号项目名称计算式或基数合计金额(元)直接工程费+258591.72 其中：人工费148621.51 材料费其

2、中：定额基价的材料费（含设备材料主材费）材料费系数调整率160554.44 机械费49415.76措施费+0.00 其中：通用措施费详见措施项目费用表0.00 专业措施费详见措施项目费用表 措施项目管理费详见措施项目费用表 措施项目利润详见措施项目费用表其他项目费详见其他项目费用表管理费(各册分部分项人工费相应管理费率调整系数100%)38641.59利润(各册分部分项人工费相应利润率调整系数100%)17834.58规费+39114.20 其中：工程排污费 社会保障及住房公积金直接工程定额人工费(元)社保费率26%38641.59 工程定额测定费+工程定额测定费率0.15%472.60税金+

3、税率3.41%（设备材料清单报价已含税金）12077.61安装工程造价+366259.69设备购置费(含税)安装工程总造价+366259.69总价(大写金额)注：社会保障及劳动保险费的计算基数人工工日单价取定24.75元/工日。建筑安装工程直接工程费计算表工工程程名名称称：XXXX智智能能化化系系统统工工程程 序定额编码项 目 名 称单位工程量单 价合 价号小计其中合计其中人工材料机械人工费材料费机械费一一、综综合合布布线线系系统统103100697超五类非屏蔽信息模块10个389.716.932.090.69368.98263.3479.4226.22203100621超五类非屏蔽双绞线|窜

4、管敷设100m164.742.8436.141.455.257055.755952.26238.82864.68303100682超五类24口非屏蔽配线架（带模块）台16136.1387.8616.7331.542178.081405.76267.68504.64403100682110配线架（100对带模块）台4136.1387.8616.7331.54544.52351.4466.92126.16503100697超五类屏蔽信息模块10个169.716.932.090.69155.36110.8833.4411.04603100621超五类屏蔽双绞线|窜管敷设100m45.7542.843

5、6.141.455.251959.931653.4166.34240.19703100682超五类48口屏蔽配线架（未带模块）台3136.1387.8616.7331.54408.39263.5850.1994.62803021667双口面板10套1323.9520.543.41311.35267.0244.330.00903021667单口面板10套1223.9520.543.41287.40246.4840.920.001003100705光纤适配器10个48.839.8529.956.133.771944.681461.56299.14183.98110310068112口光纤接线箱台4

6、81.2350.9814.7515.5324.92203.9259.0062.001203100678法兰盘台3476.158.6615.042.42587.401994.44511.3681.601303100706单模光纤尾纤10头406.304.70.730.87252.00188.0029.2034.801403100706单模光纤跳线10头0.66.304.70.730.873.782.820.440.521503100629八芯单模铠装光缆敷设|沿槽盒支架100m27212.38140.8349.8321.725734.263802.411345.41586.44160310063

7、3光缆接头制作(12芯以下)个168394.88236.3614.26144.2666339.8439708.482395.6824235.68主材 成套附件套169.6838.006447.84主材 熔接接头及器材套169.6880.0013574.40主材 光缆中间接头盒及成套附件套169.6818.003054.24主材 加感线圈个169.680.000.00主材 地线装置套169.685.00848.40主材 接续材料套169.6816.002714.88第5页 共12页17031004522m标准机柜台2612.98397.7397.15118.11225.96795.46194.3

8、0236.20180310045219标准墙柜台4612.98397.7397.15118.12451.921590.92388.60472.401903021377暗装|接线盒86*86底盒10个2537.1411.1426928.50278.50650.000.002003021098塑料管敷设|砖、混凝土结构暗配|硬质聚氯乙烯管口径20mm以内100m80147.31118.06425.2511784.809444.80320.002020.002103020330数据、电话跳线10个56.838.8611.1427.722207.25632.751574.500.00220310068

9、1光纤接续箱台381.2350.9814.7515.5243.69152.9444.2546.50230310068124口光纤接线箱台1181.2350.9814.7515.5893.53560.78162.25170.502403100682110配线架（100对带模块）台2136.1387.8616.7331.54272.26175.7233.4663.082503021377金属地弹盒10个1.637.1411.142659.4217.8241.600.002603021377金属地弹底盒10个1.637.1411.142659.4217.8241.600.002703021680三相

10、暗插座|15A|4孔10套3231.3226.734.591002.24855.36146.880.002803021198管内穿线|动力线路(铜芯)|导线截面2.5mm2以内100m单线1424.5517.337.22343.70242.62101.080.002903021218管内穿线|多芯软导线|四芯以内|导线截面1.5mm2以内100/m束13.533.624.59.1453.60330.75122.850.003003021147半硬质阻燃管埋地敷设|DN40mm以内100m3387.21386.840.371161.631160.521.110.003103020593小型塑料槽

11、安装 宽50以下|盘后10m16067.5525.7441.8110808.004118.406689.600.003203021012钢管敷设|砖、混凝土结构暗配|口径40mm以内100m2.5526.56369.02115.3842.161316.40922.55288.45105.403303020595加强式塑料槽安装 宽100mm以下10m60143.0571.7865.955.328583.004306.803957.00319.203403020543钢制槽式桥架安装 宽+高400mm以下10m6119.3478.7135.425.21716.04472.26212.5231.2

12、63503021667有线电视终端10套1.223.9520.543.4128.7424.654.090.003603100280放大器台149.7637.872.279.6249.7637.872.279.62建筑安装工程直接工程费计算表工工程程名名称称：XXXX智智能能化化系系统统工工程程 序定额编码项 目 名 称单位工程量单 价合 价号小计其中合计其中人工材料机械人工费材料费机械费第6页 共12页37031001682分配器台327.0418.321.537.1981.1254.964.5921.5738031001684分支器台427.0418.321.537.19108.1673.2

13、86.1228.763903100639SYWV-75-7同轴电缆100m1.1594.1075.7413.115.25108.2287.1015.086.044003100641SYWV-75-5同轴电缆100m3.88.714.73.320.6933.1017.8612.622.624103021377暗装|接线盒86*86底盒10个1.137.1411.142640.8512.2528.600.004203021098塑料管敷设|砖、混凝土结构暗配|硬质聚氯乙烯管口径20mm以内100m3.4147.31118.06425.25500.85401.4013.6085.8543030210

14、09钢管敷设|砖、混凝土结构暗配|口径20mm以内100m1.5251.03178.251.221.63376.55267.3076.8032.45合计84929.2547301.8630704.01二二、计计算算机机网网络络系系统统103070041核心交换机S6503主机台11462.661223.4439.97199.251462.661223.4439.97199.25203070013交流电源模块只140.8436.043.261.5440.8436.043.261.54303070014交换机路由模块只155.6647.725.562.3855.6647.725.562.38403

15、070013千兆电接口模块只140.8436.043.261.5440.8436.043.261.54503070013千兆光端口模块只140.8436.043.261.5440.8436.043.261.54603100637GBIC接口模块台6485.72228.6932.93224.12914.321372.14197.581344.60703070063接入交换机LS3050C台2613.81538.7675.051227.621077.52150.100.00803070062接入交换机LS3026C-SI台2508.47448.8759.61016.94897.74119.200.

16、00903100637GBIC接口模块LS-GSIUA台2485.72228.6932.93224.1971.44457.3865.86448.201003100637堆叠模块台3485.72228.6932.93224.11457.16686.0798.79672.301103070063防火墙台1613.81538.7675.05613.81538.7675.050.001203100637100M光纤收发器台1485.72228.6932.93224.1485.72228.6932.93224.10建筑安装工程直接工程费计算表工工程程名名称称：XXXX智智能能化化系系统统工工程程 序定额

17、编码项 目 名 称单位工程量单 价合 价号小计其中合计其中人工材料机械人工费材料费机械费第7页 共12页1303100659不间断电源柜安装套(台)1284.59189.8319.1275.64284.59189.8319.1275.641403100662不间断电源调试套11011.61571.7334.32405.561011.61571.7334.32405.56合计7399.14848.263376.65三三、综综合合安安防防系系统统103070286摄像设备安装|彩色 CCD|(含半球)台27119.9974.251.6544.093239.732004.7544.551190.43

18、203070286摄像设备安装|彩色 CCD|(含半球)台14119.9974.251.6544.091679.861039.5023.10617.26303070309云台安装|电动云台|8Kg台2768.6368.060.571853.011837.6215.390.00403070319云台支架安装|悬挂式|摄像机支架台2756.1549.56.651516.051336.50179.550.00503070315防护罩安装|全天候防护罩台2774.7474.250.492017.982004.7513.230.00603070354DS8016HC数字硬盘录像机台3272.25272.

19、25816.75816.750.000.00703070303彩色监视器安装在立柜上|56cm台9152.52991.352.211372.59891.0011.70469.89803100453非标准机柜半周长(m)操作台m4.5560.3347.7494.46118.12521.351564.83425.07531.45903100453非标准机柜半周长(m)电视墙m4.5560.3347.7494.46118.12521.351564.83425.07531.451003020774电杆组立|单腿接杆9m以内根154.8133.6621.1554.8133.6621.150.001103

20、070361摄像机直流电源|暗装台4137.4330.943.013.481534.631268.54123.41142.681203070366配电柜电源箱台270.4749.56.0514.93140.9699.0012.1029.86130307006224口交换机台1508.47448.8759.6508.47448.8759.600.001403100637100M光纤收发器台1485.72228.6932.93224.1485.72228.6932.93224.101503100681光纤终端盒台281.2350.9814.7515.5162.46101.9629.5031.001

21、603100637光端机(发射机）台8485.72228.6932.93224.103885.761829.52263.441792.801703100706单模光纤跳线根166.304.70.730.87100.8075.2011.6813.921803070330综合管理平台 管理软件台1350.97309.388.1633.43350.97309.388.1633.431903070331全电脑视频切换设备安装|64路矩阵台1631.02556.8813.2560.89631.02556.8813.2560.892003070326云台控制器视频切换器安装|键盘控制器 主控键盘2008台

22、160.5437.131.4521.9660.5437.131.4521.962103100637光电端机（接收机）台8485.72228.6932.93224.13885.761829.52263.441792.802203070394电视监控系统调试 头尾数=144系统11816.21833.9559.94922.321816.21833.9559.94922.32建筑安装工程直接工程费计算表工工程程名名称称：XXXX智智能能化化系系统统工工程程 序定额编码项 目 名 称单位工程量单 价合 价号小计其中合计其中人工材料机械人工费材料费机械费第8页 共12页2303070250总线报警控制器

23、安装|128路套1542.28391.0518.06133.17542.28391.0518.06133.172403070255编程键盘套146.5822.287.1417.1746.5922.287.1417.172503070254地址码板安装套1644.0322.284.5917.17704.64356.4873.44274.722603070255总线延伸器套146.5822.287.1417.1746.5922.287.1417.172703070222户外对射ABT-250套172.5734.6513.0424.8772.5634.6513.0424.872803070222户外

24、对射ABT-150套172.5734.6513.0424.8772.5634.6513.0424.872903070222户外对射ABT-100套272.5734.6513.0424.87145.1269.3026.0849.743003070222户外对射ABT-60套272.5734.6513.0424.87145.1269.3026.0849.743103070222户外对射ABT-30套272.5734.6513.0424.87145.1269.3026.0849.743203070319对射探头支架安装台3256.1549.56.651796.801584.00212.800.003

25、303070361电源台137.4330.943.013.4837.4330.943.013.483403070229入侵探测器安装|多技术复合探测器套1149.9623.027.0419.9549.56253.2277.44218.903503070255连动通讯接口安装套146.5822.277.1417.1646.5722.277.1417.163603070330巡更管理软件台1350.97309.388.1633.43350.97309.388.1633.433703100640视频电缆SYV75-7同轴电缆敷设|穿管敷设100m2.533.4429.702.081.6683.607

26、4.255.204.153803100640视频电缆SYV75-5同轴电缆敷设|穿管敷设100m32.8833.4429.702.081.661099.51976.5468.3954.583903100616电源电缆RVV21.5100m17.88103.8479.7018.895.251856.661425.04337.7593.874003100616电源电缆RVV21.0100m30103.8479.7018.895.253115.202391.00566.70157.504103100616控制电缆RVV100.5100m3103.8479.7018.895.25311.52239.1

27、056.6715.754203100616报警控制电缆RVV40.75100m32103.8479.7018.895.253322.882550.40604.48168.004303100621屏蔽控制线RVVP30.5|窜管敷设100m1042.8336.131.455.25428.30361.3014.5052.504403100621屏蔽控制线RVVP20.5|窜管敷设100m17.8842.8336.131.455.25765.80646.0025.9393.87建筑安装工程直接工程费计算表工工程程名名称称：XXXX智智能能化化系系统统工工程程 序定额编码项 目 名 称单位工程量单 价

28、合 价号小计其中合计其中人工材料机械人工费材料费机械费第9页 共12页4503100616屏蔽控制线RVVP41.0|4芯以下100m10103.8379.6918.895.251038.30796.90188.9052.504603021200管内穿线|接地线|导线截面6mm2以内 100m单线128.3419.88.5428.3419.808.540.004703100631铠装12芯光纤光缆敷设穿保护管100m36134.84105.197.9321.724854.243786.84285.48781.924803100633光缆接头制作(12芯以下)个12394.88236.3614.

29、26144.264738.562836.32171.121731.12主材 成套附件套12.1238.00460.560.00460.560.00主材 熔接接头及器材套12.1280.00969.600.00969.600.00主材 光缆中间接头盒及成套附件套12.1218.00218.160.00218.160.00主材 加感线圈个12.120.000.000.000.000.00主材 地线装置套12.125.0060.600.0060.600.00主材 接续材料套12.1216.00193.920.00193.920.004903021089塑料管敷设|砖、混凝土结构明配|硬质聚氯乙烯管口

30、径20mm以内 DN16100m6322.88217.5580.0825.251937.281305.30480.48151.505003021089塑料管敷设|砖、混凝土结构明配|硬质聚氯乙烯管口径20mm以内 DN20100m20322.88217.5580.0825.256457.604351.001601.60505.005103021090塑料管敷设|砖、混凝土结构明配|硬质聚氯乙烯管口径25mm以内 DN25100m11.05335.33220.2877.1737.883705.402434.09852.73418.575203021015钢管敷设|砖、混凝土结构暗配|口径80mm

31、以内 DN80镀锌钢管100m3.21161.47850.16252.5458.773716.702720.51808.13188.065303100641Q9头同轴电缆头制作个1808.714.703.320.691567.80846.00597.60124.205403100641Q9三通同轴电缆头制作个508.714.703.320.69435.50235.00166.0034.50合计51977.3211299.4013948.00四四、二二三三层层会会议议室室投投影影系系统统103100453显示屏幕半周长(m)米2560.30347.7494.46118.11120.60695.4

32、8188.92236.20203070319投影机支架安装台256.1549.56.65112.3099.0013.300.00303100621VGA线100m142.8436.141.455.2542.8436.141.455.25403100621音频线100m542.8436.141.455.25214.20180.707.2526.25合计1011.32210.92267.70建筑安装工程直接工程费计算表工工程程名名称称：XXXX智智能能化化系系统统工工程程 序定额编码项 目 名 称单位工程量单 价合 价号小计其中合计其中人工材料机械人工费材料费机械费第10页 共12页五五、LEDL

33、ED大大屏屏显显示示系系统统（办办公公楼楼一一层层及及新新数数控控车车间间）103100453显示屏幕半周长(m)米2.96560.30347.7494.46118.11658.491029.31279.60349.58203100465屏幕控制机台18.737.430.211.098.737.430.211.09303100453显示屏幕半周长(m)米6.5560.30347.7494.46118.13641.952260.31613.99767.65403100465屏幕控制机台18.737.430.211.098.737.430.211.09合计3304.48894.011119.41总总计计148621.51148621.5160554.4460554.4449415.7649415.76建筑安装工程直接工程费计算表工工程程名名称称：XXXX智智能能化化系系统统工工程程 序定额编码项 目 名 称单位工程量单 价合 价号小计其中合计其中人工材料机械人工费材料费机械费第11页 共12页第12页 共12页