Rotas and rotating shifts: what pplPortal solves that Excel cannot

A textile factory with 120 employees spends 8 hours a week managing rosters in Excel. Rotating shifts, days off, replacements, overtime calculations — all in overlapping cells, with no audit trail of who changed what. The production manager prints the roster on Friday evening and discovers on Monday morning that two operators are scheduled simultaneously on two lines. This is the Portuguese pattern: 65% of employers in Portugal struggle to find and retain talent (ManpowerGroup, 2024), and much of that difficulty stems from chaotic rosters that destroy trust. It is not a technology problem — it is an operational control problem that Excel cannot guarantee. At the end of this guide you will find an 11-point checklist to identify whether your Excel is costing more than it should.

What you need before you start

Gather the current roster file (Excel, Google Sheets, or paper), the complete list of employees with category, skills and medical/legal/union restrictions, the contractual working hours and collective agreements that govern shifts and rest periods, and 3 months of roster history to validate patterns. Contact the HR manager or operations director to clarify priorities — cost versus satisfaction versus compliance — and confirm whether there is people management software (pplPortal, SAP, Primavera, or similar) where the data already lives. Also collect absenteeism and turnover data for the last 12 months: this will be the proof that the problem is real.

Step 1: Map the current state of the Excel

Open the roster file you use today. How many tabs does it have? If it has more than 3, that is a sign of fragmentation — data scattered about, with no single source of truth. Who has edit permission? If more than 5 people, there is a risk of accidental overwriting and no one knows who changed what. Is there a change log, a history of who edited when? Excel has no native audit trail — a serious gap if you need proof of compliance. How do you mark overtime, statutory days off, sick absences, holidays? Is there conflict validation, an automatic warning if two people are scheduled on the same shift on the same line? How do you communicate the roster to employees — email, print, noticeboard, SMS? How long does it take to generate the monthly roster? The average in factories of 100+ people is 6 to 12 hours.

Document each answer. This is not a theoretical exercise — it is the starting point for measuring the real gain afterwards.

Step 2: Identify the hidden costs of Excel

Excel is not free. It costs in time, in errors and in compliance.

Calculate the real cost: (weekly time in hours × HR hourly wage) + (number of errors/month × resolution cost) + (unplanned overtime × cost/hour). Most factories discover that Excel costs between 2,500 and 6,000 euros per month in inefficiency — more than they think.

Step 3: Define the business rules that Excel cannot guarantee

Before choosing a tool, write down the rules the tool has to enforce automatically. Can each employee have no more than 3 consecutive night shifts? What is the minimum interval between shifts — 11 hours? How many qualified operators does each production line need as a minimum per shift — and what is the skills matrix? Employee X does not work Saturdays for religious reasons, employee Y has a doctor's appointment on Wednesday mornings, employee Z is on reduced hours by agreement — how is this recorded and enforced? What is the maximum overtime per week per employee, and is it compensated with time off or payment? How do you integrate planned holidays, sick absences, parental leave, mandatory training? How far in advance must the roster be confirmed — typically 2 weeks? Who can change the roster after publication, do they need approval, is it recorded?

Excel obeys what you ask of it. A rostering tool obeys the rules of the business — and warns when the rules are about to be violated.

Step 4: Compare what Excel does vs. what an integrated solution does

Step 5: Audit the compliance risk of your Excel

Excel is a file. A file is not auditable. Tick each item:

• ☐ Is there a record of who changed the roster and when? (Required by the ACT in an inspection.)
• ☐ Can you prove you respected the maximum of 8 hours of overtime/week per employee?
• ☐ Do you have documented consent from each employee for night shifts?
• ☐ Is the roster stored securely (encrypted, backup, controlled access)?
• ☐ Can you demonstrate that the roster was communicated with the minimum notice?
• ☐ Is there a complaints process if an employee disagrees with the roster?
• ☐ Is the HR data (holidays, absences) synchronised with the roster?
• ☐ Do you have a continuity plan if the file is corrupted or lost?

If you ticked fewer than 6 items, the compliance risk is high. An ACT inspection will find gaps — and that costs more than any software.

Step 6: Calculate the ROI of migrating to an integrated solution

It is not only about technology — it is about money. Reduction in management time: 8 hours/week × 50 weeks × €18/hour = €7,200 per year. Reduction in unplanned overtime: 5% reduction in payroll = €3,000 to €8,000 (depending on size). Reduction in absenteeism because employees are more satisfied with predictable rosters: 0.5% reduction = €2,000 to €5,000. Avoiding an ACT fine for non-compliance: €1,500 to €10,000 (risk avoided). Better talent retention — fairer rosters mean less turnover, and each departure costs recruitment, training, lost productivity: a 2% reduction = €5,000 to €15,000.

The typical cost of a solution like pplPortal is €80 to €200/month (depending on the number of users and modules), with implementation of 4 to 8 weeks and a one-off cost of €3,000 to €8,000. The payback is 2 to 4 months in factories of 80+ employees. After that, it is pure gain.

Step 7: Common mistakes and how to avoid them

Mistake 1: Migrating Excel data as-is to the new tool

Excel has dirty data — inconsistent categories, dates in different formats, duplicate employees. Before importing, clean it up. Validate each row. This takes time, but it avoids 3 months of problems afterwards. A factory we know imported data without cleaning and discovered 6 months later that it had a phantom employee on the payroll.

Mistake 2: Not involving employees in the transition

If the operator does not know how to check the roster on the portal, they go back to paper. Provide training — 30 minutes per shift is enough. Leave a printed guide in the changing rooms. Test with a pilot shift before a full rollout. The production manager has to be convinced that the tool works, otherwise they go back to printing the roster on Friday evening.

