### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- The angle between two vectors, Python version
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Fitting high order polynomials
- Time in hours and minutes between two dates
- Combining arrays
- Import Data from a Picture to Excel

### Recent Comments

dougaj4 on Beam Fixed End Actions by Maca… Peka Odendaal (@PKOd… on Beam Fixed End Actions by Maca… Gerardo Freyre on The history of the theory of b… dougaj4 on Time in hours and minutes betw… SDAmy on Time in hours and minutes betw… Concrete Stress Bloc… on Equivalent Stress Blocks Concrete Stress Bloc… on Stress blocks in AS 3600 Section Properties f… on Using Section Properties-… dougaj4 on ULS Design Functions and … dougaj4 on ULS Design Functions and … dougaj4 on Using LinEst() on data with… Eduardo Torres on Using LinEst() on data with… DonB on ULS Design Functions and … DonB on ULS Design Functions and … James D on ULS Design Functions and …

# Category Archives: Coordinate Geometry

## Section Properties for Rotated Shapes

I have just posted an update to my section properties spreadsheet, last discussed at: Using Section Properties- Group The new version can be downloaded from: Section Properties07-Group.zip The main sheet provides section properties for a wide variety of defined shapes: This … Continue reading

Posted in Beam Bending, Coordinate Geometry, Excel, Frame Analysis, Maths, Newton, UDFs, VBA
Tagged Excel, section properties, section properties of rotated shapes, UDF, VBA
Leave a comment

## Asymmetric Catenary Function

Back in 2009, I posted a user defined function (UDF) to generate a catenary curve, that could be used together with the Excel Solver to generate a curve of a specified span and sag: A catenary function Following a discussion … Continue reading

Posted in Coordinate Geometry, Curve fitting, Excel, Maths, Newton, UDFs, xlwings
Tagged Catenary, Excel, Solver, UDF, VBA
Leave a comment

## Plotting Mandelbrot

There are many sites discussing the Mandelbrot Set, but not many examples using VBA to plot the set in Excel, so here is my effort: The spreadsheet (including open source VBA code) may be downloaded from: Mandelbrot chart.zip Note that … Continue reading

Posted in Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, Newton, VBA
Tagged Charts, Excel, Mandelbrot Set, VBA
3 Comments

## More updates to ArcSpline and IP2

I have uploaded version 2.18 of the IP2 spreadsheet to: IP2.zip The new version includes updates to the IP, IP_4, and ArcSpline functions, as described below. The download is free and includes full open-source code. The IP and IP_4 functions find … Continue reading

Posted in Arrays, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged arcspline, Array function entry, Automatic re-size array functions, Excel, IP2.xlsb, Line intersections, UDFs, VBA
Leave a comment

## Arc-spline update

The input for the first version of the Arcspline function required the coordinates of the centre of each arc, as well as the angle of the tangents at each end of the arc. I have now added a new version with … Continue reading

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged Arc-spline function, Excel, IP2.xlsb, UDFs, VBA
7 Comments