Difference between revisions of "Vs branch info.xls"

From Vital Soft Wiki
Jump to: navigation, search
>Johno
 
Line 1: Line 1:
 
==Overview==
 
==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.'''
 
'''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_BRANCHES Worksheet==
 
 
'''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'''
+
{| class="wikitable"
    Any content in this column will render the remaining columns for the row as commented out
+
| '''Excel Column'''
 +
| '''Meaning'''
 +
|-
 +
| VS_BR_COMMENT
 +
| Any non-blank value in this column disables the entire row.
 +
|-
 +
| VS_BR_NUM
 +
| The branch number.
 +
|-
 +
| VS_BR_NAME
 +
| The branch name to display in Vital Signs documents.
 +
|-
 +
| VS_BR_SORT
 +
| A numeric sort value to determine the branch sort order in charts.
 +
|-
 +
| VS_BR_TYPE
 +
| The 2 character VS_BR_TYPE defined on the VS_BR_TYPES sheet.
 +
|-
 +
| VS_BR_DESC
 +
| A description for the branch - not used by the Vital Signs documents.
 +
|-
 +
| VS_BR_PRODUCTIVITY_TARGET
 +
| The branch productivity target in terms of transactions per hour.
 +
|-
 +
| VS_BR_PROD_RANGE
 +
| The valid productivity range.  A value of .1 indicates a range of +/- 10%.
 +
|}
  
'''VS_BR_TYPE'''
+
==VS_BR_TYPES Worksheet==
    The 2 character type (Example: FS, EX and AU)
 
  
'''VS_BR_TYPE_DESC'''
+
{| class="wikitable"
    The Branch type description (Example: Full Service, Express Branch and Automated Branch)
+
| '''Excel Column'''
 +
| '''Meaning'''
 +
|-
 +
| VS_BR_TYPE_COMMENT
 +
| Any non-blank value in this column disables the entire row.
 +
|-
 +
| VS_BR_TYPE
 +
| A 2 letter code indicating the branch type.  For example FS.
 +
|-
 +
| VS_BR_TYPE_DESC
 +
| The branch type description.  For example, Full Service.
 +
|}

Latest revision as of 23:30, 1 December 2015

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 Worksheet

Excel Column Meaning
VS_BR_COMMENT Any non-blank value in this column disables the entire row.
VS_BR_NUM The branch number.
VS_BR_NAME The branch name to display in Vital Signs documents.
VS_BR_SORT A numeric sort value to determine the branch sort order in charts.
VS_BR_TYPE The 2 character VS_BR_TYPE defined on the VS_BR_TYPES sheet.
VS_BR_DESC A description for the branch - not used by the Vital Signs documents.
VS_BR_PRODUCTIVITY_TARGET The branch productivity target in terms of transactions per hour.
VS_BR_PROD_RANGE The valid productivity range. A value of .1 indicates a range of +/- 10%.

VS_BR_TYPES Worksheet

Excel Column Meaning
VS_BR_TYPE_COMMENT Any non-blank value in this column disables the entire row.
VS_BR_TYPE A 2 letter code indicating the branch type. For example FS.
VS_BR_TYPE_DESC The branch type description. For example, Full Service.