Formula for angle

[Nanaia]

This may be more of a math question than an Excel one, but since I want to be able to use it in a spreadsheet I thought I'd pose it here.

I deal with folding panels.

Picture if you will a panel that is 24" wide and 110" tall. The width and length per panel will vary. The top and bottom are roughly 90 degree bends but at different depths. So the top could have a 1" leg bent at approximately 90 degrees from the panel face, and the bottom could have a 4" leg bent approximately 90 degrees from the face. The depth of the top and bottom could vary, one is the shallowest and 4 is the tallest. It could also vary in that instead of the sides being tapered, it could be the top and bottom are tapered so the left side could be 1" and the right side could be 4".

The way I have it set up now is with a column that contains the following column headings: face width, face length, top depth, bottom depth, right depth, left depth.

Is there a formula that I can use in Excel that uses the information for the columns above that would calculate the angle of what the tapered edge will be?

Let me know if I need more information - or if I need to clarify. I believe Excel has the ability to do this, I just don't know what to tell it to.

Thank you for your time.

 

[Perpa]

Nanaia,

Perhaps an example will suffice:
If the long side of the panel is 110", and the short side is 3" = 4"-1",
OR...Another way to look at the short side dimension would be to take the difference of the top and bottom dimensions of the larger unbent portion of the panel, in this example that would be 23" - 20" or 3".

Then the angle at the 4" bent end would be 88.43777508 in degrees and decimals
OR 180 - 88.43777508 = 91.56222492 decimal degrees on the unbent portion of the panel on the 20" end.

Notes:
The ATN function in Excel gives the angle in 'radians'
To get the angle in Degrees and decimals we multiply the radians by 180/PI().
Perpa

Excel Workbook
	C	D	E	F	G	H
1
2	Long side	Short side		Tangent	ATAN	Angle
3				(Lside/Sside)	(Radians)	(D.dddd)
4	110	3		36.66666667	1.5435304	88.437775
Sheet1

 

[Nanaia]

Thank you. I will test this and see if it works. The length and width of the panel are the finished / after folded size so would adding the leg lengths work? If so then I'd need to add the rest of the flanges instead of stopping at the portion that sits flush against the surface. The angle I'm trying to calculate would be utilized with the flat sheet to make the folds.