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

{"sheet":"Class list","index":0,"n_rows":11,"n_cols":13,"rows_kept":11,"merged":[[3,12,4,12],[5,12,9,12]]}
[]
[null,"CLASS LIST"]
[]
[null,"COURSE ID","NAME","INSTRUCTOR","DAY","YEAR","SEMESTER","TIME START","TIME END","DURATION",null,null,"CLASS \nLIST TIP: "]
[null,"CS 120","Intro to Computer Applications","Peyton Davis","Monday",{"$f":"YEAR(TODAY())","v":2023},"Spring","14:00:00","15:30:00",{"$f":"IF(AND(ISNUMBER(ClassListTable[[#This Row],[TIME END]]),ISNUMBER(ClassListTable[[#This Row],[TIME START]])),ClassListTable[[#This Row],[TIME END]]-ClassListTable[[#This Row],[TIME START]],\"\")","v":"01:30:00"}]
[null,"CS 120","Intro to Computer Applications","Quinn Campbell","Wednesday",{"$f":"YEAR(TODAY())","v":2023},"Spring","14:00:00","15:30:00",{"$f":"IF(AND(ISNUMBER(ClassListTable[[#This Row],[TIME END]]),ISNUMBER(ClassListTable[[#This Row],[TIME START]])),ClassListTable[[#This Row],[TIME END]]-ClassListTable[[#This Row],[TIME START]],\"\")","v":"01:30:00"},null,null,"Enter your individual classes in this table. Class duration is automatically updated."]
[null,"WR 121","Writing Composition","Ravi Costa","Tuesday",2023,"Spring","10:00:00","11:30:00",{"$f":"IF(AND(ISNUMBER(ClassListTable[[#This Row],[TIME END]]),ISNUMBER(ClassListTable[[#This Row],[TIME START]])),ClassListTable[[#This Row],[TIME END]]-ClassListTable[[#This Row],[TIME START]],\"\")","v":"01:30:00"}]
[null,"WR 121","Writing Composition","Nuria Acevedo","Thursday",2023,"Spring","10:00:00","11:30:00",{"$f":"IF(AND(ISNUMBER(ClassListTable[[#This Row],[TIME END]]),ISNUMBER(ClassListTable[[#This Row],[TIME START]])),ClassListTable[[#This Row],[TIME END]]-ClassListTable[[#This Row],[TIME START]],\"\")","v":"01:30:00"}]
[null,"SP 111","Public Speaking","Olivia Wilson","Monday",2023,"Spring","11:00:00","12:00:00",{"$f":"IF(AND(ISNUMBER(ClassListTable[[#This Row],[TIME END]]),ISNUMBER(ClassListTable[[#This Row],[TIME START]])),ClassListTable[[#This Row],[TIME END]]-ClassListTable[[#This Row],[TIME START]],\"\")","v":"01:00:00"}]
[null,"SP 111","Public Speaking","Paula Núñez","Wednesday",2023,"Spring","11:00:00","12:00:00",{"$f":"IF(AND(ISNUMBER(ClassListTable[[#This Row],[TIME END]]),ISNUMBER(ClassListTable[[#This Row],[TIME START]])),ClassListTable[[#This Row],[TIME END]]-ClassListTable[[#This Row],[TIME START]],\"\")","v":"01:00:00"}]
[null,"PSY 101","Basic Psychology","Gael Torres","Friday",2023,"Spring","10:00:00","11:00:00",{"$f":"IF(AND(ISNUMBER(ClassListTable[[#This Row],[TIME END]]),ISNUMBER(ClassListTable[[#This Row],[TIME START]])),ClassListTable[[#This Row],[TIME END]]-ClassListTable[[#This Row],[TIME START]],\"\")","v":"01:00:00"}]

