Category Archives: Excel

Continuous Beams with Shear Deflections

Posted on 31/12/2011 by dougaj4

The Macaulay Spreadsheet has now been modified to optionally include shear deflections, as well as a new option to output support reactions, and fixes to minor bugs. The revised spreadsheet (including full open source code) can be downloaded from: Macaulay.zip … Continue reading →

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

When does 35 not equal 35?

Posted on 20/12/2011 by dougaj4

… and when does 35 – 35 not equal zero? In the first case the answer is when one “35” is on an Excel spreadsheet and the other 35 is in VBA.  The question arose from the ongoing continuous beam … Continue reading →

Posted in Excel, Maths, Newton, VBA | Tagged , , , | 12 Comments

Dynamic Excel on the Cloud With Javascript!

Posted on 16/12/2011 by dougaj4

I have previously linked to a spreadsheet stored on Skydrive, but I have been disappointed that the possibilities for using live spreadsheets are greatly limited by the lack of support for VBA.  It seems that Microsoft have now decided to provide … Continue reading →

Posted in Animation, Charts, Computing - general, Excel, Javascript | Tagged , , , | 1 Comment

Continuous Beams With Spring Supports by Macaulay’s Method

Posted on 15/12/2011 by dougaj4

Following the last post on this topic: Continuous Beams With Cantilevers by Macaulay’s Method, and by popular demand, I have now updated the continuous beam and single span analysis functions to accept spring translational and moment restraints.  Also added is … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , | 36 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