MD Data Table in Action — Video 3 inputs; 2 outputs Bonus — Video Merged my data table values into Excel’s data table 3D Hypotenuse Screenshots Independent Variables — Input qvar_0 (10 items) qvar_1 ( 7 items) qvar_2 ( 4 items) Dependent Variables — Results Dependent Variables — Details (only for clarity) Short Tabulation Long […]
Category: PyXLL
PyXLL to Jupyter Interface (with video) Dec 2020
Screenshots Jupyter Interface — Input Jupyter Interface — Input — Alternate Jupyter Interface — Output Excel Input Output Jupyter Matplotlib Plot Named Ranges Pasted List Named Ranges in Excel Name Manager Interface in Action — Video
PyXLL Custom Task Panes in Excel (with automated drawings and video) Nov 2020
Dialog Screenshots Generic Dialog AISC Dialog with to-scale cross section drawing Dialogs in Action — Video In the video, notice that the to-scale cross section drawing is updated as each AISC shape is selected.
Excel Dropdown with NO worksheet data list (with video) Nov 2020
PyXLL function information PyXLL macro functions Spreadsheet Setup Legend Assign macro to button The ‘entry cell’ is shaded (for clarity only). The optional ‘initial value’ entry is up one row from the entry. The optional ‘regex filter’ entry is up two rows from the entry. The optional ‘name reference’ entry is up three rows from […]
ASCE 7-16 Ice Loading Apr 2018
Function get_iceweight, a function of … structural shape all kinds of structural shapes pipe, HSS, bar L, 2L, 2L spaced C, MC W, S, M, HP WT, ST, MT ‘basic’ ice thickness from ASCE map importance factor for ice function of height above grade topographic factor ice density Excel implementation … Self documentation for function […]
AISC C Coefficient for Bolt Groups Nov 2017
Replaces 48 pages of design tables in the AISC Manual. Allows any: bolt quantity or row spacing or column spacing or rotation No manual interpolation required. Karl Hoitsma, P.E. (khoitsma)
PyXLL Programmable Data Validation Nov 2017
… continued from PyXLL Dictionaries (earlier post) Karl Hoitsma, P.E. (khoitsma)
PyXLL Dictionaries — Simple retrieval of data Nov 2017
… see Data Validation (later post) Karl Hoitsma, P.E. (khoitsma)
Using AISC Properties Oct 2017
Use the properties in Excel formulas Let’s look at example calculations! These calculations consider concentrated loads on wide flange shapes. Watch the video — click ‘Formula Examples Video’. Formula Examples Video Still screenshots Formula Example 1 Formula Example 2 Formula Example 3 Karl Hoitsma, P.E. (khoitsma)
AISC Properties in Excel: Almost Magic Oct 2017
From scratch, using PyXll, I built an AISC property viewer for Excel. Just add calculations! Karl Hoitsma, P.E. (khoitsma)
Recent Comments