Templates
Advanced XLSX workbooks, Power BI PBIX files and explanatory PDFs — all free. PDFs download directly; the complex XLSX and PBIX files are sent to your email address.
.jpg)
How to structure HR data for analytics, including historisation and privacy-by-design notes.
Solves: Models that break at the next reorganisation.
Use at your own risk: no warranty, no liability for decisions based on these files.
.jpg)
Dynamic-array formulas for month-end headcount, FTE and part-time share by org unit, with full spill logic.
Solves: Headcount numbers that differ between HR and Finance.
Email required
Use at your own risk: no warranty, no liability for decisions based on these files.
.jpg)
Formula-driven population pyramid with a five-year retirement projection and skills coverage matrix.
Solves: Workforce risk questions from the works council and the board.
Email required
Use at your own risk: no warranty, no liability for decisions based on these files.
.jpg)
Power Query workbook that explodes absence intervals into days and reports calendar-day, workday and target-hour rates.
Solves: Benchmark comparisons distorted by hidden denominators, month boundaries and part-time work.
Email required
Use at your own risk: no warranty, no liability for decisions based on these files.
Named LAMBDA functions for turnover, absence, FTE and tenure — documented and unit-tested.
Solves: Five departments, five slightly different turnover formulas.
Email required
Use at your own risk: no warranty, no liability for decisions based on these files.
Power BI file with BDA/Schlüter/ZVEI measures, cohort retention matrix and early-leaver analysis.
Solves: Turnover reporting that changes meaning between two slides.
Email required
Use at your own risk: no warranty, no liability for decisions based on these files.
One-page executive cockpit with field parameters, plan and prior-year variance and a minimum-group-size guard.
Solves: Monthly HR reporting that takes three days to assemble.
Email required
Use at your own risk: no warranty, no liability for decisions based on these files.
.jpg)
A practical Excel model for analysing compensation outside collective agreements and making pay structures transparent.
Solves: Transparency about compensation outside collective agreements.
Email required
Use at your own risk: no warranty, no liability for decisions based on these files.
Event-log based funnel with stage duration, drop-off, source quality and requisition ageing.
Solves: Time-to-hire numbers nobody in recruiting believes.
Use at your own risk: no warranty, no liability for decisions based on these files.
Every common turnover formula, what it over- and understates, and when to use which.
Solves: Choosing a turnover KPI you can defend for years.
Use at your own risk: no warranty, no liability for decisions based on these files.
.jpg)
A driver-based Excel model for personnel cost planning and forecasting.
Solves: Budget rounds where every scenario currently means a new file.
Email required
Use at your own risk: no warranty, no liability for decisions based on these files.
One-page definition sheets for 24 HR KPIs: formula, source, owner, pitfalls.
Solves: Reports where nobody can say how a number was calculated.
Use at your own risk: no warranty, no liability for decisions based on these files.
Disclaimer
Templates, calculators and formulas on this site are teaching material — not audited software and not professional advice. Use at your own risk: no warranty, no liability for decisions based on these files.
Read the full disclaimer