I have some programming knowledge, but not very much. I was going to go about using MATLAB, but if i can use excel I would like to. Essentially I need to find the correct degrees for a bowthruster and z drive on a ship.

There are 3 angles..for sake of this lets call them.. Alpha, theta, and omega.. defined as I, J, and K...each angle can fall between 0-180 degrees.

so For i= 0:180
j=0:180
k:0:180

Now I want to keep this short, so I'm not going to go through all the math and steps it took to come up with the next two equations..BUT essentially the program needs to take all numbers from 0-180 for the three angles and run it through the next two equations and then find all the possible outputs with a percent different less then 1.

equation 1: Fcosi-Fcosj+F1cosk=0 F=700, F1=120

equation 2: 92.2F(sini+sinj)-7.0922f(cosi+cosj)-87.9433f1sink=0


essentially without going on, can a program be written in excel to run all the numbers through a trial and error situation.

This is a very crude begining and is what I have at the core of this, I have started to write out a program I would write into matlab, but if I can do something in excel that will make it much more simple.