There is no excerpt because this is a protected post.
Screenshot Entering Fractions ‘ NOTES ‘ ‘ This excerpt is taken from my Excel VBA project code ‘ ‘ This subroutine is activated by any change to the worksheet ‘ ‘ In a certain range of cells, named “Fraction Groups” (see Column E), ‘ the user enters the fractional portion of a measurement without a […]
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 […]
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
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.
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 […]
Google Search dynamic arrays conditional formatting TRY THIS The MP4 video was recorded on an iPad and published using Camtasia 2020. The data range is conditionally formatted to match the selection
In the petrochemical business, it is quite common to see structural steel braces built from WT shapes. If you like Table 4-12 in the AISC 15th Edition, then you might like the attached example plots which I built on the same principle. AISC 15th Edition LRFD maximum axial capacities in kips; KL in feet Maximum […]