I built a full PySide2 menu that allows the selection and presentation of AISC steel properties and the calculation of ASCE wind loads.
Filter a Pandas Dataframe using PyXLL (with video) Jul 2023
Foundation Bearing Pressures using Jupyter and PyXLL (with videos) Mar 2023
PyXLL using Jupyter and PySimpleGUI Interface (with video) Dec 2022
Excel — Taming of the Shapes with PyXLL May 2022
Lecture by Richard Feynman – with transcript Feb 2022
Adding tools to Excel Jan 2022
Interview with James McDonald PhD, PE – Transcript Dec 2021
McDonald discusses his career at Texas Tech in the Department of Engineering and his research on structural damage from natural disasters.
Special Lecture: F-22 Flight Controls Dec 2021
Luckily, I happened upon this video; I couldn’t stop watching.
Python, PyXLL, and Pyside2 Nov 2021
Fascinating Science Lectures Mar 2021
Richard Dawkins
Multi-Dimension Data Table using PyXLL (with video) Dec 2020
PyXLL to Jupyter Interface (with video) Dec 2020
PyXLL Custom Task Panes in Excel (with automated drawings and video) Nov 2020
The PyXLL/Jupyter interface would be drab without custom menus and graphical feedback.
Excel Dropdown with NO worksheet data list (with video) Nov 2020
Excel — Use dynamic arrays and conditional formatting to create a selection dependent menu Oct 2020
Though I built this spreadsheet menu using Excel on a desktop machine, the spreadsheet file also works on an iPad ( ! ) and on an iPhone ( !! ).
Microsoft 365 is required.
Sir Martyn Poliakoff, Element 33, and the periodic chart of videos Sep 2020
knowledge, research, perseverance, adventure Aug 2019
AISC Bolt Shear Capacity (with video) Jun 2019
Raspberry Pi with Sunfounder Sensor Kit Dec 2018
The video shows the LCD Display connected to the Raspberry Pi. Easy setup Easy programming
What’s on the Pythonista menu? Yep, sliders! Side dish of booleans, integers and floats Dec 2018
I built this app and am running this app on my iPad. Credit to: mikaelho / pythonista – gestures tdamdouni / Pythonista Pythonista / slider / SliderWithLabel_danrcook.py The video shows an app with 8 inputs — 2 integer, 4 float, 2 boolean. Numeric input is tedious — at best; slider input is easier and offers positive feedback. In this […]
ASCE 7-16 Ice Loading using Pythonista Oct 2018
AISC C Coefficient for Bolt Groups using Azure Jupyter Notebook Oct 2018
I decided to try out Jupyter using Microsoft Azure (currently a free trial). I’ve invested a couple of days on this project including learning new notebook extensions and Interact widgets. And so far, so good. Pros Easy to use Well-documented Relatively trouble-free Cons Could have faster response times
Pythonista 3 has an excellent UI development platform! May 2018
All of the AISC structural shapes at your fingertips The user may filter shapes by nominal type and by nominal size This is a standalone app built using Pythonista 3. Less than 500 lines of user programming (my programming) Data is contained in a CSV file of a couple thousand lines Visual drag and drop GUI builder – very nice […]
Wind and Fireproofing Dec 2017
Stand alone python program easily calculates wind loads on wide flange steel of any geometry or orientation, with or without fireproofing (video screen capture included).
Steel Properties App using PyQt Dec 2017
I’m partial, but I like this tool.
AISC C Coefficient for Bolt Groups using Pythonista Nov 2017
NOTE:Â Â Video format changed to MP4.
AISC C Coefficient for Bolt Groups (with video) Nov 2017
Replaces 48 pages of design tables in the AISC Manual. Allows any: bolt quantity or row spacing or column spacing or rotation No manual interpolation required. Karl Hoitsma, P.E. (khoitsma)
PyXLL Programmable Data Validation Nov 2017
… continued from PyXLL Dictionaries (earlier post)
Using AISC Properties Oct 2017
Examples
QuickLinks
Instant Access to all Posts
My Dash apps
My GeoGebra app
What is the most general equation for the area of a triangle?
The Wait calculation
The incessant obsolescence postulate (IOP)
Barnard’s Star and the 'Wait Equation'
IOP counterargument
The amazing arbelos
Japanese temple geometry
★ Sister Celine — a beautiful life
★ John Lienhard IV on Ingenuity
★ Charles Stutzenbaker, Field Biologist
Neal Stephenson on the OS
A few quotations
Tyler TX weather • 🌡 Steve Fitzgerald
Tyler TX weather • 3-day history
Tyler TX weather • calendar month
Tyler TX weather • graph month
East Texas weather • TAMU
★ All of the water in the world
Hacker News (from YCombinator)
Instant Access to all Posts
My Dash apps
My GeoGebra app
What is the most general equation for the area of a triangle?
The Wait calculation
Barnard’s Star and the 'Wait Equation'
IOP counterargument
Japanese temple geometry
★ Sister Celine — a beautiful life
★ John Lienhard IV on Ingenuity
★ Charles Stutzenbaker, Field Biologist
Neal Stephenson on the OS
A few quotations
Tyler TX weather • 🌡 Steve Fitzgerald
Tyler TX weather • 3-day history
Tyler TX weather • calendar month
Tyler TX weather • graph month
East Texas weather • TAMU
★ All of the water in the world
Hacker News (from YCombinator)
