{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Aggregate","SUBTOTAL","VBA","Practice"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Introduction","index":0,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Fill Down Sequence Numbers Skip Hidden Rows"]
[]
[null,"Serial No","Month","Employee ID","Salary"]
[null,null,"January","E101",35000]
[null,null,"January","E102",25000]
[null,null,"January","E103",30000]
[null,null,"January","E104",40000]
[null,null,"February","E101",35000]
[null,null,"February","E102",25000]
[null,null,"February","E103",30000]
[null,null,"February","E104",40000]
[null,null,"March","E101",35000]
[null,null,"March","E102",25000]
[null,null,"March","E103",30000]
[null,null,"March","E104",40000]

{"sheet":"Aggregate","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Fill Down Sequence Numbers Skip Hidden Rows"]
[]
[null,"Serial No","Month","Employee ID","Salary"]
[null,{"$f":"(_xlfn.AGGREGATE(2,7,$B$4:B4))+1","v":1},"January","E101",35000]
[null,{"$f":"(_xlfn.AGGREGATE(2,7,$B$4:B5))+1","v":2},"January","E102",25000]
[null,{"$f":"(_xlfn.AGGREGATE(2,7,$B$4:B6))+1","v":3},"January","E103",30000]
[null,{"$f":"(_xlfn.AGGREGATE(2,7,$B$4:B7))+1","v":4},"January","E104",40000]
[null,{"$f":"(_xlfn.AGGREGATE(2,7,$B$4:B8))+1","v":5},"February","E101",35000]
[null,{"$f":"(_xlfn.AGGREGATE(2,7,$B$4:B9))+1","v":6},"February","E102",25000]
[null,{"$f":"(_xlfn.AGGREGATE(2,7,$B$4:B10))+1","v":6},"February","E103",30000]
[null,{"$f":"(_xlfn.AGGREGATE(2,7,$B$4:B11))+1","v":6},"February","E104",40000]
[null,{"$f":"(_xlfn.AGGREGATE(2,7,$B$4:B12))+1","v":7},"March","E101",35000]
[null,{"$f":"(_xlfn.AGGREGATE(2,7,$B$4:B13))+1","v":8},"March","E102",25000]
[null,{"$f":"(_xlfn.AGGREGATE(2,7,$B$4:B14))+1","v":9},"March","E103",30000]
[null,{"$f":"(_xlfn.AGGREGATE(2,7,$B$4:B15))+1","v":10},"March","E104",40000]

{"sheet":"SUBTOTAL","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Fill Down Sequence Numbers Skip Hidden Rows"]
[]
[null,"Serial No","Month","Employee ID","Salary"]
[null,{"$f":"SUBTOTAL(103,$C$5:C5)","v":1},"January","E101",35000]
[null,{"$f":"SUBTOTAL(103,$C$5:C6)","v":2},"January","E102",25000]
[null,{"$f":"SUBTOTAL(103,$C$5:C7)","v":3},"January","E103",30000]
[null,{"$f":"SUBTOTAL(103,$C$5:C8)","v":4},"January","E104",40000]
[null,{"$f":"SUBTOTAL(103,$C$5:C9)","v":5},"February","E101",35000]
[null,{"$f":"SUBTOTAL(103,$C$5:C10)","v":5},"February","E102",25000]
[null,{"$f":"SUBTOTAL(103,$C$5:C11)","v":5},"February","E103",30000]
[null,{"$f":"SUBTOTAL(103,$C$5:C12)","v":6},"February","E104",40000]
[null,{"$f":"SUBTOTAL(103,$C$5:C13)","v":7},"March","E101",35000]
[null,{"$f":"SUBTOTAL(103,$C$5:C14)","v":8},"March","E102",25000]
[null,{"$f":"SUBTOTAL(103,$C$5:C15)","v":9},"March","E103",30000]
[null,{"$f":"SUBTOTAL(103,$C$5:C16)","v":10},"March","E104",40000]

{"sheet":"VBA","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Fill Down Sequence Numbers Skip Hidden Rows"]
[]
[null,"Serial No","Month","Employee ID","Salary"]
[null,1,"January","E101",35000]
[null,2,"January","E102",25000]
[null,3,"January","E103",30000]
[null,4,"January","E104",40000]
[null,5,"February","E101",35000]
[null,null,"February","E102",25000]
[null,null,"February","E103",30000]
[null,6,"February","E104",40000]
[null,7,"March","E101",35000]
[null,8,"March","E102",25000]
[null,9,"March","E103",30000]
[null,10,"March","E104",40000]

{"sheet":"Practice","index":4,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,">> Practice Yourself >>"]
[]
[null,"Serial No","Month","Employee ID","Salary"]
[null,null,"January","E101",35000]
[null,null,"January","E102",25000]
[null,null,"January","E103",30000]
[null,null,"January","E104",40000]
[null,null,"February","E101",35000]
[null,null,"February","E102",25000]
[null,null,"February","E103",30000]
[null,null,"February","E104",40000]
[null,null,"March","E101",35000]
[null,null,"March","E102",25000]
[null,null,"March","E103",30000]
[null,null,"March","E104",40000]