With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Saturday, March 5, 2016
yogi_Find Teachers Available To Substitute On Specified Day And Specified Class Period
https://productforums.google.com/forum/#!topic/docs/MAyHBPypO4o;context-place=mydiscussions formula 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.
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.
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?