Your prompt sheet

Analyze this maintenance data and create a dashboard.

You are a maintenance operations analyst building an executive dashboard in Excel.

The attached file has 2,419 maintenance work orders. Each row is one work order,
with Site, Asset, Priority, RaisedDate, CloseDate, DowntimeHours, Cost_KWD and
Contractor. RaisedDate and CloseDate are text in three different formats. Asset
names appear in more than one spelling. Some work orders have no CloseDate.

Build a dashboard that answers four questions for an operations director:
1. Which sites carry the most unplanned downtime? Unplanned means Emergency or Urgent.
2. Which assets generate the most emergency work orders?
3. How is downtime trending month by month?
4. Where is cost concentrated?

Requirements:
- Clean the dates to one format and normalize asset names before building anything.
- One dashboard sheet. Source data and pivot tables on separate sheets.
- Four KPI cards across the top: total work orders, total unplanned downtime hours,
  total cost, and the count of work orders with no close date.
- Slicers for Site and Priority that filter every chart at once.
- Bar charts sorted largest first, never alphabetical.
- Every chart title states the finding, not the field names.
- Conditional formatting to flag any work order above 50,000 KWD.
- State the row count you used and list every row you excluded and why.

You are a maintenance data analyst.
Each row in this file is one maintenance work order. There are 40 rows.
Which site had the worst unplanned downtime last quarter?
Unplanned means Priority is Emergency or Urgent.
Last quarter means April to June 2025.
Give a table of sites with total downtime hours, highest first.
State the row count you used. List any rows you excluded and say why.

You are a data analyst.
I am giving you a maintenance work order file. Each row is one work order.

Before any analysis, profile this file. Answer these six questions:
1. How many rows and columns?
2. What does one row represent?
3. What is the date range, and which column holds it?
4. Which columns have blank values, and how many in each?
5. Are there duplicate records? Say whether you matched on ID or on the whole row.
6. Which text columns contain the same value written more than one way? List the variants.

Do not analyze anything yet. Report the profile only.

I have this work order table open. Each row is one work order.

Before answering, state:
- the number of rows in the table
- the date range and which column holds it

Then add a column to the table that flags unplanned work orders.

With your answer, state the number of rows you used and the number
you excluded. For every excluded row, say why.

How many rows and columns are in this table?
List every column name and what type of value it holds.
What is the earliest and latest date in the file?

For every column in this table, tell me how many rows have a value
and how many are blank. Show it as a count and a percentage.
Sort it so the emptiest column is first.

What is the average time to close a work order, for each site?
Time to close means the number of days between RaisedDate and CloseDate.
Show it as a table, fastest site first.

What is the average time to close a work order, for each site?
Time to close means the number of days between RaisedDate and CloseDate.

Before you answer:
- tell me how many work orders have no CloseDate
- show that count by site, as a percentage of that site's rows

Then give me two tables:
Table A: the average using only work orders that have a CloseDate.
Table B: the average counting work orders with no CloseDate as still
open, measured from RaisedDate to 30 June 2025, the latest raised
date in the file.

Tell me which sites change rank between the two tables.

Take the Table B figures. For each site, show:
- its average days to close
- the average across all six sites
- the difference, in days and as a percentage

Sort worst first.

Split the work orders into two periods by RaisedDate:
May to December 2024, and January to June 2025.
Show average days to close for each site in each period,
and the change between them.

Compare each site's average days to close, counting open work orders,
against a 30-day target. Show days over or under.
Say plainly that the 30-day figure was supplied by me and is not
derived from this file.

Are there any values in this table that should not be possible?
Check for negative numbers in every numeric column and count them.

Total spend by cost center. Before you answer, tell me how many rows
have a negative amount and what they appear to be.

Then give me two tables:
Table A: the sum of positive amounts only.
Table B: the sum of every amount, so credit notes reduce the total.

Tell me which cost centers change rank between them.

How many rows and columns are in this table?
List every column name and what type of value it holds.
What is the earliest and latest date in the file?

For every column, tell me how many rows have a value and how many
are blank. Show a count and a percentage, emptiest column first.

Then: are there any values here that should not be possible?
Check every numeric column for negatives and count them.

What is [your measure], for each [group]?
Define [your measure] in plain words, in the prompt.
Show it as a table, [best or worst] first.

Same question. Before you answer:
- tell me how many rows you are excluding and why
- show that count by group, as a percentage of each group's rows

Then give me two tables, one on each reasonable definition,
and tell me which groups change rank between them.

For each group, show its figure, the average across all groups,
and the difference in units and as a percentage. Worst first.

Split the data into two periods by [date column].
Show the figure for each group in each period, and the change.

Compare each group against a target of [X].
Show over or under. State plainly that [X] came from me and is not
derived from this file.