Speed Camera loading for Dummies
 |
  15 years
|
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.
thanks again guys
thanks again guys
A GPS can take you where You want to go but never where you WANT to be.
Missing data
I've dug into the formulas for adding 5 miles to the speed camera value - problem is once that is done the Garmin does not display what the speed camera was set at and the location information of the speed camera. I've noticed on the most recent speed camera update that they have moved the "@45" (alert speed) to the end of the file, which is good. But I'm unable to find and Excel formula that will take the speed camera setting and add 5 mph. Example:
Column c: R/Speed 45 - Broadway & Stapley @45
means: red light/speed camera in a 45mph zone ("R/Speed 45"), and GPS will alert if speed above 45 ("@45").
What would an Excel formula be to increase the alert speed 5mph ("@50") keeping the @50 at the end of the field? Thanks in advance...
Whose formula are you using? If it's the one orignally posred by Felix Krull a couple of year back it needs some help with the new speed camera file layout.
You need to do some operations first.
1. Open the file in Excel and do a CTL H search and replace to locate all the ?? and replace them with a value. I use ~?? in the search and 20 in the replace box. You need the ~ before the question marks as the ? is a special term and the tilde tells Excel you want the character not the replacement value.
2. Insert a column between Columns B & C. Enter the following formula in C1 =if(iserr(find("@",d1,1)),d1,left(d1,find("@",d1,1)-1) This formula will copy either the entire string in D1 or will copy the value of D1 up to the @ symbol into C1. Copy the formula in C1 and paste it into the remaining cells until you reach the last record.
3. Highlight Column C, copy the contents of the column and then do a Paste Special, Value over the top of the copied cells. This replaces the formula with its value.
4. Insert Felix's formula in D1, copy it and paste it in the remaining cells of that column. The speed value in Column C will be increased by 5 and the @ symbol inserted. Repeat step 3 except now for Column D.
5. Delete Column C and then load the file.
Entries with "??" don't contain a @ value at the end of the string. So Felix's formula won't work. Can you help with a formula that preserves the ?? while adding a @ value at the end (say 5 miles an hour)?
Garmin Drive Smart 61 NA LMT-S
read my response
You need to do some operations first.
1. Open the file in Excel and do a CTL H search and replace to locate all the ?? and replace them with a value. I use ~?? in the search and 20 in the replace box. You need the ~ before the question marks as the ? is a special term and the tilde tells Excel you want the character not the replacement value.
Entries with "??" don't contain a @ value at the end of the string. So Felix's formula won't work. Can you help with a formula that preserves the ?? while adding a @ value at the end (say 5 miles an hour)?
See 1 above
Illiterate? Write for free help.
benefitses,
Yes, but there is a benefit to having the "??" displayed on your Garmin alert. What I'd like to do is find the formula to read the "??" and insert "@" with a speed of my choosing at the end of the string. Any help?
Garmin Drive Smart 61 NA LMT-S
Hi everyone, I'm a newbie
Hi everyone, I'm a newbie and I'm excited to see what you did to get more out of your GPS.
Hope I can make some contribution in the near future.
Thanks,
try this
Yes, but there is a benefit to having the "??" displayed on your Garmin alert. What I'd like to do is find the formula to read the "??" and insert "@" with a speed of my choosing at the end of the string. Any help?
=if(iserr(find("??",c1,1)),c1,c1&" @") insert the value you want between the @ and ".
Illiterate? Write for free help.
Works
Box Car - works perfectly! On a curiosity note, what would the command be had there been a one or one digit number where the "??" was and then want to only add "@" (at the end of the string) with a designated addition to the numbers?
Garmin Drive Smart 61 NA LMT-S
ramcruzer
Ramcruzer, you do good work
I may have my user name and password confused or switched! Can I get confimation of my user name????
Huh?
Box Car - works perfectly! On a curiosity note, what would the command be had there been a one or one digit number where the "??" was and then want to only add "@" (at the end of the string) with a designated addition to the numbers?
I don't understand what you are asking. If you want to manipulate the file further, I suggest you spend some time learning how to use Excel and its functions. Get a good book on Excel, do some reading and then experiment. The source files aren't set up the way you want to play with them and any change to the file would involve rewriting the commands to match the changes. They work just fine the way they are for me and everyone else on the board. It's either that, or we have learned to accept the files the way they are with all their limitations.
Illiterate? Write for free help.
Upload newest POI (red light - speed camera)
Hi
I’m new at that and I was wondering if I upload the newest files of POI Red light / speed camera (ex: 08/01/2012 update) will it make duplicates or just add the new locations?
I already have the file install on my gps
Thank you in advance
Thierry
T Corbeil
Replace
Hi
I’m new at that and I was wondering if I upload the newest files of POI Red light / speed camera (ex: 08/01/2012 update) will it make duplicates or just add the new locations?
I already have the file install on my gps
Thank you in advance
Thierry
If the file has the same name as the one before, and you load it via POILoader, it will replace the locations.
NUVI40 Kingsport TN
It depends, and welcome
Welcome to the site.
Since you are new, you may want to do a couple of the Beginner Exercises.
To make it easy, when you click on the first link below, hold down the "Cntl" key as you left-click. That will open a new "Tab" in your browser in the "Tab" bar. Click on that 'Tab" to do the first exercise - leaving the "Tab" you are now reading open and available to click on and return here.
The first link makes sure settings on your computer are such that you can do more advanced POI loading.
http://www.poi-factory.com/node/30393
This next link helps you get a backup by attaching your GPS to your computer. (NEVER do anything to your GPS until you have a backup)
http://www.poi-factory.com/node/30394
The reason why you might have two (or more) camera files is that POI loader gives you a choice as to what name the .gpi file you are about to create is named. POI Loader defaults to the name of the Folder to which you have just pointed it.
Let's say you are loading only the camera files and let's also say that you have them in a Folder called MyCameraFiles (or some such). If you let POI Loader default to the Folder name, then POI Loader will replace the previous file of that name. If you were to give it another name than the folder (which you can do if you please) and the previous time you let it use the Folder name, then you will have two sets of camera files.
If you had previously loaded the camera files as part of a group of several other POI files, then unless you have deleted that previously loaded .gpi file (of which the cameras were only one of several files), then you will indeed have duplicates.
speed
Good show Ramcruzer
I may have my user name and password confused or switched! Can I get confimation of my user name????
Thanks
Thank you David King and jgermann, your advices are appreciate
Will try that
Thierry
T Corbeil
yes and -
Good show Ramcruzer
-Amen!
nightrider --Nuvi's 660 & 680--
thanks for this
thanks for this
A GPS can take you where You want to go but never where you WANT to be.