Category: Concept
Excel — Drawing Automated Shapes with PyXLL Sep 2023
Excel — Drawing Automated Shapes with PyXLL Sep 2023
Small Ideas — Large Effects Aug 2023
Filter a Pandas Dataframe using PyXLL (with video) Jul 2023
Digit Sums and Cyclic Patterns Jan 2023
‘This simple pattern may be recalled when students are first exposed to cosets and quotient groups much later in their academic career, as the set {2, 8} is one of six cosets in the quotient group C12/{0, 6}.’
Monty Hall — Consider Only Strategy Dec 2022
Python — develop, sell, deploy, protect Nov 2022
In 2022, let’s consider the difficulties of development using Python.
Hint: it isn’t the programming.
Buckminster would be proud Nov 2022
Easy Section Properties for Array of Points © Oct 2022
Pipe Stress Calculus May 2022
Excel — Taming of the Shapes with PyXLL May 2022
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
Excel — Use dynamic arrays and conditional formatting to create a selection dependent menu Oct 2020
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
Quick read with live links to the Desmos app.
The Inexpensive Ventilator — Are We Building These ?
Percussionaire — Bird Respirator History Wiki — Ventilator
The Lincoln Index — Software Bugs Jan 2020
John, Thanks for the presentation. https://www.johndcook.com/blog/2010/07/13/lincoln-index/ How many errors are left to find?
Three Blue One Brown Feb 2019
The craft and artistry are as impressive as the mathematical concepts.
Photomath Jun 2018
Take a photo of a handwritten math problem and get the answer from your smartphone https://photomath.net/en/