{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Class list","Deadlines","Weekly schedule","Semester Calendar"],"not_rendered":{"images":10,"defined_names":9,"comments":1,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Class list","index":0,"n_rows":12,"n_cols":11,"rows_kept":12,"merged":[[2,1,2,9]]}
[]
[]
[null,"CLASS LIST",{"$nulls":8}," "]
[]
[]
[null,"Course ID","Course name","Instructor","Day","Year","Semester","Time start","Time end","Duration"]
[null,"CS 120","Intro to Computer Applications","Moni Sisodiya","Monday",{"$f":"'Semester Calendar'!$P$25","v":2024},"Spring","14:00:00","15:30:00",{"$f":"IFERROR(IF(AND(ISNUMBER(Table_ClassList[[#This Row],[Time end]]),ISNUMBER(Table_ClassList[[#This Row],[Time start]])),Table_ClassList[[#This Row],[Time end]]-Table_ClassList[[#This Row],[Time start]],\"\"),\"\")","v":"01:30:00"}]
[null,"WR 121","Writing Composition","Calimero Mazzanti","Tuesday",{"$f":"'Semester Calendar'!$P$25","v":2024},"Spring","10:00:00","11:30:00",{"$f":"IFERROR(IF(AND(ISNUMBER(Table_ClassList[[#This Row],[Time end]]),ISNUMBER(Table_ClassList[[#This Row],[Time start]])),Table_ClassList[[#This Row],[Time end]]-Table_ClassList[[#This Row],[Time start]],\"\"),\"\")","v":"01:30:00"}]
[null,"WR 121","Writing Composition","Calimero Mazzanti","Thursday",{"$f":"'Semester Calendar'!$P$25","v":2024},"Spring","10:00:00","11:30:00",{"$f":"IFERROR(IF(AND(ISNUMBER(Table_ClassList[[#This Row],[Time end]]),ISNUMBER(Table_ClassList[[#This Row],[Time start]])),Table_ClassList[[#This Row],[Time end]]-Table_ClassList[[#This Row],[Time start]],\"\"),\"\")","v":"01:30:00"}]
[null,"SP 111","Public Speaking","Aswini Ragrez","Monday",{"$f":"'Semester Calendar'!$P$25","v":2024},"Spring","11:00:00","12:00:00",{"$f":"IFERROR(IF(AND(ISNUMBER(Table_ClassList[[#This Row],[Time end]]),ISNUMBER(Table_ClassList[[#This Row],[Time start]])),Table_ClassList[[#This Row],[Time end]]-Table_ClassList[[#This Row],[Time start]],\"\"),\"\")","v":"01:00:00"}]
[null,"SP 111","Public Speaking","Aswini Ragrez","Wednesday",{"$f":"'Semester Calendar'!$P$25","v":2024},"Spring","11:00:00","12:00:00",{"$f":"IFERROR(IF(AND(ISNUMBER(Table_ClassList[[#This Row],[Time end]]),ISNUMBER(Table_ClassList[[#This Row],[Time start]])),Table_ClassList[[#This Row],[Time end]]-Table_ClassList[[#This Row],[Time start]],\"\"),\"\")","v":"01:00:00"}]
[null,"PSY 101","Basic Psychology","Diert Maage","Friday",{"$f":"'Semester Calendar'!$P$25","v":2024},"Spring","10:00:00","11:00:00",{"$f":"IFERROR(IF(AND(ISNUMBER(Table_ClassList[[#This Row],[Time end]]),ISNUMBER(Table_ClassList[[#This Row],[Time start]])),Table_ClassList[[#This Row],[Time end]]-Table_ClassList[[#This Row],[Time start]],\"\"),\"\")","v":"01:00:00"}]

