paper: Team 2834 Scouting Database-2017 Season

CD-Media: Papers
, , , , ,
1

Thread created automatically to discuss a document in CD-Media.

Team 2834 Scouting Database-2017 Season
by: gkridli

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

This is the continuation of scouting database by Ed Law from
paper: New Scouting Database from Team 2834 - CD-Media: Papers - Chief Delphi.

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

Team_2834_2017_Scouting_Database_Final.xlsx (12.9 MB)
Team_2834_2017_Scouting_Database_Final-corrected finish.xlsx (12.9 MB)

2

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

3

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?

4

Removed

5

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

6

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.

7

Thanks for pointing this out, we will be looking into it to fix it in the coming week.

8

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.

9

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

10

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:

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:

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:

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
11

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

12

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!

13

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.