Monarch forV10.5 New Features

Monarch for EZ-Pickin's V10.5 Adds an Entirely New Dimension of Compliance, Auditing and Reconciliation Capabilities to the best Report Mining & Analysis Tool

Managers, auditors and compliance personnel all need easier, better ways to answer the common questions around spreadsheets: Where does the data come from? Is the data accurate? Has it been tampered with? How can it easily be audited? EZ-Pickin's V10.5 fills those needs.

BCD's customers use EZ-Pickin's technology every day to quickly, easily and non-programmatically convert their corporate information (usually reports) into Excel spreadsheets.

With V10.5, BCD helps organizations meet the increasing need to understand the data lineage of their XLS spreadsheets for the purposes of compliance, auditing, reconciliation and just plain accuracy.

Explore the wide range of new and improved features of Monarch for EZ-Pickin's V10.5 and EZ-Pickin's Pro V10.5. Call (630) 986-0800 to upgrade today. View the different features at each version in the EZ-Pickin's Comparison Table.

Excel Compliance and Reporting Made Easy

New EZ-Pickin's V10.5 gives users the ability to include a full-fidelity XML representation of the original source report with any Excel file (XLSX/XLSM) created from that report. In other words, the source data for the Excel file travels with the Excel file—making it easy to compare and reconcile the spreadsheet and its source.

EZ-Pickin's now becomes an even more valuable tool for providing useful reporting throughout the organization. Corporate information can be delivered in the format users want (Excel) along with the original report source(s) for viewing, compliance and auditing—free from programming, database work or altering any current system output.

Excel Users Can See the Original Report Data

In addition, EZ-Pickin's developed EZ-Pickin's Context™, a free, downloadable Add-in for Excel which can be used to sync the data in the Excel spreadsheet back to the source report and visually display the source report for the Excel user. Monarch Context offers a similar experience to the Monarch Report View, providing the ability to view, explore, find, copy and paste, and print the source report all from within Excel.

Now the source data for an Excel file can travel with the Excel file—making it easy for users to compare their spreadsheet data with the source data as well as view the context in which it was originally reported.

Digital Signatures for Enhanced Data Integrity

With EZ-Pickin's V10.5, users have the option to embed a digital signature within any Excel file export, ensuring data integrity for Excel files which only need to be viewed and/or archived. Users can digitally sign a standalone Excel file, as well as an Excel file and source report combination. Digital signatures confirm data lineage and give the recipient the confidence that the message was created by a known sender and was not altered in transit. Auditing is also improved because a valid digital signature demonstrates the authenticity of the document.

Adding a digital signature and/or adding the source report to an Excel 2007 XLSX or XLSM file is as simple as checking a box during the data export process within Monarch V10.5.

XML is Key to the Export Process

During the Excel export process, EZ-Pickin's will export a full-fidelity XML representation of the report, with additional metadata in the Open XML package (XLSX file) and in the row data to allow vectoring to cells in the report from rows in the worksheet or worksheets. The functionality is available when exporting from the table view to XLSX and XLSM files. The ability to add the source report data is only available when creating new Excel files or overwriting existing files, not when appending to existing sheets, or adding/replacing sheets.

Adding source report files will generally NOT generate large Excel files. The reason is that Excel ‘packages’ created with Excel 2007 benefit from ZIP compression, which works particularly well on reports as they contain a great deal of white space.

Building Auto-Define Report Trapping

Getting started on defining a trap is dramatically simplified. Check off sample lines from the report for which you want to build a template. Monarch V10 will generate a trap based on the common features of the report lines selected.

Color Coding for Template Types

Color-Coded Templates help expedite model building. Choose a custom background color for each template type.

<< Back to EZ-Pickin's Features Main Page