{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dataset","PivotTable Option","VBA","Refresh Option"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":3},"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":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sample Dataset"]
[]
[null,"Employee","Employee ID","Department"]
[null,"Adam","S-102","Sales"]
[null,"Jhon","F-105","Finance"]
[null,"Alisa","S-108","Sales"]
[null,"Mark","H-107","Human Resource"]
[null,"Harry","F-106","Finance"]
[null,"Penny","H-101","Human Resource"]
[null,"Merry","F-112","Finance"]
[null,"Alex","S-104","Sales"]

{"sheet":"PivotTable Option","index":1,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,9],[1,11,1,13]]}
[]
[null,"Using PivotTable Options",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Employee","Employee ID","Department",null,"Count of Employee ID","Column Labels",null,null,null,null,"Employee","Employee ID","Department"]
[null,"Adam","S-102","Sales",null,"Row Labels","Finance","Human Resource","Sales","Grand Total",null,"Adam","S-102","Sales"]
[null,"Jhon","F-105","Finance",null,"Adam",null,null,1,1,null,"Jhon","F-105","Finance"]
[null,"Alisa","S-108","Sales",null,"Alisa",null,null,1,1,null,"Alisa","S-108","Sales"]
[null,"Mark","H-107","Human Resource",null,"Harry",1,null,null,1,null,"Mark","H-107","Human Resource"]
[null,"Harry","F-106","Finance",null,"Jhon",1,null,null,1,null,"Harry","F-106","Finance"]
[null,"Penny","H-101","Human Resource",null,"Mark",null,1,null,1,null,"Penny","H-101","Human Resource"]
[null,null,null,null,null,"Penny",null,1,null,1,null,"Merry","F-112","Finance"]
[null,null,null,null,null,"Grand Total",2,2,2,6,null,"Alex","S-104","Sales"]

{"sheet":"VBA","index":2,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,9],[1,11,1,13]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Employee","Employee ID","Department",null,"Count of Employee ID","Column Labels",null,null,null,null,"Employee","Employee ID","Department"]
[null,"Adam","S-102","Sales",null,"Row Labels","Finance","Human Resource","Sales","Grand Total",null,"Adam","S-102","Sales"]
[null,"Jhon","F-105","Finance",null,"Adam",null,null,1,1,null,"Jhon","F-105","Finance"]
[null,"Alisa","S-108","Sales",null,"Alisa",null,null,1,1,null,"Alisa","S-108","Sales"]
[null,"Mark","H-107","Human Resource",null,"Harry",1,null,null,1,null,"Mark","H-107","Human Resource"]
[null,"Harry","F-106","Finance",null,"Jhon",1,null,null,1,null,"Harry","F-106","Finance"]
[null,"Penny","H-101","Human Resource",null,"Mark",null,1,null,1,null,"Penny","H-101","Human Resource"]
[null,null,null,null,null,"Penny",null,1,null,1,null,"Merry","F-112","Finance"]
[null,null,null,null,null,"Grand Total",2,2,2,6,null,"Alex","S-104","Sales"]

{"sheet":"Refresh Option","index":3,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,9],[1,11,1,13]]}
[]
[null,"Using Refresh Option",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Employee","Employee ID","Department",null,"Count of Employee ID","Column Labels",null,null,null,null,"Employee","Employee ID","Department"]
[null,"Adam","S-102","Sales",null,"Row Labels","Finance","Human Resource","Sales","Grand Total",null,"Adam","S-102","Sales"]
[null,"Jhon","F-105","Finance",null,"Adam",null,null,1,1,null,"Jhon","F-105","Finance"]
[null,"Alisa","S-108","Sales",null,"Alisa",null,null,1,1,null,"Alisa","S-108","Sales"]
[null,"Mark","H-107","Human Resource",null,"Harry",1,null,null,1,null,"Mark","H-107","Human Resource"]
[null,"Harry","F-106","Finance",null,"Jhon",1,null,null,1,null,"Harry","F-106","Finance"]
[null,"Penny","H-101","Human Resource",null,"Mark",null,1,null,1,null,"Penny","H-101","Human Resource"]
[null,null,null,null,null,"Penny",null,1,null,1,null,"Merry","F-112","Finance"]
[null,null,null,null,null,"Grand Total",2,2,2,6,null,"Alex","S-104","Sales"]