配色: 字号:
方格网法计算土石方表格(自动计算)
2020-05-09 | 阅:  转:  |  分享 
  
Sheet3

Sheet2

Sheet1

方格网法计算土石方量表

序号

方格网编号

方格网边长

施工后标高(h1)

自然标高(h2)

施工高度(h=h1-h2)

方格内平高度

方格网面积

挖方体积

填方体积

设计标高

a

b

第一点

第二点

第三点

第四点

挖(-)

填(+)



m3

合计

挖方体积(m3)

填方体积(m3)

复核:

计算:

1.00

1.00

8.90

6.00

174.60

174.60

174.60

174.60

176.25

176.32

176.12

176.35

-1.65

-1.72

-1.52

-1.75

-1.66

53.40

-88.64

176.60

2.00

2.00

8.90

6.00

174.60

174.60

174.60

174.60

176.32

176.25

176.35

176.25

-1.72

-1.65

-1.75

-1.65

-1.69

53.40

-90.38

3.00

3.00

8.90

6.00

174.60

174.60

174.60

174.60

176.25

176.30

176.25

176.25

-1.65

-1.70

-1.65

-1.65

-1.66

53.40

-88.78

4.00

4.00

8.90

6.00

174.60

174.60

174.60

174.60

176.30

176.30

176.25

176.45

-1.70

-1.70

-1.65

-1.85

-1.73

53.40

-92.12

5.00

5.00

8.90

6.00

174.60

174.60

174.60

174.60

176.30

176.20

176.45

176.40

-1.70

-1.60

-1.85

-1.80

-1.74

53.40

-92.78

6.00

6.00

8.90

6.00

174.60

174.60

174.60

174.60

176.20

176.15

176.40

176.35

-1.60

-1.55

-1.80

-1.75

-1.68

53.40

-89.45

7.00

7.00

8.90

6.00

174.60

174.60

174.60

174.60

176.12

176.35

176.05

176.40

-1.52

-1.75

-1.45

-1.80

-1.63

53.40

-87.04

8.00

8.00

8.90

6.00

174.60

174.60

174.60

174.60

176.35

176.25

176.40

176.35

-1.75

-1.65

-1.80

-1.75

-1.74

53.40

-92.78

9.00

9.00

8.90

6.00

174.60

174.60

174.60

174.60

176.25

176.25

176.35

176.45

-1.65

-1.65

-1.75

-1.85

-1.73

53.40

-92.12

10.00

10.00

8.90

6.00

174.60

174.60

174.60

174.60

176.25

176.45

176.45

176.50

-1.65

-1.85

-1.85

-1.90

-1.81

53.40

-96.79

11.00

11.00

8.90

6.00

174.60

174.60

174.60

174.60

176.45

176.40

176.50

176.35

-1.85

-1.80

-1.90

-1.75

-1.83

53.40

-97.46

12.00

12.00

8.90

6.00

174.60

174.60

174.60

174.60

176.40

176.35

176.35

176.55

-1.80

-1.75

-1.75

-1.95

-1.81

53.40

-96.79

-20.70

-1105.11

14.00

14.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

15.00

15.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

16.00

16.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

17.00

17.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

18.00

18.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

19.00

19.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

20.00

20.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

21.00

21.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

22.00

22.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

23.00

23.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

24.00

24.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

25.00

25.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

26.00

26.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

27.00

27.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

28.00

28.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

29.00

29.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

30.00

30.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

31.00

31.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

32.00

32.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

33.00

33.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

34.00

34.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

35.00

35.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

36.00

36.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

37.00

37.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

38.00

38.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

39.00

39.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

40.00

40.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

41.00

41.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

42.00

42.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

43.00

43.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

44.00

44.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

45.00

45.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

46.00

46.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

47.00

47.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

48.00

48.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

49.00

49.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

50.00

50.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

51.00

51.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

52.00

52.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

53.00

53.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

54.00

54.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

55.00

55.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

56.00

56.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

57.00

57.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

58.00

58.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

59.00

59.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

60.00

60.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

61.00

61.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

62.00

62.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

63.00

63.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

64.00

64.00

10.00

10.00

.00

.00

.00

.00

.00

100.00

.00

-2210.23

.00

献花(0)
+1
(本文系落笔下的寂...首藏)