New Custom Import Feature for Points and ADP

  • 2
  • Announcement
  • Updated 2 months ago
How to import custom fantasy points and/or ADP for your fantasy football league:
  1. Open Draft Analyzer: Open the Draft Analyzer for the league you want to import custom points/adp for.
  2. Click "Upload Custom" link: Click the "Upload Custom" link in the top menu of the Draft Analyzer.
  3. Drag and Drop .csv file: Drag and drop your custom projections (in a .csv file...not .xls) onto the drop zone.
  4. Map Player Names: If any players in your spreadsheet are not recognized (typically because of different spellings of names) you will see a pop-up with those players.  Make any corrections to your spreadsheet and upload again.
  5. Only Your Players Included: Only players matched in your spreadsheet will be included in the player rankings and optimal team.  All other players will have points of zero but will be available in the general player pool and within the Player Search feature.
  6. Done!: The Draft Analyzer will update all projections and analytics based on your custom imported fantasy points and/or ADP.  You will see "Custom" selected in the yellow General Manager settings in the upper right.  You can toggle between your purchased projections and your custom projections at any time.
About the Player Mapping:
  1. Common Spellings: The Draft Analyzer includes the common spelling of close to 1,000 players and team defenses.  
  2. Player Search: View how the Draft Analyzer spells any name using the Player Search feature.
  3. "Name" or "Player" field: The import process will search for an exact match the "Name" or "Player" field in your spreadsheet.  The players team or position are not used to match players as they are not needed.
  4. "Points" and/or "ADP" fields: Once a player name is recognized, the values in the "Points" or "ADP" fields will be saved for that player.
  5. Send us Missing Players: We are constantly updating the player name mapping file, so send any names to support@draftanalyzer.com that you feel we should include and we will...usually the same day.
About the .CSV File:
  1. Save as .CSV File: Save your Excel, Google sheet or other file to a Comma Separated Values text file (.CSV).  Should be easy to do.
  2. Required Fields: Name field is required but can be called either "Name" or "Player". Points and/or ADP are required. Points can be "Points" or "Pts".  ADP field must be "ADP".
  3. Ignored Data: All columns other than those in #2 are ignored, so you do not have to remove player stats or other data from the spreadsheet before uploading.
  4. Any Order: The order of your columns/fields does not matter.
Photo of Ted Kasten

Ted Kasten, Founder

  • 3707 Posts
  • 264 Reply Likes
  • Excited

Posted 3 years ago

  • 2
Photo of Chris Holland

Chris Holland

  • 16 Posts
  • 3 Reply Likes
Looking forward to trying this
Photo of Chris Holland

Chris Holland

  • 16 Posts
  • 3 Reply Likes
For the ADP and projection files, would be great if you can show a demo of what columns look like
Photo of Ted Kasten

Ted Kasten, Founder

  • 3703 Posts
  • 263 Reply Likes
Good idea. Thank you.  Here you go.  Only the Name, Points and ADP columns are imported in this example. The other fields are not needed and are ignored.  Don't quote me on Jordy getting 400pts!

.
Photo of Chris Holland

Chris Holland

  • 16 Posts
  • 3 Reply Likes
Some problem with Team Defense.  How should I show names?
Photo of Jay Bellville

Jay Bellville, Employee

  • 2094 Posts
  • 225 Reply Likes
Same as players. you can use Cowboys or Cowboys DST or Cowboys D/ST or Dallas
Photo of Chris Holland

Chris Holland

  • 16 Posts
  • 3 Reply Likes
Think you are missing Housler and James O'Shaughnnesy.  Would be good to add them so I can be mapped against 4 for 4
Photo of Jay Bellville

Jay Bellville, Employee

  • 2098 Posts
  • 226 Reply Likes
Chris they are showing in our database as Robert Housler and James Oshaughnessy
Photo of Chris Holland

Chris Holland

  • 16 Posts
  • 3 Reply Likes
One thing that would be great is to have 4for4 and you have the same names.  That would simplyify downloading latest projections a lot.  Possible?  It would also be good if 4for4 can include the DST projections in one csv
Photo of Jay Bellville

Jay Bellville, Employee

  • 2098 Posts
  • 226 Reply Likes
Chris we have multiple projection sources so matching up exactly with all of them is impossible for us. As far as 4for4 including the DST projections in one csv you can contact their support and see if this is something they may be able to do.
Photo of Brandon Solemsaas

