View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ralph2 Ralph2 is offline
external usenet poster
 
Posts: 9
Default Vector addition and polar plot... need help

Hello

I am trying to develop a MS Excel spread sheet that would do a
residual unbalance calculation as required by the API 610
specification.

This is relatively easy to do on paper but the accuracy leaves a lot
to be desired so would like to provide a more accurate and neater
solution.

In a nutshel:l
I have 12 values at specific angles
I need to plot these on a polar chart (for display only)
I need to draw a best fit circle through these 12 values
I need to add the vectors to obtain the combined result and angle
I need to plot that value and angle
I need to know the distance between this value and the true center of
the chart


Anyone up to a programming challenge... ideas or thoughts?

Thank you for your time
Ralph