土石方计算程序
- 格式: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!