### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Cubic Splines
- The angle between two vectors, Python version
- Drawing in Excel 7 - Creating drawings from coordinates
- Fitting high order polynomials
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Solving cubic and quartic equations with Excel

### Recent Comments

More Python rotation… on Fitting 3D circles to scattere… Ana Sofía on Indexing NumPy arrays with flo… Soren Hauch on Update to Glob_to_loc3 and Loc… dougaj4 on RCInteract and RC Design Funct… Lorenzo Castellani on RCInteract and RC Design Funct… dougaj4 on Update to Glob_to_loc3 and Loc… Fitting 3D circles t… on Update to Glob_to_loc3 and Loc… Soren Hauch on Update to Glob_to_loc3 and Loc… dougaj4 on Cubic splines with jagged… Bob Jordan on Cubic splines with jagged… dougaj4 on Update to Glob_to_loc3 and Loc… Cubic splines with j… on xlwSciPy 1.09 – update f… Cubic splines with j… on Update to AL-Spline-Matrix Cubic splines with j… on Daily Download 22: Splines and… Soren Hauch on Update to Glob_to_loc3 and Loc…

# Category Archives: Maths

## More Python rotation functions

The code described in the previous post includes a Python function that rotates 3D coordinates by an angle defined with two vectors, using Rodrigue’s Rotation. I have now added this function to the IP2_py spreadsheet, where it is used in the … Continue reading

Posted in Coordinate Geometry, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged Excel, fit 3D circle, Numpy, Python, RPView, UDF, VBA, xlwings, xl_RPView
Leave a comment

## Fitting 3D circles to scattered points

Following a comment at update-to-glob_to_loc3-and-loc_to_glob3-functions, I have modified the Python code at the linked site, so it can be run from Excel, via xlwings. The spreadsheet described below, and the associated Python code, can be download from: 3DCirc.zip The original … Continue reading

Posted in Coordinate Geometry, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged 3DCirc, Excel, fit 3D circle, Numpy, Python, UDF, VBA, xlwings
1 Comment

## Evaluating text with units and finding the neutral axis

A few weeks ago a comment asked for guidance on finding the moment capacity of a reinforced concrete section. This post will look at finding the depth of the neutral axis (NA) in a rectangular section, with a single layer of … Continue reading

Posted in Beam Bending, Concrete, Excel, Maths, Newton, UDFs, VBA
Tagged depth of neutral axis, elastic analysis, EvalU, evaluate text strings, evaluate units, Excel, Reinforced Concrete, UDF, ULS analyis, unit aware, VBA
2 Comments

## Section Properties with MeshPY, including torsion and warping

I recently discovered robbie van leeuwen’s structural engineering blog, which has an open-source set of Python routines for calculation of section properties, including torsion and warping constants. The program uses the MeshPY Library for generating the finite element meshes required … Continue reading

Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Strand7, UDFs, VBA, xlwings
Tagged Excel, MatPlotlib, MeshPY, Python, section properties, Torsion, UDF, VBA, Warping
4 Comments

## Brent’s Method; Update and Examples

Has the free software at this site saved you time and/or money? If so, please contribute to the Raw Impact charity group providing practical help to poor communities in Cambodia: Everydayhero – Cambodia 2018 All contributions gratefully accepted. Contributions are … Continue reading

Posted in Arrays, Excel, Maths, Newton, UDFs, VBA
Tagged Brents method, Excel, inverse quadratic, iterative solution, Maths, UDF, VBA
Leave a comment

## Update to AL-Spline-Matrix

Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA
Tagged AlgLib, Cubic spline, Excel, spline curve fitting, UDF, VBA, weights and constraints
1 Comment

## Hofstadter, Pahud, Bach

The latest ACO concert series features the Swiss flautist Emmanuel Pahud (interview here). The performance included J.S. Bach’s 6 Part Ricercar, from The Musical Offering, which was the inspiration for the final dialogue in Douglas Hofstadter’s Godel, Esher, Bach: Achilles … Continue reading

Posted in Bach, Maths, Newton
Tagged AC0, Bach, Douglas Hofstadter, Emmanuel Pahud, Godel Escher Bach, Ricercar a 6
Leave a comment