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

Category: Excel

PyXLL Custom Task Panes in Excel (with automated drawings and video) Nov 2020

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

The PyXLL/Jupyter interface would be drab without custom menus and graphical feedback.

Continue Reading

Excel Dropdown with NO worksheet data list (with video) Nov 2020

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

I built an Excel dropdown function — that requires no worksheet reference!

The dropdown built into Excel requires a range of data to populate the dropdown list. This might be an appropriate situation if the spreadsheet is a one-off. In my work, the dropdown list would more appropriately be generated in my PyXLL program.

Continue Reading

Excel — Use dynamic arrays and conditional formatting to create a selection dependent menu Oct 2020

  • khoitsma
  • Concept, Excel, Video
  • 0 Comments

I built a short video demonstrating how to use dynamic arrays and conditional formatting to create a selection dependent menu.

Though I built this spreadsheet menu using Excel on a desktop machine, the spreadsheet file also works on an iPad ( ! ) and on an iPhone ( !! ).

Microsoft 365 is required.

Continue Reading

WT Braces Mar 2020

  • khoitsma
  • AISC, Excel, Petrochemical Design
  • 0 Comments

If you like Table 4-12 in the AISC 15th Edition, then you might like the attached example plots which I built on the same principle.

Continue Reading

ASCE 7-16 Ice Loading Apr 2018

  • khoitsma
  • AISC, ASCE, Excel, Python, PyXLL
  • 0 Comments

Although ice loading is written as a simple formula, the formula varies with structural geometry (W, T, C, etc). I haven’t seen it automated in software.

Continue Reading

Biaxial Capacity of Concrete Pedestal Jan 2018

  • khoitsma
  • ACI, Excel, Software
  • 0 Comments

   Pedestal Design Data    Mx Capacity Chart    My Capacity Chart Karl Hoitsma, P.E. (khoitsma)

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