Author Archives: dougaj4

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 , , , , , , | 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

Posted in Bach, Films | Tagged , | Leave a comment

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

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

Composite Beam Spreadsheet

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

Composite Concrete Beam Analysis

Composite concrete beams are widely used in both building and bridge structures; typically precast pretensioned beams are combined with an in-situ reinforced concrete slab to provide structures that are both efficient in use of materials and fast and easy to … Continue reading

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