PyXLL using Jupyter and PySimpleGUI Interface (with video) Dec 2022
This post features:
the PyXLL add-on
the PySimpleGUI graphical interface
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.
Lecture by Richard Feynman – with transcript Feb 2022
Los Alamos from below
Adding tools to Excel Jan 2022
Interview with James McDonald PhD, PE – Transcript Dec 2021
McDonald discusses his career at Texas Tech in the Department of Engineering and his research on structural damage from natural disasters.
Special Lecture: F-22 Flight Controls Dec 2021
Luckily, I happened upon this video; I couldn’t stop watching.
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.
Fascinating Science Lectures Mar 2021
Multi-Dimension Data Table using PyXLL (with video) Dec 2020
I coded a PyXLL macro that builds a multi-dimension data table.
The native Data Table provided by Excel is useful but limited to two variables.
My version is set up for 5 independent variables and an unlimited (theoretically) number of dependent variables. Five was an arbitrary choice; some limitation is required here.