Scouting: looking for an excel sheet

[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!

[Captain_Kirch]

Originally Posted by Jon Stratis

We use a scouting spreadsheet that utilizes macros pretty heavily.

...

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!

I know that I've always had to create a new system every year. You're right, you cant just re-use, but that's part of the challenge. We cant re-use robots, we cant re-use code, we can only carry our knowledge on. Take what you already know from previous years and make something even better.

I risk being rude here so apologies in advance. It seems like you're asking a bit much for a member of the community to do this for you. You wouldn't ask Chief Delphi to program your robot would you?

If you want something easier I suggest using pivot tables. Tableau is pretty simple it would replace that second sheet you mentioned.

[Jon Stratis]

Originally Posted by Captain_Kirch

If you want something easier I suggest using pivot tables. Tableau is pretty simple it would replace that second sheet you mentioned.

No, not really looking for something easier. Pivot tables are, frankly, a little too easy for what I'm looking for. Doing the macro's gives us a great excuse to get students involved with a second programming language (even if it is just VBA) and get them to think a little differently about programming, as the application of it and the language itself is way different from what we do for our robot! I wouldn't give up on the chance to give them that experience just to save us an hour or two of effort.