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 |
|Cost saved per day|
|Cost saved per month|
|Cost saved across a year (12 Months)|
|USD 22||15||USD 5.5||USD 110.00||USD 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.
Are you ready? Let’s go!
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.
- Security & Access Restriction
- Auditing & Traceability
- Consistency of Results
- Proactive Alerts
- 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 analysis||No 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 calibration||No 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|
Proactive Alerts / Checks
|Receive alerts on calibration standards nearing calibration due date/verification due date||Not available|
|Receive alerts on customer equipment nearing due date||Not available|
|Prevent user from using a calibration standard which is past its due date||Not available|
|Alerts for Approval / Review of Reports, documents, Procedures etc||Not 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 etc||Select templates manually. Prone to human error.|
|Apply electronic signatures in compliance with FDA 21 CFR PART 11||No electronic signatures. Do manual checks each time to ensure compliance|
|Alert certificate approvers||No alerts|
|Auto-generate calibration stickers||Generate stickers manually|
|Generate Graphs and charts automatically from calibration data||Manually copy generate the graphs from spreadsheets|
It would be fairly obvious to anyone who looks at the comparison tables that the time saved per technician when you use Metquay would be several multiples of the ’15 minutes’ we assumed initially, right?
For product videos, please watch our YouTube channel