Category Archives: Computing – general

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.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

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

Building dances to an earthquake’s beat

Posted on May 28, 2020 by dougaj4

Adam Pascale from the Seismology Research Centre recently shared this animation (click on controls bottom right for High Quality and Full Screen views): … it’s from a building in the Philippines about 130km (hypocentral distance) from a magnitude 6.1 earthquake … Continue reading →

Posted in Animation, Computing - general, Newton | Tagged , | Leave a comment

Stepping through Python code called from Excel

Posted on March 31, 2020 by dougaj4

Setting up your editor to allow Python code debugging for functions called from Excel can be tricky, depending on the details of your editor and linking software, but using the Visual Studio Code Editor and Pyxll, this works for me: … Continue reading →

Posted in Computing - general, Excel, Link to Python, PyXLL, UDFs | Tagged , , , , | 4 Comments