{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Learn Excel","Class List","Deadlines","Weekly Schedule","Semester Calendar"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":12,"comments":1,"pivot_tables":1},"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":"Learn Excel","index":0,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10]]}
["Learn More From Our Free Excel Resources:"]
["Webinars: Formulas, Pivot Tables and Macros & VBA "]
["Blog Tutorials: Formulas, Pivot Tables, Charts, Macros, VBA, Power Query, Power Pivot, Analysis "]
["Excel Podcast Interviewing the Excel Experts "]

{"sheet":"Class List","index":1,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null," "]
[null,"Course ID","Course Name","Instructor","Day","Year","Semester","Time Start","Time End","Duration"]
[null,"CS 120","Intro to Computer Applications","Instructor 1","Monday",{"$f":"YEAR(TODAY())","v":2019},"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","Instructor 2","Tuesday",2019,"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","Instructor 2","Thursday",2019,"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","Instructor 3","Monday",2019,"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","Instructor 3","Wednesday",2019,"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","Instructor 4","Friday",2019,"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":2,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null," "]
[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":"YEAR(TODAY())","v":2019},"Spring","Quiz #1",{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2019-01-15"}]
[null,"CS 120",{"$f":"IFERROR(VLOOKUP(Table_Deadlines[[#This Row],[Course ID]],Table_ClassList[],2,0),\"\")","v":"Intro to Computer Applications"},2019,"Spring","Assignment #2",{"$f":"DATE(YEAR(TODAY()),2,4)","v":"2019-02-04"}]
[null,"WR 121",{"$f":"IFERROR(VLOOKUP(Table_Deadlines[[#This Row],[Course ID]],Table_ClassList[],2,0),\"\")","v":"Writing Composition"},2019,"Spring","Assignment #3",{"$f":"DATE(YEAR(TODAY()),2,5)","v":"2019-02-05"}]
[null,"CS 120",{"$f":"IFERROR(VLOOKUP(Table_Deadlines[[#This Row],[Course ID]],Table_ClassList[],2,0),\"\")","v":"Intro to Computer Applications"},2019,"Spring","Presentation #1",{"$f":"DATE(YEAR(TODAY()),2,18)","v":"2019-02-18"}]
[null,"CS 120",{"$f":"IFERROR(VLOOKUP(Table_Deadlines[[#This Row],[Course ID]],Table_ClassList[],2,0),\"\")","v":"Intro to Computer Applications"},2019,"Spring","Paper","2018-03-17"]
[null,"WR 121",{"$f":"IFERROR(VLOOKUP(Table_Deadlines[[#This Row],[Course ID]],Table_ClassList[],2,0),\"\")","v":"Writing Composition"},2019,"Spring","Assignment #2",{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2019-03-17"}]
[null,"WR 121",{"$f":"IFERROR(VLOOKUP(Table_Deadlines[[#This Row],[Course ID]],Table_ClassList[],2,0),\"\")","v":"Writing Composition"},2019,"Spring","Paper",{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2019-04-02"}]

{"sheet":"Weekly Schedule","index":3,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null," "]
[]
[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":4,"n_rows":17,"n_cols":19,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10],[9,1,9,2],[9,9,9,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"ScheduleStart","v":"2019-01-01"},null,{"$f":"DAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+1,1)-1)","v":31},{"$f":"WEEKDAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart),1),1)","v":3},null,null,null,null,{"$f":"DATE(ScheduleYear,MONTH(ScheduleStart)+1,1)","v":"2019-02-01"},null,{"$f":"DAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+2,1)-1)","v":28},{"$f":"WEEKDAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+1,1),1)","v":6}]
[null,"Sun","Mon","Tue","Wed","Thu","Fri","Sat",null,"Sun","Mon","Tue","Wed","Thu","Fri","Sat",null,"Year"]
[null,{"$f":"IF($E$2=COLUMN(A$2),1,IF(A4>0,A4+1,\"\"))","v":""},{"$f":"IF($E$2=COLUMN(B$2),1,IF(AND(B4>0,B4<>\"\"),B4+1,\"\"))","v":""},1,2,3,4,5,null,{"$f":"IF(M$2=COLUMN(A$2),1,IF(I4>0,I4+1,\"\"))","v":""},{"$f":"IF(M$2=COLUMN(B$2),1,IF(AND(J4>0,J4<>\"\"),J4+1,\"\"))","v":""},{"$f":"IF(M$2=COLUMN(C$2),1,IF(AND(K4>0,K4<>\"\"),K4+1,\"\"))","v":""},{"$f":"IF(M$2=COLUMN(D$2),1,IF(AND(L4>0,L4<>\"\"),L4+1,\"\"))","v":""},{"$f":"IF(M$2=COLUMN(E$2),1,IF(AND(M4>0,M4<>\"\"),M4+1,\"\"))","v":""},{"$f":"IF(M$2=COLUMN(F$2),1,IF(AND(N4>0,N4<>\"\"),N4+1,\"\"))","v":1},{"$f":"IF(M$2=COLUMN(G$2),1,IF(AND(O4>0,O4<>\"\"),O4+1,\"\"))","v":2},null,{"$f":"YEAR(TODAY())","v":2019}]
[null,{"$f":"H4+1","v":6},{"$f":"B5+1","v":7},{"$f":"C5+1","v":8},9,10,11,12,null,{"$f":"P4+1","v":3},{"$f":"J5+1","v":4},5,6,7,8,9,null,"Start Date"]
[null,{"$f":"H5+1","v":13},{"$f":"B6+1","v":14},15,16,17,18,19,null,{"$f":"P5+1","v":10},11,12,13,14,15,16,null,{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2019-01-01"}]
[null,20,21,22,23,24,25,26,null,{"$f":"P6+1","v":17},18,19,20,21,22,23]
[null,{"$f":"IFERROR(IF(H7+1>$D$2,\"\",H7+1),\"\")","v":27},{"$f":"IFERROR(IF(B8+1>$D$2,\"\",B8+1),\"\")","v":28},29,30,31,"","",null,{"$f":"IFERROR(IF(P7+1>L$2,\"\",P7+1),\"\")","v":24},{"$f":"IFERROR(IF(J8+1>L$2,\"\",J8+1),\"\")","v":25},{"$f":"IFERROR(IF(K8+1>L$2,\"\",K8+1),\"\")","v":26},{"$f":"IFERROR(IF(L8+1>L$2,\"\",L8+1),\"\")","v":27},{"$f":"IFERROR(IF(M8+1>L$2,\"\",M8+1),\"\")","v":28},{"$f":"IFERROR(IF(N8+L$2,\"\",N8+1),\"\")","v":""},{"$f":"IFERROR(IF(O8+1>L$2,\"\",O8+1),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(H8+1>$D$2,\"\",H8+1),\"\")","v":""},"","","","","","",null,{"$f":"IFERROR(IF(P8+1>L$2,\"\",P8+1),\"\")","v":""},{"$f":"IFERROR(IF(J9+1>L$2,\"\",J9+1),\"\")","v":""},{"$f":"IFERROR(IF(K9+1>L$2,\"\",K9+1),\"\")","v":""},{"$f":"IFERROR(IF(L9+1>L$2,\"\",L9+1),\"\")","v":""},{"$f":"IFERROR(IF(M9+1>L$2,\"\",M9+1),\"\")","v":""},{"$f":"IFERROR(IF(N9+1>L$2,\"\",N9+1),\"\")","v":""},{"$f":"IFERROR(IF(O9+L$2,\"\",O9+1),\"\")","v":""}]
[null,{"$f":"DATE(ScheduleYear,MONTH(ScheduleStart)+2,1)","v":"2019-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":6},null,null,null,null,{"$f":"DATE(ScheduleYear,MONTH(ScheduleStart)+3,1)","v":"2019-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":2}]
[null,"Sun","Mon","Tue","Wed","Thu","Fri","Sat",null,"Sun","Mon","Tue","Wed","Thu","Fri","Sat"]
[null,{"$f":"IF($E$10=COLUMN(A$2),1,IF(A12>0,A12+1,\"\"))","v":""},{"$f":"IF($E$10=COLUMN(B$2),1,IF(AND(B12>0,B12<>\"\"),B12+1,\"\"))","v":""},"","","",1,2,null,{"$f":"IF($M$10=COLUMN(A$2),1,IF(I12>0,I12+1,\"\"))","v":""},{"$f":"IF($M$10=COLUMN(B$2),1,IF(AND(J12>0,J12<>\"\"),J12+1,\"\"))","v":1},2,3,4,5,6]
[null,{"$f":"H12+1","v":3},{"$f":"B13+1","v":4},{"$f":"C13+1","v":5},6,7,8,9,null,{"$f":"P12+1","v":7},{"$f":"J13+1","v":8},{"$f":"K13+1","v":9},10,11,12,13]
[null,{"$f":"H13+1","v":10},{"$f":"B14+1","v":11},12,13,14,15,16,null,{"$f":"P13+1","v":14},{"$f":"J14+1","v":15},16,17,18,19,20]
[null,17,18,19,20,21,22,23,null,21,22,23,24,25,26,27]
[null,{"$f":"IFERROR(IF(H15+1>$D$10,\"\",H15+1),\"\")","v":24},{"$f":"IFERROR(IF(B16+1>$D$10,\"\",B16+1),\"\")","v":25},{"$f":"IFERROR(IF(C16+1>$D$10,\"\",C16+1),\"\")","v":26},27,28,29,30,null,{"$f":"IFERROR(IF(P15+1>$L$10,\"\",P15+1),\"\")","v":28},{"$f":"IFERROR(IF(J16+1>$L$10,\"\",J16+1),\"\")","v":29},{"$f":"IFERROR(IF(K16+1>$L$10,\"\",K16+1),\"\")","v":30},"","","",""]
[null,{"$f":"IFERROR(IF(H16+1>$D$10,\"\",H16+1),\"\")","v":31},{"$f":"IFERROR(IF(B17+1>$D$10,\"\",B17+1),\"\")","v":""},"","","","","",null,{"$f":"IFERROR(IF(P16+1>$L$10,\"\",P16+1),\"\")","v":""},{"$f":"IFERROR(IF(J17+1>$L$10,\"\",J17+1),\"\")","v":""},"","","","",""]