土石方计算程序

  • 格式:xls
  • 大小:1.06 MB
  • 文档页数:117

100

53.45053.45053.85054.05054.23054.09054.68054.7254.80054.860

48.500154.010153.920154.730154.000154.000153.960153.990154.650154.6601

4.950-0.560-0.070-0.6800.2300.0900.7200.7300.1500.200

填方=+填方=+填方=+填方=+填方=+填方=+填方=+填方=+填方=+填方=+

挖方=-挖方=-挖方=-挖方=-挖方=-挖方=-挖方=-挖方=-挖方=-挖方=-

53.45053.45053.35053.55053.75053.61053.95054.20054.32054.880

54.010154.010153.920154.730154.000154.000153.960153.990154.650154.6601

-0.560-0.560-0.570-1.180-0.250-0.390-0.0100.210-0.3300.220

填方=+填方=+填方=+填方=+填方=+填方=+填方=+填方=+填方=+填方=+

挖方=-挖方=-挖方=-挖方=-挖方=-挖方=-挖方=-挖方=-挖方=-挖方=-

53.45053.45053.35053.55053.75053.61053.95054.20054.32054.880

54.000154.250151.500152.000154.000154.000153.960153.990154.650154.6601

-0.550-0.8001.8501.550-0.250-0.390-0.0100.210-0.3300.220

填方=+填方=+填方=+填方=+填方=+填方=+填方=+填方=+填方=+填方=+

挖方=-挖方=-挖方=-挖方=-挖方=-挖方=-挖方=-挖方=-挖方=-挖方=-

53.45053.45053.35053.55053.75053.61053.95054.20054.32054.880

51.000154.000153.920154.730154.000154.00053.96053.99054.65054.660

2.450-0.550-0.570-1.180-0.250-0.390-0.0100.210-0.3300.220

填方=+填方=+填方=+填方=+填方=+

挖方=-挖方=-挖方=-挖方=-挖方=-

53.45053.45053.35053.55053.75053.610

54.000154.000151.36053.02054.55054.320

-0.550-0.5501.9900.530-0.800-0.710

填方=+填方=+

挖方=-挖方=-

53.45053.45053.350

51.00051.00051.520

2.4502.4501.830场地总面积=+80135.1M³

440.0

990.00.0

2000.01002.3370000(平方米) 约合555(亩)

1008.32.3

5662.0

1460.81263.0

4231.1

0.01012.5

742.91008.3440.0

990.0

2723.4

3665.92019.9

3871.65375.03424.9

1996.6109.1

5230.71525.0

0.0

0.0

2000.01002.3

2.3408.30.0

3200.05662.0

1460.81263.0

4231.10.01508.1

226.93700.0

0.0

0.0

6175.01645.5

4716.73200.0408.31188.5

413.14148.7

0.02870.1

231.14955.60.0

4400.00.0

6250.0266.7

1066.7总填方量= 本表可提供10×10共100个方格网的场地土石方挖填方计算,只需在格网边长单元格中填上边长(M),在格网的每个角顶右上单元格

中填上设计标高、右下单元格中填上地面标高即可得到场地的总挖方量和总填方量 。可连续输入或间隔输入,当一个图形的4个角顶

都有值时,这个格网将被浅绿色填充并进行计算,否则为白色格网并不参与计算。根据场地各顶点标高,程序自动按传统的场地平

整计算方法和公式对参与计算的每个格网的挖填方量进行计算,最后汇总得到总量。(红色字体为设计高,黑色字体为地面高)

本表按教科书上计算公式进行编辑计算,敬请同仁指正。

10004.2总挖方量=-87896.7M³边长=

6658.346.4

504.215363.9

36.43340.2

2723.4

4221.31645.5

4692.2

555

37.0

54.900

53.980104.95089.83710.16334-0.5600.0000-0.070

0.92089.836666658.266-3340.2200-44000

20386.76658.2666658.266-3340.220000

20883.56658.266-3340.2200

-3340.220-3340.22-440000-6250

54.35010.1633400

54.21010.0-0.5600.0000-0.5600.0000-0.570

0.14000-617501645.5182-4716.6623.553719

11946.10001645.518221645.5182-4716.665661.9706

23784.1001645.5182-4716.66

-617500-4716.65760-4716.66-1460.75

54.3500076.446281

54.32010.0-0.5500.0000-0.80030.18969.811321.850

0.03018.333332723.356-4221.3401645.5182-4692.2276.446281

14156.92723.3562723.356-4221.341645.518221645.5182-4692.225661.9706

22548.82723.356-4221.341645.5182-4692.22

-4221.342723.356-4221.34-4692.21890-4692.22-1460.75

54.35081.66667023.553719

54.9805.02.45081.66718.33333-0.5500.0000-0.570

-0.63081.666672723.356-3665.902019.9206-3871.5622.265625

8277.32723.3562723.356-3665.92019.920592019.9206-3871.563424.9486

20139.72723.356-3665.92019.9206-3871.56

-3665.90-3665.9-3871.55740-3871.56-1996.563

18.33333077.734375

2.0-0.5500.0000-0.55021.65478.346461.990

18.3333310004.17-504.16718.333333315363.866-36.390

25368.010004.170015363.865615363.866-36.39#VALUE!

540.60000

-504.16700-36.389983000

81.6666781.66666670

0.02.4500.00002.4500.00001.830

#VALUE!0#VALUE!0

0.0#VALUE!00#VALUE!00#VALUE!

0.00000

0000000

0.00.00000.0000#VALUE!0#VALUE!0

0.0#VALUE!00#VALUE!00#VALUE!

0.00000

0000000

0.00.00000.0000

#VALUE!0#VALUE!0

0.0#VALUE!00#VALUE!00#VALUE!

0.00000

0000000

0.00.00000.0000

#VALUE!0#VALUE!0

0.0#VALUE!00#VALUE!00#VALUE!

0.00000

0000000

0.00.00000.0000

#VALUE!0#VALUE!0

0.0#VALUE!00#VALUE!00#VALUE!

0.00000

0000000

0000

0000.0000-0.68074.72525.274730.2300.00000.0900.00000.7200.00000.7300.000

0-6250046.42476-4955.5847.91667266.6667-1066.6718.751188.5-413.09998.630144148.708-0.0103802870.081

0046.4247646.42476-4955.58266.6667001188.474004148.7084148.708-0.010382870.0812870.081

0046.42476-4955.580000002870.081

00-4955.5800-1066.6700-413.09900-0.0103800-231.0760

052.0833381.251.3698630

0.0000-1.1800.0000-0.2500.0000-0.3900.0000-0.0104.54595.454550.21038.889

5661.9706-1460.7543.223441263.016-4231.0500-320000-200001002.273-2.272730408.3333

001263.0161263.016-4231.050000001002.27300408.33330

001263.016-4231.050000000

00-4231.051263.016-4231.05-320000-200000-2.2727300-1008.330

56.776560000

0.00001.55086.11113.88889-0.2500.0000-0.3900.0000-0.0104.54595.454550.21038.889

5661.9706-1460.7556.776561263.016-4231.0500-320000-200001002.273-2.272730408.3333

001263.0161263.016-4231.050000001002.27300408.33330

001263.016-4231.050000000

00-4231.050-4231.05-320000-200000-2.2727300-1008.330

43.223440000

0.0000-1.1800.0000-0.2500.0000-0.3900.0000-0.0104.54595.454550.21038.889

3424.9486-1996.5669.00585109.101-5230.7100-53750#######VALUE!#VALUE!#VALUE!#VALUE!

00109.101109.101-5230.71000#VALUE!#######VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!