Excel Mystery
Submitted: Tuesday, Jan 30, 2007 at 17:03
ThreadID:
41791
Views:
2790
Replies:
6
FollowUps:
14
This Thread has been Archived
Member - Doug T (W.A)
Is there anyone out there that knows a lot about Office Excel , I don't , What I need to find out is how do they format the POI .csv files to set in motion the warning in the GPS,Now I have a school file I downloaded and it gives a warningfrom the point ie thats 800m it covers, I also downloaded a Low
bridge csv file and gives no warning , I can make the Garming .gpx file have a proximity but I can't find how to do a .csv , Anyone want some POIs i have been playing around with some Supercheap Auto, Schools, and added some locations , you can add your own area schools in your own downloaded file , add info to it up the top bar , do it exactly as the others are and they work fine ,
Doug
Reply By: Member - Andrew (QLD) - Tuesday, Jan 30, 2007 at 18:43
Tuesday, Jan 30, 2007 at 18:43
Doug,
Have a look at this great website ==> Site Link for info on how to do it.
An easy way is to name the file RedLight.csv or even Redlight1.csv which will produce a proximity alert on all locations in that file. The csv file is fairly simple with the following format:
Longitude, Latitude, Description, Comments
eg.
151.030263, -33.931976, "SuperCheap Auto BANKSTOWN Unit 15
Home Central 49 Chapel Road NSW (02) 9709 6500"
comments are optional BTW.
Hope this helps.
Andrew
AnswerID:
218662
Follow Up By: Member - Doug T (W.A) - Tuesday, Jan 30, 2007 at 18:59
Tuesday, Jan 30, 2007 at 18:59
Andrew
Thanks mate, I will try that later, what I have found out is that if I name a file Andrew_1 it will give it a 400m prox' but 1kph speed limit Andrew_40 makes it 400m and 40kph, Now I tried the
bridge heights speed limit is not an issue , unless it's gonna hit ..lol but I found I can name the entry like this
"Under Roe Hwy 5.4m@60" will give it a 600m proximity
Doug
FollowupID:
479088
Follow Up By: Member - Doug T (W.A) - Tuesday, Jan 30, 2007 at 19:15
Tuesday, Jan 30, 2007 at 19:15
Andrew
Thanks for that , I am now starting to understand how this works, Still don't know why the name "Redlight" sets of an alarm but that link is really helpful, I will add to my GPS and maps web pages, The main page where you found it I already had a shortcut to it , thats the trouble , i got so much stuff here .
Doug
FollowupID:
479093