The routines are supplied in an addin.\u00a0 An examples workbook is also supplied which demonstrates the use of all the functions and also includes routines to install, remove or check the status of the addin.<\/p>\n
For versions of Windows Excel 2007 or later<\/strong> <\/span>or for MAC Excel 2016\/2019 please use these.<\/p>\n These files have been updated May 2025 – see additional details here…<\/a><\/p>\n For early versions of Excel 1997~2003<\/strong><\/span> which do not include the \u2018ribbon\u2019 interface you will need the deprecated code first published in 2012. These files have not been updated to use the Helmert transformation<\/p>\n Download the two relevant files.<\/p>\n You will need to run the example workbook, allow macros, allow it to install the addin, accept the licence conditions, then self-edit all the functions in the workbook.\u00a0 For MAC, further steps, including a simple manual one is required.<\/p>\n Once installed, the addin will subsequently be available automatically to all workbooks.<\/p>\n Full examples are given in the examples workbook.<\/p>\n The ribbon versions have been developed under Windows\/Excel 2016 and MAC Excel 2016 and 2019.\u00a0\u00a0 The deprecated routines were developed under Excel 2003 and have been tested with (Windows) Excel 2007, Excel 2010 and Excel 2016 though the ribbon version is recommended.<\/p>\n Accuracy of these routines is to a couple of metres – well within that of a consumer quality GPS, even without selective availability, well within one\u2019s ability to read a 1:25000 map, and\u00a0within the limits of stability of paper maps.<\/p>\n The routines have been used by a borough in Kent for plotting their drains, have been used for microlight championships, are recommended by the British Atmospheric Data Centre, have been used by those involved in coordinating rescue services, for weather studies on Arran, butterfly studies in North Wales,\u00a0bird migration, tracking basking sharks off Western Scotland, in London bio-conservation projects and managing features on the national electricity grid!\u00a0\u00a0 I use them for plotting walks with both Garmin Basecamp and Google Earth.\u00a0 I have also received an unsolicited email from Ordnance Survey describing earlier versions of this code as a fine piece of work.<\/p>\n The routines are provided \u2018as is\u2019 with no warranty.\u00a0 They are free for personal non-commercial use.<\/p>\n The latitude\/longitude to OS reference conversion routines use the algorithms published by a former colleague at Swansea University, the late Dr Derek Maling, though I must claim credit for any errors in implementation.<\/p>\n I am greatly indebted to Ian Baines for his considerable help, perseverance and encouragement in porting OSGB and developing the additional necessary code for MAC.\u00a0 Without his help (and his computers!) it would not have been possible.<\/p>\n","protected":false},"excerpt":{"rendered":" Routines for Microsoft Excel \u2122 are available which will perform a number of functions including: Import data from a gpx file. \u00a0These files are now the standard interchange mechanism for waypoints, routes and tracks for gps devices. Compact gpx data by removing duplicated or redundant points.\u00a0 Huge savings are possible without significant loss of detail. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":80,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-55","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.haroldstreet.org.uk\/osgb\/wp-json\/wp\/v2\/pages\/55","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.haroldstreet.org.uk\/osgb\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.haroldstreet.org.uk\/osgb\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.haroldstreet.org.uk\/osgb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.haroldstreet.org.uk\/osgb\/wp-json\/wp\/v2\/comments?post=55"}],"version-history":[{"count":50,"href":"https:\/\/www.haroldstreet.org.uk\/osgb\/wp-json\/wp\/v2\/pages\/55\/revisions"}],"predecessor-version":[{"id":346,"href":"https:\/\/www.haroldstreet.org.uk\/osgb\/wp-json\/wp\/v2\/pages\/55\/revisions\/346"}],"wp:attachment":[{"href":"https:\/\/www.haroldstreet.org.uk\/osgb\/wp-json\/wp\/v2\/media?parent=55"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Download](\"\/osgb\/wp-content\/uploads\/2012\/01\/excel_addin_icon.gif\"){kind=icon}
<\/a> – osgb.xlam<\/a><\/strong> \u2013 the addin which holds the basic code\u00a0 and \u2026<\/p>\n![\"Download](\"\/osgb\/wp-content\/uploads\/2012\/01\/excel_icon.gif\"){kind=icon}
<\/a> – osgbExamples.xlsm<\/strong><\/a> which has examples and includes an installer.<\/p>\n
\n<\/a> – the addin\u00a0osgb.xla<\/a><\/strong>\u00a0which holds the code and…<\/p>\n<\/a> – the example workbook OSGBExamples.xls<\/a><\/strong>\u00a0which includes an installer for the addin.<\/p>\n