Excel — Use dynamic arrays and conditional formatting to create a selection dependent menu Oct 2020

I built a short video demonstrating how to use dynamic arrays and conditional formatting to create a selection dependent menu.

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)