### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Downloads by category
- Drawing in Excel 7 - Creating drawings from coordinates
- The angle between two vectors, Python version
- Downloads
- Fine as a Bee's wing
- Section Properties with MeshPY, including torsion and warping
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Daily Download 8: Drawing in Excel

### Recent Comments

Bouarfa Mahi on Using the AlgLib ODE (Runge-Ku… dougaj4 on Using the AlgLib ODE (Runge-Ku… Bouarfa Mahi on Using the AlgLib ODE (Runge-Ku… Larry on Scarborough Fair g2-9ed9acc685824c666… on Scarborough Fair Daniel Crotzer on About Newton Excel Bach More SciPy Solvers |… on xlwSciPy update for Python… Graeme Dennes on Numerical Integration; Tanh-Si… Paul on Numerical Integration; Tanh-Si… Graeme Dennes on Numerical Integration; Tanh-Si… Paul on Numerical Integration; Tanh-Si… Paris Altidis on Numerical Integration; Tanh-Si… Erik Wynn on Cubic Splines dougaj4 on Cubic Splines Erik Wynn on Cubic Splines

# Tag Archives: UDF

## Numerical Integration; Tanh-Sinh Quadrature v. 4.4

Update 27 Nov 2018: Version 4.41 now available from the link below, with minor modifications for compatibility with Excel 2007. I recently received a new version (4.4) of the numerical integration spreadsheet by Graeme Dennes which is now available for … Continue reading

Posted in Charts, Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Double Exponential, Excel, Gauss-Kronrod, numerical integration, Romberg, Tanh-Sinh method, Tanh-Sinh Quadrature, UDF, VBA
9 Comments

## AS 3600 and RC Design Functions 8.01

The updated RC Design Functions spreadsheet (presented here) included an updated UMom function to find the ultimate strength of a rectangular section under combined bending and axial load; but I omitted to include the revisions to the alpha2 and Gamma … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, Excel, Rectangular stress block factors, Reinforced Concrete Design Functions, UDF, ULS design, VBA
Leave a comment

## Arcs and arc-splines

I have added two user defined functions (UDFs) to the IP2 spreadsheet to generate coordinates for a single arc, or a series of arcs connected (if necessary) by straight lines. The new version may be downloaded from: IP2.zip As an example … Continue reading

## New Tricks …

… or in some cases, old but forgotten tricks. The first comes from a Quora question, asking for the most underutilised feature in Excel. When de-bugging a VBA routine you can set a break point where the code will stop: … Continue reading

## VBA vs Power Query vs Python

A recent post at Chandoo’s Excel Forum asked for a formula to extract all pairs of digits from a number with 4 digits. This was soon extended to dealing with longer numbers, and the examples looked at here will work with … Continue reading

Posted in Arrays, Excel, Link to Python, UDFs, VBA, xlwings
Tagged Chandoo, Excel, itertools, Power Query, Python, UDF, VBA, xlwings
Leave a comment

## Units and solvers with Pint and Sympy

Following the previous post I have adapted the units code to use the Pint package, and added a function using the Sympy equation solver, with Pint units. I have applied the functions to finding the depth of neutral axis of a … Continue reading

Posted in Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, UDFs, VBA, xlwings
Tagged Evaluate text, evaluate units, Excel, Pint, Python, Solve text, Sympy, UDF, unit aware, Units, VBA, xlwings
Leave a comment

## Using Section Properties- Group

Following a recent comment I have updated the documentation for finding the section properties of groups of shapes in the Section-Properties-Group spreadsheet. The revised file can be downloaded from: Section Properties07-Group.zip The screenshots below illustrate use of the Group function to … Continue reading