{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["1st Example"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"1st Example","index":0,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Student ID",1,2,3,4,5,null,"Student ID","Y","N"]
["A","Y","N","N","N","Y",null,"E",{"$f":"COUNTIF(INDIRECT(\"B\"&MATCH($H2,$A$2:$A$6)+ROW($A$2)-1&\":F\"&MATCH($H2,$A$2:$A$6)+ROW($A$2)-1),I$1)","v":3},{"$f":"COUNTIF(INDIRECT(\"B\"&MATCH($H2,$A$2:$A$6)+ROW($A$2)-1&\":F\"&MATCH($H2,$A$2:$A$6)+ROW($A$2)-1),J$1)","v":2}]
["B","Y","Y","N","N","Y",null,"A",{"$f":"COUNTIF(INDIRECT(\"B\"&MATCH($H3,$A$2:$A$6)+ROW($A$2)-1&\":F\"&MATCH($H3,$A$2:$A$6)+ROW($A$2)-1),I$1)","v":2},3]
["C","N","Y","Y","Y","N",null,"B",3,2]
["D","Y","N","Y","N","Y",null,"C",3,2]
["E","Y","N","Y","Y","N",null,"D",3,2]