Mistake 3: Not reconfiguring the business rules in the tool

The tool does not automatically know that line A needs 2 qualified operators or that employee X does not work Saturdays. You have to configure this — it is consultancy work. If you do not configure it, the tool generates invalid rosters — and you go back to Excel.

Mistake 4: Not integrating with payroll

If the roster lives in one tool and payroll processing in another, someone has to copy the hours manually. This is exactly what you want to avoid. Make sure the solution integrates with your ERP or payroll software — pplPortal integrates with ERP MULTI and with third-party systems via API.

Mistake 5: Choosing a generic tool instead of a vertical one

A generic rostering software (such as Calendly or Asana) does not know Portuguese legislation on shifts, overtime, rest periods, and does not talk to payroll. Choose a solution that is built for factories and industry — one that integrates ACT, GDPR and Law 93/2021 compliance by design.

Step 8: Decision checklist — Excel vs. integrated solution

Answer each question honestly. If you answered YES to more than 3, the solution pays for itself in less than 6 months.

Step 9: What to expect during implementation

A well-executed implementation of pplPortal takes 4 to 8 weeks. Weeks 1-2: mapping business rules, cleaning data, configuring skills and restrictions. Weeks 3-4: testing with real data, adjusting the roster-generation algorithm, validating compliance. Weeks 5-6: user training (HR, shift managers, employees), creating documentation and guides. Weeks 7-8: pilot rollout with one shift, bug fixing, full rollout. It is not instant — it is a project — but the implementation time is recovered within 2 months of operation.

Step 10: After implementation — what changes

After 3 months with the tool in production, most factories report: HR has 6-8 hours/week freed up for strategic work (recruitment, development, retention). Roster conflicts drop to zero — no more two people on the same shift. Employees check the roster on the portal and receive notifications of changes — fewer surprises, more trust. Planned overtime drops 5-10% because there is coverage visibility. Absenteeism stabilises or falls because the climate improves. The ACT has a complete audit trail if it inspects. Payroll synchronises automatically — no manual copying, no errors.

Step 11: Integration with the rest of the business

The roster does not live alone. It integrates with payroll (overtime, compensatory rest), with production (who is available for which line), with purchasing (I need more staff for this project, what is the cost), with BI (HR trend dashboards). If you choose a vertical solution like pplPortal, it talks to ERP MULTI — data flows without manual copying. If you choose a generic solution, you will have to integrate manually or via API, and that is cost and risk.

Step 12: When Excel still makes sense

If you have fewer than 20 employees, simple rosters (no complex rotating shifts), and no one complains, Excel might still work — but you are wasting time. If you have 20-50 employees and rosters with some complexity, Excel is already a problem. If you have more than 50 employees, Excel is an operational and legal risk. The decision is simple: how much does the time you spend in Excel cost per month? If it is more than €500, the solution pays for itself. If it is less, you might still get by — but you are counting the days.

Frequently asked questions

Does Excel really cost that much in roster management?

Yes. The article documents that a factory with 120 employees spends 8 hours a week on roster management in Excel alone. Adding up HR time, conflict errors (two people on the same shift), unplanned overtime and the risk of legal non-compliance, the real cost sits between 2,500 and 6,000 euros per month in inefficiency — far more than most companies imagine.

What is the main security risk of an Excel roster file?

Excel has no native audit trail. It cannot record who changed the roster, when or why. If more than 5 people have edit permission, there is a risk of accidental overwriting and no one knows what was changed. In the event of an ACT inspection or an employee complaint, you cannot prove compliance — a risk of a fine.

How do I identify whether my Excel roster is fragmented?

Open the file. If it has more than 3 tabs, that is a sign of fragmentation — data scattered about with no single source of truth. This causes desynchronisation between departments, undetected conflicts and time wasted consolidating information. An integrated solution keeps all the data in a single record.

Which business rules can Excel not enforce automatically?

Excel does not automatically validate restrictions such as: a maximum of 3 consecutive night shifts, a minimum interval of 11 hours between shifts, a skills matrix per line, religious or medical restrictions, overtime limits per week, or compliance with collective agreements. You have to check manually — and errors slip through unnoticed.

What is the impact of a roster conflict (two people on the same shift)?

Production is interrupted. An employee is called in urgently, creating unplanned overtime. The production manager may only find out on Monday morning when they print the Friday roster. This destroys employees' trust and increases turnover — especially critical in a context where 65% of employers struggle to retain talent.

What should I collect before moving from Excel to a rostering tool?

Gather: the current roster file, the complete list of employees with skills and restrictions (medical, legal, union), contractual working hours and collective agreements, 3 months of roster history to validate patterns, and absenteeism and turnover data for the last 12 months. Contact HR or the operations director to clarify priorities — cost versus satisfaction versus compliance.

Can an integrated solution like pplPortal integrate with payroll?

Yes. Whereas Excel requires a manual export with a risk of error, an integrated solution automatically synchronises the hours recorded in the roster with payroll processing. Overtime is already validated and ready for calculation — with no additional manual work and no discrepancies.

Sources

• Authority for Working Conditions (ACT) — Legislation on the organisation of working time, shifts and rest periods: Law no. 7/2009, of 12 February (Labour Code)
• National Data Protection Commission (CNPD) — Regulation (EU) 2016/679 (GDPR) and compliance in the processing of employees' personal data
• National Statistics Institute (INE) — Employment Survey and turnover and absenteeism indicators in Portugal
• Standard ISO/IEC 27001:2022 — Requirements for auditing, traceability and access control in information systems
• ManpowerGroup — "Talent Shortage Survey" report (2024) — data on the difficulty of retaining talent in Portugal