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

Category: Excel

Excel — Dictionary References with PyXLL Jan 2024

  • khoitsma
  • Concept, Excel, Python, PyXLL
  • 0 Comments
Continue Reading

Excel — Drawing Automated Shapes with PyXLL Sep 2023

  • khoitsma
  • Concept, 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
  • Engineering, Excel, Python, PyXLL
  • 0 Comments

I built a couple special lookup functions using PyXLL

and

an
interesting helper function

lookup

Continue Reading

Posts navigation

Older posts
Newer posts

Recent Posts

  • Lessons Learned (structural engineering) Apr 2025
  • Marimo Notebook Mar 2025
  • Fixed Fixed Beam with a Moment at any Point — Superposition Mar 2025
  • Nobel Prize winner from NSF SSTP
  • Cantilever with a Concentrated Load at any Point — Castigliano’s 2nd Theorem Feb 2025

Archives

QuickLinks


Instant Access to all Posts
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
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
  • Home
  • What is Mathpax ?
  • Blog
  • Contact/Interests
  • About
  • Instant Access
  • Tabular List — Blog Entry Search
Pentagonal number visual proof
Get new posts by email:
Powered by follow.it