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

Category: Excel

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

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

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

Two Point Lift with Rotation Aug 2022

  • khoitsma
  • Engineering, Excel
  • 0 Comments

Two point lifts with rotation sometimes defy simple intuition.
I present several features in my Excel spreadsheet.


Lift Sequence from horizontal to vertical

 

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

Adding tools to Excel Jan 2022

  • khoitsma
  • Excel, Video
  • 0 Comments

In a short video, I show how to modify the Excel ribbon

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

  • Excel โ€” Drawing Automated Shapes with PyXLL Sep 2023
  • Design for Flood, Wind, Seismic, Snow, Ice, and Fire Aug 2023
  • Moment due to Linearly Varying Pressure Aug 2023
  • Galleries Aug 2023
  • Small Ideas — Large Effects Aug 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
Hacker News (from YCombinator)
  • Home
  • What is Mathpax ?
  • Blog
  • Contact/Interests
  • About
  • All Things Loyola
  • Instant Access
  • Tabular List โ€” Blog Entry Search