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

khoitsma
Concept, editor's pick, 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.

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 […]