{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Class List","Work Data Entry","Weekly Schedule","Assignments Due Report","Semester Schedule"],"not_rendered":{"defined_names":15,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Class List","index":0,"n_rows":11,"n_cols":10,"rows_kept":11}
[null,"CLASS LIST"]
[]
[]
[null,"COURSE ID","NAME","INSTRUCTOR","DAY","YEAR","SEMESTER","TIME START","TIME END","DURATION"]
[null,"CS 120","Intro to Computer Applications","J. Bailey","Monday",2013,"Spring","14:00:00","15:30:00",{"$f":"IF(AND(ISNUMBER(tblClassList[[#This Row],[TIME END]]),ISNUMBER(tblClassList[[#This Row],[TIME START]])),tblClassList[[#This Row],[TIME END]]-tblClassList[[#This Row],[TIME START]],\"\")","v":"01:30:00"}]
[null,"CS 120","Intro to Computer Applications","J. Bailey","Wednesday",2013,"Spring","14:00:00","15:30:00",{"$f":"IF(AND(ISNUMBER(tblClassList[[#This Row],[TIME END]]),ISNUMBER(tblClassList[[#This Row],[TIME START]])),tblClassList[[#This Row],[TIME END]]-tblClassList[[#This Row],[TIME START]],\"\")","v":"01:30:00"}]
[null,"WR 121","Writing Composition","H. Garcia","Tuesday",2013,"Spring","10:00:00","11:30:00",{"$f":"IF(AND(ISNUMBER(tblClassList[[#This Row],[TIME END]]),ISNUMBER(tblClassList[[#This Row],[TIME START]])),tblClassList[[#This Row],[TIME END]]-tblClassList[[#This Row],[TIME START]],\"\")","v":"01:30:00"}]
[null,"WR 121","Writing Composition","H. Garcia","Thursday",2013,"Spring","10:00:00","11:30:00",{"$f":"IF(AND(ISNUMBER(tblClassList[[#This Row],[TIME END]]),ISNUMBER(tblClassList[[#This Row],[TIME START]])),tblClassList[[#This Row],[TIME END]]-tblClassList[[#This Row],[TIME START]],\"\")","v":"01:30:00"}]
[null,"SP 111","Public Speaking","T. Navarro","Monday",2013,"Spring","11:00:00","12:00:00",{"$f":"IF(AND(ISNUMBER(tblClassList[[#This Row],[TIME END]]),ISNUMBER(tblClassList[[#This Row],[TIME START]])),tblClassList[[#This Row],[TIME END]]-tblClassList[[#This Row],[TIME START]],\"\")","v":"01:00:00"}]
[null,"SP 111","Public Speaking","T. Navarro","Wednesday",2013,"Spring","11:00:00","12:00:00",{"$f":"IF(AND(ISNUMBER(tblClassList[[#This Row],[TIME END]]),ISNUMBER(tblClassList[[#This Row],[TIME START]])),tblClassList[[#This Row],[TIME END]]-tblClassList[[#This Row],[TIME START]],\"\")","v":"01:00:00"}]
[null,"PSY 101","Basic Psychology","K. Abercrombie","Monday",2013,"Spring","10:00:00","11:00:00",{"$f":"IF(AND(ISNUMBER(tblClassList[[#This Row],[TIME END]]),ISNUMBER(tblClassList[[#This Row],[TIME START]])),tblClassList[[#This Row],[TIME END]]-tblClassList[[#This Row],[TIME START]],\"\")","v":"01:00:00"}]

