VBA procedures for the Numerical Analysis of Tabular Functions

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 a programmer. The first day on the job, I was handed a copy of A guide to FORTRAN programming by Daniel McCracken. It was love at first sight. I was a Mathematics major from Notre Dame, but all my courses were focused on theoretical mathematics rather than a more engineering focused piratical mathematics. I switched over to Aeronautical Engineering during my senior year. And then followed up by going to Graduate School for a degree in Astronautics.

In the early 1960’s I discovered an article in Design News, a trade magazine, that featured a short article on the Aitken Graphical Construction for generating additional points on a Parabola. This article became the foundation of my efforts to then put together my Tool Kit of codes for Tabular functions.

I am re-factoring the original FORTRAN code to Excel VBA.  I was first posting on WordPress: https://alfred-excel-vachris.com/author/excel1star/
But I find it much easier to post PDF documents on LinkedIn.

Here is a list of LinkedIn posts related to the Toolkit:
Aitken
https://www.linkedin.com/posts/alfredvachris_aitkens-graphical-construction-for-a-parabola-activity-6742091467516362752-_g34

Aitken Demonstration
https://www.linkedin.com/posts/alfredvachris_a-user-controlled-demonstration-of-the-aitken-lagrange-activity-6680575526626697217-DOCC

Aitken Variation – Hermitian Interpolation
https://www.linkedin.com/posts/alfredvachris_implicit-hermitian-interpolation-based-on-activity-6687450493733609473-P0Vu

Arc Length
https://www.linkedin.com/posts/alfredvachris_arc-length-calculation-for-2-d-and-3-d-tabular-activity-6557787121778774016-lTcu

Non-Linear Interpolation
https://www.linkedin.com/posts/alfredvachris_vba-project-non-linear-interpolation-of-activity-6765296370187280384-bcKb

Graphical Twist – Alternate Brent Root Finding
https://www.linkedin.com/posts/alfredvachris_a-graphical-twist-for-inverse-quadratic-root-activity-6745791760284344321-2l6A

Root Finding Examples – Polynomials
https://www.linkedin.com/posts/alfredvachris_my-root-finder-applied-to-a-collection-of-activity-6745865688365195264-8iws/

https://www.linkedin.com/posts/alfredvachris_myrootfinding-application-for-various-examples-activity-6746237834690105345-7ZWu/

Slope: Numerical Differentiation of Tabular Functions
https://www.linkedin.com/posts/alfredvachris_slope-numerical-differentiation-of-tabular-activity-6835626747069792256-XClT

Tangent Estimates
https://www.linkedin.com/posts/alfredvachris_a-collection-of-tangent-estimates-for-numerical-activity-6841109472837021696-RovK

For the benefit of those (like me) not familiar with how Linkedin displays pdf documents, to display the full text and make links active:

Scroll to the bottom of the displayed page and click the “full-screen” icon at the bottom right:

At the top of the page click on “Accessibility Mode”, or the download icon:

This entry was posted in Coordinate Geometry, Curve fitting, Excel, Fortran, Maths, Newton, UDFs, VBA and tagged , , , , , , . Bookmark the permalink.

1 Response to VBA procedures for the Numerical Analysis of Tabular Functions

  1. excel1star says:

    Great Thanks for sharing! Alfred

    Sent from my iPhone

    >

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.