Call for draftpreview.html files from 6.0e

[gstelmack]

All evidence is pointing to the combine numbers changing up in 6.0e. This means Analyzer is lying to everyone. So, we need new averages / standard deviations.

I am setup where I can add data from a draftpreview.html file spit out by the game to a spreadsheet and update my averages and standard deviations. I just need some of these files. I'm using the WOOF file as a base, but if anyone has any other draftpreview.html files from other leagues or single player games THAT WERE GENERATED BY 6.0e, I would love to get hold of them. I need 10 as a minimum sample size, but the more I've got the more accurate it is.

I've got a test league with no human owners that I can get some of these from, but it'll take me some time. If anyone has some already, it would save time.

[Dutch]

THAT WERE GENERATED BY 6.0e

Ack, I almost sent you the IHOF 2013 draft preview...but that would've been 6.0d...

[Ben E Lou]

Snet 14 of these to Greg today, so hopefully he's good to go here.

[gstelmack]

Looking good. Working on updated spreadsheet now.

[gstelmack]

Here are the updated numbers I've got:

Row Labels	Wt Avg	Wt Min	Wt Max	Pos Val	40 Avg	40 StD	Sol Avg	Sol StD	Bnch Avg	Bnch StD	Agil Avg	Agil StD	Brd Avg	BrdStD	Drl Avg	Drl StD
C	291.5	262	332	0.856	5.307	0.124	29.678	10.369	24.493	4.837	8.059	0.195	89.228	6.583	0.000	0.000
CB	189.6	170	217	1.027	4.549	0.075	22.028	6.216	11.128	3.050	7.263	0.194	106.172	4.699	32.615	9.038
DE	271.1	243	311	1.095	4.902	0.136	23.655	6.749	25.594	3.899	7.697	0.293	106.820	7.365	0.000	0.000
DT	297.9	268	341	1.076	5.144	0.141	21.900	6.320	27.285	3.670	7.909	0.325	96.227	9.184	0.000	0.000
FB	240.8	218	274	0.805	4.818	0.072	21.342	4.946	19.534	4.087	7.583	0.185	102.338	5.000	20.159	7.061
ILB	244.9	217	279	0.971	4.876	0.112	27.205	6.708	20.447	3.444	7.670	0.244	102.996	5.829	19.967	7.182
K	201.1	182	229	0.591	5.158	0.132	26.024	7.475	8.835	2.829	7.691	0.331	102.554	6.370	0.000	0.000
OG	311.1	279	354	0.945	5.295	0.124	27.767	9.882	26.674	4.392	8.017	0.264	88.938	6.260	0.000	0.000
OLB	238.1	213	275	0.955	4.748	0.119	25.398	6.635	17.008	3.640	7.436	0.193	107.570	5.634	19.575	7.184
OT	315.6	281	356	1.095	5.322	0.165	27.227	10.756	26.815	5.247	7.908	0.263	91.083	6.624	0.000	0.000
P	211.6	190	237	0.529	5.109	0.173	25.174	6.812	9.953	3.669	7.699	0.352	105.699	7.212	0.000	0.000
QB	217.8	197	250	1.137	4.797	0.141	27.905	6.724	9.315	2.148	7.867	0.234	101.482	6.121	68.983	9.274
RB	215.9	193	245	1.058	4.668	0.086	20.489	6.063	14.270	3.672	7.348	0.137	114.309	5.171	14.331	6.705
S	204.1	185	233	0.938	4.611	0.083	29.600	7.187	14.509	3.072	7.414	0.222	97.891	4.623	33.532	9.019
TE	253.2	228	290	0.867	4.816	0.080	24.153	6.519	21.542	4.094	7.851	0.324	103.716	5.873	28.166	8.974
WR	195.5	175	224	1.036	4.565	0.102	20.718	6.690	9.754	3.204	7.276	0.198	106.859	5.325	37.560	9.868
Totals	243.3	170	356	0.981	4.877	0.294	24.722	8.018	17.989	7.774	7.637	0.365	101.737	9.380	19.816	20.935

The "PosVal" column is simply the weight that FOF applies to the bureau rating to get to the adjusted rating, in case you wanted to know what those default weights were...

[Ben E Lou]

Those numbers look low. Any chance you did averages without backing out the guys who didn't show up to combines?

[gstelmack]

Broad Jump numbers are off a bit. It's not letting me ignore the "0" for guys that did not participate. Working on that one.

[Ben E Lou]

40 times and bench presses look too low as well...i'm wondering if they're all off

[gstelmack]

Pivot Table filters not working as expected. I think I'm just going to have to delete the no combine guys and hope that doesn't skew solecismic and position drill much.

[gstelmack]

Deleted combine guys. Removes almost 500 (from 12,500) entries that had Solecismic and Position Drill numbers.

[gstelmack]

Table corrected.

[cuervo72]

Sigh. Yep, was talking to SD about this, and it's going to lead me to have to tweak the FOFL combine tool. Which is a shame, because all of the combines from all of our drafts are in there, and it was nice to compare new draftees to past classes. They just don't line up quite the same now.

(I have a few different sql queries to calculate the ranges on the fly, each of which filters out guys with different combine sets...contemplating just using constants though)