SportzQnoA
New Member
- Joined
- Jun 19, 2022
- Messages
- 1
- Office Version
- 365
- 2021
- 2019
- Platform
- MacOS
I have a question for a conditional format specifically this:
NFL Scouts 2022.xlsx | |||
---|---|---|---|
A | |||
1 | Conditions List: | ||
2 | Add anyone that has a title with "scouting" or "personnel" in it. | ||
3 | I don't need people with "administration" in their title or any cap guys, despite having one listed from the Niners | ||
4 | Make sure every scout keeps the same number | ||
5 | If a scout is added to one team from another team, make sure his number travels with him. | ||
6 | Don't create numbers for scouts you add; just make them this color | ||
7 | If a scout's name is already there, but he has a new title, update the title and highlight him in this color | ||
8 | If you bring in a scout from another team, make him this color | ||
9 | If there are NO changes for a scout who's already listed, he'll stay this color | ||
10 | Remember: Do NOT add numbers to any of the scouts. Just make sure to keep the ones that do have them. | ||
11 | No need to add scouting assistants | ||
Sheet4 |
NFL Scouts 2022.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
2 | 2 | 49ers | Lynch, John | John | Lynch | GM | ||
3 | 3 | 49ers | Peters, Adam | Adam | Peters | Assistant GM | ||
4 | 4 | 49ers | Waugh, Ethan | Ethan | Waugh | Vice President, Player Personnel | ||
5 | 5 | 49ers | Carthon, Ran | Ran | Carthon | Director of Player Personnel | ||
6 | 6 | 49ers | Gillen, R.J. | R.J. | Gillen | Director of Pro Personnel | ||
7 | 7 | 49ers | Ahmad, Tariq | Tariq | Ahmad | Director of College Scouting | ||
8 | 8 | 49ers | Flanagan, Chip | Chip | Flanagan | National Scout | ||
9 | 9 | 49ers | Chabot, Justin | Justin | Chabot | Assistnat Director, College Scouting | ||
10 | 10 | 49ers | Clavelle, Salli | Salli | Clavelle | Area Scout | ||
11 | 11 | 49ers | DeCicco, Dom | Dom | DeCicco | Area Scout | ||
12 | 12 | 49ers | Williams, Joshua | Joshua | Williams | Area Scout | ||
13 | 13 | 49ers | Kessenich, Ryan | Ryan | Kessenich | Area Scout | ||
14 | 14 | 49ers | Rubio, Steve | Steve | Rubio | Area Scout | ||
15 | 49ers | Thatcher, Eric | Eric | Thatcher | Area Scout | |||
16 | 49ers | Gammage, Fred III | Fred III | Gammage | Pro Scout | |||
17 | 15 | 49ers | Slowik, Steve | Steve | Slowik | Pro Scout | ||
18 | 49ers | Hanlon, Crowley | Crowley | Hanlon | Pro Scout | |||
19 | 49ers | Frey, Hayden | Hayden | Frey | College Scout | |||
20 | 49ers | Seumalo, Jessi | Jessi | Seumalo | Coordinator, Player Personnel | |||
21 | 16 | 49ers | Buffum, Richard | Richard | Buffum | Manager, Football Administration | ||
22 | 17 | Bears | Poles, Ryan | Ryan | Poles | GM | ||
23 | 18 | Bears | Cunningham, Ian | Ian | Cunningham | Assistant GM | ||
24 | 19 | Bears | Sadowski, Mark | Mark | Sadowski | Director of College Scouting | ||
25 | 20 | Bears | Koziol, Trey | Trey | Koziol | Co-Director of Player Personnel | ||
26 | 21 | Bears | Prescott, Chris | Chris | Prescott | National Scout | ||
27 | 22 | Bears | Saint-Paul, Francis | Francis | Saint-Paul | National Scout | ||
28 | 23 | Bears | Summerville, Sam | Sam | Summerville | National Scout | ||
29 | 24 | Bears | Shiver, Jeff | Jeff | Shiver | Executive Scout | ||
30 | 25 | Bears | Ackley, Breck | Breck | Ackley | Area Scout | ||
31 | 26 | Bears | Hamel, Scott | Scott | Hamel | Area Scout | ||
32 | 27 | Bears | Rehor, Brendan | Brendan | Rehor | Area Scout | ||
33 | 28 | Bears | Syty, John | John | Syty | Area Scout | ||
34 | 29 | Bears | Williams, David | David | Williams | Area Scout | ||
35 | 30 | Bears | Raucina Drew | Drew | Raucina | Combine Scout | ||
36 | 31 | Bears | Macedo, Bobby | Bobby | Macedo | Scouting Coordinator | ||
37 | 32 | Bears | Love, Charles | Charles | Love | Scouting Assistant | ||
38 | 33 | Bears | Washington, Ashton | Ashton | Washington | Scouting Assistant | ||
39 | 34 | Bears | King, Jeff | Jeff | King | Director of Pro Scouting | ||
40 | 35 | Bears | White, Chris | Chris | White | Pro Scout | ||
41 | 36 | Bengals | Brown, Paul | Paul | Brown | Vice President of Player Personnel | ||
42 | 37 | Bengals | Tobin, Duke | Duke | Tobin | Director of Player Personnel | ||
43 | 38 | Bengals | Potts, Mike | Mike | Potts | Scouting Director (College) | ||
44 | 39 | Bengals | Radicevic, Steven | Steven | Radicevic | Scouting Director (Pro) | ||
45 | 40 | Bengals | Tobin, Bill | Bill | Tobin | Personnel Executive | ||
46 | 41 | Bengals | Brown, Trey | Trey | Brown | Scout | ||
47 | 42 | Bengals | Johnson, Andrew | Andrew | Johnson | Scout | ||
48 | 43 | Bengals | Sarkisian, Christian | Christian | Sarkisian | Scout | ||
49 | 44 | Bills | Boyd, Malik | Malik | Boyd | Senior Director of Pro Scouting | ||
50 | 45 | Bills | Gray, Terrance | Terrance | Gray | Assistant Director of Player Personnel | ||
51 | 46 | Bills | Dawson, Lake | Lake | Dawson | Asst. Dir of College Scouting | ||
52 | 47 | Bills | Marrow, Chris | Chris | Marrow | Asst Director of Pro Scouting/Team Advances | ||
53 | 48 | Bills | Rukavina, Curtis | Curtis | Rukavina | Asst. Director of Pro Scouting/Free Agency | ||
54 | 49 | Bills | Fisher, Brian | Brian | Fisher | Area Scout | ||
55 | 50 | Bills | Gaine, Brian | Brian | Gaine | Senior Personnel Advisor | ||
56 | 51 | Bills | Gosper, Andrea | Andrea | Gosper | Player Personnel Coordinator | ||
57 | 52 | Bills | Harris, Pete | Pete | Harris | Area Scout | ||
58 | 53 | Bills | Hickey, Dennis | Dennis | Hickey | Senior National Scout | ||
59 | 54 | Bills | Highsmith, A.J. | Aj | Highsmith | Area Scout | ||
60 | 55 | Bills | Jennings, Keith | Keith | Jennings | BLESTO Scout | ||
61 | 56 | Bills | Majeski, Doug | Doug | Majeski | Senior College Scout | ||
62 | 57 | Bills | Pratt, Tyler | Tyler | Pratt | Area Scout | ||
63 | 58 | Bills | Mulbah, Asil | Asil | Mulbah | Pro Scout | ||
64 | 59 | Bills | Szabo, Mike | Mike | Szabo | Area Scout | ||
65 | 60 | Bills | Webb, R.J. | R.J. | Webb | Pro Scout | ||
66 | 61 | Bills | Meganck, Kevin | Kevin | Meganck | VP of Football Administration | ||
67 | 62 | Bills | Overdorf, Jim | Jim | Overdorf | Senior Advisor to GM/Football Operations | ||
68 | 63 | Broncos | Paton, George | George | Paton | GM | ||
69 | 64 | Broncos | Kleine, Kelly | Kelly | Kleine | Executive Director of Football Operations/Special Advisor to the GM | ||
70 | 65 | Broncos | Mougey, Darren | Darren | Mougey | Assistant GM | ||
71 | 66 | Broncos | Durso, A.J. | A.J. | Durso | Director of Pro Personnel | ||
72 | 67 | Broncos | Stark, Brian | Brian | Stark | Director of College Scouting | ||
73 | 68 | Broncos | Phifer, Roman | Roman | Phifer | Senior Personnel Executive | ||
74 | 69 | Broncos | Dizon, Jordon | Jordon | Dizon | Assistant Director of Pro Scouting | ||
75 | 70 | Broncos | Schiralli, Nick | Nick | Schiralli | Assistant Director of College Scouting | ||
76 | 71 | Broncos | Jo, Sae Woon | Sae Woon | Jo | Western National Scout | ||
77 | 72 | Broncos | Armstrong, Eugene | Eugene | Armstrong | Southwest Area Scout | ||
78 | 73 | Broncos | Bratten, Dave | Dave | Bratten | College Scouting Coordinator/West Area Scout | ||
79 | 74 | Broncos | Chesin, Bryan | Bryan | Chesin | Midwest Area Scout | ||
80 | 75 | Broncos | Distefano, Scott | Scott | Distefano | Senior College Consultant (Midwest) | ||
81 | 76 | Broncos | Paton, Rob | Rob | Paton | Scouting Coordinator | ||
82 | 77 | Broncos | Randall, Deon | Deon | Randall | Northeast Area Scout | ||
83 | 78 | Broncos | Walsh, Patrick | Patrick | Walsh | Pro Scout | ||
84 | 79 | Broncos | Burton, Roya | Roya | Burton | Player Personnel Assistant | ||
85 | 80 | Broncos | Hurtado, Richard | Richard | Hurtado | VP of Football Administration | ||
original |
NFL Scouts 2022.xlsx | |||||||
---|---|---|---|---|---|---|---|
I | J | K | L | M | |||
2 | Chabot, Justin | 49ers | National Scout | 49ers | Assistant Director of College Scouting | ||
3 | Frey, Hayden | 49ers | Scouting Assistant | 49ers | College Scout | ||
4 | Gatson, Tyren | Auburn | Associate DPP/Recruiting Operations | 49ers | Scouting Assistant | ||
5 | Hannon, Crowley | 49ers | Pro Personnel Coordinator | 49ers | Pro Scout | ||
6 | Seumalo, Jessi | 49ers | Scouting Assistant | 49ers | Coordinator, Player Personnel | ||
7 | Slowik, Steve | 49ers | Area Scout | 49ers | Pro Scout | ||
8 | Thatcher, Eric | U. Albany | Safeties coach | 49ers | Area Scout | ||
9 | Ackley, Breck | Bears | Area Scout | Bears | Assistant Director of College Scouting | ||
10 | Bradway, Tom | Raiders | Combine Scout | Bears | Area Scout (Northeast) | ||
11 | Cavanaugh, Ryan | Ohio State | College Scouting Coordinator | Bears | Area Scout | ||
12 | Cosh, James | Bears | Salary Cap/Pro Scouting Analyst | Bears | Manager of Football Administration/Pro Scout | ||
13 | Cunningham, Ian | Eagles | Director of Player Personnel | Bears | Assistant GM | ||
14 | Hicks, Reese | Falcons | Pro Scout | Bears | Area Scout (West Coast) | ||
15 | Love, Charles | Bears | Scouting Assistant | Bears | Pro Scout | ||
16 | Poles, Ryan | Chiefs | Executive Director of Player Personnel | Bears | GM | ||
17 | Rehor, Brendan | Bears | Area Scout (Midwest) | Bears | Area Scout (Southeast) | ||
18 | Santarelli, Mike | Bears | Director of Football Systems | Bears | Executive Director of Football Technology | ||
19 | St. Paul, Francis | Bears | National Scout | Bears | Senior National Scout | ||
20 | Summerville, Sam | Bears | National Scout | Bears | Senior National Scout | ||
21 | Syty, John | Bears | Area Scout (Northeast) | Bears | Area Scout (Southwest) | ||
22 | Washington, Ashton | Bears | Scouting Assistant | Bears | Player Personnel Coordinator | ||
23 | Weese, Ryan | Montana State | General Manager | Bears | Scouting Assistant | ||
24 | White, Chris | Bears | Pro Scout | Bears | Assistant Director of Pro Scouting | ||
25 | Brown, Trey | Bengals | Scout | Bengals | Senior Personnel Executive | ||
26 | Bazirgan, Matt | Texans | Assistant Director of Player Personnel | Bills | Senior Personnel Executive | ||
27 | Dotson, Alonzo | Jets | Area Scout (Southeast) | Bills | National Scout | ||
28 | Gaine, Brian | Bills | Senior Personnel Advisor | Bills | Assistant GM | ||
29 | Gray, Terrance | Bills | Assistant Director of Player Personnel | Bills | Director of Player Personnel | ||
30 | Pratt, Tyler | Bills | Area Scout (West Coast) | Bills | Area Scout (Southeast) | ||
31 | Szabo, Mike | Bills | Area Scout | Bills | College National Scout | ||
32 | Armstrong, Eugene | Broncos | Area Scout (Southwest) | Broncos | Area Scout (Southeast) | ||
33 | Bratten, Dave | Broncos | College Scouting Coordinator/Area Scout (Midwest) | Broncos | Area Scout (West Coast) | ||
34 | Burckhardt, Reed | Vikings | Assistant Director of Pro Scouting | Broncos | Director of Player Personnel | ||
35 | Chesin, Bryan | Broncos | Area Scout | Broncos | Midwest National Scout | ||
36 | DiStefano, Scott | Broncos | Senior College Consultant | Broncos | Senior Midwest Area Scout | ||
37 | McKenzie, Chaz | Broncos | Nunn-Wooten Scouting Fellow | Broncos | Area Scout (Northeast) | ||
38 | Paton, Rob | Broncos | Scouting Coordinator | Broncos | Regional Scout | ||
39 | Randall, Deon | Broncos | Area Scout (Northeast) | Broncos | Area Scout (Southwest) | ||
Sheet4 |