;; %%%%%%%%%%%%%%%%%
;; Turgay Korkmaz
;; I got the content of this file from excel
;; in excel
;; firs mark (add) new courses that will be offered 
;;      this semester but not offered in previous year
;;      then generate add commands (see excel file)
;; Second generate cancel and istructor commands (see excel file)
;; to determine which ones are canceled and who the instructors are
;;

; after the first round
;=CONCATENATE("crn ",MID(B2,3,5), " 00",C2," ",D2)
;crn  1063 003 19996
;crn  1173 006 203
 
;by hand
;cancel 5713 002

cancel 5623 901
;	20453	Simulation_L5
cancel 6643 001
;	23168	Par. Proc_L5	
cancel 4633 901
;	19779	Simulation_L4
cancel 4723 901
;	14686	Soft. Valid_L4
cancel 4473 901
;	18528	Cryptocurr Bitcoin_L4
cancel 4223 901
;	22130	Bioinfo-I: Alg-Bio-Data_L4
cancel 3523 001
;	19757	Win Sys. Prog_L3
			
cancel 3743 004	
;	19416	DB Sys_L3
cancel 3723 003
;	16280	Prog Lang_L3
cancel 2073 001
;	12009	Eng App


;; ADD
add 6543 901 TR 6:00-7:15pm
add 3853 004 MW 4:00-5:15pm
add 3843 006 MWF 1:00-1:50pm
add 3423 004 MW 6:00-7:15pm
add 2233 007 TR 2:30-3:45pm
add 2233 006 TR 11:30-12:45pm
add 2123 006 MW 6:00-7:15pm
add 2113 002 TR 11:30-12:45pm
add 2113 001 TR 10:00-11:15am
add 2713 006 TR 10:00-11:15am
add 1153 001 MWF 11:00-11:50am
add 1083 008 TR 2:30-3:45pm
add 1083 007 TR 1:00-2:15pm
cancel 5153 002
add 5153 901 TR 7:30-8:45pm

cancel 4743 001
add 4743 901 TR 10:30-11:45am

