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

Category: PyXLL

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

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, 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

Soil Texture Triangle with Plotly Jun 2023

  • khoitsma
  • Engineering, Plotly, Python, PyXLL
  • 5 Comments
soil texture triangle

Continue Reading

ACI Rebar Lookup May 2023

  • khoitsma
  • ACI, Engineering, Engineering Codes, Python, PyXLL
  • 0 Comments

I built a rebar lookup using PyXLL
lookup

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

Python — develop, sell, deploy, protect Nov 2022

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

In 2022, let’s consider the difficulties of development using Python.

Hint: it isn’t the programming.

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

Recent Comments

  • Quoc Duong PHUNG on Soil Texture Triangle with Plotly Jun 2023
  • khoitsma on Soil Texture Triangle with Plotly Jun 2023
  • Quoc Duong PHUNG on Soil Texture Triangle with Plotly Jun 2023
  • khoitsma on Soil Texture Triangle with Plotly Jun 2023
  • Quoc Duong PHUNG on Soil Texture Triangle with Plotly Jun 2023

Recent Posts

  • Wolfram — Writings Dec 2023
  • Feynman — The Relation of Physics to Other Sciences Dec 2023
  • Engineering Math Nov 2023
  • The Engineering Hub Nov 2023
  • AI outperforms conventional weather forecasting Nov 2023

Archives

Categories

QuickLinks

Instant Access to all Posts
Tyler TX weather • 3-day history
Tyler TX weather • calendar month
Tyler TX weather • graph month
East Texas weather • TAMU
Hacker News (from YCombinator)
  • Home
  • What is Mathpax ?
  • Blog
  • Contact/Interests
  • About
  • All Things Loyola
  • Instant Access
  • Tabular List — Blog Entry Search