Category Archives: Coordinate Geometry

3D Matplotlib Plots in Excel

Posted on April 17, 2022 by dougaj4

As well as Excel, the code shown in this post requires current versions of Python, Numpy, Matplotlib, and pyxll. The required import statements at the head of the Python code are: The spreadsheets and Python code described below may be … Continue reading →

Posted in Charts, Charts, Coordinate Geometry, Drawing, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | Leave a comment

VBA procedures for the Numerical Analysis of Tabular Functions

Posted on March 12, 2022 by dougaj4

Long time on-line friend Alfred Vachris has recently been converting Fortran code developed through his working career into VBA: I had the opportunity to work at Grumman while going to Graduate School and they gave me a part-time job as … Continue reading →

Posted in Coordinate Geometry, Curve fitting, Excel, Fortran, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 1 Comment

SectionProperties update 3

Posted on February 9, 2022 by dougaj4

The SectionProperties spreadsheets previously posted had limited graphics capabilities due to problems with the plotting routines causing Excel to crash. I have now fixed that problem by updating some Python libraries with pip: installing mkl-service numpy 1.21.2 -> 1.22.1 Pillow … Continue reading →

Posted in Beam Bending, Charts, Charts, Coordinate Geometry, Excel, Finite Element Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL | Tagged , , , , , | 1 Comment

Spherical Geometry and Vincenty’s Formulae

Posted on September 27, 2020 by dougaj4

Wikipedia has detailed articles on: Spherical Geometry  and Vincenty’s Formulae (for geometric calculations on an ellipsoid). The spreadsheet Vincenty.zip uses those resources to perform the following calculations, using both on-sheet calculations and VBA user-defined functions (UDF’s): Calculation of distance and … Continue reading →

Posted in Computing - general, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 6 Comments

Section Properties for Rotated Shapes

Posted on August 6, 2020 by dougaj4

I have just posted an update to my section properties spreadsheet, last discussed at: Using Section Properties- Group The new version can be downloaded from: Section Properties07-Group.zip The main sheet provides section properties for a wide variety of defined shapes: This … Continue reading →

Posted in Beam Bending, Coordinate Geometry, Excel, Frame Analysis, Maths, Newton, UDFs, VBA | Tagged , , , , | Leave a comment