Spreadsheet: 735618d1623095745-average-multiple-rows-in-multiple-columns-based-off-multiple-criteria-points-test-sheet-avg-rop-calculator-1-
Sheet: Avg ROP

Manual Fill In Operator and [NAME] |  | Phases | SUR: Surface |  |  |  | INT: Intermediate |  |  |  | INT2: Intermediate 2 |  |  |  | INT2: Intermediate 2 / CRV: CURVE |  |  |  | CRV/LAT: CURVE/LATERAL |  |  |  | LAT: Lateral |  |  |  | Overall Performance
 |  |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP
Operator | [NAME]
A | 1
B | 2
C | 3
D | 4
E | 5
F | 6
G | 7
Manual Fill In Operator and [NAME] |  | Phases | Surface |  |  |  | Intermediate |  |  |  | Intermediate / Curve |  |  |  | Intermediate / Curve / Lateral |  |  |  | Curve |  |  |  | Curve / Lateral |  |  |  | Lateral |  |  |  | Overall Performance
 |  |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP
Operator | [NAME]
A | 1
B | 2
C | 3
D | 4
E | 5
F | 6
G | 7
 |  | Phases
Surface | 1 | N/A: N/A / SUR: SURFACE | 1 |  |  |  |  |  | Manual Fill In Operator and [NAME] |  | Operator | A | B | C | D | E | F | G
Intermediate | 2 | ST: SIDETRACK / SUR: SURFACE | 1 |  |  |  |  |  |  |  | [NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7
Intermediate / Curve | 3 | SUR: SURFACE | 1 |  |  |  |  |  | Phases
Intermediate / Curve / Lateral | 4 | SUR: SURFACE / INT: INTERMEDIATE | 1 |  |  |  |  |  | Surface | ROTATE ROP
Curve | 5 | SUR: SURFACE / INT: INTERMEDIATE / CRV: CURVE | 1 |  |  |  |  |  |  | SLIDE ROP
Curve / Lateral | 6 | INT: INTERMEDIATE | 2 |  |  |  |  |  |  | AVG ROP
Lateral | 7 | INT: INTERMEDIATE / INT2: INTERMEDIATE 2 | 2
 |  | INT: INTERMEDIATE / N/A: N/A | 2 |  |  |  |  |  | Intermediate | ROTATE ROP
 |  | INT: INTERMEDIATE / ST: SIDETRACK | 2 |  |  |  |  |  |  | SLIDE ROP
 |  | INT: INTERMEDIATE / SUR: SURFACE | 2 |  |  |  |  |  |  | AVG ROP
 |  | INT2: INTERMEDIATE 2 | 2
 |  | INT2: INTERMEDIATE 2 / INT: INTERMEDIATE | 2 |  |  |  |  |  | Intermediate / Curve | ROTATE ROP
 |  | N/A: N/A / INT: INTERMEDIATE | 2 |  |  |  |  |  |  | SLIDE ROP
 |  | ST: SIDETRACK / INT: INTERMEDIATE | 2 |  |  |  |  |  |  | AVG ROP
 |  | CRV: CURVE / INT: INTERMEDIATE | 3
 |  | INT: INTERMEDIATE / CRV: CURVE | 3 |  |  |  |  |  | Intermediate / Curve / Lateral | ROTATE ROP
 |  | INT: INTERMEDIATE / CRV: CURVE / N/A: N/A | 3 |  |  |  |  |  |  | SLIDE ROP
 |  | INT: INTERMEDIATE / CRV2: CURVE 2 / CRV: CURVE | 3 |  |  |  |  |  |  | AVG ROP
 |  | INT2: INTERMEDIATE 2 / CRV: CURVE | 3
 |  | INT2: INTERMEDIATE 2 / CRV: CURVE / SUR: SURFACE | 3 |  |  |  |  |  | Curve | ROTATE ROP
 |  | INT: INTERMEDIATE / CRV: CURVE / LAT: [NAME] | 4 |  |  |  |  |  |  | SLIDE ROP
 |  | INT: INTERMEDIATE / CRV: CURVE / LAT: [NAME] / LAT2: [NAME] 2 | 4 |  |  |  |  |  |  | AVG ROP
 |  | INT: INTERMEDIATE / CRV: CURVE / LAT: LATERAL / N/A: N/A | 4
 |  | INT: INTERMEDIATE / CRV: CURVE / SUR: SURFACE / LAT: [NAME] | 4 |  |  |  |  |  | Curve / Lateral | ROTATE ROP
 |  | INT: INTERMEDIATE / INT2: INTERMEDIATE 2 / CRV: CURVE / LAT: [NAME] | 4 |  |  |  |  |  |  | SLIDE ROP
 |  | INT: INTERMEDIATE / LAT: [NAME] / CRV: CURVE | 4 |  |  |  |  |  |  | AVG ROP
 |  | INT2: INTERMEDIATE 2 / CRV: CURVE / LAT: [NAME] | 4
 |  | INT2: INTERMEDIATE 2 / CRV: CURVE / LAT: [NAME] / SUR: SURFACE | 4 |  |  |  |  |  | Lateral | ROTATE ROP
 |  | INT2: INTERMEDIATE 2 / INT: INTERMEDIATE / CRV: CURVE / LAT: [NAME] | 4 |  |  |  |  |  |  | SLIDE ROP
 |  | CRV: CURVE | 5 |  |  |  |  |  |  | AVG ROP
 |  | CRV: CURVE / CRV2: CURVE 2 | 5
 |  | CRV: CURVE / ST: SIDETRACK | 5 |  |  |  |  |  | Overall Performance | ROTATE ROP
 |  | CRV: CURVE / ST: SIDETRACK / CRV2: CURVE 2 | 5 |  |  |  |  |  |  | SLIDE ROP
 |  | CRV2: CURVE 2 | 5 |  |  |  |  |  |  | AVG ROP
 |  | N/A: N/A / CRV: CURVE | 5
 |  | ST: SIDETRACK / CRV: CURVE | 5
 |  | ST: SIDETRACK / CRV2: CURVE 2 | 5
 |  | CRV/LAT: CURVE/LATERAL | 6
 |  | CRV/LAT: CURVE/LATERAL / CRV: CURVE / LAT: [NAME] | 6
 |  | CRV/LAT: CURVE/LATERAL / LAT: [NAME] | 6
 |  | CRV/LAT: CURVE/LATERAL / N/A: N/A | 6
 |  | CRV: CURVE / CRV/LAT: CURVE/LATERAL | 6
 |  | CRV: CURVE / CRV/LAT: CURVE/LATERAL / LAT: [NAME] | 6
 |  | CRV: CURVE / LAT: [NAME] | 6
 |  | CRV: CURVE / LAT: [NAME] / PILOT: PILOT | 6
 |  | CRV2: CURVE 2 / LAT: [NAME] | 6
 |  | LAT: [NAME] / CRV: CURVE | 6
 |  | N/A: N/A / CRV: CURVE / LAT: [NAME] | 6
 |  | ST2: SIDETRACK 2 / CRV2: CURVE 2 / LAT2: [NAME] 2 | 6
 |  | LAT: [NAME] | 7
 |  | LAT: [NAME] / | 7
 |  | LAT: [NAME] / LAT2: [NAME] 2 | 7
 |  | LAT: LATERAL / N/A: N/A | 7
 |  | LAT: LATERAL / N/A: N/A / SUR: SURFACE | 7
 |  | LAT: [NAME] / PILOT: PILOT | 7
 |  | LAT: [NAME] / ST: SIDETRACK | 7
 |  | LAT: [NAME] / ST: SIDETRACK / LAT2: [NAME] 2 | 7
 |  | LAT: [NAME] / SUR: SURFACE | 7
 |  | LAT2: [NAME] 2 | 7
 |  | N/A: N/A / LAT: [NAME] | 7
 |  | ST: SIDETRACK / LAT: [NAME] | 7
 |  | ST: SIDETRACK / LAT2: [NAME] 2 | 7
 |  | CRV/LAT: CURVE/LATERAL / SUR: SURFACE / LAT: [NAME]
 |  | CRV: CURVE / INT: INTERMEDIATE / LAT: [NAME]
 |  | CRV: CURVE / INT2: INTERMEDIATE 2
 |  | CRV: CURVE / LAT: [NAME] / SUR: SURFACE
 |  | CRV: CURVE / LAT: [NAME] / SUR: SURFACE / INT: INTERMEDIATE
 |  | CRV: CURVE / SUR: SURFACE
 |  | CRV: CURVE / SUR: SURFACE / LAT: [NAME]
 |  | INT: INTERMEDIATE / CRV: CURVE / LAT: [NAME] / SUR: SURFACE
 |  | INT: INTERMEDIATE / CRV: CURVE / ST: SIDETRACK / SUR: SURFACE
 |  | INT: INTERMEDIATE / LAT: [NAME]
 |  | INT: INTERMEDIATE / SUR: SURFACE / CRV: CURVE
 |  | INT: INTERMEDIATE / SUR: SURFACE / INT2: INTERMEDIATE 2
 |  | INT: INTERMEDIATE / SUR: SURFACE / LAT: [NAME]
 |  | LAT: [NAME] / INT: INTERMEDIATE
 |  | PILOT: PILOT
 |  | ST: SIDETRACK
 |  | ST: SIDETRACK / SUR: SURFACE / CRV: CURVE