# Do you know, using excel sheets for calibration costs you at least an additional \$1300 per technician annually?

#### How could that be true? Spreadsheets cost a  lot less compared to buying a feature-packed calibration management software like Metquay right?

Well, that may not be the case!

Let’s do a  ballpark calculation based on some assumptions.

The per annum salary of an entry-level calibration technician in the United States is \$50,000 ( as per glass door), hourly wages is roughly \$22 per hour ( payscale.com).

Let’s assume Metquay saves your technician 15 minutes a day ( just a wild assumption)

Projected savings per calibration technician/license of Metquay in US\$
Wage per hour Time saved per day
(minutes)
Cost saved per day
(8 hours)
Cost saved per month
(20 days)
Cost saved across a year (12 Months)
USD 2215USD 5.5USD 110.00USD 1,320.00

\$1,320 per technician? multiply it with the total number of technicians in your lab, WOW! that’s an awful lot of money!!!

Hold on, the whole calculation is based on the assumption that you save at least 15 minutes per technician a day, What if you don’t save that much?

Well! it could be either way right? what if it’s much higher than the 15 minutes we assumed?

We may not be able to prove that it’s exactly 15 minutes, however, it would be possible to see if it’s significantly lower or higher than our initial assumption if we do a thorough comparison.

### Metquay Vs Excel Sheets for Uncertainty Calculation & Reporting

Out of the serval, documents owned/used by you as calibration lab manager/quality manager/calibration technician, the spreadsheets used for calibration data capture/calculating measurement uncertainties/reporting are the most critical ones which have a direct impact on your productivity.

You spend a larger chunk of your quality time documenting and validating the formulae, managing version control, change history etc. and as time progresses, these spreadsheets grow in numbers and it eats up more and more of your time.

The thumb rule to survive and to stay competitive in today’s world is to spend a great share of your productive time on core innovations and let automation tools take care of the mundane tasks.

Here is a study to help you understand how Metquay outperforms spreadsheets while used in a commercial calibration lab thereby saving valuable time and money which could be invested in core-innovations to boost your calibration business.

For the ease of comparison let’s separate our concerns under five different categories.

1. Security & Access Restriction
2. Auditing & Traceability
3. Consistency of Results
5. Calibration Reports

#### Security & Access Restriction

Restrict access using fine permissions and user groups consistently across the entire organisation. Only document level password protection. May not be consistent across the entire organisation.
Restricts work assignments to trained personal using competency matrix Not available
Restricts report approvals to specific approvers based on procedures used.Not available
Multilevel authentication for report approval Not available

#### Auditing and Traceability

Entire data is stored in a single search enabled database ( Single source of truth)Data is spread across disparate spreadsheets
Each and every action is logged ( user details, old value-new value, date-time)No audit logs
Inbuilt revision workflow for every entity including Calibration Standards, Works, Certificates etc. Access to older revisions for reference and trend analysisNo revision workflow, manual revision management required.
Forward and backward traceability [ find the standards used to calibrate an instrument and vice versa in a single button click]Manually go through each and every document to find out the traceability information

#### Consistency of results

Each time a validated worksheet is modified the approvers are alerted to verify and approve the changes before it could be used again.Manually track the changes & send it for approval each time a sheet is modified. Cannot restrict a sheet from being used without approval.
Prevents the technician from using standards which are out of calibrationNo means to restrict usage of a standard which is past its calibration due date
Pulls latest calibration data from the standards and the sheet automatically adjusts itself to the new values by applying unit conversions, error, drift etc.Update values and manually validate each time before using them to ensure the latest values are used. Error-prone
One-click comparison of last calibrated data with the current values Do manual comparison
Configurations to enable maximum re-use of calibration sheets Keep different copies of spreadsheets for different configurations

Receive alerts on calibration standards nearing calibration due date/verification due dateNot available
Prevent user from using a calibration standard which is past its due dateNot available
Alerts for Approval / Review of Reports, documents, Procedures etcNot available
Regular auto backup of data to specified locations Not available
KANBAN BOARD to display the overall status of jobs Not available

#### Calibration Reports / Test Reports

Auto-generate calibration reports from the datasheet Copy data to word templates manually to generate a certificate
Auto-select templates based on equipment type, accreditation etcSelect templates manually. Prone to human error.
Apply electronic signatures in compliance with FDA 21 CFR PART 11No electronic signatures. Do manual checks each time to ensure compliance