{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Title","Offset","Index","Complex","Recap"],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":1,"defined_names":13,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2048]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: Pixabay"]

{"sheet":"Offset","index":1,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Name","Q1","Q2","Q3","Q4","Average","# Qtrs",1]
["Larry Vance",1376,1358,1403,1290,{"$f":"AVERAGE(OFFSET(B2,0,0,1,$H$1))","v":1376}]
["Anthony J. LoBello Jr.",1353,1518,1361,1341,{"$f":"AVERAGE(OFFSET(B3,0,0,1,$H$1))","v":1353}]
["Carl R Hooker",1629,1899,1372,1077,1629]
["Will Riley",1053,1359,1545,1223,1053]
["James N Johnson",1594,1243,1175,1836,1594]
["Richard B Lanza",1740,1573,1373,1324,1740]

{"sheet":"Index","index":2,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Name","Q1","Q2","Q3","Q4","Average","# Qtrs",1]
["Larry Vance",1376,1358,1403,1290,{"$f":"AVERAGE(B2:INDEX(B2:E2,$H$1))","v":1376}]
["Anthony J. LoBello Jr.",1353,1518,1361,1341,{"$f":"AVERAGE(B3:INDEX(B3:E3,$H$1))","v":1353}]
["Carl R Hooker",1629,1899,1372,1077,{"$f":"AVERAGE(B4:INDEX(B4:E4,$H$1))","v":1629}]
["Will Riley",1053,1359,1545,1223,{"$f":"AVERAGE(B5:INDEX(B5:E5,$H$1))","v":1053}]
["James N Johnson",1594,1243,1175,1836,{"$f":"AVERAGE(B6:INDEX(B6:E6,$H$1))","v":1594}]
["Richard B Lanza",1740,1573,1373,1324,{"$f":"AVERAGE(B7:INDEX(B7:E7,$H$1))","v":1740}]

{"sheet":"Complex","index":3,"n_rows":20,"n_cols":26,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"Qtr","Q3"]
[null,null,null,null,null,null,null,null,null,null,"Region","West",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L1&L2","v":"Q3West"}]
[]
[null,"Q1","Q1","Q1","Q2","Q2","Q2","Q3","Q3",null,{"$f":"\"1st \"&L1","v":"1st Q3"},{"$f":"MATCH(L1,B4:I4,0)","v":7},{"$f":"_xlfn.FORMULATEXT(L4)","v":"=MATCH(L1,B4:I4,0)"}]
["Region","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug",null,{"$f":"\"Count \"&L1","v":"Count Q3"},{"$f":"COUNTIF(B4:I4,L1)","v":2},{"$f":"_xlfn.FORMULATEXT(L5)","v":"=COUNTIF(B4:I4,L1)"}]
["East",98,30,71,35,22,80,31,58,null,{"$f":"\"1st \"&L2","v":"1st West"},{"$f":"MATCH(L2,A6:A20,0)","v":11},{"$f":"_xlfn.FORMULATEXT(L6)","v":"=MATCH(L2,A6:A20,0)"}]
["East",32,90,26,69,51,91,53,31,null,{"$f":"\"Count \"&L2","v":"Count West"},{"$f":"COUNTIF(A6:A20,L2)","v":5},{"$f":"_xlfn.FORMULATEXT(L7)","v":"=COUNTIF(A6:A20,L2)"}]
["East",56,87,83,66,46,31,67,79]
["East",79,59,30,58,68,84,29,81,null,"Median",{"$f":"MEDIAN(OFFSET(A5,L6,L4,L7,L5))","v":54},{"$f":"_xlfn.FORMULATEXT(L9)","v":"=MEDIAN(OFFSET(A5,L6,L4,L7,L5))"}]
["East",75,22,37,34,30,75,69,63]
["East",27,64,88,72,39,31,49,94,null,"Median",{"$f":"MEDIAN(INDEX(B6:I20,L6,L4):INDEX(B6:I20,L6+L7-1,L4+L5-1))","v":54},{"$f":"_xlfn.FORMULATEXT(L11)","v":"=MEDIAN(INDEX(B6:I20,L6,L4):INDEX(B6:I20,L6+L7-1,L4+L5-1))"}]
["East",65,77,76,82,28,22,40,41]
["Central",62,45,71,90,91,75,41,90,null,"Test",{"$f":"MEDIAN(H16:I20)","v":54}]
["Central",54,91,75,34,53,57,89,66]
["Central",77,26,43,33,94,71,94,49]
["West",82,41,35,62,28,61,72,59]
["West",94,97,68,33,55,86,61,25]
["West",86,33,28,53,98,74,54,66]
["West",99,93,59,41,25,63,54,49]
["West",51,68,84,88,93,83,45,39]

{"sheet":"Recap","index":4,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Episode Recap"]
[]
[null,"OFFSET is a flexible function. "]
[null,"It can be used to point to a variable top left cell,"]
[null,"and then point to a range that has a variable shape."]
[null,"The problem with OFFSET is that it is volatile."]
[null,"Volatile functions calculate at every calculation."]
[null,"Instead of OFFSET, you can use INDEX(): or :INDEX()"]
[null,"When INDEX is next to a :, it will return a cell address instead of the value at that cell."]
[null,"INDEX is not volatile"]