About the Client

Hariom Electronics tracks work quality using a Google Sheet where supervisors record every error made by users.

Each entry includes the error type, timestamp, and the name of the user responsible. As operations expanded, the company needed these errors to influence performance scoring automatically, without manual calculations.

The Problem Hariom Electronics Needed to Solve

Although errors were accurately captured in the Google Sheet, they did not impact user weekly MIS scores within MIDAP, creating a disconnect between actual performance and reported performance.

The team wanted a seamless mechanism where:

• Errors logged in the Google Sheet would be read automatically
  
• Each error would reduce the user’s weekly MIS score by –100 points
  
• Total deductions should be calculated and applied without human involvement
  

Example of Required Logic

If a user recorded 7 errors in the sheet, the system should compute:
7 × –100 = –700 points

This level of automated scoring was not available in MIDAP by default, so a custom solution was essential.

Building a Custom, Sheet-Driven Scoring Integration

Our development team designed a specialized automation layer that directly connects MIDAP with Hariom Electronics’ error-tracking sheet.

How the Integration Works

The system now performs the following steps continuously and accurately:

1. Connects to the Existing Google Sheet

No change was required from the client’s side — the same sheet continues to serve as the source of truth.

2. Reads and Organizes Error Data

Entries are grouped by username so each user’s total error count can be processed automatically.

3. Applies the Deduction Formula

The system multiplies the number of errors by –100 exactly as specified by Hariom Electronics.

4. Updates the User’s Weekly MIS Score

The final deduction is pushed directly into MIDAP, ensuring real-time score accuracy.

This eliminates manual recalculation, avoids human mistakes, and ensures that every error — regardless of when it was logged — is reflected instantly in the user’s weekly MIS score.

The Impact on Operations

With this integration in place, Hariom Electronics gains:

• Accurate, error-driven scoring aligned with their internal evaluation policy
  
• Fully automated deductions without manual entry or oversight
  
• Improved accountability as users know that every error directly affects performance
  
• A consistent scoring framework that reduces disputes and encourages better quality work
  

The entire scoring workflow now runs end-to-end without human intervention, creating a transparent and disciplined performance environment.

A Simple Input, A Powerful Output

What started as a standard Google Sheet has now become an automated scoring engine. Hariom Electronics can continue using their familiar tracking method while MIDAP does the heavy lifting behind the scenes — connecting, calculating, and updating scores flawlessly.