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
  • >
  • Python

Category: Python

Excel — Drawing Automated Shapes with PyXLL Sep 2023

  • khoitsma
  • Concept, editor's pick, Excel, Python, PyXLL
  • 0 Comments

Excel — Drawing Automated Shapes with PyXLL Sep 2023

Using PyXLL, I have programmed automatic shapes in Excel. That is, I built a function that draws an arbitrary shape in a user spreadsheet: the shape is defined by a range of coordinates; as the coordinates are edited, a new shape can be drawn.

TCMD shapes

Continue Reading

Moment due to Linearly Varying Pressure Aug 2023

  • khoitsma
  • Calculus, Engineering, Excel, Mathematics, Python, PyXLL, Sympy
  • 0 Comments

I built a new function in Python and PyXLL

Continue Reading

Online Embedded Excel Aug 2023

  • khoitsma
  • Dash by Plotly, Engineering, Excel, iPad_iPhone, Petrochemical Design, Python, pythonanywhere
  • 0 Comments

I built a new app on the web — accessible from any device — desktop, phone, iPad

· Grating calculations

Continue Reading

Filter a Pandas Dataframe using PyXLL (with video) Jul 2023

  • khoitsma
  • AISC, Concept, Engineering, Excel, Python, PyXLL, Video
  • 0 Comments

The function uses only three parameters: the criteria range, the reverse sort toggle, and the upper limit on rows of results.

Note that conditional formatting is applied using the PyXLL formatter option.

lookup

Continue Reading

Enhanced Lookup — Excel and PyXLL June 2023

  • khoitsma
  • editor's pick, Engineering, Excel, Python, PyXLL
  • 0 Comments

I built a couple special lookup functions using PyXLL

and

an
interesting helper function

lookup

Continue Reading

Foundation Bearing Pressures using Jupyter and PyXLL (with videos) Mar 2023

  • khoitsma
  • Calculus, Engineering, Excel, Jupyter, Plotly, Python, PyXLL, Video
  • 0 Comments

Continue Reading

Posts navigation

Older posts
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

  • p5 test Jul 2026
  • Divisibility July 2026
  • Narlin Beaty’s Polyominos June 2026
  • Protected: Custom iPhone Shortcuts May 2026
  • Marion Walter’s Theorem May 2026
  • Derive the Stiffness Matrix for a Beam Apr 2026
  • 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

Archives

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

graph