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: Excel
Biaxial Capacity of Concrete Pedestal 01/2018
Pedestal Design Data Mx Capacity Chart My Capacity Chart Karl Hoitsma, P.E. (khoitsma)
AISC C Coefficient for Bolt Groups 11/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 11/2017
… continued from PyXLL Dictionaries (earlier post) Karl Hoitsma, P.E. (khoitsma)
PyXLL Dictionaries — Simple retrieval of data 11/2017
… see Data Validation (later post) Karl Hoitsma, P.E. (khoitsma)
Using AISC Properties 10/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 10/2017
From scratch, using PyXll, I built an AISC property viewer for Excel. Just add calculations! Karl Hoitsma, P.E. (khoitsma)
Brom’s Method 09/2017
Rigid Shaft Foundation Design User Input ______ Load Factors (Factor_vertical, Factor_lateral) ______ Foundation Geometry (Diameter, Height, Depth, Discounted Depth) ______ Soil Cohesion (Cu) ______ Design Guidance (Bearing?, Skin Friction?) ______ Allowable Bearing Stress ______ Allowable Factor of Safety Output ______ Bearing Stress Ratio ______ Skin Friction Ratio Karl Hoitsma, P.E. (khoitsma)
AISC Bolt Calculations 07/2017
Eccentric Shear Connections Eccentrically loaded bolt group Ultimate Strength (Plastic Analysis) Uses Instantaneous Center of Rotation (I.C.)
ASCE Wind and AISC Properties
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