Interval Filter using PyXLL Oct 2024

khoitsma
editor's pick, Excel, Python, PyXLL, Video
0 Comments

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

khoitsma
editor's pick, Excel, PySide2, Python, PyXLL, Video
0 Comments

UPDATE

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

What is the Day of the Week? Jan 2024

Engineering Math Nov 2023

“Often while working, an arithmetical answer is needed — exact is sometimes required, approximate is often acceptable — maybe the basis of a decision or a path forward is based on a few quick calculations, with more rigorous calculations to follow

Multiply by 11 (or 12). Just write down the answer !
Pascal’s Triangle
Aliquot Parts

Excel — Drawing Automated Shapes with PyXLL Sep 2023

khoitsma
Concept, editor's pick, Excel, Python, PyXLL
0 Comments

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.