how to set up an excel spreadsheet for speed alert

 

example:
column A column B column C
-79.8111 36.071 University of North Carolina - Greensboro

column D
School Zone@25

name the folder say "university" and save it on your computer to a new folder that you name say: POI

download a favorite .bmp symbol and call also "university" save it in POI

download a mp3 sound you like and save it in POI

use the poi downloader from garmin and dowload to your SD card location (say drive - J) from a file you named POI on your computer. in a few seconds all your favorite poi locations are downloaded

--
marnoldi Nuvi 680 & Nuvi 2797LMT

.

Are you sure this works?

I thought the @25 had to be in Column C for the speed alert.

also curious about the title

also curious about the title and alert being in column d. Reading thread http://www.poi-factory.com/node/2983 by retiredtechnician is does not say aything about using column d .

--
Charlie. Nuvi 265 WT and Nuvi 2597 LMT. MapFactor - Offline Maps & GPS.

Speed Alert in col C

Motorcycle Mama wrote:

Are you sure this works?

I thought the @25 had to be in Column C for the speed alert.

I believe Motorcycle Mama is correct. D is used for comments or addresses. If a file name contains a valid speed number or if all records in a file have speed encoded in the name, then all records in the file will include speed and proximity alerts. For example, a data file with the file name "Speed_30" generates speed alerts of 30 mph (or kph, depending on the type of units selected in POI Loader) for each POI in the file.

If the file name contains "redlight", POI Loader assumes all records in the file have proximity alerts with a distance of 400m/0.25 miles.

If a file contains "GATSO", "mobile", "SPECS", "safety", "speed", or "camera", but does not have a speed, POI Loader uses a default alert speed of 0, which means you will always be alerted. You can override this default value by entering the speed in Manual mode.

You can also enter speeds for each POI individually by adding the @ symbol and a number after the name of the POI in col C. For example, a Custom POI named "Ahsumview@25" would create a POI named "Ahsumview" with a 25 mph speed alert.

POI Loader calculates proximity alert distance based on speed. You can enter proximity alert distance for individual Custom POIs in a .gpx file. You can also enter proximity alert distance for all Custom POIs in a data file using Manual mode.

Hope you understand all this.

--
Larry - Nuvi 680, Nuvi 1690, Nuvi 2797LMT

F.A.Q.

--
------------------------ Phil Hornby, Stockport, England ----------------------               http://GeePeeEx.com - Garmin POI Creation made easy           »      

speed alert

i tested my spreadsheet with column D using a simulation mode and it worked great. then i drove by the nearest school and it DID NOT WORK
sorry - i misguided anyone

oh well back to the drawingborad

--
marnoldi Nuvi 680 & Nuvi 2797LMT