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
Protected: Parsing Feet Inches Sixteenths (FIS) Jun 2021
There is no excerpt because this is a protected post.
ASCE Exact Wind Integration (closed form equations) Jun 2021
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
PyXLL to Jupyter Interface (with video) Dec 2020
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
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.
Recent Comments