Leaders in Innovative Research Solutions

Using Excel within MRDCL

Using Excel within MRDCL

One of the key features of MRDCL is that you develop templates in Excel that can be used to de-skill and automate various repetitive tasks. The technique is called Excel Productivity Scripting or EPS. An overview of EPS can be downloaded (!!!!!!!!!!!!!LINK TO PDF DOCUMENT ON WEBSITE!!!!!!!!!!). A fuller description of EPS with working examples can be downloaded as well. (!!!!!!!!!!!!!LINK TO PDF DOCUMENT ON WEBSITE!!!!!!!!!!)

EPS can be used in many circumstances. There are some good examples in the downloadable documents above, but one practical example is the handling of code lists where sub-totals (or nets) are required. You can design a standard way of storing code lists in Excel (or Access) with a standard notation for specifying sub-totals that are required. Then, a standard MRDCL script can be used to read the worksheet and process the variable and tables for you.

For example, the worksheet below could be used to store a code list and the sub-total that each code is assigned to. A standard MRDCL script is used, which reads the worksheet and produces the table. If a change is needed, all that the user has to do is change the worksheet.