{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Row","column","sum","average","row+column","offset+Counta","name manager","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Row","index":0,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,12],[3,2,3,6],[3,1,4,1],[3,8,3,13]]}
[]
[null,"Extracting a Whole Row "]
[]
[null,"Item","Monthly Sales Record",null,null,null,null,null,"Output"]
[null,null,"Jan","Feb","March","April","May",null,{"$f":"OFFSET(B5,7,0,1,6)","v":"Laptop"},489,499,503,772,1212]
[null,"Microwave Oven",150,189,102,287,391]
[null,"DVD",264,542,665,303,217]
[null,"Radio",984,1207,1553,832,776]
[null,"Private Car",128,65,89,198,101]
[null,"Motorcycle",288,387,456,693,359]
[null,"Desktop",572,561,532,476,598]
[null,"Laptop",489,499,503,772,1212]
[null,"Smartphone",965,1301,1567,1309,1234]
[null,"Land phone",773,1007,1047,1597,2150]
[null,"Telephone",102,86,88,53,45]
[null,"Refrigerator",42,32,39,12,17]
[null,"Television",531,632,629,978,771]
[null,"Table Fan",1014,965,1129,1609,1374]

{"sheet":"column","index":1,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,3,6],[1,1,1,8]]}
[]
[null,"Extracting an Entire Column"]
[]
[null,"Item","Monthly Sales Record",null,null,null,null,null,"Output"]
[null,null,"Jan","Feb","March","April","May",null,{"$f":"OFFSET(B5,0,3,13,1)","v":"March"}]
[null,"Microwave Oven",150,189,102,287,391,null,102]
[null,"DVD",264,542,665,303,217,null,665]
[null,"Radio",984,1207,1553,832,776,null,1553]
[null,"Private Car",128,65,89,198,101,null,89]
[null,"Motorcycle",288,387,456,693,359,null,456]
[null,"Desktop",572,561,532,476,598,null,532]
[null,"Laptop",489,499,503,772,1212,null,503]
[null,"Smartphone",965,1301,1567,1309,1234,null,1567]
[null,"Land phone",773,1007,1047,1597,2150,null,1047]
[null,"Telephone",102,86,88,53,45,null,88]
[null,"Refrigerator",42,32,39,12,17,null,39]
[null,"Television",531,632,629,978,771,null,629]
[null,"Table Fan",1014,965,1129,1609,1374]

{"sheet":"sum","index":2,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,1,4,1],[3,2,3,6]]}
[]
[null,"Getting Summation of an Entire Column"]
[]
[null,"Item","Monthly Sales Record",null,null,null,null,null,"Column","Total Sales"]
[null,null,"Jan","Feb","March","April","May",null,"April",{"$f":"SUM(OFFSET(F5,1,-2,13))","v":7473}]
[null,"Microwave Oven",150,189,102,287,391]
[null,"DVD",264,542,665,303,217]
[null,"Radio",984,1207,1553,832,776]
[null,"Private Car",128,65,89,198,101]
[null,"Motorcycle",288,387,456,693,359]
[null,"Desktop",572,561,532,476,598]
[null,"Laptop",489,499,503,772,1212]
[null,"Smartphone",965,1301,1567,1309,1234]
[null,"Land phone",773,1007,1047,1597,2150]
[null,"Telephone",102,86,88,53,45]
[null,"Refrigerator",42,32,39,12,17]
[null,"Television",531,632,629,978,771]
[null,"Table Fan",1014,965,1129,1609,1374]

{"sheet":"average","index":3,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,1,4,1],[3,2,3,6]]}
[]
[null,"Getting Average of Whole Column"]
[]
[null,"Item","Monthly Sales Record",null,null,null,null,null,"Column","Average"]
[null,null,"Jan","Feb","March","April","May",null,"April",{"$f":"AVERAGE(OFFSET(F5,1,-2,13))","v":574.84615384615381}]
[null,"Microwave Oven",150,189,102,287,391]
[null,"DVD",264,542,665,303,217]
[null,"Radio",984,1207,1553,832,776]
[null,"Private Car",128,65,89,198,101]
[null,"Motorcycle",288,387,456,693,359]
[null,"Desktop",572,561,532,476,598]
[null,"Laptop",489,499,503,772,1212]
[null,"Smartphone",965,1301,1567,1309,1234]
[null,"Land phone",773,1007,1047,1597,2150]
[null,"Telephone",102,86,88,53,45]
[null,"Refrigerator",42,32,39,12,17]
[null,"Television",531,632,629,978,771]
[null,"Table Fan",1014,965,1129,1609,1374]

