Rearrange data for a school timetable
Posted: Mon Aug 24, 2009 3:43 pm
Well
I am a total newbie, but I am wiling to learn
I am trying to format school timetables before printing them
I have some raw data in a .ods file produced by a timetabling program
like this:
I need data to be formated like this layout: Basically, I need to
1- pull the table's head (in red) from teacher column E
2- pull subject, student set, and room related to a given teacher and put them together into a single cell, according to day and period
fo example, data from row 2, (with A2=friday1 and B2=09:00) from row spreadsheet
would be put at C7 int the formatted timetable
3- in order to prepare data , I also need to check if the a cell in day column contain the number 2
if so transform period by adding 6
for example, for day tuesday2
tranform day tuesday2 period 08:00 into tuesday1 period 14:00
tranform day tuesday2 period 09:00 into into tuesday1 period 15:00
tranform day tuesday2 period 10:00 into into into tuesday1 period 16:00
and so on for other XXX2 days
here is the .ods file
http://www.mediafire.com/download.php?t2jiagzlm0o
Hope I explained my problem clearely
I am a total newbie, but I am wiling to learn
I am trying to format school timetables before printing them
I have some raw data in a .ods file produced by a timetabling program
like this:
I need data to be formated like this layout: Basically, I need to
1- pull the table's head (in red) from teacher column E
2- pull subject, student set, and room related to a given teacher and put them together into a single cell, according to day and period
fo example, data from row 2, (with A2=friday1 and B2=09:00) from row spreadsheet
would be put at C7 int the formatted timetable
3- in order to prepare data , I also need to check if the a cell in day column contain the number 2
if so transform period by adding 6
for example, for day tuesday2
tranform day tuesday2 period 08:00 into tuesday1 period 14:00
tranform day tuesday2 period 09:00 into into tuesday1 period 15:00
tranform day tuesday2 period 10:00 into into into tuesday1 period 16:00
and so on for other XXX2 days
here is the .ods file
http://www.mediafire.com/download.php?t2jiagzlm0o
Hope I explained my problem clearely