{"sheet":"Deadlines","index":1,"n_rows":11,"n_cols":10,"rows_kept":11,"merged":[[3,9,4,9],[5,9,10,9]]}
[]
[null,"DEADLINES"]
[]
[null,"COURSE ID","NAME","YEAR","SEMESTER","ITEM DESCRIPTION","DUE DATE",null,null,"WORK DATA ENTRY TIP: "]
[null,"WR 121",{"$f":"IFERROR(VLOOKUP(Work[[#This Row],[COURSE ID]],ClassListTable[],2,0),\"\")","v":"Writing Composition"},{"$f":"YEAR(TODAY())","v":2023},"Spring","Quiz #1",{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2023-01-15"}]
[null,"CS 120",{"$f":"IFERROR(VLOOKUP(Work[[#This Row],[COURSE ID]],ClassListTable[],2,0),\"\")","v":"Intro to Computer Applications"},{"$f":"YEAR(TODAY())","v":2023},"Spring","Assignment #2",{"$f":"DATE(YEAR(TODAY()),2,4)","v":"2023-02-04"},null,null,"Select a Course ID. Course Name is populated automatically. After you update the Class List sheet, Refresh the Weekly Schedule to see those changes."]
[null,"WR 121",{"$f":"IFERROR(VLOOKUP(Work[[#This Row],[COURSE ID]],ClassListTable[],2,0),\"\")","v":"Writing Composition"},2023,"Spring","Assignment #3",{"$f":"DATE(YEAR(TODAY()),2,5)","v":"2023-02-05"}]
[null,"CS 120",{"$f":"IFERROR(VLOOKUP(Work[[#This Row],[COURSE ID]],ClassListTable[],2,0),\"\")","v":"Intro to Computer Applications"},2023,"Spring","Presentation #1",{"$f":"DATE(YEAR(TODAY()),2,18)","v":"2023-02-18"}]
[null,"CS 120",{"$f":"IFERROR(VLOOKUP(Work[[#This Row],[COURSE ID]],ClassListTable[],2,0),\"\")","v":"Intro to Computer Applications"},2023,"Spring","Paper",{"$f":"DATE(YEAR(TODAY()),3,11)","v":"2023-03-11"}]
[null,"WR 121",{"$f":"IFERROR(VLOOKUP(Work[[#This Row],[COURSE ID]],ClassListTable[],2,0),\"\")","v":"Writing Composition"},2023,"Spring","Assignment #2",{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2023-03-17"}]
[null,"WR 121",{"$f":"IFERROR(VLOOKUP(Work[[#This Row],[COURSE ID]],ClassListTable[],2,0),\"\")","v":"Writing Composition"},2023,"Spring","Paper",{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2023-04-02"}]

{"sheet":"Weekly schedule","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"merged":[[3,6,4,6],[5,6,10,6]]}
[]
[null,"WEEKLY SCHEDULE"]
[]
[null,"DAY","TIME START","CLASS ",null,null,"WEEKLY \nSCHEDULE  TIP:"]
[null,"Monday","11:00:00","Public Speaking"]
[null,null,"14:00:00","Intro to Computer Applications",null,null,"To update your weekly schedule, Refresh the schedule."]
[null,"Tuesday","10:00:00","Writing Composition"]
[null,"Wednesday","11:00:00","Public Speaking"]
[null,null,"14:00:00","Intro to Computer Applications"]
[null,"Thursday","10:00:00","Writing Composition"]
[null,"Friday","10:00:00","Basic Psychology"]

{"sheet":"Semester calendar","index":3,"n_rows":20,"n_cols":19,"rows_kept":20,"merged":[[13,18,14,18],[15,18,19,18]]}
[]
[null,"SEMESTER CALENDAR"]
[]
[null,{"$f":"UPPER(TEXT(ScheduleStart,\"MMMM\"))","v":"JANUARY"},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":"UPPER(TEXT(DATE(ScheduleYear,MONTH(ScheduleStart)+1,1),\"MMMM\"))","v":"FEBRUARY"},null,{"$f":"DAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+2,1)-1)","v":28},{"$f":"WEEKDAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+1,1),1)","v":4},{"$nulls":5},"YEAR"]
[null,"SUN","MON","TUE","WED","THU","FRI","SAT",null,"SUN","MON","TUE","WED","THU","FRI","SAT",null,null,{"$f":"YEAR(TODAY())","v":2023}]
[null,{"$f":"IF($E$4=COLUMN(A$4),1,IF(A6>0,A6+1,\"\"))","v":1},{"$f":"IF($E$4=COLUMN(B$4),1,IF(AND(B6>0,B6<>\"\"),B6+1,\"\"))","v":2},3,4,5,6,7,null,{"$f":"IF(M$4=COLUMN(A$4),1,IF(I6>0,I6+1,\"\"))","v":""},{"$f":"IF(M$4=COLUMN(B$4),1,IF(AND(J6>0,J6<>\"\"),J6+1,\"\"))","v":""},{"$f":"IF(M$4=COLUMN(C$4),1,IF(AND(K6>0,K6<>\"\"),K6+1,\"\"))","v":""},{"$f":"IF(M$4=COLUMN(D$4),1,IF(AND(L6>0,L6<>\"\"),L6+1,\"\"))","v":1},{"$f":"IF(M$4=COLUMN(E$4),1,IF(AND(M6>0,M6<>\"\"),M6+1,\"\"))","v":2},{"$f":"IF(M$4=COLUMN(F$4),1,IF(AND(N6>0,N6<>\"\"),N6+1,\"\"))","v":3},{"$f":"IF(M$4=COLUMN(G$4),1,IF(AND(O6>0,O6<>\"\"),O6+1,\"\"))","v":4},null,null,"START DATE"]
[null,{"$f":"H6+1","v":8},{"$f":"B7+1","v":9},{"$f":"C7+1","v":10},11,12,13,14,null,{"$f":"P6+1","v":5},{"$f":"J7+1","v":6},7,8,9,10,11,null,null,{"$f":"DATE(YEAR(TODAY()),1,6)","v":"2023-01-06"}]
[null,{"$f":"H7+1","v":15},{"$f":"B8+1","v":16},17,18,19,20,21,null,{"$f":"P7+1","v":12},13,14,15,16,17,18,null,null,"END DATE"]
[null,22,{"$f":"B9+1","v":23},24,25,26,27,28,null,{"$f":"P8+1","v":19},20,21,22,23,24,25,null,null,{"$f":"DATE(YEAR(TODAY()),4,25)","v":"2023-04-25"}]
[null,{"$f":"IFERROR(IF(H9+1>$D$4,\"\",H9+1),\"\")","v":29},{"$f":"IFERROR(IF(B10+1>$D$4,\"\",B10+1),\"\")","v":30},31,"","","","",null,{"$f":"IFERROR(IF(P9+1>L$4,\"\",P9+1),\"\")","v":26},{"$f":"IFERROR(IF(J10+1>L$4,\"\",J10+1),\"\")","v":27},{"$f":"IFERROR(IF(K10+1>L$4,\"\",K10+1),\"\")","v":28},{"$f":"IFERROR(IF(L10+1>L$4,\"\",L10+1),\"\")","v":""},{"$f":"IFERROR(IF(M10+1>L$4,\"\",M10+1),\"\")","v":""},{"$f":"IFERROR(IF(N10+L$4,\"\",N10+1),\"\")","v":""},{"$f":"IFERROR(IF(O10+1>L$4,\"\",O10+1),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(H10+1>$D$4,\"\",H10+1),\"\")","v":""},"","","","","","",null,{"$f":"IFERROR(IF(P10+1>L$4,\"\",P10+1),\"\")","v":""},{"$f":"IFERROR(IF(J11+1>L$4,\"\",J11+1),\"\")","v":""},{"$f":"IFERROR(IF(K11+1>L$4,\"\",K11+1),\"\")","v":""},{"$f":"IFERROR(IF(L11+1>L$4,\"\",L11+1),\"\")","v":""},{"$f":"IFERROR(IF(M11+1>L$4,\"\",M11+1),\"\")","v":""},{"$f":"IFERROR(IF(N11+1>L$4,\"\",N11+1),\"\")","v":""},{"$f":"IFERROR(IF(O11+L$4,\"\",O11+1),\"\")","v":""}]
[]
[null,{"$f":"UPPER(TEXT(DATE(ScheduleYear,MONTH(ScheduleStart)+2,1),\"MMMM\"))","v":"MARCH"},null,{"$f":"DAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+3,1)-1)","v":31},{"$f":"WEEKDAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+2,1),1)","v":4},{"$nulls":4},{"$f":"UPPER(TEXT(DATE(ScheduleYear,MONTH(ScheduleStart)+3,1),\"MMMM\"))","v":"APRIL"},null,{"$f":"DAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+4,1)-1)","v":30},{"$f":"WEEKDAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+3,1),1)","v":7}]
[null,"SUN","MON","TUE","WED","THU","FRI","SAT",null,"SUN","MON","TUE","WED","THU","FRI","SAT",null,null,"SEMESTER CALENDAR TIP:"]
[null,{"$f":"IF($E$13=COLUMN(A$4),1,IF(A15>0,A15+1,\"\"))","v":""},{"$f":"IF($E$13=COLUMN(B$4),1,IF(AND(B15>0,B15<>\"\"),B15+1,\"\"))","v":""},{"$f":"IF($E$13=COLUMN(C$4),1,IF(AND(C15>0,C15<>\"\"),C15+1,\"\"))","v":""},1,2,3,4,null,{"$f":"IF($M$13=COLUMN(A$4),1,IF(I15>0,I15+1,\"\"))","v":""},{"$f":"IF($M$13=COLUMN(B$4),1,IF(AND(J15>0,J15<>\"\"),J15+1,\"\"))","v":""},{"$f":"IF($M$13=COLUMN(C$4),1,IF(AND(K15>0,K15<>\"\"),K15+1,\"\"))","v":""},"","","",1]
[null,{"$f":"H15+1","v":5},{"$f":"B16+1","v":6},{"$f":"C16+1","v":7},8,9,10,11,null,{"$f":"P15+1","v":2},{"$f":"J16+1","v":3},{"$f":"K16+1","v":4},5,6,7,8,null,null,"Enter the Year, Start Date, and End Date to view a four month schedule. Days that have deadlines display in red."]
[null,{"$f":"H16+1","v":12},{"$f":"B17+1","v":13},14,15,16,17,18,null,{"$f":"P16+1","v":9},{"$f":"J17+1","v":10},11,12,13,14,15]
[null,19,{"$f":"B18+1","v":20},21,22,23,24,25,null,16,{"$f":"J18+1","v":17},18,19,20,21,22]
[null,{"$f":"IFERROR(IF(H18+1>$D$13,\"\",H18+1),\"\")","v":26},{"$f":"IFERROR(IF(B19+1>$D$13,\"\",B19+1),\"\")","v":27},{"$f":"IFERROR(IF(C19+1>$D$13,\"\",C19+1),\"\")","v":28},29,30,31,"",null,{"$f":"IFERROR(IF(P18+1>$L$13,\"\",P18+1),\"\")","v":23},{"$f":"IFERROR(IF(J19+1>$L$13,\"\",J19+1),\"\")","v":24},{"$f":"IFERROR(IF(K19+1>$L$13,\"\",K19+1),\"\")","v":25},26,27,28,29]
[null,{"$f":"IFERROR(IF(H19+1>$D$13,\"\",H19+1),\"\")","v":""},{"$f":"IFERROR(IF(B20+1>$D$13,\"\",B20+1),\"\")","v":""},{"$f":"IFERROR(IF(C20+1>$D$13,\"\",C20+1),\"\")","v":""},"","","","",null,{"$f":"IFERROR(IF(P19+1>$L$13,\"\",P19+1),\"\")","v":30},{"$f":"IFERROR(IF(J20+1>$L$13,\"\",J20+1),\"\")","v":""},{"$f":"IFERROR(IF(K20+1>$L$13,\"\",K20+1),\"\")","v":""},"","","",""]