{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Roster","sprint1","sprint2","sprint3","sprint4","mid-semester-feedback","sprint5","sprint6","sprint7","final_feedback"],"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":"Roster","index":0,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Student Name"]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]

{"sheet":"sprint1","index":1,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,10,0,15],[0,9,1,9],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8]]}
[null,"Lecture 1",null,"Lab 1",null,"Lecture 2",null,"Lab 2",null,"Recommended Presence Grade (Use your own discretion when grading)","Notes"]
["Student","Attendance","Participation","Attendance","Participation","Attendance","Participation","Attendance","Participation",null,"General","Task 1","% Complete ","Task 2","% Complete ","Other Tasks (if needed)"]
[{"$f":"Roster!A2","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A",{"$f":"IF(COUNTIF(B3:H3,\"Absent\")>=3, \"Unsatisfactory\",\n IF(COUNTIF(B3:H3,\"Absent\")=2, \"Below Expectations\",\n IF(OR(COUNTIF(B3:H3,\"Absent\")=1,\n        COUNTIF(B3:H3,\"Camera Off\")>0,\n        COUNTIF(C3:I3,\"Poor\")>0), \"Needs Improvement\",\n IF(COUNTIF(C3:I3,\"Exceptional\")>=1, \"Exceeds Expectations\",\n \"Meets Expectations\"))))","v":"Unsatisfactory"},null,null,0,null,0]
[{"$f":"Roster!A3","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A",{"$f":"IF(COUNTIF(B4:H4,\"Absent\")>=3, \"Unsatisfactory\",\n IF(COUNTIF(B4:H4,\"Absent\")=2, \"Below Expectations\",\n IF(OR(COUNTIF(B4:H4,\"Absent\")=1,\n        COUNTIF(B4:H4,\"Camera Off\")>0,\n        COUNTIF(C4:I4,\"Poor\")>0), \"Needs Improvement\",\n IF(COUNTIF(C4:I4,\"Exceptional\")>=1, \"Exceeds Expectations\",\n \"Meets Expectations\"))))","v":"Unsatisfactory"},null,null,0,null,0]
[{"$f":"Roster!A4","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A5","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A6","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A7","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A8","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A9","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A10","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A11","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A12","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A13","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A14","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A15","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A",{"$f":"IF(COUNTIF(B16:H16,\"Absent\")>=3, \"Unsatisfactory\",\n IF(COUNTIF(B16:H16,\"Absent\")=2, \"Below Expectations\",\n IF(OR(COUNTIF(B16:H16,\"Absent\")=1,\n        COUNTIF(B16:H16,\"Camera Off\")>0,\n        COUNTIF(C16:I16,\"Poor\")>0), \"Needs Improvement\",\n IF(COUNTIF(C16:I16,\"Exceptional\")>=1, \"Exceeds Expectations\",\n \"Meets Expectations\"))))","v":"Unsatisfactory"},null,null,0,null,0]
[{"$f":"Roster!A16","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]

{"sheet":"sprint2","index":2,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,10,0,15],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,1,9]]}
[null,"Lecture 1",null,"Lab 1",null,"Lecture 2",null,"Lab 2",null,"Recommended Presence Grade (Use your own discretion when grading)","Notes"]
["Student","Attendance","Participation","Attendance","Participation","Attendance","Participation","Attendance","Participation",null,"General","Task 1","% Complete ","Task 2","% Complete ","Other Tasks (if needed)"]
[{"$f":"Roster!A2","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A",{"$f":"IF(COUNTIF(B3:H3,\"Absent\")>=3, \"Unsatisfactory\",\n IF(COUNTIF(B3:H3,\"Absent\")=2, \"Below Expectations\",\n IF(OR(COUNTIF(B3:H3,\"Absent\")=1,\n        COUNTIF(B3:H3,\"Camera Off\")>0,\n        COUNTIF(C3:I3,\"Poor\")>0), \"Needs Improvement\",\n IF(COUNTIF(C3:I3,\"Exceptional\")>=1, \"Exceeds Expectations\",\n \"Meets Expectations\"))))","v":"Unsatisfactory"},null,null,0,null,0]
[{"$f":"Roster!A3","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A",{"$f":"IF(COUNTIF(B4:H4,\"Absent\")>=3, \"Unsatisfactory\",\n IF(COUNTIF(B4:H4,\"Absent\")=2, \"Below Expectations\",\n IF(OR(COUNTIF(B4:H4,\"Absent\")=1,\n        COUNTIF(B4:H4,\"Camera Off\")>0,\n        COUNTIF(C4:I4,\"Poor\")>0), \"Needs Improvement\",\n IF(COUNTIF(C4:I4,\"Exceptional\")>=1, \"Exceeds Expectations\",\n \"Meets Expectations\"))))","v":"Unsatisfactory"},null,null,0,null,0]
[{"$f":"Roster!A4","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A5","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A6","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A7","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A8","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A9","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A10","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A11","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A12","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A13","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A14","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A15","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A16","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]

{"sheet":"sprint3","index":3,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,10,0,15],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,1,9]]}
[null,"Lecture 1",null,"Lab 1",null,"Lecture 2",null,"Lab 2",null,"Recommended Presence Grade (Use your own discretion when grading)","Notes"]
["Student","Attendance","Participation","Attendance","Participation","Attendance","Participation","Attendance","Participation",null,"General","Task 1","% Complete ","Task 2","% Complete ","Other Tasks (if needed)"]
[{"$f":"Roster!A2","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A",{"$f":"IF(COUNTIF(B3:H3,\"Absent\")>=3, \"Unsatisfactory\",\n IF(COUNTIF(B3:H3,\"Absent\")=2, \"Below Expectations\",\n IF(OR(COUNTIF(B3:H3,\"Absent\")=1,\n        COUNTIF(B3:H3,\"Camera Off\")>0,\n        COUNTIF(C3:I3,\"Poor\")>0), \"Needs Improvement\",\n IF(COUNTIF(C3:I3,\"Exceptional\")>=1, \"Exceeds Expectations\",\n \"Meets Expectations\"))))","v":"Unsatisfactory"},null,null,0,null,0]
[{"$f":"Roster!A3","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A",{"$f":"IF(COUNTIF(B4:H4,\"Absent\")>=3, \"Unsatisfactory\",\n IF(COUNTIF(B4:H4,\"Absent\")=2, \"Below Expectations\",\n IF(OR(COUNTIF(B4:H4,\"Absent\")=1,\n        COUNTIF(B4:H4,\"Camera Off\")>0,\n        COUNTIF(C4:I4,\"Poor\")>0), \"Needs Improvement\",\n IF(COUNTIF(C4:I4,\"Exceptional\")>=1, \"Exceeds Expectations\",\n \"Meets Expectations\"))))","v":"Unsatisfactory"},null,null,0,null,0]
[{"$f":"Roster!A4","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A5","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A6","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A7","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A8","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A9","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A10","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A11","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A12","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A13","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A14","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A15","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A16","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]

{"sheet":"sprint4","index":4,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,10,0,15],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,1,9]]}
[null,"Lecture 1",null,"Lab 1",null,"Lecture 2",null,"Lab 2",null,"Recommended Presence Grade (Use your own discretion when grading)","Notes"]
["Student","Attendance","Participation","Attendance","Participation","Attendance","Participation","Attendance","Participation",null,"General","Task 1","% Complete ","Task 2","% Complete ","Other Tasks (if needed)"]
[{"$f":"Roster!A2","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A",{"$f":"IF(COUNTIF(B3:H3,\"Absent\")>=3, \"Unsatisfactory\",\n IF(COUNTIF(B3:H3,\"Absent\")=2, \"Below Expectations\",\n IF(OR(COUNTIF(B3:H3,\"Absent\")=1,\n        COUNTIF(B3:H3,\"Camera Off\")>0,\n        COUNTIF(C3:I3,\"Poor\")>0), \"Needs Improvement\",\n IF(COUNTIF(C3:I3,\"Exceptional\")>=1, \"Exceeds Expectations\",\n \"Meets Expectations\"))))","v":"Unsatisfactory"},null,null,0,null,0]
[{"$f":"Roster!A3","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A",{"$f":"IF(COUNTIF(B4:H4,\"Absent\")>=3, \"Unsatisfactory\",\n IF(COUNTIF(B4:H4,\"Absent\")=2, \"Below Expectations\",\n IF(OR(COUNTIF(B4:H4,\"Absent\")=1,\n        COUNTIF(B4:H4,\"Camera Off\")>0,\n        COUNTIF(C4:I4,\"Poor\")>0), \"Needs Improvement\",\n IF(COUNTIF(C4:I4,\"Exceptional\")>=1, \"Exceeds Expectations\",\n \"Meets Expectations\"))))","v":"Unsatisfactory"},null,null,0,null,0]
[{"$f":"Roster!A4","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A5","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A6","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A7","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A8","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A9","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A10","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A11","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A12","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A13","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A14","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A15","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A16","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]

{"sheet":"mid-semester-feedback","index":5,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,10,3,10]]}
["Student Name","# Absent","# Late","# Camera Off","# Poor Participation","# Exceptional Participation",null,null,null,null,"For feedback calculation, do not modify","sprint1"]
[{"$f":"Roster!A2","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":16},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0},null,null,null,null,null,"sprint2"]
[{"$f":"Roster!A3","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":16},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0},null,null,null,null,null,"sprint3"]
[{"$f":"Roster!A4","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":16},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0},null,null,null,null,null,"sprint4"]
[{"$f":"Roster!A5","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":16},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A6","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":16},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A7","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":16},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A8","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":16},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A9","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":16},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A10","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":16},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A11","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":16},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A12","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":16},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A13","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":16},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A14","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":16},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A15","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":16},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A16","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":16},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & sheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]

