Recent Comments
Author Archives: dougaj4
Using Excel with Python and ctypes
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 ctypes, Excel, Python, PyXLL, Strand7 API, UDF
Leave a comment
Spherical Geometry and Vincenty’s Formulae
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 ellipsoid area, ellipsoid distance, Excel, Spherical Geometry, UDF, VBA, Vincenty's Formulae
9 Comments
Melanie Safka + Miley Cyrus
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
Import Data from a Picture to Excel
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 Android, Excel, import data from pictures, Windows
1 Comment
Wembley Tower 2
Following from the previous post, nearly all of the 68 designs for the Wembley Tower were in steel or iron, but there was just one with a truly unique design feature, it was to be built of concrete: If it … Continue reading
Newton Excel Bach, not (just) an Excel Blog 