# MRO Non-Routine Findings Log Worksheet

> Source: https://netray.co/tools/mro-non-routine-findings-log-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Log every non-routine finding during a check with estimated hours and parts, and see the running cost to share with the customer.

## Category

aerospace-defense

## Industry

Aerospace MRO

## Audience

- Production controller
- Maintenance planner
- Commercial manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### NRC no.

**Key:** nrc

**Type:** text

#### Parent task card

**Key:** parent

**Type:** text

#### Finding

**Key:** finding

**Type:** text

#### Status

**Key:** status

**Type:** select

**Options:**

- Open
- Awaiting customer approval
- Awaiting parts
- In work
- Closed

#### Est. hours

**Key:** hours

**Type:** number

**Unit:** h

#### Labor rate

**Key:** rate

**Type:** number

**Format:** currency

#### Labor cost

**Key:** labor

**Type:** number

**Expr:** hours * rate

**Format:** currency

#### Parts cost

**Key:** parts

**Type:** number

**Format:** currency

#### Line total

**Key:** total

**Type:** number

**Expr:** hours * rate + parts

**Format:** currency

**Rows:**

**Nrc:** NRC-001

**Parent:** TC-0142

**Finding:** Corrosion on gear bay fitting

**Status:** Awaiting customer approval

**Hours:** 14

**Rate:** 95

**Parts:** 1850

**Nrc:** NRC-002

**Parent:** TC-0188

**Finding:** Chafed harness clamp aft cabin

**Status:** In work

**Hours:** 3

**Rate:** 95

**Parts:** 120

**Nrc:** NRC-003

**Parent:** TC-0201

**Finding:** Cracked fairing bracket

**Status:** Awaiting parts

**Hours:** 5

**Rate:** 95

**Parts:** 640

**Nrc:** NRC-004

**Parent:** TC-0233

**Finding:** Seat track fastener missing

**Status:** Closed

**Hours:** 1.5

**Rate:** 95

**Parts:** 35

**Totals:**

#### Total hours

**Key:** hours

**Agg:** sum

**Format:** number

#### Total labor

**Key:** labor

**Agg:** sum

**Format:** currency

#### Total parts

**Key:** parts

**Agg:** sum

**Format:** currency

#### Total NRC value

**Key:** total

**Agg:** sum

**Format:** currency

**Summary:**

#### Average cost per finding

**Key:** avg_nrc

**Expr:** sum_total / count

**Format:** currency

**Primary:** true

#### Labor share of total

**Key:** labor_share

**Expr:** if(gt(sum_total,0), sum_labor / sum_total * 100, 0)

**Format:** percent

**Notes:** Estimates only. Customer approval and the final invoice follow your contract and your records.

## Content

**Intro:** During heavy checks, findings keep appearing and the customer wants a running number. This worksheet keeps every non-routine finding in one place with hours, parts and status.

**Sections:**

#### How to use the worksheet

**Body:** Add a row for each non-routine card as it is raised. Enter the parent task card, a short finding description, estimated hours, labor rate and parts cost. Line total and labor cost calculate automatically, and the totals show the exposure. Update the status as approvals arrive. Export to Excel to send a snapshot to the customer or the commercial team, and refresh daily during a check so the numbers do not go stale.

#### How to read the results

**Body:** The total NRC value is the money in play, but only part of it is approved. Filter by status in Excel to separate open, approved and closed work. A rising labor share often signals access and removal effort, while a high parts share points to material and lead time risk.

**Bullets:**

- Open and Awaiting approval lines are unbilled risk
- Awaiting parts lines drive turn time, chase them first
- Average cost per finding helps estimate the next check

#### Common mistakes

**Body:** Teams often log findings only in the paper stack, so the cost summary lags the hangar by days. Another error is using one average labor rate when line, avionics and structures rates differ; split rows by skill if needed. Do not close a line until the closing task card, release and any parts traceability are complete. If your ERP or MRO system holds non-routine cards, use this sheet as a quick view and reconcile weekly.

**Cta:** If findings and estimates are scattered across spreadsheets and email, we can help bring them into your ERP reporting.

**Faq:**

#### Is this a replacement for my MRO software?

**Answer:** No. It is a quick working log for planners who currently use Excel. It does not replace controlled records in your maintenance information system.

#### Can I add more columns?

**Answer:** Export to Excel and extend it as you like, for example ATA chapter, customer approval date or ordered parts reference.

#### How do I handle different labor rates?

**Answer:** Enter the applicable rate on each row. You can use a different rate for avionics, structures or cabin work and the totals still sum correctly.

#### What does labor share tell me?

**Answer:** It shows the portion of total value that is labor rather than parts. Use it to spot checks dominated by access time or by material.

## Search terms

non routine card log excel, nrc log template aviation, aircraft check findings tracker, non routine findings spreadsheet, mro nrc cost estimate, heavy check findings log, aircraft defect log template, nrc tracking worksheet

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