市政道路土方EXCEL计算表(含公式)

路基土方工程量表序号 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 桩号 K0+ K0+ K0+ K0+ K0+ K0+ K0+ K0+ K0+ K0+ K0+ K0+ K0+ K0+ K0+ K0+ K0+ K0+ K1+ K1+ K1+ K1+ K1+ K1+ K1+ K1+ K1+ K1+ K1+ K1+ 620 640 660 680 720 740 760 780 800 820 840 860 880 900 920 940 960 980 0 20 40 60 80 100 120 140 160 180 200 220 现状高程 设计高程 挖填高度 95.41 95.15 94.54 94.08 93.98 93.93 94.16 95.2 95.57 95.77 95.75 95.25 93.65 93.64 93.88 94.07 94.57 94.99 95.22 93.31 39.28 36.31

93.35 39.33 93.31 93.85 94.02 93.99 93.94 93.91 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 1.1 1.36 1.97 2.43 2.53 2.58 2.35 1.31 0.94 0.74 0.76 1.26 2.86 2.87 2.63 2.44 1.94 1.52 1.29 3.2 57.23 60.2 3.16 57.18 3.2 2.66 2.49 2.52 2.57 2.6 设计主路宽度 距离 左路基 右路基 路宽 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 40 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 7 7 7 7 7 7 7 7 7 7 7 20 20 20 20 20 20 20 20 20 20 20 断面积(m2) 填 挖 25.188 29.407 40.382 49.143 51.2 52.159 39.083 28.57 22.676 23.12 7.229 25.831 55.7 55.805 50.844 47.197 37.579 13.131 10.29 34.168 37.582 36.948 36.189 36.707 36.985 27.319 24.629 25.124 25.839 26.324 0.108 平均面积(m2) 填 挖 33.9155 0 27.2975 0 34.8945 0 44.7625 0 50.1715 0 51.6795 0 45.621 0 33.8265 0 25.623 0 22.898 0 15.1745 0 16.53 0 40.7655 0 55.7525 0 53.3245 0 49.0205 0 42.388 0 25.355 0 11.7105 0 22.229 35.875 37.265 36.5685 36.448 36.846 32.152 25.974 24.8765 25.4815 26.0815 0.054 0.054 0 0 0 0 0 0 0 0 0 土方数(m3) 填 挖 678.31 0.00 545.95 0.00 697.89 0.00 895.25 0.00 2006.86 0.00 1033.59 0.00 912.42 0.00 676.53 0.00 512.46 0.00 457.96 0.00 303.49 0.00 330.60 0.00 815.31 0.00 1115.05 0.00 1066.49 0.00 980.41 0.00 847.76 0.00 507.10 0.00 234.21 0.00 18558.13 2003.03 444.58 1.08 717.50 1.08 745.30 0.00 731.37 0.00 728.96 0.00 736.92 0.00 643.04 0.00 519.48 0.00 497.53 0.00 509.63 0.00 521.63 0.00 备注

第 2 页，共 5 页

路基土方工程量表