Difference between revisions of "Vs branch info.xls"
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)