Simultaneous equations, part II

xenium
xenium used Ask the Experts™
on
This is a follow-up to:

http://www.experts-exchange.com/questions/28929349/Solve-the-following-simultaneous-equations.html

Replacing the first equation with:

1) alpha + beta + delta = 90 degrees

I would like to vary delta, specifically what is the solution where delta = 3 or 4 degrees ?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
If possible also a suggestion also how to do this without Excel, eg with google sheets
Mechanical Engineer
Most Valuable Expert 2013
Top Expert 2013
Commented:
I hate using Google sheets because the user interface is so unfamiliar. And so slow.

I don't know if you have access to this sheet: https://docs.google.com/spreadsheets/d/1PeZOZlKzRXdMY2eSxzpsZUDqx1cYe05u7ZW1OikLhA4/edit?usp=sharing
If you don't, I can email you an invitation.

You can get a copy of Solver add-in for Google sheets at http://www.solver.com/solver-addon-google-sheets-help-and-support  It is free.

The problem set-up is the same as it is with Excel. Rewrite your four equations such that the right side equals 0. Make guesses for alpha, beta, b & q (along with the known value of delta). Miinimize the sum of the squares of the left side of the equations evaluated using the guesses using Solver, subject to the constraints that alpha and beta are between 0 and 90 degrees.

alpha      62.68047593
beta      24.31998568
b      5.860877037
q      6.58405357
delta      3

alpha      62.66974553
beta      23.33025448
b      5.804870715
q      6.53425775
delta      4
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
Solver used for four simultaneous equations

Author

Commented:
Thanks a lot that's fantastic.

I've requested access to the google doc, but perhaps for the benefit of other users you could just make the doc public but read-only .. menu Share, then click Advanced, then next to "Specific people can access.." click Change
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
xenium,
Thanks for the tip on how to make the doc public (which I have now done). I sure couldn't figure it out when I was setting the doc up--even though I clicked on the Advanced button.

In any event, you should have read/write access to the file so you can dial in the design of your project.

Brad

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial