Excel Prep-Req sheet

Science practical ordering and tracking through Excel. No online sign up, no writing your classes each week or printing them off, no more lost paper or crossing out, and no more practicals going out twice or not being collected. Just a simple, well-designed prep sheet for Science departments everywhere. Please see the images for more information and help notes are included in the file.

This spreadsheet has a named tab for each member of staff where they enter their timetable and requests. This version caters for up to 12 staff, 5 working days and up to 6 periods per day - tell me if your needs are different. Once class names, rooms and sizes have been entered, the master can be kept safely and a copy made available for each week until the technician deadline.

Features include:
1. Resource tracking: know whether a practical is being prepared or ready to go, preventing duplication.
2. Risk assessment: flag unusual practicals and confirm staff have risk assessed each one.
3. Weekly summaries: printable documents for technicians and HoDs.
4. At home access: make the spreadsheet available online. HoD overview of the week ahead.
5. Copy and paste this standard format to create a school practical bank.

The aim is for ease of use with as few formulae and complexities as possible - it has worked in my schools so far!
I hope it is useful for you and if it is please leave a positive review below to help others find it.