Mathpax Logo
  • 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
  • >
  • Video

Category: Video

Interval Filter using PyXLL Oct 2024

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


UPDATE

I built a set of functions demonstrating dynamic filtering and sorting using Excel and PyXLL. The functions determine whether a value is within a numeric interval (closed, open, or any combination).

A video illustrates the performance.


One million filters

Continue Reading

PyXLL PySide2 CTP ActiveX Sep 2024

  • khoitsma
  • Excel, PySide2, Python, PyXLL, Video
  • 0 Comments


UPDATE

I built a full PySide2 menu that allows the selection and presentation of AISC steel properties and the calculation of ASCE wind loads.

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

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

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

Continue Reading

PyXLL using Jupyter and PySimpleGUI Interface (with video) Dec 2022

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

This post features:
  the PyXLL add-on
  Jupyter
  the PySimpleGUI graphical interface

Continue Reading

Excel — Taming of the Shapes with PyXLL May 2022

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

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.

Continue Reading

Posts navigation

Older posts
Newer posts

Recent Posts

  • Bow Out Aug 2025
  • Automated Foundation Rebar Drawing Aug 2025
  • Close Encounters in Batting Averages July 2025
  • 2D Engineering Interpolation Jun 2025
  • Lessons Learned (structural engineering) Apr 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 (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
  • Home
  • What is Mathpax ?
  • Blog
  • Contact/Interests
  • About
  • Instant Access
  • Tabular List — Blog Entry Search
Pentagonal number visual proof

Dice Distribution (bar)

Bayes theorem visual proof

Bayes icon