监理收费计算表

  • 格式: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)