# ECO Backlog Aging Worksheet

> Source: https://netray.co/tools/eco-backlog-aging-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

List open ECOs with stage, owner, age and target days, and see overdue days and engineering hours at a glance for the weekly change board.

## Category

engineering-plm

## Audience

- Engineering manager
- Configuration manager
- Change board chair

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### ECO number

**Key:** eco

**Type:** text

#### Title

**Key:** title

**Type:** text

#### Owner

**Key:** owner

**Type:** text

#### Stage

**Key:** stage

**Type:** select

**Options:**

- Draft
- Impact review
- Approval
- Implementation
- Awaiting supplier
- Release pending

#### Opened

**Key:** opened

**Type:** date

#### Days open

**Key:** days_open

**Type:** number

**Help:** Calendar days since the ECO was opened.

#### Target days

**Key:** target_days

**Type:** number

**Help:** Target cycle time for this change class.

#### Days overdue

**Key:** overdue

**Type:** number

**Expr:** max(days_open - target_days, 0)

**Format:** days

#### Remaining effort

**Key:** hours

**Type:** number

**Unit:** hours

**Rows:**

#### Replace bracket fastener

**Eco:** ECO-2041

**Owner:** R. Mehta

**Stage:** Approval

**Opened:** 2026-08-24

**Days open:** 56

**Target days:** 30

**Hours:** 6

#### Update connector part number

**Eco:** ECO-2057

**Owner:** L. Okafor

**Stage:** Awaiting supplier

**Opened:** 2026-09-08

**Days open:** 41

**Target days:** 45

**Hours:** 10

#### Revise housing drawing tolerance

**Eco:** ECO-2063

**Owner:** J. Chen

**Stage:** Impact review

**Opened:** 2026-09-22

**Days open:** 27

**Target days:** 21

**Hours:** 14

#### Add alternate source for PCB

**Eco:** ECO-2070

**Owner:** S. Patel

**Stage:** Implementation

**Opened:** 2026-09-30

**Days open:** 19

**Target days:** 30

**Hours:** 22

#### Correct BOM quantity on subassembly

**Eco:** ECO-2076

**Owner:** R. Mehta

**Stage:** Release pending

**Opened:** 2026-10-07

**Days open:** 12

**Target days:** 10

**Hours:** 2

**Totals:**

#### Total days overdue

**Key:** overdue

**Agg:** sum

**Format:** days

#### Total remaining effort

**Key:** hours

**Agg:** sum

**Format:** hours

#### Oldest ECO

**Key:** days_open

**Agg:** max

**Format:** days

**Summary:**

#### Average age

**Key:** avg_age

**Expr:** avg_days_open

**Format:** days

#### Average days overdue per ECO

**Key:** avg_overdue

**Expr:** sum_overdue / count

**Format:** decimal

**Notes:** Update days open weekly from your change system. Sort by days overdue before the change board and decide per ECO whether to escalate, split or cancel.

## Content

**Intro:** A change board is only as good as the list in front of it. This worksheet gives engineering managers a simple aging view of open ECOs, with overdue days calculated for each row and totals that export cleanly to Excel.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per open ECO. Enter the stage, how many days it has been open and the target days for its change class. Overdue days are computed automatically. Sort by the overdue column and take the top items to your weekly board. Export to Excel to share with approvers or to keep a dated snapshot of the backlog.

#### Choosing target days

**Body:** Set target days by change class rather than one number for everything. A documentation correction may have a target of 10 days, a form-fit-function change 30 days and a change requiring customer or supplier approval 45 or more. Targets should be tough but realistic, or the overdue column becomes noise.

**Bullets:**

- Use calendar days, consistently.
- Restart the clock only on a formal resubmission.
- Record the reason when a target is changed.

#### Reading the totals

**Body:** Total overdue days shows the scale of the problem, while the oldest ECO highlights the item most likely to be stuck. Remaining effort shows whether the backlog is a capacity issue or an approval issue. If effort is small but age is large, ECOs are waiting on people, not work.

#### Common mistakes

**Body:** Leaving stale ECOs open inflates age and hides the live backlog. Cancel or close changes that no longer matter. Also avoid tracking only the engineering stage, because waiting at purchasing, quality or the supplier is often the longest segment.

**Cta:** If your ECOs live in an ERP or PLM, Netray can generate this aging view automatically from your change records so the worksheet is not hand-typed.

**Faq:**

#### How often should I review the backlog?

**Answer:** Weekly works for most change boards. Review the top overdue items and any ECO with no movement in two weeks. Emergency changes should be reviewed as they arrive.

#### What stages should I track?

**Answer:** Use the stages your process really has: draft, impact review, approval, implementation, supplier action and release. Fewer, well-defined stages are better than many that are rarely updated.

#### Can I import from my PLM?

**Answer:** Most systems export open changes to CSV or Excel. Paste the columns you need into the worksheet or re-enter the main fields and use the overdue calculation.

#### What if a target is wrong for an ECO?

**Answer:** Change the target and note the reason in the title or your log. A target that is routinely exceeded for a change class should be revised for that class rather than silently ignored.

## Search terms

eco backlog tracker excel, engineering change tracking spreadsheet, open eco list, change board agenda worksheet, eco aging report, engineering change log excel, overdue eco tracker, eco status tracker

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