Tag Archives: VBA

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

Composite Beam Spreadsheet – 2

Posted on 27/04/2012 by dougaj4

The previous post on this topic presented a spreadsheet performing elastic analysis of composite reinforced or prestressed composite beams, available for download from: Composite Design Functions-GS.zip.  This post will look in more detail at how the spreadsheet works, and a preview … Continue reading →

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

Modifying spreadsheet data with VBA – the quick way

Posted on 25/04/2012 by dougaj4

A question recently came up (here) asking how to speed up the process of scanning a large range of data on one sheet, and wherever a cell had a value of zero, deleting the data in the same cell address … Continue reading →

Posted in Arrays, Excel, VBA | Tagged , , , | 1 Comment

Composite Beam Spreadsheet

Posted on 22/04/2012 by dougaj4

As promised in the previous post, a spreadsheet for designing reinforced or prestressed concrete composite beams has now been uploaded to my web site.  It can be downloaded from: Composite Design Functions-GS.zip .  As usual, the spreadsheet includes full open-source code. … Continue reading →

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

Geometry for Joiners

Posted on 03/04/2012 by dougaj4

A question came up on the ABC Self-Service-Science Forum, asking for a solution to find the dimensions of a diagonal brace looking like the diagram below: The solution is not as simple as it might look because the angle of … Continue reading →

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