Category Archives: Maths

A Treatise on the Mathematical Theory of Elasticity

Posted on October 10, 2020 by

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 , , , , | Leave a comment

Spherical Geometry and Vincenty’s Formulae

Posted on September 27, 2020 by

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 , , , , , , | Leave a comment

Section Properties for Rotated Shapes

Posted on August 6, 2020 by

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 , , , , | Leave a comment

Numerical integration with on-sheet calculations

Posted on July 8, 2020 by

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 , , , , , | Leave a comment

LinEstGap with non-linear functions

Posted on March 14, 2020 by

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 , , , , , , , , , | 1 Comment