electroRF
Member
Hi,
I'd appreciate your advice please.
I got a huge spreadsheet which contains which classrooms where taken by which teachers on which dates:
(A class room can be free on certain days, not taken by any teacher)
I want to convert it into the following format:
(for the entire year of 2014, and for 2015 up to now)
What algorithm would you apply for the conversion?
I am trying to think of a proper way of doing it.
Thank you very much.
I'd appreciate your advice please.
I got a huge spreadsheet which contains which classrooms where taken by which teachers on which dates:
(A class room can be free on certain days, not taken by any teacher)
Code:
Date Taken ----- Date Released ------ Class Room ----- Teacher
01/01/2014 ----- 03/01/2014 ------ 10 ----- Tony Moore
01/01/2014 ----- 02/01/2014 ------ 13 ----- Joe Allan
02/01/2014 ----- 06/01/2014 ------ 11 ----- David Gerrero
03/01/2014 ----- 05/01/2014 ------ 10 ----- Eddie Corrie
....
I want to convert it into the following format:
(for the entire year of 2014, and for 2015 up to now)
Code:
01/01/2014 02/01/2014 03/01/2014 04/01/2014 05/01/2014 06/01/2014
Class Room
10 Tony Moore Tony Moore Tony Moore Eddie Corrie Eddie Corrie Free
11 Free David Gerrero David Gerrero David Gerrero David Gerrero David Gerrero
12
13
14
...
What algorithm would you apply for the conversion?
I am trying to think of a proper way of doing it.
Thank you very much.
Last edited: