# Bearing Replacement and L10 Life Schedule Worksheet

> Source: https://netray.co/tools/bearing-replacement-and-l10-life-schedule-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

List the bearings on your drives with load, speed and catalog rating, and the sheet computes L10 life in hours against the life you need.

## Category

mes-shop-floor

## Industry

Industrial Machinery

## Audience

- Maintenance planner
- Reliability engineer
- Plant engineer

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Drive / asset tag

**Key:** tag

**Type:** text

#### Bearing designation

**Key:** bearing

**Type:** text

#### Type

**Key:** btype

**Type:** select

**Options:**

- Ball
- Cylindrical roller
- Spherical roller
- Tapered roller

#### Dynamic rating C

**Key:** c_kn

**Type:** number

**Unit:** kN

#### Equivalent load P

**Key:** p_kn

**Type:** number

**Unit:** kN

#### Life exponent (3 ball, 3.33 roller)

**Key:** expo

**Type:** number

#### Speed

**Key:** rpm

**Type:** number

**Unit:** rpm

#### Required life

**Key:** req_h

**Type:** number

**Unit:** hours

#### L10 (million revs)

**Key:** l10_rev

**Type:** number

**Expr:** pow(c_kn / p_kn, expo)

**Format:** decimal

#### L10 life (hours)

**Key:** l10_h

**Type:** number

**Expr:** 1000000 / (60 * rpm) * pow(c_kn / p_kn, expo)

**Format:** integer

#### Life margin (x required)

**Key:** margin

**Type:** number

**Expr:** 1000000 / (60 * rpm) * pow(c_kn / p_kn, expo) / req_h

**Format:** decimal

#### Review / replace by

**Key:** due

**Type:** date

**Rows:**

**Tag:** CNV-101 gearbox input

**Bearing:** 6308 (example)

**Btype:** Ball

**C kn:** 41

**P kn:** 4.5

**Expo:** 3

**Rpm:** 1450

**Req h:** 40000

**Due:** 2027-03-31

**Tag:** CNV-101 head pulley

**Bearing:** 22216 (example)

**Btype:** Spherical roller

**C kn:** 190

**P kn:** 22

**Expo:** 3.33

**Rpm:** 180

**Req h:** 60000

**Due:** 2027-06-30

**Tag:** FAN-204 motor DE

**Bearing:** 6310 (example)

**Btype:** Ball

**C kn:** 62

**P kn:** 9

**Expo:** 3

**Rpm:** 1780

**Req h:** 40000

**Due:** 2027-01-15

**Tag:** PMP-310 pump

**Bearing:** 6206 (example)

**Btype:** Ball

**C kn:** 20.3

**P kn:** 3.2

**Expo:** 3

**Rpm:** 2900

**Req h:** 30000

**Due:** 2026-12-10

**Tag:** MIX-405 gear shaft

**Bearing:** 30210 (example)

**Btype:** Tapered roller

**C kn:** 76

**P kn:** 14

**Expo:** 3.33

**Rpm:** 320

**Req h:** 50000

**Due:** 2027-09-01

**Totals:**

#### Bearings listed

**Key:** tag

**Agg:** count

#### Lowest life margin

**Key:** margin

**Agg:** min

**Format:** decimal

#### Shortest L10 life (hours)

**Key:** l10_h

**Agg:** min

**Format:** integer

**Summary:**

#### Average life margin

**Key:** avg_life_margin

**Expr:** avg_margin

**Format:** decimal

**Notes:** Basic rating life per ISO 281: L10 = (C / P)^p million revolutions, and L10h = 10^6 / (60 n) x L10. Example C ratings are typical catalog magnitudes only, so replace them with the values for your exact bearing and series from the manufacturer's catalog. P is the equivalent dynamic load including radial and axial components. A margin below 1 means the bearing is expected to fall short of the required life with 90 percent reliability. Adjusted life with reliability, lubrication and contamination factors (ISO 281 a_ISO) is not included.

## Content

**Intro:** This editable worksheet calculates basic rating life (L10) in hours for each bearing on your list and compares it to the life you need. Maintenance planners use it to rank which drives deserve attention first and to set replacement or inspection dates.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per bearing position. Enter the catalog dynamic load rating C in kN, the equivalent dynamic load P in kN, the speed and the life you require. Set the exponent to 3 for ball bearings and 3.33 (10/3) for roller bearings. The sheet computes L10 in million revolutions and hours, plus a margin showing how many times the required life you get. Sort by the margin column to find the bearings most at risk and enter a review date for each.

#### The formula and the standard

**Body:** Basic rating life under ISO 281 is L10 = (C / P)^p in millions of revolutions, where p is 3 for ball and 10/3 for roller bearings. Dividing by speed gives hours: L10h = 1,000,000 / (60 n) x (C / P)^p. L10 is the life that 90 percent of a group of identical bearings reach or exceed under the stated load. It assumes normal lubrication and no contamination. Modified life with reliability and lubrication factors can be much longer or shorter than the basic value.

#### Reading the result

**Body:** A margin of 1 means the basic life exactly equals the target. Margins between about 1 and 2 are tight because actual life varies widely and contamination or misalignment shortens it. Margins above 3 leave room for variation. A fast, lightly loaded motor bearing can show life in the hundreds of thousands of hours and fail early from lubricant aging instead, so use the sheet for load-related wear, not lubrication failures.

#### Common mistakes

**Body:** The usual errors are using the static rating C0 instead of the dynamic rating C, mixing kN and N, and using only the radial load when axial thrust applies. Equivalent load P = X Fr + Y Fa needs factors from the bearing catalog. Duty cycles with varying load and speed need a weighted equivalent load, not one nominal point. Treat the worksheet as a ranking tool, then do a full calculation for the critical bearings.

**Cta:** If you want bearing life, vibration readings and PM work orders in one place, Netray can help connect your maintenance module and condition data.

**Faq:**

#### What is bearing L10 life?

**Answer:** L10 is the basic rating life: the number of revolutions, or hours at a constant speed, that 90 percent of a large group of identical bearings will reach or exceed before fatigue spalling appears, under a given steady load and normal conditions.

#### How do I calculate L10 hours?

**Answer:** Divide C by P, raise the result to the power 3 for ball bearings or 10/3 for roller bearings, giving millions of revolutions. Multiply by 1,000,000 and divide by 60 times the speed in rpm to get hours.

#### Where do I find the dynamic rating C?

**Answer:** It is published in the bearing manufacturer's catalog or online selector for each designation, in kN. Ratings differ by series and brand, so use the value for your exact part. The example values in this sheet are indicative only.

#### Is a high L10 value a guarantee against failure?

**Answer:** No. L10 covers only fatigue under clean, well-lubricated conditions. Most real bearing failures come from contamination, poor lubrication, misalignment, or installation damage, so combine life calculations with condition monitoring and good lubrication practice.

## Search terms

bearing L10 life worksheet, bearing life schedule excel, bearing replacement schedule template, L10 hours calculation spreadsheet, bearing life calculation multiple bearings, basic rating life ISO 281, bearing PM planning worksheet, bearing life margin

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json