|
 |
        |
|
INDIVIDUAL PRODUCTS:
PRODUCT COLLECTIONS: |
The Report To Data Assistant is an add-in for Microsoft Excel. It is designed to help you convert text reports into Microsoft Excel worksheet databases. For example, if your report looks like the following:
You would be faced with deleting the title rows that repeat every 60-80 lines and all the blank lines. With the Report to Data Assistant you can easily select the title rows and blank rows and delete them. Then you can use the data filter features of Excel or the pivot table features to analyze the data. The Report to Data Assistant can also help you extract rows from a file. When the above report is parsed into Excel the sales data ends up in column C. With the Report to Data Assistant you can select all rows with numeric entries in column C. Then you would copy these rows and paste on a new worksheet. The main menu of the Report to Data Assistant looks like this:
A selection criteria worksheet allows you to store the row selection criteria. The following illustrates such a worksheet:
Row 3 illustrates three conditions that must be met for the the row to be included in the selection list per that test. Rows 4 and 5 illustrate simpler tests. The following are the many tests that you can use:
When the selection process is done the matching rows are selected. You can copy them to another worksheet via Edit Copy. You can delete them via Edit Delete. If you want to examine them you can color code them for ease of inspection. Then run the selection again to re-select the rows. The Report To Data Assistant also has options that allow you to combine multiple rows onto one row and to concatenate multiple cell entries.
| |
| Copyright 2008 Add-ins.com LLC, all rights reserved. Spreadsheet Assistant is a registered trademark of Add-ins.com LLC. Microsoft and Excel are trademarks or registered trademarks of Microsoft Corporation. |
