This illustrates an example on how to use EasyCal’s excel mapping option to manipulate data collected using the EasyCal suite. The key areas include: use of standard procedure(s) to write a procedure on EasyCal; preparation Excel template (tabulation and metrological evaluations such as error, uncertainties etc.). Example of procedures used in calibration of pressure equipment include Guide 13, DKD-R 6-1, SAC-SINGLAS Guide 1 etc. Note that the way of writing procedure on EasyCal in this paper is done as normally done and we are mainly interested on Excel Mapping. The illustration on this paper uses MSL Guide 13 (http://msl.irl.cri.nz).
Meaning of Excel Cell Mapping
Excel mapping is an option provided on Easy Cal suite to enables the software map/post/place collected data on a chosen Excel template for any desired manipulation such as tabulation and mathematical evaluations.
Step 1: Choose a procedure
Use a standard paper/procedure to understand the nature of data of data you want to collect. This enable you understand the number of runs/cycles to perform in a calibration; whether Up/Down, Up/Down+105% or Up mode; also provide the model for uncertainty evaluation. Besides, it help one to develop an Excel Template.
In this illustration, I am doing pressure equipment calibration, so I choose MSL Guide 13 will be used.
From MSL Guide 13, I will perform:
- Two cycles/ runs;
- Up/Down mode
- Uncertainty
Step 2: Prepare Excel template.
This include the table where the data will be mapped with various formulae that will operate on the data collected. Save your template as xls on Excel folder found on EC6 folder:
