EXCEL常用测量公式计算

EXCEL常用测量公式计算°′″252525角点后点1023645求点1求点21163245ABCS=S=ABCDS=S=ABCDEFGHIJS=S=6圆面积RS=S=7椭圆面积abS=S=a°′″602530a°′″602530注:浅兰色单元格为可输入数据区,其他单元格不可操作44676.98144676.9815000.0405000.04010000.00010000.000多边形面积计算(五至十边)950.000813.3971000.000900.0001173.2051100.0001000.0001086.6031100.000950.0001086.603850.0001000.0001000.0001000.0001200.0001013.2051203.9231113.2051203.923Cy*Dx-Dy*Ax)950.000S=0.5×abs(Ax*By+Bx*Cy+200.000100.000100.000200.000200.000100.00078.2351000.00023206.780方位角Cx*Ay-Ay*Bx-By*Cx-Cy*Ax)三角形面积计算YXYXYB1256.120X1013.205坐标正算1253.6551253.655120.520X2569.95023457.580水平角距离1372.7401372.740Y200.000坐标反算13.77513.775A1000.000距离100.000任意四边形面积计算S=0.5×abs(Ax*By+Bx*Cy+Cx*Dy+Dx*Ay-Ay*Bx-By*Cx-813.39723487.99323487.9931203.923900.0001086.603850.00023535.77623535.7761200.000S=πR²S=π/4*a*b(式中a为长半径、b为短半径）12.500125.000S=S=57.78357.783103.084103.084S=S=329.567329.56749087.38549087.385S=π(R²-r²)(其中R为外圆半径,r为内圆半径)扇形面积S=a/360*π*R²(其中a为扇形弧所对圆心角)R25.000弓形面积S=0.5*R²(a*π/180-sina)(其中a为弓形弧所对圆心角)R25.000常用公式计算常用公式计算10