Vs branch info.xls
Revision as of 23:30, 1 December 2015 by >Johno
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. |
