Difference between revisions of "Vs branch info.xls"
>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 | + | ==VS_BRANCHES Worksheet== |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | ''' | + | {| class="wikitable" |
| − | + | | '''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== | |
| − | |||
| − | ''' | + | {| class="wikitable" |
| − | + | | '''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. |
