Spreadsheet: 681013d1591296494-complicated-formula-needed-to-find-value-in-a-range-with-multiple-variables-consolidated-rules-sample-file-
Sheet: Global Rule-Sets

 |  |  |  |  |  | Business Name 1 |  |  |  | Business Name 2 |  |  |  | Business Name 3
Department | Status | Unit of Measure | Shift | Job Code | Position | Hours / Day | Volume [NAME] | Hours per Shift | Cumulative Hours | Hours / Day | Volume [NAME] | Hours per Shift | Cumulative Hours | Hours / Day | Volume [NAME] | Hours per Shift | Cumulative Hours
Dept Name | Active | n/a | n/a | 10a | Night Auditor | 8 |  |  |  | 8 |  |  |  | 8
Dept Name | Active | Event Guests | Shift 1 | 12b | Planner | 0 | 0 | 8 |  | 0 | 0 | 8 |  | 0 | 0 | 8
Dept Name | Active | Event Guests | Shift 1 | 12b | Planner | 0 | 15 | 8 |  | 0 | 15 | 8 |  | 0 | 15 | 8
Dept Name | Active | Event Guests | Shift 1 | 12b | Planner | 0 | 45 | 8 |  | 0 | 45 | 8 |  | 0 | 45 | 8
Dept Name | Active | Event Guests | Shift 1 | 12b | Planner | 0 | 61 | 8 |  | 0 | 61 | 8 |  | 0 | 61 | 8
Dept Name | Active | Event Guests | Shift 2 | 12b | Planner | 0 | 0 | 8 |  | 0 | 0 | 8 |  | 0 | 0 | 8
Dept Name | Active | Event Guests | Shift 2 | 12b | Planner | 0 | 15 | 8 |  | 0 | 15 | 8 |  | 0 | 15 | 8
Dept Name | Active | Event Guests | Shift 2 | 12b | Planner | 0 | 45 | 8 |  | 0 | 45 | 8 |  | 0 | 45 | 8
Dept Name | Active | Event Guests | Shift 2 | 12b | Planner | 0 | 61 | 8 |  | 0 | 61 | 8 |  | 0 | 61 | 8
Dept Name | Active | Event Guests | Shift 3 | 12b | Planner | 0 | 0 | 8 |  | 0 | 0 | 8 |  | 0 | 0 | 8
Dept Name | Active | Event Guests | Shift 3 | 12b | Planner | 0 | 45 | 8 |  | 0 | 45 | 8 |  | 0 | 45 | 8
Dept Name | Active | Event Guests | Shift 3 | 12b | Planner | 0 | 77 | 8 |  | 0 | 77 | 8 |  | 0 | 77 | 8
Dept Name | Inactive | n/a | n/a | 61a | Manager | 0 |  |  |  | 0 |  |  |  | 0
Dept Name | Active | Total Guests | Shift 1 | 51a | Receptionist | 0 | 0 | 8 |  | 0 | 0 | 8 |  | 0 | 0 | 8
Dept Name | Active | Total Guests | Shift 1 | 51a | Receptionist | 0 | 45 | 8 |  | 0 | 45 | 8 |  | 0 | 45 | 8
Dept Name | Active | Total Guests | Shift 2 | 51a | Receptionist | 0 | 0 | 8 |  | 0 | 0 | 8 |  | 0 | 0 | 8
Dept Name | Active | Total Guests | Shift 2 | 51a | Receptionist | 0 | 61 | 8 |  | 0 | 61 | 8 |  | 0 | 61 | 8
Dept Name | Active | Total Guests | Shift 3 | 51a | Receptionist | 0 | 0 | 8 |  | 0 | 0 | 8 |  | 0 | 0 | 8
Dept Name | Active | Total Guests | Shift 3 | 51a | Receptionist | 0 | 77 | 8 |  | 0 | 77 | 8 |  | 0 | 77 | 8
Dept Name | Inactive | n/a | n/a | 31a | Engineer
Dept Name | Active | Occupied rooms | n/a | 40a | [NAME] | 0 | 0 | 8 |  | 0 | 0 | 8 |  | 0 | 0 | 8
Dept Name | Active | Occupied rooms | n/a | 40a | [NAME] | 0 | 30 | 8 |  | 0 | 30 | 8 |  | 0 | 30 | 8
Dept Name | Active | Occupied rooms | n/a | 40a | [NAME] | 0 | 61 | 8 |  | 0 | 61 | 8 |  | 0 | 61 | 8
Dept Name | Active | Occupied rooms | n/a | 40a | [NAME] | 0 | 107 | 8 |  | 0 | 107 | 8 |  | 0 | 107 | 8
Dept Name | Active | Occupied rooms | n/a | 40a | [NAME] | 0 | 169 | 8 |  | 0 | 169 | 8 |  | 0 | 169 | 8
Dept Name | Active | Occupied rooms | n/a | 40a | [NAME] | 0 | 229 | 8 |  | 0 | 229 | 8 |  | 0 | 229 | 8
Dept Name | Active | Occupied rooms | n/a | 40b | Server | 0 | 1 | 10.29 |  | 0 | 1 | 10.29 |  | 0 | 0 | 10.29
Dept Name | Active | Occupied rooms | n/a | 40b | Server | 0 | 36 | 8 |  | 0 | 36 | 8 |  | 0 | 36 | 8
Dept Name | Active | Occupied rooms | n/a | 40b | Server | 0 | 56 | 8 |  | 0 | 56 | 8 |  | 0 | 56 | 8
Dept Name | Active | Occupied rooms | n/a | 40b | Server | 0 | 78 | 8 |  | 0 | 78 | 8 |  | 0 | 78 | 8
Dept Name | Active | Occupied rooms | n/a | 40b | Server | 0 | 99 | 13.71 |  | 0 | 99 | 13.71 |  | 0 | 99 | 13.71