Spreadsheet: 116284d1311717969-sumprod_index-issue-sample_sumprod_index
Sheet: Chicago-SE_ISE

Period and Week | Number of TSPs | Days Worked | Cold Calls | Telepros.* | Appts Booked | # of Sched. First Auto Appts | # of Follow-up Auto Appts | # of No Shows | # of Completed Auto Appts | Referrals | Data Security Audits | Trials Left | # of [NAME] (CSAs) | # of Auto Service Locations | New Auto Revenue | Client Care Calls | # of Purges Sold | Est. [NAME] | Roadside Coaching | Ramp-up | # of LVO’s won | Combined Annual LVO $ [NAME] | [NAME]. LVO $ value | PTD per end of W4/W5 | [NAME]
P1W1 | 6 | 29 | 349 | 1042 | 33 | 28 | 8 | 0 | 36 | 6 | 10 | 4 | 10 | 10 | 784 | 16 | 11 | 2731 | 7 |  | 0 | 0 | 0
P1W2 | 6 | 30 | 310 | 1052 | 83 | 53 | 14 | 1 | 66 | 8 | 8 | 0 | 23 | 23 | 904 | 16 | 14 | 8028.62 | 5 |  | 0 | 0 | 0
P1W3 | 6 | 24 | 238 | 859 | 30 | 26 | 11 | 1 | 36 | 6 | 8 | 0 | 5 | 5 | 367.8 | 16 | 14 | 5140.42 | 5 |  | 0 | 0 | 0
P1W4 | 6 | 21 | 384 | 720 | 32 | 28 | 13 | 0 | 41 | 5 | 6 | 3 | 6 | 6 | 515 | 10 | 15 | 4818 | 5 |  | 0 | 0 | 0
P1W5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
P2W1 | 6 | 16 | 144 | 547 | 18 | 13 | 2 | 0 | 15 | 3 | 3 | 0 | 3 | 3 | 160 | 7 | 5 | 1243.4 | 2 |  | 0 | 0 | 0
P2W2 | 4 | 20 | 252 | 723 | 22 | 20 | 3 | 1 | 22 | 4 | 5 | 1 | 2 | 2 | 95 | 10 | 6 | 3453 | 2 |  | 0 | 0 | 0
P2W3 | 4 | 20 | 260 | 701 | 19 | 25 | 10 | 1 | 34 | 8 | 7 | 0 | 5 | 5 | 293 | 9 | 8 | 3078 | 6 |  | 0 | 0 | 0
P2W4 | 4 | 15 | 172 | 533 | 13 | 11 | 9 | 1 | 19 | 1 | 3 | 1 | 4 | 5 | 596 | 3 | 2 | 505 | 4 |  | 0 | 0 | 0
P3W1 | 3 | 13 | 166 | 315 | 22 | 18 | 7 | 1 | 24 | 1 | 5 | 0 | 10 | 10 | 630 | 6 | 5 | 2926 | 4 |  | 0 | 0 | 0
[NAME] | 3 | 8 | 139 | 352 | 12 | 5 | 1 | 0 | 6 | 0 | 1 | 0 | 3 | 3 | 140 | 0 | 2 | 2975 | 1 |  | 0 | 0 | 0
P3W3 | 3 | 15 | 196 | 574 | 16 | 18 | 12 | 1 | 29 | 2 | 5 | 0 | 3 | 2 | 340 | 6 | 6 | 1622 | 3 |  | 0 | 0 | 0
P3W4 | 4 | 20 | 306 | 694 | 17 | 18 | 6 | 0 | 24 | 2 | 9 | 0 | 3 | 3 | 127 | 9 | 3 | 371 | 0 |  | 0 | 0 | 0
P4W1 | 4 | 20 | 269 | 703 | 29 | 20 | 6 | 0 | 26 | 9 | 6 | 1 | 5 | 5 | 234 | 6 | 5 | 630 | 3 |  | 0 | 0 | 0
P4W2 | 4 | 19 | 310 | 665 | 28 | 20 | 4 | 1 | 23 | 6 | 9 | 3 | 4 | 4 | 190 | 7 | 4 | 2256 | 5 |  | 0 | 0 | 0
P4W3 | 4 | 18 | 238 | 912 | 21 | 15 | 4 | 1 | 18 | 6 | 4 | 0 | 4 | 11 | 595 | 9 | 7 | 3176 | 3 |  | 1 | 14440 | 14440
P4W4 | 5 | 24 | 268 | 1222 | 23 | 14 | 4 | 4 | 14 | 3 | 4 | 1 | 2 | 2 | 225 | 11 | 4 | 3084 | 2 |  | 0 | 0 | 0
P4W5 | 5 | 22 | 305 | 987 | 30 | 21 | 3 | 1 | 23 | 8 | 6 | 1 | 1 | 1 | 70 | 11 | 5 | 2111 | 0 |  | 0 | 0 | 0
P5W1 | 5 | 24 | 311 | 1305 | 31 | 19 | 4 | 3 | 20 | 8 | 6 | 2 | 8 | 8 | 330 | 8 | 1 | 60 | 2 |  | 0 | 0 | 0
P5W2 | 5 | 13 | 168 | 418 | 16 | 11 | 4 | 1 | 14 | 3 | 4 | 3 | 0 | 0 | 0 | 6 | 6 | 954 | 1 |  | 0 | 0 | 0
P5W3 | 5 | 19 | 259 | 720 | 26 | 22 | 2 | 4 | 20 | 3 | 10 | 0 | 7 | 7 | 300.9 | 5 | 9 | 3206.2 | 2 |  | 0 | 0 | 0
P5W4 | 5 | 20 | 274 | 765 | 16 | 16 | 6 | 3 | 19 | 3 | 5 | 0 | 3 | 3 | 117.5 | 9 | 1 | 328 | 0 |  | 0 | 0 | 0
P6W1 | 4 | 15 | 164 | 569 | 17 | 12 | 4 | 4 | 12 | 3 | 4 | 0 | 1 | 1 | 40 | 5 | 3 | 4175 | 1 |  | 0 | 0 | 0
P6W2 | 4 | 20 | 284 | 828 | 22 | 14 | 5 | 2 | 17 | 4 | 6 | 0 | 3 | 3 | 242 | 8 | 4 | 1028 | 1 |  | 0 | 0 | 0
P6W3 | 4 | 19 | 298 | 764 | 28 | 28 | 2 | 6 | 24 | 2 | 12 | 0 | 5 | 5 | 290 | 10 | 4 | 1384 | 2 |  | 0 | 0 | 0
P6W4 | 4 | 20 | 289 | 753 | 27 | 25 | 5 | 6 | 24 | 4 | 8 | 0 | 7 | 7 | 296 | 10 | 2 | 704 | 0 |  | 0 | 0 | 0
P7W1 | 4 | 19 | 227 | 741 | 19 | 23 | 2 | 0 | 25 | 2 | 9 | 0 | 3 | 3 | 150 | 13 | 6 | 1283 | 2 |  | 0 | 0 | 0
P7W2 | 4 | 11 | 135 | 433 | 11 | 12 | 3 | 2 | 13 | 2 | 5 | 0 | 1 | 1 | 64 | 7 | 3 | 690 | 2 |  | 0 | 0 | 0
P7W3 | 4 | 18 | 232 | 734 | 21 | 18 | 4 | 0 | 22 | 4 | 6 | 1 | 10 | 15 | 508 | 10 | 6 | 1208 | 0 |  | 0 | 0 | 0
P7W4 | 4 | 17 | 208 | 710 | 24 | 16 | 6 | 2 | 20 | 5 | 6 | 2 | 4 | 6 | 420 | 5 | 2 | 435 | 1 |  | 0 | 0 | 0
P7W5
P8W1
P8W2
P8W3
P8W4
P9W1
P9W2
P9W3
[NAME]
P10W1
P10W2
P10W3
P10W4
P10W5
[NAME]
P11W2
P11W3
P11W4
P12W1
P12W2
P12W3
P12W4
P12W5
 |  | Chicago
