duplicate poi checker ?

 

i am looking for a program that will check for duplicate Poi entries in my excell spread sheets (csv format)

--
marnoldi Nuvi 680 & Nuvi 2797LMT

POI Verifier

POI Verifier application by Retired Technician will check and give you "duplicate" coordinate entries in .csv files. And will show you them in a log file.

It is a shareware (minimal fee) and can be found at http://www.poiverifier.com/

--
MrKenFL- "Money can't buy you happiness .. But it does bring you a more pleasant form of misery." NUVI 260, Nuvi 1490LMT & Nuvi 2595LMT all with 2014.4 maps !

Macro for deleting duplicates

marnoldi wrote:

i am looking for a program that will check for duplicate Poi entries in my excell spread sheets (csv format)

In your Excel Spread sheet at the time you want to check for duplicates how many columns have data?

I can build a Macro for Excel that will find all duplicates and delete them. But I need to know how many columns of data you are checking at that time.

PS. Do you know how to create a Macro in EXCEL if I provide the script in text?

--
"Those that stop and smell the roses, must realize that once in awhile you may get a whiff of fertilizer."..copyright:HDHannah1986 -Mercedes GPS - UCONNECT 430N Chrysler T&C - Nuvi 2598- Nuni2555 - Nuvi855 - Nuvi295W - Nuvi 750 - Ique 3600

There is a program that is a

There is a program that is a add on to excel called ASAP Utilities that will find duplicates and color code them.Is does all kind of good things.There is a free and licensed version. See http://www.download.com/ASAP-Utilities/3640-2077_4-10781628....

--
Charlie. Nuvi 265 WT and Nuvi 2597 LMT. Android Here WeGo - Offline Maps & GPS.

Just curious

charlesd45 wrote:

There is a program that is a add on to excel called ASAP Utilities that will find duplicates and color code them.Is does all kind of good things.There is a free and licensed version. See http://www.download.com/ASAP-Utilities/3640-2077_4-10781628.html?hhTest=1&v=1&sb=1

Does ASAP also work with Microsoft Works ???????

--
MrKenFL- "Money can't buy you happiness .. But it does bring you a more pleasant form of misery." NUVI 260, Nuvi 1490LMT & Nuvi 2595LMT all with 2014.4 maps !

Specialized Macro

Please disregard the above post of mine.

My macro only works if the coordinates are identical.

I use this macro with the RR Xing data because the coordinate data "IS" identical on all duplicates in the Federal Railroad Admin Database.

--
"Those that stop and smell the roses, must realize that once in awhile you may get a whiff of fertilizer."..copyright:HDHannah1986 -Mercedes GPS - UCONNECT 430N Chrysler T&C - Nuvi 2598- Nuni2555 - Nuvi855 - Nuvi295W - Nuvi 750 - Ique 3600

Sort by distance with excel

You can use excel to calculate the approximate distance to a "home" point, then sorting by the distance you can easily find any duplicates.

The formula to calculate the approx distance would be:

=POWER(POWER(A2-$A$1,2)+POWER(B2-$B$1,2), 0.5)*101

This is not an exact distance, but is a very simple calculation to come pretty close to the real distance, the error will increase as the distance increases significantly.

Put the coordinates of your "home" location in the first row (A1 & B1) or hard code instead of the $A$1 and $B$1 in the formula, copy the formula to all rows in a new column, and then sort by that distance.

A macro could also be used to highlight POIs too close to each other.

UPDATE:

I just realized that this won't work, as you can have POIs in opposite directions that are at the same distance from the "home" (or reference) location, but deppending on the number and distribution of the POIs, this might help.

Oh well!

--
GARMIN nuvi 760 sites.google.com/site/lschwabe/

PoiEdit Will Find Duplicates by Distance You Choose

I've used this program to eliminate duplicate POIs in CSV files:
http://www.poiedit.com

You can specify the maximum distance used to determine if two POIs are duplicates.

--
DriveAssist 50 (stolen), Nüvi 2595LMT

Excel data sort function

marnoldi wrote:

i am looking for a program that will check for duplicate Poi entries in my excell spread sheets (csv format)

I your POI file is less than say 500 POIs do a sort of columns A, B, and C all in assending order then visually look for duplicates in the data. Just a suggestion. If bigger than 500 pois it depends on how much programing time is involved vs. visual inspeciton of the data with the above sort.

--
260, 295W, 1490T,2455LMT

I don't use Excel much anymore..

I have now been using a editor called "CSVed" it really is quite good and can do a lot of differnt things. Search on google for the site. I am not sure the web page at this time.

Give it a try.. I use this with POI Verify .. Its the only real tools I need!!

--
Bobkz - Garmin Nuvi 3597LMTHD/2455LMT/C530/C580- "Pain Is Fear Leaving The Body - Semper Fidelis"

asap

MrKenFL wrote:
charlesd45 wrote:

There is a program that is a add on to excel called ASAP Utilities that will find duplicates and color code them.Is does all kind of good things.There is a free and licensed version. See http://www.download.com/ASAP-Utilities/3640-2077_4-10781628.html?hhTest=1&v=1&sb=1

Does ASAP also work with Microsoft Works ???????

I found this on the faq.

ASAP Utilities 4.2 will run on all computers that meet the requirements of MS Office Excel 2000, 2002/XP, 2003 or 2007 and have MS Windows as operating system (including the new Vista). For people that still use Excel 97 there is a (very) old version available

--
Charlie. Nuvi 265 WT and Nuvi 2597 LMT. Android Here WeGo - Offline Maps & GPS.

Built into Excel 2007

charlesd45 wrote:

There is a program that is a add on to excel called ASAP Utilities that will find duplicates and color code them.Is does all kind of good things.There is a free and licensed version. See http://www.download.com/ASAP-Utilities/3640-2077_4-10781628.html?hhTest=1&v=1&sb=1

All,

Excel 2007 will do this for you. - no need to purchase ASAP or build a macro!

--
JRoz -- DriveSmart 55 & Traffic

asap

The SOFTWARE exists in two versions: an Unregistered Version and a Registered (paid) Version

You need to give it a try first.It does a lot of things plus shortcuts.

--
Charlie. Nuvi 265 WT and Nuvi 2597 LMT. Android Here WeGo - Offline Maps & GPS.

Just try ASAP

charlesd45 wrote:

You need to give it a try first.It does a lot of things plus shortcuts.

I totally agree with Charlesd45. If are you going to use Excel to edit Pois then you should load ASAP and see all of it benefits.

--
Garmin Nüvi 650, 255WT

asap

You don't have to put all them formulas in.It works great when going to a vendors web page to get all the locations that are more then one line with the info.A few clicks and all the data pulled to one line on excel without the formula.Can combine two columns of data very easy.Still learning all the ins and out of it.

--
Charlie. Nuvi 265 WT and Nuvi 2597 LMT. Android Here WeGo - Offline Maps & GPS.