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

方格网法计算土石方量表序号方格网编号方格网边长 施工后标高（h1) 自然标高（h2） 施工高度（h=h1-h2） 方格内平高度 方格网面积 挖方体积 填方体积a b 第一点 第二点 第三点 第四点 第一点 第二点 第三点 第四点 第一点 第二点 第三点 第四点 挖（） 填（） m m1 1 10 10 165.27 165.12 165.715 165.305 165.26 165.01 165.19 164.73 0.01 0.11 0.525 0.575 0.305 100 30.52 2 10 10 100 03 3 10 10 0 0 0 0 0 100 04 4 10 10 164.82 164.67 164.805 164.645 164.15 163.2 163.99 162.93 0.67 1.47 0.815 1.715 1.167 100 116.755 5 10 10 164.67 164.52 164.645 164.425 163.2 163.03 162.93 162.73 1.47 1.49 1.715 1.695 1.593 100 159.256 6 10 10 164.52 164.37 164.425 164.25 163.3 162.74 162.73 162.57 1.22 1.63 1.695 1.68 1.556 100 155.6257 7 10 10 164.37 164.41 164.25 164.47 162.74 162.75 162.57 162.19 1.63 1.66 1.68 2.28 1.813 100 181.258 8 10 10 164.41 164.47 164.47 164.47 162.75 162.74 162.19 162.21 1.66 1.73 2.28 2.26 1.982 100 198.259 9 10 10 164.47 164.53 164.47 164.47 162.74 162.75 162.21 162.54 1.73 1.78 2.26 1.93 1.925 100 192.510 10 10 10 164.53 164.59 164.47 164.47 162.75 162.56 162.54 162.48 1.78 2.03 1.93 1.99 1.933 100 193.2511 11 10 10 164.59 164.65 164.47 164.47 162.56 162.86 162.48 162.56 2.03 1.79 1.99 1.91 1.93 100 19312 12 10 10 164.65 164.71 164.47 164.47 162.86 163.02 162.56 162.71 1.79 1.69 1.91 1.76 1.787 100 178.7513 13 10.8 10 164.71 164.77 164.47 164.59 163.02 163.02 162.71 163.08 1.69 1.75 1.76 1.51 1.677 108 181.1714 14 10 10 165.715 165.305 165.25 165.435 165.19 164.73 165.2 164.83 0.525 0.575 0.05 0.605 0.439 100 43.87515 15 10 10 0 0 0 0 0 100 016 16 10 10 0 0 0 0 0 100 017 17 10 10 164.805 164.645 165.435 165.435 163.99 162.93 163.81 162.95 0.815 1.715 1.625 2.485 1.66 100 16618 18 10 10 164.645 164.425 165.435 165.435 162.93 162.73 162.95 162.57 1.715 1.695 2.485 2.865 2.19 100 21919 19 10 10 164.425 164.25 165.435 164.15 162.73 162.57 162.57 162.56 1.695 1.68 2.865 1.59 1.958 100 195.7520 20 10 10 164.25 164.47 164.15 165.105 162.57 162.19 162.56 162.16 1.68 2.28 1.59 2.945 2.124 100 212.37521 21 10 10 164.47 164.47 165.105 165.105 162.19 162.21 162.16 162.02 2.28 2.26 2.945 3.085 2.642 100 264.2522 22 10 10 164.47 164.47 165.105 165.105 162.21 162.54 162.02 162.45 2.26 1.93 3.085 2.655 2.482 100 248.2523 23 10 10 164.47 164.47 165.105 165.105 162.54 162.48 162.45 162.47 1.93 1.99 2.655 2.635 2.303 100 230.2524 24 10 10 164.47 164.47 165.105 165.105 162.48 162.56 162.47 162.55 1.99 1.91 2.635 2.555 2.272 100 227.2525 25 10 10 164.47 164.47 165.105 165.105 162.56 162.71 162.55 162.75 1.91 1.76 2.555 2.355 2.145 100 214.526 26 10.4 10 164.47 164.59 165.105 164.47 162.71 163.08 162.75 162.86 1.76 1.51 2.355 1.61 1.809 104.4 188.83327 27 10 10 0 0 0 0 0 100 028 28 10 10 0 0 0 0 0 100 029 29 10 10 165.435 165.435 164.77 164.203 165.435 163.81 164.254 163.83 0 1.625 0.516 0.373 0.629 100 62.8530 30 10 10 165.432 165.435 164.203 164.152 163.81 162.95 163.83 163.03 1.622 2.485 0.373 1.122 1.4 100 140.0531 31 10 10 165.435 165.435 164.152 164.101 162.95 162.57 163.03 162.56 2.485 2.865 1.122 1.541 2.003 100 200.32532 32 10 10 165.435 164.15 164.101 164.05 162.57 162.56 162.56 162.51 2.865 1.59 1.541 1.54 1.884 100 188.433 33 10 10 164.15 165.105 164.05 163.998 162.56 162.16 162.51 162.13 1.59 2.945 1.54 1.868 1.986 100 198.57534 34 10 10 165.105 165.105 163.998 163.944 162.16 162.02 162.13 161.69 2.945 3.085 1.868 2.254 2.538 100 253.835 35 10 10 165.105 165.105 163.944 163.89 162.02 162.45 161.69 162.48 3.085 2.655 2.254 1.41 2.351 100 235.136 36 10 10 165.105 165.105 163.89 163.836 162.45 162.47 162.48 162.37 2.655 2.635 1.41 1.466 2.041 100 204.1537 37 10 10 165.105 165.105 163.836 163.782 162.47 162.55 162.37 162.36 2.635 2.555 1.466 1.422 2.019 100 201.9538 38 10 10 165.105 165.105 163.782 163.728 162.55 162.75 162.36 162.63 2.555 2.355 1.422 1.098 1.857 100 185.7539 39 10 10 165.105 164.47 163.728 163.728 162.75 162.86 162.63 162.76 2.355 1.61 1.098 0.968 1.508 100 150.77540 40 10 10 0 0 0 0 0 100 041 41 10 10 0 0 0 0 0 100 042 42 10 10 164.77 164.203 164.44 164.38 164.254 163.83 164.43 164.29 0.516 0.373 0.01 0.09 0.247 100 24.72543 43 10 10 164.203 164.152 164.38 164.317 163.83 163.03 164.29 162.9 0.373 1.122 0.09 1.417 0.75 100 75.0544 44 10 10 164.152 164.101 164.317 164.255 163.03 162.56 162.9 162.38 1.122 1.541 1.417 1.875 1.489 100 148.87545 45 10 10 164.101 164.05 164.255 163.95 162.56 162.51 162.38 162.29 1.541 1.54 1.875 1.66 1.654 100 165.446 46 10 10 164.05 163.998 163.95 164.23 162.51 162.13 162.29 161.57 1.54 1.868 1.66 2.66 1.932 100 193.247 47 10 10 163.998 163.944 164.23 164.15 162.13 161.69 161.57 161.68 1.868 2.254 2.66 2.47 2.313 100 231.348 48 10 10 163.944 163.89 164.15 164.09 161.69 162.48 161.68 162.25 2.254 1.41 2.47 1.84 1.993 100 199.3549 49 10 10 163.89 163.836 164.09 164.04 162.48 162.37 162.25 162.23 1.41 1.466 1.84 1.81 1.632 100 163.1550 50 10 10 163.836 163.782 164.04 163.985 162.37 162.36 162.23 162.23 1.466 1.422 1.81 1.755 1.613 100 161.32551 51 10 10 163.782 163.728 163.985 163.955 162.36 162.63 162.23 162.52 1.422 1.098 1.755 1.435 1.428 100 142.7552 52 9.39 10 163.728 163.728 163.955 163.955 162.63 162.76 162.52 162.7 1.098 0.968 1.435 1.255 1.189 93.9 111.64753 53 10 10 0 0 0 0 0 100 054 54 10 10 0 0 0 0 0 100 055 55 10 10 164.44 164.38 165.08 165.08 164.43 164.29 163.85 163.94 0.01 0.09 1.23 1.14 0.618 100 61.7556 56 10 10 164.38 164.317 165.08 165.08 164.29 162.9 163.94 163.08 0.09 1.417 1.14 2 1.162 100 116.17557 57 10 10 164.317 164.255 165.08 165.08 162.9 162.38 163.08 162.24 1.417 1.875 2 2.84 2.033 100 203.358 58 10 10 164.255 163.95 165.08 163.85 162.38 162.29 162.24 162.07 1.875 1.66 2.84 1.78 2.039 100 203.87559 59 10 10 163.95 164.23 163.85 164.815 162.29 161.57 162.07 161.52 1.66 2.66 1.78 3.295 2.349 100 234.87560 60 10 10 164.23 164.15 164.815 164.815 161.57 161.68 161.52 161.48 2.66 2.47 3.295 3.335 2.94 100 29461 61 10 10 164.15 164.09 164.815 164.815 161.68 162.25 161.48 162.1 2.47 1.84 3.335 2.715 2.59 100 25962 62 10 10 164.09 164.04 164.815 164.815 162.25 162.23 162.1 162.06 1.84 1.81 2.715 2.755 2.28 100 22863 63 10 10 164.04 163.985 164.815 164.815 162.23 162.23 162.06 162.09 1.81 1.755 2.755 2.725 2.261 100 226.12564 64 10 10 163.985 163.955 164.815 164.812 162.23 162.52 162.09 162.1 1.755 1.435 2.725 2.712 2.157 100 215.67565 65 10 10 163.955 163.955 164.812 164.715 162.52 162.7 162.1 162.44 1.435 1.255 2.712 2.275 1.919 100 191.92566 66 10 10 0 0 0 0 0 100 067 67 10 10 165.08 165.08 164.18 164.074 164.63 163.85 163.51 163.35 0.45 1.23 0.67 0.724 0.769 100 76.8568 68 10 10 165.08 165.08 164.074 164.021 163.85 163.94 164.074 164.021 1.23 1.14 0 0 0.593 100 59.2569 69 10 10 165.08 165.08 164.021 163.968 163.94 163.08 163.49 162.48 1.14 2 0.531 1.488 1.29 100 128.97570 70 10 10 165.08 165.08 163.968 163.915 163.08 162.24 163.968 163.915 2 2.84 0 0 1.21 100 12171 71 10 10 165.08 163.85 163.915 163.731 162.24 162.07 163.915 163.731 2.84 1.78 0 0 1.155 100 115.572 72 10 10 163.85 164.815 163.731 163.915 162.07 161.52 163.731 163.915 1.78 3.295 0 0 1.269 100 126.87573 73 10 10 164.815 164.815 163.915 163.83 161.52 161.48 161.03 161.08 3.295 3.335 2.885 2.75 3.066 100 306.62574 74 10 10 164.815 164.815 163.83 163.75 161.48 162.1 161.08 161.67 3.335 2.715 2.75 2.08 2.72 100 27275 75 10 10 0 0 0 0 0 100 076 76 10 10 0 0 0 0 0 100 077 77 10 10 0 0 0 0 0 100 078 78 10 10 0 0 0 0 0 100 079 79 10 10 0 0 0 0 0 100 080 80 10 10 0 0 0 0 0 100 081 81 10 10 0 0 0 0 0 100 082 82 10 10 0 0 0 0 0 100 083 83 10 10 0 0 0 0 0 100 084 84 10 10 0 0 0 0 0 100 085 85 10 10 0 0 0 0 0 100 086 86 10 10 0 0 0 0 0 1