Vector addition and polar plot... need help

[Ralph2]

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]

You have a reply at one of your other posts.

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