Nothing at all to do with sheep...
Nothing at all to do with sheep...
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…
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.
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.
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…
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…
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…
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…
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…
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…
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…
In Part 2 we covered the functions for creating coordinates for accurately representing shear reinforcement (stirrups and links) using an XY scatter chart in Excel. In this third and final part, we’ll cover the functions for outputting the minimum lengths…
Onto explaining the user defined functions, if you have no idea what I’m talking about go see Part 1.
One thing that irks me about a lot of spreadsheets I’ve seen created over the years is the fact that the inputs for something that can be visualised are hidden behind a few numbers in cells. No visual representations of…
Minimum steel, love it or hate it, we have minimums for a reason even if it seems like overkill sometimes given that we may have very low demands. This post will demonstrate why (I hope) we are required to comply…
Well, one person’s world of torsion anyway… In this post I’ll show how to use Mathematica to check some derivatives of torsion relationships. Mathematica is an analysis/computational tool by Wolfram. Now if you had to pony up the dollars for…
In this post we’ll try demystify CL 5.6.4 part b, what the hell does it really mean? Well this is my take on it anyway… I can’t say for certain I’m correct as I’ve never seen anyone else use it,…