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

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

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, 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.

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

Transform Axes Jun 2021

In structural engineering, we must constantly deal with axes transformations. Mostly we have right handed coordinates (RHC), but sometimes left handed coordinates (LHC).

Protected: Parsing Feet Inches Sixteenths (FIS) Jun 2021

khoitsma
Excel, Mathematics, Python, PyXLL
Enter your password to view comments.

There is no excerpt because this is a protected post.

ASCE Exact Wind Integration (closed form equations) Jun 2021

khoitsma
ASCE, Calculus, Cocalc, Excel, Jupyter, Mathematics, Python, PyXLL, SageMath
0 Comments

I developed a Python function to calculate closed form exact values for wind forces and wind CGs.

I use only calculus — no bar charts with 0′ to 15′, 20′ to 25′, et cetera —- a curve rather than a step function. I present derivations and examples.

Multi-Dimension Data Table using PyXLL (with video) Dec 2020

I coded a PyXLL macro that builds a multi-dimension data table.
The native Data Table provided by Excel is useful but limited to two variables.
My version is set up for 5 independent variables and an unlimited (theoretically) number of dependent variables. Five was an arbitrary choice; some limitation is required here.

PyXLL to Jupyter Interface (with video) Dec 2020

khoitsma
AISC, Excel, Jupyter, Python, PyXLL, Video
0 Comments

This example is an actual serious structural engineering calculation with graphical documentation.

PyXLL Custom Task Panes in Excel (with automated drawings and video) Nov 2020

The PyXLL/Jupyter interface would be drab without custom menus and graphical feedback.

Excel Dropdown with NO worksheet data list (with video) Nov 2020

I built an Excel dropdown function — that requires no worksheet reference!

The dropdown built into Excel requires a range of data to populate the dropdown list. This might be an appropriate situation if the spreadsheet is a one-off. In my work, the dropdown list would more appropriately be generated in my PyXLL program.

ASCE 7-16 Ice Loading Apr 2018

Although ice loading is written as a simple formula, the formula varies with structural geometry (W, T, C, etc). I haven’t seen it automated in software.

AISC C Coefficient for Bolt Groups (with video) Nov 2017

Replaces 48 pages of design tables in the AISC Manual. Allows any: bolt quantity or row spacing or column spacing or rotation No manual interpolation required. Karl Hoitsma, P.E. (khoitsma)

PyXLL Programmable Data Validation Nov 2017

… continued from PyXLL Dictionaries (earlier post)

PyXLL Dictionaries — Simple retrieval of data Nov 2017

Code for the dictionary function

Using AISC Properties Oct 2017

Examples

AISC Properties in Excel: Almost Magic Oct 2017

Just add calculations!

AISC Bolt Calculations Jul 2017

This spreadsheet calculates the C coefficient for a full range of bolt patterns (1 to 4 columns of bolts, 1 to 12 rows of bolts).

All values of all C coefficients in one Excel tab !

ASCE Wind and AISC Properties Jun 2017

See list of all AISC posts. See list of all ASCE posts.

Category: PyXLL

PyXLL PySide2 CTP ActiveX Sep 2024

Excel — Dictionary References with PyXLL Jan 2024

Excel — Drawing Automated Shapes with PyXLL Sep 2023

Moment due to Linearly Varying Pressure Aug 2023

Filter a Pandas Dataframe using PyXLL (with video) Jul 2023

Enhanced Lookup — Excel and PyXLL June 2023

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

Soil Texture Triangle with Plotly Jun 2023

ACI Rebar Lookup May 2023

PyXLL using Jupyter and PySimpleGUI Interface (with video) Dec 2022

Python — develop, sell, deploy, protect Nov 2022

Excel — Taming of the Shapes with PyXLL May 2022

Python, PyXLL, and Pyside2 Nov 2021

Excel Dropdown with NO worksheet data list — redux Aug 2021

Transform Axes Jun 2021

Protected: Parsing Feet Inches Sixteenths (FIS) Jun 2021

ASCE Exact Wind Integration (closed form equations) Jun 2021

Multi-Dimension Data Table using PyXLL (with video) Dec 2020

PyXLL to Jupyter Interface (with video) Dec 2020

PyXLL Custom Task Panes in Excel (with automated drawings and video) Nov 2020

Excel Dropdown with NO worksheet data list (with video) Nov 2020

ASCE 7-16 Ice Loading Apr 2018

AISC C Coefficient for Bolt Groups (with video) Nov 2017

PyXLL Programmable Data Validation Nov 2017

PyXLL Dictionaries — Simple retrieval of data Nov 2017

Using AISC Properties Oct 2017

AISC Properties in Excel: Almost Magic Oct 2017

AISC Bolt Calculations Jul 2017

ASCE Wind and AISC Properties Jun 2017

Recent Posts

Archives

QuickLinks

Get new posts by email: