Spreadsheet: 158304d1338159849-pulling-statistics-based-on-name-sample-sheet
Sheet: Data By Role

 | Open Opportunities | Opportunity | Targeting | Interview | Application | Closed Deal - Closed | Closed - Lost | Cancelled | Opportunity Conversion Rate |  | Open Opportunities | Opportunity | Targeting | Interview | Application | Closed Deal - Closed | Closed - Lost | Cancelled | Opportunity Conversion Rate |  | Open Opportunities | Opportunity | Targeting | Interview | Application | Closed Deal - Closed | Closed - Lost | Cancelled | Opportunity Conversion Rate |  | Open Opportunities | Opportunity | Targeting | Interview | Application | Closed Deal - Closed | Closed - Lost | Cancelled | Opportunity Conversion Rate |  | Open Opportunities | Opportunity | Targeting | Interview | Application | Closed Deal - Closed | Closed - Lost | Cancelled | Opportunity Conversion Rate |  | Open Opportunities | Opportunity | Targeting | Interview | Application | Closed Deal - Closed | Closed - Lost | Cancelled | Opportunity Conversion Rate
Role 1 |  |  |  |  |  |  |  |  |  | Role 2 |  |  |  |  |  |  |  |  |  | Role 3 |  |  |  |  |  |  |  |  |  | Role 4 |  |  |  |  |  |  |  |  |  | Role 5 |  |  |  |  |  |  |  |  |  | Role 6
[NAME] | 3 | 2 | 4 | 4 | 5 | 0 | 0 | 0 | 0 | [NAME] 1 | 5 | 7 | 3 | 6 | 1 | 2 | 7 | 0 | 0.2222222222222222 | [NAME] | 4 | 6 | 5 | 4 | 1 | 2 | 0 | 0 | 1 | [NAME] | 4 | 2 | 3 | 3 | 2 | 1 | 4 | 0 | 0.2 | [NAME] | 0 | 1 | 2 | 3 | 4 | 0 | 0 | 0 | 0 | ED SMITH 1 | 63 | 4 | 2 | 1 | 1 | 23 | 28 | 8 | 0.3898305084745763
[NAME] 2 | 2 | 2 | 4 | 4 | 5 | 2 | 4 | 1 | 0.2857142857142857 | [NAME] 2 | 4 | 7 | 3 | 6 | 1 | 2 | 3 | 5 | 0.2 | [NAME] | 3 | 6 | 5 | 4 | 1 | 1 | 7 | 1 | 0.1111111111111111 | [NAME] | 2 | 2 | 3 | 3 | 2 | 2 | 0 | 3 | 0.4 | [NAME] 2 | 0 | 1 | 2 | 3 | 4 | 0 | 0 | 0 | 0 | ED SMITH 2 | 76 | 4 | 2 | 1 | 1 | 9 | 33 | 2 | 0.2045454545454546
[NAME] 3 | 4 | 2 | 4 | 4 | 5 | 1 | 2 | 0 | 0.3333333333333333 | [NAME] 3 | 1 | 7 | 3 | 6 | 1 | 2 | 1 | 2 | 0.4 | [NAME] | 7 | 6 | 5 | 4 | 1 | 1 | 12 | 1 | 0.07142857142857142 | [NAME] 3 | 2 | 2 | 3 | 3 | 2 | 2 | 8 | 0 | 0.2 | [NAME] 3 | 1 | 1 | 2 | 3 | 4 | 0 | 0 | 0 | 0 | ED SMITH 3 | 26 | 4 | 2 | 1 | 1 | 45 | 21 | 16 | 0.5487804878048781
[NAME] | 6 | 2 | 4 | 4 | 5 | 3 | 7 | 6 | 0.1875 | [NAME] 4 | 7 | 7 | 3 | 6 | 1 | 4 | 25 | 3 | 0.125 | [NAME] | 5 | 6 | 5 | 4 | 1 | 0 | 5 | 3 | 0 | [NAME] | 7 | 2 | 3 | 3 | 2 | 1 | 5 | 0 | 0.1666666666666667 | [NAME] | 0 | 1 | 2 | 3 | 4 | 0 | 0 | 0 | 0 | ED SMITH 4 | 64 | 4 | 2 | 1 | 1 | 12 | 41 | 12 | 0.1846153846153846
[NAME] 5 | 2 | 2 | 4 | 4 | 5 | 3 | 0 | 2 | 0.6 | [NAME] 5 | 4 | 7 | 3 | 6 | 1 | 3 | 0 | 1 | 0.75 | [NAME] | 6 | 6 | 5 | 4 | 1 | 2 | 11 | 4 | 0.1176470588235294 | [NAME] | 11 | 2 | 3 | 3 | 2 | 5 | 4 | 4 | 0.3846153846153846 | [NAME] | 0 | 1 | 2 | 3 | 4 | 0 | 0 | 0 | 0 | ED SMITH 5 | 92 | 4 | 2 | 1 | 1 | 24 | 41 | 34 | 0.2424242424242424
[NAME] 6 | 2 | 2 | 4 | 4 | 5 | 1 | 1 | 0 | 0.5 | [NAME] 6 | 37 | 7 | 3 | 6 | 1 | 10 | 15 | 20 | 0.2222222222222222 | [NAME] | 5 | 6 | 5 | 4 | 1 | 1 | 1 | 0 | 0.5 | [NAME] 6 | 23 | 2 | 3 | 3 | 2 | 1 | 1 | 1 | 0.3333333333333333 | [NAME] 6 | 0 | 1 | 2 | 3 | 4 | 0 | 0 | 0 | 0 | ED SMITH 6 | 6 | 4 | 2 | 1 | 1 | 1 | 1 | 8 | 0.1
[NAME] | 1 | 2 | 4 | 4 | 5 | 0 | 1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 8 | 6 | 5 | 4 | 1 | 3 | 1 | 2 | 0.5 | [NAME] | 3 | 2 | 3 | 3 | 2 | 0 | 2 | 2 | 0 | [NAME] | 1 | 1 | 2 | 3 | 4 | 0 | 0 | 1 | 0 | ED SMITH 7 | 29 | 4 | 2 | 1 | 1 | 11 | 29 | 8 | 0.2291666666666667
[NAME] 8 | 1 | 2 | 4 | 4 | 5 | 0 | 1 | 1 | 0 |  |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 5 | 4 | 1 | 1 | 3 | 0 | 0.25 |  |  |  |  |  |  |  |  |  |  | [NAME] 8 | 0 | 1 | 2 | 3 | 4 | 0 | 0 | 0 | 0 | ED SMITH 8 | 25 | 4 | 2 | 1 | 1 | 2 | 12 | 2 | 0.125
[NAME] 9 | 0 | 2 | 4 | 4 | 5 | 2 | 3 | 1 | 0.3333333333333333 |  |  |  |  |  |  |  |  |  |  |  | 10 | 6 | 5 | 4 | 1 | 4 | 7 | 1 | 0.3333333333333333 |  |  |  |  |  |  |  |  |  |  | [NAME] 9 | 1 | 1 | 2 | 3 | 4 | 0 | 1 | 0 | 0 | ED SMITH 9 | 0 | 4 | 2 | 1 | 1 | 0 | 0 | 0 | 0
[NAME] 10 | 2 | 2 | 4 | 4 | 5 | 0 | 2 | 2 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 10 | 3 | 1 | 2 | 3 | 4 | 1 | 4 | 7 | 0.08333333333333333 | ED SMITH 10 | 0 | 4 | 2 | 1 | 1 | 0 | 0 | 0 | 0
[NAME] 11 | 19 | 2 | 4 | 4 | 5 | 9 | 5 | 4 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 11 | 0 | 1 | 2 | 3 | 4 | 0 | 0 | 0 | 0
[NAME] 12 | 0 | 2 | 4 | 4 | 5 | 0 | 3 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 12 | 0 | 1 | 2 | 3 | 4 | 0 | 0 | 0 | 0
[NAME] 13 | 7 | 2 | 4 | 4 | 5 | 2 | 15 | 1 | 0.1111111111111111 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 13 | 0 | 1 | 2 | 3 | 4 | 2 | 0 | 0 | 1
[NAME] 14 | 1 | 2 | 4 | 4 | 5 | 0 | 2 | 1 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 14 | 1 | 1 | 2 | 3 | 4 | 0 | 0 | 0 | 0
[NAME] 15 | 19 | 2 | 4 | 4 | 5 | 0 | 6 | 2 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 15 | 8 | 1 | 2 | 3 | 4 | 1 | 0 | 0 | 1
[NAME] 16 | 7 | 2 | 4 | 4 | 5 | 0 | 1 | 0 | 0
[NAME] 17 | 4 | 2 | 4 | 4 | 5 | 1 | 2 | 0 | 0.3333333333333333
[NAME] 18 | 4 | 2 | 4 | 4 | 5 | 1 | 4 | 2 | 0.1428571428571428
[NAME] 19 | 30 | 2 | 4 | 4 | 5 | 3 | 16 | 3 | 0.1363636363636364
[NAME] 20 | 4 | 2 | 4 | 4 | 5 | 0 | 7 | 3 | 0
[NAME] 21 | 3 | 2 | 4 | 4 | 5 | 1 | 3 | 3 | 0.1428571428571428
[NAME] 22 | 2 | 2 | 4 | 4 | 5 | 0 | 2 | 0 | 0
[NAME] 23 | 6 | 2 | 4 | 4 | 5 | 2 | 11 | 4 | 0.1176470588235294
[NAME] 24 | 9 | 2 | 4 | 4 | 5 | 3 | 9 | 0 | 0.25
[NAME] 25 | 0 | 2 | 4 | 4 | 5 | 0 | 0 | 0 | 0
[NAME] 26 | 3 | 2 | 4 | 4 | 5 | 1 | 5 | 1 | 0.1428571428571428
[NAME] 27 | 1 | 2 | 4 | 4 | 5 | 1 | 1 | 0 | 0.5
[NAME] 28 | 1 | 2 | 4 | 4 | 5 | 4 | 1 | 1 | 0.6666666666666666
[NAME] 29 | 7 | 2 | 4 | 4 | 5 | 1 | 8 | 0 | 0.1111111111111111
[NAME] 30 | 3 | 2 | 4 | 4 | 5 | 0 | 2 | 1 | 0
[NAME] 31 | 0 | 2 | 4 | 4 | 5 | 3 | 0 | 2 | 0.6
[NAME] 32 | 6 | 2 | 4 | 4 | 5 | 0 | 2 | 0 | 0
[NAME] 33 | 0 | 2 | 4 | 4 | 5 | 1 | 0 | 0 | 1
[NAME] 34 | 6 | 2 | 4 | 4 | 5 | 0 | 3 | 0 | 0
[NAME] 35 | 8 | 2 | 4 | 4 | 5 | 3 | 8 | 0 | 0.2727272727272727
[NAME] 36 | 9 | 2 | 4 | 4 | 5 | 1 | 3 | 0 | 0.25
[NAME] 37 | 3 | 2 | 4 | 4 | 5 | 1 | 3 | 2 | 0.1666666666666667
[NAME] 38 | 2 | 2 | 4 | 4 | 5 | 1 | 3 | 4 | 0.125
[NAME] 39 | 2 | 2 | 4 | 4 | 5 | 0 | 0 | 1 | 0
[NAME] 40 | 5 | 2 | 4 | 4 | 5 | 0 | 2 | 1 | 0