;;; TIME
time 1063 001 TBA TBA
time 1083 001 MWF 9:00-9:50am
time 1083 002 MWF 10:00-10:50am
time 1083 003 MWF 1:00-1:50pm
time 1083 004 MWF 2:00-2:50pm
time 1083 005 TR 10:00-11:15am
time 1083 006 TR 11:30-12:45pm
time 1083 007 TR 1:00-2:15pm
time 1083 008 TR 2:30-3:45pm
time 1153 001 MWF 11:00-11:50am
time 1173 001 TR 10:00-11:15am
time 1173 002 TR 11:30-12:45pm
time 1173 003 TBA TBA
time 1173 004 TBA TBA
time 1173 005 TR 2:30-3:45pm
time 2713 001 MWF 2:00-2:50pm
time 2713 002 MW 6:00-7:15pm
time 2713 003 TR 1:00-2:15pm
time 2713 004 MWF 11:00-11:50am
time 2713 005 TR 2:30-3:45pm
time 2713 006 TR 10:00-11:15am
time 2113 001 TR 10:00-11:15am
time 2113 002 TR 11:30-12:45pm
time 2123 001 TR 1:00-2:15pm
time 2123 002 MWF 12:00-12:50pm
time 2123 003 TR 8:30-9:45am
time 2123 004 TR 10:00-11:15am
time 2123 005 MWF 11:00-11:50am
time 2123 006 MW 6:00-7:15pm
time 2233 001 MWF 10:00-10:50am
time 2233 002 MWF 11:00-11:50am
time 2233 003 MWF 12:00-12:50pm
time 2233 004 MWF 1:00-1:50pm
time 2233 005 MWF 2:00-2:50pm
time 2233 006 TR 11:30-12:45pm
time 2233 007 TR 2:30-3:45pm
time 3113 001 TBA TBA
time 3113 002 TBA TBA
time 3333 002 MWF 10:00-10:50am
time 3333 003 MWF 11:00-11:50am
time 3333 004 MWF 2:00-2:50pm
time 3333 001 MWF 9:00-9:50am
time 3343 001 MWF 12:00-12:50pm
time 3343 002 TR 8:30-9:45am
time 3343 003 MWF 1:00-1:50pm
time 3423 001 MWF 10:00-10:50am
time 3423 002 MWF 2:00-2:50pm
time 3423 003 TR 6:00-7:15pm
time 3423 004 MW 6:00-7:15pm
time 3433 001 MWF 3:00-3:50pm
time 3443 003 TR 1:00-2:15pm
time 3443 001 MWF 10:00-10:50am
time 3443 002 MWF 11:00-11:50am
time 3443 004 TR 2:30-3:45pm
time 3723 001 TR 11:30-12:45pm
time 3723 002 MWF 9:00-9:50am
time 3733 001 TR 10:00-11:15am
time 3733 002 TR 11:30-12:45pm
time 3733 003 TR 2:30-3:45pm
time 3743 001 TR 10:00-11:15am
time 3743 002 TR 4:00-5:15pm
time 3743 003 TBA TBA
time 3753 901 TR 10:00-11:15am
time 3773 001 TR 1:00-2:15pm
time 3773 002 MWF 9:00-9:50am
time 3793 901 TR 2:30-3:45pm
time 3843 001 MWF 9:00-9:50am
time 3843 002 TR 1:00-2:15pm
time 3843 003 MW 6:00-7:15pm
time 3843 004 TR 11:30-12:45pm
time 3843 005 TR 11:30-12:45pm
time 3843 006 MWF 1:00-1:50pm
time 3853 001 MW 7:30-8:45pm
time 3853 002 TR 2:30-3:45pm
time 3853 003 TR 4:00-5:15pm
time 3853 004 MW 4:00-5:15pm
time 3873 001 MW 4:00-5:15pm
time 4013 901 TR 4:00-5:15pm
time 4023 901 TR 6:00-7:15pm
time 4253 901 TR 4:00-5:15pm
time 4333 901 TR 4:00-5:15pm
time 4373 901 TR 11:30-12:45pm
time 4393 001 TR 2:30-3:45pm
time 4393 002 TR 4:00-5:15pm
time 4413 001 MWF 9:00-9:50am
time 4413 002 TR 8:30-9:45am
time 4423 001 TR 6:00-7:15pm
time 4613 901 F 1:00-3:45pm
time 4623 901 F 1:00-3:45pm
time 4663 901 TR 10:00-11:15am
time 4673 001 TBA TBA
time 4683 901 TR 1:00-2:15pm
time 4743 901 TR 10:30-11:45am
time 4773 901 TR 11:30-12:45pm
time 4823 001 MW 7:30-8:45pm
time 4833 001 S 10:00-12:45pm
time 4843 001 TBA TBA 
time 5013 901 TR 4:00-5:15pm
time 5023 901 TR 6:00-7:15pm
time 5123 901 MW 7:30-8:45pm
time 5153 901 TR 7:30-8:45pm
time 5163 901 TR 2:30-3:45pm
time 5233 901 TR 6:00-7:15pm
time 5243 901 MW 1:00-2:15pm
time 5323 901 MW 2:30-3:45pm
time 5343 001 TR 4:00-5:15pm
time 5443 901 TR 2:30-3:45pm
time 5463 901 TR 4:00-5:15pm
time 5473 901 TR 4:00-5:15pm
time 5513 002 S 1:00-3:45pm
time 5523 901 MW 4:00-5:15pm
time 5573 001 TBA TBA
time 5633 901 MW 6:00-7:15pm
time 5713 903 TR 2:30-3:45pm
time 5723 901 MW 6:00-7:15pm
time 6243 901 MW 4:00-5:15pm
time 6353 901 MW 4:00-5:15pm
time 6463 901 W 12:00-12:50pm
time 6543 901 TR 6:00-7:15pm

