Go to Post Sometimes, having someone that can teach you just shows you another way to do what you've been doing, but in fewer moves. - Amanda Morrison [more]
Go Back   Chief Delphi > CD-Media > White Papers
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules




GUSS Scouting System


By: theCoder
New: 02-22-2009 12:37 AM
Updated: 03-19-2009 12:13 PM
Total downloads: 793 times

Excel 2007 based scouting system for the 2009 season.

Optimized for easy data collection and data entry. Not your typical Excel spreadsheet.

Rev b improvements:
* Added match winner forecast
* Corrected mandate that one team win. Added ability to have a tie match.
* Added more data validation / error traps.

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.

Rev D
* Added a match evaluation sheet that shows detailed data for all teams in a match and also predicts the winner.

Rev E
* 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.

Rev F
* Fixed bug (finally ?? !!) with team list and vlookup / validation.
* Made available a untested, ready for someone else to correct, 2003 export version. Compatability issues will most likely be around field validation and formatting. It should'nt take more than an hour or so for someone to clean up this version. I'd do it, but do not have this version anymore. If someone does do the clean up, could you make it available to others. Thanks.

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.

Rev H
* Fixed critical bug associated with match data not written correctly IF team sheet was not sorted by Team #
* Fixed color issue with "Our Team" on matches sheet

Attached Files

  • xls Guss Rev F - Excel 2003 Version - known broken


    downloaddownload file

    uploaded: 03-03-2009 05:28 PM
    filetype: xls
    filesize: 1.25MB
    downloads: 379

  • lsm Guss Rev H - Excel 2007 Version


    downloaddownload file

    uploaded: 03-19-2009 12:11 PM
    filetype: lsm
    filesize: 515.07kb
    downloads: 412

Recent Downloaders



loading ...

All times are GMT -5. The time now is 12:43 PM.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi