This post features:
the PyXLL add-on
Jupyter
the PySimpleGUI graphical interface
Category: Python
Python — develop, sell, deploy, protect Nov 2022
In 2022, let’s consider the difficulties of development using Python.
Hint: it isn’t the programming.
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.
Asymmetric Frame Loading Jul 2022
In memory of Dr. Terry Kohutek, Texas A & M, Professor of Civil Engineering
Structural Calculations for Beams Using Calculus via Sympy Jul 2022
Something about calculus and Sympy is lovable.
Beam Deflections Jun 2022
I thought I should reassess and resharpen my basic structural engineering skills.
Lucky Me Jun 2022
As a kid and later through my career, several lucky things happened to me; some of these things were fortuitous and some happened because I searched them out — either way, still lucky.

Excel — Taming of the Shapes with PyXLL May 2022
Using PyXLL, I have programmed automatic shapes in Excel. That is, I built a function that draws an arbitrary shape in a user spreadsheet: the shape is defined by a range of coordinates; as the coordinates are edited, a new shape can be drawn.

Python, PyXLL, and Pyside2 Nov 2021
I built a full PySide2 menu that allows the selection and presentation of AISC steel properties and the calculation of ASCE wind loads.

Excel Dropdown with NO worksheet data list — redux Aug 2021
I decided to delete this post … There are limits to the number of items that will show in a data validation drop down list: The list can show up to show 32,767 items from a list on the worksheet. If you type the items into the data validation dialog box (a delimited list), the […]
Recent Comments