Spreadsheet: 791759d1660575421-count-excluding-duplicates-with-criteria-mtd-rep-participation-report-sample-ans-2
Sheet: Sheet2

User ID
46555 |  |  |  |  |  | D2D Rep | Sales ID | Employee ID | Form ID | Form Name | FormInstanceID |  |  |  | Date Submitted | Time Submitted | Adjusted Date Submitted | Timezone | Form Duration | Knock Rank | Attempt | Unique Door | Contact | Presentation | Sold | Active Lead | [NAME] | Lead ID | Sys | Prin | House Key | House Status | Node | Address1 | Address2 | City | State | Zip | Distance from Entity | Video | Internet | Voice | House Status at Assignment | Current Sales Cycle | PIA Required | PIA Method | PIA Amount | Mobile | Notes | New Build Flag | Mobile Lines Sold | Mobile Lines [NAME] | Distinct Rep | Distinct Date | Total Reps | Distinct Reps With Sales/Day | Distinct Reps With 2+ Sales/Day | 1 sale | More than 1 sale
26842 |  |  |  |  |  | [NAME] | 61976 | 6201389 | 1001199 | Unoccupied | 145483946 |  |  |  | 8/5/2022 | 16:28:14 | 2022-08-05 17:28:14.897000 | EDT | 00:00:00 | 1 | 0 | 1 | 0 | 0 | 0 | 0 |  | 165901408559139793067 | 8349 | 2100 | 29550453405012 | Non-Sub | 2H060 | 330 BELL AVE | BLDG B # B | HARTSVILLE | SC | 29550 | 5463.2411 |  |  |  | Non-Sub | 1 |  |  |  | 0 |  | Legacy
46555 |  |  |  |  |  | [NAME] | 33899 | 6080103 | 1001199 | Unoccupied | 145276626 |  |  |  | 8/2/2022 | 16:13:10 | 2022-08-02 17:13:10.503000 | EDT | 00:00:00 | 1 | 0 | 1 | 0 | 0 | 0 | 0 |  | 165863776019951094738 | 8349 | 2100 | 29540806805026 | Non-Sub | 2D164 | 612 SOCIETY HILL RD |  | DARLINGTON | SC | 29540 | 5032.5048 |  |  |  | Non-Sub | 1 |  |  |  | 0 |  | Legacy
45457 |  |  |  |  |  | [NAME] | 61976 | 6201389 | 1001171 | Not Home | 145178927 |  |  |  | 8/1/2022 | [NAME] | 2022-08-01 13:43:19.113000 | EDT | 00:00:00 | 1 | 1 | 1 | 0 | 0 | 0 | 1 |  | 165901408380751851863 | 8349 | 2100 | 29550454105124 | Non-Sub | 2H060 | 411 MARLBORO AVE | UNIT A | HARTSVILLE | SC | 29550 | 90.4094 |  |  |  | Non-Sub | 1 |  |  |  | 0 |  | Legacy
26842 |  |  |  |  |  | [NAME] | 61625 | 6193496 | 1001170 | Invalid Address | 145199058 |  |  |  | 8/1/2022 | 15:20:35 | 2022-08-01 16:20:35.310000 | EDT | 00:00:04 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | Vacant Lot | 165902081367249580978 | 8349 | 2100 | 29560252905047 | Non-Sub | 2L032 | 364 WARD ST | APT B | LAKE CITY | SC | 29560 | 0 |  |  |  | Non-Sub | 1 |  |  |  | 0 |  | Legacy
49178 |  |  |  |  |  | [NAME] | 33899 | 6080103 | 1001171 | Not Home | 145766840 |  |  |  | 8/11/2022 | 16:26:58 | 2022-08-11 17:26:58.537000 | EDT | 00:00:00 | 1 | 1 | 1 | 0 | 0 | 0 | 1 |  | 165901555652140866049 | 8349 | 2100 | 29554666905016 | Non-Sub | 2J007 | 401 E RICHARDSON AVE |  | HEMINGWAY | SC | 29554 | 116.2735 |  |  |  | Non-Sub | 1 |  |  |  | 0 |  | Legacy
 |  |  |  |  |  | [NAME] |  | 6217970 | 1001174 | Not Interested | 145534276 |  |  |  | 8/8/2022 | 10:23:40 | 2022-08-08 11:23:40.463000 | EDT | 00:00:10 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | No | 165863294967442516660 | 8349 | 2100 | 29501560605044 | Non-Sub | 2F312 | 1414 FAIRFAX RD |  | FLORENCE | SC | 29501 | 0 |  |  |  | Non-Sub | 1 |  |  |  | 0 |  | Legacy