{"sheet":"sprint5","index":6,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,10,0,15],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,1,9]]}
[null,"Lecture 1",null,"Lab 1",null,"Lecture 2",null,"Lab 2",null,"Recommended Presence Grade (Use your own discretion when grading)","Notes"]
["Student","Attendance","Participation","Attendance","Participation","Attendance","Participation","Attendance","Participation",null,"General","Task 1","% Complete ","Task 2","% Complete ","Other Tasks (if needed)"]
[{"$f":"Roster!A2","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A",{"$f":"IF(COUNTIF(B3:H3,\"Absent\")>=3, \"Unsatisfactory\",\n IF(COUNTIF(B3:H3,\"Absent\")=2, \"Below Expectations\",\n IF(OR(COUNTIF(B3:H3,\"Absent\")=1,\n        COUNTIF(B3:H3,\"Camera Off\")>0,\n        COUNTIF(C3:I3,\"Poor\")>0), \"Needs Improvement\",\n IF(COUNTIF(C3:I3,\"Exceptional\")>=1, \"Exceeds Expectations\",\n \"Meets Expectations\"))))","v":"Unsatisfactory"},null,null,0,null,0]
[{"$f":"Roster!A3","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A",{"$f":"IF(COUNTIF(B4:H4,\"Absent\")>=3, \"Unsatisfactory\",\n IF(COUNTIF(B4:H4,\"Absent\")=2, \"Below Expectations\",\n IF(OR(COUNTIF(B4:H4,\"Absent\")=1,\n        COUNTIF(B4:H4,\"Camera Off\")>0,\n        COUNTIF(C4:I4,\"Poor\")>0), \"Needs Improvement\",\n IF(COUNTIF(C4:I4,\"Exceptional\")>=1, \"Exceeds Expectations\",\n \"Meets Expectations\"))))","v":"Unsatisfactory"},null,null,0,null,0]
[{"$f":"Roster!A4","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A5","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A6","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A7","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A8","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A9","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A10","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A11","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A12","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A13","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A14","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A15","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A16","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]

{"sheet":"sprint6","index":7,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,10,0,15],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,1,9]]}
[null,"Lecture 1",null,"Lab 1",null,"Lecture 2",null,"Lab 2",null,"Recommended Presence Grade (Use your own discretion when grading)","Notes"]
["Student","Attendance","Participation","Attendance","Participation","Attendance","Participation","Attendance","Participation",null,"General","Task 1","% Complete ","Task 2","% Complete ","Other Tasks (if needed)"]
[{"$f":"Roster!A2","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A",{"$f":"IF(COUNTIF(B3:H3,\"Absent\")>=3, \"Unsatisfactory\",\n IF(COUNTIF(B3:H3,\"Absent\")=2, \"Below Expectations\",\n IF(OR(COUNTIF(B3:H3,\"Absent\")=1,\n        COUNTIF(B3:H3,\"Camera Off\")>0,\n        COUNTIF(C3:I3,\"Poor\")>0), \"Needs Improvement\",\n IF(COUNTIF(C3:I3,\"Exceptional\")>=1, \"Exceeds Expectations\",\n \"Meets Expectations\"))))","v":"Unsatisfactory"},null,null,0,null,0]
[{"$f":"Roster!A3","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A",{"$f":"IF(COUNTIF(B4:H4,\"Absent\")>=3, \"Unsatisfactory\",\n IF(COUNTIF(B4:H4,\"Absent\")=2, \"Below Expectations\",\n IF(OR(COUNTIF(B4:H4,\"Absent\")=1,\n        COUNTIF(B4:H4,\"Camera Off\")>0,\n        COUNTIF(C4:I4,\"Poor\")>0), \"Needs Improvement\",\n IF(COUNTIF(C4:I4,\"Exceptional\")>=1, \"Exceeds Expectations\",\n \"Meets Expectations\"))))","v":"Unsatisfactory"},null,null,0,null,0]
[{"$f":"Roster!A4","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A5","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A6","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A7","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A8","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A9","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A10","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A11","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A12","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A13","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A14","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A15","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A16","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]

{"sheet":"sprint7","index":8,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,10,0,15],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,1,9]]}
[null,"Lecture 1",null,"Lab 1",null,"Lecture 2",null,"Lab 2",null,"Recommended Presence Grade (Use your own discretion when grading)","Notes"]
["Student","Attendance","Participation","Attendance","Participation","Attendance","Participation","Attendance","Participation",null,"General","Task 1","% Complete ","Task 2","% Complete ","Other Tasks (if needed)"]
[{"$f":"Roster!A2","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A",{"$f":"IF(COUNTIF(B3:H3,\"Absent\")>=3, \"Unsatisfactory\",\n IF(COUNTIF(B3:H3,\"Absent\")=2, \"Below Expectations\",\n IF(OR(COUNTIF(B3:H3,\"Absent\")=1,\n        COUNTIF(B3:H3,\"Camera Off\")>0,\n        COUNTIF(C3:I3,\"Poor\")>0), \"Needs Improvement\",\n IF(COUNTIF(C3:I3,\"Exceptional\")>=1, \"Exceeds Expectations\",\n \"Meets Expectations\"))))","v":"Unsatisfactory"},null,null,0,null,0]
[{"$f":"Roster!A3","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A",{"$f":"IF(COUNTIF(B4:H4,\"Absent\")>=3, \"Unsatisfactory\",\n IF(COUNTIF(B4:H4,\"Absent\")=2, \"Below Expectations\",\n IF(OR(COUNTIF(B4:H4,\"Absent\")=1,\n        COUNTIF(B4:H4,\"Camera Off\")>0,\n        COUNTIF(C4:I4,\"Poor\")>0), \"Needs Improvement\",\n IF(COUNTIF(C4:I4,\"Exceptional\")>=1, \"Exceeds Expectations\",\n \"Meets Expectations\"))))","v":"Unsatisfactory"},null,null,0,null,0]
[{"$f":"Roster!A4","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A5","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A6","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A7","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A8","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A9","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A10","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A11","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A12","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A13","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A14","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A15","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]
[{"$f":"Roster!A16","v":" "},"Absent","N/A","Absent","N/A","Absent","N/A","Absent","N/A","Unsatisfactory",null,null,0,null,0]

{"sheet":"final_feedback","index":9,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,10,6,10]]}
["Student Name","# Absent","# Late","# Camera Off","# Poor Participation","# Exceptional Participation",null,null,null,null,"For feedback calculation, do not modify","sprint1"]
[{"$f":"Roster!A2","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":28},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0},null,null,null,null,null,"sprint2"]
[{"$f":"Roster!A3","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":28},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0},null,null,null,null,null,"sprint3"]
[{"$f":"Roster!A4","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":28},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0},null,null,null,null,null,"sprint4"]
[{"$f":"Roster!A5","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":28},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0},null,null,null,null,null,"sprint5"]
[{"$f":"Roster!A6","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":28},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0},null,null,null,null,null,"sprint6"]
[{"$f":"Roster!A7","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":28},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0},null,null,null,null,null,"sprint7"]
[{"$f":"Roster!A8","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":28},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A9","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":28},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A10","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":28},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A11","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":28},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A12","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":28},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A13","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":28},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A14","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":28},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A15","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":28},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]
[{"$f":"Roster!A16","v":" "},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Absent\"\n   )\n)","v":28},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Late\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Camera Off\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Poor\"\n   )\n)","v":0},{"$f":"SUMPRODUCT(\n   COUNTIF(\n     INDIRECT( \"'\" & fullsheetlist & \"'!B\" & ROW() + 1& \":I\" & ROW() + 1 ),\n     \"Exceptional\"\n   )\n)","v":0}]