Spreadsheet: 108279d1305299015-summing-ranges-in-workbook-based-on-matching-values-timesheet-sum-test
Sheet: 5-12

 |  |  |  |  | Craft Timesheet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day | THURSDAY |  |  |  | RUNNING TOTALS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | 2011-05-12 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shift | DAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W/E | 2011-05-15 00:00:00
 |  |  |  |  | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | SATURDAY |  |  |  | MEAL TICKET | TOTALS
 | Craft:
 | [NAME]:
 | Signature:
 |  |  | PO No.
 |  |  | PHASENo.
 |  |  | WO No.
 | W.O. | Description | Area |  | ST |  | OT |  | ST |  | OT |  | ST |  | OT |  | ST |  | OT |  | ST |  | OT |  | ST |  | OT |  |  | ST | OT
 | 2844104 | Alky Replace 8" OverFlow to CT-2 |  | 1A |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 | 2571301 | FCC Replace 1" 190# Steam line |  | 1A | 0 |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | 2897447 | CCR Replace Plug vlv lever ,Bottom of 84-D-5 |  | 1B | 0
 | 2907848 | CCR New Pilot Gas Strainer |  | 1B | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2934976 | CCR Replace FV-978 Control Vlv & pipe |  | 1B | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2788589 | CCR Replace Disch.Spool on 83-G-206 |  | 1B | 0 |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | 2994267 | CCR Replace Check Vlv at 83-G-7A |  | 1B | 0 |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | 3063190 | CCR Remove & Replace 2"Saftey Vlv.83-D-18 |  | 1B | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 3064458 | FGDU Replace 400# Steam Trap |  | 1B | 0 |  |  |  | 0.75 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.25
 | 3070434 | H2 Replace 3" Boiler Feed Water Pipe |  | 2A |  |  |  |  |  |  |  |  | 1.5
 | 3080530 | CHD 2 Replace 2" Condesate Line Pipe Rack |  | 2A |  |  |  |  | 1.75 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.25
 | 2543161 | MLDW 17D-18A Replace [NAME] |  | 2A |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 | 2543242 | MLDW 17D-18B Replace [NAME] |  | 2A |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 | 2797211 | [NAME]" Stm Line to Hyd.Gear |  | 2A | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | 3038121 | MLDW 4" Jumpover from P30 to Rundown |  | 2A | 2 |  |  |  | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.5
 | 3088572 | MLDW Install 1" spray pipe under E6 & 7 |  | 2A
 | 3094812 | MLDW Replace 14"Gate Vlv to CT-14 Pump |  | 2A | 1.75 |  |  |  | 2 |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 | 3099300 | MLDW Repack Steam Header Valves |  | 2A | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0.75 |  |  |  | 0
 | 2990102 | FURF I Add 1"Nitrogen Line for Pump Seal |  | 2B | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | 3048778 | FURF II Replace 2"Pipe w/4"Pipe |  | 2B |  |  |  |  |  |  |  |  | 1.5 |  |  |  | 0.25
 | 2951512 | PDA Replace 1-1/2"Spool top of TE-19 |  | 2B |  |  |  |  | 0
 | 3097311 | PDA Fabricate Plate for CT-3 |  | 2B |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | 3056210 | CU7 3" Over Flash Repair |  | 3B
 | 3049541 | CU 7 3" SS Vent D-101 |  | 3B | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 | 2938672 | Coker Replace Back wash Piping |  | 3A | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2820859 | COKER Piping Demo 30-k-3 |  | 3A | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | 2956445 | COKER Repair G-308  Pmp  Clg.Wtr Pipe |  | 3A | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | 3099300 | Coker Replace 6" Spool to Transfer Pump |  | 3A | 0 |  |  |  | 0 |  |  |  | 0.75 |  |  |  | 2 |  |  |  | 0
 | 2963385 | Utilities Replace spool on N2 skid |  | 4A | 0 |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | 2951429 | Utilities Replace 900# [NAME] |  | 4A | 0 |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | 2797219 | CHD1 Replace 2" By-pass Gt Vlv w/Globe |  | 6A | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2820191 | CHD1 Replace 4" 300# [NAME] |  | 6A | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 3039313 | CHD1  Replace 4" CT-9  Level Indicator Sheild |  | 6A |  |  |  |  | 1.25 |  |  |  | 0.5
 | 2894288 | SRU TGU STM Header & Demo |  | 6A | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | 3044600 | TGU1 Replace 2"Pipe to 80-LC-427 SS |  | 6A
 | 2920795 | WOM Replace 18"Transfer spool from TK74 |  | 6A | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | 3090413 | WOM K&A UG Water Leak |  | 6A | 0.25 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 1
 | 3048607 | EOM Change 12" Gasoline Pump Suct./Disch. |  | 6B
 | 2844963 | EOM G-4907 Pump Discharge spool |  | 6B |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2749315 | EOM TK-2940 4" [NAME]. Piping Fabrication |  | 6B |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 | 2656551 | EOM-LPG 23-D-4 Dead Leg Removal |  | 6B |  |  |  |  | 1.25
 | 2656801 | EOM-LPG Ldg.Rack Dead Leg Removal |  | 6B
 | 3038187 | PO:[PHONE] Ph:C1111 [NAME].Load.Arm |  | 6B
 | 11MK0191 | Nu Star Fab |  | * | 1 |  |  |  | 0.5 |  |  |  | 0.75
 |  | HOLIDAY |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Circle or [NAME] Time
 | NOTE: | If filling out time sheet by computer when employee is ABSENT please put a "ZERO" over the number to the left of their name.
 |  | If filling out sheet manually |  |  |  | number to the left of their name.