Tag Archives: Excel

GeodesiX

Posted on 19/04/2013 by dougaj4

Another link from Alfred Vachris: GeodesiX is is an addin for Microsoft Excel which allows you to display maps, perform forward and reverse geocoding, compute distances (Great Circle, driving, bicycling and walking) and verify your results in Google Maps, all within … Continue reading →

Posted in Computing - general, Excel | Tagged , , | 2 Comments

Section properties for groups of defined shapes

Posted on 12/04/2013 by dougaj4

Following a discussion at Eng-Tips, I have modified the section properties spreadsheet (presented here) so that section properties can be found for groups of defined shapes, including provision for translation and rotation of each shape, and application of different E … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , | 13 Comments

3DFrame Ver 1.03 and Frame4 Ver 3.07

Posted on 17/03/2013 by dougaj4

Updated versions of my 2D and 3D frame analysis spreadsheets are now available for download from: 3DFrame.zip Frame4.zip The download files include full open-source VBA code, and dll files for compiled solvers for much better performance with large models. See https://newtonexcelbach.wordpress.com/2012/11/16/frame4-now-with-added-alglib/ for … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, VBA | Tagged , , , | 34 Comments

Tanh-Sinh Quadrature V4.1

Posted on 16/03/2013 by dougaj4

The latest update to the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes is now available for download from: Tanh-Sinh. As usual, the download includes full open-source code and extensive documentation. Version 4.1 Release Notes  1.   Small but useful accuracy improvements have been … Continue reading →

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , | 1 Comment

Clearing excess formats

Posted on 16/03/2013 by dougaj4

I have recently been getting messages about “too many different cell formats”, particularly when saving  a 2007/10 format file as Excel 97-2003 format.  Some searching revealed that the source of the problem was a bug that caused unused styles to be copied when … Continue reading →

Posted in Excel | Tagged , , | 6 Comments