Prototype

     Our team has created a prototype Google Form and Google Sheet for the Women’s Soccer Team at Chatham. The coach will fill out the Google Form when scouting the player and the responses will be transmitted to the corresponding Google Sheet. The Google Sheet will show each player's basic contact information such as names and emails. Also it will shows each player GPA in school, main position in the team, shirt number and most importantly the game location and time. Moreover, the Sheet will show each player skill, such as ball controlling, dribbling and running with the ball, passing and shooting ability etc.. The Sheet can determines the physical skills of the player, for example, player balance, coordination, speed, strength, and stamina. Finally the Sheet could also shows the mental skills of each player. Such as, passion, mental toughness, leadership during the game, responsibility to each team member, risk assessment, and spatial awareness of the player while playing.  

    Our goal was to provide an easy to use spreadsheet which can rank the players that they are currently scouting and make the whole scouting process a breeze. Our app firstly asks the coach or player for the contact information that they will need. This is included on a Google Form and can be filled out quickly. This includes all the ways of contacting them, the team the play on, position, and so on. Once they input this data, this information gets sent into the Google Sheet listed within it. With this data, they can have all the data compiled into one source. After they have this information, the coaches will attend a game of the player and rate them on many different skills listed in three different categories. These categories are physical, mental, and technical. When all the information is input into the system, it is tallied up into a positional total for that category. After all the categories are filled, the app will create a page with a “superscore”, name, and GPA. On this sheet, you can see if the player you are scouting fits the role you are looking for and also if they are academically eligible. Before even knowing if they can play soccer at an above average level, they first have to be academically eligible. On the final sheet, their GPA is in three different colors showing how they are doing in school. If the cell they are in is above a 3.0 GPA then they are doing fantastic and should be looked at. If their GPA is from a 2.3 to a 3 then they are a maybe and could potentially become ineligible. Finally, if they are in red, they are not eligible and should not be looked at. If the “superscore” is above an 88, the cell will change to being green which is a great score and someone you should bring in. If their score is from a 72 to an 87, the cell will change to yellow. This states that the player is a maybe and further scouting will be needed to see if they are a good fit. Anything below a 72 will change to red stating that the player is not a good fit and should not be scouted anymore.

     A crucial area of our skills evaluation prototype is positional scoring. After meeting with Coach Jessica Sinclair, the team determined which skills would be more useful for each position. The positions listed are Striker, Central-Attacking Midfielder, Center Midfielder (this applies to Wing Midfield as well), Central Defensive Midfielder, Right-Back, Centre-Back, Left-Back, and Goalkeeper. So, the skills of a striker will not apply to the skills of a defender, and vice versa. In our Google Sheet, we have coded lines for each positions score, and the weight of said score. For an example we will use Arsenal FC legend Thierry Henry (a fake user we had filled a score out for)

    So to begin we will look at Thierry's technical score. On this sheet we see his position, which is a Central-Attacking Midfielder (CAM). For determining his adjusted score, we use an =IFS function. The function reads =IFS(D4="CAM", SUM(E4:I4)*1.4)) D4, in this case, is the player position, providing us with an "if" property. If Thierry Henry is a CAM, then SUM(E4:I4) and multiply by 1.4. The summed skills (E4:I4) are what we have determined to be most important for a CAM.

     These skills (E4:I4) include Ball Control, Dribbling/Running w/ Ball, Body Movement, Passing Ability, and Shooting Ability. Since Henry does not cover every skill (only defending and goalkeeping ability are left out) we needed to multiply his summed score of Ball Control, Dribbling/Running w/ Ball, Body Movement, Passing Ability, and Shooting Ability by a constant to create a score out of 35 points. The multiplier for 5 skills is 1.4. This multiplier differs with each position, depending on what skills are important for that position.

    Another example would be Goalkeepers. The goalkeeper ability skill takes into account reflexes, passing from the goal-line, and so on. Therefore, the Goalkeeper only has one skill that is eligible for a SuperScore, which is goalkeeping ability. Their goalkeeping ability score, on a scale of 1 to 5, is then multiplied by 7 to create a maximum point total of 35.

Link to Forum and Sheet:
https://drive.google.com/drive/folders/14--Sb5G3NuQT4V8s44izXrfPgBXW0WtM?usp=sharing