Category: Excel
Excel — Use dynamic arrays and conditional formatting to create a selection dependent menu Oct 2020
Though I built this spreadsheet menu using Excel on a desktop machine, the spreadsheet file also works on an iPad ( ! ) and on an iPhone ( !! ).
Microsoft 365 is required.
WT Braces Mar 2020
If you like Table 4-12 in the AISC 15th Edition, then you might like the attached example plots which I built on the same principle.
ASCE 7-16 Ice Loading Apr 2018
Although ice loading is written as a simple formula, the formula varies with structural geometry (W, T, C, etc). I haven’t seen it automated in software.
Biaxial Capacity of Concrete Pedestal Jan 2018
Pedestal Design Data Mx Capacity Chart My Capacity Chart Karl Hoitsma, P.E. (khoitsma)
AISC C Coefficient for Bolt Groups (with video) Nov 2017
Replaces 48 pages of design tables in the AISC Manual. Allows any: bolt quantity or row spacing or column spacing or rotation No manual interpolation required. Karl Hoitsma, P.E. (khoitsma)
PyXLL Programmable Data Validation Nov 2017
… continued from PyXLL Dictionaries (earlier post)
PyXLL Dictionaries — Simple retrieval of data Nov 2017
Code for the dictionary function
Using AISC Properties Oct 2017
Examples
AISC Properties in Excel: Almost Magic Oct 2017
Just add calculations!