Excel distance calculator

Potential lists to add to the existing array

Excel distance calculator

Postby John Kirk » Wed Mar 15, 2006 5:46 pm

I'm glad you mentioned this Layne. It will save me tons of time finding the closest higher ranked peaks based on their coords. I can use a min() function on the distance of all higher peaks to return the proximate parent and distance from now on. For anyone wanting to implement distance based on coordinates in excel, I've attached a file. You can batch calculate by copying the formula in column F down and pasting coords into columns A->D.
Attachments
DISTANCE.xls
(16 KiB) Downloaded 330 times
User avatar
John Kirk
LoJ Architect
 
Posts: 1605
Joined: Sun Jan 02, 2005 1:04 am
Location: Lakewood, CO

Return to Lists in the Works

Who is online

Users browsing this forum: No registered users and 18 guests