POI for Dummies

source: POI Factory

Speed Camera loading for Dummies

Tue, 12/09/2008 - 3:55pm

ramcruzer

How many would like to know how to set speed alerts to only alert if you are going to fast!!!!
Well I have searched on this site and read all the threads and even the help section in the poi loader and it was not clear to me on how this works. I have been watching and reading all this stuff and I see there are a lot of us that can’t understand a lot of this lingo.
So I started to play with all the info from this site and my GPS and have figured it out,, some of you might already know this, but it is hard to ask a question on how to do this stuff on these web sites (it’s easier to talk on the phone or in person to get information).
So here it is as per my findings on how to set the speed alerts to only alert you if you are going faster than the posted speed.
1rst you need to go into the speed camera cvs file and add the @ sign before the speed in all the line (this is on the threads here and in the help section on the poi loader), this will take some time but it is worth it. I only did this for my state at this time.
Example: speed camera @65mph
By doing this it will also turn the grey bar to red and won’t stop alerting till you slow down.
Next on the same file increase the speed by 7 to 10 mph I have mine set at 10mph above the posted speed. (AZ cameras will flash at 11mph over).
Example: 65 + 8 =73mph
Speed camera @73 mph
What this will do is alert you only if the difference is greater than 7 mph. So you can cruise at 65 to 66 mph with out an alert just the icon will appear.
Now when you load this file after you made all the changes go into the poi loader and when you come to speed camera file select the distance at the bottom and enter 0 not the 1985 change to 0.
I hope this will make it easier to understand on how this file will work. I was getting tiered of every mile and a half of beep, beep, beep, caution approaching speed camera.
AZ has or will have over a 100 + speed cameras and I drive all over the valley and it gets annoying at times to have the alert always sounding. Now I set the cruise control and I still see the Icon but no beeping unless I am going to fast then it lets me know.

‹ Chicago area red light cameras San Diego redlight camera's multipying? ›

4-Garmin Nuvi 760>>>> Owner: Sunrise Mechanical A/C & Heating,, Peoria, Arizona


SNIP

SNIP

Tue, 12/16/2008 - 9:00pm
Felix Krull's picture

Felix Krull
general maintainerpoi contributoractive user
An Excel formula to automate changing the camera data

I've worked up an Excel formula that will insert the @ sign in the right place and let you specify an adjustment value to the speed limit as ramcruzer described in his original post. I've also written up a few steps to help you use it in the red light camera file. Hopefully, it won't be too hard to follow, even if you don't use Excel very often.

What it does: If a camera description contains the characters "MPH", the "@" sign will be inserted in front of the speed limit, the speed limit will have 5 mph added to it, and the result placed in a new cell. (Step 4 tells you how to use a different value than 5 mph if you want to change it. If you're OK with 5 mph, you can skip step 4.) If there is no "MPH" in the description, the contents will be copied unchanged to a new cell. The steps below assume as an example that there are 100 rows of speed camera data in the spreadsheet.

1. Open Speed-Cameras.csv
2. Insert a column between columns C and D. This should become the new, blank column D.
3. Copy the formula below and paste it into cell D1.
4. Look in the formula for the characters "&RIGHT". Immediately to the left of that is "+5". This part of the formula adds 5 mph to whatever the speed limit value is. If you want to use a different adjustment, change it here. (In other words, use "+7" for a 7 mph adjustment, "+0" for no adjustment, etc.).
5. Copy the formula in D1 and paste it into the remaining cells in column D that have data in the corresponding cell in column C. In other words, if there are 100 cameras in the file, copy D1 and paste it into cells D2-D100.
6. Next select all the non-blank cells in column D (D1-D100). Copy the selection. Leave the cells selected; don't click anywhere else on the spreadsheet until you do the next step.
7. On Excel's "Edit" menu, click "Paste Special". In the dialog box that comes up, choose the "Values" button and click "OK".
8. Delete Column C. Your new data will now become Column C.
9. Save the file as a CSV.

Here's the formula. Make sure you copy and paste it with no changes, spaces or line breaks. It should be one long line wherever it appears in your spreadsheet.

=IF(ISERR(FIND("MPH",C1)),C1,(LEFT(C1,FIND("MPH",C1)-4)&"@"&MID(C1,(FIND("MPH",C1))-3,2)+5&RIGHT(C1,LEN(C1)-FIND("MPH",C1)+2)))

I wrote this in Excel 2003 but it should work in Excel 2002 ("Office XP") and up. I hope you find it useful.