Monarch forAt a Glance

Extract data from virtually any computer generated report

This is an introduction with critical key words...bla bla

Input to EZ-Pickin's

EZ-Pickin's can extract data from virtually any computer generated report, including complex reports with headers, footers and multiple sort levels. It automatically recognizes different data types so date fields and numeric fields are properly maintained in appropriate formats.

EZ-Pickin's reads report files sent from any AS/400 - iSeries - i5, mainframe, client/server or PC system.

Data Extraction

At the heart of EZ-Pickin's is a powerful data extraction engine that can pull data out of virtually any report, from simple columnar reports to complex reports with headers, footers and multiple sort levels. You define a data extraction template to identify desired data elements. Templates can be saved and reused any time a periodic report is run.

User Interface

EZ-Pickin's offers four views of report data:

1. A 'softcopy' of the original report is displayed in EZ-Pickin's report window
2. Data extracted from the report is displayed in the table window
3. User defined summaries which analyze report data are displayed in the summary window
4. Dynamic charts linked to summary reports are also displayed

Data Processing and Analysis

EZ-Pickin's provides a range of features to help you manipulate and analyze the data extracted from reports. You can create calculated fields using and extensive library of numeric, logical and string functions. You can define filters to boil down the data, sort the data on one or more keys and create new reports with data extracted from the original report. You can drill down through summary data to reveal successive layers of detail and create charts that change dynamically as you explore the data.

Create and run saved templates/models over reports to automatically extract and export data directly into any of 100's of Windows applications (e.g. Excel, Access, MS-Word, Lotus 1-2-3... ) without rekeying! Even send reports, graphs... via E-mail, Internet, Intranet, Lotus Notes.... Using EZ-Pickin's also saves you 6¢ for every page you don't print!

Download the products for your own tests or ask for your FREE CD of EZ-Pickin's, Spool-Explorer/400 and Catapult with demos, manuals, Power Point presentations and much more.