Here you can find a few of the (mainly Excel-based) tools that I've developed to assist me with my day to day work. Hopefully you find something useful.
Hi all, and welcome to my little corner of the web.
This is really just a place for me to collate a few little tools and tips that I use in my practice as a Structural Engineer, particularly in relation to Microsoft Excel and other software, as I’ve recently developed a few tools and Add-ins that I think others might find useful.
I’ll likely expand on this in the future with more general structural engineering posts, but don’t hold your breath 😉
The Problem The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range. The Syntax is as below: MATCH(lookup_value, lookup_array, [match_type]) The match_type is an optional argument that can take one of three values; 0 Returns an exact match -1 returns the lowest … More A more versatile Match function for Excel
How to deal with feet and inches in Excel … More Feet and inches in Excel
A quick and easy way to import modules in to your Excel workbooks … More Adding Excel user defined functions the easy way
