Shear and Moment Diagram The above shows the shear and moment diagram for a propped cantilever. The leancrew link has a full explanation of the mechanics involved. https://leancrew.com/all-this/2015/08/super/ Examples of use in my structural engineering Python, PyXLL, and Pyside2 Nov 2021 Wind and Fire-proofing Dec 2017
Category: Excel
Excel Functions Nov 2021
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.
Feet Inches Sixteenths (FIS) Calculator Jun 2021
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 […]
ASCE Exact Wind Integration (closed form equations) Jun 2021
Multi-Dimension Data Table using PyXLL (with video) Dec 2020
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 […]
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.
Recent Comments