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.
Los Alamos from below
Works great on my laptop, works great on my iPhone.
McDonald discusses his career at Texas Tech in the Department of Engineering and his research on structural damage from natural disasters.
Luckily, I happened upon this video; I couldn’t stop watching.
I built a full PySide2 menu that allows the selection and presentation of AISC steel properties and the calculation of ASCE wind loads.
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.
This example is an actual serious structural engineering calculation with graphical documentation.