An Excel (XLSX) workbook for salons, barbershops and beauty studios to plan FUTURE shifts for up to 12 people and 3 chairs or rooms. Type a shift code per person and day on a five-week rota, then get a printable weekly sheet, planned hours against contracted hours with the over and under hours highlighted by thresholds you set, a coverage view of the people on duty for each hour against your opening hours with gaps in red, and a chair or room allocation that flags overlaps. Each language comes as a fictional DEMO and an empty BLANK workbook, in English, Italian, Spanish, French and German, with a short PDF guide.

The problem it solves

Rotas live in notebooks and messages, so nobody sees at a glance who is short of hours, who is over, which hours of the day are thinly covered or who is booked on the same chair at the same time.

Who it is for

Salon owners and managers who juggle part-time and full-time staff, days off, holidays and a few shared chairs, and want the next weeks planned on one clear sheet instead of a paper diary or a chat thread.

What you get

• A five-week rota (Monday to Sunday) with one shift code per person and day: your own start, end and unpaid break, plus Day off and Holiday codes
• A printable one-page weekly sheet with each person's shifts, chair or room, planned hours, contracted hours and a status
• Planned hours against contracted hours for each person and week, with over and under hours highlighted by thresholds you enter yourself
• A coverage view of the people on duty for each hour band against your opening hours, with hours below your minimum in red
• Simple chair or room allocation with an optional override per day, and a red flag when two people overlap on the same chair
• Entry lists and checks: shift codes from a list, duplicate names flagged, formula cells protected without a password

How you use it

1. Download and extract the ZIP, open your language folder and the DEMO workbook to see how it works.
2. Open the BLANK workbook, save a working copy and read the first sheet.
3. In Setup, enter the first Monday of your rota, your opening hours with the minimum people on duty, your chair or room names and your shift codes.
4. In Staff, list up to 12 people with their contracted hours per week and their usual chair or room.
5. In Rota, type or pick a shift code for each person and day, and name another chair or room for a day where needed.
6. Pick the week in Setup, then print the Weekly Sheet and check Coverage, Chairs and Hours for red cells.

Questions