Category: Engineering Codes

Building codes and specifications

PyQt PyXLL Jupyter macros Feb 2025

• khoitsma
• ASCE, Excel, Jupyter, PyQt, PySide2, Python, PyXLL, Video
• 0 Comments

~~~

Continue Reading

App C2 AISC Bolt Capacity using Dash/PythonAnywhere Nov 2024

• khoitsma
• AISC, Dash by Plotly, iPad_iPhone, Plotly, Python, pythonanywhere
• 0 Comments

Continue Reading

AISC Bolt Shear Capacity — Minimum Dimensions Feb 2024

• khoitsma
• AISC, Engineering, Engineering Codes, Pythonista, Steel Detail
• 0 Comments

Continue Reading

Filter a Pandas Dataframe using PyXLL (with video) Jul 2023

• khoitsma
• AISC, Concept, Engineering, Excel, Python, PyXLL, Video
• 0 Comments

The function uses only three parameters: the criteria range, the reverse sort toggle, and the upper limit on rows of results.

Note that conditional formatting is applied using the PyXLL formatter option.

Continue Reading

ACI Rebar Lookup May 2023

• khoitsma
• ACI, Engineering, Engineering Codes, Excel, Python, PyXLL
• 0 Comments

I built a rebar lookup using PyXLL

Continue Reading

PyXLL using Jupyter and PySimpleGUI Interface (with video) Dec 2022

• khoitsma
• AISC, Excel, Jupyter, PySimpleGUI, Python, PyXLL, Video
• 0 Comments

This post features:
  the PyXLL add-on
  Jupyter
  the PySimpleGUI graphical interface

Continue Reading