Difference between revisions of "Vs branch info.xls"

From Vital Soft Wiki
Jump to: navigation, search
Line 27: Line 27:
 
'''VS_BR_PROD_RANGE'''
 
'''VS_BR_PROD_RANGE'''
 
     The branch productivity range
 
     The branch productivity range
 +
 +
 +
==VS_BR_TYPES Sheet==
 +
 +
'''VS_BR_TPYE_COMMENT'''
 +
    Any content in this column will render the remaining columns for the row as commented out
 +
 +
'''VS_BR_TYPE'''
 +
    The 2 character type (Example: FS, EX and AU)
 +
 +
'''VS_BR_TYPE_DESC'''
 +
    The Branch type description (Example: Full Service, Express Branch and Automated Branch)

Revision as of 22:41, 12 September 2012

Overview

The vs_branch_info spreadsheet allows for custom naming of Branches as well as assigning what type of Branch they are. You can also define productivity targets and productivity ranges.

VS_BRANCHES Sheet

VS_BR_COMMENT

   Any text in this column will render the remaining columns as commented out

VS_BR_NUM

   The branch number

VS_BR_NAME

   The custom branch name

VS_BR_SORT

   The sequential order to display the branch

VS_BR_TYPE

   The 2 character VS_BR_TYPE defined on the VS_BR_TYPES sheet

VS_BR_DESC

   The custom description of this branch

VS_BR_PRODUCTIVITY_TARGET

   The branch productivity target

VS_BR_PROD_RANGE

   The branch productivity range


VS_BR_TYPES Sheet

VS_BR_TPYE_COMMENT

   Any content in this column will render the remaining columns for the row as commented out

VS_BR_TYPE

   The 2 character type (Example: FS, EX and AU)

VS_BR_TYPE_DESC

   The Branch type description (Example: Full Service, Express Branch and Automated Branch)