{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Fill Handle","Double-Clicking Fill Handle","Keyboard Shortcut","Fill Option","Copy and Paste Formula","Array Formula","Insert Formula along Entire Row","VBA Code"],"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":"Dataset","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Performance of Sales Reps"]
[]
[null,"Name","2022 Sales","2021 Sales"]
[null,"Sam",2435,2852]
[null,"Adam",4025,2493]
[null,"Anna",4767,4743]
[null,"Harry",4533,3294]
[null,"Tyler",1591,3796]
[null,"Will",3660,3574]
[null,"Smith",2092,1160]
[null,"Julie",2914,1378]
[null,"Gloria",2652,4789]
[null,"Mary",1096,2350]

{"sheet":"Fill Handle","index":1,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using Fill Handle Tool",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","2022 Sales","2021 Sales","Difference",null,null,null,null,null,null,"Name","2022 Sales","2021 Sales","Difference"]
[null,"Sam",2435,2852,{"$f":"C5-D5","v":-417},null,null,null,null,null,null,"Sam",2435,2852,{"$f":"M5-N5","v":-417}]
[null,"Adam",4025,2493,{"$f":"C6-D6","v":1532},null,null,null,null,null,null,"Adam",4025,2493,{"$f":"M6-N6","v":1532}]
[null,"Anna",4767,4743,24,null,null,null,null,null,null,"Anna",4767,4743,24]
[null,"Harry",4533,3294,1239,null,null,null,null,null,null,"Harry",4533,3294,1239]
[null,"Tyler",1591,3796,-2205,null,null,null,null,null,null,"Tyler",1591,3796,-2205]
[null,"Will",3660,3574,86,null,null,null,null,null,null,"Will",3660,3574,86]
[null,"Smith",2092,1160,932,null,null,null,null,null,null,"Smith",2092,1160,932]
[null,"Julie",2914,1378,1536,null,null,null,null,null,null,"Julie",2914,1378,1536]
[null,"Gloria",2652,4789,-2137,null,null,null,null,null,null,"Gloria",2652,4789,-2137]
[null,"Mary",1096,2350,-1254,null,null,null,null,null,null,"Mary",1096,2350,-1254]

{"sheet":"Double-Clicking Fill Handle","index":2,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Double-Clicking Fill Handle Tool",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","2022 Sales","2021 Sales","Difference",null,null,null,null,null,null,"Name","2022 Sales","2021 Sales","Difference"]
[null,"Sam",2435,2852,{"$f":"C5-D5","v":-417},null,null,null,null,null,null,"Sam",2435,2852,{"$f":"M5-N5","v":-417}]
[null,"Adam",4025,2493,{"$f":"C6-D6","v":1532},null,null,null,null,null,null,"Adam",4025,2493,{"$f":"M6-N6","v":1532}]
[null,"Anna",4767,4743,24,null,null,null,null,null,null,"Anna",4767,4743,24]
[null,"Harry",4533,3294,1239,null,null,null,null,null,null,"Harry",4533,3294,1239]
[null,"Tyler",1591,3796,-2205,null,null,null,null,null,null,"Tyler",1591,3796,-2205]
[null,"Will",3660,3574,86,null,null,null,null,null,null,"Will",3660,3574,86]
[null,"Smith",2092,1160,932,null,null,null,null,null,null,"Smith",2092,1160,932]
[null,"Julie",2914,1378,1536,null,null,null,null,null,null,"Julie",2914,1378,1536]
[null,"Gloria",2652,4789,-2137,null,null,null,null,null,null,"Gloria",2652,4789,-2137]
[null,"Mary",1096,2350,-1254,null,null,null,null,null,null,"Mary",1096,2350,-1254]

{"sheet":"Keyboard Shortcut","index":3,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using Keyboard Shortcut",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","2022 Sales","2021 Sales","Difference",null,null,null,null,null,null,"Name","2022 Sales","2021 Sales","Difference"]
[null,"Sam",2435,2852,{"$f":"C5-D5","v":-417},null,null,null,null,null,null,"Sam",2435,2852,{"$f":"M5-N5","v":-417}]
[null,"Adam",4025,2493,{"$f":"C6-D6","v":1532},null,null,null,null,null,null,"Adam",4025,2493,{"$f":"M6-N6","v":1532}]
[null,"Anna",4767,4743,24,null,null,null,null,null,null,"Anna",4767,4743,24]
[null,"Harry",4533,3294,1239,null,null,null,null,null,null,"Harry",4533,3294,1239]
[null,"Tyler",1591,3796,-2205,null,null,null,null,null,null,"Tyler",1591,3796,-2205]
[null,"Will",3660,3574,86,null,null,null,null,null,null,"Will",3660,3574,86]
[null,"Smith",2092,1160,932,null,null,null,null,null,null,"Smith",2092,1160,932]
[null,"Julie",2914,1378,1536,null,null,null,null,null,null,"Julie",2914,1378,1536]
[null,"Gloria",2652,4789,-2137,null,null,null,null,null,null,"Gloria",2652,4789,-2137]
[null,"Mary",1096,2350,-1254,null,null,null,null,null,null,"Mary",1096,2350,-1254]

{"sheet":"Fill Option","index":4,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using Fill Option",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","2022 Sales","2021 Sales","Difference",null,null,null,null,null,null,"Name","2022 Sales","2021 Sales","Difference"]
[null,"Sam",2435,2852,{"$f":"C5-D5","v":-417},null,null,null,null,null,null,"Sam",2435,2852,{"$f":"M5-N5","v":-417}]
[null,"Adam",4025,2493,{"$f":"C6-D6","v":1532},null,null,null,null,null,null,"Adam",4025,2493,{"$f":"M6-N6","v":1532}]
[null,"Anna",4767,4743,24,null,null,null,null,null,null,"Anna",4767,4743,24]
[null,"Harry",4533,3294,1239,null,null,null,null,null,null,"Harry",4533,3294,1239]
[null,"Tyler",1591,3796,-2205,null,null,null,null,null,null,"Tyler",1591,3796,-2205]
[null,"Will",3660,3574,86,null,null,null,null,null,null,"Will",3660,3574,86]
[null,"Smith",2092,1160,932,null,null,null,null,null,null,"Smith",2092,1160,932]
[null,"Julie",2914,1378,1536,null,null,null,null,null,null,"Julie",2914,1378,1536]
[null,"Gloria",2652,4789,-2137,null,null,null,null,null,null,"Gloria",2652,4789,-2137]
[null,"Mary",1096,2350,-1254,null,null,null,null,null,null,"Mary",1096,2350,-1254]

{"sheet":"Copy and Paste Formula","index":5,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Copying and Pasting Formula",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","2022 Sales","2021 Sales","Difference",null,null,null,null,null,null,"Name","2022 Sales","2021 Sales","Difference"]
[null,"Sam",2435,2852,{"$f":"C5-D5","v":-417},null,null,null,null,null,null,"Sam",2435,2852,{"$f":"M5-N5","v":-417}]
[null,"Adam",4025,2493,{"$f":"C6-D6","v":1532},null,null,null,null,null,null,"Adam",4025,2493,{"$f":"M6-N6","v":1532}]
[null,"Anna",4767,4743,24,null,null,null,null,null,null,"Anna",4767,4743,24]
[null,"Harry",4533,3294,1239,null,null,null,null,null,null,"Harry",4533,3294,1239]
[null,"Tyler",1591,3796,-2205,null,null,null,null,null,null,"Tyler",1591,3796,-2205]
[null,"Will",3660,3574,86,null,null,null,null,null,null,"Will",3660,3574,86]
[null,"Smith",2092,1160,932,null,null,null,null,null,null,"Smith",2092,1160,932]
[null,"Julie",2914,1378,1536,null,null,null,null,null,null,"Julie",2914,1378,1536]
[null,"Gloria",2652,4789,-2137,null,null,null,null,null,null,"Gloria",2652,4789,-2137]
[null,"Mary",1096,2350,-1254,null,null,null,null,null,null,"Mary",1096,2350,-1254]

{"sheet":"Array Formula","index":6,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using Array Formula",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","2022 Sales","2021 Sales","Difference",null,null,null,null,null,null,"Name","2022 Sales","2021 Sales","Difference"]
[null,"Sam",2435,2852,{"$f":"C5:C14-D5:D14","v":-417},null,null,null,null,null,null,"Sam",2435,2852,{"$f":"M5-N5","v":-417}]
[null,"Adam",4025,2493,1532,null,null,null,null,null,null,"Adam",4025,2493,{"$f":"M6-N6","v":1532}]
[null,"Anna",4767,4743,24,null,null,null,null,null,null,"Anna",4767,4743,24]
[null,"Harry",4533,3294,1239,null,null,null,null,null,null,"Harry",4533,3294,1239]
[null,"Tyler",1591,3796,-2205,null,null,null,null,null,null,"Tyler",1591,3796,-2205]
[null,"Will",3660,3574,86,null,null,null,null,null,null,"Will",3660,3574,86]
[null,"Smith",2092,1160,932,null,null,null,null,null,null,"Smith",2092,1160,932]
[null,"Julie",2914,1378,1536,null,null,null,null,null,null,"Julie",2914,1378,1536]
[null,"Gloria",2652,4789,-2137,null,null,null,null,null,null,"Gloria",2652,4789,-2137]
[null,"Mary",1096,2350,-1254,null,null,null,null,null,null,"Mary",1096,2350,-1254]

{"sheet":"Insert Formula along Entire Row","index":7,"n_rows":7,"n_cols":29,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,11],[1,18,1,28]]}
[]
[null,"Inserting Formula Across Entire Row",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Sam","Adam","Anna","Harry","Tyler","Will","Smith","Julie","Gloria","Mary",null,null,null,null,null,null,"Name","Sam","Adam","Anna","Harry","Tyler","Will","Smith","Julie","Gloria","Mary"]
[null,"2022 Sales",2435,4025,4767,4533,1591,3660,2092,2914,2652,1096,null,null,null,null,null,null,"2022 Sales",2435,4025,4767,4533,1591,3660,2092,2914,2652,1096]
[null,"2021 Sales",2852,2493,4743,3294,3796,3574,1160,1378,4789,2350,null,null,null,null,null,null,"2021 Sales",2852,2493,4743,3294,3796,3574,1160,1378,4789,2350]
[null,"Difference",{"$f":"C5-C6","v":-417},{"$f":"D5-D6","v":1532},24,1239,-2205,86,932,1536,-2137,-1254,null,null,null,null,null,null,"Difference"]

{"sheet":"VBA Code","index":8,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Applying VBA code",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","2022 Sales","2021 Sales","Difference",null,null,null,null,null,null,"Name","2022 Sales","2021 Sales","Difference"]
[null,"Sam",2435,2852,{"$f":"C5-D5","v":-417},null,null,null,null,null,null,"Sam",2435,2852,{"$f":"M5-N5","v":-417}]
[null,"Adam",4025,2493,{"$f":"C6-D6","v":1532},null,null,null,null,null,null,"Adam",4025,2493,{"$f":"M6-N6","v":1532}]
[null,"Anna",4767,4743,24,null,null,null,null,null,null,"Anna",4767,4743,24]
[null,"Harry",4533,3294,1239,null,null,null,null,null,null,"Harry",4533,3294,1239]
[null,"Tyler",1591,3796,-2205,null,null,null,null,null,null,"Tyler",1591,3796,-2205]
[null,"Will",3660,3574,86,null,null,null,null,null,null,"Will",3660,3574,86]
[null,"Smith",2092,1160,932,null,null,null,null,null,null,"Smith",2092,1160,932]
[null,"Julie",2914,1378,1536,null,null,null,null,null,null,"Julie",2914,1378,1536]
[null,"Gloria",2652,4789,-2137,null,null,null,null,null,null,"Gloria",2652,4789,-2137]
[null,"Mary",1096,2350,-1254,null,null,null,null,null,null,"Mary",1096,2350,-1254]