;;;;; mod
mod 1063 001 "Online only, no set time"
mod 1083 001 "Online only, at set time"
mod 1083 002 "Online only, at set time"
mod 1083 003 Traditional in-person
mod 1083 004 Traditional in-person
mod 1083 005 Traditional in-person
mod 1083 006 Traditional in-person
mod 1083 007 Traditional in-person
mod 1083 008 Traditional in-person
mod 1153 001 Traditional in-person
mod 1173 001 Traditional in-person
mod 1173 002 Traditional in-person
mod 1173 003 "Online only, no set time"
mod 1173 004 "Online only, no set time"
mod 1173 005 Traditional in-person
mod 2713 001 Traditional in-person
mod 2713 002 "Online only, at set time"
mod 2713 003 Traditional in-person
mod 2713 004 Traditional in-person
mod 2713 005 "Online only, at set time"
mod 2713 006 Traditional in-person
mod 2113 001 Traditional in-person
mod 2113 002 Traditional in-person
mod 2123 001 "Online only, at set time"
mod 2123 002 Traditional in-person
mod 2123 003 Traditional in-person
mod 2123 004 Traditional in-person
mod 2123 005 Traditional in-person
mod 2123 006 "Online only, at set time"
mod 2233 001 "Online only, at set time"
mod 2233 002 "Online only, at set time"
mod 2233 003 Traditional in-person
mod 2233 004 Traditional in-person
mod 2233 005 Traditional in-person
mod 2233 006 Traditional in-person
mod 2233 007 Traditional in-person
mod 3113 001 "Online only, no set time"
mod 3113 002 "Online only, no set time"
mod 3333 001 "Online only, at set time"
mod 3333 002 Traditional in-person
mod 3333 003 Traditional in-person
mod 3333 004 Traditional in-person
mod 3343 001 Traditional in-person
mod 3343 002 "Online only, at set time"
mod 3343 003 Traditional in-person
mod 3423 001 Traditional in-person
mod 3423 002 Traditional in-person
mod 3423 003 "Online only, at set time"
mod 3423 004 Traditional in-person
mod 3433 001 Traditional in-person
mod 3443 001 Traditional in-person
mod 3443 002 Traditional in-person
mod 3443 003 Traditional in-person
mod 3443 004 "Online only, at set time"
mod 3723 001 Traditional in-person
mod 3723 002 "Online only, at set time"
mod 3733 001 "Online only, at set time"
mod 3733 002 Traditional in-person
mod 3733 003 Traditional in-person
mod 3743 001 "Online only, at set time"
mod 3743 002 Traditional in-person
mod 3743 003 "Online only, no set time"
mod 3753 901 Traditional in-person
mod 3773 001 "Online only, at set time"
mod 3773 002 Traditional in-person
mod 3793 901 Traditional in-person
mod 3843 001 "Online only, at set time"
mod 3843 002 Traditional in-person
mod 3843 003 Traditional in-person
mod 3843 004 Traditional in-person
mod 3843 005 "Online only, at set time"
mod 3843 006 Traditional in-person
mod 3853 001 Traditional in-person
mod 3853 002 "Online only, at set time"
mod 3853 003 Traditional in-person
mod 3853 004 Traditional in-person
mod 3873 001 Traditional in-person
mod 4013 901 Traditional in-person
mod 4023 901 Traditional in-person
mod 4253 901 Traditional in-person
mod 4333 901 Traditional in-person
mod 4373 901 Traditional in-person
mod 4393 001 "Online only, at set time"
mod 4393 002 "Online only, at set time"
mod 4413 001 Traditional in-person
mod 4413 002 "Online only, at set time"
mod 4423 001 "Online only, at set time"
mod 4613 901 Traditional in-person
mod 4623 901 Traditional in-person
mod 4663 901 Traditional in-person
mod 4673 001 "Online only, no set time"
mod 4683 901 Traditional in-person
mod 4743 901 Traditional in-person
mod 4773 901 Traditional in-person
mod 4823 001 "Online only, at set time"
mod 4833 001 Traditional in-person
mod 4843 001 "Online only, no set time"
mod 5013 901 Traditional in-person
mod 5023 901 Traditional in-person
mod 5123 901 "Online only, at set time"
mod 5153 901 "Online only, at set time"
mod 5163 901 Traditional in-person
mod 5233 901 Traditional in-person
mod 5243 901 Traditional in-person
mod 5323 901 Traditional in-person
mod 5343 001 Traditional in-person
mod 5443 901 Traditional in-person
mod 5463 901 Traditional in-person
mod 5473 901 Traditional in-person
mod 5513 002 Traditional in-person
mod 5523 901 Traditional in-person
mod 5573 001 "Online only, no set time"
mod 5633 901 Traditional in-person
mod 5713 903 Traditional in-person
mod 5723 901 Traditional in-person
mod 6243 901 Traditional in-person
mod 6353 901 Traditional in-person
mod 6463 901 "Mostly online, some in-person"
mod 6543 901 Traditional in-person


