Overview

Top Previous Next

To demonstrate the use of the report generator, we are going to setup and construct a Key Ratio Variance report. The report will calculate a selected number of ratios and display results for our current capture period, the selected budget set, as well as the same period last year. Variance will be produced against the current column. The report will show MTD summaries. Due to the constraints in showing an 11 column report, our sample report will show the first 6 columns.

In preparation for writing the report, we created a mock report with all the calculations as well as sample data in a spread sheet. We will demonstrate the Key Ratio - Loans to Deposits.

During the preparation of the spread sheet, we thought through the following process:

1.	What data was required in the ratio calculation - RANGE

2.	What constants will be used in the calculation - CONSTANTS

3.	What items required separate calculations - CALCULATIONS

4.	What calculation is needed between cells in the report template - CELL CALCULATIONS

5.	Some areas of the report will only require different time periods - COLUMN OVERRIDE

We established the following keys and color coded our spread sheet accordingly.

1.	Range - Green

2.	Constant - Pink

3.	Calculation - Yellow

4.	Cell Calculation - Orange

5.	Column Override - Blue