Spreadsheet: 38251d1236354852-if-then-question-shading-excelproblem3609
Sheet: Sheet1

Area | SP | TH | Description_and_Location | RESIDENT | COST | LET_DATE | Construction_Start_Date | Construction_End_Date | CREW |  | [NAME] | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-09 00:00:00 | 2009-05-09 00:00:00 | 2009-06-09 00:00:00 | 2009-07-09 00:00:00 | 2009-08-09 00:00:00 | 2009-09-09 00:00:00 | 2009-10-09 00:00:00 | 2009-11-09 00:00:00 | 2009-12-09 00:00:00 |  | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 |  | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 |  | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00
 |  |  |  |  |  | 2006-04-28 00:00:00 | 2006-07-01 00:00:00
 |  |  |  |  |  | 2011-09-23 00:00:00 | 2011-12-30 00:00:00 | 2012-06-30 00:00:00
 |  |  |  |  |  | 2008-01-25 00:00:00 | 2008-04-01 00:00:00 | 2011-06-15 00:00:00
 |  |  |  |  |  | 2009-03-27 00:00:00 | 2009-06-01 00:00:00 | 2009-08-15 00:00:00
 |  |  |  |  |  | 2009-04-10 00:00:00 | 2009-07-15 00:00:00 | 2009-10-01 00:00:00
 |  |  |  |  |  | 2009-04-24 00:00:00 | 2009-05-15 00:00:00 | 2009-07-15 00:00:00
 |  |  |  |  |  | 2009-12-18 00:00:00 | 2010-01-29 00:00:00 | 2010-07-29 00:00:00
 |  |  |  |  |  | 2010-01-22 00:00:00 | 2011-04-01 00:00:00 | 2011-11-01 00:00:00
 |  |  |  |  |  | 2010-01-22 00:00:00 | 2011-04-01 00:00:00 | 2011-11-15 00:00:00
 |  |  |  |  |  | 2010-01-22 00:00:00 | 2010-03-05 00:00:00 | 2010-09-05 00:00:00
 |  |  |  |  |  | 2010-01-22 00:00:00 | 2010-05-03 00:00:00 | 2011-11-01 00:00:00
 |  |  |  |  |  | 2010-04-23 00:00:00 | 2012-07-23 00:00:00 | 2013-01-23 00:00:00
 |  |  |  |  |  | 2010-10-22 00:00:00 | 2011-04-15 00:00:00 | 2011-08-12 00:00:00
 |  |  |  |  |  | 2010-10-22 00:00:00 | 2011-04-15 00:00:00 | 2011-08-15 00:00:00
 |  |  |  |  |  | 2010-10-22 00:00:00 | 2011-04-15 00:00:00 | 2011-08-12 00:00:00
 |  |  |  |  |  | 2010-10-22 00:00:00 | 2011-04-15 00:00:00 | 2011-08-12 00:00:00
 |  |  |  |  |  | 2011-01-28 00:00:00 | 2011-03-12 00:00:00 | 2011-08-12 00:00:00
 |  |  |  |  |  | 2011-10-28 00:00:00 | 2012-04-01 00:00:00 | 2012-04-01 00:00:00
 |  |  |  |  |  | 2011-11-18 00:00:00 | 2011-12-30 00:00:00 | 2012-06-30 00:00:00
 |  |  |  |  |  | 2012-03-23 00:00:00 | 2012-07-20 00:00:00 | 2013-01-20 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2014-01-01 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2014-01-26 00:00:00
 |  |  |  |  |  | 2013-12-01 00:00:00 | 2013-07-02 00:00:00 | 2013-11-30 00:00:00
 |  |  |  |  |  | 2023-04-28 00:00:00 | 2023-07-01 00:00:00 | 2049-04-01 00:00:00
 |  |  |  |  |  | 2009-02-27 00:00:00 | 2009-04-10 00:00:00 | 2009-05-10 00:00:00
 |  |  |  |  |  | 2009-03-27 00:00:00 | 2009-08-04 00:00:00 | 2009-11-01 00:00:00
 |  |  |  |  |  | 2009-04-24 00:00:00 | 2009-05-20 00:00:00 | 2010-11-15 00:00:00
 |  |  |  |  |  | 2010-01-22 00:00:00 | 2010-04-15 00:00:00 | 2010-07-01 00:00:00
 |  |  |  |  |  | 2010-01-22 00:00:00 | 2011-04-15 00:00:00 | 2011-08-12 00:00:00
 |  |  |  |  |  | 2011-07-22 00:00:00 | 2011-09-02 00:00:00 | 2012-03-02 00:00:00
 |  |  |  |  |  | 2012-01-27 00:00:00 | 2012-03-09 00:00:00 | 2012-09-09 00:00:00
 |  |  |  |  |  | 2012-06-08 00:00:00 | 2013-07-26 00:00:00 | 2014-01-26 00:00:00
 |  |  |  |  |  | 2012-06-08 00:00:00 | 2013-07-26 00:00:00 | 2014-01-26 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2014-01-26 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2014-01-26 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2013-07-26 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2014-01-26 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2014-01-26 00:00:00
 |  |  |  |  |  | 2014-07-25 00:00:00 | 2014-09-05 00:00:00 | 2015-03-05 00:00:00
 |  |  |  |  |  | 2006-04-28 00:00:00 | 2006-06-01 00:00:00 | 2011-06-01 00:00:00
 |  |  |  |  |  | 2010-01-22 00:00:00 | 2011-08-01 00:00:00 | 2011-09-30 00:00:00
 |  |  |  |  |  | 2012-05-18 00:00:00 | 2012-06-29 00:00:00 | 2012-02-29 00:00:00
 |  |  |  |  |  | 2008-09-08 00:00:00 | 2008-10-13 00:00:00 | 2010-11-01 00:00:00
 |  |  |  |  |  | 2008-12-19 00:00:00 | 2009-04-01 00:00:00 | 2009-09-30 00:00:00
 |  |  |  |  |  | 2009-01-30 00:00:00 | 2009-04-01 00:00:00 | 2009-09-30 00:00:00
 |  |  |  |  |  | 2009-02-27 00:00:00 | 2009-04-15 00:00:00 | 2009-09-18 00:00:00
 |  |  |  |  |  | 2009-02-27 00:00:00 | 2009-04-13 00:00:00 | 2009-07-31 00:00:00
 |  |  |  |  |  | 2010-01-22 00:00:00 | 2010-03-05 00:00:00 | 2010-09-05 00:00:00
 |  |  |  |  |  | 2010-10-22 00:00:00 | 2011-04-01 00:00:00 | 2012-11-01 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2014-01-26 00:00:00
 |  |  |  |  |  | 2014-04-25 00:00:00 | 2014-06-06 00:00:00 | 2014-12-06 00:00:00
 |  |  |  |  |  | 2030-01-01 00:00:00 | 1930-02-12 00:00:00 | 1930-08-12 00:00:00
 |  |  |  |  |  | 2006-04-28 00:00:00 | 2006-06-01 00:00:00 | 2011-06-01 00:00:00
 |  |  |  |  |  | 2010-04-23 00:00:00 | 2010-09-15 00:00:00 | 2011-10-15 00:00:00
 |  |  |  |  |  | 2010-10-22 00:00:00 | 2011-04-15 00:00:00 | 2011-08-12 00:00:00
 |  |  |  |  |  | 2011-05-20 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2014-01-26 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2013-07-26 00:00:00
 |  |  |  |  |  | 2009-03-13 00:00:00 | 2009-04-01 00:00:00 | 2009-10-15 00:00:00
 |  |  |  |  |  | 2009-03-27 00:00:00 | 2009-06-08 00:00:00 | 2009-08-15 00:00:00
 |  |  |  |  |  | 2009-05-15 00:00:00 | 2009-09-15 00:00:00 | 2009-10-15 00:00:00
 |  |  |  |  |  | 2009-11-20 00:00:00 | 2010-05-01 00:00:00 | 2010-11-01 00:00:00
 |  |  |  |  |  | 2009-12-18 00:00:00 | 2010-04-15 00:00:00 | 2010-11-30 00:00:00
 |  |  |  |  |  | 2010-11-19 00:00:00 | 2011-04-01 00:00:00 | 2011-11-30 00:00:00
 |  |  |  |  |  | 2011-06-10 00:00:00 | 2011-07-22 00:00:00 | 2012-01-22 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2014-01-26 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2013-07-26 00:00:00
 |  |  |  |  |  | 2013-07-26 00:00:00 | 2013-09-06 00:00:00 | 2015-09-15 00:00:00
 |  |  |  |  |  | 2013-07-26 00:00:00 | 2013-09-06 00:00:00 | 2016-11-15 00:00:00
 |  |  |  |  |  | 2014-04-25 00:00:00 | 2014-06-06 00:00:00 | 2016-07-01 00:00:00
 |  |  |  |  |  | 2014-04-25 00:00:00 | 2014-06-06 00:00:00 | 2014-12-06 00:00:00
 |  |  |  |  |  | 2014-11-21 00:00:00 | 2015-04-01 00:00:00 | 2018-11-01 00:00:00
 |  |  |  |  |  | 2009-04-24 00:00:00 | 2009-07-15 00:00:00 | 2009-12-05 00:00:00
 |  |  |  |  |  | 2009-05-15 00:00:00 | 2009-07-01 00:00:00 | 2009-11-10 00:00:00
 |  |  |  |  |  | 2009-06-01 00:00:00 | 2011-07-20 00:00:00 | 2012-01-20 00:00:00
 |  |  |  |  |  | 2009-04-10 00:00:00 | 2009-07-15 00:00:00 | 2009-09-15 00:00:00
 |  |  |  |  |  | 2009-06-05 00:00:00 | 2009-08-01 00:00:00 | 2009-11-01 00:00:00
 |  |  |  |  |  | 2009-06-26 00:00:00 | 2009-08-01 00:00:00 | 2009-11-15 00:00:00
 |  |  |  |  |  | 2009-06-26 00:00:00 | 2010-04-09 00:00:00 | 2015-10-09 00:00:00
 |  |  |  |  |  | 2009-08-15 00:00:00 | 2009-09-26 00:00:00 | 2010-07-15 00:00:00
 |  |  |  |  |  | 2011-06-10 00:00:00 | 2011-07-22 00:00:00 | 2012-01-22 00:00:00
 |  |  |  |  |  | 2012-06-08 00:00:00 | 2012-07-20 00:00:00 | 2013-01-20 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2014-01-26 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2014-01-26 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2013-07-26 00:00:00
 |  |  |  |  |  | 2009-04-10 00:00:00 | 2009-06-22 00:00:00 | 2009-07-31 00:00:00
 |  |  |  |  |  | 2009-05-15 00:00:00 | 2009-06-01 00:00:00 | 11/31/09
 |  |  |  |  |  | 2009-05-15 00:00:00 | 2009-06-26 00:00:00 | 2009-09-06 00:00:00
 |  |  |  |  |  | 2009-05-15 00:00:00 | 2009-09-14 00:00:00 | 2009-11-06 00:00:00
 |  |  |  |  |  | 2009-07-24 00:00:00 | 2009-09-21 00:00:00 | 2009-11-15 00:00:00
 |  |  |  |  |  | 2009-08-28 00:00:00 | 2009-10-01 00:00:00 | 2009-05-15 00:00:00
 |  |  |  |  |  | 2010-02-26 00:00:00 | 2011-04-01 00:00:00 | 2011-06-30 00:00:00
 |  |  |  |  |  | 2010-02-26 00:00:00 | 2010-04-01 00:00:00 | 2010-08-30 00:00:00
 |  |  |  |  |  | 2010-05-15 00:00:00 | 2010-06-01 00:00:00 | 2010-11-15 00:00:00
 |  |  |  |  |  | 2009-02-27 00:00:00 | 2009-06-08 00:00:00 | 2009-07-01 00:00:00
 |  |  |  |  |  | 2010-02-26 00:00:00 | 2010-05-07 00:00:00 | 2010-11-07 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2014-01-26 00:00:00
 |  |  |  |  |  | 2013-07-26 00:00:00 | 2013-09-06 00:00:00 | 2014-11-15 00:00:00
 |  |  |  |  |  | 2031-01-01 00:00:00 | 1931-02-12 00:00:00 | 1931-02-12 00:00:00
 |  |  |  |  |  | LET_DATE | Construction_Start_Date | Construction_End_Date
 |  |  |  |  |  | 2008-09-09 00:00:00 | 2008-09-01 00:00:00 | 2009-11-30 00:00:00
 |  |  |  |  |  | 2008-11-21 00:00:00 | 2009-04-01 00:00:00 | 2009-09-30 00:00:00
 |  |  |  |  |  | 2008-11-21 00:00:00 | 2009-01-01 00:00:00 | 2009-09-30 00:00:00
 |  |  |  |  |  | 2009-12-01 00:00:00 | 2010-06-01 00:00:00 | 2011-08-01 00:00:00
 |  |  |  |  |  | 2010-01-22 00:00:00 | 2010-08-01 00:00:00 | 2010-10-30 00:00:00
 |  |  |  |  |  | 2010-04-23 00:00:00 | 2010-06-04 00:00:00 | 2010-12-04 00:00:00
 |  |  |  |  |  | 2011-11-18 00:00:00 | 2012-03-28 00:00:00 | 2012-09-28 00:00:00
 |  |  |  |  |  | 2012-05-18 00:00:00 | 2012-06-29 00:00:00 | 2012-12-19 00:00:00
 |  |  |  |  |  | 2014-11-21 00:00:00 | 2015-04-15 00:00:00 | 2017-09-01 00:00:00
 |  |  |  |  |  | 2023-04-28 00:00:00 | 2023-06-09 00:00:00 | 2023-12-09 00:00:00
 |  |  |  |  |  | 2009-05-15 00:00:00 | 2009-06-29 00:00:00 | 2009-12-29 00:00:00
 |  |  |  |  |  | 2008-12-19 00:00:00 | 2009-04-15 00:00:00 | 2009-10-15 00:00:00
 |  |  |  |  |  | 2009-03-27 00:00:00 | 2009-04-20 00:00:00 | 2009-10-30 00:00:00
 |  |  |  |  |  | 2010-08-27 00:00:00 | 2010-10-01 00:00:00 | 2011-07-01 00:00:00
 |  |  |  |  |  | 2012-06-08 00:00:00 | 2012-07-20 00:00:00 | 2013-01-20 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2014-01-26 00:00:00
 |  |  |  |  |  | 2007-05-18 00:00:00 | 2009-07-07 00:00:00 | 2009-11-01 00:00:00
 |  |  |  |  |  | 2010-04-23 00:00:00 | 2010-08-06 00:00:00 | 2011-02-06 00:00:00
 |  |  |  |  |  | 2011-01-28 00:00:00 | 2011-03-11 00:00:00 | 2011-09-11 00:00:00
 |  |  |  |  |  | 2011-01-28 00:00:00 | 2011-04-15 00:00:00 | 2011-07-01 00:00:00
 |  |  |  |  |  | 2011-07-22 00:00:00 | 2012-07-20 00:00:00 | 2013-01-20 00:00:00
 |  |  |  |  |  | 2012-06-08 00:00:00 | 2013-07-26 00:00:00 | 2014-01-26 00:00:00
 |  |  |  |  |  | 2013-06-14 00:00:00 | 2013-07-26 00:00:00 | 2014-01-26 00:00:00
 |  |  |  |  |  | 2014-03-28 00:00:00 | 2014-05-09 00:00:00 | 2014-11-09 00:00:00
 |  |  |  |  |  | 2008-06-06 00:00:00 | 2008-07-14 00:00:00 | 2011-07-22 00:00:00
 |  |  |  |  |  | 2011-05-20 00:00:00 | 2011-08-01 00:00:00 | 2011-10-15 00:00:00
 |  |  |  |  |  | 2012-06-08 00:00:00 | 2012-07-20 00:00:00 | 2013-01-20 00:00:00
 |  |  |  |  |  | 2007-06-08 00:00:00 | 2007-07-07 00:00:00 | 2009-06-05 00:00:00
 |  |  |  |  |  | 2009-03-27 00:00:00 | 2009-08-17 00:00:00 | 2009-09-15 00:00:00
 |  |  |  |  |  | 2009-05-15 00:00:00 | 2009-09-08 00:00:00 | 2010-09-15 00:00:00
 |  |  |  |  |  | 2009-07-24 00:00:00 | 2009-09-01 00:00:00 | 2009-12-01 00:00:00
 |  |  |  |  |  | 2010-01-22 00:00:00 | 2010-05-15 00:00:00 | 2010-06-30 00:00:00
 |  |  |  |  |  | 2011-11-18 00:00:00 | 2011-12-30 00:00:00 | 2012-06-30 00:00:00
 |  |  |  |  |  | 2009-05-15 00:00:00 | 2009-07-01 00:00:00 | 2009-09-01 00:00:00
 |  |  |  |  |  | 2009-05-15 00:00:00 | 2009-07-01 00:00:00 | 2009-12-01 00:00:00
 |  |  |  |  |  | 1931-01-01 00:00:00 | 1931-02-12 00:00:00 | 1931-08-12 00:00:00