Trig function table
Trig function table
(OP)
I would like to build a table that will solve all factors of a triangle with two given random factors. I would like to do this in 2 columns and 6 rows. the first column would be the input of two factors, the second column would be the solve of the remaining factors. I have deduced in my simple understanding of excel that I might accomplish this with alot of if then statements. I know nothing of VBA functions. if someone might be explicite in instructing me or sharing with me something allready in existence I would appreciate it.





RE: Trig function table
RE: Trig function table
If you are going to have 6 columns and expect to input on any 3 (programmer doesn't know which 3), it sounds like a tough problem (at least without vba). I think you'll need to keep your input and your output in a different place. The equations will look at the input and decide which two are given and populate the 6 items on the output from there.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Trig function table
http://www.1728.com/trig4.htm
TTFN
RE: Trig function table
Height
Base
Hypotenuse
Angle A
Angle B
Angle C
Each "section" needs only 2 inputs, and the rest is input automatically. For example, If I only know the Height and Base variables, I just pick the section missing those values. You will not need trig for some of these because the pythagorean theorem is easy to use.
Alse, a triangle is 180 degrees, and if you have 1 angle, then you only need to subtract that one and 90 degrees (right triangle remember) from 180 and the answer is the missing angle.
Do a "thread number" search here for "770-128136" (Using sin, cosine, and tan in excel) and I have put a few examples on Excel trig functions.
Flores
RE: Trig function table
RE: Trig function table
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Trig function table
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
Steam Engine enthusiasts: www.essexsteam.co.uk
RE: Trig function table
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Trig function table
That input cell could be set up with data validation for 1,2,3,4 for the 4 different combiination types of input known data.
The function CHOOSE is a bit more efficient than the IF function. It will perform a "If,then Go To" sort of function to 4 different cells which each can have your tringle solver formulas.
RE: Trig function table
Mark Hutton
RE: Trig function table
IRstuff Nice reference page. I should clarify myself in stating a right triangle solver. Simular to the page located at this link.
http://www.darex.com/calipers/
In this page you use two known values and the rest follow. It would be great to get a graphical representaion as well.
I have 6 rows set up as
Angle a =
Angle b = 90
Angle c =
side op =
Side adj =
side Hyp =
The results co;um would be adjacent to the input column
Check out the web site and let me know what you think.
RE: Trig function table
This is wolf and I am flattered that soemone referenced my Triangle Calculator.
Just thought I'd say that I also have a right triangle calculator at:
http://www.1728.com/trig.htm
Incidentally, when only the 3 angles of any triangle are known, at least the relative sizes of the sides can be determined. I don't know why other people don't program for this - but I did:
http://www.1728.com/trig4.htm
RE: Trig function table
I want to apply this to a spread sheet. I am not familiar with doing so by determining whether to use VBA or IF Then statements or Other statements.
I dont have time to try and learning it by experiemntation. If you could advise please do.