Spreadsheet: 28832d1223383764-how-do-i-average-two-coloumns-for-6-months-rolling-overtime
Sheet: overtime 2001-2002

QMI CORE TEAM  -   2001 OVERTIME RECORD
 | GEOFF CARTWRIGHT |  |  |  | GARETH DAVIES |  |  |  | PAUL DAVIES |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | PAUL POULTNEY |  |  |  | [NAME]
 | DATE | HOURS | [NAME] |  | DATE | HOURS | [NAME] |  | DATE | HOURS | [NAME] |  | DATE | HOURS | [NAME] |  | DATE | HOURS | [NAME] |  | DATE | HOURS | [NAME] |  | DATE | HOURS | [NAME]
 |  | TOTAL | 63 |  |  | TOTAL | 121 |  |  | TOTAL | 73 |  |  | TOTAL | 75 |  |  | TOTAL | 117 |  |  | TOTAL | 103 |  |  | TOTAL | 82.5
 | 2001-03-21 00:00:00 | 1.5 | [NAME] visco 41Q003 |  | 2001-03-03 00:00:00 | 3 | ODUG |  | 2001-03-01 00:00:00 | 2 | qmi workshop meeting |  | 2001-05-22 00:00:00 | 2 | [NAME] ( 2-Q-30) |  | 2001-03-13 00:00:00 | 3 | T4868/T4842 [NAME] ratings |  | 2001-03-07 00:00:00 | 1 | 68-Q-082 FIREBREAK CABINET VALVE |  | 2001-03-05 00:00:00 | 1 | Plat 3 plenum trip
 | 2001-03-22 00:00:00 | 1 | SAP entries |  | 2001-03-05 00:00:00 | 1 | [NAME] |  | 2001-03-05 00:00:00 | 1 | plat 3 a/h trip |  | 2001-05-25 00:00:00 | 2 | [NAME] |  | 2001-03-15 00:00:00 | 2 | In Tools results |  | 2001-03-13 00:00:00 | 2 | 67-Q-500 WHITEY VALVES (PASSING) |  | 2001-03-31 00:00:00 | 9 | Sulphurs ASR probe failure
 | 2001-03-04 00:00:00 | 3 | Breakdown 54Q010 Aromatics |  | 2001-03-07 00:00:00 | 1 | ODUD |  | 2001-03-06 00:00:00 | 2 | dust analyser |  | 2001-06-04 00:00:00 | 2 | OMS |  | 2001-03-20 00:00:00 | 1 | Rush order for flashpoint spares |  | 2001-03-28 00:00:00 | 2 | 69-Q-200 SLIDER,67-Q-510 FROZEN LCD |  | 2001-04-08 00:00:00 | 6 | [NAME] servicing
 | 2001-04-08 00:00:00 | 6 | Blocked cooler tubes 59Q01&2 Arom |  | 2001-03-28 00:00:00 | 2 | ODUG |  | 2001-03-07 00:00:00 | 1 | 68q82 valve order |  | 2001-06-07 00:00:00 | 2 | [NAME] |  | 2001-03-27 00:00:00 | 1 | Problems with ref. tank s/sheet |  | 2001-03-29 00:00:00 | 2 | 67-Q-510 [NAME] |  | 2001-04-23 00:00:00 | 4 | F1 Head Change
 | 2001-04-23 00:00:00 | 2.5 | Breakdown 54Q010 Aromatics |  | 2001-03-29 00:00:00 | 2 | ODUD |  | 2001-03-13 00:00:00 | 2 | sap entries |  | 2001-06-21 00:00:00 | 2 | HVI Visco Breakdown |  | 2001-03-31 00:00:00 | 8 | Call in to ODU - 55 Q-1 |  | 2001-04-03 00:00:00 | 3 | 68-Q-082 NEW F/BREAK CABINET VALVE |  | 2001-04-24 00:00:00 | 2 | Work Instructions
 | 2001-05-10 00:00:00 | 1 | [NAME] visco |  | 2001-03-31 00:00:00 | 8 | ODUS - Called in to 55Q001 tail gas |  | 2001-03-14 00:00:00 | 2 | sap entries |  | 2001-07-15 00:00:00 | 5 | Utilities QA Backlog |  | 2001-04-04 00:00:00 | 3 | ODU breakdown 3-Q-5/ 2-Q-18 |  | 2001-04-05 00:00:00 | 3 | 60-Q-220 NEW PHOTOCELLS/OPTIC |  | 2001-05-22 00:00:00 | 2 | GC Fault CD4 02 Q 030
 | 2001-05-12 00:00:00 | 2 | [NAME] visco |  | 2001-04-03 00:00:00 | 2 | OILG |  | 2001-03-15 00:00:00 | 2 | sap entries |  | 2001-08-14 00:00:00 | 4 | OMS F1 [NAME] |  | 2001-04-05 00:00:00 | 1 | OMS schedule changes with A.Williams |  | 2001-04-10 00:00:00 | 3 | 69-Q-200 S/GUARDING,60-Q-250 LCD FRO |  | 2001-06-01 00:00:00 | 7 | PRODIST main board failure No9 PH
 | 2001-05-13 00:00:00 | 4 | SAP entries |  | 2001-04-04 00:00:00 | 3 | ODUD |  | 2001-03-23 00:00:00 | 2 | sap entries |  | 2001-08-20 00:00:00 | 3 | 23 & 24 Boiler O2 Breakdown |  | 2001-04-18 00:00:00 | 2 | OMS Operator training |  | 2001-04-20 00:00:00 | 2 | 60-Q-550 KOH PELLETS OVERPRESSURE |  | 2001-06-04 00:00:00 | 2 | [NAME]
 | 2001-06-07 00:00:00 | 1.5 | [NAME] 94Q570 |  | 2001-04-06 00:00:00 | 1 | ODUG |  | 2001-03-28 00:00:00 | 1 | work instruction updates |  | 2001-08-21 00:00:00 | 4 | OMS F2 [NAME] |  | 2001-04-23 00:00:00 | 4 | F1 Cylinder Head Change |  | 2001-06-03 00:00:00 | 6 | 68-Q-060 CALL IN SUN. CP VALVES U/S |  | 2001-07-24 00:00:00 | 4 | CFPP WOG (not on banding form)
 | 2001-06-13 00:00:00 | 1 | SAP entries |  | 2001-04-07 00:00:00 | 5 | ODUS - Called in to 55Q001 tail gas |  | 2001-04-02 00:00:00 | 2 | work instruction updates |  | 2001-08-23 00:00:00 | 1 | 21 Boiler O2 & CT9 Chlorine |  | 2001-05-15 00:00:00 | 2 | QMI Release Benchmarking |  | 2001-06-12 00:00:00 | 3 | HFA SAFEGUARDING ANALYSER HOUSE |  | 2001-07-25 00:00:00 | 2 | CFPP WOG (not on banding form)
 | 2001-06-20 00:00:00 | 2 | Breakdown  54Q020 Aromatics |  | 2001-04-10 00:00:00 | 1 | ODUD |  | 2001-04-11 00:00:00 | 2 | sap entries |  | 2001-08-29 00:00:00 | 2 | Removal Of Old Kero Freeze Analyser |  | 2001-06-19 00:00:00 | 5 | F1 Decoke/ F2 erratic/Prodist U/S |  | 2001-06-14 00:00:00 | 3 | EBU SAFEGUARDING 69-Q-200 |  | 2001-08-31 00:00:00 | 3 | [NAME] Refill
 | 2001-08-08 00:00:00 | 2 | Breakdown 54Q010 Aromatics |  | 2001-04-13 00:00:00 | 3 | ODUU - Called in Utilities. Bank Holiday |  | 2001-04-20 00:00:00 | 2 | hfa 60-q-550 |  | 2001-10-03 00:00:00 | 1 | Non conformance entries |  | 2001-06-26 00:00:00 | 2 | West Of [NAME] analysers |  | 2001-07-22 00:00:00 | 4 | CALL IN EBU START UP GC'S BOL |  | 2001-09-13 00:00:00 | 3 | F2 Engine Data Hiway Fault
 | 2001-08-15 00:00:00 | 1 | SAP entries |  | 2001-04-17 00:00:00 | 2 | ODUD |  | 2001-05-24 00:00:00 | 1 | gsu 30q610 & 34q502 |  | 2001-10-23 00:00:00 | 3 | EBU A/House Safeguarding |  | 2001-07-05 00:00:00 | 2 | ODU Kero freeze U/s (2-Q-18) |  | 2001-07-25 00:00:00 | 2 | 60-Q-550 STRM 2 VAPOURIZER U/S |  | 2001-09-14 00:00:00 | 2 | F2 Engine Data Hiway Fault
 | 2001-08-21 00:00:00 | 2 | SAP entries |  | 2001-04-19 00:00:00 | 2 | ODUD |  | 2001-05-26 00:00:00 | 3 | call-in 54q10 |  | 2001-11-07 00:00:00 | 2 | Intools Results |  | 2001-07-12 00:00:00 | 2 | Call in to Oms F2 engine (30-Q-3) |  | 2001-08-28 00:00:00 | 4 | 60-Q-001 TCD FUSE BLOWN, O/HAUL |  | 2001-09-15 00:00:00 | 4 | Call-in aromatics 54-q-010
 | 2001-08-22 00:00:00 | 1 | SAP entries |  | 2001-05-22 00:00:00 | 2 | ODUD - Breakdown CDU4 002-Q-0030 |  | 2001-06-20 00:00:00 | 2 | cd4 7q030 |  | 2001-11-08 00:00:00 | 1 | Work Instruction Laminating |  | 2001-07-17 00:00:00 | 3 | [NAME]/T4842 Refill |  | 2001-08-30 00:00:00 | 2 | 68-Q-081/82 MLIV STEM(S) QA PROBLEM |  | 2001-09-18 00:00:00 | 2 | T4868 Refill and F2 Rating
 | 2001-08-23 00:00:00 | 1 | SAP entries |  | 2001-05-25 00:00:00 | 2 | ODUD - Breakdown CDU4 |  | 2001-07-05 00:00:00 | 3 | gsu 30q580 & 35q550 |  | 2001-11-14 00:00:00 | 1 | SCNU pH probes |  | 2001-07-19 00:00:00 | 1 | [NAME] shedules |  | 2001-09-19 00:00:00 | 2 | 60-Q-220 SULPHUR DRAIN HOLED |  | 2001-09-19 00:00:00 | 2 | [NAME] on CFPP
 | 2001-08-29 00:00:00 | 1 | SAP entries |  | 2001-05-30 00:00:00 | 6 | OMSX - Call in on OMS VRU K38 |  | 2001-07-08 00:00:00 | 5 | sr   asr probe installation |  | 2001-11-28 00:00:00 | 6 | 055-Q-0001 - Breakdown |  | 2001-07-24 00:00:00 | 4 | F2 decoke/optimax ref tank analysis |  | 2001-09-28 00:00:00 | 2 | 68-Q-100 QA FAILURE, CP VALVES. |  | 2001-09-23 00:00:00 | 3 | Call-in aromatics 54-q-010
 | 2001-09-03 00:00:00 | 3 | Intools entries |  | 2001-06-07 00:00:00 | 2 | OILG - SAP Training for I DODDS |  | 2001-07-17 00:00:00 | 1 | work instruction updates |  | 2001-11-29 00:00:00 | 2 | 002-Q-0017 - Put back online. |  | 2001-07-25 00:00:00 | 1 | Optimax post-cal failure on F2 |  | 2001-10-01 00:00:00 | 3 | 68-Q-060 SEALS PASSING/MLIV VALVE |  | 2001-10-10 00:00:00 | 6.5 | F2 Engine Control Room Unit Replacement
 | 2001-09-20 00:00:00 | 2 | Intools entries |  | 2001-07-08 00:00:00 | 5 | ODUS - 053Q0001 ASR probe installation |  | 2001-07-18 00:00:00 | 1 | sap entries |  | 2001-12-04 00:00:00 | 4 | F1 H/C & F2 Thermistor Failure |  | 2001-07-26 00:00:00 | 1 | [NAME] |  | 2001-10-02 00:00:00 | 2 | 68-Q-060 SEALS PASSING/MLIV VALVE |  | 2001-11-03 00:00:00 | 4 | Crowcon Gas Monitor Contract
 | 2001-09-29 00:00:00 | 3 | Call-in to 94Q207 Plat3 |  | 2001-07-09 00:00:00 | 2 | ODUD |  | 2001-07-19 00:00:00 | 1 | work instruction updates |  | 2001-12-10 00:00:00 | 1 | Work on new silica analysers |  | 2001-07-27 00:00:00 | 4 | OMS Call in to KVP analyser (30-Q-10) |  | 2001-10-03 00:00:00 | 2 | 61-Q-510 BREAKDOWN/PURGE FAILURE |  | 2001-11-11 00:00:00 | 8.5 | OMP QA Work Instructions
 | 2001-10-02 00:00:00 | 1 | Tests on CCR PT3 to prove 94Q207 |  | 2001-07-15 00:00:00 | 5 | ODUS - 053Q0001 ASR probe installation |  | 2001-07-23 00:00:00 | 2 | work instruction updates |  | 2001-12-18 00:00:00 | 3 | F2 H/C and IGO Dist Repairs |  | 2001-08-05 00:00:00 | 3 | call in to 55-Q-1 |  | 2001-10-04 00:00:00 | 3 | BUTAMER STARTUP 60-Q-225/230/250/300 |  | 2001-11-16 00:00:00 | 2.5 | HVI - LMO Visco
 | 2001-10-04 00:00:00 | 3 | Call-in Plat3 94Q562 KVP |  | 2001-07-16 00:00:00 | 5 | ODUS - Breakdown on 055Q0001 |  | 2001-08-15 00:00:00 | 1 | ebu 68q090 |  | 2002-01-07 00:00:00 | 2.5 | Re-Applicaton of 007-Q-0030 |  | 2001-08-14 00:00:00 | 4 | F1 Cylinder Head Change |  | 2001-10-09 00:00:00 | 4 | 68-Q-081/82  CP VALVES/MLIV STEMS |  | 2002-02-06 00:00:00 | 3 | HVI - DAO Visco
 | 2001-10-16 00:00:00 | 2 | Call-in HVI 49Q001 & 49Q008 |  | 2001-07-20 00:00:00 | 2 | ODUD |  | 2001-09-24 00:00:00 | 1 | GSU 35Q510 - moisture check, ops req |  | 2002-01-08 00:00:00 | 4.5 | Re-Applicaton of 007-Q-0030 |  | 2001-08-21 00:00:00 | 4 | [NAME]. Head Change |  | 2001-10-10 00:00:00 | 3 | HFA SAFEGUARDING ANALYSER HOUSE
 | 2001-10-20 00:00:00 | 2 | Call-in Plat3 94Q563 Octane |  | 2001-07-31 00:00:00 | 2 | ODUD |  | 2001-09-26 00:00:00 | 1 | GSU plant change 39Q011/30Q530 |  | 2002-01-09 00:00:00 | 2.5 | Re-Applicaton of 007-Q-0030 |  | 2001-08-28 00:00:00 | 2 | Sap/In Tools/ OMS planning |  | 2001-10-23 00:00:00 | 3 | EBU A/HOUSE SAFEGUARDING
 | 2001-10-30 00:00:00 | 2 | Intools entries |  | 2001-08-20 00:00:00 | 3 | ODUU - Breakdown HPBH O2 analysers |  | 2001-10-09 00:00:00 | 2 | ODU tech approval of work instructions |  | 2002-01-10 00:00:00 | 2.5 | Re-Applicaton of 007-Q-0030 |  | 2001-08-31 00:00:00 | 1 | T4842 Refill/rate |  | 2001-11-03 00:00:00 | 4 | W/END ATTENDANCE 60-Q-250 RETURN
 | 2001-11-10 00:00:00 | 8 | Intools entries |  | 2001-08-21 00:00:00 | 1 | ODUU - Breakdown HPBH smoke meter |  | 2001-10-10 00:00:00 | 1 | GSU 30Q502 purge alarm fault |  | 2002-01-14 00:00:00 | 3 | Re-Applicaton of 007-Q-0030 |  | 2001-09-13 00:00:00 | 3 | F2 Engine Dat Hiway Fault |  | 2001-11-06 00:00:00 | 3 | 69-Q-200 BENZ IN AIR SAFEGUARDING
 | 2001-11-16 00:00:00 | 2.5 | [NAME] visco |  | 2001-08-23 00:00:00 | 1 | ODUU - Breakdown CT9 Hypo dosing |  | 2001-11-11 00:00:00 | 2 | OMC sap entries |  | 2002-01-21 00:00:00 | 1 | Re-Applicaton of 007-Q-0030 |  | 2001-09-14 00:00:00 | 2 | F2 Engine Dat Hiway Fault |  | 2001-11-23 00:00:00 | 1 | ISOLATE GSU PLENUM FOR EXCHANGER
 | 2001-12-12 00:00:00 | 1 | Breakdown Arom 54Q020 SI valve seals |  | 2001-08-27 00:00:00 | 4 | ODUD - Called in Bank Holiday unit 500 |  | 2001-10-12 00:00:00 | 2 | intools safeguarding entries |  | 2002-01-22 00:00:00 | 4 | Re-Applicaton of 007-Q-0030 |  | 2001-09-18 00:00:00 | 2 | Gas Oil QMI S/D |  | 2001-12-14 00:00:00 | 1 | 60-Q-500 GATING TIMES
 |  |  |  |  | 2001-08-30 00:00:00 | 2 | ODUD - Removal of old [NAME] |  | 2001-10-13 00:00:00 | 2 | omc work instructions   (h) |  | 2002-01-29 00:00:00 | 2 | 055-Q-0001 - Breakdown |  | 2001-10-10 00:00:00 | 4 | F2 Engine Control Room Unit Replacement |  | 2002-01-07 00:00:00 | 4 | 68-Q-082 FROZEN/HFA SAFEGUARDING
 |  |  |  |  | 2001-09-09 00:00:00 | 4 | ODUS - Called in to 55Q001 tail gas |  | 2001-10-14 00:00:00 | 3 | ebu work instructions   (h) |  |  |  |  |  | 2001-10-17 00:00:00 | 1 | QA Work Instructions |  | 2002-01-15 00:00:00 | 4 | HFA SAFEGUARDING/68Q050 (K6800 RE)
 |  |  |  |  | 2001-09-17 00:00:00 | 1 | ODUS - Breakdown on 057Q0503 |  | 2001-10-15 00:00:00 | 2 | omc work instructions   (h) |  |  |  |  |  | 2001-11-03 00:00:00 | 3 | Call in to Mogas Sulphur analyser. |  | 2002-01-16 00:00:00 | 2 | QA SCHEDULES DOCUMENTS
 |  |  |  |  | 2001-10-10 00:00:00 | 2 | OILG - Work Instructions |  | 2001-10-16 00:00:00 | 1 | hfa  work instructions  (h) |  |  |  |  |  | 2001-11-04 00:00:00 | 2 | QA Work Instructions (H) |  | 2002-01-17 00:00:00 | 1 | 68-Q-050 REGEN O2. CATALYST BLOCKED
 |  |  |  |  | 2001-10-11 00:00:00 | 1 | OILG - Work Instructions |  | 2001-10-17 00:00:00 | 1 | hfa  work instructions  (h) |  |  |  |  |  | 2001-11-07 00:00:00 | 1 | QA Work Instructions (pinks) |  | 2002-01-22 00:00:00 | 3 | INTOOLS/SAP DATA ENTRIES
 |  |  |  |  | 2001-10-23 00:00:00 | 2 | OILG - Input Intools Data |  | 2001-10-18 00:00:00 | 1 | hfa  work instructions |  |  |  |  |  | 2001-11-24 00:00:00 | 3 | Call in to reactivator 3 ph |  | 2002-01-29 00:00:00 | 2 | INTOOLS/SAP DATA ENTRIES
 |  |  |  |  | 2001-10-27 00:00:00 | 3 | ODUS - Called in to 55Q001 tail gas |  | 2001-10-23 00:00:00 | 1 | sap entries |  |  |  |  |  | 2001-11-28 00:00:00 | 2 | 55-Q-1 Tail Gas Analyser (ODU Sulphurs) |  | 2002-02-01 00:00:00 | 2 | HFA START UP. 60-Q-230/250.
 |  |  |  |  | 2001-11-07 00:00:00 | 3 | ODUD - CDU3 Backlog on schedules |  | 2001-11-01 00:00:00 | 1.5 | sap entries & WI |  |  |  |  |  | 2001-12-01 00:00:00 | 3 | Call in to 55-Q-1 by [NAME]. |  | 2002-02-03 00:00:00 | 6 | CALL IN EBU START UP
 |  |  |  |  | 2001-11-08 00:00:00 | 3 | OILG - Work Instructions |  | 2001-11-02 00:00:00 | 1.5 | gsu 35q520 & WI |  |  |  |  |  | 2001-12-04 00:00:00 | 4 | F1 H/C & F2 Thermistor Failure |  | 2002-02-12 00:00:00 | 3 | 67-Q-112 DRY GAS DENSITY, FULL LIQUID
 |  |  |  |  | 2001-11-12 00:00:00 | 2 | OILG - Work Instructions |  | 2001-11-07 00:00:00 | 1 | omc work instructions |  |  |  |  |  | 2001-12-18 00:00:00 | 3 | F2 H/C and IGO Dist Repairs |  | 2002-02-13 00:00:00 | 1 | SAP/INTOOLS DATA ENTRIES
 |  |  |  |  | 2001-11-14 00:00:00 | 1 | ODUD - Scnu pH checks |  | 2001-12-04 00:00:00 | 1 | 22q018 flash analyser report |  |  |  |  |  | 2002-01-09 00:00:00 | 2 | CD4 2-Q-17 sample problems.
 |  |  |  |  | 2001-11-23 00:00:00 | 1 | OILG - Sims & Intools |  | 2002-01-11 00:00:00 | 1 | 22q001 chiller failure |  |  |  |  |  | 2002-01-16 00:00:00 | 4 | mix/ulsd sulphur changeover.
 |  |  |  |  | 2001-11-28 00:00:00 | 6 | ODUS - Breakdown on 55Q001 tail gas |  | 2002-01-17 00:00:00 | 1 | 21q006 liquid carryover |  |  |  |  |  | 2002-01-22 00:00:00 | 3 | ODU Purge Unit Repairs
 |  |  |  |  | 2001-11-29 00:00:00 | 2 | ODUS - Breakdown on 55Q001 tail gas |  | 2002-01-23 00:00:00 | 3 | ODU Purge Unit Repairs |  |  |  |  |  | 2002-01-29 00:00:00 | 2 | T4842 Refill + IGO Prodist In Tools
 |  |  |  |  | 2001-12-20 00:00:00 | 2 | ODUD - Start up of HGO analysers |  | 2002-01-25 00:00:00 | 1 | sap entries |  |  |  |  |  | 2002-02-01 00:00:00 | 3 | [NAME] on mogas sulphur analyser.
 |  |  |  |  | 2001-12-21 00:00:00 | 6 | ODUU - Called in for 26 Blr Start up |  | 2001-02-01 00:00:00 | 1 | sap entries |  |  |  |  |  | 2002-02-03 00:00:00 | 4 | Call in to Mogas dist & IGO Cloud point.
 |  |  |  |  | 2002-02-15 00:00:00 | 2 | ODUU - Called in for Reactivator 3 pH