Spreadsheet: 867533d1714388286-updating-excel-data-from-another-spreadsheet-with-a-single-cell-reference-workbook-1
Sheet: Main DT Report

INPUT DATA TO THE YELLOW & Blue HIGHLIGHTED CELLS
Week
Year | 2024
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70762
Day | Production | Agri | Maintenance | Hygiene | IT | Diff | Other | Total DT | Running Time | % DT | % DT Due to Engineering | Reasons: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70137
Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67723
Tue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72504
Wed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72702
Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71054
Fri |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70749
Sat
Sun
Total DT
Day | Start Time | Finish Time (Kill) | Finish Time (Chills) | Birds Killed
Mon | 04:00:00 | 14:54:00 |  | 72811 |  |  |  |  |  |  |  | Mon
Tue | 04:00:00 | 14:10:00 |  | 70527 |  |  |  |  |  |  |  | Tue
Wed | 04:00:00 | 15:30:00 |  | 74423 |  |  |  |  | Production | Other |  | Wed
Thu | 04:00:00 | 15:26:00 |  | 74402 |  |  |  |  | Reason = paste formula |  |  | Thu
Fri | 04:00:00 | 14:50:00 |  | 74458 |  |  |  |  |  |  |  | Fri
Sat | 04:00:00 | 14:10:00 |  | 69754 |  |  |  |  |  |  |  | Sat
Sun | 04:00:00 | 14:10:00 |  | 71389 |  |  |  |  |  |  |  | Sun
Daily Welfare Meetings - File |  |  |  |  | Total
Day | DT | Responsible Dept | Pre / Post Hang-On | Area | Reason | na | NA | Reason (DT) |  |  |  | Comments
Mon | 1 | Diff | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | . |  |  |  |  | Organic Birds
Mon | 15 | Maintenance | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | . |  |  |  |  | FR Birds
Mon | 27 | Production | Other | Other | Gaps for flock code separation | . | .
Mon | 1 | Diff | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | .
Mon | 1 | Maintenance | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | .
Mon | 1 | Diff | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | .
Mon | 1 | Maintenance | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | .
Mon | 1 | Diff | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | .
Mon | 1 | Maintenance | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | .
Mon | 1 | Diff | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | .
Tue | 20 | Production | Other | Other | Gaps for flock code separation | . | .
Tue | 1 | Diff | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | . |  |  |  |  | FR Birds
Tue | 1 | Maintenance | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | . |  |  |  |  | FR Birds
Tue | 1 | Diff | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | . |  |  |  |  | CF Birds
Tue | 1 | Diff | Post | Lairage | Auto Killer | . | . |  |  |  |  | CF Birds
Tue | 1 | Diff | Post | Lairage | Auto Killer | . | .
Tue | 1 | Diff | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | .
Tue | 1 | Maintenance | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | .
Tue | 5 | Diff | Pre | Lairage | [NAME] | . | . |  |  |  |  | Gas Chamber Empty
Wed | 20 | Production | Other | Other | Gaps for flock code separation | . | .
Wed | 1 | Diff | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | . |  |  |  |  | trec
Wed | 13 | Maintenance | Post | EV | Process 2 stoppage | . | . |  |  |  |  | chill line / rehanger 3
Wed | 5 | Diff | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | . |  |  |  |  | TREC
Wed | 10 | IT | Pre | Lairage | Basket Stuck | . | . |  |  |  |  | BACK LIFT
Wed | 4 | Maintenance | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | . |  |  |  |  | TREC
Thu | 20 | Production | Other | Other | Gaps for flock code separation | . | .
Thu | 20 | Maintenance | Post | EV | Basketwash (maintenance) | . | . |  |  |  |  | SENSOR
Thu | 5 | Diff | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | .
Thu | 5 | IT | Pre | Lairage | Basket Stuck | . | .
Thu | 6 | IT | Pre | Lairage | [NAME] module | . | .
Thu | 5 | IT | Pre | Lairage | Basket Stuck | . | .
Thu | 5 | Maintenance | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | .
Fri | 24.99999999999999 | Production | Other | Other | Gaps for flock code separation | . | .
Fri | 1 | Diff | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | . |  |  |  |  | CF BIRDS
Fri | 4 | Diff | Post | Defeathering | Re-hang 1 - JCA | . | . |  |  |  |  | Rehanger Jammed
Fri | 1 | Maintenance | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | .
Fri | 12 | Agri | Post | EV | Agri | . | . |  |  |  |  | No Birds on site
Sat | 1 | Diff | Post | Lairage | Auto Killer | . | .
Sat | 1 | Diff | Post | EV | Re-hang 1 - JCA
Sat | 20 | Production | Other | Other | Gaps for flock code separation
Sat | 3 | IT | Pre | Lairage | Bab basket stuck |  |  | bad basket
Sat | 4 | Diff | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) |  |  | re-Hanger 2:- bad transfer
Sat | 5 | IT | Pre | Lairage | Basket Stuck |  |  | basket stuck lift
Sat | 4 | Maintenance | Post | EV | Re-Hanger 2: - Bad transfer (Leg behind lifter) | . | .
Sun | 5 | Diff | Pre | Lairage | Basket Stuck | . | . | Bad basket
Sun | 3 | Diff | Post | Lairage | Re- hanger 2:- Bad transfer |  |  | Re- hang 2
Sun | 3 | Maintenance |  | EV | Re- hanger 2:- Bad transfer |  |  | Re- hang 2
Sun | 20 | Production | Other | Other | Gaps for flock code separation
Sun | 5 | Agri | Other | Other | No birds on site |  |  | No birds on site
Sun | 5 | Diff | Post | Other | Bad basket stuck in reloader |  |  | bad basket