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.
Category: PyXLL
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!
AISC Bolt Calculations Jul 2017
This spreadsheet calculates the C coefficient for a full range of bolt patterns (1 to 4 columns of bolts, 1 to 12 rows of bolts).
All values of all C coefficients in one Excel tab !
ASCE Wind and AISC Properties Jun 2017
See list of all AISC posts. See list of all ASCE posts.