Excel Dropdown with NO worksheet data list (with video) Nov 2020

I built an Excel dropdown function — that requires no worksheet reference!

The dropdown built into Excel requires a range of data to populate the dropdown list. This might be an appropriate situation if the spreadsheet is a one-off. In my work, the dropdown list would more appropriately be generated in my PyXLL program.

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.

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)