1
Сергей
no recommendations
no complaints
Project title: Excel Children's Art School Schedule
Type of cooperation: One-time project
Section: Texts and translation
Prepayment: prepayment is possible
Payment methods: Bank transfer
Acceptance of requests: from 2019-04-29 until 2019-05-06
Type of cooperation: One-time project
Section: Texts and translation
Prepayment: prepayment is possible
Payment methods: Bank transfer
Acceptance of requests: from 2019-04-29 until 2019-05-06
Project description:
Good afternoon. There is a schedule of classes in Excel. It has group classes (participants of the group lesson are inscribed in the note), there are individual classes. The title of the group and individual lesson fits into the cell. On the left side of the cell is the beginning and end of the lesson. Time is injected haphazardly. The number of lines in all teachers remains unchanged (14). The rule (formula) must be entered in light brown columns (GROUP) for all teachers for Monday, Tuesday, etc. for the whole year. There is no July (no need) schedule.
Task.
If the time of the student’s class coincides with the time of his class with another teacher on the same day, or is partially layered at this time, then both cells should be painted red on this day by any teacher in any combination. The revision is performed in the attached file without removing the other functions.
Example:
1. The teachers Ishutin S.R. and Ishutina M.G. In January, on Monday, individual lessons are held at Osipov, cells Q147 and Q166 (paint in red), the basis is the time of classes B147 and B166 the beginning of the lesson, C147 and C166 the end of the lesson, the time has layered.
2. The teachers Ishutin S.R. and Ishutina M.G. In January, on Tuesday, individual lessons are held at Osipov and a choir with participation in Osipov’s group (the list is filled in the note), cells AN143 and AN166 (paint in red), the basis is the time of classes S143 and T166 the beginning of the lesson, S143 and T166 the end of the lesson, time has layered.
3. The teachers Ishutin S.R. and Ishutina M.G. In January, on Wednesday, group lessons Orchestra and Solfeggio are held with participation in Osipov groups (list is filled in the note), cells AY146 and AY167 (paint in red), the basis is the time of AJ146 and AK167 classes the beginning of the lesson, AJ146 and AK167 the end of the lesson, time has layered.
Good afternoon. There is a schedule of classes in Excel. It has group classes (participants of the group lesson are inscribed in the note), there are individual classes. The title of the group and individual lesson fits into the cell. On the left side of the cell is the beginning and end of the lesson. Time is injected haphazardly. The number of lines in all teachers remains unchanged (14). The rule (formula) must be entered in light brown columns (GROUP) for all teachers for Monday, Tuesday, etc. for the whole year. There is no July (no need) schedule.
Task.
If the time of the student’s class coincides with the time of his class with another teacher on the same day, or is partially layered at this time, then both cells should be painted red on this day by any teacher in any combination. The revision is performed in the attached file without removing the other functions.
Example:
1. The teachers Ishutin S.R. and Ishutina M.G. In January, on Monday, individual lessons are held at Osipov, cells Q147 and Q166 (paint in red), the basis is the time of classes B147 and B166 the beginning of the lesson, C147 and C166 the end of the lesson, the time has layered.
2. The teachers Ishutin S.R. and Ishutina M.G. In January, on Tuesday, individual lessons are held at Osipov and a choir with participation in Osipov’s group (the list is filled in the note), cells AN143 and AN166 (paint in red), the basis is the time of classes S143 and T166 the beginning of the lesson, S143 and T166 the end of the lesson, time has layered.
3. The teachers Ishutin S.R. and Ishutina M.G. In January, on Wednesday, group lessons Orchestra and Solfeggio are held with participation in Osipov groups (list is filled in the note), cells AY146 and AY167 (paint in red), the basis is the time of AJ146 and AK167 classes the beginning of the lesson, AJ146 and AK167 the end of the lesson, time has layered.
