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

方格网法计算土石方量表序号方格网编号方格网边长施工后标高（h1) 自然标高（h2） 施工高度（h=h1-h2） 方格内平高度 方格网面积 挖方体积 填方体积第一点 第二点 第三点 第四点 第一点 第二点 第三点 第四点 第一点 第二点 第三点 第四点 挖（） 填（） m m1 1 42.036 1876.079 1876.247 1878.122 1878.314 1876.431 1876.598 1879.087 1879.431 -0.352 -0.351 -0.965 -1.117 -0.696 108.709 -75.6892 2 46.71 1876.247 1876.258 1878.097 1878.122 1876.598 1876.647 1879.349 1879.087 -0.351 -0.389 -1.252 -0.965 -0.739 132.134 -97.6903 3 51.649 1876.257 1876.157 1878.245 1878.097 1876.647 1876.356 1879.467 1879.349 -0.390 -0.199 -1.222 -1.252 -0.766 156.831 -120.0934 4 56.435 1876.157 1876.028 1878.324 1878.245 1876.356 1876.287 1879.518 1879.467 -0.199 -0.259 -1.194 -1.222 -0.719 180.764 -129.8795 5 61.222 1876.028 1876.149 1878.248 1878.324 1876.287 1876.428 1879.679 1879.518 -0.259 -0.279 -1.431 -1.194 -0.791 204.697 -161.8646 6 65.826 1876.149 1876.047 1878.007 1878.248 1876.428 1876.578 1879.413 1879.679 -0.279 -0.531 -1.406 -1.431 -0.912 227.707 -207.6127 7 70.795 1876.047 1876.018 1878.007 1878.891 1876.578 1876.308 1879.413 1879.037 -0.531 -0.290 -1.406 -0.146 -0.593 252.929 -150.0508 8 75.677 1876.018 1876.518 1878.407 1878.007 1878.308 1876.457 1879.614 1879.413 -2.290 0.061 -1.207 -1.406 -1.211 276.932 -335.2269 9 78.100 1876.518 1876.518 1878.014 1878.407 1876.457 1876.918 1879.247 1879.614 0.061 -0.400 -1.233 -1.207 -0.695 269.307 -187.101合计 -1465.204复 核： 计 算：方格网法计算土石方量表序号方格网编号方格网边长施工后标高（h1) 自然标高（h2） 施工高度（h=h1-h2） 方格内平高度 方格网面积 挖方体积 填方体积第一点 第二点 第三点 第四点 第一点 第二点 第三点 第四点 第一点 第二点 第三点 第四点 挖（） 填（） m m1 1 55 1878.079 1878.217 1878.197 1878.004 1878.731 1878.804 1878.525 1878.489 -0.652 -0.587 -0.328 -0.485 -0.513 150.000 -76.9502 2 55.029 1878.217 1878.008 1878.242 1878.197 1878.804 1878.541 1878.642 1878.525 -0.587 -0.533 -0.400 -0.328 -0.462 150.114 -69.3533 3 48.211 1879.008 1878.400 1878.027 1878.242 1878.541 1878.789 1878.579 1878.642 0.467 -0.389 -0.552 -0.400 -0.218 125.000 -27.3124 4 48.86 1878.400 1878.256 1878.017 1878.027 1878.789 1878.846 1878.245 1878.579 -0.389 -0.590 -0.228 -0.552 -0.440 75.000 -32.9815 5 41.79 1878.256 1878.647 1878.143 1878.017 1878.846 1878.846 1878.524 1878.245 -0.590 -0.199 -0.381 -0.228 -0.349 100.082 -34.9796 6 59.654 1878.004 1878.197 1878.138 1878.057 1878.489 1878.525 1879.428 1879.597 -0.485 -0.328 -1.290 -1.540 -0.911 192.145 -174.9967 7 53.428 1878.197 1878.242 1878.047 1878.089 1878.525 1878.642 1879.647 1879.728 -0.328 -0.400 -1.600 -1.639 -0.992 134.278 -133.1708 8 46.667 1878.142 1878.027 1878.097 1878.047 1878.642 1878.579 1879.517 1879.647 -0.500 -0.552 -1.420 -1.600 -1.018 111.111 -113.1119 9 53.333 1878.027 1878.017 1878.219 1878.097 1878.579 1878.245 1879.647 1879.517 -0.552 -0.228 -1.428 -1.420 -0.907 133.333 -120.93310 10 39.269 1878.017 1878.143 1878.142 1878.219 1878.245 1878.524 1879.597 1879.647 -0.228 -0.381 -1.455 -1.428 -0.873 88.435 -77.20411 11 54.8 1878.089 1878.047 1878.307 1878.138 1879.428 1879.647 1879.678 1879.428 -1.339 -1.600 -1.371 -1.290 -1.400 143.517 -200.92412 12 46.664 1878.047 1878.097 1878.217 1878.138 1879.647 1879.517 1879.643 1879.428 -1.600 -1.420 -1.426 -1.290 -1.434 111.104 -159.32313 13 42.505 1878.138 1878.217 1878.307 1878.417 1879.428 1879.643 1879.678 1879.524 -1.290 -1.426 -1.371 -1.107 -1.299 73.366 -95.26614 14 59.71 1878.097 1878.219 1878.089 1878.307 1879.517 1879.647 1879.542 1879.678 -1.420 -1.428 -1.453 -1.371 -1.418 184.472 -261.58115 15 33.941 1878.219 1878.142 1878.118 1878.089 1879.647 1879.597 1879.489 1879.542 -1.428 -1.455 -1.371 -1.453 -1.427 33.941 -48.425合计 -1626.508 复 核： 计 算：方格网法计算土石方量表方格网法计算土石方量表序号方格网编号方格网边长施工后标高（h1) 自然标高（h2） 施工高度（h=h1-h2） 方格内平高度 方格网面积 挖方体积 填方体积第一点 第二点 第三点 第四点 第一点 第二点 第三点 第四点 第一点 第二点 第三点 第四点 挖（） 填（） m m1 1 19.184 1877.314 1877.524 1877.478 1877.507 1878.454 1878.558 1878.671 1878.674 -1.140 -1.034 -1.193 -1.167 -1.133 22.960 -26.0252 2 20 1877.524 1877.617 1877.647 1877.478 1878.558 1879.758 1879.608 1878.671 -1.034 -2.141 -1.961 -1.193 -1.582 25.000 -39.5563 3 30.043 1877.617 1877.804 1877.879 1877.647 1879.758 1879.647 1879.668 1879.608 -2.141 -1.843 -1.789 -1.961 -1.933 50.212 -97.0854 4 25.043 1877.804 1877.795 1877.014 1877.897 1879.647 1879.747 1879.721 1879.668 -1.843 -1.952 -2.707 -1.771 -2.068 37.659 -77.8885 5 24.32 1877.795 1877.571 1877.314 1877.014 1879.747 1879.418 1880.066 1879.721 -1.952 -1.847 -2.752 -2.707 -2.315 35.800 -82.8596 6 25.68 1877.571 1877.617 1877.728 1877.314 1879.418 1880.274 1880.271 1880.066 -1.847 -2.657 -2.543 -2.752 -2.450 39.200 -96.0307 7 25 1877.617 1877.787 1877.508 1877.728 1880.274 1880.521 1879.628 1880.271 -2.657 -2.734 -2.120 -2.543 -2.513 42.857 -107.7218 8 25 1877.787 1877.809 1877.671 1877.508 1880.521 1880.542 1879.692 1879.628 -2.734 -2.733 -2.021 -2.120 -2.402 42.857 -102.9439 9 33.799 1877.809 1877.907 1878.514 1878.671 1880.542 1880.562 1880.762 1879.692 -2.733 -2.655 -2.248 -1.021 -2.164 59.436 -128.63410 10 19.184 1877.507 1877.478 1877.478 1877.047 1878.674 1878.671 1878.701 1878.679 -1.167 -1.193 -1.223 -1.632 -1.304 22.960 -29.93411 11 20 1877.478 1877.647 1877.457 1877.521 1878.671 1879.608 1879.688 1878.701 -1.193 -1.961 -2.231 -1.180 -1.641 25.000 -41.03112 12 30 1877.647 1877.879 1877.612 1877.457 1878.608 1878.668 1878.713 1878.668 -0.961 -0.789 -1.101 -1.211 -1.015 50.000 -50.77513 13 25 1877.879 1877.014 1877.647 1877.612 1878.668 1878.721 1878.776 1878.713 -0.789 -1.707 -1.129 -1.101 -1.182 37.500 -44.30614 14 24.32 1877.014 1877.314 1877.457 1877.646 1878.721 1879.066 1879.008 1878.776 -1.707 -1.752 -1.551 -1.130 -1.535 35.800 -54.95315 15 25.655 1877.314 1877.728 1878.314 1877.457 1879.066 1879.271 1879.403 1879.118 -1.752 -1.543 -1.089 -1.661 -1.511 39.103 -59.09416 16 25 1877.728 1877.508 1877.797 1877.314 1879.271 1879.628 1879.688 1879.057 -1.543 -2.120 -1.891 -1.743 -1.824 42.857 -78.18217 17 25 1877.508 1877.671 1877.027 1877.797 1878.628 1878.692 1878.721 1879.688 -1.120 -1.021 -1.694 -1.891 -1.431 37.500 -53.68118 18 33.816 1878.671 1876.514 1876.617 1877.027 1879.692 1877.762 1877.805 1878.721 -1.021 -1.248 -1.188 -1.694 -1.288 59.540 -76.67319 19 19.184 1877.047 1877.478 1877.218 1877.569 1878.679 1878.701 1878.773 1878.723 -1.632 -1.223 -1.555 -1.154 -1.391 22.960 -31.93720 20 20 1877.521 1877.457 1877.487 1877.218 1878.701 1879.668 1879.719 1878.773 -1.180 -2.211 -2.232 -1.555 -1.794 25.000 -44.86221 21 30 1877.457 1877.612 1877.478 1877.487 1879.668 1879.713 1878.838 1878.719 -2.211 -2.101 -1.360 -1.232 -1.726 50.000 -86.30022 22 25 1877.612 1877.647 1877.017 1877.408 1878.713 1878.776 1878.901 1878.838 -1.101 -1.129 -1.884 -1.430 -1.386 37.500 -51.97523 23 24.32 1877.647 1877.457 1876.508 1877.017 1878.776 1879.118 1878.212 1878.901 -1.129 -1.661 -1.704 -1.884 -1.594 35.800 -57.08324 24 25.68 1877.457 1877.314 1877.014 1876.508 1879.118 1878.403 1878.481 1878.212 -1.661 -1.089 -1.467 -1.704 -1.480 39.200 -58.02625 25 25 1877.314 1877.794 1876.579 1877.014 1878.403 1878.688 1878.892 1878.481 -1.089 -0.894 -2.313 -1.467 -1.441 37.500 -54.02826 26 25 1877.797 1877.027 1876.591 1876.579 1879.688 1878.721 1877.962 1877.892 -1.891 -1.694 -1.371 -1.313 -1.567 37.500 -58.77227 27 33.816 1877.027 1877.617 1875.647 1876.591 1878.721 1878.805 1877.072 1877.962 -1.694 -1.188 -1.425 -1.371 -1.420 59.540 -84.51728 28 19.185 1877.569 1877.218 1877.014 1877.628 1878.723 1878.773 1878.926 1878.841 -1.154 -1.555 -1.912 -1.213 -1.458 22.960 -33.48729 29 20 1877.218 1877.487 1877.418 1877.014 1878.773 1878.719 1878.829 1878.926 -1.555 -1.232 -1.411 -1.912 -1.527 25.000 -38.187小计 -1846.547 复 核： 计 算：方格网法计算土石方量表方格网法计算土石方量表序号方格网编号方格网边长施工后标高（h1) 自然标高（h2） 施工高度（h=h1-h2） 方格内平高度 方格网面积 挖方体积 填方体积第一点 第二点 第三点 第四点 第一点 第二点 第三点 第四点 第一点 第二点 第三点 第四点 挖（） 填（） m m30 30 30 1877.487 1877.408 1877.147 1877.418 1878.719 1878.838 1878.912 1878.829 -1.232 -1.430 -1.765 -1.411 -1.460 50.000 -72.97531 31 25 1876.408 1877.017 1876.647 1877.147 1877.838 1878.901 1877.937 1878.912 -1.430 -1.884 -1.290 -1.765 -1.592 37.500 -59.70932 32 24.3 1877.017 1875.508 1875.987 1876.647 1878.901 1877.212 1877.268 1877.937 -1.884 -1.704 -1.281 -1.290 -1.540 35.800 -55.12333 33 25.5 1875.508 1876.014 1876.314 1876.987 1877.212 1877.481 1877.523 1878.268 -1.704 -1.467 -1.209 -1.281 -1.415 39.200 -55.47834 34 25 1876.014 1876.579 1876.128 1876.314 1877.481 1877.892 1877.952 1877.523 -1.467 -1.313 -1.824 -1.209 -1.453 37.500 -54.49735 35 25 1876.579 1876.591 1876.078 1876.128 1877.892 1877.962 1877.073 1877.952 -1.313 -1.371 -0.995 -1.824 -1.376 37.500 -51.59136 36 33.816 1876.591 1875.647 1875.287 1875.078 1877.962 1877.072 1877.121 1877.073 -1.371 -1.425 -1.834 -1.995 -1.656 59.540 -98.61337 37 19.181 1877.628 1877.014 1876.507 1877.427 1878.841 1878.926 1878.012 1878.932 -1.213 -1.912 -1.505 -1.505 -1.534 22.960 -35.21538 38 20 1877.014 1877.418 1877.607 1876.507 1878.926 1878.829 1878.938 1878.012 -1.912 -1.411 -1.331 -1.505 -1.540 25.000 -38.49439 39 30 1877.418 1876.147 1876.287 1877.507 1878.829 1877.912 1877.897 1878.938 -1.411 -1.765 -1.610 -1.431 -1.554 50.000 -77.71340 40 25 1876.147 1876.647 1875.987 1876.287 1877.912 1877.937 1877.897 1877.897 -1.765 -1.290 -1.910 -1.610 -1.644 37.500 -61.64141 41 24.32 1876.647 1875.987 1875.849 1877.937 1877.268 1877.376 1877.897 -1.290 -1.281 -1.527 #VALUE! #VALUE! 35.800 #VALUE!42 42 25.5 1874.987 1875.314 1873.521 1875.849 1877.268 1877.523 1875.596 1877.373 -2.281 -2.209 -2.075 -1.524 -2.022 39.200 -79.27243 43 25 1875.314 1875.128 1872.914 1873.521 1877.523 1877.952 1875.011 1875.596 -2.209 -2.824 -2.097 -2.075 -2.301 37.500 -86.29744 44 25 1875.128 1875.078 1872.612 1872.914 1877.952 1877.073 1875.078 1875.011 -2.824 -1.995 -2.466 -2.097 -2.346 37.500 -87.95645 45 33.816 1875.078 1874.287 1872.428 1872.612 1877.073 1877.121 1875.271 1875.078 -1.995 -2.834 -2.843 -2.466 -2.534 59.540 -150.90446 46 19.181 1877.427 1877.507 1876.314 1876.017 1878.932 1878.012 1877.118 1877.112 -1.505 -0.505 -0.804 -1.095 -0.977 22.960 -22.43847 47 20 1877.507 1878.607 1876.308 1875.314 1878.012 1878.938 1878.271 1877.118 -0.505 -0.331 -1.963 -1.804 -1.151 25.000 -28.76948 48 30 1878.607 1876.287 1875.087 1876.308 1878.938 1877.897 1876.063 1878.271 -0.331 -1.610 -0.976 -1.963 -1.220 50.000 -61.00049 49 25 1876.287 1875.987 1876.014 1875.087 1877.897 1877.897 1877.303 1876.063 -1.610 -1.910 -1.289 -0.976 -1.446 37.500 -54.23450 50 24.32 1875.988 1875.849 1873.987 1876.014 1877.897 1877.373 1876.473 1877.303 -1.909 -1.524 -2.486 -1.289 -1.802 35.800 -64.51451 51 25.5 1875.849 1873.521 1873.687 1873.987 1877.373 1875.596 1875.987 1876.473 -1.524 -2.075 -2.300 -2.486 -2.096 39.200 -82.17352 52 25 1873.521 1872.914 1873.987 1873.687 1875.596 1875.011 1876.047 1875.987 -2.075 -2.097 -2.060 -2.300 -2.133 37.500 -79.98853 53 25 1872.914 1872.612 1873.017 1873.987 1875.011 1875.078 1875.261 1876.047 -2.097 -2.466 -2.244 -2.060 -2.217 37.500 -83.12854 54 33.816 1872.612 1872.428 1872.028 1873.017 1875.078 1875.271 1874.341 1875.261 -2.466 -2.843 -2.313 -2.244 -2.466 59.540 -146.85555 55 19.181 1876.017 1876.314 1876.087 1876.214 1877.112 1877.118 1877.292 1877.235 -1.095 -0.804 -1.205 -1.021 -1.031 22.960 -23.67756 56 20 1876.314 1876.308 1874.287 1876.087 1877.118 1878.271 1876.423 1877.292 -0.804 -1.963 -2.136 -1.205 -1.527 25.000 -38.17557 57 30 1876.308 1875.087 1873.814 1874.287 1878.271 1876.063 1876.501 1876.423 -1.963 -0.976 -2.687 -2.136 -1.940 50.000 -97.02558 58 25 1875.087 1876.014 1874.328 1874.814 1876.063 1877.303 1876.515 1876.501 -0.976 -1.289 -2.187 -1.687 -1.535 37.500 -57.553小计 #VALUE!复 核： 计 算：方格网法计算土石方量表方格网法计算土石方量表序号方格网编号方格网边长施工后标高（h1) 自然标高（h2） 施工高度（h=h1-h2） 方格内平高度 方格网面积 挖方体积 填方体积第一点 第二点 第三点 第四点 第一点 第二点 第三点 第四点 第一点 第二点 第三点 第四点 挖（） 填（） m m59 59 24.32 1876.014 1873.987 1874.897 1874.328 1877.303 1876.473 1876.651 1876.515 -1.289 -2.486 -1.754 -2.187 -1.929 35.800 -69.05860 60 25.5 1873.987 1873.687 1874.308 1874.897 1876.473 1875.987 1876.926 1876.651 -2.486 -2.300 -2.618 -1.754 -2.290 39.200 -89.74861 61 25 1873.687 1873.987 1874.418 1874.308 1875.987 1876.047 1876.259 1876.926 -2.300 -2.060 -1.841 -2.618 -2.205 37.500 -82.67862 62 25 1873.987 1873.017 1874.414 1874.418 1876.047 1875.261 1876.897 1876.259 -2.060 -2.244 -2.483 -1.841 -2.157 37.500 -80.88763 63 33.816 1873.017 1872.028 1874.278 1874.414 1875.261 1874.341 1876.641 1876.897 -2.244 -2.313 -2.363 -2.483 -2.351 59.540 -139.96464 64 19.181 1876.214 1876.087 1875.567 1875.328 1877.235 1877.292 1876.501 1876.393 -1.021 -1.205 -0.934 -1.065 -1.056 22.960 -24.25165 65 20 1876.087 1874.287 1874.278 1875.657 1877.292 1876.423 1876.511 1876.501 -1.205 -2.136 -2.233 -0.844 -1.604 25.000 -40.11266 66 30 1874.287 1874.841 1875.978 1876.278 1876.423 1876.501 1876.523 1876.511 -2.136 -1.660 -0.545 -0.233 -1.143 50.000 -57.17567 67 25 1874.814 1874.328 1875.647 1875.978 1876.501 1876.515 1876.625 1876.523 -1.687 -2.187 -0.978 -0.545 -1.349 37.500 -50.59768 68 24.32 1874.328 1874.897 1875.997 1875.647 1876.515 1876.651 1876.793 1876.625 -2.187 -1.754 -0.796 -0.978 -1.429 35.800 -51.14969 69 25.5 1874.897 1874.308 1874.214 1875.997 1876.651 1876.926 1875.023 1876.793 -1.754 -2.618 -0.809 -0.796 -1.494 39.200 -58.57570 70 25 1874.308 1874.418 1875.018 1874.214 1876.926 1876.259 1875.401 1875.023 -2.618 -1.841 -0.383 -0.809 -1.413 37.500 -52.97871 71 25 1874.418 1874.414 1874.608 1874.018 1