方格网法计算土石方表格(自动计算)

,,,,方格网法计算土石方量表,,,,,,,,,,,,,,,,,

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

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

序号,方格网编号,方格网边长,,施工后标高（h1),,,,自然标高（h2）,,,,施工高度（h=h1-h2）,,,,方格内平高度,,方格网面积,挖方体积,填方体积,设计标高

,,a,b,第一点,第二点,第三点,第四点,第一点,第二点,第三点,第四点,第一点,第二点,第三点,第四点,挖（－）,填（＋）,㎡,m³,m³,

1,1,8.9,6,174.6,174.6,174.6,174.6,176.25,176.32,176.12,176.35,-1.65,-1.72,-1.52,-1.75,-1.66,,53.4,-88.644,,176.6

2,2,8.9,6,174.6,174.6,174.6,174.6,176.32,176.25,176.35,176.25,-1.72,-1.65,-1.75,-1.65,-1.6925,,53.4,-90.3795,,

3,3,8.9,6,174.6,174.6,174.6,174.6,176.25,176.3,176.25,176.25,-1.65,-1.7,-1.65,-1.65,-1.6625,,53.4,-88.7775,,

4,4,8.9,6,174.6,174.6,174.6,174.6,176.3,176.3,176.25,176.45,-1.7,-1.7,-1.65,-1.85,-1.725,,53.4,-92.115,,

5,5,8.9,6,174.6,174.6,174.6,174.6,176.3,176.2,176.45,176.4,-1.7,-1.6,-1.85,-1.8,-1.7375,,53.4,-92.7825,,

6,6,8.9,6,174.6,174.6,174.6,174.6,176.2,176.15,176.4,176.35,-1.6,-1.55,-1.8,-1.75,-1.675,,53.4,-89.445,,

7,7,8.9,6,174.6,174.6,174.6,174.6,176.12,176.35,176.05,176.4,-1.52,-1.75,-1.45,-1.8,-1.63,,53.4,-87.042,,

8,8,8.9,6,174.6,174.6,174.6,174.6,176.35,176.25,176.4,176.35,-1.75,-1.65,-1.8,-1.75,-1.7375,,53.4,-92.7825,,

9,9,8.9,6,174.6,174.6,174.6,174.6,176.25,176.25,176.35,176.45,-1.65,-1.65,-1.75,-1.85,-1.725,,53.4,-92.115,,

10,10,8.9,6,174.6,174.6,174.6,174.6,176.25,176.45,176.45,176.5,-1.65,-1.85,-1.85,-1.9,-1.8125,,53.4,-96.7875,,

11,11,8.9,6,174.6,174.6,174.6,174.6,176.45,176.4,176.5,176.35,-1.85,-1.8,-1.9,-1.75,-1.825,,53.4,-97.455,,

12,12,8.9,6,174.6,174.6,174.6,174.6,176.4,176.35,176.35,176.55,-1.8,-1.75,-1.75,-1.95,-1.8125,,53.4,-96.7875,,

,,,,,,,,,,,,,,,,-20.695,,,-1105.113,,

14,14,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

15,15,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

16,16,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

17,17,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

18,18,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

19,19,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

20,20,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

21,21,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

22,22,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

23,23,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

24,24,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

25,25,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

26,26,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

27,27,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

28,28,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

29,29,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

30,30,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

31,31,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

32,32,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

33,33,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

34,34,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

35,35,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

36,36,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

37,37,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

38,38,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

39,39,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

40,40,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

41,41,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

42,42,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

43,43,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

44,44,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

45,45,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

46,46,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

47,47,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

48,48,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

49,49,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

50,50,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

51,51,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

52,52,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

53,53,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

54,54,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

55,55,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

56,56,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

57,57,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

58,58,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

59,59,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

60,60,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

61,61,10,10,,,,,,,,,0,0,0,0,0,,100,0,,

62,62,10,10,,,,,