|Oracle financial Analyzer User's Guide
Part No. A87522-01
Express Spreadsheet Add-In , 5 of 7
This section describes the Financial Analyzer data collection toolkit for use with Microsoft Excel. This toolkit enables you to create a simple lightweight data entry mechanism for infrequent users of Financial Analyzer.
In order to use the data collection toolkit, a user must have a thin client setup. A thick client cannot make the required connection.
The Excel Data Collection toolkit is made up of the following components:
A sample produced using the toolkit is provided. The sample is composed of the following files:
SAMPLE.XLS -- An Excel workbook containing a sample data collection worksheet and a macro module containing routines to control functionality.
SAMPLE.INF -- A text file containing Express programs for recalculating and submitting spreadsheet data. The programs can be incorporated in a Financial Analyzer custom database using the Express INFILE command.
These two files are located in the DOC\ADD_IN folder on the Oracle Financial Analyzer CD-ROM.
Using this toolkit sample, users can collect data using the following procedure.