Brandon Solemsaas

  • 7 Posts
  • 2 Reply Likes
I have my file saved as .csv and have ADP and player filed save in there. When I drag and drop it doesn't update.  Any input into why this wouldn't update to my imported rankings?
Photo of Jay Bellville

Jay Bellville, Employee

  • 2098 Posts
  • 226 Reply Likes
Brandon,

If you could send us a email over at support@draftanalyzer.com with a sample of the .csv file you are trying to load into the Draft Analyzer and we can take a closer look at what the error could be.

Thanks,
Jay
Photo of RalphPa

RalphPa

  • 2 Posts
  • 0 Reply Likes
I have a question about possibly importing "positional drafting tendencies" for a league of mine into DA. One league I have been in has shown some positional drafting tendencies that are very unique to this league.  Is it possible to upload this data in generic 'by position' form?  For example, the biggest tendency is that RBs go much earlier than pretty much any other league I've played in.  Knowing this information is obviously useful in seeing how many at a given position are likely to be drafted before your next pick and exploiting it for my benefit.

What I would expect the program to maybe do is something like this:  use my rankings to tell me what should be left for my future picks, but use ADPs to know the order players would be drafted by other people b/w my picks AND use this "positional drafting tendencies" data to influence DA in selecting specific positions b/w my picks in forecasting what will be available for my future picks. So basically, ADP is only used to determine what order players are selected by the rest of my league while this custom "positional drafting tendencies" data would be used in selecting how many at each position might go b/w my picks.  (this would be the general idea, but I assume that DA might have some algorithm it would use with all this data) 

I could upload the data in a few ways. I could tell DA how many go at which position in each round. I could also give it an entire draft pick by pick by position.  Here are a couple screen shots for you to show you how I could present this info to upload to DA (first one is an example showing only RBs and I have that info for each position).  I have several years of data by year, but could easily combine into a single column based on more recent trends in my league.

Please let me know your thoughts.  Thanks!

(Edited)
Photo of Ted Kasten

Ted Kasten, Founder

  • 3700 Posts
  • 263 Reply Likes
Very interesting data and idea. I am trying to understand exactly how this would work. If the data shows that RBs go much earlier...then WR and Gronk and a few QBS likely get bumped down. Could you export our current ADP and then lower the numbers for RBs and increase the others as dictated by your data? And then re-import it? Would that cover this?
Photo of RalphPa

RalphPa

  • 2 Posts
  • 0 Reply Likes
Yes. What you suggest is basically along the lines what I was thinking might be the best current fix.

If you did edit the program to allow for a scenario where it was using both ADP & some sort of draft history for a league, I guess I would expect it to use the ADP to know the order of players at each position and then just bump down a few picks the positions that don't go as early.  It actually seems fairly simple to consider on the surface.  I know you would have to incorporate other ideas already present in the program like tier or value dropoffs that could possibly conflict with the draft history data. I would think that the dropoffs might rule over the league history data when it's obvious.  This would obviously take some additional programming to fine tune it so that you are comfortable it works well.

I think the best way to add something like this into the programming is probably to concentrate on the number drafted each round and then try somehow to accommodate that.  The data used would be the 2nd example I uploaded.  The program would know how many at each position should be gone at the end of each round, but then would have some checks in there to make sure something egregious didn't happen (example:  you wouldn't want to be 1 away from the end of a HUGE dropoff at a position and have that player go 10 picks later just b/c league history said only a certain number go in that round).  I think overall it seems like a simple concept to incorporate into the programming, but it probably would take a good bit of programming to get it just right.

Thanks for listening.
(Edited)
Photo of Adler Brutus

Adler Brutus

  • 1 Post
  • 1 Reply Like
Is Quan Bray in the rankings?  WR/IND
Photo of Jay Bellville

Jay Bellville, Employee

  • 2090 Posts
  • 224 Reply Likes
We did add him but the projection sources have him projected points so you should only see him in searches currently
Photo of Bob Modelski

Bob Modelski, Employee

  • 1264 Posts
  • 72 Reply Likes
He is not a player being drafted even in the deepest of leagues but we will add him in the next update.
Photo of Justen

Justen

  • 6 Posts
  • 2 Reply Likes
First off, I'm super excited the site is up for 2017!!!!

