Category Archives: Computing – general

CSpline and Malware

Posted on March 13, 2021 by dougaj4

I was recently informed that the Malwarebyte program was raising a warning for the CSpline2 download. On checking I found that the spreadsheet had a VBA module called frmPickwb which was not my code. The file has now been updated, … Continue reading →

Posted in Computing - general, Curve fitting, UDFs, VBA | Tagged , , | Leave a comment

Lambda and VBA

Posted on February 28, 2021 by dougaj4

The new Excel Lambda function (see here for more details and links) is currently only available to those signed up to the Beta Preview version of Excel 365, but is has been favourably reviewed by almost all of those who … Continue reading →

Posted in Computing - general, Excel, UDFs, VBA | Tagged , , , , | Leave a comment

Open Source FEA Code Links

Posted on October 25, 2020 by dougaj4

There have been many posts here based on code from the book Programming The Finite Element Method, with the Fortran code either translated to VBA, or with VBA links to compiled Fortran Code. I recently discovered: The “Programming the Finite … Continue reading →

Posted in Computing - general, Excel, Finite Element Analysis, Fortran, Frame Analysis, Link to Python | 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 , , , , , , | Leave a comment

Import Data from a Picture to Excel

Posted on September 16, 2020 by dougaj4

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