Category: Software
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
MIT Math Test 1876 Jan 2021
Problem 1 Problem 2 Problem 3 Problem 4 Problem 5 And here is the Jupyter notebook solving the problems using computer algebra (CA). The CA for the five problems was done using the Sympy module, the Python language, and a Jupyter notebook. Click on download to get the Jupyter notebook: (you might need to right […]
Best of Seven Outcome Probability Dec 2020
Static Plots Using PLOTLY live plots Each chart series can be toggled off and on by clicking its legend entry. On a desktop device, reset the chart to full scale by reloading the web page. On a mobile device, reset the chart to full scale by double clicking. Team A Winning Outcomes The best of […]
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