Homepage
>
Concept

The Suez Canal — How Ships Float May 2021

I started thinking about the support of floating ships — in detail.

Continue Reading

2×2 RC Sequence Dec 2020

2×2 Rubik’s Cube

Continue Reading

From Punch Cards to Flash Memory Dec 2020

Continue Reading

Multi-Dimension Data Table using PyXLL (with video) Dec 2020

I coded a PyXLL macro that builds a multi-dimension data table (MDDT).

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.

Continue Reading

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.

Continue Reading

Gauss Profile Jun 2020

Quick read with live links to the Desmos app.

Continue Reading