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 […]
Category: Software
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.
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 […]
Tabular List — Blog Entries Oct 2020
Structural Analysis, Finite Difference Method, Pythonista, and Plotly Oct 2020
Beam Problem — Hand Calculation PDF LINK — beam analysis — hand calculations The 5 page calculation in the PDF was done in 1983. The quidiagonal matrix solution was probably done with an HP-41 calculator program. Beam Problem — Plotly Graph LIVE LINK to HTML PAGE — using Plotly The Plotly graph shows deflections, shears, […]
Excel — Use dynamic arrays and conditional formatting to create a selection dependent menu Oct 2020
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
CodeSkulptor3 (Probability Plot) Aug 2020
I built a short presentation demonstrating the use of CodeSkulptor3 (Python 3). This time, my goal was to illustrate coding a small probability problem including a plot of results — accessible from any device — desktop, phone, iPad. Feel free to follow the links and to offer a critique. Probability of finding exactly one digit […]
Recent Comments