Category Archives: Excel

Update to Beam1 and Beam2

Posted on 16/10/2010 by dougaj4

It has just been pointed out that the single span beam spreadsheet presented at Frame Analysis with Excel 1 does not work for a propped cantilever.  The same applies to the spreadsheet for single span sloping beams at Frame Analysis with … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton | Tagged , , | 3 Comments

Faster Integration with the Tanh-Sinh Method

Posted on 10/10/2010 by dougaj4

In my previous post about numerical integration I mentioned that I would be writing about another lesser known method providing better speed and/or accuracy in many cases.  The method is known as Tanh-Sinh quadrature, and has been implemented in Excel by a reader … Continue reading →

Posted in Excel, Maths, Numerical integration, UDFs, VBA | Tagged , , , , , , , | 3 Comments

Faster Ferns

Posted on 03/10/2010 by dougaj4

I have modified the fern input parameters in the spreadsheet presented in the previous post to match the layout used by Barnsley and others, so that examples such as those given at the Wikipedia article can be entered directly.  The … Continue reading →

Posted in Arrays, Charts, Charts, Drawing, Excel, Maths, Newton, VBA | Tagged , , , | 4 Comments

Plotting Ferns

Posted on 27/09/2010 by dougaj4

Over at Daily-Dose-of-Excel mrt has posted an interesting VBA version of a Matlab program that used an Iterated Transfer Function to plot a graph resembling a fern.  The original Matlab code came from Dr Tom Wood, and Michael’s VBA version works just fine, … Continue reading →

Posted in Arrays, Charts, Drawing, Excel, Maths, Newton, VBA | Tagged , , , , | 5 Comments

Working with FEM data and using the dictionary object

Posted on 26/09/2010 by dougaj4

This post features an Excel User Defined Function (UDF) to count the number of different element types (beams, plates, bricks and links) and the number of node restraints at each end of listed beams from a finite element model.  The … Continue reading →

Posted in Arrays, Excel, Finite Element Analysis, Newton, UDFs, VBA | Tagged , , , , , | 5 Comments