监理收费计算表
- 格式:xls
- 大小:35.00 KB
- 文档页数:2
计费额(x)收费基价(y)d4为工程费合计
150016.5500
2100030.1500-1000
3300078.11000-3000
45000120.83000-5000
580001813000-5000
610000218.64为工程费合计
round(d4*0.033,2)
ROUND(((D4-5000000)*30.1+(10000000-D4)*16.5)/(1000-500),2)
round(((d4-10000000)*78.1+(30000000-d4)*30.1)/(3000-1000),2)
round(((d4-30000000)*120.8+(50000000-d4)*78.1)/(5000-3000),2)
round(((d4-50000000)*181+(80000000-d4)*120.8)/(8000-5000),2)