Difference between revisions of "Volume targets.xls"
>Jeremyb (Created page with "'''The Volume Target spreadsheet defines volume targets for individual branches for specific dates''' == Volume Sheet == '''YEAR''' '''SHARE_VOLUME''' '''LOAN_VOLUME''' ...") |
>Jeremyb |
||
| Line 4: | Line 4: | ||
'''YEAR''' | '''YEAR''' | ||
| + | The year for the Gross amount entry | ||
'''SHARE_VOLUME''' | '''SHARE_VOLUME''' | ||
| + | The Gross amount for Shares | ||
'''LOAN_VOLUME''' | '''LOAN_VOLUME''' | ||
| + | The Gross amount for Loans | ||
| Line 13: | Line 16: | ||
'''YEAR''' | '''YEAR''' | ||
| + | The CCYY year for the defined Branch entry | ||
'''BRANCH''' | '''BRANCH''' | ||
| + | The name of the Branch | ||
'''SHARES_PCT''' | '''SHARES_PCT''' | ||
| + | The percent of shares out of the total shares | ||
'''LOAN_PCT''' | '''LOAN_PCT''' | ||
| + | The percent of loans out of the total loans | ||
== Month Sheet == | == Month Sheet == | ||
| − | '''YEAR MONTH''' | + | '''YEAR''' |
| + | The CCYY year of the entry | ||
| + | |||
| + | '''MONTH''' | ||
| + | The MM month of the entry | ||
'''SHARE_PCT''' | '''SHARE_PCT''' | ||
| + | The Percent of total Shares for the year this month | ||
'''LOAN_PCT''' | '''LOAN_PCT''' | ||
| + | The Percent of total Loans for the year this month | ||
Revision as of 21:21, 31 August 2012
The Volume Target spreadsheet defines volume targets for individual branches for specific dates
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
