大家都在搜
关注稻壳领福利
公司对账单
流程图
外贸英文报价单模板
现金日记账
销售单
应付账款明细表
员工工资表汇总
财务系统.xlsx
行程规划表
财务系统费用支出日记账
公司员工花名册（带照片）
销售单模板-通用
设计作品162 独家高品质原创文档
举报
工作计划表
费用支出明细表
采购明细表（自动计算）
财务报表-自动计算
报价表
项目推行计划进度表
产品报价单-带公式计算
工程量计算表
我的
福利
反馈
微信咨询在线客服
客服
回到顶部
![工程量计算表格（精装）-表格模板使 用 说 明,1、本表完全采用excel内部函数设置，进行计算式的列式和标注。,2、如在计算式中进行标注，须遵循本表标注规则，否则计算结果不会实现。,3、中、英、数字标注时[ ]要在计算式的后面，如：2*4.5[宽]+3*3.3[高]，其结果为18.9。,4、计算表中“项目名称/部位”需分C、D列填写，项目名称直接在计算表中填写，也可通过下拉菜单选取（最好在“常用项目”工作表中事先将经常使用的名称录入，供以背后用）。,5、单位录入方法同 9。,6、计算式输入务必在填写项目名称后，另起一行。,7、本表的汇总采用两种方式。一种在计算表中对每个项目名称进行汇总，一种在汇总表中对同一项目名称进行汇总,8、适用本表项目名称的第一行必须填写，否则汇总表无法汇总。,9、为了防止误删计算表1—3行，已对其进行加锁。其他行的插入、删除、单元个设置可正常进行。,10、插入行勿忘将A—J列的设置公式进行复制。,11、本表暂对一页进行公式设置，如需加行向下复制A—J列即可。,,工 程 量 计 算 书,工程名称：某小区幼儿园装修,建筑面积：工程类别：,结构形式：层数高度：,建设单位：设计单位：,编制单位：审核单位：,编制日期：43819.0,,项目名称：某小区幼儿园装修,建设单位：,序号项 目 名 称计量单位预算工程数量代码金额,1.0地面、墙面、天棚拆除、清理270.01.04050.0,2.0玻璃门、其他门保护性拆除70.02.035378.0,3.0垃圾外运m3120.03.01200.0,4.0室内原有物体保护性搬移个36.04.019627.2,5.0地面垫层m3600.05.01818.0,6.0地面随打随抹2100.06.03612.0,7.0仿爵士白地砖80.177.022166.766,8.0瓷砖波打线4.028.01230.12,9.0雅士白石材地面93.259.027540.45,10.0总计10.0116622.536,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,51.0,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0,62.0,63.0,64.0,65.0,66.0,67.0,68.0,69.0,70.0,71.0,72.0,73.0,74.0,75.0,76.0,77.0,78.0,79.0,80.0,81.0,82.0,83.0,84.0,85.0,86.0,87.0,88.0,89.0,90.0,91.0,92.0,93.0,94.0,95.0,96.0,97.0,98.0,99.0,100.0,101.0,102.0,103.0,104.0,105.0,106.0,107.0,108.0,109.0,110.0,111.0,112.0,113.0,114.0,115.0,116.0,117.0,118.0,119.0,120.0,121.0,122.0,123.0,124.0,125.0,126.0,127.0,128.0,129.0,130.0,131.0,132.0,133.0,134.0,135.0,136.0,137.0,138.0,139.0,140.0,141.0,142.0,143.0,144.0,145.0,146.0,147.0,148.0,149.0,150.0,151.0,152.0,153.0,154.0,155.0,156.0,157.0,158.0,159.0,160.0,161.0,162.0,163.0,164.0,165.0,166.0,167.0,168.0,169.0,170.0,171.0,172.0,173.0,174.0,175.0,176.0,177.0,178.0,179.0,180.0,181.0,182.0,183.0,184.0,185.0,186.0,187.0,188.0,189.0,190.0,191.0,192.0,193.0,194.0,195.0,196.0,197.0,198.0,199.0,200.0,201.0,202.0,203.0,204.0,205.0,206.0,207.0,208.0,209.0,210.0,211.0,212.0,213.0,214.0,215.0,216.0,217.0,218.0,219.0,220.0,221.0,222.0,223.0,224.0,225.0,226.0,227.0,228.0,229.0,230.0,231.0,232.0,233.0,234.0,235.0,236.0,237.0,238.0,239.0,240.0,241.0,242.0,243.0,244.0,245.0,246.0,247.0,248.0,249.0,250.0,251.0,252.0,253.0,254.0,255.0,256.0,257.0,258.0,259.0,260.0,261.0,262.0,263.0,264.0,265.0,266.0,267.0,268.0,269.0,270.0,271.0,272.0,273.0,274.0,275.0,276.0,277.0,278.0,279.0,280.0,281.0,282.0,283.0,284.0,285.0,286.0,287.0,288.0,289.0,290.0,291.0,292.0,293.0,294.0,295.0,296.0,297.0,298.0,299.0,300.0,301.0,302.0,303.0,304.0,305.0,306.0,307.0,308.0,309.0,310.0,311.0,312.0,313.0,314.0,315.0,316.0,317.0,318.0,319.0,320.0,321.0,322.0,323.0,324.0,325.0,326.0,327.0,328.0,329.0,330.0,331.0,332.0,333.0,334.0,335.0,336.0,337.0,338.0,339.0,340.0,341.0,342.0,343.0,344.0,345.0,346.0,347.0,348.0,349.0,350.0,351.0,352.0,353.0,354.0,355.0,356.0,357.0,358.0,359.0,360.0,361.0,362.0,363.0,364.0,365.0,366.0,367.0,368.0,369.0,370.0,371.0,372.0,373.0,374.0,375.0,376.0,377.0,378.0,379.0,380.0,381.0,382.0,383.0,384.0,385.0,386.0,387.0,388.0,389.0,390.0,391.0,392.0,393.0,394.0,395.0,396.0,397.0,398.0,399.0,400.0,401.0,402.0,403.0,404.0,405.0,406.0,407.0,408.0,409.0,410.0,411.0,412.0,413.0,414.0,415.0,416.0,417.0,418.0,419.0,420.0,421.0,422.0,423.0,424.0,425.0,426.0,427.0,428.0,429.0,430.0,431.0,432.0,433.0,434.0,435.0,436.0,437.0,438.0,439.0,440.0,441.0,442.0,443.0,444.0,445.0,446.0,447.0,448.0,449.0,450.0,451.0,452.0,453.0,454.0,455.0,456.0,457.0,458.0,459.0,460.0,461.0,462.0,463.0,464.0,465.0,466.0,467.0,468.0,469.0,470.0,471.0,472.0,473.0,474.0,475.0,476.0,477.0,478.0,479.0,480.0,481.0,482.0,483.0,484.0,485.0,486.0,487.0,488.0,489.0,490.0,491.0,492.0,493.0,494.0,495.0,496.0,497.0,498.0,499.0,500.0,501.0,502.0,503.0,504.0,505.0,506.0,507.0,508.0,509.0,510.0,511.0,512.0,513.0,514.0,515.0,516.0,517.0,518.0,519.0,520.0,521.0,522.0,523.0,524.0,525.0,526.0,527.0,528.0,529.0,530.0,531.0,532.0,533.0,534.0,535.0,536.0,537.0,538.0,539.0,540.0,541.0,542.0,543.0,544.0,545.0,546.0,547.0,548.0,549.0,550.0,551.0,552.0,553.0,554.0,555.0,556.0,557.0,558.0,559.0,560.0,561.0,562.0,563.0,564.0,565.0,566.0,567.0,568.0,569.0,570.0,571.0,572.0,573.0,574.0,575.0,576.0,577.0,578.0,579.0,580.0,581.0,582.0,583.0,584.0,585.0,586.0,587.0,588.0,589.0,590.0,591.0,592.0,593.0,594.0,595.0,596.0,597.0,598.0,599.0,600.0,,工程名称：某小区幼儿园装修主材单价主材内容及型号规格辅材单价辅材内容及施工工艺主辅材人工费综合单价总价主辅材分类,项目名称/部位单位计算公式数量预算汇总代码索引1清单数量损耗单价合价,地面、墙面、天棚拆除、清理100+150+20地砖地面，墙、天棚原构件拆除、垃圾清运出室内，对不施工区域成品保护15.015.04050.0,玻璃门、其他门保护性拆除30+4070.070.050.0保护性拆除玻璃门、搬移至安全区域，堆放整齐，其他门拆除325.4180.0505.435378.022778.0,垃圾外运m340+50[一层]+30[2层]120.0120.0人装自卸汽车外运至市政指定垃圾堆放处1200.0,室内原有物体保护性搬移个10+16+1036.036.0260.050.0原有物品保护性拆下后移动至指定位置315.2230.0545.219627.211347.2,地面垫层m3100+200+300[二~三层]1.50.5搅拌、振捣、抹面、养护2.033.031818.01218.0,地面随打随抹600+900+600冀东水泥0.2钳子、锡焊枪、钢丝1.220.51.723612.02562.0,仿爵士白地砖大厅、办公室13.5*2.4+12.5*2180.0800*800马可波罗高档183.6273.615704.6410538.64,仿爵士白地砖活动室3.3*2.3*3190.0600*600马可波罗高档193.8283.86462.1264412.83,瓷砖波打线大厅、门厅、活动室0.3*13.44.024.020.03200.0300*900马可波罗高档206.0100.0306.01230.12828.12,雅士白石材地面门厅9*981.081.0200.0900*900蒙娜丽莎高档204.0294.023814.016524.0,11.0雅士白石材地面玄关3.5*3.512.2512.2511.0210.0600*600蒙娜丽莎高档214.2304.23726.452623.95,小计116622.536,13.0总计116622.536,,m,m2,m3,kg,t,只,个,副,组,支,把,套,座,根,Φ,,](http://personal.wpscdn.cn/app/new-www-docer-com/img/loading-img-42.ffcbba5.gif)