Homepage
>
Engineering

Design for Flood, Wind, Seismic, Snow, Ice, and Fire Aug 2023

Overview
Flood
Wind
Earthquake
Snow and Ice
Fire

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

Small Ideas — Large Effects Aug 2023

khoitsma
Concept, Engineering, General, History, Mathematics, Science, Software
0 Comments

Continue Reading

Online Embedded Excel Aug 2023

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

Enhanced Lookup — Excel and PyXLL June 2023

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

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