How is turnover rate calculated?

Period turnover equals separations divided by the chosen average headcount, multiplied by 100. Starting and ending headcounts of 100 with ten separations give 10%. Starting at 80 and ending at 120 gives an arithmetic mean of 100; fifteen separations then give 15%.

Which average headcount should I use?

The start/end method uses (starting headcount + ending headcount) / 2. This is an approximation that does not capture every workforce change during the period. If you have a separately measured average for the same population and period, choose the measured method and enter it explicitly. The worksheet does not select a method for you.

Why can turnover exceed 100%?

The separation count can exceed average headcount when people join and leave during a period. For example, 250 separations divided by an average of 100 gives 250%. The worksheet retains the arithmetic result without capping or judging it.

What happens when average headcount is zero?

The rate is unavailable because division by zero is undefined, including when separations are also zero. The chart marks that period separately from a zero rate. CSV retains the inputs and labels the result as a zero denominator.

Can I combine or annualize the period rates?

This worksheet does not add rates, average them into a total or automatically annualize them. Comparisons need consistent population, separation definitions and period lengths. No industry benchmarks, replacement costs, employee ratings or predictions are supplied.

Can I reload my CSV worksheet?

Yes. Export includes raw labels and counts, the average method, measured average and exact rate fraction for every period. Import previews and validates all rows before replacing the worksheet; computed columns are recalculated. Keep the headers and format marker. Formula-like labels are escaped on export and restored on reimport. Replacement, deletion and editing support up to 50 undo/redo changes.

What are the input limits and privacy rules?

The worksheet supports 1–120 periods. Start, end and separations are whole numbers from zero to one trillion; a measured average supports six decimal places. Inputs remain in browser memory and are not automatically saved. Export before leaving. Use aggregate period counts rather than individual employee records.

Turnover Rate Calculator

Enter aggregate headcounts and separations for each period, choose an explicit average headcount method, and compare descriptive turnover rates. Keep labels and calculation inputs together in an exportable worksheet.

Compare supplied periods

Keep one row per period. Use the same population and separation definition, and comparable period lengths, before comparing percentages. Enter aggregate counts only. This worksheet does not classify outcomes or estimate future turnover.

3/120 periods · 0 zero-denominator rates · 0 rows needing corrections. Up to 50 undo/redo changes. Data stays in page memory; export before leaving.

Edit one period

Selected periodPeriod label

Starting headcountEnding headcountSeparations

Average methodMeasured average headcount

Start, end and separations must be whole numbers from 0 to 1,000,000,000,000. A measured average may have up to six decimal places. It is used only with “Supplied measured average.” Zero averages produce an unavailable rate, never a division-by-zero percentage.

Period turnover10%

Average = (100 + 100) ÷ 2 = 100. Turnover = 10 ÷ 100 × 100 = 10%.

Exact percentage fraction: 10/1. Display rounds to six decimal places; tiny positive rates are marked.

Period comparison

All periods appear in worksheet order on one shared scale, from 0% to 15%. Select a bar to edit its period. Striped rows are unavailable or invalid, not zero rates.

Start	End	Separations	Average / method	Turnover
100	100	10	100 Start/end mean	10%
80	120	15	100 Start/end mean	15%
90	110	12	96 Measured average	12.5%

Period rates are not added or averaged into a total. No automatic annualization, industry benchmark, replacement cost or employee-level assessment is applied.

Save or reload the worksheet

CSV keeps all raw inputs, labels, denominator choices, exact rate fractions and unavailable rates. Formula-like labels are escaped for spreadsheet safety and restored when reimported here. Keep the format column and headers. Computed columns are ignored on import and recalculated.

Import a worksheet CSV

Choose CSV fileOr paste exported CSV

Worksheet summary

Turnover period worksheet

1. Period 1
Start: 100; end: 100; separations: 10
Method: Start/end arithmetic mean
Average = (100 + 100) ÷ 2 = 100. Turnover = 10 ÷ 100 × 100 = 10%.
Exact rate in percent: 10/1

2. Period 2
Start: 80; end: 120; separations: 15
Method: Start/end arithmetic mean
Average = (80 + 120) ÷ 2 = 100. Turnover = 15 ÷ 100 × 100 = 15%.
Exact rate in percent: 15/1

3. Period 3
Start: 90; end: 110; separations: 12
Method: Measured average
Supplied measured average = 96. Turnover = 12 ÷ 96 × 100 = 12.5%.
Exact rate in percent: 25/2

Separations ÷ chosen average headcount × 100. The start/end mean only approximates average workforce. Rates are descriptive, not annualized, added across periods or benchmarked; no individual employment assessments.
Compare periods only when their duration, population and separation definitions align. No total or annualized rate is calculated.

Separations ÷ chosen average headcount × 100. The start/end mean only approximates average workforce. Rates are descriptive, not annualized, added across periods or benchmarked; no individual employment assessments. Inputs and exports are processed in your browser.

Common questions

How is turnover rate calculated?: Period turnover equals separations divided by the chosen average headcount, multiplied by 100. Starting and ending headcounts of 100 with ten separations give 10%. Starting at 80 and ending at 120 gives an arithmetic mean of 100; fifteen separations then give 15%.
Which average headcount should I use?: The start/end method uses (starting headcount + ending headcount) / 2. This is an approximation that does not capture every workforce change during the period. If you have a separately measured average for the same population and period, choose the measured method and enter it explicitly. The worksheet does not select a method for you.
Why can turnover exceed 100%?: The separation count can exceed average headcount when people join and leave during a period. For example, 250 separations divided by an average of 100 gives 250%. The worksheet retains the arithmetic result without capping or judging it.
What happens when average headcount is zero?: The rate is unavailable because division by zero is undefined, including when separations are also zero. The chart marks that period separately from a zero rate. CSV retains the inputs and labels the result as a zero denominator.
Can I combine or annualize the period rates?: This worksheet does not add rates, average them into a total or automatically annualize them. Comparisons need consistent population, separation definitions and period lengths. No industry benchmarks, replacement costs, employee ratings or predictions are supplied.
Can I reload my CSV worksheet?: Yes. Export includes raw labels and counts, the average method, measured average and exact rate fraction for every period. Import previews and validates all rows before replacing the worksheet; computed columns are recalculated. Keep the headers and format marker. Formula-like labels are escaped on export and restored on reimport. Replacement, deletion and editing support up to 50 undo/redo changes.
What are the input limits and privacy rules?: The worksheet supports 1–120 periods. Start, end and separations are whole numbers from zero to one trillion; a measured average supports six decimal places. Inputs remain in browser memory and are not automatically saved. Export before leaving. Use aggregate period counts rather than individual employee records.