TRIANGLE.xls
Description
Triangle Solutions: General, Right and Oblique
Solves a triangle from any three known parts, returning the remaining sides and angles and the area. Three independent worksheets cover the general case, right-angled triangles and oblique (acute or obtuse) triangles, each with a labelled nomenclature sketch and the governing laws printed beside the tables.
Method
Law of sines, law of cosines and Pythagoras; area from ½ab·sin C. Angles are entered and reported in degrees.
Inputs
- General Triangle: one row each for SSS, SAS, ASA, SAA and SSA input, entered in counter-clockwise order around the triangle
- Right Triangle: nine rows for the common combinations of two sides, or one side and one acute angle
- Oblique Triangle: seven rows of side and angle combinations
Outputs
- All three sides (a, b, c) and all three angles (LA, LB, LC opposite them)
- Area of the triangle
- On the right-triangle sheet, the slope a/b as a percentage
The stored examples use the 3-4-5 triangle (angles 36.8699°, 53.1301°, 90°; area 6.00; slope 75%) and an oblique triangle with sides 10, 20 and 22 (angles 27.0123°, 65.2801° and 87.7076°; area 99.92). Dimensionless; use any consistent length unit.
Please note
- For the ambiguous side-side-angle case only one solution is returned (the one with the smaller second angle); the alternative obtuse solution is not shown. If the data cannot form a triangle the results show #NUM!.
- Inputs must follow the side and angle naming in the sketches exactly.
- No macros. The sheets are protected without a password and the formulas are hidden. The current description refers to a “DOC” worksheet, but this file has none; the notes are on each sheet.
- Written by Alex Tomanovich, P.E. Reference: engineering mathematics texts.
Calculation Preview
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 3
×
18 years ago
From the guy above comments...Alex, maybe try using the symbol fonts and use alpha instead. Well let me see and investigate first the program before I judge.
Thank you for your triangle solver. We checked it with a 3-4-5 triangle and a 10/20/22 triangle, and the angles and areas (6 and 99.92) agree with our own calculations. It also correctly returns #NUM! when the data cannot form a triangle.
While rewriting the description we found one gap. In the ambiguous side-side-angle case only one of the two valid triangles is returned, with no warning. For example, with a = 3, b = 4 and angle A = 30°, the sheet gives B = 41.81° and c = 5.70, but B = 138.19° with c = 1.23 is equally valid and is not shown. A user who needs the obtuse solution would not know it exists.
You may want to consider showing both solutions, or at least a note when the second one exists.
We have mentioned this in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team