We need an Excel VBA script that is able to export a schedule manually formated in Excel in a csv format.
Time periods in 1 row
Rooms names on 1st and 2nd column
In cells, we have course names
Each cell has a colour which is related to a class [url removed, login to view] mapping of the colours and class names are on bottom of the sheet.
The exported csv file should then look like this:
Room X,0800/0950,Class Alpha,Mathematics
Room X, 1005/1155, Class Beta, English
Merged cells should be also managed.
A screenshot of the excel sheet is attached.