Spreadsheet: 207845-cell-color-changes-regarding-current-and-past-due-dates-sample-spreadsheet1
Sheet: Sheet1

Program | NCM | Last | First | Client # | DOB | Case Worker Name: | Insurance Coverage | PCP | Assmt Due Date | Date Assmt signed | ITP/PDP Due Date | ITP Goal | Date ITP signed
Clinic A | BJ |  |  | 4174724 | 1995-07-11 00:00:00 |  |  |  | 2013-01-01 00:00:00 | 2012-11-09 00:00:00 | 2013-07-01 00:00:00 | yes | 2012-11-09 00:00:00
Clinic A | BJ |  |  | 186201 | 1973-12-01 00:00:00 |  |  |  | 2013-07-01 00:00:00 | 2013-01-10 00:00:00 | 2013-12-01 00:00:00 | yes | 2013-01-10 00:00:00
Clinic A | BJ |  |  | 588589 | 1967-03-09 00:00:00 |  |  |  | 2013-06-01 00:00:00 |  | 2012-12-01 00:00:00
Clinic A | BJ |  |  | xxxxxxx | 1960-03-29 00:00:00 |  |  |  | 2015-05-01 00:00:00 | 2012-11-09 00:00:00 | 2013-03-01 00:00:00 | yes | 2012-11-09 00:00:00
Clinic A | BJ |  |  | 412346 | 1970-03-29 00:00:00 |  |  |  | 2012-04-01 00:00:00 | 2013-01-10 00:00:00 | 2013-08-01 00:00:00 | yes | 2013-01-10 00:00:00
Clinic A | BJ |  |  | xxxxxxxx | 1989-10-19 00:00:00 |  |  |  | 2014-02-01 00:00:00 |  | 2012-06-01 00:00:00
Clinic A | BJ |  |  | 844066 | 1998-11-08 00:00:00 |  |  |  | 2012-10-01 00:00:00 | 2012-12-07 00:00:00 | 2013-11-01 00:00:00 | yes | 2012-12-07 00:00:00
Clinic A | BJ |  |  | 4223274 | 1977-08-24 00:00:00 |  |  |  | 2014-03-01 00:00:00 |  | 2013-07-01 00:00:00 | yes
Clinic A | BJ |  |  | 713574 | 1999-04-11 00:00:00 |  |  |  | 2013-09-01 00:00:00 |  | 2013-02-01 00:00:00 | yes
Clinic A | BJ |  |  | 4023714 | 2000-04-18 00:00:00 |  |  |  | 2014-05-01 00:00:00 |  | 2013-11-01 00:00:00 | yes
Clinic A | BJ |  |  | 462961 | 1975-12-13 00:00:00 |  |  |  | Sep-12 |  | Sep-12
Clinic A | BJ |  |  | 4206263 | 1967-11-19 00:00:00 |  |  |  | 2013-10-01 00:00:00 |  | 2013-12-01 00:00:00
Clinic A | BJ |  |  | 922129 | 1997-04-23 00:00:00 |  |  |  | 2012-06-01 00:00:00
Clinic A | BJ |  |  | 926066 | 1984-04-19 00:00:00 |  |  |  | 2014-01-01 00:00:00
Clinic A | BJ |  |  | 4205106 | 1972-08-18 00:00:00 |  |  |  | 2013-09-01 00:00:00 |  | 2013-09-01 00:00:00
Clinic A | BJ |  |  | 244815 | 1959-01-25 00:00:00 |  |  |  | 2012-05-01 00:00:00 |  | 2013-09-01 00:00:00 | yes
Clinic A | BJ |  |  |  | 1971-06-19 00:00:00 |  |  |  | 2015-06-01 00:00:00 |  | 2013-06-01 00:00:00
Clinic B | BJ |  |  | 4153454 | 1975-04-14 00:00:00 |  |  |  | 2014-05-01 00:00:00 |  | 2012-05-01 00:00:00
Clinic B | BJ |  |  |  | 1994-11-19 00:00:00 |  |  |  | 2012-09-01 00:00:00 |  | 2012-10-01 00:00:00
Clinic B | BJ |  |  | 410105 | 1960-08-02 00:00:00 |  |  |  | 2011-12-01 00:00:00 |  | 2013-03-01 00:00:00
Clinic B | BJ |  |  | 82101 | 1970-04-12 00:00:00 |  |  |  | 2012-02-01 00:00:00 |  | 2012-05-01 00:00:00
Clinic B | BJ |  |  | 836558 | 1978-08-19 00:00:00 |  |  |  | PSR |  | PSR
Clinic B | BJ |  |  | 211900 | 1955-04-24 00:00:00 |  |  |  | CS |  | CS
Clinic B | BJ |  |  | 4181997 | 1988-02-23 00:00:00 |  |  |  | 2013-04-01 00:00:00 |  | 2012-06-01 00:00:00
Clinic B | BJ |  |  | 4186393 | 1994-09-10 00:00:00 |  |  |  | 2013-08-01 00:00:00 |  | 2013-12-01 00:00:00 | yes
Clinic B | BJ |  |  | 185584 | 1981-08-24 00:00:00 |  |  |  | 2013-06-01 00:00:00 |  | 2013-10-01 00:00:00 | yes
Clinic B | BJ |  |  | 00025882 | 1996-05-31 00:00:00 |  |  |  | 2015-03-01 00:00:00 |  | 2013-03-01 00:00:00
Clinic B | BJ |  |  | 4081102 | 1976-11-07 00:00:00 |  |  |  | 2010-01-01 00:00:00 |  | 2012-07-01 00:00:00 | yes
Clinic B | BJ |  |  | 511822 | 1955-02-24 00:00:00 |  |  |  | 2011-06-01 00:00:00 |  | 2012-03-01 00:00:00
Clinic B | BJ |  |  | 4196830 | 1994-01-31 00:00:00 |  |  |  | 2013-07-01 00:00:00 |  | 2012-12-01 00:00:00
Clinic B | BJ |  |  | 405353 | 1966-07-05 00:00:00 |  |  |  | 2011-08-01 00:00:00 |  | 2011-08-01 00:00:00
Clinic B | BJ |  |  |  | 2004-04-15 00:00:00 |  |  |  | 2012-11-08 00:00:00 |  | 2011-05-01 00:00:00
Clinic B | BJ |  |  | 4183417 | 2004-03-02 00:00:00 |  |  |  | 2013-04-01 00:00:00 |  | 2012-06-13 00:00:00
Clinic B | BJ |  |  | 796365 | 2000-04-28 00:00:00 |  |  |  | 2011-06-01 00:00:00 |  | 2013-11-01 00:00:00 | yes
Clinic B | BJ |  |  | 4184631 | 1983-02-15 00:00:00 |  |  |  | 2013-06-01 00:00:00 |  | 2013-11-01 00:00:00 | yes
Clinic B | BJ |  |  | 602822 | 1968-06-23 00:00:00 |  |  |  | 2014-06-01 00:00:00 |  | 2013-02-01 00:00:00
Clinic B | BJ |  |  | 383529 | 1953-11-23 00:00:00 |  |  |  | 2014-04-01 00:00:00 |  | 2012-04-01 00:00:00
Clinic B | BJ |  |  |  | 1969-06-25 00:00:00 |  |  |  | 2015-05-01 00:00:00 |  | 2013-06-01 00:00:00
Clinic C | BJ |  |  | 4022344 | 2000-10-11 00:00:00 |  |  |  | 2013-03-01 00:00:00 |  | 2013-10-01 00:00:00 | yes
Clinic C | BJ |  |  | 717477 | 1959-10-17 00:00:00 |  |  |  | 2011-05-18 00:00:00 |  | PDP-04/19/10
Clinic C | BJ |  |  | 594453 | 1985-02-06 00:00:00 |  |  |  | 2010-04-01 00:00:00 |  | 2013-11-01 00:00:00 | yes
Clinic C | BJ |  |  | 21760 | 1962-04-27 00:00:00 |  |  |  | 2011-06-01 00:00:00 |  | 2012-10-01 00:00:00
Clinic C | BJ |  |  | 4102217 | 1962-08-25 00:00:00 |  |  |  | 2011-07-01 00:00:00 |  | 2012-10-01 00:00:00
Clinic C | BJ |  |  | 0213642 | 1974-11-30 00:00:00 |  |  |  | 2013-01-01 00:00:00 |  | 2013-12-01 00:00:00
Clinic C | BJ |  |  | 183272 | 1972-11-03 00:00:00 |  |  |  | 2012-04-01 00:00:00 |  | 2013-06-01 00:00:00
Clinic C | BJ |  |  | 4234606 | 1988-12-29 00:00:00 |  |  |  | 2014-06-01 00:00:00 |  | 2013-06-01 00:00:00
Clinic C | BJ |  |  |  | 1978-09-10 00:00:00
Clinic C | BJ |  |  | 806206 | 1995-12-09 00:00:00 |  |  |  | 2015-09-01 00:00:00 |  | 2012-11-01 00:00:00
Clinic C | BJ |  |  | 4184336 | 1965-01-13 00:00:00 |  |  |  | 2013-04-01 00:00:00 |  | 2013-11-01 00:00:00
Clinic C | BJ |  |  | 522631 | 1957-07-26 00:00:00 |  |  |  | 2013-12-01 00:00:00 |  | 2013-01-01 00:00:00
Clinic C | BJ |  |  | 477844 | 1958-07-02 00:00:00 |  |  |  | 2012-10-01 00:00:00 |  | 2013-11-01 00:00:00
Clinic C | BJ |  |  | 4203119 | 1975-11-28 00:00:00 |  |  |  |  |  | 2013-10-01 00:00:00
Clinic C | BJ |  |  |  | 1953-08-29 00:00:00
Clinic C | BJ |  |  |  | 1966-03-13 00:00:00
Clinic C | BJ |  |  | 434232 | 1945-04-18 00:00:00 |  |  |  | 2013-09-01 00:00:00 | 2013-01-15 00:00:00 | 2013-09-01 00:00:00 | yes
Clinic C | BJ |  |  | 4160076 | 1990-07-31 00:00:00 |  |  |  | 2013-06-01 00:00:00 | 2013-01-15 00:00:00 | 2013-06-01 00:00:00 | yes | 2013-01-15 00:00:00
Clinic C | BJ |  |  | 49800 | 1961-06-19 00:00:00 |  |  |  | 2013-08-01 00:00:00 | 2013-01-15 00:00:00 | 2013-08-01 00:00:00 | yes
Clinic C | BJ |  |  |  | 1962-09-08 00:00:00 |  |  |  | 2013-06-01 00:00:00 |  | 2013-06-01 00:00:00
Clinic C | BJ |  |  | 522289 | 1958-03-13 00:00:00 |  |  |  | 2013-11-01 00:00:00 |  | 2013-11-01 00:00:00
Clinic C | BJ |  |  |  | 1963-12-05 00:00:00
Clinic C | BJ |  |  | 4102192 | 1990-06-06 00:00:00 |  |  |  | 2013-05-01 00:00:00 |  | 2013-05-01 00:00:00
Clinic C | BJ |  |  |  | 1971-12-11 00:00:00
Clinic C | BJ |  |  |  | 1972-01-17 00:00:00 |  |  |  | 2015-07-01 00:00:00
Clinic C | BJ |  |  | 810382 | 1991-09-28 00:00:00 |  |  |  | 2013-08-01 00:00:00 | yes | 2013-08-01 00:00:00
Clinic C | BJ |  |  | 810075 | 1968-04-08 00:00:00 |  |  |  | 2013-07-01 00:00:00 |  | 2013-07-01 00:00:00
Clinic C | BJ |  |  |  | 1962-08-18 00:00:00
Clinic C | BJ |  |  | 49752 | 1955-05-16 00:00:00 |  |  |  | 2013-10-01 00:00:00 |  | 2013-10-01 00:00:00
Clinic C | BJ |  |  | 4216424 | 1967-07-15 00:00:00 |  |  |  | 2012-01-11 00:00:00 |  | 2013-01-11 00:00:00 | yes
Clinic C | BJ |  |  | 4001269 | 1968-08-24 00:00:00 |  |  |  | 2013-09-01 00:00:00 |  | 2013-09-01 00:00:00
Clinic C | BJ |  |  | 58603 | 1952-11-14 00:00:00 |  |  |  | 2013-06-01 00:00:00 |  | 2013-06-01 00:00:00
Clinic C | BJ |  |  | 905783 | 1991-12-10 00:00:00 |  |  |  | 2013-04-01 00:00:00 |  | 2013-04-01 00:00:00
Clinic C | BJ |  |  | 888770 | 1961-12-08 00:00:00 |  |  |  | 2013-06-01 00:00:00 |  | 2013-06-01 00:00:00
Clinic C | BJ |  |  |  | 1960-05-31 00:00:00 |  |  |  | 2013-11-01 00:00:00 |  | 2013-11-01 00:00:00 | yes | 2012-09-05 00:00:00
Clinic C | BJ |  |  | 574994 | 1957-08-15 00:00:00 |  |  |  | 2013-09-01 00:00:00 |  | 2013-09-01 00:00:00
Clinic C | BJ |  |  | 179791 | 1956-10-28 00:00:00 |  |  |  | 2013-07-01 00:00:00 |  | 2013-07-01 00:00:00
Clinic C | BJ |  |  | 186701 | 1967-09-18 00:00:00 |  |  |  | 2013-02-01 00:00:00 |  | 2013-02-01 00:00:00
Clinic C | BJ |  |  | 103112 | 1964-04-22 00:00:00 |  |  |  | 2012-10-01 00:00:00 |  | 2012-02-14 00:00:00
Clinic C | BJ |  |  | xxxxxxxx | 1983-10-26 00:00:00 |  |  |  | 2012-06-01 00:00:00
Clinic C | BJ |  |  | 51200 | 1962-07-16 00:00:00 |  |  |  | 2013-07-01 00:00:00 |  | 2013-07-01 00:00:00
Clinic C | BJ |  |  | 4148199 | 1955-09-08 00:00:00 |  |  |  | 2013-09-01 00:00:00 |  | 2013-09-01 00:00:00
Clinic C | BJ |  |  |  | 1959-05-25 00:00:00 |  |  |  | 2013-12-01 00:00:00 |  | 2013-12-01 00:00:00 | yes
Clinic C | BJ |  |  | 4221176 | 1971-01-05 00:00:00 |  |  |  | 2013-02-01 00:00:00 |  | 2013-02-01 00:00:00
Clinic C | BJ |  |  | 4121910 | 1961-10-17 00:00:00 |  |  |  | Mar-12 |  | Mar-12
Clinic C | BJ |  |  |  | 1954-01-06 00:00:00 |  |  |  | 2013-11-01 00:00:00 |  | 2013-11-01 00:00:00 | yes | 2012-09-05 00:00:00
Clinic C | BJ |  |  | 358776 | 1957-04-16 00:00:00 |  |  |  | 2013-01-01 00:00:00 |  | 2013-01-01 00:00:00
Clinic C | BJ |  |  | 51857 | 1956-10-01 00:00:00 |  |  |  | 2013-01-01 00:00:00 |  | 2013-01-01 00:00:00
Clinic C | BJ |  |  | 4093621 | 1985-10-17 00:00:00 |  |  |  | 2013-04-01 00:00:00 |  | 2013-04-01 00:00:00
Clinic C | BJ |  |  | 4047095 | 1998-09-23 00:00:00 |  |  |  | 2013-03-12 00:00:00 | yes | 2013-03-29 00:00:00 | yes | 2013-01-03 00:00:00
Clinic C | BJ |  |  | 624811 | 1993-12-25 00:00:00 |  |  |  | 2012-03-12 00:00:00 | yes | 2012-04-27 00:00:00
Clinic C | BJ |  |  | 943210 | 1996-11-26 00:00:00 |  |  |  | 2013-10-01 00:00:00 | yes | 2013-10-01 00:00:00 | yes
Clinic C | BJ |  |  | 4192261 | 2005-10-27 00:00:00 |  |  |  | 2013-06-01 00:00:00 | yes | 2013-06-01 00:00:00 | yes | 2013-01-03 00:00:00
Clinic C | BJ |  |  | 4109778 | 2002-09-07 00:00:00 |  |  |  | 2012-11-01 00:00:00 |  | 2012-11-27 00:00:00 | yes | 2013-01-03 00:00:00
Clinic C | BJ |  |  | 4116262 | 1995-09-30 00:00:00 |  |  |  | 2013-11-01 00:00:00 |  | 2013-11-01 00:00:00 | yes | 2013-01-03 00:00:00
Clinic C | BJ |  |  | 4135241 | 2001-10-23 00:00:00 |  |  |  | 2013-05-07 00:00:00 | yes | 2012-05-01 00:00:00 | yes
Clinic C | BJ |  |  | 4211063 | 1998-12-08 00:00:00 |  |  |  | 2013-03-01 00:00:00 | yes | 2013-03-01 00:00:00 | yes | 2013-01-03 00:00:00
Clinic C | BJ |  |  | 4201071 | 1999-06-29 00:00:00 |  |  |  | 2013-09-01 00:00:00 | yes | 2013-09-01 00:00:00 | yes | 2013-01-03 00:00:00
Clinic C | BJ |  |  | 4185601 | 1996-07-20 00:00:00 |  |  |  | 2013-05-01 00:00:00 | yes | 2013-05-01 00:00:00
Clinic D | BJ |  |  | 4078225 | 1958-08-25 00:00:00 |  |  |  | 2012-03-28 00:00:00 |  | 2011-12-02 00:00:00
Clinic D | BJ |  |  | 158818 | 1961-01-17 00:00:00 |  |  |  | 2010-11-22 00:00:00 | yes | 2012-12-17 00:00:00 | yes
Clinic D | BJ |  |  | 35323 | 1968-05-27 00:00:00 |  |  |  | 2011-09-15 00:00:00 |  | 2011-08-22 00:00:00
Clinic D | BJ |  |  | 950937 | 1967-03-13 00:00:00 |  |  |  | 2011-04-26 00:00:00 |  | 2011-10-27 00:00:00
Clinic D | BJ |  |  | 311421 | 1964-01-23 00:00:00 |  |  |  |  | yes | 2012-02-01 00:00:00 | yes
Clinic D | BJ |  |  | 76599 | 1988-01-04 00:00:00 |  |  |  |  | yes |  | yes
Clinic D | BJ |  |  | 428850 | 1958-04-14 00:00:00 |  |  |  | 2012-07-10 00:00:00 |  | 2012-01-13 00:00:00 | yes
Clinic D | BJ |  |  | 4180030 | 1992-10-27 00:00:00 |  |  |  | 2011-04-20 00:00:00 |  | 2011-03-18 00:00:00
Clinic D | BJ |  |  | 831109 | 1984-07-16 00:00:00 |  |  |  |  |  | 2011-08-15 00:00:00
Clinic D | BJ |  |  | 863898 | 1979-08-14 00:00:00 |  |  |  |  |  | 2012-04-13 00:00:00 | yes
Clinic D | BJ |  |  | 4105721 | 1955-10-04 00:00:00 |  |  |  | 2011-08-31 00:00:00 |  | 2012-03-07 00:00:00
Clinic D | BJ |  |  | 768446 | 1987-12-22 00:00:00 |  |  |  | Mar-12 |  | 2012-03-01 00:00:00
Clinic D | BJ |  |  | 28456 | 1963-09-04 00:00:00 |  |  |  | 2011-05-18 00:00:00 | yes | 2012-03-09 00:00:00 | yes
Clinic D | BJ |  |  | 35050 | 1960-11-05 00:00:00 |  |  |  | 2011-05-03 00:00:00 | yes | 2012-07-23 00:00:00 | yes
Clinic D | BJ |  |  | 4168223 | 1960-09-04 00:00:00
Clinic D | BJ |  |  | 650030 | 1959-11-29 00:00:00 |  |  |  |  |  | 2012-03-25 00:00:00
Clinic D | Pam |  |  | 442710 | 1971-11-30 00:00:00 |  |  |  | 2013-01-01 00:00:00 |  | 2013-01-01 00:00:00 | DONE
Clinic D | Pam |  |  |  | 1989-12-16 00:00:00 |  |  |  | 2013-09-01 00:00:00 |  | 2013-09-01 00:00:00
Clinic D | Pam |  |  | 57356 | 1961-05-04 00:00:00 |  |  |  | 2013-12-01 00:00:00 |  | 2013-12-01 00:00:00 |  | dec '12
Clinic D | Pam |  |  | 680369 | 1950-12-20 00:00:00 |  |  |  | 2013-10-01 00:00:00 |  | 2013-10-01 00:00:00 |  | 2013-01-18 00:00:00
Clinic D | Pam |  |  | 4196206 | 1984-12-11 00:00:00 |  |  |  | 2013-06-01 00:00:00 |  | 2013-06-01 00:00:00 |  | 2013-01-18 00:00:00
Clinic D | Pam |  |  | 4158388 | 1979-01-31 00:00:00 |  |  |  | 2013-03-01 00:00:00 |  | 2013-03-01 00:00:00 |  | 2013-01-03 00:00:00
Clinic D | Pam |  |  | 4223594 | 1970-09-10 00:00:00 |  |  |  | 2013-09-01 00:00:00 |  | 2013-09-01 00:00:00
Clinic D | Pam |  |  | 242435 | 1965-07-07 00:00:00 |  |  |  | 2013-02-01 00:00:00 |  | 2013-02-01 00:00:00
Clinic D | Pam |  |  | 342527 | 1965-08-27 00:00:00 |  |  |  | 2013-11-01 00:00:00 |  | 2013-11-01 00:00:00
Clinic D | Pam |  |  | 4170976 | 1994-04-16 00:00:00 |  |  |  | 2013-08-01 00:00:00 |  | 2013-06-01 00:00:00 |  | 2013-01-03 00:00:00
Clinic D | Pam |  |  | 354014 | 1969-12-16 00:00:00 |  |  |  | 2013-09-01 00:00:00 |  | 2013-09-01 00:00:00
Clinic D | Pam |  |  | 500003 | 1959-01-08 00:00:00 |  |  |  | 2013-04-01 00:00:00 |  | 2013-04-01 00:00:00
Clinic D | Pam |  |  | 36326 | 1965-02-13 00:00:00 |  |  |  | 2013-11-01 00:00:00 |  | 2013-11-01 00:00:00
Clinic D | Pam |  |  | 298045 | 1958-03-15 00:00:00 |  |  |  | 2013-02-01 00:00:00 |  | 2013-02-01 00:00:00
Clinic D | Pam |  |  | 472190 | 1963-06-08 00:00:00 |  |  |  | 2013-02-01 00:00:00 |  | 2013-02-01 00:00:00
Clinic D | Pam |  |  | 295807 | 1981-02-26 00:00:00 |  |  |  | 2013-03-01 00:00:00 |  | 2013-03-01 00:00:00