In structural engineering and in pipe stress, is it possible to optimize designs using current software?
Category: Concept
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.
Engineering Cost Estimates Jul 2021
Uncertainty analysis illustrates simple but often ignored concepts.
Feet Inches Sixteenths (FIS) Calculator Jun 2021
The Suez Canal — How Ships Float May 2021
I started thinking about the support of floating ships — in detail.
2×2 RC Sequence Dec 2020
2×2 Rubik’s Cube
From Punch Cards to Flash Memory Dec 2020
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.
Excel — Use dynamic arrays and conditional formatting to create a selection dependent menu Oct 2020
I built a short video demonstrating how to use dynamic arrays and conditional formatting to create a selection dependent menu.
Though I built this spreadsheet menu using Excel on a desktop machine, the spreadsheet file also works on an iPad ( ! ) and on an iPhone ( !! ).
Microsoft 365 is required.
Gauss Profile Jun 2020
Recent Comments