{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","COUNTIF Function Method","SUMPRODUCT Function Method","Pivot Table Method","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":2},"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":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Counting Occurrences per Day"]
[]
[null,"Employee Name","Joining Date"]
[null,"Rob","2021-08-11"]
[null,"Bran","2021-10-10"]
[null,"Tom","2021-05-11"]
[null,"Scarlet","2021-10-10"]
[null,"John","2021-05-11"]
[null,"Hank","2021-08-11"]
[null,"Rody","2021-10-10"]
[null,"Jack","2021-08-11"]

{"sheet":"COUNTIF Function Method","index":1,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,5],[2,8,2,12]]}
[]
[]
[null,"Counting Occurrences per Day",null,null,null,null,null,null,"Counting Occurrences per Day"]
[]
[null,"Employee Name","Joining Date",null,"Date","Occurrence",null,null,"Employee Name","Joining Date",null,"Date","Occurrence"]
[null,"Rob","2021-08-11",null,"2021-08-11",{"$f":"COUNTIF(C6:C13,E6)","v":3},null,null,"Rob","2021-08-11"]
[null,"Bran","2021-10-10",null,null,null,null,null,"Bran","2021-10-10"]
[null,"Tom","2021-05-11",null,null,null,null,null,"Tom","2021-05-11"]
[null,"Scarlet","2021-10-10",null,null,null,null,null,"Scarlet","2021-10-10"]
[null,"John","2021-05-11",null,null,null,null,null,"John","2021-05-11"]
[null,"Hank","2021-08-11",null,null,null,null,null,"Hank","2021-08-11"]
[null,"Rody","2021-10-10",null,null,null,null,null,"Rody","2021-10-10"]
[null,"Jack","2021-08-11",null,null,null,null,null,"Jack","2021-08-11"]

{"sheet":"SUMPRODUCT Function Method","index":2,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,5],[2,7,2,11]]}
[]
[]
[null,"Counting Occurrences per Day",null,null,null,null,null,"Counting Occurrences per Day"]
[]
[null,"Employee Name","Joining Date",null,"Date","Occurrence",null,"Employee Name","Joining Date",null,"Date","Occurrence"]
[null,"Rob","2021-08-11",null,"2021-08-11",{"$f":"SUMPRODUCT(--(C6:C13=E6))","v":3},null,"Rob","2021-08-11"]
[null,"Bran","2021-10-10",null,null,null,null,"Bran","2021-10-10"]
[null,"Tom","2021-05-11",null,null,null,null,"Tom","2021-05-11"]
[null,"Scarlet","2021-10-10",null,null,null,null,"Scarlet","2021-10-10"]
[null,"John","2021-05-11",null,null,null,null,"John","2021-05-11"]
[null,"Hank","2021-08-11",null,null,null,null,"Hank","2021-08-11"]
[null,"Rody","2021-10-10",null,null,null,null,"Rody","2021-10-10"]
[null,"Jack","2021-08-11",null,null,null,null,"Jack","2021-08-11"]

{"sheet":"Pivot Table Method","index":3,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,5],[2,7,2,11]]}
[]
[]
[null,"Counting Occurrences per Day",null,null,null,null,null,"Counting Occurrences per Day"]
[]
[null,"Employee Name","Joining Date",null,"Row Labels","Count of Order Date",null,"Employee Name","Joining Date",null,"Row Labels","Count of Order Date"]
[null,"Rob","2021-08-11",null,"11-May",2,null,"Rob","2021-08-11",null,"11-May",2]
[null,"Bran","2021-10-10",null,"11-Aug",3,null,"Bran","2021-10-10",null,"11-Aug",3]
[null,"Tom","2021-05-11",null,"10-Oct",3,null,"Tom","2021-05-11",null,"10-Oct",3]
[null,"Scarlet","2021-10-10",null,"Grand Total",8,null,"Scarlet","2021-10-10",null,"Grand Total",8]
[null,"John","2021-05-11",null,null,null,null,"John","2021-05-11"]
[null,"Hank","2021-08-11",null,null,null,null,"Hank","2021-08-11"]
[null,"Rody","2021-10-10",null,null,null,null,"Rody","2021-10-10"]
[null,"Jack","2021-08-11",null,null,null,null,"Jack","2021-08-11"]

{"sheet":"VBA","index":4,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,5],[2,7,2,11]]}
[]
[]
[null,"Counting Occurrences per Day",null,null,null,null,null,"Counting Occurrences per Day"]
[]
[null,"Employee Name","Joining Date",null,"Date","Occurrence",null,"Employee Name","Joining Date",null,"Date","Occurrence"]
[null,"Rob","2021-08-11",null,"2021-08-11",3,null,"Rob","2021-08-11"]
[null,"Bran","2021-10-10",null,null,null,null,"Bran","2021-10-10"]
[null,"Tom","2021-05-11",null,null,null,null,"Tom","2021-05-11"]
[null,"Scarlet","2021-10-10",null,null,null,null,"Scarlet","2021-10-10"]
[null,"John","2021-05-11",null,null,null,null,"John","2021-05-11"]
[null,"Hank","2021-08-11",null,null,null,null,"Hank","2021-08-11"]
[null,"Rody","2021-10-10",null,null,null,null,"Rody","2021-10-10"]
[null,"Jack","2021-08-11",null,null,null,null,"Jack","2021-08-11"]