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 your spreadsheets and tracking changes to that code using git. Well, that’s a pain you might say, extracting/exporting the code modules from Excel manually each time you make a change. Well, I couldn’t agree more, it would be a major…
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 2 of their calculations as well, though it always gives me a laugh that they went on and did 403 pages of calculations based on the wrong seismic load…. laugh it happens.
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 moment strength. Isn’t this the point of designing the beam….. Arrgghhh!
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 for via the start menu, very cumbersome right. This got me thinking, what other things am I ashamed to admit I found out way after the rest of the world apparently did, and way after I’d like to admit after…
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 and a 3 there, and the whole mass and weight thing which I didn’t even realise existed…..
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 of getting in the way sometimes (by this I mean work essentially…. you know how it is… ).
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 it comes to structural specific mark-ups.
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 of stirrups or links. As mentioned in the first part in this series, estimating the total length of bars and hence weights can be a tedious boring process. These functions take out boring bits, but it’s still not ‘exciting’.
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 the calculations are given. With an overarching reliance on the user to mentally complete the picture of their design inputs (and sometimes outputs) within their minds.
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 with these arbitrary limits. Usually I’m going into these posts with only the theoretical background of why something exists, but hopefully once we get into it this theory can actually be demonstrated.
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 it you’d be out a few thousand dollars, but as it happens I’m cheap and it’s free on Raspberry Pi’s Raspbian operating system. Yes it’s linux based, but don’t let that turn you off, it’s so simple to setup anyone…