~~~
Category: Software
Beautiful Retro Rebuild — Windows↓ Linux↑ Dec 2024
It was, originally, a Windows 7 machine. Bought in 2010.
Yesterday, I wiped the disk and installed 2024 Linux Ubuntu 24.04.1 LTS.
It’s now a 500GB Linux machine with a DVD drive, SmartCard slot
~~~
Universal Dropdowns in Excel Dec 2024
Plotly Insights Nov 2024
I have built a few Plotly charts and have learned a few tricks along the way.
Reading the docs will get you part of the way there but trial and error is required to go all the way.
App C2 AISC Bolt Capacity using Dash/PythonAnywhere Nov 2024
Interval Filter using PyXLL Oct 2024
I built a set of functions demonstrating dynamic filtering and sorting using Excel and PyXLL. The functions determine whether a value is within a numeric interval (closed, open, or any combination).
A video illustrates the performance.
One million filters
PyXLL PySide2 CTP ActiveX Sep 2024
I built a full PySide2 menu that allows the selection and presentation of AISC steel properties and the calculation of ASCE wind loads.
A short history of “software as a service” June 2024
AISC Bolt Shear Capacity — Minimum Dimensions Feb 2024
Excel — Dictionary References with PyXLL Jan 2024
Hand Calculated Truss vs RISA Dec 2023
AI outperforms conventional weather forecasting Nov 2023
AI Poetry Nov 2023
Convolution as seen in Virtual Work Nov 2023
Photomath and Slide Rule Competition Oct 2023
Excel — Drawing Automated Shapes with PyXLL Sep 2023
Excel — Drawing Automated Shapes with PyXLL Sep 2023
Moment due to Linearly Varying Pressure Aug 2023
Small Ideas — Large Effects Aug 2023
Online Embedded Excel Aug 2023
I built a new app on the web — accessible from any device — desktop, phone, iPad
· Grating calculations
Filter a Pandas Dataframe using PyXLL (with video) Jul 2023
Enhanced Lookup — Excel and PyXLL June 2023
Foundation Bearing Pressures using Jupyter and PyXLL (with videos) Mar 2023
Soil Texture Triangle with Plotly Jun 2023
ACI Rebar Lookup May 2023
Encounter with Rust
PyXLL using Jupyter and PySimpleGUI Interface (with video) Dec 2022
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.