Spreadsheet: 696827d1600996884-fill-down-values-in-column-l-p-fill-down_form_1_gw_revised_reva1
Sheet: Sheet4 (2)

Sales ID | Sales Office | [NAME] | [NAME] | Zip | Agent (=0)? | Non-Agent (1) | Position-1 | Position-2 | Filled Position |  | Agent (=0)? | Non-Agent (1) | Position-1 | Position-2 | Filled Position |  | Expected results |  |  |  |  | Check
885535104 | 10Com | 1999 | [NAME], [NAME] | 25 | 0 | 1 | 0 | 0 | 1 |  |  |  |  |  |  |  | 0 | 1 | 0 | 0 | 1
232806109 | Cyper | 1999 | [NAME], [NAME] | 25 | 0 | 1 | 0 | 0 | 1 |  |  |  |  |  |  |  | 0 | 1 | 0 | 0 | 1
524651106 | Legend | 1999 | [NAME], [NAME] | 25 | - | - | - | - | - |  |  |  |  |  |  |  | - | - | - | - | -
885535104 | 10Com | 2000 | [NAME], [NAME] | 25 | 0 | 1 | 0 | 0 | 1 |  |  |  |  |  |  |  | 0 | 1 | 0 | 0 | 1
232806109 | Cyper | 2000 | [NAME], [NAME] | 25 | 0 | 1 | 0 | 0 | 1 |  |  |  |  |  |  |  | 0 | 1 | 0 | 0 | 1
524651106 | Legend | 2000 | [NAME], [NAME] | 25 | - | - | - | - | - |  |  |  |  |  |  |  | - | - | - | - | -
885535104 | 10Com | 2001 | [NAME], [NAME] | 25 | 0 | 1 | 0 | 0 | 1 |  |  |  |  |  |  |  | 0 | 1 | 0 | 0 | 1
232806109 | Cyper | 2001 | [NAME], [NAME] | 25 | 0 | 1 | 0 | 0 | 1 |  |  |  |  |  |  |  | 0 | 1 | 0 | 0 | 1
524651106 | Legend | 2001 | [NAME], [NAME] | 25 | - | - | - | - | - |  |  |  |  |  |  |  | - | - | - | - | -
696643105 | Pamosa | 2001 | [NAME], [NAME] | 25 | 1 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 1
885535104 | 10Com | 2002 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
232806109 | Cyper | 2002 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
524651106 | Legend | 2002 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | -
696643105 | Pamosa | 2002 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 1 | 1 | 0
885535104 | 10Com | 2003 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
232806109 | Cyper | 2003 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
46069S109 | Inter | 2003 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | -
524651106 | Legend | 2003 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | -
885535104 | 10Com | 2004 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
232806109 | Cyper | 2004 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
885535104 | 10Com | 2005 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
232806109 | Cyper | 2005 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
78486Q101 | SVBFG | 2005 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | -
885535104 | 10Com | 2006 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
232806109 | Cyper | 2006 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
696643105 | Pamosa | 2006 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 1 | 1 | 0
78486Q101 | SVBFG | 2006 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | -
885535104 | 10Com | 2007 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
232806109 | Cyper | 2007 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
696643105 | Pamosa | 2007 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 1 | 1 | 0
78486Q101 | SVBFG | 2007 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | -
885535104 | 10Com | 2008 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
232806109 | Cyper | 2008 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
78486Q101 | SVBFG | 2008 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | -
885535104 | 10Com | 2009 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
232806109 | Cyper | 2009 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
78486Q101 | SVBFG | 2009 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | -
232806109 | Cyper | 2010 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
78486Q101 | SVBFG | 2010 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | -
232806109 | Cyper | 2011 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
78486Q101 | SVBFG | 2011 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | -
232806109 | Cyper | 2012 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
78486Q101 | SVBFG | 2012 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | -
232806109 | Cyper | 2013 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
78486Q101 | SVBFG | 2013 | [NAME], [NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | -
004933107 | Action | 2001 | Bar, Herb M. | 27 | 0 | 1 | 0 | 0 | 1 |  |  |  |  |  |  |  | 0 | 1 | 0 | 0 | 1
25247D101 | Dial | 2001 | Bar, Herb M. | 27 | 0 | 1 | 0 | 0 | 1 |  |  |  |  |  |  |  | 0 | 1 | 0 | 0 | 1
339130106 | Fleming | 2001 | Bar, Herb M. | 27 | - | - | - | - | - |  |  |  |  |  |  |  | - | - | - | - | -
339130106 | Fleming | 2001 | Bar, Herb M. | 27 | - | - | - | - | - |  |  |  |  |  |  |  | - | - | - | - | -
589433101 | Meredith | 2001 | Bar, Herb M. | 27 | 0 | 1 | 0 | 0 | 1 |  |  |  |  |  |  |  | 0 | 1 | 0 | 0 | 1
595626102 | Mid | 2001 | Bar, Herb M. | 27 | 0 | 1 | 0 | 0 | 1 |  |  |  |  |  |  |  | 0 | 1 | 0 | 0 | 1
71343P200 | Pep | 2001 | Bar, Herb M. | 27 | 0 | 1 | 0 | 0 | 1 |  |  |  |  |  |  |  | 0 | 1 | 0 | 0 | 1
004933107 | Action | 2002 | Bar, Herb M. | 27 | - | - | - | - | - |  |  |  |  |  |  |  | - | - | - | - | -
25247D101 | Dial | 2002 | Bar, Herb M. | 27 | 1 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 1
339130106 | Fleming | 2002 | Bar, Herb M. | 27 | - | - | - | - | - |  |  |  |  |  |  |  | - | - | - | - | -
589433101 | Meredith | 2002 | Bar, Herb M. | 27 | 1 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 1
595626102 | Mid | 2002 | Bar, Herb M. | 27 | 1 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 1
71343P200 | Pep | 2002 | Bar, Herb M. | 27 | 1 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 1
004933107 | Action | 2003 | Bar, Herb M. | 27 | 1 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 1
25247D101 | Dial | 2003 | Bar, Herb M. | 27 | 1 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 1
589433101 | Meredith | 2003 | Bar, Herb M. | 27 | 1 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 1
71343P200 | Pep | 2003 | Bar, Herb M. | 27 | 1 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 1
339130106 | Action | 2004 | Bar, Herb M. | 27 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
589433101 | Meredith | 2005 | Bar, Herb M. | 27 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
595626102 | Mid | 2006 | Bar, Herb M. | 27 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
71343P200 | Pep | 2007 | Bar, Herb M. | 27 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
004933107 | Action | 2008 | Bar, Herb M. | 27 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 0
25247D101 | Dial | 2009 | Bar, Herb M. | 27 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 1 | 1 | 0
589433101 | Meredith | 2010 | Bar, Herb M. | 27 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 1 | 1 | 0
71343P200 | Pep | 2011 | Bar, Herb M. | 27 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 1 | 1 | 0