Category: Engineering

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.

Continue Reading

Enhanced Lookup — Excel and PyXLL June 2023

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

I built a couple special lookup functions using PyXLL

and

an interesting helper function

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
• 0 Comments

Continue Reading

ACI Rebar Lookup May 2023

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

I built a rebar lookup using PyXLL

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