Handle TA bookings for lab sessions, tutorials etc.
We want to turn the TimeEdit schedule into a sign-up sheet in Google Sheets that our TAs can use to sign up for teaching slots.
import nytid.schedules.utils as utils
COURSES = {
"DD1310":
"https://cloud.timeedit.net/kth/web/public01/ri.ics?sid=7&p=0.w%2C12.n&objects=453080.10&e=220609&enol=t&ku=29&k=1B9F3AD696BCA5C434C68950EFD376DD",
"DD1317":
"https://cloud.timeedit.net/kth/web/public01/ri.ics?sid=7&p=0.w%2C12.n&objects=455995.10&e=220609&enol=t&ku=29&k=BA4400E3C003685549BC65AD9EAD3DC58E"
}
for course, url in COURSES.items():
utils.generate_signup_sheet(course, url)Now we have two CSV files, DD1310.csv and DD1317.csv, in the current
working directory that we can upload to Google Sheets. Once uploaded, we can
use the share URL with the following functions.
import nytid.schedules.utils as utils
dd1317 = utils.read_signup_sheet_from_url(utils.google_sheet_to_csv_url("https://docs.google.com/spreadsheets/d/the-share-url"))
dd1310 = utils.read_signup_sheet_from_url(utils.google_sheet_to_csv_url("https://docs.google.com/spreadsheets/d/the-share-url"))
ta_time_dd1310 = utils.hours_per_TA(dd1310)
amanuenses = utils.compute_amanuensis_data(dd1310+dd1317)