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.

Can I calculate monthly or annual employee turnover?

Yes. Enter separations and headcounts for that whole month or year, and label the period accordingly. The same formula applies to either period. A rate from a shorter interval is not automatically annualized, and the worksheet does not add monthly percentages into a yearly rate.

How do I calculate pool or aquarium turnover in litres or gallons?

In Pool and aquarium turnover, enter water volume in litres or US gallons and the actual circulation flow in the matching listed unit. The flow can be per minute or per hour, and mixed units are converted. A 20,000-litre pool at 40 litres per minute takes about 8.333333 hours per turnover, or 0.12 turnovers per hour and 2.88 per 24 hours. This assumes constant flow; one circulated volume does not mean every part of mixed water passed through a filter.

Can I use the employee worksheet in Excel?

Download worksheet CSV to keep raw inputs, labels, average choices and computed rates. The website performs the calculations; it does not create a native Excel workbook or add live spreadsheet formulas. Pool and aquarium inputs are separate and are not included in that CSV.

Does it calculate inventory, apartment, bed or restaurant turnover?

The employee worksheet uses separations and average headcount. The water section uses volume and circulation flow. Neither section supplies inventory cost ratios, rental-unit turnover, occupied-bed statistics or restaurant table cycles; those jobs need their own inputs and definitions.

Turnover Rate Calculator

Compare employee turnover for supplied periods using separations and an explicit average headcount method. Label a row for a month or a year and export the worksheet with its inputs. The separate Pool and aquarium turnover section calculates circulation time and turnovers per hour or day from water volume and flow.

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.

Pool and aquarium turnover

Enter the water volume and the actual circulation flow. Each numeric input accepts 0.000000000001 to 1,000,000,000,000 in its selected unit. One turnover means a volume equal to the tank or pool has passed through the circulation system.

Water volumeVolume unitCirculation flowFlow unit

One turnover takes: 8.333333 hours
Turnovers per hour: 0.12
Turnovers per 24 hours: 2.88

Time in hours = volume in litres ÷ circulation flow in litres per minute ÷ 60. Rates are the reciprocal time per hour and that rate × 24 per day. Displays are rounded to six decimal places or seven significant digits for scientific notation.

Assumes constant circulation flow. Mixing means one turnover does not guarantee every part of the water passed through a filter. These numbers do not assess filtration quality, choose a pump or set a required operating schedule. Water inputs stay in page memory and are separate from the employee worksheet and its exports.

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.
Can I calculate monthly or annual employee turnover?: Yes. Enter separations and headcounts for that whole month or year, and label the period accordingly. The same formula applies to either period. A rate from a shorter interval is not automatically annualized, and the worksheet does not add monthly percentages into a yearly rate.
How do I calculate pool or aquarium turnover in litres or gallons?: In Pool and aquarium turnover, enter water volume in litres or US gallons and the actual circulation flow in the matching listed unit. The flow can be per minute or per hour, and mixed units are converted. A 20,000-litre pool at 40 litres per minute takes about 8.333333 hours per turnover, or 0.12 turnovers per hour and 2.88 per 24 hours. This assumes constant flow; one circulated volume does not mean every part of mixed water passed through a filter.
Can I use the employee worksheet in Excel?: Download worksheet CSV to keep raw inputs, labels, average choices and computed rates. The website performs the calculations; it does not create a native Excel workbook or add live spreadsheet formulas. Pool and aquarium inputs are separate and are not included in that CSV.
Does it calculate inventory, apartment, bed or restaurant turnover?: The employee worksheet uses separations and average headcount. The water section uses volume and circulation flow. Neither section supplies inventory cost ratios, rental-unit turnover, occupied-bed statistics or restaurant table cycles; those jobs need their own inputs and definitions.