{"sheet":"row+column","index":4,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,3,6],[3,8,3,10],[1,1,1,10]]}
[]
[null,"Extracting Adjacent Multiple Rows and Columns "]
[]
[null,"Item","Monthly Sales Record",null,null,null,null,null,"Output"]
[null,null,"Jan","Feb","March","April","May",null,{"$f":"OFFSET(B5,5,0,3,3)","v":"Motorcycle"},288,387]
[null,"Microwave Oven",150,189,102,287,391,null,"Desktop",572,561]
[null,"DVD",264,542,665,303,217,null,"Laptop",489,499]
[null,"Radio",984,1207,1553,832,776]
[null,"Private Car",128,65,89,198,101]
[null,"Motorcycle",288,387,456,693,359]
[null,"Desktop",572,561,532,476,598]
[null,"Laptop",489,499,503,772,1212]
[null,"Smartphone",965,1301,1567,1309,1234]
[null,"Land phone",773,1007,1047,1597,2150]
[null,"Telephone",102,86,88,53,45]
[null,"Refrigerator",42,32,39,12,17]
[null,"Television",531,632,629,978,771]
[null,"Table Fan",1014,965,1129,1609,1374]

{"sheet":"offset+Counta","index":5,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,8,3,13],[1,1,1,13]]}
[]
[null,"Combining OFFSET & COUNTA Functions"]
[]
[null,"Item","Jan","Feb","March","April","May",null,"Output"]
[null,"Microwave Oven",150,189,102,287,391,null,{"$f":"OFFSET(B4,0,0,COUNTA(B4:B100),COUNTA(B4:G4))","v":"Item"},"Jan","Feb","March","April","May"]
[null,"DVD",264,542,665,303,217,null,"Microwave Oven",150,189,102,287,391]
[null,"Radio",984,1207,1553,832,776,null,"DVD",264,542,665,303,217]
[null,"Private Car",128,65,89,198,101,null,"Radio",984,1207,1553,832,776]
[null,"Motorcycle",288,387,456,693,359,null,"Private Car",128,65,89,198,101]
[null,"Desktop",572,561,532,476,598,null,"Motorcycle",288,387,456,693,359]
[null,"Laptop",489,499,503,772,1212,null,"Desktop",572,561,532,476,598]
[null,"Smartphone",965,1301,1567,1309,1234,null,"Laptop",489,499,503,772,1212]
[null,"Land phone",773,1007,1047,1597,2150,null,"Smartphone",965,1301,1567,1309,1234]
[null,"Telephone",102,86,88,53,45,null,"Land phone",773,1007,1047,1597,2150]
[null,"Refrigerator",42,32,39,12,17,null,"Telephone",102,86,88,53,45]
[null,"Television",531,632,629,978,771,null,"Refrigerator",42,32,39,12,17]
[null,"Table Fan",1014,965,1129,1609,1374,null,"Television",531,632,629,978,771]
[null,null,null,null,null,null,null,null,"Table Fan",1014,965,1129,1609,1374]

{"sheet":"name manager","index":6,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,8,3,13],[1,1,1,13]]}
[]
[null,"Using Name Manager"]
[]
[null,"Item","Jan","Feb","March","April","May",null,"Output"]
[null,"Microwave Oven",150,189,102,287,391,null,{"$f":"Data1","v":"Microwave Oven"},150,189,102,287,391]
[null,"DVD",264,542,665,303,217,null,"DVD",264,542,665,303,217]
[null,"Radio",984,1207,1553,832,776,null,"Radio",984,1207,1553,832,776]
[null,"Private Car",128,65,89,198,101,null,"Private Car",128,65,89,198,101]
[null,"Motorcycle",288,387,456,693,359,null,"Motorcycle",288,387,456,693,359]
[null,"Desktop",572,561,532,476,598,null,"Desktop",572,561,532,476,598]
[null,"Laptop",489,499,503,772,1212,null,"Laptop",489,499,503,772,1212]
[null,"Smartphone",965,1301,1567,1309,1234,null,"Smartphone",965,1301,1567,1309,1234]
[null,"Land phone",773,1007,1047,1597,2150,null,"Land phone",773,1007,1047,1597,2150]
[null,"Telephone",102,86,88,53,45,null,"Telephone",102,86,88,53,45]
[null,"Refrigerator",42,32,39,12,17,null,"Refrigerator",42,32,39,12,17]
[null,"Television",531,632,629,978,771,null,"Television",531,632,629,978,771]
[null,"Table Fan",1014,965,1129,1609,1374,null,"Table Fan",1014,965,1129,1609,1374]

{"sheet":"VBA","index":7,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Embedding VBA Code"]
[]
[null,"Item","Jan","Feb","March","April","May"]
[null,"Microwave Oven",150,189,102,287,391]
[null,"DVD",264,542,665,303,217]
[null,"Radio",984,1207,1553,832,776]
[null,"Private Car",128,65,89,198,101]
[null,"Motorcycle",288,387,456,693,359]
[null,"Desktop",572,561,532,476,598]
[null,"Laptop",489,499,503,772,1212]
[null,"Smartphone",965,1301,1567,1309,1234]
[null,"Land phone",773,1007,1047,1597,2150]
[null,"Telephone",102,86,88,53,45]
[null,"Refrigerator",42,32,39,12,17]
[null,"Television",531,632,629,978,771]
[null,"Table Fan",1014,965,1129,1609,1374]