Category: Concept
Observations Jul 2021
Leaving a step out of a routine inevitably lengthens the routine. No matter what else, it all boils down to the competence and motivation of the people doing the work. Calculations Do your best work, Revisit next morning and edit out errors, Revisit next week and edit out errors, Revisit and run several arbitrary (though […]
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 […]
The Suez Canal — How Ships Float May 2021
Suez Canal I read about the recent incident in the Suez Canal with the container ship, Ever Given. I started thinking about the support of floating ships. With a relatively narrow canal, it was easier to imagine the mechanics. Archimedes Recall Archimedes Principle — we simply say a floating object displaces its weight in water. […]
2×2 RC Sequence Dec 2020
[ ( R’ D ) ( R D’ ) ] [ ( R’ D ) ( R D’ ) ] [ ( R’ D ) ( R D’ ) ] [ ( R’ D ) ( R D’ ) ] [ ( R’ D ) ( R D’ ) ] [ ( R’ D ) […]
Best of Seven Outcome Probability Dec 2020
Static Plots Using PLOTLY live plots Each chart series can be toggled off and on by clicking its legend entry. On a desktop device, reset the chart to full scale by reloading the web page. On a mobile device, reset the chart to full scale by double clicking. Team A Winning Outcomes The best of […]
From Punch Cards to Flash Memory Dec 2020
Multi-Dimension Data Table using PyXLL (with video) Dec 2020
MD Data Table in Action — Video 3 inputs; 2 outputs Bonus — Video Merged my data table values into Excel’s data table 3D Hypotenuse Screenshots Independent Variables — Input qvar_0 (10 items) qvar_1 ( 7 items) qvar_2 ( 4 items) Dependent Variables — Results Dependent Variables — Details (only for clarity) Short Tabulation Long […]
Excel — Use dynamic arrays and conditional formatting to create a selection dependent menu Oct 2020
Google Search dynamic arrays conditional formatting TRY THIS The MP4 video was recorded on an iPad and published using Camtasia 2020. The data range is conditionally formatted to match the selection
Recent Comments