I receive timetabling data in Excel spreadsheets and want to map it out automatically, rather than working out the timetable/grid by hand every time because the data changes, and I'd also like to filter it to show certain groups - teacher for example.
So I’m doing timetabling for my organisation this semester, and in the past, the incumbents have entered the data manually, which seems to me to be ridiculous. However, I can’t quite work out how to do it.
These are the variables I work with:
Now I can and have done a pivot table that works just fine EXCEPT some of the classes go for one hour, some for two, some for three, and some for the entire day. I want to see a grid with days and course codes down the side, and times across the top. With the way my data is currently structured, I’m getting that, except every class looks like it’s one hour.
I want a table that has days across the top, times down the side, and the grid showing class, venue, teacher. I could do this in a report in Access, except for the difference in class lengths. That’s where I’m losing the plot. I’m not very good at coding, but I can see that if I do end time – start time, I do get the length of the class, but not sure how then to reflect that against time.
Sample data here