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.
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.
Quick read with live links to the Desmos app.
Percussionaire — Bird Respirator History Wiki — Ventilator
John, Thanks for the presentation. https://www.johndcook.com/blog/2010/07/13/lincoln-index/ How many errors are left to find?
The craft and artistry are as impressive as the mathematical concepts.
Take a photo of a handwritten math problem and get the answer from your smartphone https://photomath.net/en/