Mathpax
  • Blog
  • About
  • Contact/Interests
  • Nellie Vanderzee Contact Form A 04042020
  • Homepage
  • >
  • Excel

Category: Excel

Excel — Taming of the Shapes with PyXLL May 2022

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

Shear and Moment Diagram The above shows the shear and moment diagram for a propped cantilever. The leancrew link has a full explanation of the mechanics involved. https://leancrew.com/all-this/2015/08/super/ Examples of use in my structural engineering Python, PyXLL, and Pyside2 Nov 2021 Wind and Fire-proofing Dec 2017

Continue Reading

Excel Functions Nov 2021

  • khoitsma
  • Excel
  • 0 Comments
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
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

Feet Inches Sixteenths (FIS) Calculator Jun 2021

  • khoitsma
  • Concept, Excel
  • 0 Comments

Screenshot Entering Fractions ‘ NOTES ‘ ‘ This excerpt is taken from my Excel VBA project code ‘ ‘ This subroutine is activated by any change to the worksheet ‘ ‘ In a certain range of cells, named “Fraction Groups” (see Column E), ‘ the user enters the fractional portion of a measurement without a […]

Continue Reading

ASCE Exact Wind Integration (closed form equations) Jun 2021

  • khoitsma
  • ASCE, Cocalc, Excel, Jupyter, Python, PyXLL, SageMath
  • 0 Comments
Continue Reading

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

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

MD Data Table in Action — Video 3 inputs; 2 outputs Bonus — Video Merged my data table values into Excel’s data table 3D Hypotenuse Screenshots Independent Variables — Input qvar_0 (10 items) qvar_1 ( 7 items) qvar_2 ( 4 items) Dependent Variables — Results Dependent Variables — Details (only for clarity) Short Tabulation Long […]

Continue Reading

PyXLL to Jupyter Interface (with video) Dec 2020

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

Screenshots Jupyter Interface — Input Jupyter Interface — Input — Alternate Jupyter Interface — Output Excel Input Output Jupyter Matplotlib Plot Named Ranges Pasted List Named Ranges in Excel Name Manager Interface in Action — Video

Continue Reading

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

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

Dialog Screenshots Generic Dialog AISC Dialog with to-scale cross section drawing Dialogs in Action — Video In the video, notice that the to-scale cross section drawing is updated as each AISC shape is selected.

Continue Reading

Posts navigation

Older posts
  • Blog
  • About
  • Contact/Interests
  • Nellie Vanderzee Contact Form A 04042020

User Login

[swpm_login_form]

Recent Posts

  • Pipe Stress Calculus May 2022
  • Excel — Taming of the Shapes with PyXLL May 2022
  • Powerful Song Apr 2022
  • What I learned at the planetarium (and after) Mar 2022
  • Subterranean Vibrations Feb 2022

Recent Comments

  • khoitsma on Multi-Dimension Data Table using PyXLL (with video) Dec 2020
  • exceler on Multi-Dimension Data Table using PyXLL (with video) Dec 2020
  • khoitsma on Calculate Beta w for Single Angles Dec 2019 (revised Jul 2021)
  • Shawn J Nolan on Calculate Beta w for Single Angles Dec 2019 (revised Jul 2021)
  • khoitsma on AISC Bolt Shear — C Coefficient Jul 2019

Archives

  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017

Categories

  • ACI
  • AISC
  • ASCE
  • Azure
  • Bitwarden
  • Cocalc
  • CodeSkulptor
  • Computer Algebra
  • Concept
  • Dash by Plotly
  • Desmos Calculator
  • Engineering
  • Engineering Codes
  • Excel
  • General
  • Hardware
  • History
  • iPad_iPhone
  • Jupyter
  • Maple
  • Mathematics
  • MathPix
  • Mental Math
  • Observation
  • Petrochemical Design
  • Plotly
  • PyQt
  • PySide2
  • Python
  • pythonanywhere
  • Pythonista
  • PyXLL
  • Raspberry Pi 3 Plus
  • SageMath
  • Science
  • Software
  • Steel Detail
  • Sunfounder Sensor Kit
  • Sympy
  • Texas Tech (TTU)
  • Uncategorized
  • Wolfram Alpha

Theme: Starbay by Industhemes.