{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Data Set","Combining Functions","Merging","VBA","Sum","Practice Sheet"],"not_rendered":{"charts":0,"images":0,"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":"Data Set","index":0,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sample Data Set"]
[]
[null,"Date","Sales"]
[null,"2021-02-01",1500]
[null,"2021-02-02",1895.8]
[null,"2021-02-03",1760]
[null,"2021-02-04",1437.26]
[null,"2021-02-05",1391.29]
[null,"2021-02-06",1520]
[null,"2021-02-07",1600]
[null,"2021-02-08",1722.5]
[null,"2021-02-09",1730]
[null,"2021-02-10",1725.6]
[null,"2021-02-11",1671.5526666666699]
[null,"2021-02-12",1579.42678787879]
[null,"2021-02-13",1560.30090909091]
[null,"2021-02-14",1430.1750303030301]
[null,"2021-02-15",1453.04915151515]
[null,"2021-02-16",1490.9232727272699]
[null,"2021-02-17",1538.7973939393901]
[null,"2021-02-18",1593.67151515152]
[null,"2021-02-19",1609.5456363636399]
[null,"2021-02-20",1629.4197575757601]
[null,"2021-02-21",1850.29387878788]
[null,"2021-02-22",1858.1679999999999]
[null,"2021-02-23",1766.04212121212]
[null,"2021-02-24",1773.91624242424]
[null,"2021-02-25",1781.7903636363601]

