+ Reply to Thread
Results 1 to 10 of 10

UK Postcode Distance Calculator

  1. #1
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    17,691

    UK Postcode Distance Calculator

    I first put the attached file together some years ago, and I've mentioned it on one post here soon after I joined and have had a few PMs asking for a copy, so I thought I might as well submit it here.

    The file works out the distance in miles between 2 UK postcodes. On the Single sheet you can enter the two postcodes in B3 and B4 (just up to the first space), and on the Multiple sheet you can enter several postcodes on different rows in columns A and B, where, for example, you might have one central location and need to know the distances to travel from other locations.

    The file uses a lookup table containing lattitudes and longitudes, and calculates the straight-line distance between the "nominal" centre of each postcode.

    Hope this is of use to some of you.

    Pete
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-08-2012
    Location
    Aurangabad, Maharashtra
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: UK Postcode Distance Calculator

    Good, But show more typical things like drop down list.

  3. #3
    Registered User
    Join Date
    02-14-2012
    Location
    Newcastle, England
    MS-Off Ver
    Excel 2010
    Posts
    90

    Re: UK Postcode Distance Calculator

    Hey this is prety handy, good work Pete.
    Could you get it to work with the second half of the postcode?

    Cheers
    Carl

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    17,691

    Re: UK Postcode Distance Calculator

    Hi Carl,

    yes, it could be adapted to the full postcode - do you have a complete list of them?

    Pete

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,067

    Re: UK Postcode Distance Calculator

    I do, but it might be a bit exhaustive - there are over 1.6m of them - I've got the lat/lng for them too - dunno if it's of any use though!!

    OS publish a free version of them with eastings and northings if you need them, it's a bit of a pain to convert them all into lat lon, but it's doable - I've got a SQL script that does it if you need, pretty accurate too from my testing

  6. #6
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    17,691

    Re: UK Postcode Distance Calculator

    Hi Kyle,

    I knew there was over a million of them, and I suppose new ones are added quite often (as new houses/office developments are built). I'm not sure how you could attach a file that large to the Forum.

    Pete

  7. #7
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,067

    Re: UK Postcode Distance Calculator

    It's one of the reasons I use a web service for distance calculations in Excel, they also go by road distance rather than as the crow flies

  8. #8
    Registered User
    Join Date
    01-08-2014
    Location
    liverpool
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: UK Postcode Distance Calculator

    Quote Originally Posted by Pete_UK View Post
    I first put the attached file together some years ago, and I've mentioned it on one post here soon after I joined and have had a few PMs asking for a copy, so I thought I might as well submit it here.

    The file works out the distance in miles between 2 UK postcodes. On the Single sheet you can enter the two postcodes in B3 and B4 (just up to the first space), and on the Multiple sheet you can enter several postcodes on different rows in columns A and B, where, for example, you might have one central location and need to know the distances to travel from other locations.

    The file uses a lookup table containing lattitudes and longitudes, and calculates the straight-line distance between the "nominal" centre of each postcode.

    Hope this is of use to some of you.

    Pete


    Thank you for the share, great job! I am trying to figure out a way where if you enter a post code and a distance it will tell you the surrounding postcodes. Do you have any ideas on how to do this?

    Thanks in advance

  9. #9
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    17,691

    Re: UK Postcode Distance Calculator

    I think you would need to examine every postcode in the list (there are 2,800+ of them) and determine the distance to see if that is within range, and then report that. I think it would be a bit sluggish, so maybe there are other algorithms that would speed things up (like omitting the distance calculation if the lat or long or obviously out of range from the source postcode).

    Pete

  10. #10
    Registered User
    Join Date
    10-26-2016
    Location
    London
    MS-Off Ver
    Office 2016
    Posts
    1

    Re: UK Postcode Distance Calculator

    Check the distance between any cities in England on a map of the world.

    This calculator will calculate the distance - http://distancecalculation.info/
    between the cities on a map of the world will always help anyone
    who wants to know the exact distance between the cities and countries of the world.
    Name:  road_home.jpg
Views: 7186
Size:  25.9 KB
    The calculation of the distance on the map of the world is possible!
    In a straight line - as if you were flying in an airplane.
    On the roads - always choose the most optimal route by road.
    Walking - the calculation of distance is carried out on public roads with a speed of 5km / h.
    Cycling - the distance calculation is carried out on public roads with a speed of 20km / h.

    Our calculator can calculate a route only on free roads
    then you do not have to pay for travel on the roads, as is well known in Europe
    almost all toll roads, but there are free - this route will only
    toll-free roads and you will save money

    Our calculation distance calculator will give you additional information: approximate travel time, price and quantity of fuel
    you potramite on this route, distance killometrah.

    You can also create a complex route which will pass through only those cities that you need
    You can add up to 10 intermediate cities and your route will be built through them.

    Our distance calculator for calculating have additional fields where you will be able to
    indicate how many liters of fuel your vehicle consumes on a 100km path, and specify the cost of fuel per 1 liter.

    On the map of the world will show you a detailed route where it will be able to consider in detail, also
    a geographical map of the route you will receive detailed instructions where you need to go by car and where you have to rotate the pointers to all traffic signs.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1