Excel — Taming of the Shapes with PyXLL May 2022

Shear and Moment Diagram The above shows the shear and moment diagram for a propped cantilever. The leancrew link has a full explanation of the mechanics involved. https://leancrew.com/all-this/2015/08/super/ Examples of use in my structural engineering Python, PyXLL, and Pyside2 Nov 2021 Wind and Fire-proofing Dec 2017

Long Division — Just Write the Answer Oct 2021

Five Easy Inverses (marked) What is 44/201? (marked) Hey Wolfram Alpha, what is 44/201? Five Easy Inverses (unmarked) What is 44/201? (unmarked) References Dr. Aitken was both a mathematician and a mental calculator. His prowess is described in the first link below (about halfway down the page). https://mathshistory.st-andrews.ac.uk/HistTopics/Mental_arithmetic/ And here’s a second link — well […]

Mathpix Snip Sep 2021

Take a photo of a handwritten math problem and get the LaTeX code from your smartphone (or computer) Take a photo on the iPhone, and crop it. Submit and voilá. Here’s the LaTeX code (I added code shown in red to remove the equation number): $$$\therefore R_{1}=\left(\frac{q a}{2}\right)\left[2-\alpha^{2}(1+\beta)\right]$$$

Excel Dropdown with NO worksheet data list — redux Aug 2021

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 […]

Protected: Parsing Feet Inches Sixteenths (FIS) Jun 2021

There is no excerpt because this is a protected post.

Feet Inches Sixteenths (FIS) Calculator Jun 2021

Screenshot Entering Fractions ‘ NOTES ‘ ‘ This excerpt is taken from my Excel VBA project code ‘ ‘ This subroutine is activated by any change to the worksheet ‘ ‘ In a certain range of cells, named “Fraction Groups” (see Column E), ‘ the user enters the fractional portion of a measurement without a […]