41695 |  |  |  |  |  | [NAME] |  | 6217970 | 1001174 | Not Interested | 145534276 |  |  |  | 8/8/2022 | 10:23:40 | 2022-08-08 11:23:40.463000 | EDT | 00:00:10 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | No | 165863294967442516660 | 8349 | 2100 | 29501560605044 | Non-Sub | 2F312 | 1414 FAIRFAX RD |  | FLORENCE | SC | 29501 | 0 |  |  |  | Non-Sub | 1 |  |  |  | 0 |  | Legacy
 |  |  |  |  |  | [NAME] |  | 6217970 | 1001174 | Not Interested | 145534276 |  |  |  | 8/8/2022 | 10:23:40 | 2022-08-08 11:23:40.463000 | EDT | 00:00:10 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | No | 165863294967442516660 | 8349 | 2100 | 29501560605044 | Non-Sub | 2F312 | 1414 FAIRFAX RD |  | FLORENCE | SC | 29501 | 0 |  |  |  | Non-Sub | 1 |  |  |  | 0 |  | Legacy
 |  |  |  |  |  | [NAME] |  | 6217970 | 1001174 | Not Interested | 145534276 |  |  |  | 8/8/2022 | 10:23:40 | 2022-08-08 11:23:40.463000 | EDT | 00:00:10 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | No | 165863294967442516660 | 8349 | 2100 | 29501560605044 | Non-Sub | 2F312 | 1414 FAIRFAX RD |  | FLORENCE | SC | 29501 | 0 |  |  |  | Non-Sub | 1 |  |  |  | 0 |  | Legacy
48967 |  |  |  |  |  | [NAME] | 17277 | 6170329 | 1001199 | Unoccupied | 145571421 |  |  |  | 8/8/2022 | 16:41:25 | 2022-08-08 17:41:25.633000 | EDT | 00:00:00 | 1 | 0 | 1 | 0 | 0 | 1 | 0 |  | 165901587238555256483 | 8349 | 2100 | 29536335905030 | Non-Sub | 2B008 | 710 W MAIN ST |  | DILLON | SC | 29536 |  |  |  |  | Non-Sub | 1 |  |  |  | 0 |  | Legacy
27733 |  |  |  |  |  | [NAME] | 76351 | 6218650 | 1001170 | Invalid Address | 145175145 |  |  |  | 8/1/2022 | 11:53:12 | 2022-08-01 12:53:12.943000 | EDT | 00:00:15 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | Vacant Lot | 165861560607346082525 | 8349 | 2100 | 29536782205017 | Non-Sub | 2B005 | 1027 AIRPORT RD |  | DILLON | SC | 29536 | 13878.5415 |  |  |  | Non-Sub | 1 |  |  |  | 0 |  | Legacy
48174 |  |  |  |  |  | [NAME] | 72448 | 6085794 | 1001174 | Not Interested | 145137264 |  |  |  | 8/1/2022 | 18:17:21 | 2022-07-29 19:17:21.707000 | EDT | 00:00:13 | 2 | 1 | 0 | 1 | 0 | 1 | 0 | No | 165871312799556346933 | 8349 | 2100 | 29520202505016 | Non-Sub | 2C222 | 45 WINDSOR DR |  | CHERAW | SC | 29520 | 802.7809 |  |  |  | Non-Sub | 1 |  |  |  | 0 |  | Legacy
41695 |  |  |  |  |  | [NAME] | 73458 | 6213152 | 1001171 | Not Home | 145492610 |  |  |  | 8/1/2022 | 17:27:38 | 2022-08-05 18:27:38.427000 | EDT | 00:00:00 | 1 | 1 | 1 | 0 | 0 | 1 | 1 |  | 165906712041940483664 | 8349 | 2100 | 29501260105071 | Non-Sub | 2F089 | 222 CAMERON LN |  | FLORENCE | SC | 29501 | 141.945 |  |  |  | Non-Sub | 1 |  |  |  | 0 |  | Legacy
 |  |  |  |  |  | [NAME] | 17277 | 6170329 | 1001172 | Not Home - 2nd Attempt | 145872048 |  |  |  | 8/13/2022 | 15:21:35 | 2022-08-13 16:21:35.880000 | EDT | 00:00:00 | 2 | 1 | 0 | 0 | 0 | 0 | 1 |  | 165902075962940755898 | 8349 | 2100 | 29560340405083 | Non-Sub | 2L008 | 127 BUFF RD |  | LAKE CITY | SC | 29560 | 138.3643 |  |  |  | Non-Sub | 1 |  |  |  | 0 |  | Legacy