Mathpax
  • Home
  • What is Mathpax ?
  • Blog/Contact/Interests/About
    • Blog
    • Contact/Interests
    • About
  • Search Posts
    • Short Takes
    • Instant Access
    • Tabular List — Blog Entry Search
  • Search the site ... 🔍
  • Homepage
  • >

Month: December 2020

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

  • khoitsma
  • Concept, Excel, Python, PyXLL, Video
  • 2 Comments

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

PyXLL to Jupyter Interface (with video) Dec 2020

  • khoitsma
  • AISC, Excel, Jupyter, Python, PyXLL, Video
  • 0 Comments

This example is an actual serious structural engineering calculation with graphical documentation.

Continue Reading

Posts navigation

Newer posts


QuickLinks


Instant Access to all Posts
Posts — Editor's Picks
Short Takes
My Dash apps

My GeoGebra app
What is the most general equation for the area of a triangle?
The Wait calculation
The incessant obsolescence postulate (IOP)
Barnard’s Star and the 'Wait Equation'
IOP counterargument
The amazing arbelos (only good on a real desktop)
Surprises found in the arbelos (1954)
Arbelos from Wolfram MathWorld
Circle Theorems
• Circle Theorems Marked
• Circle Theorems — Practice
Two Semicircles
Japanese temple geometry
★ Sister Celine — a beautiful life
★ John Lienhard IV on Ingenuity
★ Charles Stutzenbaker, Field Biologist
Neal Stephenson on the OS
A few quotations

Tyler TX weather • 🌡 Steve Fitzgerald
Tyler TX weather • 3-day history
Tyler TX weather • calendar month
Tyler TX weather • graph month
East Texas weather • TAMU
★ All of the water in the world

Hacker News (from YCombinator)
Diaorifa

Recent Posts

  • UIL Number Sense Mar 2026
  • Navigate this blog by Category Mar 2026
  • How Likely Feb 2026
  • Looking for a and b — and I accidentally re-proved the Pythagorean theorem Feb 2026
  • Derivative — polygon properties after offsetting one point Feb 2026
  • Centers of Gravity of the Triangle and Lean-To Trapezoid Jan 2026
  • Classical Structural Analysis (2nd verse) Dec 2025
  • Classical Structural Analysis Dec 2025
  • Gale-Shapley Algorithm Dec 2025
  • The Triangle of Minimum Perimeter Nov 2025
  • NotebookLM Cather Oct 2025

Archives

  • Home
  • What is Mathpax ?
  • Blog
  • Contact/Interests
  • About
  • Instant Access
  • Tabular List — Blog Entry Search

graph