TRIANGLE.xls

(5/9)

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

11 Feb 2008
File Size 62.00Kb
Downloads: 854
File Version: 1.0
File Author: Alex Tomanovich
File Rating (5/9)

 
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
excelcalcs-review-team 12 hours ago
Hello Alex,
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
Ver 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.
atomanovich 18 years ago
Sorry you found the labeling confusing. The italicized letter 'L' was meant to signify an angle (common at least in structural engineering). The angle in an uppercase letter corresponds to opposite the side in the same, but lowercase, letter.