Case study

Automating Work-Order Processing for an Electrical Contractor

A custom web application that reads scanned work orders, fills in the forms and calculates cabling charges against the client’s rate list.

Client
Singapore Electrical Contractor
Industry
Electrical engineering and infrastructure services
The application’s upload screen, with job details and a drop zone for work orders and other documents
The upload screen: job details and the work-order upload

What they needed

The client needed to digitise the processing of scanned electrical work orders.

Their workflow involved transferring information from each work order into forms, then calculating cabling charges against an existing rate list. Those repetitive steps were the focus of the project.

What we built

We built a custom web application that combines three steps:

  • OCR to extract information from scanned work orders.
  • Automatic population of the relevant form fields.
  • Rules-based cabling price calculations using the client’s rate list.

Document extraction, form preparation and pricing calculations now run in one workflow.

Illustration: a sample work order beside the details extracted from it
Illustration with sample data: details read from a work order
Illustration: job details filled in automatically, and cabling charges calculated from a rate list
Illustration with sample data and sample rates: form filled in and cabling charges calculated

What it does now

The parts of the workflow that used to need manual transcription and calculation are now automated: reading the scanned work order, filling in the form and working out the cabling charges against the rate list.

Still retyping information from work orders or calculating charges manually?

Talk to retroXpect about automating your document and pricing workflow.