|
|
 Who says engineers can't be poets? - Wayne TenBrink [more] |
 |
|
||||||||||||||
|
|||||||||||||||
A spreadsheet to store, view, and analyze match data for OPR, CCWM, and +/- for the game Lunacy
This spreadsheet stores scout data for the game Lunacy. All data must be hand entered, unfortunately, but I'm working on a way to fix that. The front sheet is a search page based on the databases provided by Ed Law, but the rest is custom built. Includes a page for calculating OPR and Ed Law's CCWM, which is set up for the teams attending the Colorado Regional, according to TBA.
This system is set up for the Colorado Regional, but anyone with intermediate skill in excel should be able to scale it and edit it for others
Note: This is currently a beta version of the system, as I am still working out some kinks in how the system will ultimately work. If any of the numbers generated by this system seem to be incorrect, drop me a pm and I'll try to fix it. Also, there is a partial entry in the Raw Data section. This was meant to test the search sheet, and does not represent any real data.
Attached Files
-
Scout System beta v.5.xls
Scout System beta v.5.xls
download file
uploaded: 03-09-2009 12:49 AM
filetype: xls
filesize: 174kb
downloads: 185
-
Scout System beta v.6.xls
Scout_System_beta_v.6.xls
download file
uploaded: 03-16-2009 11:16 PM
filetype: xls
filesize: 182kb
downloads: 119
-
Scout System beta v.7
Scout_System_beta_v.7.xls
download file
uploaded: 03-25-2009 06:43 PM
filetype: xls
filesize: 301kb
downloads: 155
Discussion
view entire thread
03-16-2009 11:17 PM
Zholl
Re: paper: Team 2996 Scout System/Database
Updates in version 0.6
- "Raw Data" page now pulls all average stats for each team as well as each calculated stat (OPR, DPR, CCWM, +/-)
- Sample matrix added for ease of testing calculated stats retrieval
Planned Updates for version 0.7
- Bot picture retrieval for each team
- Individual match stats retrieval in addition to average scores
- DPR calculation matrix and data retrieval setup
- Rankings in addition to raw calculated stat scores
03-25-2009 06:46 PM
Zholl
Re: paper: Team 2996 Scout System/Database
Updates version 0.7
- Added individual scoring and alliance scoring for matches in search page
- Added a sheet for storing individual match scores and alliances
- Tweaked interface
- Added match number tracking for teams in Raw Data
- Added DPR matrix system and data retrieval
- Calculated stats (OPR, DPR, CCWM, +/-) are now ranked in Raw Data and the search page
Planned Future updates
- Picture retrieval
- Cleaner interface
If anyone can explain to me how to add picture retrieval, it would be a big help, since I can't seem to get it.
view entire thread
Tags
loading ...