OCCRA
Go to Post My brain is about as full as the ChiefDelphi servers have been lately with all the info from the past few days jammed in there. - Elgin Clock [more]
Home
Go Back   Chief Delphi > CD-Media > White Papers
CD-Events   CD-Media   CD-Spy   FRC-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

photos

papers

everything



GUSS Scouting System

theCoder

By: theCoder
New: 02-22-2009 12:37 AM
Updated: 03-19-2009 12:13 PM
Total downloads: 694 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

    GUSS-2009f-2003.xls

    downloaddownload file

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


  • lsm Guss Rev H - Excel 2007 Version

    GUSS-2009h.xlsm

    downloaddownload file

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



Recent Downloaders

Discussion

Tags

loading ...



All times are GMT -5. The time now is 06:12 AM.

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


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