Home Articles Forums Gallery Marketplace Videos

WoodCentral Forums

Knowledge You Can Build On — Est. 1998

Compare cordless drills on the numbers that matter

Triangle geometry

Posts

Triangle geometry

#1

Moses Yoder

Triangle geometry

Moses Yoder

I looked around online for this, but didn't really find what I was looking for. This is woodworking related in that it has to do with calculating the size of the cabinet. I normally just draw it on Autocad to figure the size, but what the salespeople want is an Excel spreadsheet with the formula set up so all they have to do is enter the depth of the cabinet. The spreadsheet will tell them how far away the cabinet should set from where the wall angles. So in the triangle below, A is the cabinet depth, B is the distance from the angles in the wall, and we don't really need to know C because it affects nothing. Although if I know A and figure out B I can set up the pythagorean theorem to figure out C. My question is if I know A, and I know the angle on the right is 90� and the angle on the left is known (varies) what formula do I use to figure the length of B? If I need to know the cosine of the angle, is there an easy way to put that in my spreadsheet?


Re: Triangle geometry

#2

Re: Triangle geometry

Paul Leuba

As I recall my high school trig, the tangent of angle AC is B/A.

Therefore, B= Tan AC * A

As you mentioned, length of C is not relevant to the issue provided that the angle AB is 90 degrees. Then the length of B is defined by the length of A and the Tangeant of angle AC.

Paul in Hunt Valley, MD

Re: Triangle geometry

#3

Re: Triangle geometry

Paul Leuba

Also, regarding putting trig functions in spreadsheets, Excel has the necessary functions for Tangent and Arc Tangent, as well as the other trig functions. The input variable is radians, but the Excel help for these functions explains how to quickly convert degrees to radians with a formula in the sheet.

Paul in Hunt Valley, MD

Re: Triangle geometry

#4

Re: Triangle geometry

Dave Paine

To build on Paul's reply.

B= Tan(Angle(AC) * A

As Paul stated, the nuance with Excel as mentioned by Paul is that the trig functions do not use Angle, rather they use Radians, so you have to convert the angle in degrees to Radians. Fortunately Excel has a function to do this..

So the formula would be

B= TAN(RADIANS(Angle(AC)) * A

where Angle(AC) would be entered as a number, e.g., 22.5 from the picture.

Enter the angle in a cell, and reference that cell for "Angle(AC)".

Re: Triangle geometry

#5

I was just looking for this the other day

Nathan

This doesn't directly address your need for an Excel macro, but others seem to have done that already.

The other day I needed to find out the slope of our roof. Briefly, I tried to recall the formulas I learned in trigonometry, but quickly came to the conclusion that Google would be faster. I googled "right triangle calculator" and came up with this page:

http://www.csgnetwork.com/righttricalc.html

You type in a pair of values (the length of side A, the length of side B, the length of the hypotenuse (side C), or either angle A or B). Hit the "Calculate" button and the calculator fills in the rest of the values. The formulas are there, too. In your case, you would use "cos A = adj/hyp", i.e. the cosine of angle (A) is equal to the length of the side adjacent to the angle (divided by the length of the hypotenuse. There's a picture on the site that makes it clearer.

HTH

Nathan