Science Equipment Requisition Timetable Sheet Maker

Quickly create weekly science equipment requisitions which can be automatically printed or emailed to your technician with the click of a single button.
The spreadsheet uses macros to automate functions and so will only run with the Windows version of excel.
Automatically creates a timetable with the number of lessons per day to suit your needs with the click of a single button.
A blank master timetable is created which you populate with your groups and room numbers where groups or locations can be colour coded.
The spreadsheet copies the blank timetable to create new weekly timetables which are date stamped with a single click of a button. Scrolling to the right of these weekly timetables allows previous weeks requests to be seen and if necessary requests can be copied and pasted into the current/upcoming week. This enables a record of experiments to be kept and speeds up creating future requests.
Once the current week’s request information has been entered it can be easily printed out to automatically fill a complete A4 landscape page again with the click of a single button.
The current/upcoming week’s request sheet can be emailed to your technician with a single click of a button. The email includes an attached spreadsheet titled with your name and the week date that contains your current week’s requests.
Macros must be enabled for the spreadsheet to run.