### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Downloads by category
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Rabbits, Foxes, and Lorenz Attractors
- The angle between two vectors, Python version
- Time in hours and minutes between two dates
- Downloads
- Installing Adobe Reader non-DC version.

### Recent Comments

Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update Units4Excel Update |… on Extracting text from an Intern… dougaj4 on Using LinEst() on data with… More on RC design of… on Reinforced Concrete Design for… AndyF83 on Using LinEst() on data with… dougaj4 on Extracting text from an Intern… Kirby on Extracting text from an Intern… Extracting text from… on Evaluating text with units and… dougaj4 on Deflections and Moments in Rec… Kaushal on Deflections and Moments in Rec… Kurt Clark on Working with units in Excel…

# Category Archives: UDFs

## Newton-Raphson and Brent’s Method – Solver examples

I recently discovered the Computing Skillset site (via open-struct-engineer), which has good information on the basis and use of the Newton-Raphson method: The Newton Raphson method explained, details, pictures, python code Highly instructive examples for the Newton Raphson method I … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Brents method, Computing Skillset, Excel, Newton Raphson Method, UDF, VBA
Leave a comment

## Numerical Integration With Tanh-Sinh Quadrature v 5.0

Graeme Dennes has updated his Tanh-Sinh Quadrature spreadsheet to V 5.0. The new version (including full open source code) may be downloaded from: Tanh-Sinh Quadrature Graeme’s summary of the new features in the spreadsheet: The Tanh-Sinh quadrature workbook has been … Continue reading

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, numerical integration, on-sheet calculations, Tanh-Sinh Quadrature, UDFs
Leave a comment

## Using Excel with Python and ctypes

The Strand7 API provides an interface between the Strand7 Finite Element Analysis program and external software. It works with many different languages, including Python, which uses ctypes to transfer data to and from the API functions. It is essential that … Continue reading

Posted in Beam Bending, Excel, Link to dll, Link to Python, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged ctypes, Excel, Python, PyXLL, Strand7 API, UDF
Leave a comment

## Spherical Geometry and Vincenty’s Formulae

Wikipedia has detailed articles on: Spherical Geometry and Vincenty’s Formulae (for geometric calculations on an ellipsoid). The spreadsheet Vincenty.xlsb uses those resources to perform the following calculations, using both on-sheet calculations and VBA user-defined functions (UDF’s): Calculation of distance and … Continue reading

Posted in Computing - general, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged ellipsoid area, ellipsoid distance, Excel, Spherical Geometry, UDF, VBA, Vincenty's Formulae
Leave a comment

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