PURPOSE-BUILT EXCEL TOOLS FOR HR

Clarity for your
people data.

Thoughtful spreadsheets for the HR team of one. Turn everyday numbers into a people report you can actually use.

The Monthly People Report is ready. One payment, an instant download and no onboarding call.

theanalyticsproSAMPLE DATA

YOUR MONTHLY OVERVIEW

People, at a glance.

Headcount132At month end
New starters6During August
Leavers5During August
Workforce over timeHeadcount
Opening + starters − leavers = closing131 + 6 − 5 = 132

Illustrative reporting view. Final workbook may differ.

Made for everyday HR Familiar Excel workflows Clear, written guidance

THE FIRST COLLECTION

A useful tool for
the work in front of you.

Start with a clearer monthly report. Explore planning and practice tools built around the same considered approach.

FIRST RELEASEThe Monthly People Report is available now. Other packs remain in development.
Explore the rest of the collection7 more planned packs

A CONSIDERED APPROACH

The detail behind
a useful spreadsheet.

The aim is simple: help you understand the numbers, explain the calculation and repeat the process next month.

Explore the reporting pack
01

Know what goes in.

Defined input tables and written guidance, with the assumptions made visible.

02

Understand what comes out.

Meaningful measures, clear definitions and a view designed to answer a real question.

03

Make it repeatable.

A consistent structure you can return to, without rebuilding your report each month.

A LITTLE CLARITY, ON THE HOUSE

What’s your employee
turnover rate?

Three numbers. One clear calculation.
Try it with your own totals, or use the example.

Your reporting period

FREE TOOL
People at the start of the period
People at the end of the period
Count departures from the same workforce

YOUR RESULT

Monthly employee turnover

6.1%

8 departures ÷ 132 average headcount × 100

Average headcount132
Headcount change+8 people

This is the rate for the selected period, not an annualised estimate. There is no universal “good” turnover rate.

How this calculation works

Turnover = leavers during the period ÷ average headcount × 100. Here, average headcount is estimated as (opening headcount + closing headcount) ÷ 2.

Use the same dates, workforce and departure definition for every input. Headcount counts people, not FTE. Monthly and quarterly rates are not automatically annualised. A rate above 100% can occur when positions turn over repeatedly.

If staffing varies substantially during the period, a consistent average of more frequent snapshots may be more representative. Compare rates calculated with the same method. Changes in workforce scope or internal transfers may also affect interpretation.

Calculated in your browser. No employee records, email address or sign-up needed.

BEFORE YOU GET STARTED

A few good questions.

Clear expectations from the start.

Can I buy a pack yet?

Yes. The Monthly People Report is available as an instant digital download for £49 excluding applicable VAT or other local taxes. Gumroad calculates taxes at checkout; a UK purchase is normally £58.80 including 20% VAT. The other collection pages show planned products that are not yet for sale.

Which version of Excel will I need?

The Monthly People Report is verified for Excel 2019 and Microsoft 365 desktop on Windows. It does not use macros, add-ins, external links or dynamic-array formulas. It is not designed for Google Sheets or Excel for the web.

Do I need to book a call?

No. The packs are being designed for independent use with written instructions and worked examples. Any support offered at release will be text-based; you will not need a call or video session to get started.

Will I need to share employee data?

This website does not accept employee records. The calculator uses aggregate totals and processes them in your browser. The planned Excel products work with your files in your own environment; demos will use clearly labelled synthetic data.

Can consultants and trainers use the packs?

Intended uses differ by product. Consultant and trainer licence options, including any permissions for client or learner reuse, will be stated before purchase. The £29 Practice Lab price shown is a proposed individual-use price.

What support is included?

The pack includes a setup guide, definitions and a worked example. If you have a problem with the supplied files, support is available in writing. Custom dashboards, data cleaning, integrations and calls are not included.

START WITH ONE CLEAR ANSWER

A small tool. A clearer picture.

Try the free turnover calculator