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

You have a reply at one of your other posts.

Ralph2 wrote:
>
> 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

--

Dave Peterson