### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Commenting a block of code in VBA
- Using LINEST for non-linear curve fitting
- The angle between two vectors, Python version
- Cubic Splines
- Fitting high order polynomials
- Drawing in Excel 7 - Creating drawings from coordinates
- Using Linest for non-linear curve fitting, examples, hints and warnings
- 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: VBA

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

## Cubic splines with jagged data

A cubic spline provides a good approximation to a smooth curve, and alternative versions are available for free download (see Daily Download 22: Splines and Curves, Update to AL-Spline-Matrix, and xlwSciPy 1.09 – update for xlwings 0.10 and Scipy 0.18.1), but if … Continue reading

Posted in Arrays, Beam Bending, Concrete, Curve fitting, Excel, Newton, UDFs, VBA
Tagged CSplineA, Cubic splines, Excel, fitting jagged data, MSplineA, UDF, VBA
2 Comments

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

## On not using Hungarian Notation, and VBA shortcuts

In June this year Michael Alexander at Bacon Bits had a post on using Hungarian Notation (or not). It contained the following quote from Stackoverflow, which for me sums up excellently a good reason for not using it: “vUsing adjHungarian nNotation vMakes … Continue reading

## Excel Uservoice and Python for Excel

The Excel Uservoice site is a forum for users to post suggestions for improvements to Excel. A suggestion to add native Python support to Excel, as a replacement to VBA, has had by far the most votes since the start, and … Continue reading

Posted in Computing - general, Excel, Link to Python, VBA
Tagged Excel, Python, survey, uservoice, VBA
1 Comment

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