# Template Design Brief: stundennachweis-vorlage

**Primary Keyword:** Stundennachweis Vorlage
**Generated:** 2026-03-26 11:03:32

Use this brief to inform Phase 4 (Template Definition Creation).

## 1. Recommended Sheet Structure

Based on competitor analysis and template best practices:

- **Anleitung** – Instructions sheet (required)
- **Daten** – Main data entry sheet
- **Übersicht** – Summary/calculations (optional)
- **Compliance** – Validation checks (optional, for time-tracking templates)

Reference: [Excel Best Practices Research](../../excel-generator/TEMPLATE_BEST_PRACTICES_RESEARCH.md)

## 2. Formulas and Functions to Include

*(Run analyze-competitor-template.php to populate competitor Excel analysis.)*

Common functions for templates: SUM, IF, VLOOKUP, IFERROR, DATE, TIME, ROUND.

## 3. Content Blocks to Cover

Review competitive-depth-analysis.md for competitor topics.

## 4. Feature Gaps vs Competitors

*(Run generate-template-comparison-report.php after competitor template analysis.)*

## 5. Best Practices Checklist

- [ ] Use English function names (SUM, IF, VLOOKUP, IFERROR)
- [ ] Add named ranges for key values
- [ ] Add placeholder text to input cells
- [ ] Implement error handling (IFERROR)
- [ ] Add data validation on input cells
- [ ] Add conditional formatting for visual feedback
- [ ] Include 2–3 example data rows
- [ ] Add instructions sheet content
- [ ] Follow Ordio branding (colors, fonts)
- [ ] Add hyperlinks for sheet navigation

Reference: [Template Definition Guide](../../v2/systems/excel-template-generator/docs/TEMPLATE_DEFINITION_GUIDE.md)