Spreadsheet: 160710d1339170131-update-date-in-a-cell-when-any-changes-are-made-and-saved-on-a-worksheet-test
Sheet: 1. People Sheet

 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | People Sheet |  |  |  |  |  |  |  |  | Date Changed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CTR designation |  | CTR
 | Manager [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Max & Erma's |  |  |  |  |  |  |  |  |  |  |  | MIT dropdown
 | Restaurant Unit  Phone |  |  |  |  |  |  | Volume | CTR | Mystery Shop Score | General Manager  Date of Hire |  |  |  |  | Rank | Rating | Time in Position | Associate Manager Date of Hire |  |  |  |  | Rank | Rating | Time in Position | 1st Assistant Manager Date of Hire |  |  |  |  | Rank | Rating | Time in Position | % of MDC Completed | 2nd Assistant Manager Date of Hire |  |  |  |  | Rank | Rating | Time in Position | % of MDC Completed | 2nd Assistant Manager Date of Hire |  |  |  |  | Rank | Rating | Time in Position | % of MDC Completed | AM Supervisor |  |  |  | PM Supervisor |  |  |  | AM FPS |  |  |  | PM FPS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  |  | Supervisor |  |  | food production specialist |  |  | associate |  | location |  | at risk flags
[NAME] Mugleston1 | 110002 S. State Street |  |  |  |  |  |  |  |  | 100 | [NAME] |  |  |  |  |  |  | 99.9 | [NAME] |  |  |  |  |  |  | 0.09041095890410959 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  | 1,2 | [NAME] |  | 1,2 | [NAME] |  |  | [NAME] |  | 110002 S. State Street | 110002 S. State Street |  |  |  |  |  | 0
[NAME] | [PHONE] |  |  |  |  |  |  |  |  |  | 2008-05-19 00:00:00 |  |  |  |  |  |  |  | 2010-09-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Max & Erma's |  | 3,4 |  |  | 3,4 | [NAME] |  |  |  |  |  | 110076 Fourth South
[NAME] Mugleston2 | 110076 Fourth South |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 2.071232876712329 | [NAME] |  |  |  |  |  |  | 0.3972602739726027 | [NAME] |  |  |  |  |  |  | 0.1671232876712329 |  | Need |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amanda Alviso |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Bakers Square |  | 1,2 | Amanda Alviso | [NAME] | 1,2 | [NAME] | [NAME] |  | [NAME] |  | 110076 Fourth South | 110081 Bountiful |  |  |  |  |  | 0
[NAME] | [PHONE] |  |  |  |  |  |  |  |  |  | 2006-11-17 00:00:00 |  |  |  |  |  |  |  | 2008-09-05 00:00:00 |  |  |  |  |  |  |  | 2011-12-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  | 3,4 | [NAME] |  | 3,4 | [NAME] | [NAME] |  |  |  |  | 110085 Taylorsville
[NAME] Mugleston3 | 110081 Bountiful |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 0.09041095890410959 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 0.7616438356164383 |  | [NAME] |  |  |  |  |  |  | 0.1671232876712329 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Angel Valdez |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Max & Erma's |  | 1,2 |  |  | 1,2 | Angel Valdez |  |  |  |  | 110081 Bountiful | 110750 Ogden |  |  |  |  |  | 0
[NAME] | [PHONE] |  |  |  |  |  |  |  |  |  | 2009-08-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-05-19 00:00:00 |  |  |  |  |  |  |  |  | 2010-11-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  | 3,4 |  |  | 3,4 | [NAME] |  |  |  |  |  | 110784 [NAME]
[NAME] Mugleston4 | 110085 Taylorsville |  |  |  |  |  |  |  |  |  | Tori [NAME] |  |  |  |  |  |  | 0.5315068493150685 | [NAME] |  |  |  |  |  |  | 1.126027397260274 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  | 1,2 | [NAME] |  | 1,2 | [NAME] |  |  | [NAME] |  | 110085 Taylorsville | 110854 S Ogden (Skylin |  |  |  |  |  | 0
[NAME] | [PHONE] |  |  |  |  |  |  |  |  |  | 2007-01-16 00:00:00 |  |  |  |  |  |  |  | 2005-12-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dawn Cohoon | Bakers Square |  | 3,4 |  |  | 3,4 |  |  |  |  |  |  | New Store
[NAME] Mugleston5 | 110750 Ogden |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 7.358904109589041 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  | 1,2 | [NAME] |  | 1,2 | [NAME] |  |  |  |  | 110750 Ogden |  |  |  |  |  |  | 0
[NAME] | [PHONE] |  |  |  |  |  |  |  |  |  | 2003-06-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1995-05-31 00:00:00 |  |  |  |  |  |  |  |  | dfasdfasdf |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  | 3,4 |  |  | 3,4
[NAME] Mugleston6 | 110784 [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 4.52054794520548 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fred Raso | [NAME] |  | 1,2 | [NAME] | [NAME] | 1,2 |  |  |  |  |  | 110784 [NAME] |  |  |  |  |  |  | 0
[NAME] | [PHONE] |  |  |  |  |  |  |  |  |  | 1998-10-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2007-07-12 00:00:00 |  |  |  |  |  |  |  |  | asdf |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Bakers Square |  | 3,4 |  |  | 3,4
[NAME] Mugleston7 | 110854 S Ogden (Skylin |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 0.326027397260274 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  | 1,2 | [NAME] |  | 1,2 | [NAME] |  |  |  |  | 110854 S Ogden (Skylin |  |  |  |  |  |  | 0
[NAME] | [PHONE] |  |  |  |  |  |  |  |  |  | 2004-03-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-04-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  | 3,4 |  |  | 3,4
[NAME] Mugleston8 | New Store |  |  |  |  |  |  |  |  |  | Need |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | fghdfgh |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Bakers Square |  | 1,2 |  |  | 1,2 |  |  |  | [NAME] |  | New Store |  |  |  |  |  |  | 0
[NAME] | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | need |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Max & Erma's |  | 3,4 |  |  | 3,4
[NAME] Mugleston9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  | 1,2 |  |  | 1,2 |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Bakers Square |  | 3,4 |  |  | 3,4
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  | 1,2 |  |  | 1,2 |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Max & Erma's |  | 3,4 |  |  | 3,4
 |  | P1 | P2 | P3 | P4 | NR | NI | X |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location with a fourth assistant |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  | 9 | 2 |  | 4 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 | Promotable |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MITs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Bakers Square
 | Name |  |  |  |  |  | Target Position |  |  |  |  | Target Date |  |  |  |  |  | MITs |  |  |  |  |  | Training Location |  |  |  |  |  |  | Target Location |  |  |  |  | Target Start Date |  |  |  |  | Target Completion Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Max & Erma's
Promo1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110081 Bountiful1 | 1 | [NAME] |  |  |  |  |  | 110081 Bountiful |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Max & Erma's
Promo2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110750 Ogden1 | 1 | [NAME] |  |  |  |  |  | 110750 Ogden |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teresa Rivera | [NAME] |  |  |  |  | IF(ISERROR(VLOOKUP(B4&1,Supervisor!$C$1:$E$130,3,FALSE)),"",VLOOKUP(B4&1,Supervisor!$C$1:$E$130,3,FALSE))
Promo3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
Promo4
Promo5
Promo6
Promo7
 |  |  | Assistant Manager | Associate Manager | General Manager | Higher Volume Unit | RMIT | TGM
 | Skills Trainers
 | Restaurant Unit  Phone |  |  |  |  |  |  | Vol | FOH AM  Skills Trainers |  |  |  |  |  |  | FOH PM  Skills Trainers |  |  |  |  |  |  | BOH AM  Skills Trainers |  |  |  |  |  |  | BOH PM  Skills Trainers |  |  |  |  |  |  |  |  | Talent Map Rating Key |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | add counts here
 | 110002 S. State Street |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1 |  | Exceptional Performer |  |  |  |  |  | Ready for promotion today |  |  |  |  |  |  |  |  | 4/ | 8 | Associate Managers
 | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P2 |  | Strong Performer with High Potential |  |  |  |  |  | Promote in 6 months to 1 year |  |  |  |  |  |  |  |  | 3 |  | Total Management Needs
 | 110076 Fourth South
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P3 |  | Strong Performer |  |  |  |  |  | Fully functioning in current role |  |  |  |  |  |  |  |  | 2 |  | MITs
 | [PHONE]
 | 110081 Bountiful |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P4 |  | Performs Consistently |  |  |  |  |  | Consistent but improving in current level |  |  |  |  |  |  |  |  | 11/ | 16 | Food Production Specialists
 | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NR |  | New in Role |  |  |  |  |  | New for 6 months to 1 year
 | 110085 Taylorsville
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NI |  | Needs Improvement |  |  |  |  |  | Must improve within 6 months
 | [PHONE]
 | 110750 Ogden |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  | At Risk |  |  |  |  |  | Performs consistently but has special circumstances
 | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Use this key to select the appropriate rating for the manager list above. See Talent Map tab for more detail.
 | 110784 [NAME]
 | [PHONE]
 | 110854 S Ogden (Skylin
 | [PHONE]
 | New Store
 | [PHONE]