Period and Week | Number of ISEs | Days Worked | # of Outbound Calls (Dials) | # of Incoming Calls | Total Calls | # Appts Set for SE | # Appts Closed by SE | # New Cust. [NAME] | $ New Cust. [NAME] | # Existing Cust. [NAME] |  | $ Existing Cust. [NAME] | # of Total Purge Opportunities Quoted | $ of Total Purge Opportunities Quoted | # New Cust. [NAME] | $ New Cust. [NAME] | # Existing Cust. [NAME] | $ Existing Cust. [NAME] | # of Total Purge Opportunities Sold | $ of Total Purge Opportunities Sold
P1W1 | 2 | 9 | 676 | 100 | 776 | 23 | 7 | 12 | 4663 | 32 |  | 7949 | 44 | 12612 | 6 | 1884 | 24 | 7046 | 30 | 8930
P1W2 | 2 | 10 | 773 | 81 | 854 | 21 | 6 | 19 | 4231.85 | 28 |  | 6685 | 47 | 10916.85 | 11 | 4133.26 | 29 | 8932 | 40 | 13065.26
P1W3 | 2 | 10 | 937 | 96 | 1033 | 18 | 3 | 22 | 4029.25 | 23 |  | 7106 | 45 | 11135.25 | 20 | 3918.24 | 21 | 7050 | 41 | 10968.24
P1W4 | 2 | 9 | 799 | 104 | 903 | 14 | 6 | 21 | 4657 | 26 |  | 8726 | 47 | 13383 | 13 | 4193 | 25 | 9637 | 38 | 13830
P1W5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P2W1 | 2 | 8 | 659 | 76 | 735 | 13 | 1 | 12 | 2142.98 | 17 |  | 3828 | 29 | 5970.98 | 10 | 1598 | 20 | 4595 | 30 | 6193
P2W2 | 2 | 9 | 856 | 108 | 964 | 5 | 1 | 12 | 4572 | 21 |  | 10343 | 33 | 14915 | 9 | 3421 | 16 | 8063 | 25 | 11484
P2W3 | 2 | 9 | 851 | 131 | 982 | 23 | 9 | 19 | 3907 | 21 |  | 5801 | 40 | 9708 | 14 | 3075 | 20 | 5647 | 34 | 8722
P2W4 | 2 | 10 | 973 | 110 | 1083 | 7 | 4 | 20 | 2987 | 25 |  | 7779 | 45 | 10766 | 11 | 2074 | 29 | 9111 | 40 | 11185
P3W1 | 2 | 10 | 839 | 131 | 970 | 16 | 6 | 26 | 6246 | 17 |  | 4209 | 43 | 10455 | 18 | 4670 | 15 | 4616 | 33 | 9286
[NAME] | 2 | 10 | 753 | 152 | 905 | 11 | 2 | 23 | 6932 | 173 |  | 11856 | 196 | 18788 | 13 | 3871 | 24 | 11428 | 37 | 15299
P3W3 | 2 | 9 | 736 | 149 | 885 | 5 | 3 | 24 | 4532 | 33 |  | 8948 | 57 | 13480 | 19 | 3539 | 30 | 8842 | 49 | 12381
P3W4 | 2 | 10 | 909 | 121 | 1030 | 9 | 4 | 15 | 2670 | 26 |  | 6961 | 41 | 9631 | 9 | 1585 | 27 | 7052 | 36 | 8637
P4W1 | 2 | 8 | 714 | 161 | 875 | 7 | 0 | 34 | 7933 | 15 |  | 3075 | 49 | 11008 | 18 | 5017 | 17 | 3785 | 35 | 8802
P4W2 | 2 | 10 | 1038 | 99 | 1137 | 10 | 1 | 13 | 2369 | 18 |  | 3886 | 31 | 6255 | 10 | 1824 | 18 | 3709 | 28 | 5533
P4W3 | 2 | 8 | 799 | 89 | 888 | 6 | 3 | 15 | 3778 | 8 |  | 3448 | 23 | 7226 | 13 | 3484 | 10 | 4113 | 23 | 7597
P4W4 | 2 | 5 | 500 | 120 | 620 | 5 | 1 | 6 | 2252 | 10 |  | 2508 | 16 | 4760 | 4 | 2042 | 10 | 2508 | 14 | 4550
P4W5 | 2 | 10 | 969 | 159 | 1128 | 17 | 2 | 27 | 7103 | 20 |  | 6425 | 47 | 13528 | 19 | 5804 | 17 | 5771 | 36 | 11575
P5W1 | 2 | 10 | 961 | 148 | 1109 | 7 | 0 | 20 | 4166 | 22 |  | 6011 | 42 | 10177 | 18 | 3906 | 25 | 6710 | 43 | 10616
P5W2 | 2 | 7 | 596 | 193 | 789 | 16 | 0 | 24 | 7190.8 | 18 |  | 6047 | 42 | 13237.8 | 15 | 2885 | 14 | 4661 | 29 | 7546
P5W3 | 2 | 9 | 783 | 160 | 943 | 6 | 3 | 25 | 7459 | 26 |  | 6971 | 51 | 14430 | 17 | 5378 | 25 | 6756 | 42 | 12134
P5W4 | 2 | 9 | 925 | 107 | 1032 | 5 | 2 | 18 | 12026 | 30 |  | 7175 | 48 | 19201 | 16 | 2830 | 34 | 8447 | 50 | 11277
P6W1 | 2 | 8 | 655 | 73 | 728 | 7 | 2 | 16 | 4466 | 14 |  | 4235 | 30 | 8701 | 7 | 3094 | 14 | 3613 | 21 | 6707
P6W2 | 2 | 8 | 655 | 123 | 778 | 5 | 4 | 28 | 5488 | 20 |  | 5306 | 48 | 10794 | 15 | 3083 | 19 | 4933 | 34 | 8016
P6W3 | 2 | 10 | 854 | 93 | 947 | 8 | 3 | 21 | 8449 | 22 |  | 8337 | 43 | 16786 | 13 | 2028 | 19 | 6579 | 32 | 8607
P6W4 | 2 | 10 | 846 | 129 | 975 | 16 | 6 | 26 | 19576 | 23 |  | 5275 | 49 | 24851 | 16 | 6775 | 22 | 4950 | 38 | 11725
P7W1 | 2 | 9 | 706 | 109 | 815 | 10 | 3 | 35 | 24261 | 29 |  | 8280 | 64 | 32541 | 19 | 14546 | 30 | 10507 | 49 | 25053
P7W2 | 2 | 7 | 489 | 101 | 590 | 8 | 1 | 21 | 4498 | 27 |  | 8306 | 48 | 12804 | 17 | 4054 | 25 | 5898 | 42 | 9952
P7W3 | 2 | 10 | 946 | 124 | 1070 | 11 | 4 | 26 | 11538.12 | 34 |  | 13177 | 60 | 24715.12 | 10 | 1841.12 | 39 | 14849 | 49 | 16690.12
P7W4 | 2 | 10 | 1051 | 83 | 1134 | 16 | 5 | 21 | 18329 | 23 |  | 8414 | 44 | 26743 | 14 | 3126 | 21 | 9322 | 35 | 12448
P7W5
P8W1
P8W2
P8W3
P8W4
P9W1
P9W2
P9W3
[NAME]
P10W1
P10W2
P10W3
P10W4
P10W5
[NAME]
P11W2
P11W3
P11W4
P12W1
P12W2
P12W3
P12W4
P12W5