Difference between revisions of "Volume targets.xls"

From Vital Soft Wiki
Jump to: navigation, search
>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
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
'''The Volume Target spreadsheet defines volume targets for individual branches for specific dates'''
+
== 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 ==
  
 
'''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 21:
  
 
'''YEAR'''
 
'''YEAR'''
 +
    The CCYY year for the defined Branch entry
  
 
'''BRANCH'''
 
'''BRANCH'''
 +
    The Branch number
  
 
'''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

Latest revision as of 21:28, 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 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