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.

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.

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

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

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.