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.
I built a full PySide2 menu that allows the selection and presentation of AISC steel properties and the calculation of ASCE wind loads.
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 […]
In structural engineering, we must constantly deal with axes transformations. Mostly we have right handed coordinates (RHC), but sometimes left handed coordinates (LHC).
There is no excerpt because this is a protected post.
I developed a Python function to calculate closed form exact values for wind forces and wind CGs.
I use only calculus — no bar charts with 0′ to 15′, 20′ to 25′, et cetera —- a curve rather than a step function. I present derivations and examples.
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.
The PyXLL/Jupyter interface would be drab without custom menus and graphical feedback.
I built an Excel dropdown function — that requires no worksheet reference!
The dropdown built into Excel requires a range of data to populate the dropdown list. This might be an appropriate situation if the spreadsheet is a one-off. In my work, the dropdown list would more appropriately be generated in my PyXLL program.
Recent Comments