You own one generator or several, in a building, shop, factory or farm, and you want to know how much diesel each one burns per hour, when the oil and filters are due before something fails, and what the generators really cost you each month. The free generator maintenance sheet answers this from three logs you type: runtime, service and breakdowns.
The problem it solves
A generator runs only when the power fails, so nobody remembers its service until it breaks. Diesel is bought in batches on loose paper, so the cost of a running hour stays unknown and a generator that burns more than its twin goes unnoticed. With sites in several places the paper multiplies. Periodic service is usually measured in running hours, not dates, and the sheet works those hours out from the runtime log itself.
How it works, step by step
- In الإعدادات (Settings) type today's date, the analysis period (from and to), the "soon" percentage, the idle days and the report year.
- In المولدات (Generators) register each one: code, make, kVA, location, fuel type, tank size, service interval in hours and the hour-meter reading before the first log row.
- In أنواع الصيانة (Service types) edit the list of jobs and each interval in hours.
- In سجل التشغيل (Runtime log) type each run: date, generator, start and stop meter (or the hours directly), litres added and their cost.
- In جدول الصيانة (Service schedule) list which service types each generator follows, and record every service done in سجل الصيانة (Service log).
- The sheet calculates hours since the last service, the hours left and the status: "overdue" when the interval is reached, "soon" at the percentage you set, otherwise "OK".
- Open التنبيهات (Alerts), الملخص (Summary) and شهري (Monthly) for priorities and costs with charts.
What each sheet does
- المولدات: the register plus running hours, litres, litres per hour and its cost, total cost per hour, the current meter, how many hours the tank lasts, maintenance status and an idle flag.
- سجل التشغيل: one row per run with the price per litre worked out,.
- التنبيهات: overdue, then soon, then never-serviced items, ordered by priority.
- Service sheets and الأعطال: the type list, the schedule, the service log and the breakdowns.
- شهري and الملخص: fuel, service and repair cost by month and by generator, with four charts.
Walk-through on the sample numbers
The generators and figures below are sample data in the file, not a real business. The example has 5 generators and 26 runs, today is 20 November 2026 and the analysis period runs from 1 October to 30 November:
- Fuel: 235 running hours and 2,620 litres costing 53,458 in total, an average of 11.15 litres per hour and 20.40 per litre.
- Thirstiest generator: the Cummins 250 with 92 hours and 1,435 litres, or 15.60 litres per hour. The Perkins 100 ran 44 hours on 443 litres, 10.07 per hour. The Honda 5.5 ran 14 hours on 22 litres, 1.57 per hour, and its 15-litre tank lasts about 9.5 hours.
- Service: the Perkins 100 oil was last changed at meter 990 and the meter now reads 1,224, so 234 of 250 hours have passed (94%): "soon", 16 hours left. Its fuel filter has run 524 hours against 500, so it is "overdue" by 24 hours.
- Alert order: most overdue is the Deutz 60 fuel filter (615 hours against 500), then the Perkins filter, then the Cummins oil (262 against 250). The Cummins air filter is "soon" (462 of 500) and its battery check has "no record". In total 9 items are OK, 2 soon, 3 overdue and 1 has no record.
- Idle: the rental Perkins 40 last ran on 5 November, 15 days ago against a limit of 14, so it shows "not run".
- Cost: 5 breakdowns cost 7,080 with 52 hours of downtime (the biggest was the Perkins 100 vibration at 3,200 and 24 hours), and service in the period cost 2,610. Total cost is 63,148, or 268.71 per hour.
- Monthly: October had 145 hours and a total cost of 37,152 (256.22 per hour); November had 90 hours and 25,996 (288.84 per hour).
Features and why they matter
- Service by hours, not dates: you see the generator that is nearly due even if it hardly ran.
- Litres and cost per hour for each generator: spot the thirsty one and compare sites.
- Total cost: fuel, service and repairs together, so breakdowns are not forgotten.
- Works in Excel 2016 and later, Google Sheets and LibreOffice, free. It holds 20 generators, 1,500 runs, 500 services and 300 breakdowns.
Common mistakes
- A stop meter below the start: the row turns red and its hours are not counted.
- Leaving the hours before the first log row empty: the meter starts from zero, so service looks earlier or later than it is.
Putting it to use
Open the sheet and replace the examples with your generators, type each meter from its current reading, then record the last service of each type. If you track cars instead, see the fleet fuel and maintenance sheet, and for parts the spare parts inventory sheet.
Who it suits and when it is not enough
It suits an owner of a building, factory, farm or rental generators who types the runs personally. When you have many technicians across sites who should each log from their phone and you want alerts sent automatically, Softwiro can build a system around the way you work.
Your next step
Download the sheet, enter one generator with its last meter reading and last service, log this week's run and read its maintenance status in the "المولدات" sheet.
FAQ
How do I work out diesel use per hour? Divide litres added by running hours, which is what the "litres / hour" column does.
Does the status change when I log a service? Yes, the latest service meter comes from the log and the status goes back to "OK".





