Homepage
>
PyXLL

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

Continue Reading

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

Continue Reading

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.

Continue Reading

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.

Continue Reading

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

I coded a PyXLL macro that builds a multi-dimension data table (MDDT).

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.

Continue Reading

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.

Continue Reading