Excel spreadsheet Staff Rota

Tab 1 – Schedule Choice of 2 week view or entire view Be able to skip ahead with start date of either views Staff names on left hand side like examples and total hours working in week + fortnight under name these to be titled / Weekly Hours: Fortnightly Hours: In the box like on example B8/9 to have 2 rows in a 24 hour format under in have shift name - no costings or money on schedule view Either On Schedule or shift setup be able to repeat shifts every Week, 2, 3, 4, 5 or no Repeat for every member of staff Tab 2 – Shift Setup The Same as example but D3 changed to Total Hours - Make this easy to add shift types + Shift times Also be able to spilt shift when needed so 0700 – 0900 & 1500 – 1700 as example Tab 3 Employee - The same as example but these additions This tab is password protected Hourly Rate In £’s Warnings To Come Up When any of these Rules are broken Maximum Working Day Minimum Rest In Any 24 Hour Period Weekly Hours Limit Fortnightly Hours Limit To have no rule on the employee set up just to put 0 in setup box Tab 4 Events Password Protected To be able to add an event for a minimum of a day to any maximum length Similar to shifts setup be able to keep adding as many as we want This to be shown on the Schedule for that day Please note: there might be a maximum of 4 events per day Tab 5 Holidays Password Protected Be able to add Staff Holidays Minimum Of 1 day This to remove any work for that member of staff out of Schedule and it to be over written By Holiday / Sick Day / To be able add any number of separate holidays / Sick Days per staff member and total number of days Holiday & Sick Days Other Bits Saturday & Sundays to be a different colour Add Company logo to all tabs To use greens, greys as colour scheme Must important to be finished by 1700 GMT Tomorrow 23 Feb 2016