{"sheet":"Work Data Entry","index":1,"n_rows":12,"n_cols":7,"rows_kept":12}
[null,"WORK DATA ENTRY"]
[]
[]
[null,"COURSE ID","NAME","YEAR","SEMESTER","ITEM DESCRIPTION","DUE DATE"]
[null,"CS 120",{"$f":"VLOOKUP(tblWork[[#This Row],[COURSE ID]],tblClassList[],2,0)","v":"Intro to Computer Applications"},2013,"Spring","Assignment #2","2013-02-27"]
[null,"CS 120",{"$f":"VLOOKUP(tblWork[[#This Row],[COURSE ID]],tblClassList[],2,0)","v":"Intro to Computer Applications"},2013,"Spring","Presentation #1","2013-02-03"]
[null,"CS 120",{"$f":"VLOOKUP(tblWork[[#This Row],[COURSE ID]],tblClassList[],2,0)","v":"Intro to Computer Applications"},2013,"Spring","Quiz #1","2013-03-08"]
[null,"WR 121",{"$f":"VLOOKUP(tblWork[[#This Row],[COURSE ID]],tblClassList[],2,0)","v":"Writing Composition"},2013,"Spring","Assignment #1","2013-04-28"]
[null,"WR 121",{"$f":"VLOOKUP(tblWork[[#This Row],[COURSE ID]],tblClassList[],2,0)","v":"Writing Composition"},2013,"Spring","Quiz #1","2013-01-14"]
[null,"WR 121",{"$f":"VLOOKUP(tblWork[[#This Row],[COURSE ID]],tblClassList[],2,0)","v":"Writing Composition"},2013,"Spring","Assignment #2","2013-03-21"]
[null,"WR 121",{"$f":"VLOOKUP(tblWork[[#This Row],[COURSE ID]],tblClassList[],2,0)","v":"Writing Composition"},2013,"Spring","Assignment #3","2013-02-04"]
[null,"WR 121",{"$f":"VLOOKUP(tblWork[[#This Row],[COURSE ID]],tblClassList[],2,0)","v":"Writing Composition"},2013,"Spring","Assignment #4","2013-04-07"]

{"sheet":"Weekly Schedule","index":2,"n_rows":11,"n_cols":4,"rows_kept":11}
[null,"WEEKLY SCHEDULE"]
[]
[]
[null,"DAY","TIME START","CLASS "]
[null,"Monday","10:00:00","Basic Psychology"]
[null,"Monday","11:00:00","Public Speaking"]
[null,"Monday","14:00:00","Intro to Computer Applications"]
[null,"Tuesday","10:00:00","Writing Composition"]
[null,"Wednesday","11:00:00","Public Speaking"]
[null,"Wednesday","14:00:00","Intro to Computer Applications"]
[null,"Thursday","10:00:00","Writing Composition"]

{"sheet":"Assignments Due Report","index":3,"n_rows":12,"n_cols":5,"rows_kept":12}
[null,"ASSIGNMENTS DUE REPORT"]
[]
[]
[null,"COURSE ID","NAME","ITEM DESCRIPTION","DUE DATE"]
[null,"CS 120","Intro to Computer Applications","Assignment #2","2013-02-27"]
[{"$nulls":3},"Presentation #1","2013-02-03"]
[{"$nulls":3},"Quiz #1","2013-03-08"]
[null,"WR 121","Writing Composition","Assignment #1","2013-04-28"]
[{"$nulls":3},"Assignment #2","2013-03-21"]
[{"$nulls":3},"Assignment #3","2013-02-04"]
[{"$nulls":3},"Assignment #4","2013-04-07"]
[{"$nulls":3},"Quiz #1","2013-01-14"]

