{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":57,"n_cols":16,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,7,0,12]]}
["TRS Eligibility Calculations"]
["FY22-23"]
[]
[]
[]
["FALL Eligibility"]
["Course","CR/CE","Meet Hrs","Meet Days","#Days Taught","Factor","TRS Hours",null,"Sep Work Hrs","Sep Work Days","Oct Work Hrs","Oct Work Days","Nov Work Hrs","Nov Work Days","Dec Work Hrs","Dec Work Days"]
["Crs 1","CR",0,null,{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,1)","v":0},{"$f":"IF(Table4[[#This Row],[CR/CE]]=\"CR\",2,1)","v":2},{"$f":"+C8*F8*Table4[[#This Row],['#Days Taught]]","v":0},null,{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,8,FALSE))","v":0}]
["Crs 2","CR",0,null,{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,1)","v":0},{"$f":"IF(Table4[[#This Row],[CR/CE]]=\"CR\",2,1)","v":2},{"$f":"+C9*F9*Table4[[#This Row],['#Days Taught]]","v":0},null,{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,8,FALSE))","v":0}]
["Crs 3","CR",0,null,{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,1)","v":0},{"$f":"IF(Table4[[#This Row],[CR/CE]]=\"CR\",2,1)","v":2},{"$f":"+C10*F10*Table4[[#This Row],['#Days Taught]]","v":0},null,{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,8,FALSE))","v":0}]
["Crs 4","CR",0,null,{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,1)","v":0},{"$f":"IF(Table4[[#This Row],[CR/CE]]=\"CR\",2,1)","v":2},{"$f":"+C11*F11*Table4[[#This Row],['#Days Taught]]","v":0},null,{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,8,FALSE))","v":0}]
["Crs 5","CR",0,null,{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,1)","v":0},{"$f":"IF(Table4[[#This Row],[CR/CE]]=\"CR\",2,1)","v":2},{"$f":"+C12*F12*Table4[[#This Row],['#Days Taught]]","v":0},null,{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$7,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$7,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$7,3),$A$29:$H$41,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,8,FALSE)))*Table4[[#This Row],[Factor]]*Table4[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table4[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($O$7,3),$A$29:$H$41,8,FALSE))","v":0}]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table4[TRS Hours])","v":0},null,{"$f":"SUBTOTAL(109,Table6[Sep Work Hrs])","v":0},{"$f":"SUBTOTAL(109,Table6[Sep Work Days])","v":0},{"$f":"SUBTOTAL(109,Table6[Oct Work Hrs])","v":0},{"$f":"SUBTOTAL(109,Table6[Oct Work Days])","v":0},{"$f":"SUBTOTAL(109,Table6[Nov Work Hrs])","v":0},{"$f":"SUBTOTAL(109,Table6[Nov Work Days])","v":0},{"$f":"SUBTOTAL(109,Table6[Dec Work Hrs])","v":0},{"$f":"SUBTOTAL(109,Table6[Dec Work Days])","v":0}]
[]
[]
["SPRING Eligibility"]
["Course","CR/CE","Meet Hrs","Meet Days","#Days Taught","Factor","TRS Hours",null,"Feb Work Hrs","Feb Work Days","Mar Work Hrs","Mar Work Days","Apr Work Hrs","Apr Work Days","May Work Hrs","May Work Days"]
["Crs 1","CR",0,null,{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,1)","v":0},{"$f":"IF(Table5[[#This Row],[CR/CE]]=\"CR\",2,1)","v":2},{"$f":"+C18*F18*Table5[[#This Row],['#Days Taught]]","v":0},null,{"$f":"(IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\", Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\", Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$J$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$J$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,8,FALSE))","v":0}]
["Crs 2","CR",0,null,{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,1)","v":0},{"$f":"IF(Table5[[#This Row],[CR/CE]]=\"CR\",2,1)","v":2},{"$f":"+C19*F19*Table5[[#This Row],['#Days Taught]]","v":0},null,{"$f":"(IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\", Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\", Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$J$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$J$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,8,FALSE))","v":0}]
["Crs 3","CR",0,null,{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,1)","v":0},{"$f":"IF(Table5[[#This Row],[CR/CE]]=\"CR\",2,1)","v":2},{"$f":"+C20*F20*Table5[[#This Row],['#Days Taught]]","v":0},null,{"$f":"(IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\", Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\", Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$J$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$J$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,8,FALSE))","v":0}]
["Crs 4","CR",0,null,{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,1)","v":0},{"$f":"IF(Table5[[#This Row],[CR/CE]]=\"CR\",2,1)","v":2},{"$f":"+C21*F21*Table5[[#This Row],['#Days Taught]]","v":0},null,{"$f":"(IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\", Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\", Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$J$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$J$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,8,FALSE))","v":0}]
["Crs 5","CR",0,null,{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,1)+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,1)","v":0},{"$f":"IF(Table5[[#This Row],[CR/CE]]=\"CR\",2,1)","v":2},{"$f":"+C22*F22*Table5[[#This Row],['#Days Taught]]","v":0},null,{"$f":"(IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\", Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\", Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($K$17,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$J$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($I$17,3),$A$30:$J$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($M$17,3),$A$30:$H$42,8,FALSE))","v":0},{"$f":"(IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,8,FALSE)))*Table5[[#This Row],[Factor]]*Table5[[#This Row],[Meet Hrs]]","v":0},{"$f":"IF(ISERROR(SEARCH(\"M\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,2,FALSE))+IF(ISERROR(SEARCH(\"T\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,3,FALSE))+IF(ISERROR(SEARCH(\"W\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,4,FALSE))+IF(ISERROR(SEARCH(\"R\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,5,FALSE))+IF(ISERROR(SEARCH(\"F\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,6,FALSE))+IF(ISERROR(SEARCH(\"S\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,7,FALSE))+IF(ISERROR(SEARCH(\"U\",Table5[[#This Row],[Meet Days]],1)),0,VLOOKUP(LEFT($P$17,3),$A$30:$H$42,8,FALSE))","v":0}]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table5[TRS Hours])","v":0},null,{"$f":"SUBTOTAL(109,Table7[Feb Work Hrs])","v":0},{"$f":"SUBTOTAL(109,Table7[Feb Work Days])","v":0},{"$f":"SUBTOTAL(109,Table7[Mar Work Hrs])","v":0},{"$f":"SUBTOTAL(109,Table7[Mar Work Days])","v":0},{"$f":"SUBTOTAL(109,Table7[Apr Work Hrs])","v":0},{"$f":"SUBTOTAL(109,Table7[Apr Work Days])","v":0},{"$f":"SUBTOTAL(109,Table7[May Work Hrs])","v":0},{"$f":"SUBTOTAL(109,Table7[May Work Days])","v":0}]
[]
[]
["Minutes to Hours Conversion Table",null,null,null,null,null,null,null,null,"Days of Week (Enter as CAPS, no  delimiter)"]
["50 minutes = .83 hrs",null,null,"20 minutes = .33 hrs",null,null,null,null,null,"(M)onday","(T)uesday","(W)ednesday"]
[null,null,null,null,null,null,null,null,null,"thu(R)sday","(F)riday","(S)aturday","s(U)nday"]
["Days Worked in a Month"]
["Month","Mon","Tues","Wed","Thur","Fri","Sat ","Sun",null,"Web Calculations:"]
["Sep",3,4,4,5,5,4,4,null,"Select the CR/CE Indicator"]
["Oct",5,4,4,4,4,5,5,null,"For Meet Hrs, enter the credit hours/5"]
["Nov",4,5,4,3,3,3,3,null,"For Meet Days, enter MTWRF"]
["Dec",1,1,1,2,2,2,2]
["Jan",2,3,2,2,2,2,2]
["Feb",4,4,4,4,4,4,4]
["Mar",3,3,4,4,4,3,3]
["Apr",4,4,4,4,3,4,4]
["May",2,2,2,2,2,2,2,"*Days For Spring Only"]
[]
["Wintermester",null,null,"Calculate Manually due to schedule"]
["Maymester",null,null,"Calculate Manually due to schedule"]
["Summer I,II,III",null,null,"Calculate Manually due to schedule"]
[]
["WMN (Dec)",2,2,2,2,1,1,1]
["WMN (Jan)",0,1,1,0,0,0,0]
[]
["MMN(May)",2,3,2,2,2,2,2]
["MMN(Jun)",0,0,0,0,0,0,0]
[]
["SUM I/3(Jun)",4,4,4,4,4,3,3]
["Sum I(Jul)",1,0,1,1,1,2,2]
["Sum II(Jul)",4,3,3,3,3,3,3]
["Sum3(Jul)",5,3,4,4,4,5,5]
[]
["Sum II(Aug)",1,2,1,1,2,2,2]
["Sum 3(Aug)",1,2,1,1,2,2,2]