{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Polygon Area"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Polygon Area","index":0,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[21,1,21,3],[31,1,31,4],[32,1,32,4],[0,0,0,19],[2,4,2,5],[13,1,13,3],[13,8,13,9],[17,1,17,3],[23,7,25,9],[33,1,33,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[25,1,25,3],[29,1,30,4]]}
["Calculating The Area Of A Simple Polygon Using The Shoelace Algorithm"]
[]
[null,"Point","X","Y","Manual"]
[null,1,3,4,{"$f":"C4*D5","v":33},{"$f":"D4*C5","v":20},"=C4*D5","=D4*C5"]
[null,2,5,11,{"$f":"C5*D6","v":40},{"$f":"D5*C6","v":132},"=C5*D6","=D5*C6"]
[null,3,12,8,60,{"$f":"D6*C7","v":72},"=C6*D7","=D6*C7"]
[null,4,9,5,54,25,"=C7*D8","=D7*C8"]
[null,5,5,6,20,{"$f":"D8*C9","v":18},"=C8*D9","=D8*C9"]
[null,1,3,4,{"$f":"SUM(E4:E8)","v":207},{"$f":"SUM(F4:F8)","v":267},"=SUM(E4:E8)","=SUM(F4:F8)"]
[null,"1. Manual calculations",null,null,{"$f":"0.5*ABS(E9-F9)","v":30}]
[null,null,null,null,"=0.5*ABS(E9-F9)"]
[]
[]
[null,"2. Using SUMPRODUCT",null,null,{"$f":"0.5*ABS(SUMPRODUCT(C4:C8,D5:D9)-SUMPRODUCT(D4:D8,C5:C9))","v":30}]
[null,null,null,null,"=0.5*ABS(SUMPRODUCT(C4:C8;D5:D9)-SUMPRODUCT(D4:D8;C5:C9))"]
[]
[]
[null,"3. Using Array Formula",null,null,{"$f":"0.5*ABS(SUM(C4:C8*D5:D9-D4:D8*C5:C9))","v":30},"After typing needs CTRL + SHIFT + ENTER in order to work"]
[null,null,null,null,"=0.5*ABS(SUM(C4:C8*D5:D9-D4:D8*C5:C9))"]
[]
[]
[null,"4. Custom VBA Function",null,null,{"$f":"PolygonArea(C4:C8,D4:D8)","v":30}]
[null,null,null,null,"=PolygonArea(C4:C8;D4:D8)"]
[null,null,null,null,null,null,null,"Note that the input difference didn't change the result…"]
[]
[null,"..and with the extra point",null,null,{"$f":"PolygonArea(C4:C9,D4:D9)","v":30}]
[null,null,null,null,"=PolygonArea(C4:C9;D4:D9)"]
[]
[]
[null,"Calculating The Area Of A Simple Polygon Using The Shoelace Algorithm"]
[]
[null,"© Christos Samaras"]
[null,"Mechanical Engineer"]
[null,"tel.: +306973513308"]
[null,"e-mail: xristos.samaras@gmail.com"]
[null,"site: http://www.myengineeringworld.net"]
[null,"Thessaloniki, Greece 25/06/2014"]