red light cameras

 

how do i install red light cameras just for the uk
for a garmin nuvi 350 ?

You would have to do a sort

You would have to do a sort in Excel and delete all the other POI from that file.

--
NickJr Nuvi 3597LMT

red light cameras

I thought the British were more civilized that that!!!

--
Alan-Garmin c340

About England

OMG! I am a displaced Brit living here in the States and let me tell you something. Speed cameras are EVERYWHERE! With the exception of residential streets there is hardly a road you can drive on without seeing one of them. But by law they are conveniently painted yellow so you can see them and slow down. It's a mad system but it seems to work.

--
"Life is a journey - enjoy the ride!" Garmin nuvi 255

Little Help Please................

I have the red light files open in Excel. I just want the red light locations for my area (there may be 50 locations or less). They are spread throughout 2671 rows. I have looked at the Excel Help files, but can't seem to get them to sort by row. Do you have to go through each row and highlight it? That would take six Sundays and a Monday to do that. What am I doing wrong? I don't need all these locations all over the USA.

--
Garmin 660

Excel help

One thing that you can do..is highlight the whole sheet and make sure under the cell properties and set them to 'text'. That way it's not a 'neagtive number etc and it will sort on what ever row you want to sort on?

Hope that helps??

--
It's those changes in latitudes, changes in attitudes nothing remains quite the same. With all of our running and all of our cunning, If we couldn't laugh, we would all go insane.

Sort

Sort by column D, then delete all the rows that are not in your state. If you want it tighter than that use the Autofilter to set Lat and Lon brackets. If you need more help, send me an email and I can walk you through it.

--
Tom

Excel Sorting

Make a backup copy (optional)
Click on col A
Hold the shift key and click on col D, all columns are now selected.
Click data and sort
Change to col D
Click OK, the file is now sorted by province/state
Save the file (optional)
Use the same click, shift, click on the rows and use delete to delete the unwanted rows
Save the file

Why do all that

CATraveler wrote:

Make a backup copy (optional)
Click on col A
Hold the shift key and click on col D, all columns are now selected.
Click data and sort
Change to col D
Click OK, the file is now sorted by province/state
Save the file (optional)
Use the same click, shift, click on the rows and use delete to delete the unwanted rows
Save the file

Just click in the top block of column D and hit sort. The spreadsheet is sorted.

--
Glenn - Southern MD; SP C330 / Nuvi 750 / Nuvi 265WT

Sorting

gpfoster wrote:
CATraveler wrote:

Make a backup copy (optional)
Click on col A
Hold the shift key and click on col D, all columns are now selected.
Click data and sort
Change to col D
Click OK, the file is now sorted by province/state
Save the file (optional)
Use the same click, shift, click on the rows and use delete to delete the unwanted rows
Save the file

Just click in the top block of column D and hit sort. The spreadsheet is sorted.

Well, OK but at least post that in the popup window leave the Expand Selection otherwise it will sort only Column D.

And if I had done that then I would have had to add more detail to the section on row selection.

Of course for those that know Excel no explanation is needed.

Row Delete

To actually remove the rows hit edit delete as the delete key just blanks the rows.