{"sheet":"Combining Functions","index":1,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combining Functions"]
[]
[null,"Date","Sales","Average"]
[null,"2021-02-01",1500,{"$f":"AVERAGE(OFFSET($C$5,(ROW()-ROW($D$5))*5,,5,))","v":1596.8700000000001}]
[null,"2021-02-02",1895.8,{"$f":"AVERAGE(OFFSET($C$5,(ROW()-ROW($D$5))*5,,5,))","v":1659.6200000000001}]
[null,"2021-02-03",1760,1538.9009090909099]
[null,"2021-02-04",1437.26,1572.4715151515159]
[null,"2021-02-05",1391.29,1806.04212121212]
[null,"2021-02-06",1520,{"$error":"#DIV/0!"}]
[null,"2021-02-07",1600,{"$error":"#DIV/0!"}]
[null,"2021-02-08",1722.5,{"$error":"#DIV/0!"}]
[null,"2021-02-09",1730,{"$error":"#DIV/0!"}]
[null,"2021-02-10",1725.6,{"$error":"#DIV/0!"}]
[null,"2021-02-11",1671.5526666666699,{"$error":"#DIV/0!"}]
[null,"2021-02-12",1579.42678787879,{"$error":"#DIV/0!"}]
[null,"2021-02-13",1560.30090909091,{"$error":"#DIV/0!"}]
[null,"2021-02-14",1430.1750303030301,{"$error":"#DIV/0!"}]
[null,"2021-02-15",1453.04915151515,{"$error":"#DIV/0!"}]
[null,"2021-02-16",1490.9232727272699,{"$error":"#DIV/0!"}]
[null,"2021-02-17",1538.7973939393901,{"$error":"#DIV/0!"}]
[null,"2021-02-18",1593.67151515152,{"$error":"#DIV/0!"}]
[null,"2021-02-19",1609.5456363636399,{"$error":"#DIV/0!"}]
[null,"2021-02-20",1629.4197575757601,{"$error":"#DIV/0!"}]
[null,"2021-02-21",1850.29387878788,{"$error":"#DIV/0!"}]
[null,"2021-02-22",1858.1679999999999,{"$error":"#DIV/0!"}]
[null,"2021-02-23",1766.04212121212,{"$error":"#DIV/0!"}]
[null,"2021-02-24",1773.91624242424,{"$error":"#DIV/0!"}]
[null,"2021-02-25",1781.7903636363601,{"$error":"#DIV/0!"}]

{"sheet":"Merging","index":2,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Merging Functions"]
[]
[null,"Date","Sales","Average"]
[null,"2021-02-01",1500,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":1596.8700000000001}]
[null,"2021-02-02",1895.8,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":1659.6200000000001}]
[null,"2021-02-03",1760,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":1538.9009090909099}]
[null,"2021-02-04",1437.26,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":1572.4715151515159}]
[null,"2021-02-05",1391.29,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":1806.04212121212}]
[null,"2021-02-06",1520,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-07",1600,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-08",1722.5,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-09",1730,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-10",1725.6,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-11",1671.5526666666699,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-12",1579.42678787879,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-13",1560.30090909091,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-14",1430.1750303030301,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-15",1453.04915151515,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-16",1490.9232727272699,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-17",1538.7973939393901,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-18",1593.67151515152,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-19",1609.5456363636399,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-20",1629.4197575757601,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-21",1850.29387878788,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-22",1858.1679999999999,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-23",1766.04212121212,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-24",1773.91624242424,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]
[null,"2021-02-25",1781.7903636363601,{"$f":"AVERAGE(INDEX(C:C,5+5*(ROW()-ROW($D$5))):\nINDEX(C:C,4+5*(ROW()-ROW($D$5)+1)))","v":{"$error":"#DIV/0!"}}]

{"sheet":"VBA","index":3,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying VBA"]
[]
[null,"Date","Sales"]
[null,"2021-02-01",1500]
[null,"2021-02-02",1895.8]
[null,"2021-02-03",1760]
[null,"2021-02-04",1437.26]
[null,"2021-02-05",1391.29]
[null,"2021-02-06",1520]
[null,"2021-02-07",1600]
[null,"2021-02-08",1722.5]
[null,"2021-02-09",1730]
[null,"2021-02-10",1725.6]
[null,"2021-02-11",1671.5526666666699]
[null,"2021-02-12",1579.42678787879]
[null,"2021-02-13",1560.30090909091]
[null,"2021-02-14",1430.1750303030301]
[null,"2021-02-15",1453.04915151515]
[null,"2021-02-16",1490.9232727272699]
[null,"2021-02-17",1538.7973939393901]
[null,"2021-02-18",1593.67151515152]
[null,"2021-02-19",1609.5456363636399]
[null,"2021-02-20",1629.4197575757601]
[null,"2021-02-21",1850.29387878788]
[null,"2021-02-22",1858.1679999999999]
[null,"2021-02-23",1766.04212121212]
[null,"2021-02-24",1773.91624242424]
[null,"2021-02-25",1781.7903636363601]

{"sheet":"Sum","index":4,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sum Every Nth Row"]
[]
[null,"Date","Sales","Row Numbers","Result"]
[null,"2021-02-01",1500,{"$f":"MOD(ROW(C5)-4,5)=0","v":false},{"$f":"SUM(C5:C29*(MOD(ROW(C5:C29)-4,5)=0))","v":7981.1492727272698}]
[null,"2021-02-02",1895.8,{"$f":"MOD(ROW(C6)-4,5)=0","v":false}]
[null,"2021-02-03",1760,false]
[null,"2021-02-04",1437.26,false]
[null,"2021-02-05",1391.29,true]
[null,"2021-02-06",1520,false]
[null,"2021-02-07",1600,false]
[null,"2021-02-08",1722.5,false]
[null,"2021-02-09",1730,false]
[null,"2021-02-10",1725.6,true]
[null,"2021-02-11",1671.5526666666699,false]
[null,"2021-02-12",1579.42678787879,false]
[null,"2021-02-13",1560.30090909091,false]
[null,"2021-02-14",1430.1750303030301,false]
[null,"2021-02-15",1453.04915151515,true]
[null,"2021-02-16",1490.9232727272699,false]
[null,"2021-02-17",1538.7973939393901,false]
[null,"2021-02-18",1593.67151515152,false]
[null,"2021-02-19",1609.5456363636399,false]
[null,"2021-02-20",1629.4197575757601,true]
[null,"2021-02-21",1850.29387878788,false]
[null,"2021-02-22",1858.1679999999999,false]
[null,"2021-02-23",1766.04212121212,false]
[null,"2021-02-24",1773.91624242424,false]
[null,"2021-02-25",1781.7903636363601,true]

{"sheet":"Practice Sheet","index":5,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Practice Sheet"]
[]
[null,"Date","Sales"]
[null,"2021-02-01",1500]
[null,"2021-02-02",1895.8]
[null,"2021-02-03",1760]
[null,"2021-02-04",1437.26]
[null,"2021-02-05",1391.29]
[null,"2021-02-06",1520]
[null,"2021-02-07",1600]
[null,"2021-02-08",1722.5]
[null,"2021-02-09",1730]
[null,"2021-02-10",1725.6]
[null,"2021-02-11",1671.5526666666699]
[null,"2021-02-12",1579.42678787879]
[null,"2021-02-13",1560.30090909091]
[null,"2021-02-14",1430.1750303030301]
[null,"2021-02-15",1453.04915151515]
[null,"2021-02-16",1490.9232727272699]
[null,"2021-02-17",1538.7973939393901]
[null,"2021-02-18",1593.67151515152]
[null,"2021-02-19",1609.5456363636399]
[null,"2021-02-20",1629.4197575757601]
[null,"2021-02-21",1850.29387878788]
[null,"2021-02-22",1858.1679999999999]
[null,"2021-02-23",1766.04212121212]
[null,"2021-02-24",1773.91624242424]
[null,"2021-02-25",1781.7903636363601]