| Import XPS Files |
• |
|
|
|
|
|
|
|
|
| Table Verify (round diff, data convert errors, numeric out-of-bounds, text truncate, date format, field length |
• |
|
|
|
|
|
|
|
|
| Import Excel 2007 XLSM files |
• |
|
|
|
|
|
|
|
|
| Import Access 2007 (ACCDB) files |
• |
|
|
|
|
|
|
|
|
| Ability to include the source data when exporting Tables to Excel (XLSX/XLSM) |
• |
|
|
|
|
|
|
|
|
| Support for Digital Signatures in Excel (XLSX/XLSM) |
• |
|
|
|
|
|
|
|
|
| Auto-Define Trap Feature |
• |
|
|
|
|
|
|
|
|
| Color Coding for Template Types |
• |
|
|
|
|
|
|
|
|
| Clear Field Values Option |
• |
|
|
|
|
|
|
|
|
| Advanced Field Capabilities for Floating Traps |
• |
|
|
|
|
|
|
|
|
| Bookmark Comments (will export to PDF if using Monarch PRO) |
• |
|
|
|
|
|
|
|
|
| Ability to Shift Only the Selected Object - When using the Shift Templates feature |
• |
|
|
|
|
|
|
|
|
| Value-based filters (create filters by picking values from a list) |
• |
|
|
|
|
|
|
|
|
| Export Data to Pivot Tables - When performing a table export to an xlsx file |
• |
|
|
|
|
|
|
|
|
| 14 New Date Functions |
• |
|
|
|
|
|
|
|
|
| Improved Advanced filter duplicate handling - options are now sensitive to the active sort |
• |
|
|
|
|
|
|
|
|
| Export Summary Data Based on a Key Value Change |
• |
|
|
|
|
|
|
|
|
| Display Multiple Measures in Across Key Summaries |
• |
|
|
|
|
|
|
|
|
| Summarize Data by Time Intervals |
• |
|
|
|
|
|
|
|
|
| Embed Page Headers in Excel Worksheets |
• |
|
|
|
|
|
|
|
|
| Choose standard or custom colors when specifying summary coloring |
• |
|
|
|
|
|
|
|
|
| Apply subtotal and grand total coloring across the summary to all measures |
• |
|
|
|
|
|
|
|
|
| Suppress Accumulated Unmatched Values in summaries |
• |
|
|
|
|
|
|
|
|
| Hide the Across Total Column feature in a summary |
• |
|
|
|
|
|
|
|
|
| Time Intervals feature (13 time intervals make it easy to define the fiscal year) |
• |
|
|
|
|
|
|
|
|
| Link to External Models |
• |
• |
|
|
|
|
|
|
|
| Import Using OLE DB |
• |
• |
|
|
|
|
|
|
|
| Import OpenXML Spreadsheets |
• |
• |
|
|
|
|
|
|
|
| Open Excel and file-based databases directly from Sharepoint |
• |
• |
|
|
|
|
|
|
|
| Enhanced Database Filters (22 functions) |
• |
• |
|
|
|
|
|
|
|
| PDF Improvements (Bookmarks, Password Protect) |
• |
• |
• |
|
|
|
|
|
|
| New Excel Export Engine (5x faster) |
• |
• |
• |
|
|
|
|
|
|
| Export to OpenXML Spreadsheet (xlsx) |
• |
• |
• |
|
|
|
|
|
|
| Sharepoint Support |
• |
• |
• |
|
|
|
|
|
|
| Not Traps |
• |
• |
• |
|
|
|
|
|
|
| User-Defined Functions |
• |
• |
• |
|
|
|
|
|
|
| Opening of Models without Data Sources |
• |
• |
• |
|
|
|
|
|
|
| Calendar Control for Inserting Dates |
• |
• |
• |
|
|
|
|
|
|
| Quick Summary Design |
• |
• |
• |
|
|
|
|
|
|
| Excel Subtotals and Grand Totals as formulas |
• |
• |
• |
|
|
|
|
|
|
| Excel Conditional Formatting Rules |
• |
• |
• |
|
|
|
|
|
|
| Import and analyze PDF files |
• |
• |
|
• |
|
|
|
|
|
| PDF as export option |
• |
• |
|
• |
|
|
|
|
|
| Import data from database files (ODBC - SQL Server, Oracle, more) |
• |
• |
|
• |
|
|
|
|
|
| Save Passwords for PDF and database file access |
• |
• |
|
• |
|
|
|
|
|
| Monarch for EZ-Pickin's Features (continued) |
10.5
(Pro) |
9
(Pro) |
9 |
8
(Pro) |
8 |
7 |
6 |
5 |
4 |
| Mine data from HTML files
|
• |
• |
|
• |
|
|
|
|
|
| Preview Data to be Imported from Databases |
• |
• |
|
• |
|
|
|
|
|
| Natively read CSV files as databases |
• |
• |
|
• |
|
|
|
|
|
| Report Tree View |
• |
• |
• |
• |
• |
|
|
|
|
| Multiple Footers |
• |
• |
• |
• |
• |
|
|
|
|
| Shift Template sleft or right |
• |
• |
• |
• |
• |
|
|
|
|
| Jump from Report or Summary to Table |
• |
• |
• |
• |
• |
|
|
|
|
| 6 new calculated fields |
• |
• |
• |
• |
• |
|
|
|
|
| User-Edited fields |
• |
• |
• |
• |
• |
|
|
|
|
| Compound Filters |
• |
• |
• |
• |
• |
|
|
|
|
| Audit Trail |
• |
• |
• |
• |
• |
|
|
|
|
| Quick filter and Sort Creation |
• |
• |
• |
• |
• |
|
|
|
|
| Maximum data capacity has doubled |
• |
• |
• |
• |
• |
• |
|
|
|
| Export filters and/or summaries to Excel, Access |
• |
• |
• |
• |
• |
• |
|
|
|
| 18 new or improved calculated field functions including Julian dates |
• |
• |
• |
• |
• |
• |
|
|
|
| Duplicate value filter |
• |
• |
• |
• |
• |
• |
|
|
|
| Improved Report view with auto preview |
• |
• |
• |
• |
• |
• |
|
|
|
| New Summary Measures (count percent of total and subtotal) |
• |
• |
• |
• |
• |
• |
|
|
|
| Capture data in multi column reports |
• |
• |
• |
• |
• |
• |
|
|
|
| View all Model and Project information view |
• |
• |
• |
• |
• |
• |
|
|
|
| Export as HTML and XML-SS format |
• |
• |
• |
• |
• |
• |
• |
|
|
| Floating Trap |
• |
• |
• |
• |
• |
• |
• |
|
|
| Address Blocks Wizard |
• |
• |
• |
• |
• |
• |
• |
|
|
| Runtime End User Prompt for Input Parameters |
• |
• |
• |
• |
• |
• |
• |
|
|
| Lookup Fields |
• |
• |
• |
• |
• |
• |
• |
|
|
| Summary Exception Coloring |
• |
• |
• |
• |
• |
• |
• |
|
|
| Summary Formatting (background and text colors) |
• |
• |
• |
• |
• |
• |
• |
|
|
| Export all summaries option |
• |
• |
• |
• |
• |
• |
• |
|
|
| Chart formatting options (changing colors, fonts) |
• |
• |
• |
• |
• |
• |
• |
|
|
| Improved Summary and Analysis (filters for summaries, top-n) |
• |
• |
• |
• |
• |
• |
• |
• |
|
| Improved Data manipulation (calcs and conversions of date/time) |
• |
• |
• |
• |
• |
• |
• |
• |
|
| Friendly User Interface (newfield list dialogue) |
• |
• |
• |
• |
• |
• |
• |
• |
|
| Faster Summary Performance |
• |
• |
• |
• |
• |
• |
• |
• |
|
| Improved Exporting & Printing (column widths are retained) |
• |
• |
• |
• |
• |
• |
• |
• |
|
| Import & analyze data from virtually any computer generated text report |
• |
• |
• |
• |
• |
• |
• |
• |
• |
| Import System i spool files (use Catapult or Spool-Explorer to convert to text) |
• |
• |
• |
• |
• |
• |
• |
• |
• |
| Reusable Templates & Models for Data extraction |
• |
• |
• |
• |
• |
• |
• |
• |
• |
| Report View with Green Bar Option |
• |
• |
• |
• |
• |
• |
• |
• |
• |
| Table View with Extracted Data |
• |
• |
• |
• |
• |
• |
• |
• |
• |
| User Defined Summaries |
• |
• |
• |
• |
• |
• |
• |
• |
• |
| Dynamic Charts |
• |
• |
• |
• |
• |
• |
• |
• |
• |
| Combined View |
• |
• |
• |
• |
• |
• |
• |
• |
• |
| Record Selection Filters |
• |
• |
• |
• |
• |
• |
• |
• |
• |
| Calculated Fields |
• |
• |
• |
• |
• |
• |
• |
• |
• |
| Data Sorting |
• |
• |
• |
• |
• |
• |
• |
• |
• |
| Query Data |
• |
• |
• |
• |
• |
• |
• |
• |
• |
| Drill up or down |
• |
• |
• |
• |
• |
• |
• |
• |
• |
| Export to Excel, Access, MS-Word, Lotus |
• |
• |
• |
• |
• |
• |
• |
• |
• |
| Printing & Copying |
• |
• |
• |
• |
• |
• |
• |
• |
• |
| Monarch for EZ-Pickin's Features |
10.5
(Pro) |
9
(Pro) |
9 |
8
(Pro) |
8 |
7 |
6 |
5 |
4 |
