Author Archives: dougaj4

A Treatise on the Mathematical Theory of Elasticity

Posted on October 10, 2020

The book The Man Who Knew Infinity by Robert Kanigel describes the life of the Indian mathematician  Srinivasa Ramanujan, and also his Cambridge mentor G.H. Hardy. It mentions that Hardy was influenced by reading “A Treatise on the Mathematical Theory … Continue reading →

Posted in Beam Bending, Maths, Newton | Tagged , , , , | Leave a comment

Using Excel with Python and ctypes

Posted on October 5, 2020

The Strand7 API provides an interface between the Strand7 Finite Element Analysis program and external software. It works with many different languages, including Python, which uses ctypes to transfer data to and from the API functions. It is essential that … Continue reading →

Posted in Beam Bending, Excel, Link to dll, Link to Python, NumPy and SciPy, PyXLL, Strand7, UDFs | Tagged , , , , , | Leave a comment

Spherical Geometry and Vincenty’s Formulae

Posted on September 27, 2020

Wikipedia has detailed articles on: Spherical Geometry  and Vincenty’s Formulae (for geometric calculations on an ellipsoid). The spreadsheet Vincenty.xlsb 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 , , , , , , | Leave a comment

Melanie Safka + Miley Cyrus

Posted on September 25, 2020

I have previously posted a link to a young Melanie singing Look What They Done to my Song, Ma.  45 years later, she got together with Miley Cyrus to sing the song again, and they both look like they had … Continue reading →

Posted in Bach | Tagged , , | Leave a comment

Import Data from a Picture to Excel

Posted on September 16, 2020

The myOnlineTraininghub blog recently had a post entitled Import Data from a Picture to Excel which sounded promising, since I often need to extract data from Autocad files saved to a pdf. From the link, it seems that if I … Continue reading →

Posted in Computing - general, Excel | Tagged , , , | 1 Comment