I was wondering if custom ADP still available?  I'm uploading an ADP file and I'm not sure if its taking or where to select on under General Manager as I don't see a Custom ADP button to select.  Thanks!
Photo of Ted Kasten

Ted Kasten, Founder

  • 3702 Posts
  • 263 Reply Likes
Yes, the custom uploads for ADP, Points and Dollars is still available.  Click the "Upload Custom" link in the top navigation bar (just to the right of the Draft Analyzer logo).  You can drag-and-drop your .csv file with custom ADP values.  Let us know how it goes. We will likely need to update some player names to make sure the mapping works for 100% of the players in your .csv file.

Ted
Photo of Justen

Justen

  • 6 Posts
  • 2 Reply Likes
Hi Ted,

I don't see a button under the ADP sources to select my custom ADP.  Can you advise?  Thanks.
Photo of Ted Kasten

Ted Kasten, Founder

  • 3702 Posts
  • 263 Reply Likes
Gotcha.  That option will appear after you upload the custom ADP (assuming the system can read that file properly and there are no hickups).  If you have already followed the steps outlined at the top of this post, email me the .csv and I will test it on my end. ted@draftanalyzer.com.

Thank you Justen.

Ted
Photo of Matthew Anderson

Matthew Anderson

  • 26 Posts
  • 10 Reply Likes
I was playing with a customized ADP file, but the names where in a last name, first name format.  I was getting errors.  Is the system set up for a First Name Last Name format?
Photo of Ted Kasten

Ted Kasten, Founder

  • 3700 Posts
  • 263 Reply Likes
Yes, the software will check any order of names. Send your adp file to me and I will take a look. Usually easy fix. ted@draftanalyzer.com.
Photo of Jay Bellville

Jay Bellville, Employee

  • 2090 Posts
  • 224 Reply Likes
Matt,

If you send the file you are trying to upload over to support@draftanalyzer.com  I can look into why you are receiving errors when trying to import it into the app.  You do have the columns named Name and ADP in your file?  I will double check with you to see about the first and last name matching.

Thanks,
Jay
Photo of Matthew Anderson

Matthew Anderson

  • 26 Posts
  • 10 Reply Likes
Thanks for the quick support, it works like a charm.  Right now I'm using the Mock Draft feature.  Is there a way to have the mock draft use the traditional ADP and then the tool recommend picks based on my customized ADP?  

I'm hoping my customized ADP will provide a good idea when to reach and when not to.
Photo of Jay Bellville

Jay Bellville, Employee

  • 2090 Posts
  • 224 Reply Likes
The custom adp replaces the adp for all aspects of the app so when you import your ADP it should reflect in the mock draft tool
Photo of stephen

stephen

  • 5 Posts
  • 2 Reply Likes
Can I load IDP too?
Photo of Ted Kasten

Ted Kasten, Founder

  • 3703 Posts
  • 263 Reply Likes
Yes. I haven't personally tested IDPs, but it should work. We may have to add/update the player mapping for IDPs. I will check that shortly.
Photo of Ted Kasten

Ted Kasten, Founder

  • 3703 Posts
  • 263 Reply Likes
We just wired up IDPs for the custom import. I need to test it a bit more, so let me know if you run into any problems...we will fix them asap.
Photo of Ryan Mullis

Ryan Mullis

  • 6 Posts
  • 0 Reply Likes
I am trying to import projection .csv files and curious how i should know that this is successful?  It states in the window that it has imported but i don't see any change in the projections.  I have a license through fantasy guru and only see this option or the custom option for projections (which is useless bc i only have fantasy guru and unable to blend any other sources).  Is there a fee associated with using imported .csv files?  Also, since i plan using the more user friendly web page during the draft as opposed to the desktop version, do these imports go away if i reload the page or accidentally close out the browser?
Photo of Jay Bellville

Jay Bellville, Employee

  • 2090 Posts
  • 224 Reply Likes
Ryan,

If you can send over your csv file to support@draftanalyzer.com I can take a look at it for any errors

Thanks,
Jay
Photo of Mat Masters

Mat Masters

  • 1 Post
  • 0 Reply Likes
Hi,

Is there any way to adjust VBD totals in the custom uploaded projections? The default baseline is different from where I want it to be. Please let me know if there's a way to adjust the baseline or to include a VBD number in the uploaded player projection file.


Thanks,

Mat