Vs branch info.xls

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)