Enter or review these records before relying on the summary.
Suggested for your taskFor a small repair workshop
Repair Queue & Handover
Carry a repair from intake to verified handover.
Follow the item's condition, diagnosis, approval, parts, work, final test and actual collection as separate records.
Excel 2021, Excel 2024 or Microsoft 365 with XMATCH; native compatibility not verified. Spreadsheet software is separate.
- Format
- Excel · .xlsx
- Inside
- 9 worksheets
- Included
- Clean file + example + guide
$9.90USD · one-time priceVAT included where applicable. Other applicable taxes are shown at checkout.Explore the sheets Follow the real example
Check the capacity and fitWho it is for, supplied record limits and software requirements
The everyday problem
Carry a repair from intake to verified handover.
Follow the item's condition, diagnosis, approval, parts, work, final test and actual collection as separate records.
Optional guideNeed help getting started?Choose where to begin. All listed files are included.
Add the complete product to your cart whenever you’re ready. Use this guide only if you’d like help choosing what to open first; your choices do not change the product or its price.
Guide step 1 of 4
What would you like to do?
Pick a useful task, or build your own selection.
Which sheets would you explore first?
Choose your starting points. The workbook keeps all its connected sheets and formulas; this does not remove or rebuild worksheets.
Nothing selected yet.
Enter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskWhich file would you open first?
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Your starting plan.
Your first file or method
Both XLSX files, all 9 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the complete setup guideThe complete product. Your starting choices do not change its contents or price.
Your choices help you understand the complete product. They do not alter its contents or price.
Both XLSX files, all 9 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the tasks, contents and file choices
Useful starting tasks
Record the object as received. Use the included START_HERE.pdf guide to follow one complete task in a disposable example copy.
Choose my own starting points. Explore the contents and select only the parts you would use first.
Contents to explore
- Dashboard: Enter or review these records before relying on the summary.
- Start: Enter or review these records before relying on the summary.
- Settings: Enter or review these records before relying on the summary.
- Customers: Enter or review these records before relying on the summary.
- Intake: Enter or review these records before relying on the summary.
- Diagnoses: Enter or review these records before relying on the summary.
- Parts: Enter or review these records before relying on the summary.
- Work Log: Enter or review these records before relying on the summary.
- Handover: Enter or review these records before relying on the summary.
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Explore the worked example: Fictional records show how the sheets work together. Save a disposable copy before trying a change. repair-queue-example.xlsx
Start my own working copy: Open the clean workbook after reading the guide. Keep the original and save a copy for your own records. repair-queue-clean.xlsx
Follow the complete first taskUse the included guide and a disposable example copy.
Your first useful session / Start with the example
Record the object as received
Follow this one complete task before entering your own records. Keep the blank original and save a working copy.
Identify the customer
Create a short private customer reference before connecting a received repair job.
Inspect CustomersRecord the item at intake
Link the customer and note the object's condition, reported issue, receipt date and cost cap.
Inspect IntakeDecide the diagnosis
Record the recommendation and explicit approval before entering authorised repair work.
Inspect DiagnosesRecord parts received
Link each part to the job, quantity and unit cost; enter its receipt date only when received.
Inspect PartsLog work and final test
Enter actual work hours, rate and observed test outcome; use a passing row for handover.
Inspect Work LogClose the handover
Link the final passing test and record ready and collected dates as separate events.
Inspect Handover
EVERY WORKSHEET / ACTUAL EXAMPLE FILE
See what you enter.
Understand what updates.
Inspect all 9 sheets. These are images of the delivered example, with fictional records. Open an image to read its full detail.
Actual example worksheet · Preview range A1:E29. Image only; entries are made in your downloaded workbook.
Dashboard
Dashboard: Labelled results and source warnings.
- You enter
- Review linked input records
- Calculated or supplied reference
- Labelled results and source warnings
Actual example worksheet · Preview range A1:D40. Image only; entries are made in your downloaded workbook.
Start
Start: The first task and route through the sheets.
- You enter
- Read the route through the file
- Calculated or supplied reference
- First useful task
Actual example worksheet · Preview range A1:D27. Image only; entries are made in your downloaded workbook.
Settings
Settings: Review date and chosen assumptions.
- You enter
- Review date and assumptions
- Calculated or supplied reference
- Chosen settings
Actual example worksheet · Preview range A1:D14. Image only; entries are made in your downloaded workbook.
Customers
Customers: 100 supplied input rows.
- You enter
- Record ID, Customer reference, Contact reference
- Calculated or supplied reference
- Input check
Actual example worksheet · Preview range A1:K14. Image only; entries are made in your downloaded workbook.
Intake
Intake: 120 supplied input rows.
- You enter
- Record ID, Customer ID, Object / serial, Received on, Condition on arrival, Issue reported, Approved cost cap
- Calculated or supplied reference
- Parts and work cost, Stage, Cost state
Actual example worksheet · Preview range A1:G14. Image only; entries are made in your downloaded workbook.
Diagnoses
Diagnoses: 160 supplied input rows.
- You enter
- Record ID, Intake ID, Diagnosed on, Decision, Quoted amount, Recommendation / scope
- Calculated or supplied reference
- Input check
Actual example worksheet · Preview range A1:H14. Image only; entries are made in your downloaded workbook.
Parts
Parts: 240 supplied input rows.
- You enter
- Record ID, Intake ID, Part / material, Quantity, Unit cost, Received on
- Calculated or supplied reference
- Received cost
Actual example worksheet · Preview range A1:H14. Image only; entries are made in your downloaded workbook.
Work Log
Work Log: 240 supplied input rows.
- You enter
- Record ID, Intake ID, Worked on, Hours, Hourly rate, Test outcome
- Calculated or supplied reference
- Labour cost
Actual example worksheet · Preview range A1:H14. Image only; entries are made in your downloaded workbook.
Handover
Handover: 120 supplied input rows.
- You enter
- Record ID, Intake ID, Final test log ID, Ready on, Collected on, Collected by / reference, Reference / short note
- Calculated or supplied reference
- Input check
Follow the supplied fictional exampleRead the inputs and the result together
From the supplied fictional example
The supplied fictional example
A desk lamp arrives with a worn cord. A 120.00 diagnosis is approved under a 150.00 working cap. A 30.00 cord is received and two hours of labour at 35.00 are logged. A passing final test is referenced before the 11 October ready date; collection is recorded on 12 October. Actual recorded cost is 100.00.
- Approved cap
- 150.00
- Cord part
- 30.00
- Labour
- 2 hours at 35.00
- Collected
- 1 item
- Recorded cost
- 100.00
FOLLOW THE ACTUAL EXAMPLE FILE
The supplied fictional example
Fictional records from the supplied example XLSX. Follow the same references through the sheets, then start your own clean copy.
The records behind the result
Approved cap 150.00
Cord part 30.00
Labour 2 hours at 35.00
A desk lamp arrives with a worn cord. A 120.00 diagnosis is approved under a 150.00 working cap. A 30.00 cord is received and two hours of labour at 35.00 are logged. A passing final test is referenced before the 11 October ready date; collection is recorded on 12 October. Actual recorded cost is 100.00.
- Collected
- 1 item
- Recorded cost
- 100.00
This is an explanation of the downloadable workbook, not an online editor. Its complete clean and worked files are included. Save a working copy. Manual entry, with no automatic sync or external connections.
Inspect the actual worksheetsFrom setup to a regular review
How you use it.
Open the 3-step setup and review routineInputs, calculations and the decision each step supports
- 01
Record the object as received
You enterCreate a customer reference, intake ID, visible condition and reported issue.
CalculatedIntake identifiers connect the item and its initial condition.
Your next stepReview the labelled results and correct source warnings before acting.
- 02
Get a decision before work
You enterAdd one diagnosis and record whether the recommendation was approved.
CalculatedApproved diagnoses do not by themselves mark work as completed.
Your next stepReview the labelled results and correct source warnings before acting.
- 03
Close the handover
You enterLog actual parts and work, reference a passing final test and record ready and collected dates separately.
CalculatedParts, logged work, final test and actual collection remain separately reviewable.
Your next stepReview the labelled results and correct source warnings before acting.
9 sheets. Inspect each one.Inputs, outputs and when to use every worksheet
DashboardOpen sheet details
Editable inputs
- Review linked input records
Calculated or reference
- Labelled results and source warnings
Enter or review these records before relying on the summary.
Inspect the actual Dashboard sheetStartOpen sheet details
Editable inputs
- Read the route through the file
Calculated or reference
- First useful task
Enter or review these records before relying on the summary.
Inspect the actual Start sheetSettingsOpen sheet details
Editable inputs
- Review date and assumptions
Calculated or reference
- Chosen settings
Enter or review these records before relying on the summary.
Inspect the actual Settings sheetCustomersOpen sheet details
Editable inputs
- Record ID, Customer reference, Contact reference
Calculated or reference
- Input check
Enter or review these records before relying on the summary.
Inspect the actual Customers sheetIntakeOpen sheet details
Editable inputs
- Record ID, Customer ID, Object / serial, Received on, Condition on arrival, Issue reported, Approved cost cap
Calculated or reference
- Parts and work cost, Stage, Cost state
Enter or review these records before relying on the summary.
Inspect the actual Intake sheetDiagnosesOpen sheet details
Editable inputs
- Record ID, Intake ID, Diagnosed on, Decision, Quoted amount, Recommendation / scope
Calculated or reference
- Input check
Enter or review these records before relying on the summary.
Inspect the actual Diagnoses sheetPartsOpen sheet details
Editable inputs
- Record ID, Intake ID, Part / material, Quantity, Unit cost, Received on
Calculated or reference
- Received cost
Enter or review these records before relying on the summary.
Inspect the actual Parts sheetWork LogOpen sheet details
Editable inputs
- Record ID, Intake ID, Worked on, Hours, Hourly rate, Test outcome
Calculated or reference
- Labour cost
Enter or review these records before relying on the summary.
Inspect the actual Work Log sheetHandoverOpen sheet details
Editable inputs
- Record ID, Intake ID, Final test log ID, Ready on, Collected on, Collected by / reference, Reference / short note
Calculated or reference
- Input check
Enter or review these records before relying on the summary.
Inspect the actual Handover sheetFiles, capacities and practical limitsRead these before choosing your working copy
The download
Files with a purpose.
START_HERE.pdf
One four-page guide: first session, file index, practical limits, recovery and license.
repair-queue-clean.xlsx
Empty workbook. Save As a working copy before entering records.
repair-queue-example.xlsx
The same workbook with fictional records and checked results.
English instructions, sheet names and field labels.
Before you choose
Fit and practical limits.
- For a small repair workshop
Understand the boundaries.
- Save a working copy. Manual entry, with no automatic sync or external connections.
- Supplied tables have fixed capacities. Extend formulas, tables and validation together before using extra rows.
- Use one currency. Blank means unknown; enter 0 when the amount is known to be zero.
- Resolve the highlighted input rows before relying on the summary.
- Uses exact-mode XMATCH. Requires Excel 2021, Excel 2024 or Microsoft 365; older Excel editions are not supported. Native Excel, Google Sheets and Numbers have not been verified.
- Intake condition and reported issue are records of what was observed or stated, not a diagnosis. Only an explicit approved Diagnosis authorizes work.
- Parts count in the actual cost only when a received date is entered. Work Log hours are actual. A quote is not a charge, paid amount or guarantee.
- Ready and Collected require a linked approved diagnosis, received parts and a referenced passing final test. This is not a safety certification or customer messaging tool.
Excel 2021, Excel 2024 or Microsoft 365 with XMATCH; native compatibility not verified. Local digital-engine tests are separate from native application verification.
Repair Queue & Handover / Version 1.0
Your own working copy.
Clean workbook, separate example and one START_HERE.pdf guide covering setup, practical limits and the internal-use license.
$9.90USD · One-time purchaseVAT included where applicable. Other applicable taxes are shown at checkout.
Desktop spreadsheet software required; it is not included. Native Excel compatibility is still awaiting verification.
Private preview. Purchases are unavailable while the files and delivery are verified.
Questions about this workbook
The details that affect your choice.
Must I connect an account?
No. The workbook uses manually entered records and has no external connection.
Can I add unlimited records?
No. Supplied capacities are listed. Extend formulas, tables and validation together before using additional rows.
Why does the result ask me to review inputs?
Correct the highlighted Input check at its source. Keep a backup before changing IDs, dates or assumptions; do not replace a formula with a typed result.