Spreadsheet: 181000d1347894761-help-correcting-a-formula-that-pulls-data-from-a-separate-sheet-cage-act-tracking-sample-02-
Sheet: Data

CAGE ACT TRACKING
Employee Name | Completed By | Date | A | C | T | ACT | APP. | Pass All | Comments
Employee #01 | Supervisor #01 | 2012-08-07 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | None
Employee #02 | Supervisor #02 | 2012-08-08 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Good with guests.
Employee #03 | Supervisor #03 | 2012-08-08 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Always offers to help.
Employee #04 | Supervisor #04 | 2012-08-09 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | [NAME] and connected with our players.
Employee #05 | Supervisor #05 | 2012-08-10 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Uses her humor to connect.
Employee #06 | Supervisor #06 | 2012-08-18 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | New. Very professional.
Employee #07 | Supervisor #07 | 2012-09-02 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Great.
Employee #08 | Supervisor #08 | 2012-09-02 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Professional.
Employee #09 | Supervisor #09 | 2012-09-02 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | [NAME] and sincere.
Employee #10 | Supervisor #10 | 2012-09-03 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Connects with a great smile.
Employee #11 | Supervisor #11 | 2012-09-03 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Promoted to Tem Lead. Thanks consistently.
Employee #12 | Supervisor #12 | 2012-09-03 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Observed ACT'ing in ESM/Main Bank. Great.
Employee #13 | Supervisor #13 | 2012-09-03 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Acknowledges well.
Employee #14 | Supervisor #14 | 2012-09-03 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Professional interactions ACT'ing.
Employee #15 | Supervisor #15 | 2012-09-03 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | High volume ACT'ing due to Labor Day, good.
Employee #16 | Supervisor #01 | 2012-09-04 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Elite line, good ACT'ing.
Employee #17 | Supervisor #02 | 2012-09-05 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Main Bank ACT'ing. Good.
Employee #18 | Supervisor #03 | 2012-09-05 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | [NAME] is calm and quite. Pacific Rim guests particularly like her ACT'ing.
Employee #19 | Supervisor #04 | 2012-09-05 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Happy and smiling.
Employee #20 | Supervisor #05 | 2012-09-05 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Polite and real ACT'ing.
Employee #21 | Supervisor #06 | 2012-09-05 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | High volume ACT'ing due to Labor Day, good.
Employee #22 | Supervisor #07 | 2012-09-06 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | [NAME] just started his shift and was prepared to deliver.
Employee #23 | Supervisor #08 | 2012-09-06 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | [NAME] offered to enroll guest in Global VIP, guest was pleased.
Employee #24 | Supervisor #09 | 2012-09-06 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Observed in Chip Bank. Provided quick and efficient service.
Employee #25 | Supervisor #10 | 2012-09-06 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Good interaction.
Employee #26 | Supervisor #11 | 2012-09-06 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Always maintains friendly interaction with each and every guest.
Employee #27 | Supervisor #12 | 2012-09-06 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Quick to assist guests.
Employee #28 | Supervisor #13 | 2012-09-06 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Polite & pleasant. Greets each guest with a smile.
Employee #29 | Supervisor #14 | 2012-09-08 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Acknowlege guest with a smile. Had a good friendly conversation.
Employee #30 | Supervisor #15 | 2012-09-08 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Sophia did a great job. Greeted them, cashed them out quickly, wished luck.
Employee #31 | Supervisor #01 | 2012-09-08 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Great interaction, greeted them, good conversation and wished them luck.
Employee #32 | Supervisor #02 | 2012-09-08 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Greeted guest, asked how they were and wished them luck. Always pleasant even when the guest are aggitated.
Employee #33 | Supervisor #03 | 2012-09-08 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Very engaging with a big smile.
Employee #34 | Supervisor #04 | 2012-09-08 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Excellent interaction with guests. Great Service.
Employee #35 | Supervisor #05 | 2012-09-08 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Nice hustle with guest issues at the ATM's responded in a timel manner.
Employee #36 | Supervisor #06 | 2012-09-09 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Always cheerful and upbeat ready for service. Good job [NAME].
Employee #37 | Supervisor #07 | 2012-09-09 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Always ready to assist incoming guest at his window.
Employee #38 | Supervisor #08 | 2012-09-09 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Though it was a busy night Dy kept her smile on the whole night. DLee
Employee #39 | Supervisor #09 | 2012-09-10 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Made excellent eye-contact while making sure of all the guest's needs.
Employee #40 | Supervisor #10 | 2012-09-11 00:00:00 | Yes | Yes | No | No | Yes | No | Greeted the guest, but did not say thank you or wish good luck the to the guest.
Employee #41 | Supervisor #11 | 2012-09-11 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Dy demonstrated excellent service. She assisted a guess with her change.
Employee #42 | Supervisor #12 | 2012-09-12 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Greeted her guest, helped the guest do a cash advance, and thanked the guest.
Employee #43 | Supervisor #13 | 2012-09-12 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | [NAME] was great with her guest as always.
Employee #44 | Supervisor #14 | 2012-09-12 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | [NAME] is good at making his guests laugh. Great Job.
Employee #45 | Supervisor #15 | 2012-09-13 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Great guest service
Employee #46 | Supervisor #01 | 2012-09-12 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Greeted each guest and thanked/wished guest luck at the end of transaction.
Employee #47 | Supervisor #02 | 2012-09-14 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Engaged guest in conversation making the guest feel very welcomed. Excellent interaction.
Employee #48 | Supervisor #03 | 2012-09-14 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Very professional and made the it a fun experience for the guest.
Employee #49 | Supervisor #04 | 2012-09-15 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Answered her radio call professionally and in a timely manner for a guest inquiry.
Employee #50 | Supervisor #05 | 2012-09-15 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Greeted Elite Member to his window. Joked with guest and invited him back.
Employee #51 | Supervisor #06 | 2012-09-15 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Kind and Courteous. Kept Machines Up and Running to better service our guests.
Employee #52 | Supervisor #07 | 2012-09-15 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Big Inviting smiles! [NAME].
Employee #53 | Supervisor #08 | 2012-09-15 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Presentable and Big Smiles.
Employee #54 | Supervisor #09 | 2012-09-15 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Professional and Presentable in HL.