管道土方挖填自動(dòng)計(jì)算表格(帶公式)

室內(nèi)外給排水管道土方量計(jì)算,,,,,,,土方類別,一二類土,,,,,,,

,,,,,,,,,,,,,,,,

"管徑DN

(mm)",鑄鐵管、鋼管、石棉水泥管,,,,砼、鋼筋砼管,,,,說(shuō)明,,,,土方屬性設(shè)置,,

,"溝底寬b

(m)","溝深h

(m)","溝長(zhǎng)l

(m)","挖方量

(m3)","溝底寬b

(m)","溝深h

(m)","溝長(zhǎng)l

(m)","挖方量

(m3)",,,,,土方類別,放坡起始深度,放坡系數(shù)

50～75,0.6,,,,0.8,1.00,127.00,101.60,"管溝挖方量計(jì)算式：V=h*(b+對(duì)應(yīng)類別放坡系數(shù)*h)*L

式中：

h：溝深，按設(shè)計(jì)管底標(biāo)高計(jì)算，m；

b：溝底寬，m；

L：溝長(zhǎng)，m；

i：對(duì)應(yīng)土方類別放坡系數(shù)。

計(jì)算時(shí)，各種檢查井和排水管道接口處的加寬多挖土方工程量不增加；但鑄鐵管給水管道，接口處操作坑工程量應(yīng)增加，按全部給水管溝土方量的2.5%計(jì)算增加量。",,,,一二類土,1.2,0.5

100～200,0.7,,,,0.9,,"1,266.00",,,,,,三類土,1.5,0.33

250～350,0.8,,,,1.0,,,,,,,,四類土,2,0.25

400～450,1.0,,,,1.3,,,,,,,,,,

500～600,1.3,,,,1.5,,,,,,,,,,

700～800,1.6,,,,1.8,,,,,,,,,,

900～1000,1.8,,,,2.0,,,,,,,,,,

1000～1200,2.0,,,,2.2,,,,,,,,,,

1200～1400,2.2,,,,2.4,,,,,,,,,,

小計(jì),,,0.00m,0.000m3,,,1393.00m,101.600m3,,,,,,,

挖方合計(jì)：,101.600m3,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

管道回填土方量計(jì)算,,,,,,,管道選擇,鋼管,,,,,,,

管徑DN,鋼管(m3/m),鑄鐵管(m3/m),砼管(m3/m),鋼管(m3),鑄鐵管(m3),砼管(m3),說(shuō)明,,,挖方合計(jì),101.600,m3,,,

500～600,0.21,0.24,0.33,,,,"(1)DN500以下的管溝回填土方量不扣除管道所占體積；

(2)DN500以上的管溝回填土方量按左表扣除。",,,填方合計(jì),101.600,m3,,,

601～800,0.44,0.49,0.6,,,,,,,填砂合計(jì),0.000,m3,,,

801～1000,0.71,0.77,0.92,,,,,,,,,,,,

1001～1200,0.94985,1.056296,1.32665,0.000,,,,,,,,,,,

1201～1400,1.32665,1.451936,1.76625,,,,,,,,,,,,

小計(jì),,,,0.000m3,,0.000m3,,,,,,,,,

回填合計(jì)：,101.600m3,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

管道回填砂方量計(jì)算,,,,,,,管道選擇,鋼管,,,,,,,

管徑DN,鋼管(m3/m),鑄鐵管(m3/m),砼管(m3/m),鋼管(m3),鑄鐵管(m3),砼管(m3),說(shuō)明,,,,,,,,

500～600,0.21,0.24,0.33,0.000,,0.000,"(1)DN500以下的管溝回填土方量不扣除管道所占體積；

(2)DN500以上的管溝回填土方量按左表扣除。",,,,,,,,

601～800,0.44,0.49,0.6,0.000,,0.000,,,,,,,,,

801～1000,0.71,0.77,0.92,0.000,,0.000,,,,,,,,,

1001～1200,0.94985,1.056296,1.32665,0.000,,0.000,,,,,,,,,

1201～1400,1.32665,1.451936,1.76625,0.000,,0.000,,,,,,,,,

小計(jì),,,,0.000m3,,0.000m3,,,,,,,,,

回填合計(jì)：,0.000m3,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,