# Breakdown register format (Excel) that you can still search in two years

A breakdown register lasts only if the columns stay fixed. This post lists the fields that make an old row findable later, shows three illustrative Excel examples, and ties weak machine-history recording in a Cebu MSMI study to why Indian plants need a searchable register.

**Short answer:** A breakdown register you can still search in two years needs fixed fields, not free text alone: asset ID and serial, fault code as displayed, symptom, cause, fix, parts with numbers, captioned photos, date and technician. The columns below, with a filled example you can copy into Excel, are built so a later search can find the row.

**Applies to:** maintenance and service teams that keep a breakdown register, job cards or downtime log in Excel or on paper, especially Indian plants that use "breakdown" vocabulary. Worked examples use fault codes already covered on this blog (for example Delta MS300 ocA). **Last verified:** 5 Nov 2026. **Author:** Muhammed Fahiz

## What should a breakdown register include?

A usable breakdown register is a single place where each breakdown gets one row, with the same columns every time. It is not a free-text notebook and it is not a scrap of paper that says "running now".

At minimum it should capture:

- Which machine it was (asset ID, model, serial)
- What the machine showed (fault code as displayed)
- What the engineer saw (symptom in plain words)
- What was found and what was done (cause, fix)
- What parts went on (with part numbers)
- When, who, and optionally how long it was down
- Photos kept with the row, with a short caption

