6 steps to using EPS in MRDCL to gain an advantage
EPS stands for Excel Productivity Scripting. It’s…Read more
MRDCL has a good range of tools to check your data. Errors can be output to text files or Excel reports displaying any data you choose.
For example, you might want to check that the sum of 4 figures totals 100%. All you would have to do is to specify a figure that adds the 4 figures together and displays the data with a message, if you wish, so that the data can be checked or amended.
Some of the common checks that you can make using MRDCL are:
Data can also be corrected within MRDCL. We recommended the raw data is not physically changed at all, but that all data is changed within MRDCL so that there is an audit trail for your data. Correcting the data in Excel spreadsheet is a recommended approach.