What's new
Fantasy Football - Footballguys Forums

Welcome to Our Forums. Once you've registered and logged in, you're primed to talk football, among other topics, with the sharpest and most experienced fantasy players on the internet.

ADP averaged from 3 sites (MFL/Xpert/ESPN) (1 Viewer)

Boss: Any way you could clean up the first column width so that the entire sheet fits better on the screen?Change from: "Overall Rank"to"Overall Rank"Otherwise, Thanks.......this info always is a big help.

 
Boss: Any way you could clean up the first column width so that the entire sheet fits better on the screen?

Change from: "Overall Rank"

to

"Overall

Rank"

Otherwise, Thanks.......this info always is a big help.
Click to expand...
how's this look?, (hazards of working on a widescreen sorry... :P )
 
Boss:  Any way you could clean up the first column width so that the entire sheet fits better on the screen?

Change from:  "Overall Rank"

to

"Overall

  Rank"

Otherwise, Thanks.......this info always is a big help.
Click to expand...
how's this look?, (hazards of working on a widescreen sorry... :P )
Click to expand...
:thumbup: much better.........all columns fit on my 17in screen now.
 
does anyone find it weird that lamont jordan is going 24 in xpert and 194 in MFL?
Click to expand...
hey Hip, I see 22 and 27. Where do you see 194? Did I miscalcuate something?

24 Jordan, Lamont OAK RB19 24.07 -3.40 27.19 22.30 22.73

 
Although it's part of the pay area, FBG looks like they will be doing something like this. Here is a link to some questions I raised about the frequency it will appear in the Applications Questions (VBD, AVT, Draft Dominator) forum if anyone is interested in following or chiming in.

By the way, thanks Boss Hogg for the work you've put into this. We all very much appreciate it. :thumbup:

 
Last edited by a moderator:
Is anyone able to get to buckeye's original links?I get routed to a search engine. (no spyware here either).

 
Maybe interesting - and maybe notI didn't see this thread last year, but did anyone take the final set before the season (major drafts) started and do an analysis of which site was closest to actual. Or which site has the better drafters?

 
I'll do this for you guys just tell me how.I got all the info, how do I merge spreadsheets?I'm not counting/averaging by hand, each's order is completely different.I could upload the csv files to a database and somehow query the rows that all have the same player name? I'm lost as to how to combine them

 
I'll do this for you guys just tell me how.

I got all the info, how do I merge spreadsheets?

I'm not counting/averaging by hand, each's order is completely different.

I could upload the csv files to a database and somehow query the rows that all have the same player name?

I'm lost as to how to combine them
Click to expand...
Someone else can walk you through some fairly easy ways to do it in a database.If you want to do it in Excel here is a way. This assumes that all the names are listed the same (i.e. no Mike Vick in one list and Michael Vick in another), and that no players have the identical first/last name.

1. Combine the first and last names of each player into a cell (using =A1&B1). This will give you a fairly nonrepeatable ID.

2. Sort the list with the ADPs by alphebetical order.

3. Repeat 1&2 for every list you want to combine.

4. On a different part of the spreadsheet copy all the combined names.

5. Use the vlookup function on the combined names to lookup the ADP in the other lists. (using =vlookup(cell with combined name,list you are looking up from fixed with $ signs, the number of columns you want to have to go over from the combined name to the ADP data,false))

6. Repeat 5 for the other lists.

7. Average the ADPs, sort by lowest to highest ADP.

PM me if this doesn't make sense.

 
I'll do this later today(merged or not)Bucky,I don't have excel my computer came with XPs stripped down Excel wanna be. I have that and decided to get Filemakerpro.I'll look into this vlookup type stuff though. Thanks for the suggestion

 
as for DB, if any other suggestions out there, I've got MySQL and use PHPMyAdmin(like everyone else seems to)

 
as for DB, if any other suggestions out there, I've got MySQL and use PHPMyAdmin(like everyone else seems to)
Click to expand...
Quick hijack - do you know if MySQL works with Excel or Access, or do you just prefer FileMakerPro?
 
MySQL works with everything, well it really seems too. Haven't found anything that doesn't work with it

 
You must log in or register to reply here.

Similar threads

Scoresman
Knowing your league - The Single Best Piece of FF Research You Can Do
Replies
22
Views
669
Joe Bryant
Joe Bryant
Hot Sauce Guy
What is the strangest draft strategy you’ve ever seen?
2
Replies
51
Views
877
Rubi
R
Ministry of Pain
Some of the biggest traps most fall victim to in Redraft
2 3
Replies
121
Views
3K
blips24
blips24

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
Top