Spreadsheet: 84517d1284565745-lookup-and-conditional-formatting-test-version-formatting
Sheet: Sheet1

CUSTOM CONTRACTS |  |  |  |  | ALLIANCE |  |  |  |  | 2010-09-15 00:00:00
Contract Number | [NAME] | Contract Eff Date | Contract Exp Date | Months remaining before Exp | CITRUS | Multi | SweD | CentWA | Alliance Participation | In Tracking Master [NAME]? | count for # alliances accessing contract
PCE40141 |  | 2008-07-01 00:00:00 | 2010-12-31 00:00:00 | 3 |  |  |  |  | 0 | PCE40141 | 0
PCE50191 |  | 2009-08-01 00:00:00 | 2010-09-30 00:00:00 | 0 |  |  |  |  | 0.5 | PCE50191 | 2
PCE60021 |  | 2006-03-01 00:00:00 | 2011-02-28 00:00:00 | 5 |  |  |  |  | 0 | PCE60021 | 0
PCE60031 |  | 2008-02-01 00:00:00 | 2010-12-31 00:00:00 | 3 |  |  |  |  | 1 | PCE60031 | 4
PCE60092 |  | 2006-08-01 00:00:00 | 2011-05-31 00:00:00 | 8 |  |  |  |  | 0 | PCE60092 | 0
PCE60102 |  | 2009-06-01 00:00:00 | 2011-05-31 00:00:00 | 8 |  |  |  |  | 0.25 | PCE60102 | 1
PCE80162 |  | 2008-07-01 00:00:00 | 2011-06-30 00:00:00 | 9 |  |  |  |  | 0 | PCE80162 | 0
PCE91012 |  | 2009-03-01 00:00:00 | 2012-02-28 00:00:00 | 17 |  |  |  |  | 1 | Not Found | 4
PCE91046 |  | 2009-06-01 00:00:00 | 2012-05-31 00:00:00 | 20 |  |  |  |  | 1 | Not Found | 4
PDL91000 |  | 2010-05-01 00:00:00 | 2014-09-30 00:00:00 | 48 |  |  |  |  | 0.75 | PDL91000 | 3
PDP50016 |  | 2007-02-09 00:00:00 | 2011-05-31 00:00:00 | 8 |  |  |  |  | 0 | PDP50016 | 0
PDPCARD |  | 2007-07-16 00:00:00 | 2011-04-30 00:00:00 | 7 |  |  |  |  | 0 | PDPCARD | 0
PDR80010 |  | 2008-07-21 00:00:00 | 2010-12-31 00:00:00 | 3 |  |  |  |  | 0 | PDR80010 | 0
[NAME] |  | 2010-02-15 00:00:00 | 2012-12-31 00:00:00 | 27 |  |  |  |  | 0.75 | [NAME] | 3
[NAME] |  | 2004-09-14 00:00:00 | 2016-05-31 00:00:00 | 68 |  |  |  |  | 0.25 | [NAME] | 1
PIV4001C |  | 2004-09-14 00:00:00 | 2012-05-31 00:00:00 | 20 |  |  |  |  | 0.25 | Not Found | 1
PIV4001E |  | 2004-09-14 00:00:00 | 2012-05-31 00:00:00 | 20 |  |  |  |  | 0.25 | Not Found | 1
PIV4001P |  | 2004-09-14 00:00:00 | 2012-05-31 00:00:00 | 20 |  |  |  |  | 0.25 | Not Found | 1
PLB40021 |  | 2005-09-01 00:00:00 | 2010-01-31 00:00:00 | -8 |  |  |  |  | 0 | PLB40021 | 0
PLB50011 |  | 2007-02-01 00:00:00 | 2010-07-31 00:00:00 | -2 |  |  |  |  | 0 | PLB50011 | 0
PLB60050 |  | 2007-04-01 00:00:00 | 2010-09-30 00:00:00 | 0 |  |  |  |  | 0.5 | Not Found | 2
PMS01103 |  | 2010-01-01 00:00:00 | 2012-12-31 00:00:00 | 27 |  |  |  |  | 0.5 | PMS01103 | 2
PMS01104 |  | 2010-01-01 00:00:00 | 2012-12-31 00:00:00 | 27 |  |  |  |  | 0.5 | PMS01104 | 2
PMS40254 |  | 2008-02-01 00:00:00 | 2010-12-31 00:00:00 | 3 |  |  |  |  | 1 | PMS40254 | 4
PMS50292 |  | 2008-09-08 00:00:00 | 2012-12-31 00:00:00 | 27 |  |  |  |  | 0.5 | PMS50292 | 2
PMS50661 |  | 2007-03-01 00:00:00 | 2011-02-28 00:00:00 | 5 |  |  |  |  | 0.5 | PMS50661 | 2
PMS60231 |  | 2010-03-01 00:00:00 | 2011-12-31 00:00:00 | 15 |  |  |  |  | 1 | PMS60231 | 4
PMS60450 |  | 2008-09-15 00:00:00 | 2013-12-31 00:00:00 | 39 |  |  |  |  | 1 | PMS60450 | 4
PMS60461 |  | 2008-09-15 00:00:00 | 2013-12-31 00:00:00 | 39 |  |  |  |  | 1 | PMS60461 | 4
PMS70103 |  | 2007-10-01 00:00:00 | 2011-12-31 00:00:00 | 15 |  |  |  |  | 0.25 | PMS70103 | 1
PMS70130 |  | 2007-07-01 00:00:00 | 2011-12-31 00:00:00 | 15 |  |  |  |  | 0.25 | PMS70130 | 1
PMS7013N |  | 2007-07-01 00:00:00 | 2011-12-31 00:00:00 | 15 |  |  |  |  | 0.25 | Not Found | 1
PMS70152 |  | 2007-10-01 00:00:00 | 2011-12-31 00:00:00 | 15 |  |  |  |  | 1 | PMS70152 | 4
PMS80550 |  | 2009-02-01 00:00:00 | 2010-12-31 00:00:00 | 3 |  |  |  |  | 0.25 | PMS80550 | 1
PMS80562 |  | 2008-08-01 00:00:00 | 2013-07-31 00:00:00 | 34 |  |  |  |  | 0.5 | Not Found | 2
PMS90830 |  | 2009-03-01 00:00:00 | 2010-11-30 00:00:00 | 2 |  |  |  |  | 1 | PMS90830 | 4
PMS92091 |  | 2010-01-01 00:00:00 | 2013-12-31 00:00:00 | 39 |  |  |  |  | 0.75 | Not Found | 3
PMS93003 |  | 2010-01-01 00:00:00 | 2013-12-31 00:00:00 | 39 |  |  |  |  | 1 | Not Found | 4
PSBP001 |  | 2008-01-01 00:00:00 | 2012-12-31 00:00:00 | 27 |  |  |  |  | 1 | PSBP001 | 4
PSCE003 |  | 2006-08-01 00:00:00 | 2014-07-31 00:00:00 | 46 |  |  |  |  | 0 | PSCE003 | 0
PSCE005 |  | 2009-02-01 00:00:00 | 2012-01-31 00:00:00 | 16 |  |  |  |  | 0.25 | PSCE005 | 1
PSDM001 |  | 2005-01-01 00:00:00 | 2011-12-31 00:00:00 | 15 |  |  |  |  | 0.25 | PSDM001 | 1
PSDM002 |  | 2005-03-15 00:00:00 | 2013-10-31 00:00:00 | 37 |  |  |  |  | 0 | PSDM002 | 0
PSFM001 |  | 2009-06-01 00:00:00 | 2012-05-31 00:00:00 | 20 |  |  |  |  | 0.25 | PSFM001 | 1
PSLB001 |  | 2005-10-01 00:00:00 | 2010-09-30 00:00:00 | 0 |  |  |  |  | 0.25 | PSLB001 | 1
PSLB002 |  | 2008-11-01 00:00:00 | 2011-10-31 00:00:00 | 13 |  |  |  |  | 0.75 | PSLB002 | 3
PSMS001 |  | 2005-07-01 00:00:00 | 2011-01-31 00:00:00 | 4 |  |  |  |  | 0.25 | PSMS001 | 1
[NAME] |  | 2005-07-01 00:00:00 | 2011-01-31 00:00:00 | 4 |  |  |  |  | 0.25 | [NAME] | 1
PSSV001 |  | 2005-12-19 00:00:00 | 2011-03-31 00:00:00 | 6 |  |  |  |  | 0 | PSSV001 | 0
PSVC970 |  | 2009-07-15 00:00:00 | 2011-07-14 00:00:00 | 10 |  |  |  |  | 1 | PSVC970 | 4
PSXR001 |  | 2005-02-01 00:00:00 | 2012-06-30 00:00:00 | 21 |  |  |  |  | 1 | PSXR001 | 4
PSXR001A |  | 2005-02-01 00:00:00 | 2012-06-30 00:00:00 | 21 |  |  |  |  | 1 | Not Found | 4
PSXR001B |  | 2005-02-01 00:00:00 | 2012-06-30 00:00:00 | 21 |  |  |  |  | 1 | Not Found | 4
PSXR001C |  | 2005-02-01 00:00:00 | 2012-06-30 00:00:00 | 21 |  |  |  |  | 1 | Not Found | 4
PSXR001D |  | 2005-02-01 00:00:00 | 2012-06-30 00:00:00 | 21 |  |  |  |  | 1 | Not Found | 4
PSXR001E |  | 2005-02-01 00:00:00 | 2012-06-30 00:00:00 | 21 |  |  |  |  | 1 | Not Found | 4
PSXR01AN |  | 2005-02-01 00:00:00 | 2012-06-30 00:00:00 | 21 |  |  |  |  | 1 | Not Found | 4
PSXR01BN |  | 2005-02-01 00:00:00 | 2012-06-30 00:00:00 | 21 |  |  |  |  | 1 | Not Found | 4
PSXR01DN |  | 2005-02-01 00:00:00 | 2012-06-30 00:00:00 | 21 |  |  |  |  | 1 | Not Found | 4
PSXR002 |  | 2007-09-01 00:00:00 | 2011-10-01 00:00:00 | 13 |  |  |  |  | 0.75 | PSXR002 | 3
PSXR003 |  | 2007-10-01 00:00:00 | 2010-09-30 00:00:00 | 0 |  |  |  |  | 0 | PSXR003 | 0
PXR50112 |  | 2006-04-01 00:00:00 | 2010-08-31 00:00:00 | -1 |  |  |  |  | 0.5 | PXR50112 | 2
[NAME] |  | 2006-04-01 00:00:00 | 2010-08-31 00:00:00 | -1 |  |  |  |  | 0.25 | [NAME] | 1
PXR90010 |  | 2005-01-01 00:00:00 | 2012-12-31 00:00:00 | 27 |  |  |  |  | 0.25 | PXR90010 | 1
PLB01031 |  | 2010-04-01 00:00:00 | 2013-01-31 00:00:00 | 28 |  |  |  |  | 0.75 | Not Found | 3
PMS70253 |  | 2010-01-01 00:00:00 | 2014-12-13 00:00:00 | 51 |  |  |  |  | 0.75 | Not Found | 3
PSMS004 |  | 2010-09-01 00:00:00 | 2013-08-31 00:00:00 | 35 |  |  |  |  | 0.25 | Not Found | 1
PSMS005 |  | 2010-09-01 00:00:00 | 2015-08-31 00:00:00 | 59 |  |  |  |  | 0.25 | Not Found | 1