Spreadsheet: 582240d1531798551-extract-data-to-another-data-sheet-production-report-new-copy-malinda18751-
Sheet: DataBase

 |  |  | Production |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Damage |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Machine Break Down |  |  |  |  |  |  |  |  | Production Delay |  |  |  |  |  |  | Lost Man Power Hrs |  |  |  |  |  |  |  | Transfer Tag #
 |  |  | Date | Assembly Line | Order # | Ø | Product Description | Time Duration |  | Total Prod. hrs. | Rest hrs. | Actual Prod. Hrs. | 36500 | Output / hr. | % | Remarks | Allocated | Print | Scrape | Cutting | Assembly |  |  |  |  |  |  |  |  |  |  | Assembly - Total | Assemby Damage % | Rusted, QC & Other | Upside Down | Total Rejects | % | Machine | Time Duration |  | Total BD. hrs. | Rest hrs. | Actual [NAME] | Loss Production | Reason for the B'down |  | Time Duration |  | Total Delay hrs. | Rest hrs. | Actual [NAME] | Loss Production | Reason for the [NAME] |  |  |  |  |  |  |  |  | Components |  |  | Body Blanks
 |  |  |  |  |  |  |  | Start | Finish |  |  |  | Achieved Qty. |  |  |  |  |  |  |  | Notch | Rolling | Weld / Lock Seam | Powder | Beading / Inner Curling | Expand | Hammer | Neck-In | Flange | [NAME] | Seaming |  |  |  |  |  |  |  | Start | Finish |  |  |  |  |  |  | Start | Finish |  |  |  |  |  | Total | Present | Absence | Recruit | Resign | Late Present | Product Description | Loss Production | End | Ring | Lid |  | Date Helper | Line Helper
 | 1 |  | 2018-09-01 00:00:00 | General [NAME] 01 | 1234 | 111 | abche | 07:30:00 | 19:00:00 | 11.5 | 1.5 | 10 | 13500 | 1350 | 1 | * Order completed. | 10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 99 | 0.007333333333333333 | 15 | 16 | 136 | 0.01007407407407407 |  | 08:15:00 | 09:15:00 | 1 | 0.25 | 0.75 | 1012.5 |  |  | 08:15:00 | 09:15:00 | 1 | 0.25 | 0.75 | 759.375 |  | 64 | 60 | 5 | 1 | 2 | 2 |  | 12000 |  |  |  |  | 2018-09-01 00:00:00 | 1
 | 1
 | 1 |  |  | General [NAME] 02 | 2345 | 222 | bcdef | 07:30:00 | 17:15:00 | 9.75 | 1.5 | 8.25 | 6000 | 600 | 1.212121212121212 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  | 08:15:00 | 09:15:00 | 1 | 0.25 | 0.75 | 759 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-09-01 00:00:00 | 2
 | 1
 | 1 |  |  | General [NAME] 03 | 3456 | 333 | cdefg | 07:30:00 | 19:00:00 | 11.5 | 1.5 | 10 | 3000 | 400 | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-09-01 00:00:00 | 3
1 | 1 | 1 | 2018-09-02 00:00:00 | General [NAME] 01 | 4567 | 444 | defghi | 07:30:00 | 17:15:00 | 9.75 | 1.5 | 8.25 | 6000 | 700 | 1.038961038961039 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 2018-09-02 00:00:00 | 1
2 | 1
3 | 1 |  |  | General [NAME] 02 | 2345 | 222 | bcdef | 07:30:00 | 17:15:00 | 9.75 | 1.5 | 8.25 | 8000 | 850 | 1.140819964349376 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  | 08:15:00 | 09:15:00 | 1 | 0.25 | 0.75 | 759 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-09-02 00:00:00 | 2