GUSS Scouting System

[Pat Arnold]

I couldn't open the file since it's in Excel 2007... wish it was available in Excel 2003.

[ATannahill]

Originally Posted by Pat Arnold

I couldn't open the file since it's in Excel 2007... wish it was available in Excel 2003.

seconded

[JesseK]

Maybe you guys should "upgrade" rather than requesting that he downgrade...there's some really spiffy things going on in the background that 2007 does that can mostly be converted to 2003 formats.

Microsoft Office 2007 Converter

[theCoder]

Thanks for the input.

The most common problems I've seen so far have been associated with running directly from the download. Save the program when prompted, do not open it. A number of problems go away this way. If the buttons do not work, try to enable macros. This is done with the colorful button in the top left \ excel options \ trust center \ trust center settings \ macro settings \ "Enable" and check "trust access..."

I understand the desire for a 2003 version. I no longer have any computers with this version. I can do a save-as to the 2003 version, but I'm pretty sure there will be some problems with the macros. The differences may be minor and be a great learning experience for someone.

Someone asked about running this on Open Office (open source office for Linux). I'd be very surprised if it works. I use open office on my laptop and have noticed minor differences. There are a lot of semi-advanced macros under some of these sheets and I doubt the code has been implemented exactly.

Rev C
* Made observed attributes more configurable. Text on "Attributes" sheet, Column A will show up on other sheets and scouting paper sheet. Ranges are now all 0 (bad), 1 (medium/average), & 2 (good). Default values are also configurable.
* Added averages of all observed attributes on the team sheets. Now can see, for example, the % win of a team.

Worksheets in this system include:

Team List – List of teams, team names, current rank, average computed “score”, # matches played. On this screen is a button to automatically create one sheet per team. You may order the list by team # or by rank order. Double clicking on a team # will jump to the team sheet for that team.

Matches – The list of matches, each with the scheduled time, teams, and a forecasted winner based on previous team scores. Double clicking on a match id will automatically clear and populate the Match Input sheet.

Match Input –Match observations are entered in this sheet. The system automatically sets the default values for each observation/team to the configured default values. These values are set to a dark grey color initially. As values are entered, they turn black. This aids in data input so the scout can quickly double check that all entries have been made. If nothing extreme is observed, the default values will be used. This significantly reduces the amount of data collection required and entered. Space is provided for notes to be entered for each team. On this screen is a “Save Match” button. The save macro automatically populates information on each team sheet, copies team average values to the “Team List” screen, determines the rank order of all teams, then copies the rank values to the individual teams sheet.

Attributes & Weights – This sheet contains the list of 5 user configurable observations, their weight, % of total, default value, and description. The text value of the observation is automatically populated on the Match Input Screen, Individual Team sheets, and the Paper Sheet sheet. As delivered, the observations include: Robot Scoring Ability, Human Player Scoring Ability, Ability to feed human player / empty cells, Heavily Scored Upon, Healthy (died, had some problem).

Team Sheets – One sheet per team based on a configurable template. This sheet includes the team #, team name, # matches played, current rank, average values for all observations of the matches played, and all notes taken during the matches. Space is provided for a picture of the robot.

Notes – Contains revision log, and various notes about using the system.

[Daniel_LaFleur]

Originally Posted by theCoder

I understand the desire for a 2003 version. I no longer have any computers with this version. I can do a save-as to the 2003 version, but I'm pretty sure there will be some problems with the macros. The differences may be minor and be a great learning experience for someone.

Someone asked about running this on Open Office (open source office for Linux). I'd be very surprised if it works. I use open office on my laptop and have noticed minor differences. There are a lot of semi-advanced macros under some of these sheets and I doubt the code has been implemented exactly.
.

I've converted it to EXCEL 2003 and it seems to work just fine (granted I'm running it under EXCEL 2007 in compatability mode, so YMMV). I'll test it in open office later on today.

BTW, really nice setup

P.S. is there any way of adding additional weights easily and expanding the weights beyond 0-1-2?