Without those fields, a later search for the same machine and the same code has nothing solid to match. Nick Nickolovski put the failure mode in one sentence in a comment on a public LinkedIn post by Delin S. in October 2026: "Same machine, five different descriptions, so it never adds up to one problem." We wrote that problem up in [same machine, five descriptions](https://hangersearch.com/blog/repeat-breakdown-same-machine).

The rest of this post is the field list, why each field helps a search two years later, a filled example, and when Excel is enough.

![Wall rack of blank machine history cards with one card pulled out beside a workshop lathe](/blog/media/breakdown-register-format-excel-mw3eh2uq.png)

## Which fields make an old report findable later?

Each column below exists so a later engineer can find the row by machine, by code, or by symptom words, and then trust what it says.

| Field | What goes in it | Why it makes the row findable later |
|---|---|---|
| Date (DD/MM/YYYY) and time | When the breakdown started or when the job closed | Lets you sort a machine's history and see repeats |
| Asset ID | Your plant tag for that machine (IM-03, CNC-07) | Groups every visit to one machine even when the description changes |
| Model | OEM model as on the nameplate | Lets you search across sister machines of the same type |
| Serial number | Nameplate serial | Distinguishes two identical models on the same line |
| Fault code as displayed | Exact code on the HMI or drive (ocA, F0001, SV0401) | The most precise search term you have; variants hide repeats |
| Symptom in plain words | What was seen before the reset ("won't accelerate under load") | Catches visits where no code was shown, and supports a word search |
| Cause found | What the check showed, not a guess | A found row is useless if it only says "checked OK" |
| Fix done | What was actually done | Tells the next engineer whether to repeat the same step |
| Parts replaced (with part numbers) | Part name and OEM or store part number | Lets you search by part and reorder the right item |
| Photo / caption | Link or file name, plus a caption naming machine and part | An uncaptioned photo can't be found or trusted later |
| Technician | Who closed the job | Useful for follow-up; not a substitute for the fields above |
| Downtime hours (optional) | Hours from stop to running again | Useful for MTTR tallies; leave blank rather than invent a number |

*Our recommended columns for a searchable breakdown register, not a published standard.*

Two fields do most of the search work: a firm machine identity (asset ID plus serial) and the fault code exactly as displayed. Without them, five different write-ups of the same fault stay five rows, which is the Nickolovski problem in [same machine, five descriptions](https://hangersearch.com/blog/repeat-breakdown-same-machine). Symptom, cause and fix are what make a found row usable. Parts and captioned photos stop the next visit from starting from zero. Our post on [what to write before closing a breakdown job](https://hangersearch.com/blog/its-running-now-is-not-a-fix) covers the write-up itself; this page is the register those write-ups feed.

## What does a filled example look like?

The three rows below are illustrative examples invented for this template. They are not real plant data. The machines and codes are the kind of Indian machine-builder and panel work this blog already covers (injection moulding and CNC with a Delta VFD fault code).

| Date | Time | Asset ID | Model | Serial | Fault code | Symptom | Cause found | Fix done | Parts replaced | Photo / caption | Technician | Downtime hrs |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12/03/2025 | 14:40 | IM-03 | Haitian MA1200 | HT-88421 | ocA | Injection screw drive trips on accel after mould change | Motor cable insulation low at terminal box; accel time too short for new mould weight | Dried and reseated terminals; lengthened accel; verified IR | None | IM-03_20250312_terminal-box.jpg - terminal box before reseat | R. Patil | 2.5 |
| 03/07/2025 | 09:15 | CNC-07 | Ace Micromatic LT-20 | AM-12044 | - | Spindle won't hold 2000 rpm under cut; no drive code | Belt glazing; tension below mark | Replaced belt; set tension to mark; test cut OK | Belt SP-LT20-B44 | CNC-07_20250703_belt-glaze.jpg - glazed belt removed | S. Khan | 1.0 |
| 28/09/2025 | 22:10 | CNV-02 | Conveyor panel, Delta MS300 | MS-55102 | ocA | Line 2 conveyor stops on start after night clean | Coolant in motor junction box; wet connectors | Dried box; replaced connectors; megger motor OK | Connector kit CK-MS3-04 | CNV-02_20250928_jbox-wet.jpg - wet junction box | Night shift / A. Desai | 3.0 |

*Illustrative examples only. Invented for the template. Not claimed as real plant records.*

Notice what a later search can do with these rows. Filter Asset ID = IM-03 and you get that machine's history. Search fault code = ocA and you get both drive trips, on two different assets. Search "junction box" or the part number CK-MS3-04 and you land on the wet-connector fix. A one-line note that said only "reset, running" would match none of those.

Copy the header row from the example table into a new sheet to start. Keep one file as the register, freeze the header, and add rows the same way every time.

## Excel or paper?

Either can work. What fails is a format that changes every shift.

**Excel (or a shared sheet)** is usually enough when:

- One file is the register, not a new workbook per month with different headers
- Headers are frozen and nobody renames columns
- Dates use one format (in India, DD/MM/YYYY) so sorts work
- Photos live in a shared folder and the Photo / caption cell holds the file name or link
- Finalized rows are not overwritten; corrections get a new note, not a silent edit

**Paper** still works on the floor for the first write-up. The risk is the transfer step. If the paper job card is the only record, a later search has to open a filing cabinet. If paper is the capture and Excel is the register, treat the Excel row as the finalized record and keep the paper only as backup.

A CMMS is fine too, as long as the same fields exist as required fields, not optional free text. The tool matters less than whether the columns stay stable for two years.

![Open laptop showing a blank spreadsheet grid beside a paper ledger and a compact VFD on a desk](/blog/media/breakdown-register-format-excel-mw3ehm9a.png)

## Why do weak machine-history records keep costing time?

A 2025 DEMATEL study of Micro, Small and Medium-Scale Machine Shop Industries (MSMIs) in Cebu City, Philippines - not India - measured how those shops were recording machine history. Van Gaitano N. Vergara surveyed preventive-maintenance practice and reported medium-level performance in recording machine history cards (1.83) and in machine safety (2.46). The same abstract flags frequent machine breakdowns, inadequate documentation and ineffective scheduling of maintenance activities.

The abstract also reports mean time between failures and mean time to repair for three problem machines in that sample: lathe MTBF 486 hrs / MTTR 144 hrs; welding MTBF 541 hrs / MTTR 59 hrs; portable grinder MTBF 311.63 hrs / MTTR 13.5 hrs. We are citing the published abstract only; the full PDF is closed access.

The geography is Cebu, Philippines. The vocabulary of this post is Indian ("breakdown register") because that is how Indian plants usually name the log. The useful takeaway for any small machine shop is the same: if machine history cards are the weak row in the scorecard, a register you cannot search later will not fix the pattern of frequent breakdowns. Filling the columns above is the low-cost version of a machine history card that a later engineer can actually find.

## How does this tie to searching old service reports?

A breakdown register is only half the job. The rows have to stay findable when the person who wrote them has left, and when the next visit is at 2 a.m.

- Group by machine first, then by code: [same machine, five descriptions](https://hangersearch.com/blog/repeat-breakdown-same-machine)
- Write cause and fix before you close: ["It's running now" is not a fix](https://hangersearch.com/blog/its-running-now-is-not-a-fix)
- Treat messy text, scans and uncaptioned photos as a data problem: [searching old service reports is a data problem](https://hangersearch.com/blog/searching-service-reports-data-problem)
- Look for a prior fix on the same alarm: [alarm already solved three years ago](https://hangersearch.com/blog/alarm-already-solved-three-years-ago) and [find a past service fix for a repeat machine fault](https://hangersearch.com/blog/find-past-service-fix-repeat-machine-fault)

None of those steps need a new tool on day one. They need the fields in the register to exist and to be filled the same way every time.

## What this doesn't tell you

The Vergara / DEMATEL paper is a study of MSMIs in Cebu City. Its Likert scores and MTBF/MTTR figures describe that sample. They are not Indian plant benchmarks and they are not a measured test of Excel registers. The field list and the three example rows are ours, built so a later search has something to match. We found no study that measures how much a fixed-column breakdown register improves search hit rate two years later.

## Where does HangerSearch fit?

If your team already writes breakdown rows and service reports, the next problem is finding the right prior case when the machine is down. HangerSearch is private, retrieval-only search over your team's own finalized service reports, searched where they already sit. You search by fault code, model or symptom. It shows the prior reports that match and why each matched, and opens the cited page. Nothing is generated, and if there is no similar report, it says so. It cannot invent an asset ID or a cause that was never written down, which is why the register columns come first. See [how we handle your reports](https://hangersearch.com/trust).

Book a 20-minute demo: hangersearch.com

## FAQ

### What is a breakdown register format in Excel?

A breakdown register in Excel is one sheet where each breakdown is one row and the columns stay fixed: date, asset ID, model, serial, fault code as displayed, symptom, cause, fix, parts with part numbers, photo caption, technician and optional downtime hours. Freeze the header row, use DD/MM/YYYY in India, and keep photos in a shared folder linked from the Photo cell.

### Which fields make an old breakdown report searchable later?

Asset ID plus serial, and the fault code exactly as displayed, do most of the find work. Symptom, cause and fix make a found row usable. Part numbers and captioned photos stop the next visit from starting from zero. Free text alone, with no machine identity and no code, is what produces five descriptions of the same fault.

### Is Excel enough, or do we need a CMMS?

Excel is enough if one file is the register, headers never change, dates use one format, and finalized rows are not silently edited. A CMMS is fine when the same fields are required. Paper is fine for capture if the finalized record still lands in the register. The format that fails is a new layout every month.

### Why cite a Cebu study in an India breakdown-register post?

Because the published abstract is one of the few recent open measurements of weak machine-history-card recording in small machine shops, and the documentation gap it reports is the same gap an Indian breakdown register is meant to close. The plants studied were MSMIs in Cebu City, Philippines - not India. The MTBF/MTTR figures are from that sample only.

## Sources

1. Van Gaitano N. Vergara, "Assessing Preventive Maintenance Program for Micro, Small, and Medium Scale Machine Shop Industries Using DEMATEL", 2025 4th International Conference on Computational Modelling, Simulation and Optimization (ICCMSO), published 20 Jun 2025, DOI 10.1109/iccmso67468.2025.00041. Cited from the published abstract only (full PDF closed access). Read 5 Nov 2026. Supports: Cebu City MSMIs geography; medium-level performance for machine history cards (1.83) and machine safety (2.46); lathe MTBF 486 hrs / MTTR 144 hrs; welding MTBF 541 hrs / MTTR 59 hrs; portable grinder MTBF 311.63 hrs / MTTR 13.5 hrs; findings of frequent breakdowns, inadequate documentation and ineffective scheduling.
2. Nick Nickolovski, comment on Delin S., public LinkedIn post "Maintenance keeps fixing, but the same machine keeps breaking." (11 Oct 2026); comment dated 12 Oct 2026: https://www.linkedin.com/posts/delinsirkov_maintenance-cmms-reliability-activity-7514852511011463168-0mhw. Previously read for [our repeat-breakdown post](https://hangersearch.com/blog/repeat-breakdown-same-machine) (31 Oct 2026). Supports: "Same machine, five different descriptions, so it never adds up to one problem."
3. Delta MS300 Series User Manual context for the ocA example code only: see our earlier post [Delta VFD fault codes](https://hangersearch.com/blog/delta-vfd-fault-codes). The example rows in this article are invented illustrations, not field reports.

## Related

- [Same machine, five descriptions: why repeat faults never add up](https://hangersearch.com/blog/repeat-breakdown-same-machine)
- ["It's running now" is not a fix](https://hangersearch.com/blog/its-running-now-is-not-a-fix)
- [Searching old service reports is a data problem, not a model problem](https://hangersearch.com/blog/searching-service-reports-data-problem)
- [The alarm was already solved three years ago](https://hangersearch.com/blog/alarm-already-solved-three-years-ago)
- [Find a past service fix for a repeat machine fault](https://hangersearch.com/blog/find-past-service-fix-repeat-machine-fault)
- [How HangerSearch handles your data](https://hangersearch.com/trust)