Advertisement
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
Circle through three points.xls (1 viewing) (1) Guest
This area of the Forum is Reserved for comments and discussion of specific Calculation Repository items. There is one topic for every document in the Repository. Generally authors like to receive feedback, to let them know that you value their contribution or to help them make improvements to their calculations. You might also like to make other users aware of other resources and references relating to this topic. I would encourage all users to leave some feedback when ever possible.
Go to bottom Post Reply Favoured: 0
TOPIC: Circle through three points.xls
#695
JohnDoyle (Admin)
Admin
Posts: 423
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Circle through three points.xls 11 Months, 3 Weeks ago Karma: 470  
Please reply to this topic to comment on or discuss Repository item:
Circle through three points.xls
 
Report to moderator   Logged Logged  
 
Talk to me about training.
Talk to me about engineering consultancy work and finite element analysis.
  The administrator has disabled public write access.
#698
xmarks102 (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Re:Circle through three points.xls 11 Months, 3 Weeks ago Karma: 0  
To try this out I used a unit circle and put in points (-1,0), (0,1) and (1,0). I should get a center of (0,0) and a raduis of 1, right? Instead I get a center of (-.5,-.5) and a radius of 0.707. I'm no math whiz, but this makes no sense to me. I moved the third point around the circle 30 degrees to (.866, .5) and then got a center of (-.2255, -.7745) and a radius of 1.095.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#700
JohnDoyle (Admin)
Admin
Posts: 423
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:Circle through three points.xls 11 Months, 3 Weeks ago Karma: 470  
You are quite right xmarks102. I noticed two incorrect formulas. I have corrected them and updated the file to version 1.2 - your problem works fine now. Thanks for the comment!
 
Report to moderator   Logged Logged  
 
Talk to me about training.
Talk to me about engineering consultancy work and finite element analysis.
  The administrator has disabled public write access.
Go to top Post Reply