{"sheet":"Deadlines","index":1,"n_rows":13,"n_cols":10,"rows_kept":13,"merged":[[2,1,2,6]]}
[]
[]
[null,"DEADLINES",{"$nulls":7}," "]
[]
[]
[null,"Course ID","Course name","Year","Semester","Item description","Due date"]
[null,"WR 121",{"$f":"IFERROR(VLOOKUP(Table_Deadlines[[#This Row],[Course ID]],Table_ClassList[],2,0),\"\")","v":"Writing Composition"},{"$f":"'Semester Calendar'!$P$25","v":2024},"Spring","Quiz #1",{"$f":"DATE(Table_Deadlines[[#This Row],[Year]],1,20)","v":"2024-01-20"}]
[null,"CS 120",{"$f":"IFERROR(VLOOKUP(Table_Deadlines[[#This Row],[Course ID]],Table_ClassList[],2,0),\"\")","v":"Intro to Computer Applications"},{"$f":"'Semester Calendar'!$P$25","v":2024},"Spring","Assignment #2",{"$f":"DATE(Table_Deadlines[[#This Row],[Year]],2,3)","v":"2024-02-03"}]
[null,"WR 121",{"$f":"IFERROR(VLOOKUP(Table_Deadlines[[#This Row],[Course ID]],Table_ClassList[],2,0),\"\")","v":"Writing Composition"},{"$f":"'Semester Calendar'!$P$25","v":2024},"Spring","Assignment #3",{"$f":"DATE(Table_Deadlines[[#This Row],[Year]],2,6)","v":"2024-02-06"}]
[null,"CS 120",{"$f":"IFERROR(VLOOKUP(Table_Deadlines[[#This Row],[Course ID]],Table_ClassList[],2,0),\"\")","v":"Intro to Computer Applications"},{"$f":"'Semester Calendar'!$P$25","v":2024},"Spring","Presentation #1",{"$f":"DATE(Table_Deadlines[[#This Row],[Year]],2,17)","v":"2024-02-17"}]
[null,"CS 120",{"$f":"IFERROR(VLOOKUP(Table_Deadlines[[#This Row],[Course ID]],Table_ClassList[],2,0),\"\")","v":"Intro to Computer Applications"},{"$f":"'Semester Calendar'!$P$25","v":2024},"Spring","Paper",{"$f":"DATE(Table_Deadlines[[#This Row],[Year]],3,15)","v":"2024-03-15"}]
[null,"WR 121",{"$f":"IFERROR(VLOOKUP(Table_Deadlines[[#This Row],[Course ID]],Table_ClassList[],2,0),\"\")","v":"Writing Composition"},{"$f":"'Semester Calendar'!$P$25","v":2024},"Spring","Assignment #2",{"$f":"DATE(Table_Deadlines[[#This Row],[Year]],3,15)","v":"2024-03-15"}]
[null,"WR 121",{"$f":"IFERROR(VLOOKUP(Table_Deadlines[[#This Row],[Course ID]],Table_ClassList[],2,0),\"\")","v":"Writing Composition"},{"$f":"'Semester Calendar'!$P$25","v":2024},"Spring","Paper",{"$f":"DATE(Table_Deadlines[[#This Row],[Year]],4,6)","v":"2024-04-06"}]

