Date: Mon, 24 Jan 2022 06:33:51 +0000 (GMT) Message-ID: <742174272.107164.1643006031306@9c5033e110b2> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_107163_1752118537.1643006031306" ------=_Part_107163_1752118537.1643006031306 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html EXAMPLE - DEGREES and RADIANS Functions

EXAMPLE - DEGREES and RADIANS Functions

This example illustrates to use the DEGREES and RADIANS function= s to convert values from one unit of measure to the other.

Source:

In this example, the source data contains information about a set of iso= sceles triangles. Each triangle is listed in a separate row, with the liste= d value as the size of the non-congruent angle in the triangle in degrees.<= /p>

You must calculate the measurement of all three angles of each isosceles= triangle in radians.

=20 =20 =20
triangle a01
t01 30
t02 60
t03 90
t04 120
t05 150

Transformation:

You can convert the value for the non-congruent angle to radians using t= he following:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula ROUND(RADIANS(a01), 4) 'r01'
=20

Now, calculate the value in degrees of the remaining two angles, which a= re congruent. Since the sum of all angles in a triangle is 180, the followi= ng formula can be applied to compute the size in degrees of each of these a= ngles:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula (180 - a01) / 2 'a02'
=20

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula ROUND(RADIANS(a02), 4) 'r02'
=20

Create a second column for the other congruent angle:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula ROUND(RADIANS(a02), 4) 'r03'
=20

To check accuracy, you sum all three columns and convert to degrees:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula ROUND(RADIANS(a02), 4) 'checksum'
=20

Results:

After you delete the intermediate columns, you see the following results= and determine the error in the checksum is acceptable:

=20 =20 =20 =20 =20 =20 =20
triangle a01 r03 r02 r01 checksum
t01 30 1.3095 1.3095 0.5238 179.9967
t02 60 1.0476 1.0476 1.0476 179.9967
t03 90 0.7857 0.7857 1.5714 179.9967
t04 120 0.5238 0.5238 2.0952 179.9967
t05 150 0.2619 0.2619 2.6190 179.9967
------=_Part_107163_1752118537.1643006031306--