Category: Excel

Foundation Bearing Pressures using Jupyter and PyXLL (with videos) Mar 2023

• khoitsma
• Calculus, Engineering, Excel, Jupyter, Plotly, Python, PyXLL, Video
• 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

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.

 

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