Data and reporting · Free Excel template

Robot Fleet Uptime and Incident Log

An Excel log of every stop and incident in a warehouse robot fleet: when, why, whether it needs a repair and how fast the vendor responded. Each month it calculates availability, MTBF and MTTR for each robot and the fleet, against the target in your service agreement.

Free: enter your name, email and job title and we email you the file. It works in Excel 2019 or later, Microsoft 365, Google Sheets and LibreOffice Calc, with no macros.
  • 5 sheets, no macros
  • Monthly availability, MTBF, MTTR
  • Against your service target
safee-robot-fleet-uptime-log-en.xlsx
RobotScheduled hDowntime hAvailabilityFailuresMTBF (h)MTTR (h)Against target
R-026200.399.96%0OK
R-0362013.097.9%2303.56.5Below target
R-046200.399.95%0OK
R-0662016.597.3%1603.516.5Below target
Example figures for October with a 98% availability target. R-06 is below target because of a battery charging fault.
What's in the file

One log for the fleet, from incident to monthly KPI

You record each stop once; the file works out the downtime and the vendor response time, and rolls them up into monthly KPIs for each robot and the fleet.

  1. 01

    Robots

    ID, type, model, serial number, zone, in-service date, battery and status of each robot, up to 60 robots.

  2. 02

    Incidents

    1,000 rows: stop and back-in-service times, one of 11 categories, failure needing repair, safety and injury, vendor call and response, cause and action, with automatic flags.

  3. 03

    Monthly KPIs

    For each robot and the fleet: scheduled hours, downtime, availability, failures, MTBF, MTTR and safety incidents, against the target.

  4. 04

    Incidents by category

    Incidents, downtime hours and share of downtime for each category in the month, with the biggest one highlighted.

  5. 05

    Settings and sources

    Operating hours and days, availability and response targets, lists, and the sources with the date checked.

Why keep your own robot fleet uptime log?

The robot vendor reports from its fleet manager, but the service agreement is usually measured on availability and response time. Your own record of every stop, with the time you called the vendor and the time they responded, gives you figures to review with them at the monthly service meeting, and shows which robots and which causes take most of the downtime.

This file holds a robot register, an incident and downtime log, and monthly KPIs: availability, mean time between failures (MTBF), mean time to repair (MTTR), incidents by category and safety incidents.

How to use the log

  1. Set up: operating hours and days, and the availability and response targets from your contract.
  2. Register the robots: a unique ID for each robot, its type and the date it entered service.
  3. Log every stop when it happens: stop and back-in-service times, category, whether it needs a repair and whether it is safety-related.
  4. Log the vendor contact: when you called, when they responded and the ticket number.
  5. Read the monthly KPIs: type the first day of the month, then review the robots below target and the biggest category.

How does the log calculate the KPIs?

Downtime = (back in service − stopped at) × 1440 minutes Scheduled hours = operating hours per day × days in month × operating days per week ÷ 7 Availability = 1 − downtime hours ÷ scheduled hours MTBF = (scheduled hours − downtime hours) ÷ failures needing repair MTTR = downtime hours of completed repairs ÷ number of completed repairs Response time = (vendor responded − vendor called) × 1440 minutes

The log separates a failure that needs a repair or a part from an operational stop such as a blocked path or a network drop: both lower availability, but only failures count in MTBF and MTTR. An open incident with no back-in-service time counts as downtime until the as-of time.

Sources

  • Reliability Magazine, Maintenance and Reliability KPI Reference, 22 July 2026 (MTBF = operating time ÷ failures, MTTR = repair time ÷ repairs, availability = uptime ÷ (uptime + downtime), citing SMRP and EN 15341). Source: Reliability Magazine.
  • SMRP Best Practice Metric 3.5.1, Mean Time Between Failures. Source: SMRP.
  • M. P. Groover, definition of availability for vehicle-based transport systems (chapter 10, section 10.6). Source: NIT Srinagar lecture notes. Last reviewed 21 October 2026.

Worked example: two robots below target in October

The figures in the file are examples: six robots scheduled 20 hours a day, seven days a week, with a 98% availability target in the contract.

  • In October (31 days) each robot has 20 × 31 = 620 scheduled hours.
  • R-03 stopped 4.5 hours with a worn drive wheel and 8.5 hours after a failed software update: 13 hours, so availability is 1 − 13 ÷ 620 = 97.9%, below target.
  • Two failures needing repair: MTBF = (620 − 13) ÷ 2 = 303.5 hours and MTTR = 13 ÷ 2 = 6.5 hours.
  • The autonomous forklift R-06 stopped 16.5 hours because its battery would not charge: availability 97.3%, and the vendor responded after 105 minutes, over the 60-minute target.
  • Battery or charging is the biggest cause of downtime in the month, so it is the first item at the service meeting.

Common mistakes in robot uptime records

  • Logging only big failures. Short, repeated stops add up to a lot of time.
  • Relying only on the vendor's report. Your log lets you compare their figures with yours.
  • Not recording when you called. Without it you cannot measure the contract response time.
  • Mixing operational stops with failures. A blocked path is a process problem, not a robot fault.
  • Ignoring small safety stops. Every safety stop caused by a person deserves a review.

What the template does not cover

The log calculates what you record; it does not read data from the vendor's fleet manager. A stop counts in the month it started, and every robot is assumed scheduled for all operating hours. Targets and hours on Settings are examples: take them from your contract. For near misses with people, also use the Near-Miss Report Form and Log.

Related Safee solution

Around the warehouse: recorded equipment and vehicle activity

Safee does not manage robots. For equipment fitted with a tracking unit it records active and idle time, from a machine signal, engine RPM or motion and angle sensors, and it tracks the delivery vans and trucks that serve the warehouse.

  • Equipment Activity Status, active or not active from a signal on the machine.
  • Equipment Activity report, with the active and non-active time of each machine.
  • Trip and stop reports for delivery vans and trucks.
  • Excel export of the reports you select.
FAQ

Questions about robot fleet uptime

Want the same kind of record for the equipment and vehicles around your warehouse? Talk to Safee.

How is robot fleet availability calculated?

Availability = 1 − downtime hours ÷ scheduled hours. The log works it out for each robot, and for the fleet by adding the scheduled and downtime hours of all robots.

What is the difference between MTBF and MTTR?

Mean time between failures (MTBF) is operating time divided by the number of failures: how long a robot runs between faults. Mean time to repair (MTTR) is repair time divided by the number of repairs: how fast it comes back.

Is a blocked path a failure?

No. It lowers availability because the robot stopped, but it does not count in MTBF or MTTR because no repair is needed. Set "Failure needing repair" to No.

What availability target should I use?

The one you agree with the vendor in the service agreement. The value on Settings is an example: replace it with your contract figure and how it is measured.

Does the log read data from the fleet manager?

No, it calculates what you record. Compare its figures with the vendor's reports each month and discuss the differences at the service meeting.

Does the file work in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. In Excel it needs Excel 2019 or later, or Microsoft 365. It also works in LibreOffice Calc.

Next step

Talk to Safee about your warehouse fleet

Tell us about the equipment and vehicles that run around your warehouse, and we will show you how Safee records their activity and trips.

Related tools and templates

More for warehouse automation

Get the report

Enter your details and we will email you the file.

Use your real name so the file arrives addressed to you. Don't worry, we won't flood you with emails or calls.

Scroll to Top