### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Commenting a block of code in VBA
- Fitting 3D circles to scattered points
- Contour plots with Excel and Matplotlib
- Using Goal Seek on Multiple Cells

### Recent Comments

Sukrit Ghorai on Biaxial bending update dougaj4 on Biaxial bending update Sukrit on Biaxial bending update A not so easy proble… on Pint, MPmath and implied units… dougaj4 on ULS design of circular reinfor… Dakota on ULS design of circular reinfor… Marcus747 on Commenting a block of code in… dougaj4 on Biaxial bending update Sukrit on Biaxial bending update DT67 on Using ConbeamU DT67 on Using ConbeamU dougaj4 on Using ConbeamU DT67 on Using ConbeamU DT67 on Using ConbeamU dougaj4 on Biaxial bending update

# Tag Archives: Area

## 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 Without VBA

At the Eng-Tips forum there was a question asking for a calculation of area and centroid values from coordinates without the use of VBA. In my opinion using VBA is much the easiest and most robust way to do it, … Continue reading

Posted in Coordinate Geometry, Excel, Newton, UDFs, VBA
Tagged Area, Centroid, Excel, section properties, UDF, VBA
13 Comments

## Cubic Spline Update

The previous post in this series presented a User Defined Function (UDF) to fit a cubic spline to a series of points defined by XY coordinates. Each segment of the resulting spline is defined by a separate cubic curve, which may be … Continue reading

## Elegant proofs 2 – The area of a circle

We are so familiar with the formula for the area enclosed by a circle that we tend not to think much about how it was derived, at least I don’t. The proofs of the formula are in fact many and … Continue reading

## Section Properties from Layers

An alternative to finding the section properties of irregular polygons from the coordinates of the corners is to divide the shape into rectangular or trapezoidal layers. The properties of the shape may then be found by simply summing the properties … Continue reading

Posted in Maths, Newton, Uncategorized
Tagged Area, first moment of area, layers, second moment of area, section properties
1 Comment