Welcome Guest
You last visited December 9, 2016, 6:13 pm
All times shown are
Eastern Time (GMT-5:00)

# Excel question

Topic closed. 6 replies. Last post 1 year ago by lakerben.

 Page 1 of 1
New Mexico
United States
Member #86099
January 29, 2010
11119 Posts
Offline
 Posted: June 15, 2015, 9:26 am - IP Logged

In my many work experiences I worked with electronics.  We used Polar and rectangular for ac electronics.  I would like to try it for pick 3.

Say for example draw 003.

sum 3 root 3. How can that be expressed dealing with the largest sum 27 with polar and rectangular.  Is this feasabile?

Any thoughts?

ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
5912 Posts
Offline
 Posted: June 15, 2015, 9:45 am - IP Logged

In my many work experiences I worked with electronics.  We used Polar and rectangular for ac electronics.  I would like to try it for pick 3.

Say for example draw 003.

sum 3 root 3. How can that be expressed dealing with the largest sum 27 with polar and rectangular.  Is this feasabile?

Any thoughts?

The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3675 Posts
Offline
 Posted: June 15, 2015, 12:12 pm - IP Logged

In my many work experiences I worked with electronics.  We used Polar and rectangular for ac electronics.  I would like to try it for pick 3.

Say for example draw 003.

sum 3 root 3. How can that be expressed dealing with the largest sum 27 with polar and rectangular.  Is this feasabile?

Any thoughts?

What do you want assign as x and y?

Sum = x? Root = x? Sum = y? Root = y?

Once we get by that, all else is easy.

Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.

Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish
Jehocifer

New Mexico
United States
Member #86099
January 29, 2010
11119 Posts
Offline
 Posted: June 17, 2015, 1:12 pm - IP Logged

What do you want assign as x and y?

Sum = x? Root = x? Sum = y? Root = y?

Once we get by that, all else is easy.

Sum =x, root =y.  And maybe a pulldown feature to change these.

PS :I used to have a lab named Tejas who looked exactly like the avatar you are using.  He lived to 12 years old and was a great dog.

The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3675 Posts
Offline
 Posted: June 17, 2015, 1:58 pm - IP Logged

Sum =x, root =y.  And maybe a pulldown feature to change these.

PS :I used to have a lab named Tejas who looked exactly like the avatar you are using.  He lived to 12 years old and was a great dog.

I'll work it with sum - x and root - y.

That's my baby, Nikki. She's a Border Lab.

Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.

Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish
Jehocifer

The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3675 Posts
Offline
 Posted: June 17, 2015, 4:21 pm - IP Logged

We have one method.

The radial vector would always be above the x-axis.

Where x = Sum and y = Root, then r = √((x - 13.5)(x - 13.5) + y²) and in radians θ = arccos(x / r) or in degrees θ = (180°/π) · arccos(x / r)

Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.

Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish
Jehocifer

New Mexico
United States
Member #86099
January 29, 2010
11119 Posts
Offline
 Posted: June 18, 2015, 12:18 pm - IP Logged

We have one method.

The radial vector would always be above the x-axis.

Where x = Sum and y = Root, then r = √((x - 13.5)(x - 13.5) + y²) and in radians θ = arccos(x / r) or in degrees θ = (180°/π) · arccos(x / r)