Homepage
>
Video

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

Excel — Taming of the Shapes with PyXLL May 2022

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

Lecture by Richard Feynman – with transcript Feb 2022

Los Alamos from below

Continue Reading

Adding tools to Excel Jan 2022

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

Continue Reading

Interview with James McDonald PhD, PE – Transcript Dec 2021

McDonald discusses his career at Texas Tech in the Department of Engineering and his research on structural damage from natural disasters.

Continue Reading

Special Lecture: F-22 Flight Controls Dec 2021

Luckily, I happened upon this video; I couldn’t stop watching.

Continue Reading

Python, PyXLL, and Pyside2 Nov 2021

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

Fascinating Science Lectures Mar 2021

Richard Dawkins

Continue Reading