Google Spreadsheet Post #2049
formula to match absent teacher with teacher to fill teaching duties?
On my 'fake' 'Timetables' tab of my spreadsheet I have the timetables of several teachers; and on the OnCall tab, teachers' names along with which period and day that they may be called to substitute for an absent teacher.
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Mar-05-2016
post by: bpugh2:
https://productforums.google.com/forum/#!topic/docs/MAyHBPypO4o;context-place=mydiscussionsformula to match absent teacher with teacher to fill teaching duties?
If a teacher is absent for 1 or more periods during a day, his/her teaching duties are covered by other teachers who have on-call periods in which they, if selected, must substitute on the day and in the period of the absent teacher.
Is there a formula that will take the day and period of an absent teacher and return the matching day and period of a duty with an on call period?
For example:
| Absent: Friday | Period 3 | Science 6-3 | Costanza Bardsley |
Available to substitute:
| Brian Pugh | Friday | Period 3 |
Thank you very much.
formula question
------------------------------------------------------------------------------------------------
No comments:
Post a Comment