boss hogg
Footballguy
I've got three sites so far this year (mfl, antsports, and xperts). Your welcome to check these out until the FBGs post a web version...
my averaged ADP
my averaged ADP
thanks b.h.I've got three sites so far this year (mfl, antsports, and xperts). Your welcome to check these out until the FBGs post a web version...my averaged ADP
i think espn is charging for this info now.If anyone has a link to the ESPN ADP(or any other reputable site) I can include those as well, I could not find the damn thing.
Sweet - thx Boss HoggMy June ADPPatiently waiting for FBG to provide a web version. Your all welcome to use my excel version until they do. This only June Drafts (except MFL, who does not break that out yet.)
I've got three sites so far this year (mfl, antsports, and xperts). Your welcome to check these out until the FBGs post a web version...my averaged ADP
That would be correct. But too many comments about "shrinkage" caused me to switch to the "Godfather of Soul" baby!Tbone didn't you have a George Costanza avatar last year?Great stuff I used it last year.
I'm unsure if this is of any help or not .... MFL Draft Tracker up till July 4th Great stuff you guy's .... greatly appreciated !!My June ADPPatiently waiting for FBG to provide a web version. Your all welcome to use my excel version until they do. This updated for June Drafts (except MFL, who does not break that out yet.)
Here's one just updated for those that prefer a web page rather than downloading an excel file.Average Draft Position 2004Hey guys. Sorry, first time to the Shark Pool since last year. Here's what I know, last year I created the ADP average in an excel format and a static html format that I hosted on my site. I posted links to it here in the Shark Pool for all to see.Footballguys contacted me and asked permission to use this data on their site, which I granted for a small fee. They took the information and improved upon it by making the web version fully sortable by various catagories. This was by far the most useful way to use this tool.I don't know if they plan to do the same this year or not, haven't heard from them. I'm not sure I'll be updating my pages this year or not as I've been pretty busy. But if I do, I will post here.In the mean time, it looks like boss hogg has created a great excel file to use.
Thanks for the web version tbone. I'm starting to think about excluding the MFL Draft data simply because it includes IDPs. Not that there is anything wrong with IDPs, but for those that don't use them in their leagues, it skews the ADP data downward the further down the list you go.Here's one just updated for those that prefer a web page rather than downloading an excel file.Average Draft Position 2004Hey guys. Sorry, first time to the Shark Pool since last year. Here's what I know, last year I created the ADP average in an excel format and a static html format that I hosted on my site. I posted links to it here in the Shark Pool for all to see.Footballguys contacted me and asked permission to use this data on their site, which I granted for a small fee. They took the information and improved upon it by making the web version fully sortable by various catagories. This was by far the most useful way to use this tool.I don't know if they plan to do the same this year or not, haven't heard from them. I'm not sure I'll be updating my pages this year or not as I've been pretty busy. But if I do, I will post here.In the mean time, it looks like boss hogg has created a great excel file to use.
TBone, Tryboss hogg,
have you figured out an easy way to convert the way antsports reports draft positions to a raw number? in other words, they might show somebody's average as 4.5.86 (4th round 5.86th pick). Of course you also must know the size of the league. So in a 12 team league this would equal average pick 41.86.
Not a major deal to write a forumula in excel that will convert this, but so far the only way I've figured out how to do it is to do that silly text to column thing first and then write a formula.
Anyway enough beyatching. Was just wondering what you do to convert your antsports numbers?
Edited to say I took a closer look at the formula you created and see that your way is easier than what I was doing. I noticed that you appear to truncate rather than round though. In otherwords an average of 9.8 would show up as pick 9 rather than 10 if I'm understanding your formula correctly. I wonder if it'd be easy to tweak it a little to round rather than truncate.....hmm..
MROUND(((LEFT(H5,FIND(".",H5)-1)-1)*12+MID(H5,FIND(".",H5)+1,2)+RIGHT(H5,2)/100),1)
I see that, and now that I think about it, to average apples to apples we should not truncate nor round the antsports figure if we report the MFL (and now xperts) figure to include decimal places. In that case TBone, dropping the MROUND portion of the formula will include the decimals but not round.On another subject, I had some thoughts on not including the MFL data due to the fact that IPDs were included. Does anyone know if we can get that same data but only for drafts including offensive players. I played around with the options a bit, but could not find a way to do that.A note on the Xperts ADP to you guys that are compiling it. I carry it out the the hundredth place now to aid in getting accurate averages between the sites that you use.
Agreed on not reporting results as integers. Your idea without the MROUND is exactly what I had done. As far as only pulling from non IDP drafts at MFL, I'm not aware of any way to do it. I wonder what percentage of the leagues that use MFL actually use IDP's anyway. I'd have to think it is pretty low.I see that, and now that I think about it, to average apples to apples we should not truncate nor round the antsports figure if we report the MFL (and now xperts) figure to include decimal places. In that case TBone, dropping the MROUND portion of the formula will include the decimals but not round.On another subject, I had some thoughts on not including the MFL data due to the fact that IPDs were included. Does anyone know if we can get that same data but only for drafts including offensive players. I played around with the options a bit, but could not find a way to do that.A note on the Xperts ADP to you guys that are compiling it. I carry it out the the hundredth place now to aid in getting accurate averages between the sites that you use.
Good info here.It's been about a month now -- can we expect an update? Pretty please?
I'll jump on the good info bandwagonGood info here.It's been about a month now -- can we expect an update? Pretty please?
-feT-Bone,
This was one of my favorite sources on the site last year. It helped out a ton at my drafts and I found the info to be pretty dead on. Are you keeping it up this year?
I vote that FBG add this list to the subscriber area as a regular feature.