Homepage
>
Excel

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

Feet Inches Sixteenths (FIS) Calculator Jun 2021

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