Author Archives: dougaj4

Ligurian Arches

Posted on 15/05/2012 by dougaj4

We have looked previously at Robert Hooke’s statement on the mathematical analysis of arches:  abcccddeeeeefggiiiiiiiillmmmmnnnnnooprrsssttttttuuuuuuuvx but of course  people had been constructing large arch structures for many hundreds of years before Hooke made his enigmatic statement, and the masters, if … Continue reading →

Posted in Arch structures, Newton | Tagged , , , , | Leave a comment

Galileo and Pisa

Posted on 14/05/2012 by dougaj4

Welcome to Galileo Excel Baccusi, which will be replacing Newton Excel Bach for the next four weeks, while I travel in Northern Italy. Arriving in Rome on Friday morning, we travelled to Camogli by mini-bus, stopping for a quick tour … Continue reading →

Posted in Newton | Tagged , , , , | 4 Comments

Composite Beam Spreadsheet 3

Posted on 08/05/2012 by dougaj4

The Composite Beam Analysis spreadsheet, previously discussed at: https://newtonexcelbach.wordpress.com/2012/04/27/composite-beam-spreadsheet-2/ has now been updated with a VBA User Defined Function (UDF) in place of the previous macro that used the Excel Goal-Seek command.  This has two main advantages: The UDF is much faster … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 5 Comments

Using UDFs – Continuous Beam Example

Posted on 03/05/2012 by dougaj4

Recently (well a month ago) a comment was left at Continuous Beams with Shear Deflections asking for a tutorial on how to use the ConBeam User Defined Function (UDF).  In this post I will give detailed instructions for the ConBeam function, but similar … Continue reading →

Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , | Leave a comment

Spreadsheet Link – Abbott Aerospace Consultants

Posted on 29/04/2012 by dougaj4

Abbott Aerospace has a wide range of spreadsheets available for free download. Many are intended for specific aerospace design applications, but some are for general purpose engineering applications, such as calculation of section properties. A general purpose add-in of particular … Continue reading →

Posted in Excel, Newton, UDFs, VBA | Tagged , , , , | 1 Comment