Category Archives: Newton

Cambridge Digital Library

Posted on 13/12/2011 by dougaj4

Newton Papers Cambridge Digital Library Cambridge University Library is pleased to present the first items in its Foundations of Science collection: a selection from the Papers of Sir Isaac Newton. The Library holds the most important and substantial collection of … Continue reading →

Posted in Newton | Tagged , , , | 2 Comments

Continuous Beams With Cantilevers by Macaulay’s Method

Posted on 05/12/2011 by dougaj4

Edit 13 Apr 2014: See Continuous Beam Spreadsheet with Moving Load for the latest version, which is now called ConBeamU. I have updated the Macaulay spreadsheet (described here) to allow the analysis of continuous beams with cantilevers at one or … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , | 12 Comments

Linest, NPV, IRR and solving polynomials

Posted on 01/12/2011 by dougaj4

In a comment on Using LINEST for non-linear curve fitting Lori Miller posted a formula that found the coefficients fitting a cubic polynomial curve to a set of data, then solved the resulting equation to find the X value for a given … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 3 Comments

Continuous Beam Analysis by Macaulay’s Method

Posted on 19/11/2011 by dougaj4

The Macaulay spreadsheet now includes a ConBeam() function, analysing continuous beams with any number of segments of different stiffness, subject to any combination of distributed or point loads and moments.  The spreadsheet also includes an example, together with output of … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , | 8 Comments

Beam Fixed End Actions by Macaulay’s Method

Posted on 13/11/2011 by dougaj4

Following the previous post examples have been added to the Macaulay Spreadsheet illustrating the use of the method to find fixed end moments and reactions for a beam fixed at one or both ends, and subject to any number of … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , | 2 Comments