Top 25 ETCs after Week 3

[speedbuggy76]

Alright, I've spent some time trying to re-create your calculations using the data from Peachtree. However, I keep getting a different number for our team (2415) than you do.

Some sample data:
In match 5, blue alliance scored 39 points and was composed of 2415, 1683, and 3694
2415's average alliance score: 77.1
1683's average alliance score: 26.2
3694's average alliance score: 7.1

The average score of the teams on the alliance = (77.1+26.2+7.1)/3 = 36.8

2415's contribution = 39*77.1/36.8 = 81.7

Is this correct? I ran this calculation for all of our matches and found us to have an average contribution of 119.2. This disagrees with your value of 38. Any idea what I'm doing wrong/differently?

Also, how did you break up the Peachtree data for our robot into ERC and EMC? I'm just using the data set on the FIRST website which only contains total alliance scores.

Thanks for putting all this together and answering questions! You have my interest piqued.