# Lubrication Route and Schedule Worksheet > Source: https://netray.co/tools/lubrication-route-schedule-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Build a lubrication schedule by point: lubricant, method, grams per shot, shots and frequency, with annual consumption calculated per row. ## Category maintenance ## Audience - Maintenance manager - Lubrication technician - Reliability engineer ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Lube point **Key:** point **Type:** text #### Equipment **Key:** equip **Type:** text #### Lubricant **Key:** lubricant **Type:** text #### Method **Key:** method **Type:** select **Options:** - Grease gun - Auto lubricator - Oil level check - Oil change - Manual oiler #### Grams per application **Key:** qty **Type:** number **Unit:** g #### Applications per visit **Key:** shots **Type:** number #### Interval **Key:** freq **Type:** number **Unit:** days #### Annual use **Key:** annual_kg **Type:** number **Expr:** qty * shots * 365 / freq / 1000 **Format:** decimal **Unit:** kg #### Next due **Key:** next **Type:** date **Rows:** **Point:** Main motor DE bearing **Equip:** Fan F-12 **Lubricant:** Polyurea EP2 grease **Method:** Grease gun **Qty:** 8 **Shots:** 1 **Freq:** 90 **Next:** 2026-11-15 **Point:** Spindle ways **Equip:** Lathe L-04 **Lubricant:** Way oil ISO VG 68 **Method:** Auto lubricator **Qty:** 60 **Shots:** 1 **Freq:** 30 **Next:** 2026-11-02 **Point:** Gearbox sump **Equip:** Conveyor C-12 **Lubricant:** Gear oil ISO VG 220 **Method:** Oil level check **Qty:** 0 **Shots:** 1 **Freq:** 14 **Next:** 2026-10-27 **Point:** Chain drive **Equip:** Conveyor C-12 **Lubricant:** Chain oil ISO VG 150 **Method:** Manual oiler **Qty:** 30 **Shots:** 2 **Freq:** 30 **Next:** 2026-11-05 **Point:** Pump bearing housing **Equip:** Pump P-210 **Lubricant:** Lithium complex grease NLGI 2 **Method:** Grease gun **Qty:** 12 **Shots:** 2 **Freq:** 60 **Next:** 2026-12-01 **Totals:** #### Total annual lubricant **Key:** annual_kg **Agg:** sum **Format:** decimal #### Lube points **Key:** point **Agg:** count **Format:** integer **Summary:** #### Average annual use per point (kg) **Key:** avg_use **Expr:** sum_annual_kg / count **Format:** decimal **Notes:** Oil level checks use zero grams because no lubricant is added on a normal visit; add a separate row for top-ups or changes. Treat quantities as starting values and adjust with condition monitoring. ## Content **Intro:** Lubrication is routine work that is easy to lose in a spreadsheet nobody trusts. This worksheet lists every lube point with its lubricant, method, quantity and interval, then calculates annual consumption so you can buy, store and schedule correctly. **Sections:** #### How to use the worksheet **Body:** Add one row per lube point, not per machine. Record the exact lubricant the manufacturer specifies, the method, the grams per application, how many applications each visit and the interval in days. The annual use column multiplies quantity by applications per visit by visits per year, then converts grams to kilograms. Export to Excel for route printing, or to PDF for a floor copy. **Bullets:** - Use one lubricant name per product to avoid mixing - Group rows by route in the equipment column - Set next due dates in a way that spreads work across weeks - Review quantities after the first quarter of oil analysis #### Choosing intervals and quantities **Body:** Start from the OEM manual, then adjust for speed, temperature, contamination and load. Over-greasing is as damaging as under-greasing, because excess grease causes churning heat and seal damage. For ball bearings, a commonly used estimate of regrease quantity is outer diameter in mm times width in mm times 0.005, in grams. Our bearing grease quantity calculator applies that rule for you. #### Linking to purchasing and PM **Body:** The annual use total drives purchasing and storage: it tells you how many cartridges or drums of each product to hold. Each row also becomes a PM or task line in your CMMS or ERP, so due dates generate work orders. If one lubricant is used across hundreds of points, assign it a stock item number and reorder level so stores do not run out between routes. #### Common mistakes **Body:** Frequent errors include using two incompatible greases on one bearing, leaving the shots column at 1 when a point needs several, and treating lubrication as a single weekly task rather than a list of intervals. Another is ignoring oil analysis, which tells you when intervals are wrong. **Cta:** If lubrication routes are separate from your ERP work orders, we can help generate the route and consumption lists from your asset and PM data. **Faq:** #### How do I decide the grease interval? **Answer:** Start from the equipment manufacturer's recommendation. Then adjust for operating hours, speed, temperature and contamination, and verify with vibration or oil analysis over time. Bearings in hot, dirty or high-speed service generally need shorter intervals than clean, slow ones. #### Why is the annual use column in kilograms? **Answer:** Lubricants are bought and stored by weight or volume, usually cartridges, pails or drums. Converting grams to kilograms makes the total easy to compare against stock. For oils bought by litre, convert using the density on the product data sheet. #### Can I include oil changes? **Answer:** Yes. Add a row for the oil change with grams equal to the sump fill converted by density, one application per visit, and the change interval in days. That way, annual consumption includes oil drained and replaced. #### Does this replace a CMMS? **Answer:** No. It is a planning and quantity worksheet. Once the schedule is agreed, load the points and intervals as PM tasks in your CMMS or ERP so due work orders are generated and completion is recorded. ## Search terms lubrication schedule excel, lubrication route template, grease schedule template, lubrication plan worksheet, lube route spreadsheet, machine lubrication chart template, annual lubricant consumption calculator --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json