Spreadsheet: 736230d1623424804-copy-and-combining-duplicate-data-carllogsdon
Sheet: Sheet 2

ECI Year | ECI Mon | ECI Seq | ECI Date | [NAME]? | Mag# | Job# | [NAME] | Job Open | Job Close | Title | Issue | Original          Issue | Credit? | Cust# | Customer | Splg Cost | Splg Cost * 90% | Splg Labor | [NAME] * 60% | Credit Amt | Total Cost | Originating Department | CC# | Cost Center Desc | Shift | QC Error Desc | CSR Error Desc 1 | CSR Error Desc 2 | CSR Error Desc 3 | CSR Error Desc 4 | Corrective Action | Error Discription
2021 | 1 | 14 | 2021-01-11 00:00:00 | Yes | 50545 | 2014 | 2021 | 2021-01-18 00:00:00 | 2021-04-16 00:00:00 | AJC | SPL2014 | 2021-02-01 00:00:00 | No | 535 | ELSEVIER INC | 0.6 | 0.54 | 0 | 0 | 0 | 0.54 | LJ SHIP & MAIL | 650 | SHIPPING DPT-LJ | 0 | INCORRECT SHIPMENT | No form printing | This spoilage is for shipping | adv copies were sent w/no tip | sending off copies back out | 33 copies resent - Positive Counseling given Formal reminder
2021 | 1 | 14 | 2021-01-11 00:00:00 | Yes | 50545 | 2014 | 2021 | 2021-01-18 00:00:00 | 2021-04-16 00:00:00 | AJC | SPL2014 | 2021-02-01 00:00:00 | No | 535 | ELSEVIER INC | 0.6 | 0.54 | 0 | 0 | 0 | 0.54 | LJ SHIP & MAIL | 650 | SHIPPING DPT-LJ | 0 | INCORRECT SHIPMENT | No form printing | This spoilage is for shipping | adv copies were sent w/no tip | sending off copies back out | 33 copies resent - Positive Counseling given Formal reminder
2021 | 2 | 55 | 2021-02-25 00:00:00 | Yes | 27232 | 2046 | 2021 | 2021-02-12 00:00:00 | 2021-02-19 00:00:00 | CP | SPL2046 | FEB | No | 854 | MINING MEDIA, INC. | 102.56 | 92.3 | 0 | 0 | 0 | 92.3 | LJ SHIP & MAIL | 650 | SHIPPING DPT-LJ | 0 | INSTRUCTIONS NOT FOLLOWED | Shipping error | Reshipping office copies. | Copies were sent without tip. | ****Nothing is reprinting**** | No QC person working that night, Shipping clerk pulled in the load from QC, Checked the mags that needed to ship and missed that it did not have the tip on procover. The Shift coordinator pulled a check book to process the rest of the job caught that they needed tip. Had them tipped and resent the specials do to UPS picked up the advance shipment before it was caught that it needed tip. Had plenty of mags so the customer recieved 1 set with and 1 without the tip on procover.
2021 | 2 | 55 | 2021-02-25 00:00:00 | Yes | 27232 | 2046 | 2021 | 2021-02-12 00:00:00 | 2021-02-19 00:00:00 | CP | SPL2046 | FEB | No | 854 | MINING MEDIA, INC. | 102.56 | 92.3 | 0 | 0 | 0 | 92.3 | LJ SHIP & MAIL | 650 | SHIPPING DPT-LJ | 0 | INSTRUCTIONS NOT FOLLOWED | Shipping error | Reshipping office copies. | Copies were sent without tip. | ****Nothing is reprinting**** | No QC person working that night, Shipping clerk pulled in the load from QC, Checked the mags that needed to ship and missed that it did not have the tip on procover. The Shift coordinator pulled a check book to process the rest of the job caught that they needed tip. Had them tipped and resent the specials do to UPS picked up the advance shipment before it was caught that it needed tip. Had plenty of mags so the customer recieved 1 set with and 1 without the tip on procover.
2021 | 3 | 55 | 2021-03-26 00:00:00 | No | 32676 | 32678 | 2021 | 2020-12-01 00:00:00 | 2021-03-15 00:00:00 | HCI | MAR-APR |  | No | 279 | ENDEAVOR BUSINESS MEDIA LLC |  |  |  |  | 0 | 0 | LJ SHIP & MAIL | 650 | SHIPPING DPT-LJ | 1 | WRONG MAIL LABELS
2021 | 3 | 55 | 2021-03-26 00:00:00 | No | 32676 | 32678 | 2021 | 2020-12-01 00:00:00 | 2021-03-15 00:00:00 | HCI | MAR-APR |  | No | 279 | ENDEAVOR BUSINESS MEDIA LLC |  |  |  |  | 0 | 0 | LJ SHIP & MAIL | 650 | SHIPPING DPT-LJ | 1 | WRONG MAIL LABELS
2021 | 5 | 9 | 2021-05-07 00:00:00 | No | 27232 | 27234 | 2021 | 2021-01-11 00:00:00 | 2021-02-12 00:00:00 | CP | FEB |  | No | 854 | MINING MEDIA, INC. |  |  |  |  | 0 | 0 | LJ SHIP & MAIL | 650 | SHIPPING DPT-LJ | 0 | BOOKS NOT SHIPPED
2021 | 5 | 9 | 2021-05-07 00:00:00 | No | 27232 | 27234 | 2021 | 2021-01-11 00:00:00 | 2021-02-12 00:00:00 | CP | FEB |  | No | 854 | MINING MEDIA, INC. |  |  |  |  | 0 | 0 | LJ SHIP & MAIL | 650 | SHIPPING DPT-LJ | 0 | BOOKS NOT SHIPPED
2021 | 6 | 4 | 2021-06-03 00:00:00 | No | 59494 | 59495 | 2021 | 2021-05-10 00:00:00 | 2001-01-01 00:00:00 | TLIC | MAY |  | No | 2139 | FAITH CATHOLIC |  |  |  |  | 0 | 0 | LJ SHIP & MAIL | 650 | SHIPPING DPT-LJ | 1 | INSTRUCTIONS NOT FOLLOWED
2021 | 6 | 4 | 2021-06-03 00:00:00 | No | 59494 | 59495 | 2021 | 2021-05-10 00:00:00 | 2001-01-01 00:00:00 | TLIC | MAY |  | No | 2139 | FAITH CATHOLIC |  |  |  |  | 0 | 0 | LJ SHIP & MAIL | 650 | SHIPPING DPT-LJ | 1 | INSTRUCTIONS NOT FOLLOWED