Tag Archives: VBA

Two views on VBA

First from Microsoft: Microsoft are continuing their quest to make downloading spreadsheets with macros ever more difficult, and now any downloaded spreadsheet has VBA code disabled by default. Unblocking the code (if you know and trust the source of the … Continue reading

Posted in Excel, VBA | Tagged , , , | 2 Comments

Downloads update

A list of files available for free download can be found under the Downloads link at the top of the page: The list has now been updated and there are now 189 files available for download, most with open source … Continue reading

Posted in Computing - general, Excel | Tagged , , , , , , | Leave a comment

ULS Design Functions 2.16

The ULS Design Spreadsheet has now been updated to Version 2.16, which can be downloaded from: ULS Design Functions The main new feature is the option to design for prestress loads applied to circular tanks. Due to axi-symmetric effects, when … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , | 1 Comment

Using ConbeamU

This post was prompted by a thread at Eng-Tips: https://www.eng-tips.com/viewthread.cfm?qid=501339 The beam analysis functions in the ConbeamU spreadsheet allow for the use of any SI units, or any non-SI units found in the long list included with the spreadsheet. I … Continue reading

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

RC Design Functions 9.03; compression strut angle adjustment

The RC Design Functions spreadsheet has now been updated to Version 9.03, and is available for free download from: RC Design Functions9.zip The new version includes a number of corrections to the calculation of beam shear and torsion capacity to … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , | 1 Comment