Staff Shift Rota & Cost Calculator

Act as a specialist consultant.

**Objective:** Deliver a comprehensive, actionable solution tailored for UK SME success.

Here is the improved business prompt template, maintaining the exact structure and variables while maximizing clarity, persuasiveness, and expected results:

I require a highly functional and compliant **'Weekly Staff Rota'** spreadsheet solution for **[Number of Staff | number]** employees.

**Essential Columns (Must be Present and Labeled Precisely):** Staff Name, Mon, Tue, Wed, Thu, Fri, Sat, Sun, Total Hours, Estimated Cost.

**Specific Tasks (Actionable Requirements):**
1. **Structure Definition:** Precisely lay out the required column headers and establish the optimal cell structure for data entry and calculation.
2. **Total Hours Formula:** Provide the exact, robust formula to accurately sum the working hours across the entire seven-day week for each staff member.
3. **Cost Calculation Formula:** Provide the exact formula to dynamically calculate the 'Estimated Cost' for each staff member, utilizing a fixed hourly rate of **[Hourly Rate | text]**. *(Crucially, assume the static hourly rate is accessible or input in a designated cell, and reference this clearly in the formula explanation.)*

**Mandatory Contextual Constraint:** The final output and structure must be designed with strict adherence to **UK Working Time Directive compliance** (e.g., facilitating easy identification of maximum weekly hours if necessary).