N3S

← All cases// Systems & integrations · Web apps

Electrical installation tracking without spreadsheets

A system for an electrical installation company: documentation, installation, rotational shifts, warehouse and installers' pay in one place, with an installer portal on the phone.

work orders a month went through with no office involvement
893
installers work in the system
51
log in to their portal every month
47

// Client

An electrical installation company with installers on site and a rotational shift schedule.

// Before

Work was run in a dozen spreadsheets: shifts, tickets, warehouse, workwear, the as-built documentation register, payroll. Pay was calculated by hand, and an extra or missing ticket only surfaced on the day of the flight.

// What we built

A system that mirrors the client's processes, with no extra buttons:

  1. 01registers of as-built documentation, fixture installation and acceptance, shifts and tickets, warehouse, workwear, installers' pay;
  2. 02pay is calculated automatically from accepted fixtures, and bonuses for extra work come from points set by the engineering staff, under the client's own rules;
  3. 03tickets from SmartWay are matched against shifts in advance;
  4. 04workwear is ordered by actual sizes and grouped by supplier; issuing and audits go through the installer portal;
  5. 05the warehouse runs on data collection terminals; negative stock is highlighted and the people responsible are notified;
  6. 06every installer has a portal on the phone: completed-work requests, accruals, tickets, documents, requests from the office;
  7. 07access rights are set by section and role.

Process map

  1. 01

    The installer submits work in the portal

  2. 02

    The engineer accepts it

  3. 03

    Pay and bonus are calculated automatically

  4. 04

    The accrual shows up in the portal

// Screens

Project list: each site has a code, contract number and term, and completion status. A summary on top shows how many contracts are completed, in progress or missing.

01 / 05

// Integrations

  • Bitrix24
  • SmartWay
  • Kontur.KEDO
  • Data collection terminals
SmartWay
tickets are matched against shifts in advance
Data collection terminals
warehouse: negative stock is highlighted and the people responsible are notified

// Results

MetricValue
Installers in the system51
Log in to the portal monthly47
Work orders with no office involvement893 a month

Similar challenge?

Installation crews, shifts and a dozen spreadsheets? We'll review your process for free.

Review my process→