Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Retrieving unique values from a range or array ...
- Latex Maths Text in Excel
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Automatic download of csv files
- Cubic Splines
- 3D Matplotlib Plots in Excel
- Contour plots with Excel and Matplotlib
- Downloads by category
Recent Comments
Tag Archives: coordinates
Area from Vectors
The previous post looked at User Defined Functions (UDFs) for working with vectors, including examples of functions to find the area of polygons defined by coordinates. In this post the functions will be extended to find other section properties (such … Continue reading
Posted in Arrays, Coordinate Geometry, Excel, Maths, UDFs, VBA
Tagged Area, coordinates, Excel, section properties, UDF, VBA, vectors
5 Comments
Section Properties from Coordinates
The area of irregular closed polygons defined by coordinates may be conveniently calculated by summing the areas of adjacent trapeziums, as shown below. The area of each trapezium is calculated from the X axis. Note that with the apex coordinates … Continue reading
Posted in Maths, Newton
Tagged Area, coordinates, first moment of area, polygon, second moment of area
2 Comments