Function get_iceweight, a function of … structural shape all kinds of structural shapes pipe, HSS, bar L, 2L, 2L spaced C, MC W, S, M, HP WT, ST, MT ‘basic’ ice thickness from ASCE map importance factor for ice function of height above grade topographic factor ice density Excel implementation … Self documentation for function […]
Category: PyXLL
AISC C Coefficient for Bolt Groups 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) Karl Hoitsma, P.E. (khoitsma)
PyXLL Dictionaries — Simple retrieval of data Nov 2017
… see Data Validation (later post) Karl Hoitsma, P.E. (khoitsma)
Using AISC Properties Oct 2017
Use the properties in Excel formulas Let’s look at example calculations! These calculations consider concentrated loads on wide flange shapes. Watch the video — click ‘Formula Examples Video’. Formula Examples Video Still screenshots Formula Example 1 Formula Example 2 Formula Example 3 Karl Hoitsma, P.E. (khoitsma)
AISC Properties in Excel: Almost Magic Oct 2017
From scratch, using PyXll, I built an AISC property viewer for Excel. Just add calculations! Karl Hoitsma, P.E. (khoitsma)
AISC Bolt Calculations Jul 2017
Eccentric Shear Connections Eccentrically loaded bolt group Ultimate Strength (Plastic Analysis) Uses Instantaneous Center of Rotation (I.C.)
ASCE Wind and AISC Properties Jun 2017
ASCE and AISC Let’s make this easy Here we have a PDF describing: An easy approach to ASCE wind calculations. Automatic AISC properties for all AISC profiles All of the above is ready to go as simple Excel function calls. ASCE 7-05 and AISC Properties . . . . […]
Recent Comments