instructor 1063 001 Rutherford, L.
instructor 1083 001 Gomez Morales
instructor 1083 002 Gomez Morales
instructor 1083 003 Valadez
instructor 1083 004 Valadez
instructor 1083 005 Arslan
instructor 1083 006 Long
instructor 1083 007 Arslan
instructor 1083 008 Heaps
instructor 1153 001 Ang
instructor 1173 001 Alkittawi
instructor 1173 002 Alkittawi
instructor 1173 003 Rutherford, L.
instructor 1173 004 Rutherford, L.
instructor 1173 005 Rutherford, L.
instructor 2713 001 Dogru
instructor 2713 002 Desai
instructor 2713 003 Ang
instructor 2713 004 Dogru
instructor 2713 005 Gomez Morales
instructor 2713 006 Ang
instructor 2113 001 Heaps
instructor 2113 002 Heaps
instructor 2123 001 Siddiqi
instructor 2123 002 Sherette
instructor 2123 003 Siddiqi
instructor 2123 004 Siddiqi
instructor 2123 005 Sherette
instructor 2123 006 Sherette
instructor 2233 001 Arslan
instructor 2233 002 Arslan
instructor 2233 003 Long
instructor 2233 004 Long
instructor 2233 005 Long
instructor 2233 006 NEED
instructor 2233 007 NEED
instructor 3113 001 Richards, K.
instructor 3113 002 Richards, K.
instructor 3333 001 Sahba, A.
instructor 3333 002 Sahba, A.
instructor 3333 003 Sahba, R.
instructor 3333 004 Sahba, A.
instructor 3343 001 Ruan
instructor 3343 002 Gibson
instructor 3343 003 Ruan
instructor 3423 001 Silvestro
instructor 3423 002 Silvestro
instructor 3423 003 Lama
instructor 3423 004 NEED
instructor 3433 001 Harrison
instructor 3443 001 Alkittawi
instructor 3443 002 Alkittawi
instructor 3443 003 Fernandez
instructor 3443 004 Bokaei Hosseini
instructor 3723 001 Arafat
instructor 3723 002 Arafat
instructor 3733 001 Korkmaz
instructor 3733 002 Silvestro
instructor 3733 003 Silvestro
instructor 3743 001 Richards, T.
instructor 3743 002 Richards, T.
instructor 3743 003 Richards, T.
instructor 3753 901 Chowdhury
instructor 3773 001 Richards, K.
instructor 3773 002 Dogru
instructor 3793 901 Sahba, R.
instructor 3843 001 Dutta
instructor 3843 002 Dutta
instructor 3843 003 Ortiz
instructor 3843 004 Dutta
instructor 3843 005 Sahba, R.
instructor 3843 006 Sahba, R.
instructor 3853 001 Ortiz
instructor 3853 002 Banoth
instructor 3853 003 Banoth
instructor 3853 004 NEED
instructor 3873 001 Boppana
instructor 4013 901 Sherette-xlist
instructor 4023 901 Chowdhury-xlist
instructor 4253 901 Sahba, A.
instructor 4333 901 Ergur
instructor 4373 901 Chowdhury
instructor 4393 001 Arafat
instructor 4393 002 Arafat
instructor 4413 001 Richards, T.
instructor 4413 002 Richards, K.
instructor 4423 001 Ang
instructor 4613 901 Heaps
instructor 4623 901 Heaps-xlist
instructor 4663 901 Gomez Morales
instructor 4673 001 Heruska
instructor 4683 901 Slavin
instructor 4743 901 Valadez
instructor 4773 901 Dogru
instructor 4823 001 Prasad
instructor 4833 001 Zhu
instructor 4843 001 Valadez
instructor 5013 901 Sherette
instructor 5023 901 Chowdhury
instructor 5123 901 Wang, X.
instructor 5153 901 Quarles
instructor 5163 901 Tabar
instructor 5233 901 Zhang, Z.
instructor 5243 901 Desai
instructor 5323 901 Siddiqi
instructor 5343 001 NEED
instructor 5443 901 Yang, K.
instructor 5463 901 Ergur
instructor 5473 901 Chowdhury
instructor 5513 002 Wang, W.
instructor 5523 901 Xie
instructor 5573 001 ISCS-turn
instructor 5633 901 Gibson
instructor 5713 903 Jadliwala
instructor 5723 901 Banoth
instructor 6243 901 Dutta
instructor 6353 901 Banoth
instructor 6463 901 Dang
instructor 6543 901 Korkmaz

;;; ROOM

labC 5513 002
labC 3873 001
labC 3443 002
labC 3443 001
labC 2713 006
labC 2713 003
labC 1173 005
labC 1153 001
labC 1083 007
labC 1083 005
labB 4833 001
labB 4413 001
labB 3853 004
labB 3853 003
labB 3853 001
labB 3743 002
labB 3443 003
labB 2113 002
labB 2113 001
labB 2713 004
labB 2713 001
labB 1173 002
labB 1173 001
labB 1083 008
labB 1083 006
labB 1083 004
labB 1083 003

