[Jon Stratis]

We use a scouting spreadsheet that utilizes macros pretty heavily.

The first tab is identical to our paper scouting sheets - that makes input a lot easier. It has some custom defined lists so that, for example, you pick the current match from a drop down and it automatically populates the team numbers that are playing in that match. Then there's a nice big "submit" button that calls a macro - that macro simply copies all the information over to a data tab, which keeps the data for a single team in a single match in a single row. For example, there's 6 rows for match one, one for each team. And by the end of the competition each team has 8-10 rows, depending on how many matches they have.

On that second data tab, there's another submit button that kicks off another macro. That macro goes through the data tab and does a bit of math. It identifies every row for a particular team, then combines them into a single row on another tab representing the team's overall contribution. For example, there might be a "total high goal shots made" column, a "total high goal shots missed" column, and then a "% shots made" column. That way, if you're looking at alliance selection and want a high goal shooter, you can sort by those columns to see who shoots the most, makes the most, missed the least, etc. Likewise, there can be columns for each individual defense so you know what teams are capable off (important for selecting defenses in each match!).

Anyways, with the reliance on macros and more advanced excel functions like custom lists, it can be difficult to adapt something like that to a different set of data. If you're comfortable trying, let me know and I can send over one I have for you to work on!