Mathpax
  • Home
  • What is Mathpax ?
  • Blog
  • Contact/Interests
  • About
  • All Things Loyola
  • Galleries
    • Gallery (General)
    • Gallery (Antarctica and Arctic)
    • Gallery (Seismology)
  • Encounter with Rust
  • Tabular List β€” Blog Entry Search
  • Search the site ... πŸ”
  • Homepage
  • >
  • PyXLL

Category: PyXLL

ACI Rebar Lookup May 2023

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

I built a rebar lookup using PyXLL

lookup

Continue Reading

Foundation Bearing Pressures using Jupyter and PyXLL (with videos) Mar 2023

  • khoitsma
  • Calculus, Engineering, Excel, Jupyter, Plotly, Python, PyXLL, Video
  • 0 Comments

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

Python β€” develop, sell, deploy, protect Nov 2022

  • khoitsma
  • Concept, Excel, Python, PyXLL, Software
  • 0 Comments

In 2022, let’s consider the difficulties of development using Python.

Hint: it isn’t the programming.

Continue Reading

Excel — Taming of the Shapes with PyXLL May 2022

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

Using PyXLL, I have programmed automatic shapes in Excel. That is, I built a function that draws an arbitrary shape in a user spreadsheet: the shape is defined by a range of coordinates; as the coordinates are edited, a new shape can be drawn.

Continue Reading

Python, PyXLL, and Pyside2 Nov 2021

  • khoitsma
  • PySide2, Python, PyXLL, Video
  • 0 Comments

I built a full PySide2 menu that allows the selection and presentation of AISC steel properties and the calculation of ASCE wind loads.

Continue Reading

Excel Dropdown with NO worksheet data list — redux Aug 2021

  • khoitsma
  • Excel, Python, PyXLL
  • 0 Comments

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 […]

Continue Reading

Transform Axes Jun 2021

  • khoitsma
  • Excel, Mathematics, Python, PyXLL
  • 0 Comments

In structural engineering, we must constantly deal with axes transformations. Mostly we have right handed coordinates (RHC), but sometimes left handed coordinates (LHC).

Continue Reading

Protected: Parsing Feet Inches Sixteenths (FIS) Jun 2021

  • khoitsma
  • Excel, Mathematics, Python, PyXLL
  • Enter your password to view comments.

There is no excerpt because this is a protected post.

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

Posts navigation

Older posts

Recent Comments

  • Karl Hoitsma on Recent Posts
  • khoitsma on All Things Loyola
  • khoitsma on Commemorating 55 years: Loyola University, New Orleans 1967 SSTP
  • Martha (Marty) ZΓΊΓ±iga on Commemorating 55 years: Loyola University, New Orleans 1967 SSTP
  • khoitsma on Monty Hall — Consider Only Strategy Dec 2022

Recent Posts

  • USS Hilarity (minesweeper) WWII
  • ACI Rebar Lookup May 2023
  • Weathering Apr 2023
  • Foundation Bearing Pressures using Jupyter and PyXLL (with videos) Mar 2023
  • Dr. Frank Komitsky, Jr. Feb 2023

Archives

Categories

User Login

[swpm_login_form]

https://w1.weather.gov/obhistory/KTYR.html

  • Home
  • What is Mathpax ?
  • Blog
  • Contact/Interests
  • About
  • All Things Loyola
  • Galleries
    • Gallery (General)
    • Gallery (Antarctica and Arctic)
    • Gallery (Seismology)
  • Encounter with Rust
  • Tabular List β€” Blog Entry Search