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 […]
There is no excerpt because this is a protected post.
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 […]
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 […]
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 […]