### 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
- Taming Symbols in Excel
- The angle between two vectors, Python version
- Fitting high order polynomials
- Cubic Splines
- Section Properties with MeshPY, including torsion and warping
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Downloads

### Recent Comments

josh on Import Data from a Picture to… Melanie Safka + Mile… on Melanie Safka Mohd Yousef on Biaxial bending update DonB on Biaxial bending update Mohd Yousef on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update Mohd Yousef on Biaxial bending update 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…

# Category Archives: Maths

## A Treatise on the Mathematical Theory of Elasticity

The book The Man Who Knew Infinity by Robert Kanigel describes the life of the Indian mathematician Srinivasa Ramanujan, and also his Cambridge mentor G.H. Hardy. It mentions that Hardy was influenced by reading “A Treatise on the Mathematical Theory … Continue reading

Posted in Beam Bending, Maths, Newton
Tagged AEH Love, B-OK Global, HAL Archives, Internet archives, Mathematical Theory of Elasticity
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

## Numerical integration with on-sheet calculations

Following a comment here I have prepared a spreadsheet that works through the Tanh-Sinh Quadrature process with on-sheet calculations. For that purpose Graeme Dennes has provided a simplified version of the code: QUAD_RODRIGUEZ_TANH_SINH for finite intervals. Translated from HP RPN … Continue reading

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

## LinEstGap with non-linear functions

The LinEstGap user defined function (UDF) allows the built-in Linest function to be used on data with empty cells or hidden rows, returning results that agree with the chart trend-line function, which automatically ignores blank cells and hidden data. It … Continue reading

Posted in Arrays, Curve fitting, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, Exponential curves, Linest, Linest with gaps, Log curves, non-linear curve fitting, Polynomial curves, Power curves, UDF, VBA
1 Comment