Spreadsheet: 695044d1600001064-extract-values-in-column-s-into-column-r-desired-output-column-sample_sept
Sheet: Sheet1 (3)

Sales ID | [NAME] | ZIP Code | Agent Name | Sales Start Date | Sales End Date | Sales Period | Sales Period-1 | Sales Period-2 | Gain | Profit | Non-Profit | Adjusted Profit | Cond |  | AO | Sum (all Output) | Desired Output | Index [NAME] | Cond-1 | Cond-2 | Cond-3
885535104 | 3Com Corporation | 1999 | Dorman, [NAME] | 1995 | 2001 |  |  |  | - | - | 0 | 0 | Dorman, [NAME]
808655104 | Scientific-Atlanta, Inc. | 1999 | Dorman, [NAME] | 1998 | 2001 |  |  |  | - | - | 0 | 0 | Dorman, [NAME]
885535104 | 3Com Corporation | 2000 | Dorman, [NAME] | 1995 | 2001 |  |  |  | - | - | 0 | 0 | Dorman, [NAME]
808655104 | Scientific-Atlanta, Inc. | 2000 | Dorman, [NAME] | 1998 | 2001 |  |  |  | - | - | 0 | 0 | Dorman, [NAME]
885535104 | 3Com Corporation | 2001 | Dorman, [NAME] | 1995 | 2003 |  |  |  | - | - | 0 | 0 | Dorman, [NAME]
785905100 | Sabre Holdings Corporation [Cl A] | 2001 | Dorman, [NAME] | 2000 | 2003 |  |  |  | - | - | - | - | Dorman, [NAME]
808655104 | Scientific-Atlanta, Inc. | 2001 | Dorman, [NAME] | 1998 | 2004 |  |  |  | - | - | 0 | 0 | Dorman, [NAME]
00207Q202 | AT&T Corporation | 2002 | Dorman, [NAME] | 2002 | 2003 |  |  |  | - | - | 0 | 0 | Dorman, [NAME]
785905100 | Sabre Holdings Corporation [Cl A] | 2002 | Dorman, [NAME] | 2000 | 2003 |  |  |  | - | - | - | - | Dorman, [NAME]
808655104 | Scientific-Atlanta, Inc. | 2002 | Dorman, [NAME] | 1998 | 2005 |  |  |  | - | - | 0 | 0 | Dorman, [NAME]
00207Q202 | AT&T Corporation | 2003 | Dorman, [NAME] | 2002 | 2004 |  |  |  | - | - | - | - | Dorman, [NAME]
808655104 | Scientific-Atlanta, Inc. | 2003 | Dorman, [NAME] | 1998 | 2005 |  |  |  | - | - | 0 | 0 | Dorman, [NAME]
00207Q202 | AT&T Corporation | 2004 | Dorman, [NAME] | 2002 | 2005 |  |  |  | - | - | - | - | Dorman, [NAME]
808655104 | Scientific-Atlanta, Inc. | 2004 | Dorman, [NAME] | 1998 | 2005 |  |  |  | - | - | 0 | 0 | Dorman, [NAME]
808655104 | Scientific-Atlanta, Inc. | 2005 | Dorman, [NAME] | 1998 | 2007 |  |  |  | - | - | 0 | 0 | Dorman, [NAME]
988498101 | Yum! Brands, Inc. (F.K.A: Tricon Global Restaurants, Inc.) | 2005 | Dorman, [NAME] | 2005 | 2005 |  |  |  | - | - | 0 | 0 | Dorman, [NAME]
126650100 | CVS Health Corporation | 2006 | Dorman, [NAME] | 2006 | 2007 |  |  |  | - | - | - | - | Dorman, [NAME]
988498101 | Yum! Brands, Inc. (F.K.A: Tricon Global Restaurants, Inc.) | 2006 | Dorman, [NAME] | 2005 | 2007 |  |  |  | - | - | 0 | 0 | Dorman, [NAME]
126650100 | CVS Health Corporation | 2007 | Dorman, [NAME] | 2006 | NONE |  |  |  | - | - | - | - | Dorman, [NAME]
988498101 | Yum! Brands, Inc. (F.K.A: Tricon Global Restaurants, Inc.) | 2007 | Dorman, [NAME] | 2005 | NONE |  |  |  | - | - | 0 | 0 | Dorman, [NAME]
126650100 | CVS Health Corporation | 2008 | Dorman, [NAME] | 2006 | NONE | 2006 | S | A | - | - | - | - | Dorman, [NAME]
620076109 | Motorola, Inc. | 2008 | Dorman, [NAME] | 2006 | NONE | 2006 | S | A | 1 | 0 | 0 | 0 | Dorman, [NAME] |  |  |  | Motorola, Inc.
988498101 | Yum! Brands, Inc. (F.K.A: Tricon Global Restaurants, Inc.) | 2008 | Dorman, [NAME] | 2005 | NONE | 2006 | B | A | 0 | 1 | 0 | 0 | Dorman, [NAME] |  |  |  | Yum! Brands, Inc. (F.K.A: Tricon Global Restaurants, Inc.)
126650100 | CVS Health Corporation | 2009 | Dorman, [NAME] | 2006 | NONE | 2007 | B | A | - | - | - | - | Dorman, [NAME]
620076109 | Motorola, Inc. | 2009 | Dorman, [NAME] | 2006 | NONE | 2007 | B | A | 0 | 1 | 0 | 0 | Dorman, [NAME] |  |  |  | Motorola, Inc.
988498101 | Yum! Brands, Inc. (F.K.A: Tricon Global Restaurants, Inc.) | 2009 | Dorman, [NAME] | 2005 | NONE | 2007 | B | A | 0 | 1 | 0 | 0 | Dorman, [NAME] |  |  |  | Yum! Brands, Inc. (F.K.A: Tricon Global Restaurants, Inc.)
126650100 | CVS Health Corporation | 2010 | Dorman, [NAME] | 2006 | NONE |  |  |  | - | - | - | - | Dorman, [NAME]
620076109 | Motorola, Inc. | 2010 | Dorman, [NAME] | 2006 | NONE | 2008 | B | A | 0 | 1 | 0 | 0 | Dorman, [NAME] |  |  |  | Motorola, Inc.
988498101 | Yum! Brands, Inc. (F.K.A: Tricon Global Restaurants, Inc.) | 2010 | Dorman, [NAME] | 2005 | NONE | 2008 | B | A | 0 | 1 | 0 | 0 | Dorman, [NAME] |  |  |  | Yum! Brands, Inc. (F.K.A: Tricon Global Restaurants, Inc.)
126650100 | CVS Health Corporation | 2011 | Dorman, [NAME] | 2006 | NONE |  |  |  | - | - | - | - | Dorman, [NAME]
620076109 | Motorola, Inc. | 2011 | Dorman, [NAME] | 2006 | NONE | 2009 | B | A | 0 | 1 | 0 | 0 | Dorman, [NAME] |  |  |  | Motorola, Inc.
988498101 | Yum! Brands, Inc. (F.K.A: Tricon Global Restaurants, Inc.) | 2011 | Dorman, [NAME] | 2005 | NONE | 2009 | B | A | 0 | 1 | 0 | 0 | Dorman, [NAME] |  |  |  | Yum! Brands, Inc. (F.K.A: Tricon Global Restaurants, Inc.)
126650100 | CVS Health Corporation | 2012 | Dorman, [NAME] | 2006 | NONE |  |  |  | - | - | - | - | Dorman, [NAME]
620076109 | Motorola, Inc. | 2012 | Dorman, [NAME] | 2006 | NONE |  |  |  | - | - | - | - | Dorman, [NAME] |  |  |  | Motorola, Inc.
988498101 | Yum! Brands, Inc. (F.K.A: Tricon Global Restaurants, Inc.) | 2012 | Dorman, [NAME] | 2005 | NONE |  |  |  | - | - | - | - | Dorman, [NAME] |  |  |  | Yum! Brands, Inc. (F.K.A: Tricon Global Restaurants, Inc.)
126650100 | CVS Health Corporation | 2013 | Dorman, [NAME] | 2006 | NONE |  |  |  | - | - | - | - | Dorman, [NAME]
620076109 | Motorola, Inc. | 2013 | Dorman, [NAME] | 2006 | NONE |  |  |  | - | - | - | - | Dorman, [NAME] |  |  |  | Motorola, Inc.
988498101 | Yum! Brands, Inc. (F.K.A: Tricon Global Restaurants, Inc.) | 2013 | Dorman, [NAME] | 2005 | NONE |  |  |  | - | - | - | - | Dorman, [NAME] |  |  |  | Yum! Brands, Inc. (F.K.A: Tricon Global Restaurants, Inc.)