Solved

Excel model to find distance from XY points to a cirle

Posted on 2013-06-18
4
512 Views
Last Modified: 2013-06-18
I need an Excel model / functions to calculate distance from a number of points to a given circle.

I have a circle with a center xy and a given radius.
I have a list of points.
I need to know the closest distance from each point to the circle

Distance from circle
The Excel model is attached - only thing missing is the calculation of the distance.
Points-distance-to-a-circle.xlsx
0
Comment
Question by:NielsMadsen
  • 2
  • 2
4 Comments
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 39255521
Place this formula in E9 and copy down:

=((C9-$C$5)^2+(D9-$D$5)^2)^0.5-$C$2

Kevin
0
 

Author Comment

by:NielsMadsen
ID: 39255618
Excellent!

Is there a way to tell if the point is inside or outside the circle?
(is that the negative/positive distance?)

Niels
0
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 500 total points
ID: 39255650
Yes.

Kevin
0
 

Author Closing Comment

by:NielsMadsen
ID: 39255677
Precise, quick...GREAT
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Honda Vezel hybrid vs Honda Shuttle hybrid 2 59
Excel partial font macro 14 26
ms office troubleshooting for users 8 33
NEED TO UPDATE DATA IN EXCEL 18 25
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Iteration: Iteration is repetition of a process. A student who goes to school repeats the process of going to school everyday until graduation. We go to grocery store at least once or twice a month to buy products. We repeat this process every mont…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now