{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Simple Calculation","SUMPRODUCT Function","Array Formula"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Simple Calculation","index":0,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,4,3,5],[1,1,1,5],[1,15,1,19],[3,18,3,19]]}
[]
[null,"Use of Simple Calculation",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Vertex","X","Y","Multiplication",null,null,null,null,null,null,null,null,null,null,"Vertices","X","Y","Multiplication"]
[null,1,0,1,{"$f":"C5*D6","v":0},{"$f":"D5*C6","v":2},null,null,null,null,null,null,null,null,null,1,0,1]
[null,2,2,1.5,{"$f":"C6*D7","v":2.6},{"$f":"D6*C7","v":2.7},null,null,null,null,null,null,null,null,null,2,2,1.5]
[null,3,1.8,1.3,3.6,1.3,null,null,null,null,null,null,null,null,null,3,1.8,1.3]
[null,4,1,2,1.9,1.8,null,null,null,null,null,null,null,null,null,4,1,2]
[null,5,0.9,1.9,{"$f":"C9*D5","v":0.9},{"$f":"D9*C5","v":0},null,null,null,null,null,null,null,null,null,5,0.9,1.9]
[null,null,null,null,{"$f":"SUM(E5:E9)","v":9},7.8]
[]
[null,null,"Area",{"$f":"ABS(E10-F10)/2","v":0.60000000000000009}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,7,3]
[null,4,1.5]
[null,2,0.8]
[null,1,0]

{"sheet":"SUMPRODUCT Function","index":1,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,4,3,5],[1,15,1,19],[3,18,3,19]]}
[]
[null,"Use of SUMPRODUCT Function",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Vertex","X","Y","Sumproduct",null,null,null,null,null,null,null,null,null,null,"Vertices","X","Y","Multiplication"]
[null,1,0,1,{"$f":"SUMPRODUCT(C5:C9,D6:D10)","v":9},{"$f":"SUMPRODUCT(D5:D9,C6:C10)","v":7.8},null,null,null,null,null,null,null,null,null,1,0,1]
[null,2,2,1.5,null,null,null,null,null,null,null,null,null,null,null,2,2,1.5]
[null,3,1.8,1.3,null,null,null,null,null,null,null,null,null,null,null,3,1.8,1.3]
[null,4,1,2,null,null,null,null,null,null,null,null,null,null,null,4,1,2]
[null,5,0.9,1.9,null,null,null,null,null,null,null,null,null,null,null,5,0.9,1.9]
[null,1,0,1]
[]
[null,null,"Area",{"$f":"0.5*ABS(E5-F5)","v":0.60000000000000009}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,7,3]
[null,4,1.5]
[null,2,0.8]
[null,1,0]

{"sheet":"Array Formula","index":2,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,15,1,19],[3,18,3,19]]}
[]
[null,"Use of Array Formula",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Vertex","X","Y",null,null,null,null,null,null,null,null,null,null,null,"Vertices","X","Y","Multiplication"]
[null,1,0,1,null,null,null,null,null,null,null,null,null,null,null,1,0,1]
[null,2,2,1.5,null,null,null,null,null,null,null,null,null,null,null,2,2,1.5]
[null,3,1.8,1.3,null,null,null,null,null,null,null,null,null,null,null,3,1.8,1.3]
[null,4,1,2,null,null,null,null,null,null,null,null,null,null,null,4,1,2]
[null,5,0.9,1.9,null,null,null,null,null,null,null,null,null,null,null,5,0.9,1.9]
[null,1,0,1]
[]
[null,null,"Area",{"$f":"0.5*ABS(SUM(C5:C9*\nD6:D10-D5:D9*C6:C10))","v":0.59999999999999987}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,7,3]
[null,4,1.5]
[null,2,0.8]
[null,1,0]