Difference between revisions of "Volume targets.xls"
>Jeremyb |
>Jeremyb |
||
| Line 1: | Line 1: | ||
| − | '''The Volume Target spreadsheet defines volume targets for individual | + | == Overview == |
| + | '''The Volume Target spreadsheet defines volume targets for past years/months for individual Branches''' | ||
| + | |||
| + | '''The spreadsheet contains 3 sheets, Volume, Branch and Month''' | ||
| + | |||
== Volume Sheet == | == Volume Sheet == | ||
Revision as of 21:23, 31 August 2012
Overview
The Volume Target spreadsheet defines volume targets for past years/months for individual Branches
The spreadsheet contains 3 sheets, Volume, Branch and Month
Volume Sheet
YEAR
The year for the Gross amount entry
SHARE_VOLUME
The Gross amount for Shares
LOAN_VOLUME
The Gross amount for Loans
Branch Sheet
YEAR
The CCYY year for the defined Branch entry
BRANCH
The name of the Branch
SHARES_PCT
The percent of shares out of the total shares
LOAN_PCT
The percent of loans out of the total loans
Month Sheet
YEAR
The CCYY year of the entry
MONTH
The MM month of the entry
SHARE_PCT
The Percent of total Shares for the year this month
LOAN_PCT
The Percent of total Loans for the year this month
