Volume targets.xls

From Vital Soft Wiki
Revision as of 21:28, 31 August 2012 by >Jeremyb
Jump to: navigation, search

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 Branch number

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