A structural engineer, who sometimes likes structural engineering.

## VBA functions for determining (and graphing of) moment, shear, and deflection for a simply supported beams +/- cantilevers (Part 2)

One thing to state up front, the shear, moment and deflection are all based on the loads given, so if they are factored ultimate loads then the moment, shear and deflection are factored. Which for the deflection might not be…

## VBA functions for determining (and graphing of) moment, shear, and deflection for a simply supported beams +/- cantilevers (Part 1)

Today we bring you moment, shear, deflection stuff! Sharing some basic VBA functions for determining the moment, shear and deflection of a simply supported beam (with or without cantilever) under almost any typical loading scenario imaginable. Point loads, variable length…

## Fun with functions….Use cases for Excels LET() function

If you’re not aware of what the LET() function is, prepare to be informed (and get out from under the rock you’ve been hiding under!). The LET function was introduced in July 2020, and I must admit it wasn’t until…

## Lambda functions coming in Excel!

Well, it’s not often I wake up at 4am and get excited about Excel formulas. Today was one of those days though. There on Google was the recommendation for a link saying on sheet lambda functions are on their way…

## ADRS curve generation functions for the New Zealand seismic code (Part 4)

Following on from the previous blog posts in this series that provided functions for calculating the NZS1170.5 seismic coefficient. I’ve added some further functions to the GitHub repository that utilise the previous functions to generate an ADRS curve in accordance…

## Excel…. Version control…. Git the hell out of here!

Version tracking Excel VBA code with git…. I’m not talking about uploading your spreadsheets to GitHub and calling it a day…. boring, we can do a bit better than that obviously! I’m talking about extracting your actual VBA code from…

## Functions for calculating the New Zealand seismic coefficient Cd(T) and associated parameters (Part 3)

In this final instalment let’s use the functions. They should hopefully be self-explanatory with the VBA comments, but there are a couple of subtleties to be aware of.

## Functions for calculating the New Zealand seismic coefficient Cd(T) and associated parameters (Part 2)

The functions discussed in Part 1 are outlined below. Click here to go to the GitHub repository with the full code and some extras. Or simply cut and paste from this page.

## Functions for calculating the New Zealand seismic coefficient Cd(T) and associated parameters (Part 1)

As exciting as it is calculating seismic coefficients (it’s not), you get sick of doing it by hand and implementing it time after time in various spreadsheets. Theres nothing worse than seeing someone calculate their seismic coefficient wrong on page…

## Moment coverage, do it, and do it right (please!)

Something that really irks me when checking others concrete designs, is the apparent lack of knowledge surrounding moment or tension reinforcement development. Along with the concept of moment coverage diagrams to prove that all regions of your member have sufficient…

## Stuff I should have known earlier … shortcuts…

The other day I learned a useful shortcut in windows, being that the Windows key + SHIFT + S opens up the snipping tool in windows, very handy. This is something I always used to open manually with a search…

## Metric for the win…

I’m not a fan of the imperial system when it comes to engineering calculations, I make no secret of this. Nothing is easier than multiples of ten in my mind, it just makes sense. As opposed to a 12 here…

## Parabolas, Rectangles, Triangles & Snakes (Part 10)

Well, this post has been a while coming (since Part 9), not because it took a lot of work. Quite the opposite, more regarding a lack of progress on this project in the last few months! Life has a way…

## Doing some cool stuff with JavaScript in Bluebeam (Part 2)

In part 1 we added a single line of JavaScript, it was basic. But hopefully that single line of JavaScript provided some inspiration on how you could make other stamps you might create dynamic, and less specific. In this post…

## Doing some cool stuff with JavaScript in Bluebeam (Part 1)

In my previous post I commented on how Bluebeam could be made a ‘little‘ bit more useful. It wouldn’t be that hard for the developers … surely. However, if you know a little JavaScript and are motivated enough you can…

## Creating a Bluebeam Structural Steel Toolset

As far as I can tell, Bluebeam has all but become the defacto standard for electronically marking up PDF’s in structural engineering consultancies. By default, it basically comes with nothing to make your job easier as a structural engineer when…