I built a rebar lookup using PyXLL
Category: Engineering Codes
Building codes and specifications
PyXLL using Jupyter and PySimpleGUI Interface (with video) Dec 2022
This post features:
the PyXLL add-on
Jupyter
the PySimpleGUI graphical interface
Easy Section Properties for Array of Points © Oct 2022
AISC bolt holes Aug 2022
This code illustrates the readability of Python.
Compare reading the text of AISC 15th Edition Manual, Section J3 to the program statements.
Pipe Flexibility using Julia and Jupyter Jul 2022
I compared equations from den Hartog, from Kireev et al, and from B31.3 Table D300.
The agreement was quite good.
ASCE Exact Wind Integration (closed form equations) Jun 2021
I developed a Python function to calculate closed form exact values for wind forces and wind CGs.
I use only calculus — no bar charts with 0′ to 15′, 20′ to 25′, et cetera —- a curve rather than a step function. I present derivations and examples.
PyXLL to Jupyter Interface (with video) Dec 2020
This example is an actual serious structural engineering calculation with graphical documentation.
PyXLL Custom Task Panes in Excel (with automated drawings and video) Nov 2020
The PyXLL/Jupyter interface would be drab without custom menus and graphical feedback.

Multi-Page Apps using Dash/PythonAnywhere Apr 2020
I built these apps on the web — accessible from any device – desktop, phone, iPad
· AISC Strong Axis Bending
· AISC Filtered Shape Properties
· Coefficient C for Bolt Groups
· WT Strut Capacity (eccentrically loaded)

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.

Recent Comments