Much Better Dropdowns Jan 2025

~~~

I built a set of functions demonstrating dynamic filtering and sorting using Excel and PyXLL. The functions determine whether a value is within a numeric interval (closed, open, or any combination).

A video illustrates the performance.

One million filters

PyXLL PySide2 CTP ActiveX Sep 2024

UPDATE

I built a full PySide2 menu that allows the selection and presentation of AISC steel properties and the calculation of ASCE wind loads.

Excel — Dictionary References with PyXLL Jan 2024

Hand Calculated Truss vs RISA Dec 2023

khoitsma
Calculus, Computer Algebra, Engineering, Jupyter, Mathematics, Plotly, Python, RISA-3D, Sympy
hand calculated, RISA, truss
0 Comments

Convolution as seen in Virtual Work Nov 2023

khoitsma
Calculus, Engineering, Jupyter, Mathematics, Plotly, Python, Sympy
0 Comments

Is this convolution linear or nonlinear?

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.

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

Online Embedded Excel Aug 2023

I built a new app on the web — accessible from any device — desktop, phone, iPad

· Grating calculations

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

Enhanced Lookup — Excel and PyXLL June 2023

I built a couple special lookup functions using PyXLL

and

an interesting helper function

lookup

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

khoitsma
Calculus, Engineering, Excel, Jupyter, Plotly, Python, PyXLL, Video
0 Comments

Soil Texture Triangle with Plotly Jun 2023

ACI Rebar Lookup May 2023

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

I built a rebar lookup using PyXLL
lookup

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

Python — develop, sell, deploy, protect Nov 2022

In 2022, let’s consider the difficulties of development using Python.

Hint: it isn’t the programming.

AISC bolt holes Aug 2022

This code illustrates the readability of Python.

Compare reading the text of AISC 15th Edition Manual, Section J3 to the program statements.

Asymmetric Frame Loading Jul 2022

khoitsma
Calculus, Engineering, Jupyter, Mathematics, Plotly, Python, RISA-3D, SAP2000, Sympy
0 Comments

In memory of Dr. Terry Kohutek, Texas A & M, Professor of Civil Engineering

Structural Calculations for Beams Using Calculus via Sympy Jul 2022

khoitsma
Calculus, Computer Algebra, Engineering, Jupyter, Mathematics, Plotly, Python, Sympy
0 Comments

Something about calculus and Sympy is lovable.

Click to see R1 plot; hover over data points to see data values; use finger or mouse to select rectangular area of interest

Beam Deflections Jun 2022

khoitsma
Calculus, Computer Algebra, Engineering, Jupyter, Mathematics, Plotly, Python, Sympy
0 Comments

I thought I should reassess and resharpen my basic structural engineering skills.

Lucky Me Jun 2022

khoitsma
Computer Algebra, General, Mathematics, Mental Math, Personal, Python, Software
0 Comments

As a kid and later through my career, several lucky things happened to me; some of these things were fortuitous and some happened because I searched them out — either way, still lucky.

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.

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.

Excel Dropdown with NO worksheet data list — redux Aug 2021

I decided to delete this post … There are limits to the number of items that will show in a data validation drop down list: The list can show up to show 32,767 items from a list on the worksheet. If you type the items into the data validation dialog box (a delimited list), the […]