POI Maker

vince59it · #1 02-28-2010, 05:14 PM

see what the problem is?

I tried sevaral ways. Succedeed in dividing data form one column in three separate columns, but now I have the problem with the lat and long digits

KiwiJochen · #2 02-28-2010, 09:27 PM

Quote:

Originally Posted by vince59it

see what the problem is?

I tried sevaral ways. Succedeed in dividing data form one column in three separate columns, but now I have the problem with the lat and long digits

Looks fine to me. Just correct the formatting of the lat / long from text to decimal notation

vince59it · #3 03-06-2010, 06:41 AM

Well, taking advantage from the bad weather in Roma I did not go sailing but stayed in front of the fireplace...messing up with the excel POI maker.
Great work by Kiwi. I studied the macro and learned a lot.
I only have one question so far. The heading of the file is always "Gphi" even if I select HIGH. Nevertheless I modified the macro to have "Glambda". I guess it is not a critical item, but it is just to understand why it does not work...soon I will test the output files and post the results.

KiwiJochen · #4 03-06-2010, 05:07 PM

Quote:

Originally Posted by vince59it

The heading of the file is always "Gphi" even if I select HIGH. Nevertheless I modified the macro to have "Glambda". I guess it is not a critical item, but it is just to understand why it does not work...

Because I do not understand the difference between phi and lambda

vince59it · #5 03-07-2010, 01:30 PM

Quote:

Originally Posted by KiwiJochen

Because I do not understand the difference between phi and lambda

I believe there is no real difference, they are actually two letters from greek alphabet, maybe just different identification.
BTW I made my own POI files with your excel wsheet and I will try them as soon as possible. If everything is ok I will post a step-by-step guide to explain how to easily (I hope) get lat,long and name to put into wsheet.

KiwiJochen · #6 03-07-2010, 03:01 PM

Quote:

Originally Posted by vince59it

I will post a step-by-step guide to explain how to easily (I hope) get lat,long and name to put into wsheet.

That I can do
Lat,Long:
1. Copy lat/long from Google Earth
2. Paste into worksheet

Name:
1. Write name in worksheet

Done!
:-)

vince59it · #7 03-07-2010, 04:47 PM

Quote:

Originally Posted by KiwiJochen

That I can do
Lat,Long:
1. Copy lat/long from Google Earth
2. Paste into worksheet

Name:
1. Write name in worksheet

Done!
:-)

My friend. I didn't mean this. I mean take data (for more than 12.000 POIs) from .asc file and put them in the correct value into worskheet...