---
name: teknik-acik-isler
description: "Use when an overdue open engineering work orders analysis is requested from fault list, open/close timestamps, applicable resolution target and report time. Produce a formula-based Excel file and a Word summary."
---

# Overdue open engineering work orders

At shift handover, which open fault has exceeded its own resolution target, and by how much?

## Input and scope

Fault list, open/close timestamps, applicable resolution target and report time.

Use the attached Excel/CSV files as the source. Read each one without modifying it. Identify the sheets, report scope, periods, units and required fields. Match synonymous column headers to the sample. If a missing field affects only a specific metric, still produce the other metrics. If a critical definition can be interpreted in more than one way, ask one focused question. Trace subtotals and duplicates back to the source row. Remove fields containing personal data from the output. Use the sample only when the user wants to try it with the sample data.

## Analysis

1. Use the latest status of each work order. Calculate elapsed time up to the report time for open jobs and up to closure for closed jobs. Apply only the defined working calendar and pause rules.

2. Separate the first-response target from the resolution target. If no target is defined, do not assign an overrun. For records that were opened, closed and reopened, verify the applicable cycle.

3. Target overrun = max(0, elapsed time − resolution target). Put open jobs that exceed their target at the top of the handover, and closed overruns into the quality review.

## Delivery and checks

On the first sheet of Analiz.xlsx, show the rows that answer the question and the calculated indicators. Keep the sources on a separate sheet with anonymised fields. Write Excel formulas for derived measures. On the Checks sheet, add the date range, column mapping, scope, missing/unmatched records and the reconciliation result. Create the Word file as Yonetim-Ozeti.docx. On one page, write the period, the main result, at most three evidenced findings and the work the responsible team should check. Reopen both files; independently check the numbers, the denominators of the ratios and the source totals. Do not report causes you cannot verify as findings. Deliver both files as downloads.

Visible fields in the Excel analysis: Work order, Location, Status, Target overrun (min), Handover.

## Try it with the sample

Use assets/ornek-girdi.xlsx. The expected Excel and Word examples are in the ornekler/ folder. Check specific to this sample: T-104 is open and has exceeded its resolution target by 70 minutes.
