HomeMicrosoft


Booking.com Latitude, Longitude Converter for AR or S&T
werdnanostaw
Booking.com displays lats and lons in degrees, decimal minutes format with N or S and E or W and degrees symbols.

Autoroute and Streets and Trips accept lats and lons in decimal degrees (plus other formats).

Booking.com displays a leading zero on the northing but not on the easting.

These formulas take account of these features and generate lats and lons in decimal degrees format so they can be copied and pasted into AR or S&T.

Warning 1: Booking.com, as far as I am aware, does not display lats and lons on web page for hotel. When booking is complete the Confirmation shows the lats and lons. You should print this to a PDF for future reference.

Warning 2: Do not use Microsoft Print to PDF. This produces "image" PDFs that you cannot copy lat lons out of. Use Save as PDF because this produces a "text" PDF that you can copy out of.

Use the following formulas in Excel or similar spreadsheet.

Tip: If you want to display formulas instead of results press CTRL+`

These formulas are based on lat lon copied from PDF being pasted into A9.

Section below shows cell addresses and formulas.

A8: Make sure you include leading N or S character
A9: N 044 31.392, E 11 22.436
A10: =LEFT(A9,1)
A11:
A12: =MID(A9,3,3)
A13: =MID(A9,8,6)
A14: =A13/60
A15: =IF(A10="N",1,-1)
A16: =A15*(A12+A14)

B10: =MID(A9,16,1)
B11: =FIND("",A9,FIND("",A9)+1)
B12: =MID(A9,B11-3,3)
B13: =RIGHT(A9,6)
B14: =B13/60
B15: =IF(B10="E",1,-1)
B16: =B15*(B12+B14)

C10: Extract NSEW
C11: Find second degree symbol to take account of 2 or 3 digit E degrees
C12: Extract degrees
C13: Extract decimal minutes
C14: Convert decimal minutes to decimal degrees
C15: Make negative for S or W
C16: Calculate positive or negative decimal degrees

Section below just shows formulas for copying and pasting into Excel.

=LEFT(A9,1)

=MID(A9,3,3)
=MID(A9,8,6)
=A13/60
=IF(A10="N",1,-1)
=A15*(A12+A14)

=MID(A9,16,1)
=FIND("",A9,FIND("",A9)+1)
=MID(A9,B11-3,3)
=RIGHT(A9,6)
=B13/60
=IF(B10="E",1,-1)
=B15*(B12+B14)

Extract NSEW
Find second degree symbol to take account of 2 or 3 digit E degrees
Extract degrees
Extract decimal minutes
Convert decimal minutes to decimal degrees
Make negative for S or W
Calculate positive or negative decimal degrees

This section shows results.

N 044 31.392, E 11 22.436
N

044
31.392
0.5232
1
44.5232

E
20
11
22.436
0.373933333
1
11.37393333
werdnanostaw
Warning 3: Do not trust street address given by Booking.com as it is sometimes (many times in recent 8 week holiday in Italy) wrong.

As far as I am aware the built-in satnav in our lease Citroen C3 Aircross did not have any way of entering lat lons. You had to use street address and it produced many way off the mark destinations.

The lat lons were usually correct but sometimes they gave coords of house but entry was off another street.

In another case hotel had 2 entries; one was off main street while the other was in maze of tiny streets in centro storico. Guess which one they gave the coords for? Fortunately, there was a religious parade in centre of town and I had to walk in. If I had driven in it would have been a disaster.

Speaking of disasters, we did have one. It was in Gangi in Sicily.

http://www.sicily.co.uk/nearby_town/gangi/

Try and imagine what it's like driving in this:

https://www.google.com.au/maps/place/90024+Gangi+Province+of+Palermo,+Italy/@37.7958274,14...7966504!4d14.2059064

The owner contacted us by Whatsapp and he gave us an address different from the hotel where we should park and then contact him and he would take us to hotel.

While we driving to parking spot there was a three way street split and I didn't see the third street. I took the wrong street. The street got narrower. We pulled in the mirrors.

On a downgrade I drove onto a front door step and dropped off the other side leaving one of the front wheels spinning in the air.

Traffic started to build up behind me. Onlookers got everyone to back out and stopped any further traffic coming up the street.

A policeman arrived. He got half a dozen of the young onlookers to lift the car, drag it off the step and drop it onto the ground.

Then the policeman directed me how to go left or right as I drove down the street back to a (slightly) wider street.

The rocker panel was crushed. The trim around the wheel arch popped. The wheel rubbed against the wheel well plastic whenever I turned. The next day I found some wire and pulled the wheel well plastic out of the way.

If this had been a rental car this is underbody damage that isn't covered by their "insurance".

However, it was a lease car which means it was covered for all eventualities. When I returned it in Milano the Citroen rep looked at the damage and shrugged.
werdnanostaw
Here are photos of disaster.
Attached Images
181222-164929-sat-gangi.jpg   181222-165434-sat-gangi.jpg   181222-165535-sat-gangi.jpg   181222-165546-sat-gangi.jpg  
werdnanostaw
The first photo of car wheel is the damaged side. The second photo is the undamaged other side so you can see the difference.
Attached Images
181223-080019-sun-gangi-view-b-b.jpg   181223-084237-sun-gangi-street-outside-b-b.jpg   181223-091403-sun-gangi.jpg   181223-091418-sun-gangi.jpg  
Marvin Hlavac
Wow, Andrew, the "street" seems way too narrow for even the smallest of cars!
Ken in Regina
Quote:
Originally Posted by werdnanostaw
...

Warning 2: Do not use Microsoft Print to PDF. This produces "image" PDFs that you cannot copy lat lons out of. Use Save as PDF because this produces a "text" PDF that you can copy out of.

...
Thank you, Thank you! I've been trying to figure a way around that image PDF problem forever.

...ken...
laptopgpsworld.com About