{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["수업 목록","마감일","주간 일정","학기 일정"],"not_rendered":{"defined_names":24,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"수업 목록","index":0,"n_rows":9,"n_cols":10,"rows_kept":9,"merged":[[0,1,0,9],[2,11,7,11]]}
[null,"수업 목록"]
[null,"강의 ID","이름","강사","요일","연도","학기","시작 시간","종료 시간","기간"]
[null,"CS 120","컴퓨터 응용 프로그램 입문","강사 1","월요일",{"$f":"YEAR(TODAY())","v":2022},"봄","14:00:00","15:30:00",{"$f":"IF(AND(ISNUMBER(ClassListTable[[#This Row],[종료 시간]]),ISNUMBER(ClassListTable[[#This Row],[시작 시간]])),ClassListTable[[#This Row],[종료 시간]]-ClassListTable[[#This Row],[시작 시간]],\"\")","v":"01:30:00"}]
[null,"CS 120","컴퓨터 응용 프로그램 입문","강사 1","수요일",{"$f":"YEAR(TODAY())","v":2022},"봄","14:00:00","15:30:00",{"$f":"IF(AND(ISNUMBER(ClassListTable[[#This Row],[종료 시간]]),ISNUMBER(ClassListTable[[#This Row],[시작 시간]])),ClassListTable[[#This Row],[종료 시간]]-ClassListTable[[#This Row],[시작 시간]],\"\")","v":"01:30:00"}]
[null,"WR 121","컴퍼지션 작성","강사 2","화요일",2022,"봄","10:00:00","11:30:00",{"$f":"IF(AND(ISNUMBER(ClassListTable[[#This Row],[종료 시간]]),ISNUMBER(ClassListTable[[#This Row],[시작 시간]])),ClassListTable[[#This Row],[종료 시간]]-ClassListTable[[#This Row],[시작 시간]],\"\")","v":"01:30:00"}]
[null,"WR 121","컴퍼지션 작성","강사 2","목요일",2022,"봄","10:00:00","11:30:00",{"$f":"IF(AND(ISNUMBER(ClassListTable[[#This Row],[종료 시간]]),ISNUMBER(ClassListTable[[#This Row],[시작 시간]])),ClassListTable[[#This Row],[종료 시간]]-ClassListTable[[#This Row],[시작 시간]],\"\")","v":"01:30:00"}]
[null,"SP 111","발표","강사 3","월요일",2022,"봄","11:00:00","12:00:00",{"$f":"IF(AND(ISNUMBER(ClassListTable[[#This Row],[종료 시간]]),ISNUMBER(ClassListTable[[#This Row],[시작 시간]])),ClassListTable[[#This Row],[종료 시간]]-ClassListTable[[#This Row],[시작 시간]],\"\")","v":"01:00:00"}]
[null,"SP 111","발표","강사 3","수요일",2022,"봄","11:00:00","12:00:00",{"$f":"IF(AND(ISNUMBER(ClassListTable[[#This Row],[종료 시간]]),ISNUMBER(ClassListTable[[#This Row],[시작 시간]])),ClassListTable[[#This Row],[종료 시간]]-ClassListTable[[#This Row],[시작 시간]],\"\")","v":"01:00:00"}]
[null,"PSY 101","기본 심리학","강사 4","금요일",2022,"봄","10:00:00","11:00:00",{"$f":"IF(AND(ISNUMBER(ClassListTable[[#This Row],[종료 시간]]),ISNUMBER(ClassListTable[[#This Row],[시작 시간]])),ClassListTable[[#This Row],[종료 시간]]-ClassListTable[[#This Row],[시작 시간]],\"\")","v":"01:00:00"}]

{"sheet":"마감일","index":1,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[0,1,0,6],[2,8,7,8]]}
[null,"마감일"]
[null,"강의 ID","이름","연도","학기","항목 설명","기한"]
[null,"WR 121",{"$f":"IFERROR(VLOOKUP(작업[[#This Row],[강의 ID]],ClassListTable[],2,0),\"\")","v":"컴퍼지션 작성"},{"$f":"YEAR(TODAY())","v":2022},"봄","퀴즈 #1",{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2022-01-15"}]
[null,"CS 120",{"$f":"IFERROR(VLOOKUP(작업[[#This Row],[강의 ID]],ClassListTable[],2,0),\"\")","v":"컴퓨터 응용 프로그램 입문"},{"$f":"YEAR(TODAY())","v":2022},"봄","과제 #2",{"$f":"DATE(YEAR(TODAY()),2,4)","v":"2022-02-04"}]
[null,"WR 121",{"$f":"IFERROR(VLOOKUP(작업[[#This Row],[강의 ID]],ClassListTable[],2,0),\"\")","v":"컴퍼지션 작성"},2022,"봄","과제 #3",{"$f":"DATE(YEAR(TODAY()),2,5)","v":"2022-02-05"}]
[null,"CS 120",{"$f":"IFERROR(VLOOKUP(작업[[#This Row],[강의 ID]],ClassListTable[],2,0),\"\")","v":"컴퓨터 응용 프로그램 입문"},2022,"봄","프레젠테이션 #1",{"$f":"DATE(YEAR(TODAY()),2,18)","v":"2022-02-18"}]
[null,"CS 120",{"$f":"IFERROR(VLOOKUP(작업[[#This Row],[강의 ID]],ClassListTable[],2,0),\"\")","v":"컴퓨터 응용 프로그램 입문"},2022,"봄","과제물",{"$f":"DATE(YEAR(TODAY()),3,11)","v":"2022-03-11"}]
[null,"WR 121",{"$f":"IFERROR(VLOOKUP(작업[[#This Row],[강의 ID]],ClassListTable[],2,0),\"\")","v":"컴퍼지션 작성"},2022,"봄","과제 #2",{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2022-03-17"}]
[null,"WR 121",{"$f":"IFERROR(VLOOKUP(작업[[#This Row],[강의 ID]],ClassListTable[],2,0),\"\")","v":"컴퍼지션 작성"},2022,"봄","과제물",{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2022-04-02"}]

{"sheet":"주간 일정","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"merged":[[0,1,0,3],[2,5,7,5]]}
[null,"주간 일정"]
[null,"요일","시작 시간","이름"]
[null,"월요일","11:00:00","발표"]
[null,null,"14:00:00","컴퓨터 응용 프로그램 입문"]
[null,"화요일","10:00:00","컴퍼지션 작성"]
[null,"수요일","11:00:00","발표"]
[null,null,"14:00:00","컴퓨터 응용 프로그램 입문"]
[null,"목요일","10:00:00","컴퍼지션 작성"]
[null,"금요일","10:00:00","기본 심리학"]

{"sheet":"학기 일정","index":3,"n_rows":17,"n_cols":18,"rows_kept":17,"merged":[[0,1,0,15],[1,1,1,2],[1,9,1,10],[3,18,8,18]]}
[null,"학기 일정"]
[null,{"$f":"UPPER(TEXT(ScheduleStart,\"m월\"))","v":"1월"},null,{"$f":"DAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+1,1)-1)","v":31},{"$f":"WEEKDAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart),1),1)","v":7},{"$nulls":4},{"$f":"UPPER(TEXT(DATE(ScheduleYear,MONTH(ScheduleStart)+1,1),\"m월\"))","v":"2월"},null,{"$f":"DAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+2,1)-1)","v":28},{"$f":"WEEKDAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+1,1),1)","v":3}]
[null,"일","월","화","수","목","금","토",null,"일","월","화","수","목","금","토",null,"연도"]
[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,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":1},{"$f":"IF(M$2=COLUMN(D$2),1,IF(AND(L4>0,L4<>\"\"),L4+1,\"\"))","v":2},{"$f":"IF(M$2=COLUMN(E$2),1,IF(AND(M4>0,M4<>\"\"),M4+1,\"\"))","v":3},{"$f":"IF(M$2=COLUMN(F$2),1,IF(AND(N4>0,N4<>\"\"),N4+1,\"\"))","v":4},{"$f":"IF(M$2=COLUMN(G$2),1,IF(AND(O4>0,O4<>\"\"),O4+1,\"\"))","v":5},null,{"$f":"YEAR(TODAY())","v":2022}]
[null,{"$f":"H4+1","v":2},{"$f":"B5+1","v":3},{"$f":"C5+1","v":4},5,6,7,8,null,{"$f":"P4+1","v":6},{"$f":"J5+1","v":7},8,9,10,11,12,null,"시작 날짜"]
[null,{"$f":"H5+1","v":9},{"$f":"B6+1","v":10},11,12,13,14,15,null,{"$f":"P5+1","v":13},14,15,16,17,18,19,null,{"$f":"DATE(YEAR(TODAY()),1,6)","v":"2022-01-06"}]
[null,16,{"$f":"B7+1","v":17},18,19,20,21,22,null,{"$f":"P6+1","v":20},21,22,23,24,25,26,null,"종료 날짜"]
[null,{"$f":"IFERROR(IF(H7+1>$D$2,\"\",H7+1),\"\")","v":23},{"$f":"IFERROR(IF(B8+1>$D$2,\"\",B8+1),\"\")","v":24},25,26,27,28,29,null,{"$f":"IFERROR(IF(P7+1>L$2,\"\",P7+1),\"\")","v":27},{"$f":"IFERROR(IF(J8+1>L$2,\"\",J8+1),\"\")","v":28},{"$f":"IFERROR(IF(K8+1>L$2,\"\",K8+1),\"\")","v":""},{"$f":"IFERROR(IF(L8+1>L$2,\"\",L8+1),\"\")","v":""},{"$f":"IFERROR(IF(M8+1>L$2,\"\",M8+1),\"\")","v":""},{"$f":"IFERROR(IF(N8+L$2,\"\",N8+1),\"\")","v":""},{"$f":"IFERROR(IF(O8+1>L$2,\"\",O8+1),\"\")","v":""},null,{"$f":"DATE(YEAR(TODAY()),4,25)","v":"2022-04-25"}]
[null,{"$f":"IFERROR(IF(H8+1>$D$2,\"\",H8+1),\"\")","v":30},31,"","","","","",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":"UPPER(TEXT(DATE(ScheduleYear,MONTH(ScheduleStart)+2,1),\"m월\"))","v":"3월"},null,{"$f":"DAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+3,1)-1)","v":31},{"$f":"WEEKDAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+2,1),1)","v":3},{"$nulls":4},{"$f":"UPPER(TEXT(DATE(ScheduleYear,MONTH(ScheduleStart)+3,1),\"m월\"))","v":"4월"},null,{"$f":"DAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+4,1)-1)","v":30},{"$f":"WEEKDAY(DATE(YEAR(ScheduleStart),MONTH(ScheduleStart)+3,1),1)","v":6}]
[null,"일","월","화","수","목","금","토",null,"일","월","화","수","목","금","토"]
[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":""},{"$f":"IF($E$10=COLUMN(C$2),1,IF(AND(C12>0,C12<>\"\"),C12+1,\"\"))","v":1},2,3,4,5,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":""},{"$f":"IF($M$10=COLUMN(C$2),1,IF(AND(K12>0,K12<>\"\"),K12+1,\"\"))","v":""},"","",1,2]
[null,{"$f":"H12+1","v":6},{"$f":"B13+1","v":7},{"$f":"C13+1","v":8},9,10,11,12,null,{"$f":"P12+1","v":3},{"$f":"J13+1","v":4},{"$f":"K13+1","v":5},6,7,8,9]
[null,{"$f":"H13+1","v":13},{"$f":"B14+1","v":14},15,16,17,18,19,null,{"$f":"P13+1","v":10},{"$f":"J14+1","v":11},12,13,14,15,16]
[null,20,{"$f":"B15+1","v":21},22,23,24,25,26,null,17,{"$f":"J15+1","v":18},19,20,21,22,23]
[null,{"$f":"IFERROR(IF(H15+1>$D$10,\"\",H15+1),\"\")","v":27},{"$f":"IFERROR(IF(B16+1>$D$10,\"\",B16+1),\"\")","v":28},{"$f":"IFERROR(IF(C16+1>$D$10,\"\",C16+1),\"\")","v":29},30,31,"","",null,{"$f":"IFERROR(IF(P15+1>$L$10,\"\",P15+1),\"\")","v":24},{"$f":"IFERROR(IF(J16+1>$L$10,\"\",J16+1),\"\")","v":25},{"$f":"IFERROR(IF(K16+1>$L$10,\"\",K16+1),\"\")","v":26},27,28,29,30]
[null,{"$f":"IFERROR(IF(H16+1>$D$10,\"\",H16+1),\"\")","v":""},{"$f":"IFERROR(IF(B17+1>$D$10,\"\",B17+1),\"\")","v":""},{"$f":"IFERROR(IF(C17+1>$D$10,\"\",C17+1),\"\")","v":""},"","","","",null,{"$f":"IFERROR(IF(P16+1>$L$10,\"\",P16+1),\"\")","v":""},{"$f":"IFERROR(IF(J17+1>$L$10,\"\",J17+1),\"\")","v":""},{"$f":"IFERROR(IF(K17+1>$L$10,\"\",K17+1),\"\")","v":""},"","","",""]