{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Manually","filter","Table","Find","Function","VBA","Practice"],"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":"Dataset","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"\"XYZ\" Company"]
[]
[null,"Item","Sales Person","Region","Sales"]
[null,"Apple","Jonas","North",5979]
[null,"Orange","Michael","South",1559]
[null,"Apple","Richard","North",4588]
[null,"Tomato","Watson","East",4196]
[null,"Lemon","Camelly","West",2436]
[null,"Apple","Jefferson","South",1425]
[null,"Blackberry","Richard","West",5010]
[null,"Apple","Watson","West",1200]

{"sheet":"Manually","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Calculating Percentage Manually"]
[]
[null,"Item","Sales Person","Region","Sales","Color"]
[null,"Apple","Jonas","North",5979,"Yellow"]
[null,"Orange","Michael","South",1559,"White"]
[null,"Apple","Richard","North",4588,"Yellow"]
[null,"Tomato","Watson","East",4196,"White"]
[null,"Lemon","Camelly","West",2436,"White"]
[null,"Apple","Jefferson","South",1425,"Yellow"]
[null,"Blackberry","Richard","West",5010,"White"]
[null,"Apple","Watson","West",1200,"Yellow"]
[]
[null,"Total Rows",{"$f":"COUNTA(B5:B12)","v":8}]
[null,"Colored Rows",{"$f":"COUNTIF(F5:F12,\"Yellow\")","v":4}]
[null,"Percentage",{"$f":"C15/C14","v":0.5}]

{"sheet":"filter","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using Filter Option"]
[]
[null,"Item","Sales Person","Region","Sales"]
[null,"Apple","Jonas","North",5979]
[null,"Orange","Michael","South",1559]
[null,"Apple","Richard","North",4588]
[null,"Tomato","Watson","East",4196]
[null,"Lemon","Camelly","West",2436]
[null,"Apple","Jefferson","South",1425]
[null,"Blackberry","Richard","West",5010]
[null,"Apple","Watson","West",1200]
[]
[null,"Total Rows",{"$f":"COUNTA(B4:B11)","v":8}]
[null,"Colored Rows",{"$f":"SUBTOTAL(3,B4:B11)","v":4}]
[null,"Percentage",{"$f":"C14/C13","v":0.5}]

{"sheet":"Table","index":3,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using Table"]
[]
[null,"Item","Sales Person","Region","Sales"]
[null,"Apple","Jonas","North",5979]
[null,"Orange","Michael","South",1559]
[null,"Apple","Richard","North",4588]
[null,"Tomato","Watson","East",4196]
[null,"Lemon","Camelly","West",2436]
[null,"Apple","Jefferson","South",1425]
[null,"Blackberry","Richard","West",5010]
[null,"Apple","Watson","West",1200]
[]
[null,"Total Rows",{"$f":"COUNTA(Table3[Item])","v":8}]
[null,"Colored Rows",{"$f":"SUBTOTAL(3,Table3[Item])","v":4}]
[null,"Percentage",{"$f":"C14/C13","v":0.5}]

{"sheet":"Find","index":4,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using Find & Select Option"]
[]
[null,"Item","Sales Person","Region","Sales"]
[null,"Apple","Jonas","North",5979]
[null,"Orange","Michael","South",1559]
[null,"Apple","Richard","North",4588]
[null,"Tomato","Watson","East",4196]
[null,"Lemon","Camelly","West",2436]
[null,"Apple","Jefferson","South",1425]
[null,"Blackberry","Richard","West",5010]
[null,"Apple","Watson","West",1200]
[]
[null,"Total Rows",{"$f":"COUNTA(B4:B11)","v":8}]
[null,"Colored Rows",4]
[null,"Percentage",{"$f":"C14/C13","v":0.5}]

{"sheet":"Function","index":5,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using GET.CELL Function"]
[]
[null,"Item","Sales Person","Region","Sales","ColorCode"]
[null,"Apple","Jonas","North",5979,6]
[null,"Orange","Michael","South",1559,0]
[null,"Apple","Richard","North",4588,6]
[null,"Tomato","Watson","East",4196,0]
[null,"Lemon","Camelly","West",2436,0]
[null,"Apple","Jefferson","South",1425,6]
[null,"Blackberry","Richard","West",5010,0]
[null,"Apple","Watson","West",1200,6]
[]
[null,"Total Rows",8]
[null,"Colored Rows",4]
[null,"Percentage",0.5]

{"sheet":"VBA","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using VBA Code"]
[]
[null,"Item","Sales Person","Region","Sales"]
[null,"Apple","Jonas","North",5979]
[null,"Orange","Michael","South",1559]
[null,"Apple","Richard","North",4588]
[null,"Tomato","Watson","East",4196]
[null,"Lemon","Camelly","West",2436]
[null,"Apple","Jefferson","South",1425]
[null,"Blackberry","Richard","West",5010]
[null,"Apple","Watson","West",1200]

{"sheet":"Practice","index":7,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Practice"]
[]
[null,"Item","Sales Person","Region","Sales"]
[null,"Apple","Jonas","North",5979]
[null,"Orange","Michael","South",1559]
[null,"Apple","Richard","North",4588]
[null,"Tomato","Watson","East",4196]
[null,"Lemon","Camelly","West",2436]
[null,"Apple","Jefferson","South",1425]
[null,"Blackberry","Richard","West",5010]
[null,"Apple","Watson","West",1200]