cap 1063 001 80
cap 1083 001 60
cap 1083 002 60
cap 1083 003 60
cap 1083 004 60
cap 1083 005 60
cap 1083 006 60
cap 1083 007 60
cap 1083 008 60
cap 1153 001 60
cap 1173 001 60
cap 1173 002 60
cap 1173 003 60
cap 1173 004 60
cap 1173 005 60
cap 2713 001 60
cap 2713 002 60
cap 2713 003 60
cap 2713 004 60
cap 2713 005 60
cap 2713 006 60
cap 2113 001 60
cap 2113 002 60
cap 2123 001 60
cap 2123 002 60
cap 2123 003 60
cap 2123 004 60
cap 2123 005 60
cap 2123 006 60
cap 2233 001 60
cap 2233 002 60
cap 2233 003 60
cap 2233 004 60
cap 2233 005 60
cap 2233 006 60
cap 2233 007 60
cap 3113 001 80
cap 3113 002 80
cap 3333 001 60
cap 3333 002 60
cap 3333 003 60
cap 3333 004 60
cap 3343 001 60
cap 3343 002 60
cap 3343 003 60
cap 3423 001 60
cap 3423 002 60
cap 3423 003 60
cap 3423 004 60
cap 3433 001 60
cap 3443 001 60
cap 3443 002 60
cap 3443 003 60
cap 3443 004 60
cap 3723 001 60
cap 3723 002 60
cap 3733 001 60
cap 3733 002 60
cap 3733 003 60
cap 3743 001 60
cap 3743 002 60
cap 3743 003 80
cap 3753 901 60
cap 3773 001 60
cap 3773 002 60
cap 3793 901 60
cap 3843 001 60
cap 3843 002 60
cap 3843 003 60
cap 3843 004 60
cap 3843 005 60
cap 3843 006 60
cap 3853 001 60
cap 3853 002 60
cap 3853 003 60
cap 3853 004 60
cap 3873 001 60
cap 4013 901 60
cap 4023 901 60
cap 4253 901 60
cap 4333 901 10
cap 4373 901 60
cap 4393 001 60
cap 4393 002 60
cap 4413 001 60
cap 4413 002 60
cap 4423 001 60
cap 4613 901 30
cap 4623 901 30
cap 4663 901 60
cap 4673 001 60
cap 4683 901 60
cap 4743 901 60
cap 4773 901 60
cap 4823 001 60
cap 4833 001 60
cap 4843 001 60
cap 5013 901 20
cap 5023 901 24
cap 5123 901 40
cap 5153 901 40
cap 5163 901 40
cap 5233 901 50
cap 5243 901 40
cap 5323 901 40
cap 5343 001 40
cap 5443 901 40
cap 5463 901 5
cap 5473 901 40
cap 5513 002 50
cap 5523 901 50
cap 5573 001 30
cap 5633 901 50
cap 5713 903 40
cap 5723 901 40
cap 6243 901 40
cap 6353 901 40
cap 6463 901 20
cap 6543 901 40

; MANUAL ADJUST
time 6243 901 MW 1:00-2:15pm
time 5443 901 TR 1:00-2:15pm

cancel 5343 001
add 5343 901 TR 11:30-12:45pm


time 3423 002 MWF 12:00-12:50pm
time 2713 001 MWF  12:00-12:50pm
labB 2713 001

labC 3773 002
labB 3423 001
labA 1153 001
labC 3423 002
labC 3423 004

time 3843 005 MWF 10:00-10:50am

labA 2113 001
labA 2113 002

time 2713 006 TR 8:30-9:45am
labB 2713 006

labC 3853 003
labA 1083 007
labC 1083 006

labB 3843 003

time 3743 001 TR 1:00-2:15pm

time 3733 002 TR 4:00-5:15pm
time 3733 003 TR 6:00-7:15pm


time 4823 001 MW 4:00-5:15pm

;;;;;;;;;;;;;;;;;;

add 2113 003 TR 8:30-9:45am
instructor 2113 003 NEED
labC 2113 003

add 2113 004 TR 2:30-3:45pm
instructor 2113 004 Gomez Morales
labA 2113 004
instructor 2713 005 NEED

add 2113 005 MWF 12:00-12:50pm
instructor 2113 005 NEED
labA 2113 005

cap  2113 001 50
cap  2113 002 50
cap  2113 003 50
cap  2113 004 50
cap  2113 005 50

time 3423 003 TR 11:30-12:45pm
time 2713 005 TR 6:00-7:15pm
time 3443 004 TR 4:00-5:15pm

time 3843 004 TR 10:00-11:15am
; time 3743 001 TR 10:00-11:15am
time 4413 001 TR 7:30-8:45pm
labB 4413 001 

time 4373 901 TR 1:00-2:15pm
time 3773 001 TR 11:30-12:45pm

instructor 3423 004 Anderson