{"sheet":"Weekly schedule","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"merged":[[2,1,2,5]]}
[]
[]
[null,"WEEKLY SCHEDULE"]
[]
[]
[null,"Day","Time Start","Course Name"]
[null,"Monday","14:00:00","Intro to Computer Applications"]
[null,null,"11:00:00","Public Speaking"]
[null,"Tuesday","10:00:00","Writing Composition"]
[null,"Wednesday","11:00:00","Public Speaking"]
[null,"Thursday","10:00:00","Writing Composition"]
[null,"Friday","10:00:00","Basic Psychology"]

{"sheet":"Semester Calendar","index":3,"n_rows":26,"n_cols":16,"rows_kept":26,"merged":[[2,1,2,15],[5,1,5,2],[5,9,5,10],[15,1,15,2],[15,9,15,10],[19,19,20,21],[19,22,20,22],[21,19,22,21],[21,22,22,22],[24,3,24,4],[24,5,24,6],[24,13,24,14],[24,15,24,16],[25,3,25,4],[25,5,25,6],[25,13,25,14],[25,15,25,16],[28,2,29,4],[28,5,29,7],[28,8,29,10]]}
[]
[]
[null,"SEMESTER CALENDAR"]
[]
[]
[null,{"$f":"ScheduleStart","v":"00:00:00"},null,{"$f":"DAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+1,1)-1)","v":31},{"$f":"WEEKDAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart),1),1)","v":1},{"$nulls":4},{"$f":"DATE(ScheduleYear,MONTH(ScheduleStart)+1,1)","v":"1900-02-01"},null,{"$f":"DAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+2,1)-1)","v":29},{"$f":"WEEKDAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+1,1),1)","v":4}]
[]
[null,"Sun","Mon","Tue","Wed","Thu","Fri","Sat",null,"Sun","Mon","Tue","Wed","Thu","Fri","Sat"]
[null,{"$f":"IF($E$6=COLUMN(A$6),1,IF(A9>0,A9+1,\"\"))","v":1},{"$f":"IF($E$6=COLUMN(B$6),1,IF(AND(B9>0,B9<>\"\"),B9+1,\"\"))","v":2},3,4,5,6,7,null,{"$f":"IF(M$6=COLUMN(A$6),1,IF(I9>0,I9+1,\"\"))","v":""},{"$f":"IF(M$6=COLUMN(B$6),1,IF(AND(J9>0,J9<>\"\"),J9+1,\"\"))","v":""},{"$f":"IF(M$6=COLUMN(C$6),1,IF(AND(K9>0,K9<>\"\"),K9+1,\"\"))","v":""},{"$f":"IF(M$6=COLUMN(D$6),1,IF(AND(L9>0,L9<>\"\"),L9+1,\"\"))","v":1},{"$f":"IF(M$6=COLUMN(E$6),1,IF(AND(M9>0,M9<>\"\"),M9+1,\"\"))","v":2},{"$f":"IF(M$6=COLUMN(F$6),1,IF(AND(N9>0,N9<>\"\"),N9+1,\"\"))","v":3},{"$f":"IF(M$6=COLUMN(G$6),1,IF(AND(O9>0,O9<>\"\"),O9+1,\"\"))","v":4}]
[null,{"$f":"H9+1","v":8},{"$f":"B10+1","v":9},{"$f":"C10+1","v":10},11,12,13,14,null,{"$f":"P9+1","v":5},{"$f":"J10+1","v":6},7,8,9,10,11]
[null,{"$f":"H10+1","v":15},{"$f":"B11+1","v":16},17,18,19,20,{"$f":"G11+1","v":21},null,{"$f":"P10+1","v":12},13,14,15,16,17,18]
[null,22,23,24,25,26,27,28,null,{"$f":"P11+1","v":19},20,21,22,23,24,25]
[null,{"$f":"IFERROR(IF(H12+1>$D$6,\"\",H12+1),\"\")","v":29},{"$f":"IFERROR(IF(B13+1>$D$6,\"\",B13+1),\"\")","v":30},31,"","","","",null,{"$f":"IFERROR(IF(P12+1>L$6,\"\",P12+1),\"\")","v":26},{"$f":"IFERROR(IF(J13+1>L$6,\"\",J13+1),\"\")","v":27},{"$f":"IFERROR(IF(K13+1>L$6,\"\",K13+1),\"\")","v":28},{"$f":"IFERROR(IF(L13+1>L$6,\"\",L13+1),\"\")","v":29},{"$f":"IFERROR(IF(M13+1>L$6,\"\",M13+1),\"\")","v":""},{"$f":"IFERROR(IF(N13+L$6,\"\",N13+1),\"\")","v":""},{"$f":"IFERROR(IF(O13+1>L$6,\"\",O13+1),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(H13+1>$D$6,\"\",H13+1),\"\")","v":""},"","","","","","",null,{"$f":"IFERROR(IF(P13+1>L$6,\"\",P13+1),\"\")","v":""},{"$f":"IFERROR(IF(J14+1>L$6,\"\",J14+1),\"\")","v":""},{"$f":"IFERROR(IF(K14+1>L$6,\"\",K14+1),\"\")","v":""},{"$f":"IFERROR(IF(L14+1>L$6,\"\",L14+1),\"\")","v":""},{"$f":"IFERROR(IF(M14+1>L$6,\"\",M14+1),\"\")","v":""},{"$f":"IFERROR(IF(N14+1>L$6,\"\",N14+1),\"\")","v":""},{"$f":"IFERROR(IF(O14+L$6,\"\",O14+1),\"\")","v":""}]
[]
[null,{"$f":"DATE(ScheduleYear,MONTH(ScheduleStart)+2,1)","v":"1900-03-01"},null,{"$f":"DAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+3,1)-1)","v":31},{"$f":"WEEKDAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+2,1),1)","v":5},{"$nulls":4},{"$f":"DATE(ScheduleYear,MONTH(ScheduleStart)+3,1)","v":"1900-04-01"},null,{"$f":"DAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+4,1)-1)","v":30},{"$f":"WEEKDAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+3,1),1)","v":1}]
[]
[null,{"$f":"IF($E$16=COLUMN(A$6),1,IF(A18>0,A18+1,\"\"))","v":""},{"$f":"IF($E$16=COLUMN(B$6),1,IF(AND(B18>0,B18<>\"\"),B18+1,\"\"))","v":""},"","",1,2,3,null,{"$f":"IF($M$16=COLUMN(A$6),1,IF(I18>0,I18+1,\"\"))","v":1},{"$f":"IF($M$16=COLUMN(B$6),1,IF(AND(J18>0,J18<>\"\"),J18+1,\"\"))","v":2},3,4,5,6,7]
[null,{"$f":"H18+1","v":4},{"$f":"B19+1","v":5},{"$f":"C19+1","v":6},7,8,9,10,null,{"$f":"P18+1","v":8},{"$f":"J19+1","v":9},{"$f":"K19+1","v":10},11,12,13,14]
[null,{"$f":"H19+1","v":11},{"$f":"B20+1","v":12},13,14,15,16,17,null,{"$f":"P19+1","v":15},{"$f":"J20+1","v":16},17,18,19,20,21]
[null,18,19,20,21,22,23,24,null,22,23,24,25,26,27,28]
[null,{"$f":"IFERROR(IF(H21+1>$D$16,\"\",H21+1),\"\")","v":25},{"$f":"IFERROR(IF(B22+1>$D$16,\"\",B22+1),\"\")","v":26},{"$f":"IFERROR(IF(C22+1>$D$16,\"\",C22+1),\"\")","v":27},28,29,30,31,null,{"$f":"IFERROR(IF(P21+1>$L$16,\"\",P21+1),\"\")","v":29},{"$f":"IFERROR(IF(J22+1>$L$16,\"\",J22+1),\"\")","v":30},{"$f":"IFERROR(IF(K22+1>$L$16,\"\",K22+1),\"\")","v":""},"","","",""]
[null,{"$f":"IFERROR(IF(H22+1>$D$16,\"\",H22+1),\"\")","v":""},{"$f":"IFERROR(IF(B23+1>$D$16,\"\",B23+1),\"\")","v":""},"","","","","",null,{"$f":"IFERROR(IF(P22+1>$L$16,\"\",P22+1),\"\")","v":""},{"$f":"IFERROR(IF(J23+1>$L$16,\"\",J23+1),\"\")","v":""},"","","","",""]
[]
[{"$nulls":13},"Year:",null,{"$f":"IF(MONTH(TODAY())=12,YEAR(TODAY())+1,YEAR(TODAY()))","v":2024}]
[{"$nulls":13},"Start Date:",null,{"$f":"DATE(P25,1,1)+7+CHOOSE(WEEKDAY(DATE(P25,1,1),1),2,1,0,6,5,4,3)","v":"2024-01-09"}]