Mathpax
  • Home
  • What is Mathpax ?
  • Blog/Contact/Interests/About
    • Blog
    • Contact/Interests
    • About
  • All Things Loyola
  • Search Posts
    • Instant Access
    • Tabular List — Blog Entry Search
  • Search the site ... 🔍
  • Homepage
  • >
  • Engineering Codes

Category: Engineering Codes

Building codes and specifications

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.

lookup

Continue Reading

ACI Rebar Lookup May 2023

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

I built a rebar lookup using PyXLL
lookup

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

Easy Section Properties for Array of Points © Oct 2022

  • khoitsma
  • AISC, Concept, Engineering, Mathematics, Steel Detail
  • 0 Comments

Based on finite calculus


Continue Reading

AISC bolt holes Aug 2022

  • khoitsma
  • AISC, Python, Steel Detail
  • 0 Comments

This code illustrates the readability of Python.

Compare reading the text of AISC 15th Edition Manual, Section J3 to the program statements.

Continue Reading

Pipe Flexibility using Julia and Jupyter Jul 2022

  • khoitsma
  • ASME, Engineering, Julia, Jupyter, Plotly, Plots, Symbolics
  • 0 Comments

I compared equations from den Hartog, from Kireev et al, and from B31.3 Table D300.

The agreement was quite good.

Continue Reading

ASCE Exact Wind Integration (closed form equations) Jun 2021

  • khoitsma
  • ASCE, Calculus, Cocalc, Excel, Jupyter, Mathematics, Python, PyXLL, SageMath
  • 0 Comments

I developed a Python function to calculate closed form exact values for wind forces and wind CGs.

I use only calculus — no bar charts with 0′ to 15′, 20′ to 25′, et cetera —- a curve rather than a step function. I present derivations and examples.

Continue Reading

PyXLL to Jupyter Interface (with video) Dec 2020

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

This example is an actual serious structural engineering calculation with graphical documentation.

Continue Reading

PyXLL Custom Task Panes in Excel (with automated drawings and video) Nov 2020

  • khoitsma
  • AISC, Excel, PyQt, Python, PyXLL, Video
  • 0 Comments

The PyXLL/Jupyter interface would be drab without custom menus and graphical feedback.

Continue Reading

Multi-Page Apps using Dash/PythonAnywhere Apr 2020

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

I built these apps on the web — accessible from any device — desktop, phone, iPad
· Grating calculations
· AISC strong axis bending
· AISC filtered shape properties
· Coefficient C for bolt groups
· WT strut capacity (eccentrically loaded)

Continue Reading

Posts navigation

Older posts

Recent Comments

  • Quoc Duong PHUNG on Soil Texture Triangle with Plotly Jun 2023
  • khoitsma on Soil Texture Triangle with Plotly Jun 2023
  • Quoc Duong PHUNG on Soil Texture Triangle with Plotly Jun 2023
  • khoitsma on Soil Texture Triangle with Plotly Jun 2023
  • Quoc Duong PHUNG on Soil Texture Triangle with Plotly Jun 2023

Recent Posts

  • Excel — Drawing Automated Shapes with PyXLL Sep 2023
  • Design for Flood, Wind, Seismic, Snow, Ice, and Fire Aug 2023
  • Moment due to Linearly Varying Pressure Aug 2023
  • Galleries Aug 2023
  • Small Ideas — Large Effects Aug 2023

Archives

Categories

QuickLinks

Instant Access to all Posts
Tyler TX weather • 3-day history
Tyler TX weather • calendar month
Tyler TX weather • graph month
Hacker News (from YCombinator)
  • Home
  • What is Mathpax ?
  • Blog
  • Contact/Interests
  • About
  • All Things Loyola
  • Instant Access
  • Tabular List — Blog Entry Search