This post features:
the PyXLL add-on
Jupyter
the PySimpleGUI graphical interface
Category: Video
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
Bitwarden Dec 2021
Works great on my laptop, works great on my iPhone.
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
Richard Dawkins
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.
Recent Comments