Spreadsheet: 167558d1342024661-expanding-a-formula-to-display-content-on-more-variables-actcasinotracking-expanded-3-
Sheet: Data

ACT Casino Tracking
Shopper Dept | Shopper Last Name | Shopper EID | TM Dept | TM Last Name | TM EID | A | C | T | ACT | Appearance | Pass All | Date | Comments
F&B EDR/TMDR | Bila | 1711 | Poker | Harvey | 5611 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-01 00:00:00 | good work
F&B EDR/TMDR | Bila | 1711 | Poker | [NAME] | 571 | Yes | Yes | No | No | Yes | No | 2012-04-02 00:00:00 | no thank you
F&B EDR/TMDR | Bila | 1711 | Poker | Hord | 5811 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-03 00:00:00 | good
F&B EDR/TMDR | Bila | 1711 | Poker | Johnston | 5911 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-04 00:00:00 | good work
[NAME] | [NAME] | 7777 | F&B Stewards | Campbell | 3111 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-05 00:00:00
EVS | Froid | 4444 | Poker | Harvey | 5611 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-06 00:00:00
F&B EDR/TMDR | Giertych | 1911 | Poker | [NAME] | 5911 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-07 00:00:00 | superstar&#9733;
EVS | Hyde | 3333 | [NAME] | [NAME] | 4511 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-08 00:00:00
[NAME] | [NAME] | 2422 | Security | [NAME] | 6811 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-09 00:00:00 | Great
[NAME] | [NAME] | 2422 | F&B Stewards | Campbell | 3111 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-10 00:00:00 | great job with guest
EVS | Doe | 2222 | F&B Stewards | Campbell | 3111 | Yes | No | Yes | Yes | Yes | Yes | 2012-04-11 00:00:00 | good job mostly. remember to connect
EVS | Doe | 2222 | F&B Stewards | Fisher | 3211 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-12 00:00:00 | very well done
EVS | Doe | 2222 | F&B Stewards | [NAME] | 3311 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-13 00:00:00 | very nicely done
EVS | Doe | 2222 | F&B Stewards | Hall | 3411 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-14 00:00:00 | good employee
EVS | Doe | 2222 | F&B Pearl | Bullock | 3711 | Yes | No | No | No | Yes | No | 2012-04-15 00:00:00 | make a better connection with guest
EVS | Doe | 2222 | F&B Pearl | Buss | 3711 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-16 00:00:00 | nice work
F&B EDR/TMDR | Giertych | 1911 | Security | [NAME] | 6711 | No | Yes | Yes | No | Yes | Yes | 2012-04-17 00:00:00 | no eye contact
EVS | Hyde | 3333 | [NAME] | [NAME] | 4511 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-18 00:00:00
F&B Beverage | Valdez | 1511 | Security | martinez | 6911 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-19 00:00:00
[NAME] | Adair | 2522 | Security | [NAME] | 6811 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-20 00:00:00
[NAME] | Adair | 2522 | Security | [NAME] | 1268 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-21 00:00:00 | very nice and friendly
F&B EDR/TMDR | Bila | 1711 | F&B Stewards | Hall | 3411 | Yes | Yes | No | No | Yes | No | 2012-04-22 00:00:00 | no thank you
[NAME] | [NAME] | 2422 | F&B Stewards | Fisher | 3211 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-23 00:00:00 | nice work
[NAME] | [NAME] | 2422 | F&B Pearl | [NAME] | 3311 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-24 00:00:00 | nice job keep it up
[NAME] | [NAME] | 2422 | F&B Stewards | Hall | 3411 | Yes | No | Yes | No | Yes | No | 2012-04-25 00:00:00 | didn't connect with guest otherwise nice job
[NAME] | [NAME] | 7777 | [NAME] | Curtis | 4611 | No | Yes | Yes | No | Yes | No | 2012-04-26 00:00:00
F&B EDR/TMDR | Giertych | 4321 | F&B Stewards | Fisher | 3211 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-27 00:00:00
EVS | Hyde | 3333 | [NAME] | [NAME] | 4511 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-28 00:00:00
[NAME] | Lopez | 6666 | Security | Matson | 6011 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-29 00:00:00 | so glad you hired this guy
[NAME] | [NAME] | 2622 | Security | [NAME] | 6711 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-04-30 00:00:00
F&B EDR/TMDR | Bila | 1711 | F&B Pearl | [NAME] | 1234 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-01 00:00:00 | seemed bored
F&B Beverage | [NAME] | 1411 | Poker | [NAME] | 5711 | Yes | Yes | No | Yes | Yes | Yes | 2012-05-01 00:00:00
[NAME] | [NAME] | 7777 | [NAME] | Curtis | 4611 | Yes | No | Yes | No | Yes | No | 2012-05-01 00:00:00
F&B EDR/TMDR | Falco | 1811 | [NAME] | Emery | 4811 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-01 00:00:00 | nice
F&B EDR/TMDR | Falco | 1811 | [NAME] | [NAME] | 4511 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-01 00:00:00 | greatful
EVS | Froid | 4444 | F&B Stewards | Hall | 3411 | Yes | Yes | No | No | Yes | Yes | 2012-05-01 00:00:00
EVS | Smith | 1111 | F&B Stewards | Campbell | 3111 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-01 00:00:00 | Nice Employee
EVS | Smith | 1111 | F&B Stewards | Fisher | 3211 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-01 00:00:00 | Great worker
EVS | Smith | 1111 | F&B Stewards | [NAME] | 3311 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-01 00:00:00 | Great worker
EVS | Smith | 1111 | F&B Stewards | Hall | 3411 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-01 00:00:00 | He is great
F&B Beverage | Valdez | 1511 | F&B Pearl | Bullock | 3711 | Yes | Yes | Yes | Yes | Yes | No | 2012-05-01 00:00:00
F&B EDR/TMDR | Bila | 1711 | [NAME] | Ellis | 4711 | Yes | Yes | Yes | Yes | No | No | 2012-05-25 00:00:00
[NAME] | [NAME] | 2422 | Security | [NAME] | 1268 | Yes | Yes | Yes | Yes | No | No | 2012-05-25 00:00:00 | looked dirty
F&B Beverage | [NAME] | 1411 | Poker | [NAME] | 5911 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-25 00:00:00
EVS | Froid | 4444 | F&B Stewards | [NAME] | 3311 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-25 00:00:00
[NAME] | [NAME] | 2622 | Security | Matson | 6011 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-25 00:00:00 | ok
[NAME] | [NAME] | 2622 | F&B Stewards | Hall | 3411 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-25 00:00:00
[NAME] | [NAME] | 5555 | F&B Pearl | Agee | 3511 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-25 00:00:00 | Hard worker
[NAME] | [NAME] | 5555 | F&B Pearl | Araza | 3611 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-25 00:00:00 | Very good
[NAME] | [NAME] | 5555 | F&B Pearl | Bullock | 3711 | Yes | Yes | Yes | Yes | No | No | 2012-05-25 00:00:00 | crazy hair color
[NAME] | [NAME] | 5555 | F&B Pearl | Buss | 3811 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-05-25 00:00:00 | nice job
F&B Beverage | Adams | 1211 | [NAME] | [NAME] | 4511 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00 | fun person
F&B Beverage | Adams | 1211 | [NAME] | Ellis | 4711 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00 | very great person
F&B Beverage | Adams | 1211 | [NAME] | Emery | 4811 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00 | very nice job
F&B EDR/TMDR | Bila | 1711 | [NAME] | Ellis | 4711 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00
F&B Beverage | [NAME] | 1411 | Security | martinez | 6911 | Yes | Yes | No | No | Yes | No | 2012-06-02 00:00:00 | overall nice, no thank you
EVS | Froid | 4444 | F&B Stewards | Hall | 3411 | Yes | Yes | No | No | Yes | No | 2012-06-02 00:00:00
F&B EDR/TMDR | Giertych | 1911 | [NAME] | Curtis | 4611 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00 | very nice person
F&B EDR/TMDR | Giertych | 4321 | F&B Stewards | [NAME] | 3311 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00
[NAME] | Park | 8888 | Security | Matson | 6011 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00
EVS | Smith | 1111 | F&B Pearl | Agee | 3511 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00
EVS | Smith | 1111 | F&B Pearl | Araza | 3611 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00
EVS | Smith | 1111 | [NAME] | [NAME] | 4511 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00
F&B Beverage | Valdez | 1511 | F&B Pearl | Buss | 3811 | Yes | Yes | Yes | No | Yes | Yes | 2012-06-02 00:00:00
[NAME] | [NAME] | 2622 | F&B Pearl | [NAME] | 1234 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-02 00:00:00 | sort-of-nice
[NAME] | [NAME] | 2422 | F&B Pearl | [NAME] | 1234 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00
F&B Beverage | [NAME] | 1411 | Security | Matson | 6011 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00 | Great
EVS | Froid | 4444 | F&B Stewards | [NAME] | 3211 | Yes | Yes | No | Yes | Yes | Yes | 2012-06-30 00:00:00
EVS | Froid | 4444 | Security | [NAME] | 6711 | Yes | Yes | No | Yes | Yes | Yes | 2012-06-30 00:00:00
F&B EDR/TMDR | Giertych | 4321 | Poker | Harvey | 5611 | Yes | Yes | Yes | Yes | Yes | No | 2012-06-30 00:00:00
F&B EDR/TMDR | [NAME] | 1611 | Poker | Harvey | 5611 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00 | good employee
F&B EDR/TMDR | [NAME] | 1611 | Poker | [NAME] | 5711 | Yes | Yes | No | No | Yes | No | 2012-06-30 00:00:00 | remember to thank the guest
F&B EDR/TMDR | [NAME] | 1611 | Marketing Rewards Club | Hord | 5811 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00 | always smiling
F&B EDR/TMDR | [NAME] | 1611 | Poker | [NAME] | 5911 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00 | awesome employee
F&B Beverage | Lopez | 6666 | Security | [NAME] | 6711 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00 | very nice employee
F&B Beverage | Lopez | 6666 | Security | [NAME] | 6811 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00 | what a fantastic person
EVS | Smith | 1111 | F&B Pearl | Agee | 3511 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00
EVS | Smith | 1111 | F&B Pearl | Araza | 3611 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00
EVS | Smith | 1111 | [NAME] | Curtis | 4611 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00
[NAME] | [NAME] | 2622 | [NAME] | Emery | 4811 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-06-30 00:00:00 | reallynice
EVS | Froid | 4444 | F&B Stewards | Hall | 3411 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00
[NAME] | [NAME] | 2322 | Security | [NAME] | 6711 | No | Yes | Yes | No | Yes | No | 2012-07-03 00:00:00 | Look up when a guest walks in
[NAME] | [NAME] | 2322 | Security | [NAME] | 6811 | Yes | No | Yes | No | No | No | 2012-07-03 00:00:00 | worthless employee
[NAME] | [NAME] | 2322 | Security | martinez | 6911 | No | No | No | No | No | No | 2012-07-03 00:00:00 | I can't believe you hired this guy
[NAME] | [NAME] | 2322 | Poker | Matson | 6011 | Yes | Yes | No | No | No | No | 2012-07-03 00:00:00 | what an idiot
F&B EDR/TMDR | Giertych | 1911 | Poker | [NAME] | 5911 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00 | rude
F&B EDR/TMDR | Giertych | 4321 | F&B Pearl | Hord | 5811 | Yes | Yes | No | No | Yes | No | 2012-07-03 00:00:00 | Not nice
F&B EDR/TMDR | Giertych | 4321 | Poker | Hord | 5811 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00 | ok
EVS | Hyde | 3333 | [NAME] | [NAME] | 4511 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00 | nice
F&B Beverage | Lopez | 6666 | Security | martinez | 6911 | Yes | Yes | No | No | Yes | No | 2012-07-03 00:00:00 | make sure you thank the guest
F&B Beverage | Nunn | 1311 | [NAME] | [NAME] | 4511 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00 | well done
F&B Beverage | Nunn | 1311 | [NAME] | Curtis | 4611 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00 | nice job
F&B Beverage | Nunn | 1311 | [NAME] | Ellis | 4711 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00 | nice work
F&B Beverage | Nunn | 1311 | [NAME] | Emery | 4811 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00 | what a great person
[NAME] | [NAME] | 2622 | Poker | [NAME] | 5911 | Yes | Yes | Yes | Yes | Yes | Yes | 2012-07-03 00:00:00 | nice overall