Spreadsheet: 111806d1308089588-how-to-use-sumif-with-multiple-rows-of-each-instance-example
Sheet: Report Data

Activity Log
Work Date: | 2011-04-01 00:00:00
Technician: | 462/10 | RAUL ZARATE | Shift: |  | Work Order #: | WO 2011 | 18188 | Work Type: | PM | Asset: | PS1TUNNEL | Procedure ID: | 408/113 | Start/Stop Time: | Hours: | 0.5 | WO Description: | SICK CAMERA TUNNEL PM PERIOD
Comments: | BOXES DIMMED GOOD. CLEAR PICS.
Technician: | 462/10 | RAUL ZARATE | Shift: |  | Work Order #: | WO 2011 | 18160 | Work Type: | PM | Asset: | ACS-1 | Procedure ID: | 600/104 | Start/Stop Time: | Hours: | 4 | WO Description: | AIR COMPRESSOR QUARTERLY PM
Comments: | COMPLETELY CLEANED AIR COMPRESSOR SYSTEM. INSTALLED HOSES FOR ALL DRAINS AND AUTO PRESSURE SWITCHES.
Technician: | 462/10 | RAUL ZARATE | Shift: |  | Work Order #: | WO 2011 | 18189 | Work Type: | PM | Asset: | PS2 TUNNEL | Procedure ID: | 408/113 | Start/Stop Time: | Hours: | 0.5 | WO Description: | SICK CAMERA TUNNEL PM PERIOD
Comments: | BOXES DIMMED GOOD. CLEAR PICS.
Total Hours for | 462/10 | on | 2011-04-01 00:00:00 | 5
Technician: | 462/12 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 17561 | Work Type: | EM | Asset: | S1-1 | Procedure ID: | 003/101 | Start/Stop Time: | Hours: | 0.4 | WO Description: | EMERGENCY MATERIAL HANDLING MAINTENANCE
Comments: | [NAME] TAKE UP ROLLER ON SINGULATOR DRIVE
Technician: | 462/12 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 18149 | Work Type: | PM | Asset: | 101-1 | Procedure ID: | 110/113 | Start/Stop Time: | Hours: | 2 | WO Description: | CHUTE PM PERIOD
Comments: | [NAME] UP ON SKATE WHEEL SECTIONS. TIGHTENED SET SCREWS AT COAL CHUTE CRANK HANDLE AT CHUTES 102-6 AND 103-6
Technician: | 462/12 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 18148 | Work Type: | PM | Asset: | 101-5 | Procedure ID: | 106/113 | Start/Stop Time: | Hours: | 1.25 | WO Description: | GRAVITY ROLLER VISUAL INSPECTION
Comments: | [NAME] IN GOOD SHAPE, ALL LANE FULL LIGHT WORKING CORRECTLY.
Total Hours for | 462/12 | on | 2011-04-01 00:00:00 | 3.65
Technician: | 462/2 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 17562 | Work Type: | NS | Asset: | IC AUTODIM | Procedure ID: | 001/101 | Start/Stop Time: | Hours: | 0.5 | WO Description: | NON SCHEDULED MAINTENANCE
Comments: | COMPLETED AUTO-DIM TEST.
Technician: | 462/2 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 17563 | Work Type: | NS | Asset: | 100 | Procedure ID: | 002/101 | Start/Stop Time: | Hours: | 1 | WO Description: | NON SCHEDULED MAINTENANCE
Comments: | DID A POST-OPS/PRE-OPS BELT CHECK/DOCK WALK.
Technician: | 462/2 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 17563 | Work Type: | NS | Asset: | 700 | Procedure ID: | 002/101 | Start/Stop Time: | Hours: | 1.5 | WO Description: | NON SCHEDULED MAINTENANCE
Comments: | MEETING WITH TROY EADS ( FMM )
Technician: | 462/2 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 18182 | Work Type: | PM | Asset: | SWAK SCALES | Procedure ID: | 300/152 | Start/Stop Time: | Hours: | 0.75 | WO Description: | SWAK SCALE TEST
Comments: | COMPLETED DAILY SWAK SCALE TEST.
Technician: | 462/2 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 18158 | Work Type: | PM | Asset: | LC1-2 | Procedure ID: | 100/104 | Start/Stop Time: | Hours: | 1.75 | WO Description: | CONVEYOR PM QUARTERLY
Comments: | COMPLETED QUARTERLY PM._x000D_ SIDE ACCESS TO DRIVE CAGE ( DOORS ) NEEDS SPOT WELDING._x000D_ BELT NEEDS TRACKED.
Total Hours for | 462/2 | on | 2011-04-01 00:00:00 | 5.5
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18164 | Work Type: | PM | Asset: | NR1-6 | Procedure ID: | 100/113 | Start/Stop Time: | Hours: | 0.25 | WO Description: | CONVEYOR PM PERIOD
Comments: | ALL IS IN GOOD CONDITION
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18155 | Work Type: | PM | Asset: | TMS | Procedure ID: | 490/113 | Start/Stop Time: | Hours: | 0.25 | WO Description: | TMS Tag Reader Inspection Period
Comments: | BLEW OUT DUST THAT WAS INSIDE ENCLOSURE.
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18120 | Work Type: | PM | Asset: | UNL1-7-2 | Procedure ID: | 100/101 | Start/Stop Time: | Hours: | 0.25 | WO Description: | CONVEYOR PM ANNUAL
Comments: | ALL IS IN GOOD CONDITION
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18102 | Work Type: | PM | Asset: | LC1-8 | Procedure ID: | 106/113 | Start/Stop Time: | Hours: | 0.5 | WO Description: | GRAVITY ROLLER VISUAL INSPECTION
Comments: | ALL IS IN GOOD CONDITION.
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18178 | Work Type: | PM | Asset: | UNL2-5-1 | Procedure ID: | 127/113 | Start/Stop Time: | Hours: | 0.5 | WO Description: | Maxx Extendo PM - Period
Comments: | BELT HAS SOME CRACKING ON EDGES, AND A LARGE PIECE HAS BEEN CUT OUT ON NORTH SIDE.
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18103 | Work Type: | PM | Asset: | LC1-7 | Procedure ID: | 110/113 | Start/Stop Time: | Hours: | 0.25 | WO Description: | CHUTE PM PERIOD
Comments: | ALL IS IN GOOD CONDITION
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18179 | Work Type: | PM | Asset: | UNL2-7-1 | Procedure ID: | 127/113 | Start/Stop Time: | Hours: | 0.5 | WO Description: | Maxx Extendo PM - Period
Comments: | BELT IS FRAYING ON EDGES, AND LACE IS CUT AT BOTH ENDS.
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18122 | Work Type: | PM | Asset: | UNL1-1-3 | Procedure ID: | 300/113 | Start/Stop Time: | Hours: | 0.25 | WO Description: | SWAK STATION PM INSPECTIONS
Comments: | KEY STATION IS WORN.
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18113 | Work Type: | PM | Asset: | LC4-4 | Procedure ID: | 100/113 | Start/Stop Time: | Hours: | 0.25 | WO Description: | CONVEYOR PM PERIOD
Comments: | ALL IS IN GOOD CONDTION
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18131 | Work Type: | PM | Asset: | UNL1-1-1 | Procedure ID: | 127/113 | Start/Stop Time: | Hours: | 0.25 | WO Description: | Maxx Extendo PM - Period
Comments: | ALL IS IN GOOD CONDITION.
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18185 | Work Type: | PM | Asset: | EW2 | Procedure ID: | 790/152 | Start/Stop Time: | Hours: | 0.1 | WO Description: | Eye Wash Station Inspection WEEKLY
Comments: | [NAME]
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18185 | Work Type: | PM | Asset: | EW2 | Procedure ID: | 790/152 | Start/Stop Time: | Hours: | 0.15 | WO Description: | Eye Wash Station Inspection WEEKLY
Comments:
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18184 | Work Type: | PM | Asset: | EW1 | Procedure ID: | 790/152 | Start/Stop Time: | Hours: | 0.15 | WO Description: | Eye Wash Station Inspection WEEKLY
Comments: | [NAME]
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18132 | Work Type: | PM | Asset: | UNL1-4-1 | Procedure ID: | 127/113 | Start/Stop Time: | Hours: | 0.25 | WO Description: | Maxx Extendo PM - Period
Comments: | ALL IS IN GOOD CONDITION.
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18180 | Work Type: | PM | Asset: | UNL2-8-1 | Procedure ID: | 127/113 | Start/Stop Time: | Hours: | 0.5 | WO Description: | Maxx Extendo PM - Period
Comments: | SOME MINOR BELT FRAYING.
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18111 | Work Type: | PM | Asset: | LC4-1 | Procedure ID: | 100/113 | Start/Stop Time: | Hours: | 0.25 | WO Description: | CONVEYOR PM PERIOD
Comments: | ALL IS IN GOOD CONDITION, SOME MINOR FRAYING ON BELT
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18112 | Work Type: | PM | Asset: | LC4-2 | Procedure ID: | 100/113 | Start/Stop Time: | Hours: | 0.25 | WO Description: | CONVEYOR PM PERIOD
Comments: | ALL IS IN GOOD CONDITION
Technician: | 462/9 | PAUL DUNN | Shift: |  | Work Order #: | WO 2011 | 18186 | Work Type: | PM | Asset: | EW3 | Procedure ID: | 790/152 | Start/Stop Time: | Hours: | 0.16 | WO Description: | Eye Wash Station Inspection WEEKLY
Comments: | [NAME]
Total Hours for | 462/9 | on | 2011-04-01 00:00:00 | 5.06
Total Hours for all technicians on | 2011-04-01 00:00:00 | 19.21
Work Date: | 2011-04-02 00:00:00
Technician: | 462/12 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 17561 | Work Type: | EM | Asset: | LC4-4 | Procedure ID: | 003/101 | Start/Stop Time: | Hours: | 0.5 | WO Description: | EMERGENCY MATERIAL HANDLING MAINTENANCE
Comments: | [NAME] METAL PACKAGE THAT WAS HUNG AT TRANSISION OF BELT. ADJUST BELT TENSION BY 1/4 OF A INCH, DUE TO BELT SLIPPING WITH WEIGHT ON IT.
Technician: | 462/12 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 17562 | Work Type: | NS | Asset: | S2-11 | Procedure ID: | 001/101 | Start/Stop Time: | Hours: | 0.33 | WO Description: | NON SCHEDULED MAINTENANCE
Comments: | [NAME] CORNER OF TRANSISION PLATE TO KEEP IT FROM HANGING STRAPE ON PACKAGES.
Technician: | 462/12 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 17562 | Work Type: | NS | Asset: | LC2-7 | Procedure ID: | 001/101 | Start/Stop Time: | Hours: | 0.75 | WO Description: | NON SCHEDULED MAINTENANCE
Comments: | [NAME], METAL ROLLERS, SCREWS, AND PLASTIC PLUGS. REMOVED DUST AND DIRT BUILD UP FROM BOTTOM FRAME WORK.
Technician: | 462/12 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 17562 | Work Type: | NS | Asset: | S1-1 | Procedure ID: | 001/101 | Start/Stop Time: | Hours: | 0.5 | WO Description: | NON SCHEDULED MAINTENANCE
Comments: | [NAME], THAT WAS RUBBING THE TAB RAIL. INSTALLED SLAVE BAND SO ALL SLAVE ROLLERS ARE TURNING.
Technician: | 462/12 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 18163 | Work Type: | PM | Asset: | NR1-14 | Procedure ID: | 100/113 | Start/Stop Time: | Hours: | 0.5 | WO Description: | CONVEYOR PM PERIOD
Comments: | [NAME] IN DRIVE CAGE. FEW DAMAGED TEETH AT LACING, BUT DOES NOT EFFECT OPERATION.TRASH IN MESH UNDER GUARDS.
Technician: | 462/12 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 18147 | Work Type: | PM | Asset: | LC1-9 | Procedure ID: | 105/113 | Start/Stop Time: | Hours: | 1 | WO Description: | GRAVITY WHEEL VISUAL INSPECTION
Comments: | [NAME] UP ON SKATE WHEELS. REMOVED METAL OVERGOODS, SCREWS AND BOLTS FROM SKATE WHEEL SECTION LC4-9
Technician: | 462/12 | [NAME] | Shift: |  | Work Order #: | WO 2011 | 18162 | Work Type: | PM | Asset: | NR1-12 | Procedure ID: | 100/113 | Start/Stop Time: | Hours: | 0.5 | WO Description: | CONVEYOR PM PERIOD
Comments: | [NAME] DUST IN MOTOR CAGE. EXCESS GREASE ON ZIRK FITTINGS. MINOR CUT RUNNING LENGHT OF BELT.
Total Hours for | 462/12 | on | 2011-04-02 00:00:00 | 4.08
Total Hours for all technicians on | 2011-04-02 00:00:00 | 4.08
Work Date: | 2011-04-04 00:00:00
Technician: | 462/11 | DANIEL VOGES | Shift: |  | Work Order #: | WO 2011 | 17563 | Work Type: | NS | Asset: | 100 | Procedure ID: | 002/101 | Start/Stop Time: | Hours: | 6 | WO Description: | NON SCHEDULED MAINTENANCE
Comments: | STARTED DISSEMBELING CARRIAGES AND DISSEMBELING
Technician: | 462/11 | DANIEL VOGES | Shift: |  | Work Order #: | WO 2011 | 18166 | Work Type: | PM | Asset: | S1-9A | Procedure ID: | 100/113 | Start/Stop Time: | Hours: | 0.17 | WO Description: | CONVEYOR PM PERIOD
Comments: | THE TRACKING OF BOTH BELTS ARE GREAT.
Technician: | 462/11 | DANIEL VOGES | Shift: |  | Work Order #: | WO 2011 | 18152 | Work Type: | PM | Asset: | S1-3 | Procedure ID: | 104/113 | Start/Stop Time: | Hours: | 0.1 | WO Description: | POWER FACE DEFLECTOR INSPECTION
Comments: | THIS DOES NOT EXIST.
Technician: | 462/11 | DANIEL VOGES | Shift: |  | Work Order #: | WO 2011 | 18153 | Work Type: | PM | Asset: | S2-3 | Procedure ID: | 104/113 | Start/Stop Time: | Hours: | 0.1 | WO Description: | POWER FACE DEFLECTOR INSPECTION
Comments:
Technician: | 462/11 | DANIEL VOGES | Shift: |  | Work Order #: | WO 2011 | 18175 | Work Type: | PM | Asset: | S2-4 | Procedure ID: | 115/113 | Start/Stop Time: | Hours: | 0.17 | WO Description: | LIVE ROLLER PM PERIOD
Comments: | THE FLAT BELT IS WORN AND TRACKING SIDE TO SIDE.  SOME OF THE BEARINGS ON ROLLERS ARE BAD AND WORN OUT, CAUSING THE ROLLERS TO [NAME] AND SPIN ERRATICALLY.  SEVERAL ROLLERS ARE DENTED.
Technician: | 462/11 | DANIEL VOGES | Shift: |  | Work Order #: | WO 2011 | 18190 | Work Type: | PM | Asset: | RELABEL 1 | Procedure ID: | 310/152 | Start/Stop Time: | Hours: | 0.17 | WO Description: | RELABEL STATION PM WEEKLY
Comments: | CLEANED PRINT HEAD AND PRINTED TEST LABEL.
Technician: | 462/11 | DANIEL VOGES | Shift: |  | Work Order #: | WO 2011 | 18173 | Work Type: | PM | Asset: | S2-1 | Procedure ID: | 113/113 | Start/Stop Time: | Hours: | 0.17 | WO Description: | Singulator Period PM
Comments: | A FEW ROLLERS HAVE SOME GOOD SIZED DENTS, BUT ARE FUCTIONAL.
Technician: | 462/11 | DANIEL VOGES | Shift: |  | Work Order #: | WO 2011 | 18176 | Work Type: | PM | Asset: | S2-6 | Procedure ID: | 115/113 | Start/Stop Time: | Hours: | 0.17 | WO Description: | LIVE ROLLER PM PERIOD
Comments: | THE FLAT BELT IS WORN AND TRACKING LEFT AND RIGHT.  THE ROLLERS ARE BENT AND DAMAGED AND A FEW HAVE BAD BEARINGS.
Technician: | 462/11 | DANIEL VOGES | Shift: |  | Work Order #: | WO 2011 | 18108 | Work Type: | PM | Asset: | [NAME] | Procedure ID: | 110/113 | Start/Stop Time: | Hours: | 0.17 | WO Description: | CHUTE PM PERIOD
Comments: | CHUTES ARE DIRTY AS WELL AS TRANSFER PLATES FROM THE SKATE WHEELS ARE BENT UPWARDS.
Technician: | 462/11 | DANIEL VOGES | Shift: |  | Work Order #: | WO 2011 | 18165 | Work Type: | PM | Asset: | QA1-1 | Procedure ID: | 100/113 | Start/Stop Time: | Hours: | 0.17 | WO Description: | CONVEYOR PM PERIOD
Comments:
Technician: | 462/11 | DANIEL VOGES | Shift: |  | Work Order #: | WO 2011 | 18106 | Work Type: | PM | Asset: | [NAME] | Procedure ID: | 110/113 | Start/Stop Time: | Hours: | 0.17 | WO Description: | CHUTE PM PERIOD
Comments: | CHUTES ARE DIRTY AS WELL AS TRANSFER PLATES FROM THE SKATE WHEELS ARE BENT UPWARDS.
Technician: | 462/11 | DANIEL VOGES | Shift: |  | Work Order #: | WO 2011 | 18191 | Work Type: | PM | Asset: | RELABEL 2 | Procedure ID: | 310/152 | Start/Stop Time: | Hours: | 0.17 | WO Description: | RELABEL STATION PM WEEKLY
Comments: | CLEANED PRINT HEAD AND PRINTED TEST LABEL.
Technician: | 462/11 | DANIEL VOGES | Shift: |  | Work Order #: | WO 2011 | 18192 | Work Type: | PM | Asset: | RELABEL 3 | Procedure ID: | 310/152 | Start/Stop Time: | Hours: | 0.17 | WO Description: | RELABEL STATION PM WEEKLY
Comments:
Technician: | 462/11 | DANIEL VOGES | Shift: |  | Work Order #: | WO 2011 | 18174 | Work Type: | PM | Asset: | S2-2 | Procedure ID: | 115/113 | Start/Stop Time: | Hours: | 0.17 | WO Description: | LIVE ROLLER PM PERIOD
Comments: | THE FLAT BELT IS WORN AND TRACKING SIDE TO SIDE.  tHE FIRST COUPLE OF ROLLERS THAT HAVE THE RUBBER GRIPPERS NEED TO BE REPLACED ALONG WITH THE RUBBER BANDS.  ONE ROLLER HAS A BAD BEARING AND RUNNING INTO THE OTHER CAUSING IT TO NOT SPIN AS [NAME].  THE RESULT IS PACKAGES GOING TO THE CENTER AND BEING RECIRCULATED.
Technician: | 462/11 | DANIEL VOGES | Shift: |  | Work Order #: | WO 2011 | 18167 | Work Type: | PM | Asset: | S1-9B | Procedure ID: | 100/113 | Start/Stop Time: | Hours: | 0.17 | WO Description: | CONVEYOR PM PERIOD
Comments: | TRACKING OF THE BELT IS GREAT
Technician: | 462/11 | DANIEL VOGES | Shift: |  | Work Order #: | WO 2011 | 18105 | Work Type: | PM | Asset: | NR1-15 | Procedure ID: | 106/113 | Start/Stop Time: | Hours: | 0.17 | WO Description: | GRAVITY ROLLER VISUAL INSPECTION
Comments: | COULD NOT TEST THE LANE 50 AND 75 PERCENT FULL PHOTOEYES.
Total Hours for | 462/11 | on | 2011-04-04 00:00:00 | 8.41