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: Python
PyXLL to Jupyter Interface (with video)
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)
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)
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 […]
Structural Analysis, Finite Difference Method, Pythonista, and Plotly
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, […]
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 […]
Multi-Page Apps using Dash/PythonAnywhere Apr2020
AISC Strong Axis Bending https://khoitsma1.pythonanywhere.com/apps/app2 Replaces 45 pages in AISC 15th Manual Graphical and tabular data Change the shape selection (HP12, for instance) Hover over the chart data points AISC Filtered Shape Properties https://khoitsma1.pythonanywhere.com/apps/app3 All properties for a user’s selection (2L4X3X3/8X3/4SLBB , for instance) Just start typing 2L4 and the drop down will filter to […]
Calculate Beta w for Single Angles Dec 2019
AISC v15.0 Shapes Database # NOTE # For enhanced readability and easier translation to other software, # exponents are indicated with the (mathematically) traditional caret symbol. # In Python, replace all carets with a double asterisk. # Get single angle properties a = np.arctan(my_angle.TANA) c = np.cos(a) s = np.sin(a) b = my_angle.B_LOWERCASE d = […]
Python — Nested Ifs Nov 2019
NESTED IFs: A question was asked recently on Stack Overflow The solution shown below is readable, scalable, easily edited — and contains no IF statements. This is similar to the method proposed by Anitoliy R except I use a single string and the split function to simplify editing and scaling. To illustrate scalability, I add […]
Raspberry Pi with Sunfounder Sensor Kit Dec 2018
The video shows the LCD Display connected to the Raspberry Pi. Easy setup Easy programming
Recent Comments