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

Category: Excel

Python, PyXLL, and Pyside2 Nov 2021

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


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

Excel Dropdown with NO worksheet data list — redux Aug 2021

  • khoitsma
  • Excel, Python, PyXLL
  • 0 Comments

I decided to delete this post … There are limits to the number of items that will show in a data validation drop down list: The list can show up to show 32,767 items from a list on the worksheet. If you type the items into the data validation dialog box (a delimited list), the […]

Continue Reading

Transform Axes Jun 2021

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

In structural engineering, we must constantly deal with axes transformations. Mostly we have right handed coordinates (RHC), but sometimes left handed coordinates (LHC).

Continue Reading

Protected: Parsing Feet Inches Sixteenths (FIS) Jun 2021

  • khoitsma
  • Excel, Mathematics, Python, PyXLL
  • Enter your password to view comments.

There is no excerpt because this is a protected post.

Continue Reading

Feet Inches Sixteenths (FIS) Calculator Jun 2021

  • khoitsma
  • Concept, Excel, Mathematics
  • 0 Comments


Continue Reading

ASCE Exact Wind Integration (closed form equations) Jun 2021

  • khoitsma
  • ASCE, Calculus, Cocalc, editor's pick, Excel, Jupyter, Mathematics, Python, PyXLL, SageMath
  • 0 Comments

I developed a Python function to calculate closed form exact values for wind forces and wind CGs.

I use only calculus — no bar charts with 0′ to 15′, 20′ to 25′, et cetera —- a curve rather than a step function. I present derivations and examples.

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

  • Truss Calculations — A Puzzle Oct 2026
  • Truss Calculations Sep 2026
  • Back of the Envelope using Graph Paper Sep 2026
  • Short Takes
  • Not Quite Uniform Loadings Aug 2026
  • 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

Archives

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

graph