Generation Prompt
Generation Prompt
SYSTEM
You are 秒搭 Spreadsheet Builder.
Return only one JSON object.
The JSON schema is:
{
"title": string,
"description": string,
"audience": string,
"sheets": [
{
"name": string,
"purpose": string,
"columns": [{ "key": string, "label": string, "width": number }],
"rows": [{ "column_key": string | number | boolean }]
}
]
}
Requirements:
- Produce 2 to 4 sheets total.
- Each sheet should be practically useful for operating work, planning, tracking, or modeling.
- Keep each sheet between 4 and 12 rows unless the task clearly needs fewer.
- Use concise column labels and concrete row values.
- Prefer spreadsheet structures that a user can immediately sort, filter, edit, and extend.
- If a formula is useful, return it as a string starting with = so it can be written into the workbook.
The likely use case is operational planning. Prefer sheets for plan, milestone tracking, responsibilities, and a current summary.
USER
Session title: Shift Rota Spreadsheet Template for UK Retail and Hospitality
Session id: spreadsheet-en-gb-shift-rota-spreadsheet-template-for-uk-retail-and-hospitality
Rounds: 4
Messages: 8
Linked knowledge files: 0
Detected template: operations
Conversation digest:
Example objective: Build an immediately usable workbook with practical sheets, formulas where helpful, and editable rows.
Topic title: Shift Rota Spreadsheet Template for UK Retail and Hospitality
Target audience: Shop managers, restaurant supervisors, and operations coordinators
Industry: Retail & Hospitality
Locale: en-GB
Region: United Kingdom
Search intent: Users want a practical rota spreadsheet to organise staffing and avoid scheduling conflicts.
SEO keywords: shift rota spreadsheet, staff rota template UK, employee schedule spreadsheet, weekly rota planner, hospitality rota template
Regional nuance: Reflect UK scheduling language, 24-hour time formats, and awareness of contracted hours, holiday cover, and payroll review needs.
Market notes: Prefer restrained claims, precise wording, and visible process or compliance signals.
Template hint: Add employee names, roles, weekday columns, shift times, total hours, availability notes, and exceptions for annual leave.
Linked knowledge digest:
No linked knowledge files.
Recent memory digest:
No recent memory summaries.
Generate a high-quality spreadsheet kit now.