Spreadsheet: 707606d1607361811-separating-data-and-counting-the-data-on-a-different-spreadsheet-lesia-test
Sheet: Complaints -20

Account # | Account Name | Date | Operator | Valid/Invalid (use only V or I) | Complaint | Law - Infraction # | Resolution
132 | Blue Ridge Energy | 2020-03-09 00:00:00 | [NAME] | I | PHONE NUMBER ON CAROL PARKER IS INCORRECT |  | CALLER GAVE # IN MESSAGE AND AGENT REPEATED - NON COMPLAINT CALLER DID SAY THIS WAS A NEW # - SHE GAVE IT INCORRECTLY
8144 | [NAME] | 2020-07-11 00:00:00 | [NAME] | V | [NAME] STATES THE PHONE NUMBER FOR BLANCA DIZON IS NOT CORRECT |  | [NAME] TO CALL AND PHONE NUMBER IS NOT CORRECT. REPRIMAND TO BE GIVEN.
2425 | Konica Minolta | 2020-01-09 00:00:00 | Beverly Michaux | I | THE PHONE NUMBER FOR CALLER [NAME] WAS GOING TO THE I.T DEPARTMENT AND ISNT CORRECT. |  | AFTER REVIEWING. THE CALLER DID GIVE THE PHONE NUMBER THAT IS IN TICKET. THE OPERATOR REPEATED THE WHOLE PHONE NUMBER INCLUDING THE EXTENSION - NO WRITE UP
6127 | Bsyada Home Health | 2020-08-25 00:00:00 | Beverly Michaux | V | CALLED IN AND SAID THIS PT IS IN A FACILITY NOT AT HOME. WILL LISTEN TO CALL. |  | [NAME] TO CALL. [NAME] WAS NOT ASKED PROPERLY. CSR WILL BE REPRIMANDED.
421 | Protective Security | 2020-09-23 00:00:00 | [NAME] | I | PHONE # NOT WORKING |  | [NAME] TO CALL FROM SUSAN PORTER. NUMBER IS CORRECT NO REPRIMAND
8152 | LN Med Associates | 2020-05-24 00:00:00 | [NAME] | O | RE: [NAME] 1ST CALL: DR WAS NOT NOTIFIED UNTIL 2ND CALL | 101
1964 | Airgas | 2020-05-18 00:00:00 | [NAME] Beverly Michaux | V | THE FIRST OPERATOR DID TAKE A NUMBER FROM CALLER BUT DID NOT PUT INTO SALESFORCE, THE DISPATCHER, DIDNT CHECK BEFORE DISPATCHING THE CASE. REPRIMAND FOR BOTH OPERATORS |  | RESPONDED TO A CASE, WONDERING WHY THERE WAS NO PHONE NUMBER ONYX HANDLING-CASE #520160
8135 | Hospice of Iredell | 2020-10-22 00:00:00 | Chasity [NAME] | V | DEBBIE MANUS TAKEN AT 5:16P: PHONE NUMBER IS TO THE OFFICE  NOT THE PATIENTS. |  | Agent read phone number from caller ID and caller agreed to the number.  However the agent did not clarify to caller if it was the call back number or the number she was dialing.  Agent should have asked caller for the correct call back number.
5964 | Serv. - Tri-County | 2020-04-05 00:00:00 | [NAME] | I | PHONE # FOR [NAME] TO TRY THE # BACK AT ANOTHER TIME AND NOT GOING THROUGH. WANTS TO CONFIRM # |  | ADVISED PHONE NUMBER (704)498-2132 IS CORRECT & OPERATOR DID VERIFY CORRECTLY. NON-COMPLAINT, COMPLAINT.
5019 | [NAME] | 2020-10-08 00:00:00 | [NAME] | V | REGARDING CALL FROM KELSEY ANDERSON ON 10/7 @ 9:59PM. SAYS AGENT CALLED HIS 2ND DIAL WHICH IS HIS WIFE INSTEAD OF HIS 1ST. DCL IS WORKING. ONYX WILL HANDLE ON 10/9 |  | THE DCL WAS WORKING PROPERLY, AGENT MUST HAVE JUST CHOSEN THE 2ND DIAL. THE ONCALL WAS NOT CALLED FIRST. REPRIMAND HAS BEEN ISSUED
268 | Serv. - Vacaville | 2020-02-25 00:00:00 | [NAME] | I | STATE THE NUMBER IS INCORRECT FOR BARBARA TALLEY |  | OPERATOR DID REPEAT THE NUMBER AND THE CALLER DID NOT CORRECT HER EXCEPT FOR THE LAST 4 DIGITS SAID NOTHING ABOUT THE 749 BEING WRONG
5062 | Asheville Housing | 2020-01-27 00:00:00 | [NAME] | V | SENT IN VIA EMAIL - STATES 2 SEPARATE TICKETS - NEITHER ONE OF THE RESIDENTS RESIDE AT ASHEVILLE TERRACE APARTMENTS | 1-3 | THE MESSAGE WAS MANUALLY EMAILED INCORRECTLY TO ASHEVILLE TERRACE DUE TO IT NOT GOING OVER ON THE SCHEDULED DELIVERY. AGENT WILL BE REPRIMANDED.
132 | Blue Ridge Energy | 2020-11-16 00:00:00 | [NAME] | V | Agent had unfriendly tone and was particularly rude |  | Lesia will be going over soft skills with agent.  Agent did not sound inviting or friendly with caller
4071 | HCSC | 2020-01-15 00:00:00 | [NAME] | I | Did not receive copy of email from [NAME] |  | THE EMAILS WERE ONLY SUCCESSFULLY SENT TO COE-5 AND NO  ONE MANS THAT ADDRESS. MESSAGE WAS RESENT TO COE-1 AND SHE RCVD IT. SENT AN EMAIL TO NIK TO CONFIRM EMAIL ADDRESSES.
1070 | CEENTA - Main | 2020-09-26 00:00:00 | [NAME] | V | MSG 9/26 @ 8:09A FROM [NAME] A RETINA CALL NOT GEN EYE |  | AGENT DID NOT ASK THE SCRIPT QUESTION RE: GENERAL VS RETINA REPRIMAND IN FOLDER - MESSAGE WAS RERUN AND GIVEN TO CORRECT ON CALL
1959 | BCI | 2020-02-03 00:00:00 | [NAME] | I | CALL ON 1/24 FROM JERRY COATES. [NAME] SAID FOWLER  & SONS NEVER GOT A WORK ORDER NUMBER.  MARTHA WANTED THE RECORDING PULLED, ONYX REVIEWING |  | AFTER REVIEWING, OPERATOR DID COLLET THE W/O#. WHEN CSR CALLED TECH HE ASKED FOR NAME OF STORE, STORE NUMBER AND THE ISSUE, THEN SAID ILL HANDLE AND THEN HUNG UP. SEE COMMENTS
5010 | Kindred | 2020-04-13 00:00:00 | [NAME] | I | FIRST MSSG FROM VIRGINIA JONES, PHONE NUMBER IS INCORRECT. |  | OPERATOR READ BACK PHONE NUMBER WITH 664, INSTEAD OF 264, CALLER DID AGREE. NON COMPLAINT, COMPLAINT. [NAME].
397 | Servp - Hunt Valley | 2020-06-06 00:00:00 | HOLD TIMES | V | WAS UPSET BECAUSE HE WAS ASKED TO HOLD. WAS EXTREMELY UPSET I NEVER GOT A CHANCE TO TRY AND FIX THE ISSUE. HE TOLD ME TO | 200 | 43 HAS BEEN PLACED FOR A DO NOT PARK ACCOUNT
2402 | AP - Pinehurst | 2020-06-09 00:00:00 | INC | O | PHYICIANS WANTING TO KNOW WHEY THEY RECEIVED A MSG SAYING CALLER DID NOT LEAVE MSG NO ACTION NEEDED. HAS HAD SEVERAL OF THESE WANTS TO KNOW IF THEY ARE BEING CHARGED |  | INCOMPLETE
1070 | CEENTA - Main | 2020-06-18 00:00:00 | INCOMPLETE | INC | RECEIVED A CALL THAT WAS MEANT FOR THE EYE TECH, REGARDING PT BY THE NAME OF BESSIE. CALL IS BEING REVIEWED. |  | INCOMPLETE