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
  • >
  • PyXLL

Category: PyXLL

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

Multi-Dimension Data Table using PyXLL (with video) Dec 2020

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

I coded a PyXLL macro that builds a multi-dimension data table.
The native Data Table provided by Excel is useful but limited to two variables.
My version is set up for 5 independent variables and an unlimited (theoretically) number of dependent variables. Five was an arbitrary choice; some limitation is required here.

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

Excel Dropdown with NO worksheet data list (with video) Nov 2020

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

I built an Excel dropdown function β€” that requires no worksheet reference!

The dropdown built into Excel requires a range of data to populate the dropdown list. This might be an appropriate situation if the spreadsheet is a one-off. In my work, the dropdown list would more appropriately be generated in my PyXLL program.

Continue Reading

ASCE 7-16 Ice Loading Apr 2018

  • khoitsma
  • AISC, ASCE, Excel, Python, PyXLL
  • 0 Comments

Although ice loading is written as a simple formula, the formula varies with structural geometry (W, T, C, etc). I haven’t seen it automated in software.

Continue Reading

Posts navigation

Older posts
Newer 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