Spreadsheet: 735555d1623072507-average-multiple-rows-in-multiple-columns-based-off-multiple-criteria-points-test-sheet-avg-rop-calculator
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 |  | SUR: SURFACE / INT: INTERMEDIATE / CRV: CURVE |  |  |  |  |  |  | Manual Fill In Operator and [NAME] |  | Operator | A | B | C | D | E | F | G
Intermediate |  | SUR: SURFACE / INT: INTERMEDIATE |  |  |  |  |  |  |  |  | [NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7
Intermediate / Curve |  | SUR: SURFACE |  |  |  |  |  |  | Phases
Intermediate / Curve / Lateral |  | ST2: SIDETRACK 2 / CRV2: CURVE 2 / LAT2: [NAME] 2 |  |  |  |  |  |  | Surface | ROTATE ROP
Curve |  | ST: SIDETRACK / SUR: SURFACE / CRV: CURVE |  |  |  |  |  |  |  | SLIDE ROP
Curve / Lateral |  | ST: SIDETRACK / SUR: SURFACE |  |  |  |  |  |  |  | AVG ROP
Lateral |  | ST: SIDETRACK / LAT2: [NAME] 2
 |  | ST: SIDETRACK / LAT: [NAME] |  |  |  |  |  |  | Intermediate | ROTATE ROP
 |  | ST: SIDETRACK / INT: INTERMEDIATE |  |  |  |  |  |  |  | SLIDE ROP
 |  | ST: SIDETRACK / CRV2: CURVE 2 |  |  |  |  |  |  |  | AVG ROP
 |  | ST: SIDETRACK / CRV: CURVE
 |  | ST: SIDETRACK |  |  |  |  |  |  | Intermediate / Curve | ROTATE ROP
 |  | PILOT: PILOT |  |  |  |  |  |  |  | SLIDE ROP
 |  | N/A: N/A / SUR: SURFACE |  |  |  |  |  |  |  | AVG ROP
 |  | N/A: N/A / LAT: [NAME]
 |  | N/A: N/A / INT: INTERMEDIATE |  |  |  |  |  |  | Intermediate / Curve / Lateral | ROTATE ROP
 |  | N/A: N/A / CRV: CURVE / LAT: [NAME] |  |  |  |  |  |  |  | SLIDE ROP
 |  | N/A: N/A / CRV: CURVE |  |  |  |  |  |  |  | AVG ROP
 |  | LAT2: [NAME] 2
 |  | LAT: [NAME] / SUR: SURFACE |  |  |  |  |  |  | Curve | ROTATE ROP
 |  | LAT: [NAME] / ST: SIDETRACK / LAT2: [NAME] 2 |  |  |  |  |  |  |  | SLIDE ROP
 |  | LAT: [NAME] / ST: SIDETRACK |  |  |  |  |  |  |  | AVG ROP
 |  | LAT: [NAME] / PILOT: PILOT
 |  | LAT: LATERAL / N/A: N/A / SUR: SURFACE |  |  |  |  |  |  | Curve / Lateral | ROTATE ROP
 |  | LAT: LATERAL / N/A: N/A |  |  |  |  |  |  |  | SLIDE ROP
 |  | LAT: [NAME] / LAT2: [NAME] 2 |  |  |  |  |  |  |  | AVG ROP
 |  | LAT: [NAME] / INT: INTERMEDIATE
 |  | LAT: [NAME] / CRV: CURVE |  |  |  |  |  |  | Lateral | ROTATE ROP
 |  | LAT: [NAME] / |  |  |  |  |  |  |  | SLIDE ROP
 |  | LAT: [NAME] |  |  |  |  |  |  |  | AVG ROP
 |  | INT2: INTERMEDIATE 2 / INT: INTERMEDIATE / CRV: CURVE / LAT: [NAME]
 |  | INT2: INTERMEDIATE 2 / INT: INTERMEDIATE |  |  |  |  |  |  | Overall Performance | ROTATE ROP
 |  | INT2: INTERMEDIATE 2 / CRV: CURVE / SUR: SURFACE |  |  |  |  |  |  |  | SLIDE ROP
 |  | INT2: INTERMEDIATE 2 / CRV: CURVE / LAT: [NAME] / SUR: SURFACE |  |  |  |  |  |  |  | AVG ROP
 |  | INT2: INTERMEDIATE 2 / CRV: CURVE / LAT: [NAME]
 |  | INT2: INTERMEDIATE 2 / CRV: CURVE
 |  | INT2: INTERMEDIATE 2
 |  | INT: INTERMEDIATE / SUR: SURFACE / LAT: [NAME]
 |  | INT: INTERMEDIATE / SUR: SURFACE / INT2: INTERMEDIATE 2
 |  | INT: INTERMEDIATE / SUR: SURFACE / CRV: CURVE
 |  | INT: INTERMEDIATE / SUR: SURFACE
 |  | INT: INTERMEDIATE / ST: SIDETRACK
 |  | INT: INTERMEDIATE / N/A: N/A
 |  | INT: INTERMEDIATE / LAT: [NAME] / CRV: CURVE
 |  | INT: INTERMEDIATE / LAT: [NAME]
 |  | INT: INTERMEDIATE / INT2: INTERMEDIATE 2 / CRV: CURVE / LAT: [NAME]
 |  | INT: INTERMEDIATE / INT2: INTERMEDIATE 2
 |  | INT: INTERMEDIATE / CRV2: CURVE 2 / CRV: CURVE
 |  | INT: INTERMEDIATE / CRV: CURVE / SUR: SURFACE / LAT: [NAME]
 |  | INT: INTERMEDIATE / CRV: CURVE / ST: SIDETRACK / SUR: SURFACE
 |  | INT: INTERMEDIATE / CRV: CURVE / N/A: N/A
 |  | INT: INTERMEDIATE / CRV: CURVE / LAT: [NAME] / SUR: SURFACE
 |  | INT: INTERMEDIATE / CRV: CURVE / LAT: LATERAL / N/A: N/A
 |  | INT: INTERMEDIATE / CRV: CURVE / LAT: [NAME] / LAT2: [NAME] 2
 |  | INT: INTERMEDIATE / CRV: CURVE / LAT: [NAME]
 |  | INT: INTERMEDIATE / CRV: CURVE
 |  | INT: INTERMEDIATE
 |  | CRV2: CURVE 2 / LAT: [NAME]
 |  | CRV2: CURVE 2
 |  | CRV: CURVE / SUR: SURFACE / LAT: [NAME]
 |  | CRV: CURVE / SUR: SURFACE
 |  | CRV: CURVE / ST: SIDETRACK / CRV2: CURVE 2
 |  | CRV: CURVE / ST: SIDETRACK
 |  | CRV: CURVE / LAT: [NAME] / SUR: SURFACE / INT: INTERMEDIATE
 |  | CRV: CURVE / LAT: [NAME] / SUR: SURFACE
 |  | CRV: CURVE / LAT: [NAME] / PILOT: PILOT
 |  | CRV: CURVE / LAT: [NAME]
 |  | CRV: CURVE / INT2: INTERMEDIATE 2
 |  | CRV: CURVE / INT: INTERMEDIATE / LAT: [NAME]
 |  | CRV: CURVE / INT: INTERMEDIATE
 |  | CRV: CURVE / CRV2: CURVE 2
 |  | CRV: CURVE / CRV/LAT: CURVE/LATERAL / LAT: [NAME]
 |  | CRV: CURVE / CRV/LAT: CURVE/LATERAL
 |  | CRV: CURVE
 |  | CRV/LAT: CURVE/LATERAL / SUR: SURFACE / LAT: [NAME]
 |  | CRV/LAT: CURVE/LATERAL / N/A: N/A
 |  | CRV/LAT: CURVE/LATERAL / LAT: [NAME]
 |  | CRV/LAT: CURVE/LATERAL / CRV: CURVE / LAT: [NAME]
 |  | CRV/LAT: CURVE/LATERAL