{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["main dataset","Filter","Daniel Defoe (1)","Henry Jackson (1)","Donald Paul (1)","Pivot table","Daniel Defoe (2)","Henry Jackson (2)","Donald Paul (2)","pivot"," Daniel Defoe (3)","Henry Jackson (3)","Donald Paul (3)","Daniel Defoe (4)","Henry Jackson (4)","Donald Paul (4)","VBA","Daniel Defoe","Henry Jackson","Donald Paul","practice"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":4},"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":"main dataset","index":0,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"\"XYZ\" College"]
[]
[null,"Student Name","Subject","Grade"]
[null,"Daniel Defoe","Physics ","A"]
[null,"Daniel Defoe","Chemistry","B"]
[null,"Daniel Defoe","Math","A"]
[null,"Daniel Defoe","Biology","C"]
[null,"Henry Jackson","Physics ","A"]
[null,"Henry Jackson","Chemistry","A"]
[null,"Henry Jackson","Math","D"]
[null,"Henry Jackson","Biology","C"]
[null,"Donald Paul","Physics ","A"]
[null,"Donald Paul","Chemistry","A"]
[null,"Donald Paul","Math","A"]
[null,"Donald Paul","Biology","B"]

{"sheet":"Filter","index":1,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FILTER function"]
[]
[null,"Student Name","Subject","Grade"]
[null,"Daniel Defoe","Physics ","A"]
[null,"Daniel Defoe","Chemistry","B"]
[null,"Daniel Defoe","Math","A"]
[null,"Daniel Defoe","Biology","C"]
[null,"Henry Jackson","Physics ","A"]
[null,"Henry Jackson","Chemistry","A"]
[null,"Henry Jackson","Math","D"]
[null,"Henry Jackson","Biology","C"]
[null,"Donald Paul","Physics ","A"]
[null,"Donald Paul","Chemistry","A"]
[null,"Donald Paul","Math","A"]
[null,"Donald Paul","Biology","B"]

{"sheet":"Daniel Defoe (1)","index":2,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Student Name","Subject","Grade"]
[null,{"$f":"_xlfn._xlws.FILTER(Filter!B5:D16,Filter!B5:B16=\"Daniel Defoe\")","v":"Daniel Defoe"},"Physics ","A"]
[null,"Daniel Defoe","Chemistry","B"]
[null,"Daniel Defoe","Math","A"]
[null,"Daniel Defoe","Biology","C"]

{"sheet":"Henry Jackson (1)","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Student Name","Subject","Grade"]
[null,{"$f":"_xlfn._xlws.FILTER(Filter!B5:D16,Filter!B5:B16=\"Henry Jackson\")","v":"Henry Jackson"},"Physics ","A"]
[null,"Henry Jackson","Chemistry","A"]
[null,"Henry Jackson","Math","D"]
[null,"Henry Jackson","Biology","C"]

{"sheet":"Donald Paul (1)","index":4,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Student Name","Subject","Grade"]
[null,{"$f":"_xlfn._xlws.FILTER(Filter!B5:D16,Filter!B5:B16=\"Donald Paul\")","v":"Donald Paul"},"Physics ","A"]
[null,"Donald Paul","Chemistry","A"]
[null,"Donald Paul","Math","A"]
[null,"Donald Paul","Biology","B"]

{"sheet":"Pivot table","index":5,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Pivot Table"]
[]
[null,"Student Name","Subject","Grade"]
[null,"Daniel Defoe","Physics ","A"]
[null,"Daniel Defoe","Chemistry","B"]
[null,"Daniel Defoe","Math","A"]
[null,"Daniel Defoe","Biology","C"]
[null,"Henry Jackson","Physics ","A"]
[null,"Henry Jackson","Chemistry","A"]
[null,"Henry Jackson","Math","D"]
[null,"Henry Jackson","Biology","C"]
[null,"Donald Paul","Physics ","A"]
[null,"Donald Paul","Chemistry","A"]
[null,"Donald Paul","Math","A"]
[null,"Donald Paul","Biology","B"]

{"sheet":"Daniel Defoe (2)","index":6,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Student Name","Daniel Defoe"]
[]
["Subject","Grade"]
["Biology"]
[null,"C"]
["Chemistry"]
[null,"B"]
["Math"]
[null,"A"]
["Physics "]
[null,"A"]

{"sheet":"Henry Jackson (2)","index":7,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Student Name","Henry Jackson"]
[]
["Subject","Grade"]
["Biology"]
[null,"C"]
["Chemistry"]
[null,"A"]
["Math"]
[null,"D"]
["Physics "]
[null,"A"]

{"sheet":"Donald Paul (2)","index":8,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Student Name","Donald Paul"]
[]
["Subject","Grade"]
["Biology"]
[null,"B"]
["Chemistry"]
[null,"A"]
["Math"]
[null,"A"]
["Physics "]
[null,"A"]

{"sheet":"pivot","index":9,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Student Name","(All)"]
[]
["Subject","Grade"]
["Biology"]
[null,"B"]
[null,"C"]
["Chemistry"]
[null,"A"]
[null,"B"]
["Math"]
[null,"A"]
[null,"D"]
["Physics "]
[null,"A"]

{"sheet":" Daniel Defoe (3)","index":10,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," Table Option"]
[]
[null,"Student Name","Subject","Grade"]
[null,"Daniel Defoe","Physics ","A"]
[null,"Daniel Defoe","Chemistry","B"]
[null,"Daniel Defoe","Math","A"]
[null,"Daniel Defoe","Biology","C"]
[null,"Henry Jackson","Physics ","A"]
[null,"Henry Jackson","Chemistry","A"]
[null,"Henry Jackson","Math","D"]
[null,"Henry Jackson","Biology","C"]
[null,"Donald Paul","Physics ","A"]
[null,"Donald Paul","Chemistry","A"]
[null,"Donald Paul","Math","A"]
[null,"Donald Paul","Biology","B"]

{"sheet":"Henry Jackson (3)","index":11,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," Table Option"]
[]
[null,"Student Name","Subject","Grade"]
[null,"Daniel Defoe","Physics ","A"]
[null,"Daniel Defoe","Chemistry","B"]
[null,"Daniel Defoe","Math","A"]
[null,"Daniel Defoe","Biology","C"]
[null,"Henry Jackson","Physics ","A"]
[null,"Henry Jackson","Chemistry","A"]
[null,"Henry Jackson","Math","D"]
[null,"Henry Jackson","Biology","C"]
[null,"Donald Paul","Physics ","A"]
[null,"Donald Paul","Chemistry","A"]
[null,"Donald Paul","Math","A"]
[null,"Donald Paul","Biology","B"]

{"sheet":"Donald Paul (3)","index":12,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," Table Option"]
[]
[null,"Student Name","Subject","Grade"]
[null,"Daniel Defoe","Physics ","A"]
[null,"Daniel Defoe","Chemistry","B"]
[null,"Daniel Defoe","Math","A"]
[null,"Daniel Defoe","Biology","C"]
[null,"Henry Jackson","Physics ","A"]
[null,"Henry Jackson","Chemistry","A"]
[null,"Henry Jackson","Math","D"]
[null,"Henry Jackson","Biology","C"]
[null,"Donald Paul","Physics ","A"]
[null,"Donald Paul","Chemistry","A"]
[null,"Donald Paul","Math","A"]
[null,"Donald Paul","Biology","B"]

{"sheet":"Daniel Defoe (4)","index":13,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Filter Option"]
[]
[null,"Student Name","Subject","Grade"]
[null,"Henry Jackson","Physics ","A"]
[null,"Henry Jackson","Chemistry","A"]
[null,"Henry Jackson","Math","D"]
[null,"Henry Jackson","Biology","C"]
[null,"Donald Paul","Physics ","A"]
[null,"Donald Paul","Chemistry","A"]
[null,"Donald Paul","Math","A"]
[null,"Donald Paul","Biology","B"]
[null,"Daniel Defoe","Physics ","A"]
[null,"Daniel Defoe","Chemistry","B"]
[null,"Daniel Defoe","Math","A"]
[null,"Daniel Defoe","Biology","C"]

{"sheet":"Henry Jackson (4)","index":14,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Filter Option"]
[]
[null,"Student Name","Subject","Grade"]
[null,"Daniel Defoe","Physics ","A"]
[null,"Daniel Defoe","Chemistry","B"]
[null,"Daniel Defoe","Math","A"]
[null,"Daniel Defoe","Biology","C"]
[null,"Henry Jackson","Physics ","A"]
[null,"Henry Jackson","Chemistry","A"]
[null,"Henry Jackson","Math","D"]
[null,"Henry Jackson","Biology","C"]
[null,"Donald Paul","Physics ","A"]
[null,"Donald Paul","Chemistry","A"]
[null,"Donald Paul","Math","A"]
[null,"Donald Paul","Biology","B"]

{"sheet":"Donald Paul (4)","index":15,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Filter Option"]
[]
[null,"Student Name","Subject","Grade"]
[null,"Daniel Defoe","Physics ","A"]
[null,"Daniel Defoe","Chemistry","B"]
[null,"Daniel Defoe","Math","A"]
[null,"Daniel Defoe","Biology","C"]
[null,"Henry Jackson","Physics ","A"]
[null,"Henry Jackson","Chemistry","A"]
[null,"Henry Jackson","Math","D"]
[null,"Henry Jackson","Biology","C"]
[null,"Donald Paul","Physics ","A"]
[null,"Donald Paul","Chemistry","A"]
[null,"Donald Paul","Math","A"]
[null,"Donald Paul","Biology","B"]

{"sheet":"VBA","index":16,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"VBA Code"]
[]
[null,"Student Name","Subject","Grade"]
[null,"Daniel Defoe","Physics ","A"]
[null,"Daniel Defoe","Chemistry","B"]
[null,"Daniel Defoe","Math","A"]
[null,"Daniel Defoe","Biology","C"]
[null,"Henry Jackson","Physics ","A"]
[null,"Henry Jackson","Chemistry","A"]
[null,"Henry Jackson","Math","D"]
[null,"Henry Jackson","Biology","C"]
[null,"Donald Paul","Physics ","A"]
[null,"Donald Paul","Chemistry","A"]
[null,"Donald Paul","Math","A"]
[null,"Donald Paul","Biology","B"]

{"sheet":"Daniel Defoe","index":17,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Student Name","Subject","Grade"]
["Daniel Defoe","Physics ","A"]
["Daniel Defoe","Chemistry","B"]
["Daniel Defoe","Math","A"]
["Daniel Defoe","Biology","C"]

{"sheet":"Henry Jackson","index":18,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Student Name","Subject","Grade"]
["Henry Jackson","Physics ","A"]
["Henry Jackson","Chemistry","A"]
["Henry Jackson","Math","D"]
["Henry Jackson","Biology","C"]

{"sheet":"Donald Paul","index":19,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Student Name","Subject","Grade"]
["Donald Paul","Physics ","A"]
["Donald Paul","Chemistry","A"]
["Donald Paul","Math","A"]
["Donald Paul","Biology","B"]

{"sheet":"practice","index":20,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Practice"]
[]
[null,"Student Name","Subject","Grade"]
[null,"Daniel Defoe","Physics ","A"]
[null,"Daniel Defoe","Chemistry","B"]
[null,"Daniel Defoe","Math","A"]
[null,"Daniel Defoe","Biology","C"]
[null,"Henry Jackson","Physics ","A"]
[null,"Henry Jackson","Chemistry","A"]
[null,"Henry Jackson","Math","D"]
[null,"Henry Jackson","Biology","C"]
[null,"Donald Paul","Physics ","A"]
[null,"Donald Paul","Chemistry","A"]
[null,"Donald Paul","Math","A"]
[null,"Donald Paul","Biology","B"]