Homepage
>
Excel

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

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.

Continue Reading

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.

Continue Reading