Recent Comments
Author Archives: dougaj4
Using UDFs – Continuous Beam Example
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 continuous beam analysis, Excel, Macaulay's Method, shear deflections, support reactions, UDF, VBA
Leave a comment
Spreadsheet Link – Abbott Aerospace Consultants
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
Composite Beam Spreadsheet – 2
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 composite concrete beam, Excel, Goal Seek, Prestressed concrete, Reinforced Concrete, UDF, VBA
4 Comments
Girl
GIRL is the first single off March of the Real Fly’s highly anticipated first studio EP. Directed by Kerinne Jenkins Shot and Graded by Emma Paine Edited by Keri and Marnie Produced by Marnie Vaughn 2nd Camera – Marnie Vaughn … Continue reading
Modifying spreadsheet data with VBA – the quick way
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
