|
The programmable spreadsheet is ideal for extracting, consolidating and summarizing data from up to 200 other programmable spreadsheets and Excel files. A spreadsheet could show the financial position of a company. Several layers of spreadsheets would result in a fairly complex financial model that can be built either quickly or incrementally and modified at anytime. The spreadsheet consists of 145 cells, 100 labels and 10 list boxes that link to up to 10 other files. Here is a sample, configured to look like a comparative income statement. Data is extracted from other files and [Compute] calculates Net Profit.
The spreadsheet, customized into a more traditional format.
Each cell is programmable, may be placed anywhere on the screen, assigned different colors and fonts. Like the data entry program, the screen objects are customizable.
This sample is about actual and forecasted sales. [Special] command includes more functions:
1. [Batch editor], as in data entry program. 2. [Charts] converts the cells into bar charts. 3. [Extract data] extracts data from other programmable spreadsheets, and csv and Excel files. After data is extracted, [Compute] command may be used to carry out additional calculations before the record is [Created] or [Modified]. Both [Create] and [Modified] may also include specific instructions. In the example, green cells are added and pink cells subtracted. Light blue cells are variances. An image of the spreadsheet is used for creating formulas. As a cell is selected, it is highlighted and the formula is shown at the bottom. The formula is automatically converted into program instructions that are executed when the [Compute] command is clicked.
Aside from formulas, you can process the cells using specific instructions (point-and-click interface). Instructions include: Add days to a date, add amount to a balance in another file, add, multiply, subtract, divide, get elapsed days, read, delete, write records, check if record exists, if not amount then go to..., if blank then go to..., data must between value-1 and value-2... GenRe has its own set of over a hundred powerful programming instructions. |
