Go to Post Looks very well designed. Now where is the "export to reality" button in the CAD software? (I have been looking for it for weeks). - sanddrag [more]
Home
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

photos

papers

everything



Team 2834 Scouting Database-2017 Season

By: gkridli
New: 03-09-2017 10:26 PM
Updated: 05-05-2017 06:49 PM
Total downloads: 93 times


Scouting database with OPR, CCWM and EPR calculations for week 1

This is the continuation of scouting database by Ed Law from
http://www.chiefdelphi.com/media/papers/2174.

EPR calculations (http://www.chiefdelphi.com/forums/sh...d.php?t=137328) are also included.

Attached Files

  • lsx Team_2834_2017_Scouting_Database_Final.xlsx

    Team_2834_2017_Scouting_Database_Final.xlsx

    downloaddownload file

    uploaded: 05-03-2017 10:24 PM
    filetype: lsx
    filesize: 12.93MB
    downloads: 24


  • lsx Team_2834_2017_Scouting_Database_Final-corrected finish.xlsx

    Team_2834_2017_Scouting_Database_Final-corrected finish.xlsx

    downloaddownload file

    uploaded: 05-05-2017 06:49 PM
    filetype: lsx
    filesize: 12.93MB
    downloads: 67



Recent Downloaders

Discussion

view entire thread

Reply

03-13-2017 06:29 AM

Banderoonies


Unread Re: paper: Team 2834 Scouting Database-2017 Season

Hello, I can't seem to get this to work. When I enter a team number, none of the ranks change in the Query tool. Also, what is the difference between EPR and OPR? both descriptions in your instructions tab are the same



03-16-2017 08:55 PM

Jacob Plicque


Unread Re: paper: Team 2834 Scouting Database-2017 Season

The scouting database is showing 1065 Moose as the #1 OPR team in the world with an Orlando regional #2 OPR of 135.73. Spam 180 was #1 in the Orlando regional as the champion and the top OPR of 138.98. How did the results get flipped?



03-16-2017 09:07 PM

Jacob Plicque


Unread Re: paper: Team 2834 Scouting Database-2017 Season

Removed



03-17-2017 02:18 PM

indubitably


Unread Re: paper: Team 2834 Scouting Database-2017 Season

Will the "Alliance" and "Finish" columns be populated in future releases?



03-23-2017 07:46 AM

gkridli


Unread Re: paper: Team 2834 Scouting Database-2017 Season

Quote:
Originally Posted by Banderoonies View Post
Hello, I can't seem to get this to work. When I enter a team number, none of the ranks change in the Query tool. Also, what is the difference between EPR and OPR? both descriptions in your instructions tab are the same
Automatic calculations was turned off in previous versions and required to manually click on "calculate" at the lower left corner of the "Query" worksheet. The current version automatically updates team info once for the desired team number.



03-23-2017 07:48 AM

gkridli


Unread Re: paper: Team 2834 Scouting Database-2017 Season

Quote:
Originally Posted by Jacob Plicque View Post
The scouting database is showing 1065 Moose as the #1 OPR team in the world with an Orlando regional #2 OPR of 135.73. Spam 180 was #1 in the Orlando regional as the champion and the top OPR of 138.98. How did the results get flipped?
Thanks for pointing this out, we will be looking into it to fix it in the coming week.



03-23-2017 07:50 AM

gkridli


Unread Re: paper: Team 2834 Scouting Database-2017 Season

Quote:
Originally Posted by indubitably View Post
Will the "Alliance" and "Finish" columns be populated in future releases?
We will be including information on the alliance, the alliance caption, the finalists and winners for each event. This will be included with the results for weeks 4.



03-23-2017 07:11 PM

Jacob Plicque


Unread Re: paper: Team 2834 Scouting Database-2017 Season

1065 and 8 other teams got DQs at Orlando. I suspect this may have shewed the matrix results.



04-03-2017 01:05 PM

Caleb Sykes


Unread Re: paper: Team 2834 Scouting Database-2017 Season

Are you calculating the component OPRs in the same way as you calculate conventional OPR? I'm noticing a slight discrepancy in component OPR values between your sheet, the 4536 database, and Jaci's component OPR calculator. Looking at the calculated contribution to teleop takeoff points (OPR Touchpad) for the Bayou regional, we have:

2834 database:

Code:
Team	OPR Touchpad
281	68.0
283	44.3
364	44.0
456	36.0
590	-7.3
1421	62.7
1730	30.6
1818	3.4
1902	37.6
1912	35.0
1927	-15.3
2078	17.4
2080	59.2
2152	40.9
2183	45.0
2221	23.0
2613	24.9
2797	50.0
2992	28.3
3039	34.2
3337	33.0
3478	52.7
3481	33.6
3606	30.9
3616	53.7
3666	0.8
3753	7.6
3932	38.3
3937	48.2
3946	-35.9
3991	25.3
4053	-7.1
4063	8.3
4087	28.1
4107	25.4
4209	16.0
4336	26.6
4353	17.5
4587	33.2
4592	61.4
4641	39.8
4978	27.2
5006	23.6
5168	52.8
5325	-9.9
5410	24.6
5785	19.5
5819	33.5
5863	-4.6
5864	36.1
5953	10.4
5965	6.3
5971	-14.9
5997	-17.2
6068	15.1
6103	26.5
6179	53.3
6489	16.5
6614	3.8
6677	7.1
4536 database:
Code:
Team	teleop Takeoff Points
281	70.63
283	46.52
364	46.86
456	40.51
590	-8.04
1421	60.87
1730	34.20
1818	2.55
1902	31.32
1912	41.75
1927	-16.46
2078	17.86
2080	48.84
2152	43.79
2183	41.23
2221	21.55
2613	29.33
2797	42.88
2992	39.87
3039	33.14
3337	32.58
3478	57.16
3481	43.35
3606	38.02
3616	58.12
3666	0.97
3753	7.90
3932	46.43
3937	53.61
3946	-32.16
3991	27.72
4053	-5.47
4063	11.00
4087	26.15
4107	33.94
4209	18.46
4336	28.41
4353	18.45
4587	36.01
4592	62.34
4641	33.89
4978	28.18
5006	25.59
5168	50.43
5325	-8.18
5410	27.02
5785	13.52
5819	27.70
5863	-3.72
5864	40.01
5953	13.51
5965	7.42
5971	-13.68
5997	-17.70
6068	14.51
6103	25.84
6179	52.20
6489	16.44
6614	3.87
6677	5.94
Jaci's component OPR calculator:
Code:
Team	ready_for_takeoff_opr
281	70.63
283	46.52
364	46.86
456	40.51
590	-8.04
1421	60.87
1730	34.2
1818	2.55
1902	31.32
1912	41.75
1927	-16.46
2078	17.86
2080	48.84
2152	43.79
2183	41.23
2221	21.55
2613	29.33
2797	42.88
2992	39.87
3039	33.14
3337	32.58
3478	57.16
3481	43.35
3606	38.02
3616	58.12
3666	0.97
3753	7.9
3932	46.43
3937	53.61
3946	-32.16
3991	27.72
4053	-5.47
4063	11
4087	26.15
4107	33.94
4209	18.46
4336	28.41
4353	18.45
4587	36.01
4592	62.34
4641	33.89
4978	28.18
5006	25.59
5168	50.43
5325	-8.18
5410	27.02
5785	13.52
5819	27.7
5863	-3.72
5864	40.01
5953	13.51
5965	7.42
5971	-13.68
5997	-17.7
6068	14.51
6103	25.84
6179	52.2
6489	16.44
6614	3.87
6677	5.94



04-05-2017 09:35 AM

gkridli


Unread Re: paper: Team 2834 Scouting Database-2017 Season

The database for week 5 shows new computations for the component OPR values and are now in line with the database by team 4536.



04-18-2017 04:40 PM

kingbrandon14


Unread Re: paper: Team 2834 Scouting Database-2017 Season

There appears to be an error in the PeachtreeStateCMP sheet- the team numbers are not listed like they are in the other sheets, so none of the data from PeachtreeStateCMP is able to be applied to those teams for that event.

Other than that, everything looks awesome, thanks a ton for putting this together again this year!



05-06-2017 12:28 PM

gkridli


Unread Re: paper: Team 2834 Scouting Database-2017 Season

Thank you. We corrected the sheet for the Peachtree Championship in the final version that was posted this week. We will continue to publish the database and are exploring means to improve it for the 2018 season.



view entire thread

Reply

Tags

loading ...



All times are GMT -5. The time now is 03:41 AM.

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


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