Spreadsheet: 180582d1347646320-re-writing-a-formula-to-remove-old-references-act-tracking-sample-
Sheet: Data

ACT CAGE TRACKING
Employee Name | Completed By | A | C | T | ACT | APP. | Pass All | Date | Comments
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-01 00:00:00 | good work
Employee #01 | Supervisor #01 | Yes | Yes | No | No | Yes | No | 2012-04-02 00:00:00 | no thank you
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-03 00:00:00 | good
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-04 00:00:00 | good work
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-05 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-06 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-07 00:00:00 | superstar&#9733;
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-08 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-09 00:00:00 | Great
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-10 00:00:00 | great job with guest
Employee #01 | Supervisor #01 | Yes | No | Yes | Yes | Yes | Yes | 2012-04-11 00:00:00 | good job mostly. remember to connect
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-12 00:00:00 | very well done
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-13 00:00:00 | very nicely done
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-14 00:00:00 | good employee
Employee #01 | Supervisor #01 | Yes | No | No | No | Yes | No | 2012-04-15 00:00:00 | make a better connection with guest
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-16 00:00:00 | nice work
Employee #01 | Supervisor #01 | No | Yes | Yes | No | Yes | Yes | 2012-04-17 00:00:00 | no eye contact
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-18 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-19 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-20 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-21 00:00:00 | very nice and friendly
Employee #01 | Supervisor #01 | Yes | Yes | No | No | Yes | No | 2012-04-22 00:00:00 | no thank you
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-23 00:00:00 | nice work
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-24 00:00:00 | nice job keep it up
Employee #01 | Supervisor #01 | Yes | No | Yes | No | Yes | No | 2012-04-25 00:00:00 | didn't connect with guest otherwise nice job
Employee #01 | Supervisor #01 | No | Yes | Yes | No | Yes | No | 2012-04-26 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-27 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-28 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-29 00:00:00 | so glad you hired this guy
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-30 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-01 00:00:00 | seemed bored
Employee #01 | Supervisor #01 | Yes | Yes | No | Yes | Yes | Yes | 2012-05-01 00:00:00
Employee #01 | Supervisor #01 | Yes | No | Yes | No | Yes | No | 2012-05-01 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-01 00:00:00 | nice
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-01 00:00:00 | greatful
Employee #01 | Supervisor #01 | Yes | Yes | No | No | Yes | Yes | 2012-05-01 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-01 00:00:00 | Nice Employee
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-01 00:00:00 | Great worker
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-01 00:00:00 | Great worker
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-01 00:00:00 | He is great
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | No | 2012-05-01 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | No | No | 2012-05-25 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | No | No | 2012-05-25 00:00:00 | looked dirty
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-25 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-25 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-25 00:00:00 | ok
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-25 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-25 00:00:00 | Hard worker
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-25 00:00:00 | Very good
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | No | No | 2012-05-25 00:00:00 | crazy hair color
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-25 00:00:00 | nice job
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00 | fun person
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00 | very great person
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00 | very nice job
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | No | No | Yes | No | 2012-06-02 00:00:00 | overall nice, no thank you
Employee #01 | Supervisor #01 | Yes | Yes | No | No | Yes | No | 2012-06-02 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00 | very nice person
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | No | Yes | Yes | 2012-06-02 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00 | sort-of-nice
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00 | Great
Employee #01 | Supervisor #01 | Yes | Yes | No | Yes | Yes | Yes | 2012-06-30 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | No | Yes | Yes | Yes | 2012-06-30 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | No | 2012-06-30 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00 | good employee
Employee #01 | Supervisor #01 | Yes | Yes | No | No | Yes | No | 2012-06-30 00:00:00 | remember to thank the guest
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00 | always smiling
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00 | awesome employee
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00 | very nice employee
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00 | what a fantastic person
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00 | reallynice
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00
Employee #01 | Supervisor #01 | No | Yes | Yes | No | Yes | No | 2012-07-03 00:00:00 | Look up when a guest walks in
Employee #01 | Supervisor #01 | Yes | No | Yes | No | No | No | 2012-07-03 00:00:00 | worthless employee
Employee #01 | Supervisor #01 | No | No | No | No | No | No | 2012-07-03 00:00:00 | I can't believe you hired this guy
Employee #01 | Supervisor #01 | Yes | Yes | No | No | No | No | 2012-07-03 00:00:00 | what an idiot
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00 | rude
Employee #01 | Supervisor #01 | Yes | Yes | No | No | Yes | No | 2012-07-03 00:00:00 | Not nice
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00 | ok
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00 | nice
Employee #01 | Supervisor #01 | Yes | Yes | No | No | Yes | No | 2012-07-03 00:00:00 | make sure you thank the guest
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00 | well done
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00 | nice job
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00 | nice work
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00 | what a great person
Employee #01 | Supervisor #01 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00 | nice overall