坐标法计算面积.xls

操作说明： 本软件根据各转折点坐标（xi,yi)计算多边形面积，您只需在表中输入各测点 的坐标即可自动求出闭合多边形的面积（注意：闭合多边形不得出现为左图这种交 叉，若有交叉，应沿交叉点分开成单独的闭合多边形再求面积之和）。公式及示意 图如下： 开发：狗尾草 坐标法计算面积 n 1i i1i1ii yxyx 2 1 A 此处可输入如：测量、计算等人员信息。 坐标 测点 xy 本多边形面积（m2） 1476216.073249340.75952171568.16 2476182.6833249332.069588035.808 3476176.1453249327.7177030179.21 4476170.3773249317.885-1323992.10 5476169.483249306.203-1695610.24 6476169.0893249296.413-34626951.98 7476180.9543249231.938-36201418.17 8476201.4613249219.819-10243141.79 9476208.0723249221.907-18624255.23 10476215.9023249197.11310528405.64 11476209.1073249194.96812178986.12 12476198.6683249174.892-56176717.39 13476222.2863249100.103-1729815.61 14476222.9193249097.157-7239960.24 15476224.9053249080.301-1729813.20 16476225.5383249077.355-96126349.61 17476265.9523248949.381-37927300.45 18476285.6653248924.588-28707388.91 19476301.7723248913.913-15568248.14 20476311.1623248912.592-35609356.60 21476334.1473248919.851-18624397.47 22476341.9773248895.0587386680.31 23476337.2093248893.55245030938.73 24476305.0883248863.545333034.41 25476299.8453248850.171-1340680.79 26476299.5963248842.843-82451795.60 27476334.261324873307 28476363.3783248640.874-39697694.90 29476383.8363248613.721-28707271.83 30476399.944324860396 31476409.3333248601.725-35607051.95 32476432.3193248608.984#REF! #REF!476440.1463248584.19#REF! #REF!476435.3813248582.685#REF!# #REF!476403.2593248552.67345026097.18 #REF!476398.0163248539.3045331563.25 #REF!476397.7683248531.975-1342941.66 #REF!476455.4723248349.251-137251297.42 #REF!476471.911324832597 #REF!476507.531324829605 #REF!476517.7883248294.105-17125387.23 坐标法计算面积 #REF!476544.9663248302.688-42096092.51 #REF!476552.7993248277.886-18631611.60 #REF!476548.0283248276.397392305.40 #REF!476519.4063248253.57941050814.88 #REF!476502.0013248223.93521204956.14 #REF!476500.9973248215.053-485536.97 #REF!476557.8783248034.938-135293348.75 #REF!476574.3173248010.741-32462858.66 #REF!476596.0913247994.644-39196801.33 #REF!476615.9593247983.238-34983606.30 #REF!476643.1373247991.821-42091446.83 #REF!476650.967324796763 #REF!476646.1993247965.5227384235.22 #REF!476617.5783247942.71241043860.70 #REF!476600.1723247913.06821202419.68 #REF!476599.1693247904.186-487752.96 #REF!476656.1613247723.716-135558203.70 #REF!476678.5093247695.635-42982555.63 #REF!476712.7773247675.451-60456656.52 #REF!476720.9443247674.523-13483077.43 #REF!476779.7823247693.104-91114360.86 #REF!476895.5653247701.942-185906935.47 #REF!477003.2623247658.525-185236565.40 #REF!477182.443247532.516-321007831.62 #REF!477362.13247504.718-298358204.65 #REF!477374.5253247508.641-19238777.30 #REF!477317.913247687.915134719271.15 #REF!477320.7713247688.818-4430308.53 #REF!477311.7373247717.42621497406.70 #REF!477309.6223247716.7583275039.06 #REF!477306.2883247718.4915827532.62 #REF!477236.3813247939.858166349058.80 #REF!477212.8043247932.41236511587.97 #REF!477208.6783247945.4779817877.21 #REF!477123.5173248110.873177763345.64 #REF!477125.2523248114.212-2021178.47 #REF!477198.2683248137.337-113065392.93 #REF!477090.6983248477.966255974851.09 #REF!477071.243248471.50730063677.72 #REF!476982.4943248752.527211177706.11 #REF!477002.0423248758.7-30281100.73 #REF!476894.4453249099.414256038981.79 #REF!476867.7453249090.98241364890.20 #REF!476803.1083249295.661153808153.49 #REF!476544.0483249315.563425625934.70 #REF!538855511.78 #REF! 476216.073249340.759 476192.6833249332.0671849728.74 476176.1453249327.71751669348.79 476170.3773249317.88514060358.41 476169.483249306.203-2647984.201 476169.0893249296.413-3391220.484 476180.9543249231.938-69253903.95 476201.4613249219.819-72402836.33 476208.0723249221.907-20486283.57 476215.9023249197.113-37248510.47 476209.1073249194.96821056811.27 476198.6683249174.89224357972.24 476222.2863249100.103-112353434.8 476222.9193249097.157-3459631.219 476224.9053249080.301-14479920.48 476225.5383249077.355-3459626.401 476265.9523248949.381-192252699.2 476285.6653248924.588-75854600.9 476301.7723248913.913-57414777.81 476311.1623248912.592-31136496.28 476334.1473248919.851-71218713.2 476341.977324889594 476337.2093248893.55214773360.62 476305.0883248863.5490061877.47 476299.845324885082 476299.5963248842.843-2681361.572 476334.2613248733.075-164903591.2 476363.3783248840.874-43245003.94 476383.8363248813.721-79399481.4 476399.9443248603.045-152694532.5 476409.3333248601.725-31129981.92 476432.3193248608.984-71214103.9 476432.3193248608.9840 476440.1463248584.19-37239525.44 476435.3813248582.68514762461.25 476403.2593248552.67390052194.35 476398.0163248539.30410663126.5 476397.7683248531.975-2685883.312 476455.4723248349.251-274502594.8 476471.911324829698 476507.5313248296.063-115704305.8 476517.7883248294.105-34250774.46 476544.9663248302.688-84192185.01 476552.7993248277.886-37263223.2 476548.0283248276.3914784610.81 476519.4063248253.57982101629.77 476502.0013248223.93542409912.27 476500.9973248215.053-971073.9421 476557.8783248034.938-270586697.5 476574.3173248010.741-64925717.32 476596.0913247994.644-78393602.66 476615.9593247983.238-69967212.6 476643.1373247991.821-84182893.67 476650.967324796725 476646.1993247965.52214768470.43 476617.5783247942.71282087721.41 476600.1723247913.06842404839.36 476599.1693247904.186-975505.9204 476656.1613247723.716-271116407.4 476678.5093247695.635-85965111.26 476712.7773247675.451-120913313 476720.9443247674.523-26966154.87 476779.7823247693.104-182228721.7 476895.5653247701.942-371813870.9 477003.2623247658.525-370473130.8 477182.443247532.516-642015663.2 477362.13247504.715-596717840.8 477374.5253247508.641-38476122.48 477317.91324768