Homepage
>

Best of Seven Outcome Probability Dec 2020

There must be 70 ways to … win the playoff.

Continue Reading

From Punch Cards to Flash Memory Dec 2020

Continue Reading

Protected: D Day Paratroopers June 1944

khoitsma
History, Personal
Enter your password to view comments.

There is no excerpt because this is a protected post.

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