5.5 PROBLEM 1 IS ANSWERED
THE ANSWER IS SOLVED IN EXCEL
ALL THE FORMULAS WERE CLEARLY SHOWN IN PICTURES.
THE FORMULA USED IS CALLED SUEVEYOR'S FORMULA FOR CALCULATION OF
AREA OF POLYGON OF ANY NUMBER OF SIDES.
THE ANSWER IS 20358.5 sq.m



Home Insert Page Layout Formulas Data Review View % Cut 2 AutoSum 势リずwrap Text 11 ▼ A" A General Paste Copy B l u. 田, Cr.Δ. = 剉Merge & Center- s-% , 'al;o Cor ditional asorbat styles . Insert Delete Format Sort & Find & 涅, = 2 Clear FilterSelect Cells Clipboard Alignment Editing 114 SIDE LATITUDE LONGITUDE 156.16 AB 53.16 3 45.55 4 75.8 BC 87.12 84.96 CD 41.91 6 DE 108.01 8.74 7 EA 67.85 9 10 VERTEX VERTEXX A (GIVEN) 100 100 100 A (GIVEN 100 12 -C11+C3 -D11+D3 153.16256.16 77.36 13 C12+C4 -D12+D4 301.71 9.76 32.15 216.75 14 -C13+C5 -D13+D 108.74 C14+C6 -D14+D6 15 100 100 16 D15+D7 CHECK FOR A CHECK FOR A -C15+C7 17 18 19 Sheet2· Sheet3 Sheet1 1..-+nl @t4) ▲ 18/05/2019
Bookl - Microsoft Excel Home Insert Page Layout Formulas Data Review View cut 2 AutoSum A Av 剃ョwrap Text General = Copy .r Form at Painter Fil- Paste B 1 u-.-a-a- S. % , 'al;08 Conditional asor mat .styles . Insert Delete For mat 2 Sort & Filter. Find & Merge & Center. # : Clear Select Number Cells Clipboard Alignment Editing L1 AREA OF POLYGON =-| ((KJ2-X2Yİ)) + (X2Y3-X3Vy) + +(A,呂一,A) 4 X1 Y1 X1Y2 X2Y1 X2 6 Y2 X2Y3 X3Y2 X3 Y3 X3Y4 X4Y3 X4 Y4 X4Y5 XSY4 Y5 X5Y1 X1Y5 10 12 13 14 15 16 17 18 19 4 Sheeti Sheet2 Sheet3 13096 ; 9:50 PM ▲ I.. all!磋4) 18/05/2019
Bookl - Microsoft Excel Home Insert Page Layout Formulas Data Review View cut Σ AutoSum 11 T A Av ー-=剃ョwrap Text General Copy Paste,Format Painter Biu, Fill ▲. s-% ,t蠿Conditional as able . Styles . Insert Delete Form at 2Clear % , 'i e Conditional Format Cell Insert Delete Format Formatting as Table Styles Sort & Find & ..涅涅 s Mergeacenter - 2 Clear FilterSelect Number Cells Clipboard Alignment Editing | CHECK FOR A A16 SIDE LATITUDE LONGITUDE AB 156.16 53.16 4 BC 75.8 45.55 84.96 CD 87.12 41.91 6 DE 108.01 8.74 EA 67.85 10 VERTEX A (GIVEN 100 25616 15316 100 10300 153.16 256.16 46209.9036 19816.5 26393.366 12 77.36 13 301.71 16767.78-2944.69 19712.4696 14 9.76 216.751061.3024 6968.51 -8029.8149 32.15 15 108.74 7659 3215 10874 16 CHECK FOR A SUM 100 100 40717.0207 17 AREA 20358.5 m2 18 19. 11 1 ト 커 Sheet1 Sheet2·Sheet3 e 소 Jl18/05/2019