GUSS Scouting System

[theCoder]

Originally Posted by Zholl

How exactly do you run this? I just downloaded it to check it out, and it downloaded as a zip file and I now have a folder with a ton of different files and folders, none of which are excel files.

I've never run into that. Did you save first? You should get one file with an .xlsm extension? Weird.

[theCoder]

Rev D is now available. I added a sheet to prepare for an upcoming match. The sheet shows all teams for a match with detailed information on each. It also predicts the winner of the match.

I tried to make the input values more general. As recommended by others, making it able to handle a large range of values such as the # balls scored. It impacts the validity configuration (not too much of a problem) and the score determination logic. The score code now just multiplies the value (0, 1, or 2) times the weight. I couldn't come up with a clean way to do make the scoring logic generic enough to handle a large range. Feel free to change this yourself. You would need to change the validity of the cells B6-G11 on sheet Match Input. The score calculation code is in macro "compute_score". After hearing about the first weeks regionals, I now more than ever, want to score this regional with high/medium/low rankings. It sounds like it is going to be very hard to count the # balls scored by each robot or HP.

[Zholl]

I figured it out. It's some weird thing with the school computers. It works fine at home, so it's probably a combination of user limitations, Fortress, and dated software.

[adcn6f]

Hi, I am a mentor from Team Driven 1730. We used your software during the Kansas City Regional and it was awesome. It was very useful when we needed to know quick information about each robot. We attached pictures to each page which was very cool. It was very easy to fill out each match's results

This program was great in combination with our Pit scouting since it could not truly tell us the skills of each robot on the playing field.

What we like;

The simple and clear scoring system on each robot.
The observation categories and note compiling.
The ranking system based on adjustable weights.
We found the match prediction to be fairly close as the day progressed.

Thank you very much!

[theCoder]

Originally Posted by adcn6f

Hi, I am a mentor from Team Driven 1730. We used your software during the Kansas City Regional and it was awesome. It was very useful when we needed to know quick information about each robot. We attached pictures to each page which was very cool. It was very easy to fill out each match's results

This program was great in combination with our Pit scouting since it could not truly tell us the skills of each robot on the playing field.

What we like;

The simple and clear scoring system on each robot.
The observation categories and note compiling.
The ranking system based on adjustable weights.
We found the match prediction to be fairly close as the day progressed.

Thank you very much!

My Pleasure.

In the mean time, I've got another (getting close to done?) version just before I'm off to use this thing in the Oregon Regional. Check it out at the first link, page one of this thread.

Rev E improvements:

* Added match delete function. Removes match entries from team sheets, decrements # matches played, recomputes scores & ranks. Accessed from the match input sheet.
* Fixed bug where team names not copied when team sheets created.
* Added "Our Team" field (on Matches sheet). Matches with your team # will be highlighted in the matches list.

[theCoder]

Excel 2003 Version Now Available
The file is available on the download page. It is a straight "save as" from Excel 2007 and will likely have a dozen or so formatting issues that someone can clean up. I'd do it myself, but don't have a copy of Excel 2003 any more. If you do clean it up, please make it available for others.

Rev F
* Fixed bug (finally ?? !!) with team list and vlookup / validation.

In the event that this rev did not fix the problem for you, you can:
1) Cut & paste the team list to notepad, then cut & paste it back. This has been known to work.
2) Remove validation from the cells on the match input page. If you go this route, make sure to enter the team numbers correctly or you may get an error later when trying to save a match.

Enjoy...

[Corey Oostveen]

All I can say about the Guss Software is....wow!

I am very impressed with it and have not had many problems.

If anyone runs into any issues theCoder is really prompt on getting back to you. If you run into any problems contacting him I will be more then happy to help you out with use and implimentation of the software.

Many thanks from Code Red Robotics Team 2771!


Corey

[Daniel_LaFleur]

Originally Posted by Zholl

How exactly do you run this? I just downloaded it to check it out, and it downloaded as a zip file and I now have a folder with a ton of different files and folders, none of which are excel files.

It's not a zip file, it's a .XLSX file. XLSX files save as XML and therefore hold a file structure within them. You need Excel 2007 to properly open a .XLSX file.

[theCoder]

Rev G

Added 5 additional columns on the team list page to display the average values from each team sheet. For example, scoring ability, feed HP, HP scoring ability, etc. Also provided the means to quickly sort on these values. This allows you to, for example, see which team has the best human player.

[Fred Sayre]

1 problem,

It shows us as the probable loser for the first match!

Looks impressive, some people have quite the excel wizardry!

Good luck in Portland you guys, hope we can play together!

[theCoder]

Originally Posted by Fred Sayre

...Good luck in Portland you guys, hope we can play together!

Sounds great. How about late Saturday?

[Sundance Kid]

This is truly one of the best systems I've seen out there - Thanks Coder.

I fyou plan to convert to the 2003 version there is a flaw if you have too many teams, like we do for the upcoming Connecticut Regional [week 5 = 60+ teams]. Excel '03 limits your colums, so the team sheets just stop being created and you can even manuall y add them Works fine in 2007 though. Again this isn't a problem with this program rather with Mr. Gates and Microsoft's shortsightedness in '03 version.

When this sytem highlights your team (956) was highighted, but only in two fields on the blue alliance. Didn't work on the red alliance. If I changed out the "Our Team #" on the matches sheet (L14 I think it is) to be our team (1991) our team numbers are not highlighted in any sample matches I created. Again, only a minor issue with this excellently planned out system.

I did make a change to your "Paper Sheet". We have found, by just scouting at the Boston Regional (economic hardships have caused us to only enter our robot in the CT Regional, but we did make a day trip with some team members) that those that are scouting can only concentrate on one robot & HP at time. So, I have just change yours to only have 1 team monitored at a time. However, this allows me to have 8 matches on a single page. We plan to have 6 students scouting at a given time. Again, this may not be viable by a smaller team, but in no way deters from this scouting system. more of a personal observation for our own team.

I plan to run the results of the Bsoton regional through it to see how accurately the scouting system works. We have some heavy hitters coming to CT, so I'll keep you posted But, from tests I've done with it:

1) I looks easy to use - once all teams and matches have been entered
2) Matches could be quickly entered by one person
3) Scouting is made easier - even by new members to a team. So smaller teams can still get results with minimal effort
4) Results would be quick - helping a team if you are lucky enough to pick an alliance in the finals.

Good luck everyone.

[theCoder]

Originally Posted by Sundance Kid

This is truly one of the best systems I've seen out there - Thanks Coder.
...
When this sytem highlights your team (956) was highighted, but only in two fields on the blue alliance. Didn't work on the red alliance. If I changed out the "Our Team #" on the matches sheet (L14 I think it is) to be our team (1991) our team numbers are not highlighted in any sample matches I created. Again, only a minor issue with this excellently planned out system.
.

Thanks. This is my 5th year involved in scouting and I've been a software engineer for a long time.

Look for an update tonight.

< CAUTION > Deep Dark has identified a more important bug that I need to fix and/or you need to be aware of. Apparently if you leave the team sheet sorted in anything other than team # order, it will incorrectly write data when you save matches. I will fix this tonight. Until this bug is fixed, please make sure to leave the team page sorted by team # when you leave it.

[theCoder]

Rev H
* Fixed critical bug associated with match results storage problem when team list not sorted by team #
* Fixed "Our Team" highlight bug on matches sheet.

[wilsonmw04]

We used the system at VCU. It worked very well. Expect for the fact that when I asked a parent to help enter match data. I MIGHT have forgotten to tell the parent to hit "save" after every match...