{"sheet":"Semester Schedule","index":4,"n_rows":21,"n_cols":21,"rows_kept":21}
[null,"SEMESTER SCHEDULE"]
[]
[]
[{"$nulls":4},{"$f":"DAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+1,1)-1)","v":28},{"$f":"WEEKDAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart),1),1)","v":6},{"$nulls":6},{"$f":"DAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+2,1)-1)","v":31},{"$f":"WEEKDAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+1,1),1)","v":6}]
[{"$nulls":4},{"$f":"UPPER(TEXT(ScheduleStart,\"MMMM\"))","v":"FEBRUARY"},{"$nulls":7},{"$f":"UPPER(TEXT(DATE(ScheduleYear,MONTH(ScheduleStart)+1,1),\"MMMM\"))","v":"MARCH"}]
[{"$nulls":4},"S","M","T","W","T","F","S",null,"S","M","T","W","T","F","S",null,"YEAR"]
[{"$nulls":4},{"$f":"IF($F$4=COLUMN(A$3),1,IF(D7>0,D7+1,\"\"))","v":""},{"$f":"IF($F$4=COLUMN(B$3),1,IF(AND(E7>0,E7<>\"\"),E7+1,\"\"))","v":""},"","","",1,2,null,{"$f":"IF($N$4=COLUMN(A$3),1,IF(L7>0,L7+1,\"\"))","v":""},{"$f":"IF($N$4=COLUMN(B$3),1,IF(AND(M7>0,M7<>\"\"),M7+1,\"\"))","v":""},"","","",1,2,null,2013]
[{"$nulls":4},{"$f":"K7+1","v":3},{"$f":"E8+1","v":4},{"$f":"F8+1","v":5},6,7,8,9,null,{"$f":"S7+1","v":3},{"$f":"M8+1","v":4},5,6,7,8,9,null,"START DATE"]
[{"$nulls":4},{"$f":"K8+1","v":10},{"$f":"E9+1","v":11},12,13,14,15,16,null,{"$f":"S8+1","v":10},11,12,13,14,15,16,null,"2013-02-18"]
[{"$nulls":4},17,{"$f":"E10+1","v":18},19,20,21,22,23,null,{"$f":"S9+1","v":17},18,19,20,21,22,23,null,"END DATE"]
[{"$nulls":4},{"$f":"IFERROR(IF(K10+1>$E$4,\"\",K10+1),\"\")","v":24},{"$f":"IFERROR(IF(E11+1>$E$4,\"\",E11+1),\"\")","v":25},26,27,28,"","",null,{"$f":"IFERROR(IF(S10+1>$M$4,\"\",S10+1),\"\")","v":24},{"$f":"IFERROR(IF(M11+1>$M$4,\"\",M11+1),\"\")","v":25},26,27,28,29,30,null,"2013-05-15"]
[{"$nulls":4},{"$f":"IFERROR(IF(K11+1>$E$4,\"\",K11+1),\"\")","v":""},"","","","","","",null,{"$f":"IFERROR(IF(S11+1>$M$4,\"\",S11+1),\"\")","v":31},"","","","","",""]
[{"$nulls":4},{"$f":"DAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+3,1)-1)","v":30},{"$f":"WEEKDAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+2,1),1)","v":2},{"$nulls":6},{"$f":"DAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+4,1)-1)","v":31},{"$f":"WEEKDAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+3,1),1)","v":4}]
[{"$nulls":4},{"$f":"UPPER(TEXT(DATE(ScheduleYear,MONTH(ScheduleStart)+2,1),\"MMMM\"))","v":"APRIL"},{"$nulls":7},{"$f":"UPPER(TEXT(DATE(ScheduleYear,MONTH(ScheduleStart)+3,1),\"MMMM\"))","v":"MAY"}]
[{"$nulls":4},"S","M","T","W","T","F","S",null,"S","M","T","W","T","F","S"]
[{"$nulls":4},{"$f":"IF($F$13=COLUMN(A$3),1,IF(D16>0,D16+1,\"\"))","v":""},{"$f":"IF($F$13=COLUMN(B$3),1,IF(AND(E16>0,E16<>\"\"),E16+1,\"\"))","v":1},2,3,4,5,6,null,{"$f":"IF($N$13=COLUMN(A$3),1,IF(L16>0,L16+1,\"\"))","v":""},{"$f":"IF($N$13=COLUMN(B$3),1,IF(AND(M16>0,M16<>\"\"),M16+1,\"\"))","v":""},"",1,2,3,4]
[{"$nulls":4},{"$f":"K16+1","v":7},{"$f":"E17+1","v":8},{"$f":"F17+1","v":9},10,11,12,13,null,{"$f":"S16+1","v":5},{"$f":"M17+1","v":6},{"$f":"N17+1","v":7},8,9,10,11]
[{"$nulls":4},{"$f":"K17+1","v":14},{"$f":"E18+1","v":15},16,17,18,19,20,null,{"$f":"S17+1","v":12},{"$f":"M18+1","v":13},14,15,16,17,18]
[{"$nulls":4},21,{"$f":"E19+1","v":22},23,24,25,26,27,null,19,{"$f":"M19+1","v":20},21,22,23,24,25]
[{"$nulls":4},{"$f":"IFERROR(IF(K19+1>$E$13,\"\",K19+1),\"\")","v":28},{"$f":"IFERROR(IF(E20+1>$E$13,\"\",E20+1),\"\")","v":29},30,"","","","",null,{"$f":"IFERROR(IF(S19+1>$M$13,\"\",S19+1),\"\")","v":26},{"$f":"IFERROR(IF(M20+1>$M$13,\"\",M20+1),\"\")","v":27},28,29,30,31,""]
[{"$nulls":4},{"$f":"IFERROR(IF(K20+1>$E$13,\"\",K20+1),\"\")","v":""},"","","","","","",null,{"$f":"IFERROR(IF(S20+1>$M$13,\"\",S20+1),\"\")","v":""},"","","","","",""]