Spreadsheet: 707702d1607426776-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.
5003 | The Farm | 2020-02-23 00:00:00 | [NAME] | I | GOT A BAD REVIEW FROM TENANT. SAID AGENT WHO TOOK HER INFORMATION SEEMED DISINTERESTED AND DID NOT SEEM TO HAVE A SENSE OF URGENCY. WAS NOT HAPPY WITH AFTER HRS SERVICE. |  | [NAME] THAT THE AGENT WAS PROFESSIONAL AND TOOK THE INFORMATION IN A CALM MANNER AND DISPATCHED CORRECTLY. WILL SEND HER THE RECORDINGS.
8138 | Lake Norman Med Group | 2020-05-01 00:00:00 | [NAME] | I | [NAME] WAS NOT SATISFIED WITH THE WAY THE LEAD HANDLED HIS CONVERSATION WHEN HE CALLED TO ADDRESS THE ISSUE REGARDING THE NON-ER THAT WAS DISPATCHED. |  | CONTINUED...[NAME] AND RUDE, THEN REQUESTED TO SPEAK TO HER SUPERVISOR. THE LEAD DID NOT DO ANYTHING OUT OF THE WAY IN HANDLING THE CALL. **CLOSED**
6128 | Brookdale Home Health | 2020-05-30 00:00:00 | [NAME] | I | PHONE NUMBER FOR TAMILIA W/ REX HOSPITAL IS INCORRECT |  | PHONE NUMBER FOR TAIMILA W/ REX HOSPITAL IS INCORRECT, BUT OPERATOR DID VERIFY. PUT IN [PHONE] & INSTEAD IT SHOULD BE [PHONE]
2009 | Pintail D&C | 2020-02-10 00:00:00 | [NAME] | V | WAS UPSET DUE TO CALL TAKEN ON 2/7 AT 6:20P.  SAID [NAME] CLIENT THAT SHE WOULD HAVE SOMEONE GET BACK WITH HER. DURING.           HRS OF 7A-7P. WE PATCH ALL CALLS | 1-3 | AFTER REVIEWING CSR TOLD CALLER SHE HAVE SOMEONE GET BACK TO THEM. PER DISPATCH WE TAKEN INFO DURING OFC HRS AND PATCH TO ONCALL. WRITE UP.
2408 | [NAME] | 2020-05-13 00:00:00 | [NAME] | V | QUOTE FOR CUSTOMER [NAME] WAS INCORRECT - AGENT DID NOT DO CORRECT ESTIMATE PROCEDURE FOR AREA RUG. | 2-4 | AGENT CONFIRMED [NAME] WITH CUSTOMER WHEN HE CALLED 2ND TIME TO SCHEDULE HIS APPT AGENT ALSO DID NOT OBTAIN SIZE FOR AREA RUG, CONFIRMED WRONG QUOTE AND SCHEDULED JOB WITH INCORRECT PRICE.
445 | Servp. New Haven | 2020-06-25 00:00:00 | [NAME] | V | EMAILED IN REGARDING WHY HE HAD NOT RECEIVED EMAIL ON CALL FROM NORMAN GOODMAN. BEING REVIEWED |  | OPERATOR HAD FORGOTTEN TO SUSPEND THE TICKET PRIOR TO SAVING SO THE EMAIL WOULD SEND TO THE ONCALL. HAS SINCE BEEN FIXED, EMAILED HAS BEEN SENT. COMPLAINT IS GOING INTO FOLDER