Started By
Message

Are there any resources that have blank/blind excel sheets with players listed?

Posted on 7/19/17 at 5:17 pm
Posted by SlowFlowPro
Simple Solutions to Complex Probs
Member since Jan 2004
421188 posts
Posted on 7/19/17 at 5:17 pm
so like some sort of excel (or hell, even word) database of payers, positions, teams, etc

i really don't feel like hand-entering 300 players into a new document to group players
Posted by CJD4LSU
Ray-Vegas, La
Member since Sep 2006
3504 posts
Posted on 7/19/17 at 5:24 pm to
Go to a sites adp rankings, copy and paste those players into an excel spreadsheet and then you can set your spreadsheet up how you want it.

You don't have to key 300 names in by hand.

ETA: Use the text to column feature under the data tab and you can set the delimitation accordingly.
This post was edited on 7/19/17 at 5:25 pm
Posted by reddman
Member since Jul 2005
78186 posts
Posted on 7/19/17 at 6:00 pm to
This is some amateur hour shite, bro.
Posted by DeathValley85
Member since May 2011
17106 posts
Posted on 7/19/17 at 6:07 pm to
Man if you use Google there will be like 50 pages of exactly what you want.
Posted by MrPappagiorgio
Prairieville
Member since Jan 2009
41122 posts
Posted on 7/19/17 at 6:42 pm to
Slo, I have something like this on my hard drive at work

I'll shoot it to you tomorrow if you'd like

Sortable by player, team and pos
Posted by Peazey
Metry
Member since Apr 2012
25418 posts
Posted on 7/19/17 at 7:35 pm to
I was thinking that you could just copy and paste some stuff off of the internet into excel, but I thought that maybe sounded too easy.
Posted by OweO
Plaquemine, La
Member since Sep 2009
113873 posts
Posted on 7/19/17 at 9:14 pm to
SFP, I use to pay for Draftsharks, they allow you to download their list to an excel sheet.

But what I do now is just copy and paste each team's depth chart into an excel sheet.

Also, there is an app called NFL Fantasy Football Cheat Sheet & Draft Kit. IMO it is the best tool to go into a draft with. If you play in multiple leagues, you can set it up for each league, and it generates rankings by the rules of each respective league. When someone is drafted, you can take them off the board, you can either keep up with what teams are drafting what, including yours are just keep up with your roster.

You can sort players in different ways, I think you can look at teams current depth charts, it ranks rookies, etc. I play in 3 money leagues, two are auction leagues obviously done in person and I play in a 7 player keeper league in which we draft online. Each person gets like 12 hrs to pick their player, but everyone drafts in a reasonable time. The only thing I bring to the drafts is my ipad. There are people in the leagues I play in, who still buys magazines.

We have been playing in one of the leagues for 19 years. One of the leagues is 4 years old and the other one is 10 years old. I have three super bowls, several super bowl appearances, have won my divisions multiple times, have been scoring champ maybe 3 or 4 times.

When I stopped putting too much thought in it and simplified how I prepared, I actually started doing better. This is what I do.
- Keep up with player ranking, just to see the trends.
- Keep up with injuries (suspensions, etc)
- And never make a decision based on what you see in a preseason game.

Depth charts tell you what you need to know.
Posted by SlowFlowPro
Simple Solutions to Complex Probs
Member since Jan 2004
421188 posts
Posted on 7/19/17 at 11:48 pm to
quote:

This is some amateur hour shite, bro.



literally never done any research before the draft

and i have a TDFL title recently. do you?
Posted by SlowFlowPro
Simple Solutions to Complex Probs
Member since Jan 2004
421188 posts
Posted on 7/19/17 at 11:50 pm to
quote:

When I stopped putting too much thought in it and simplified how I prepared, I actually started doing better

yeah i just want a sheet with groups and some other info for a live auction draft i do (with keepers and IDP)

typically i just print off the ESPN 300 but i am trying to have it a little more organized this year
Posted by rondo
Worst. Poster. Evar.
Member since Jan 2004
77403 posts
Posted on 7/20/17 at 8:33 am to
quote:

and i have a TDFL title recently. do you?



Posted by jojothetireguy
Live out in Coconut Grove
Member since Jan 2009
10484 posts
Posted on 7/20/17 at 2:18 pm to
i have my tiered sheet in excel. All you have to do is cut and paste.
Posted by Vicks Kennel Club
29-24 #BlewDat
Member since Dec 2010
31060 posts
Posted on 7/20/17 at 2:20 pm to
Redd is calling amateur hour cause literally all you need to do is go to the ESPN top 300 and copy and paste.

With some very simple formatting (or clearing their formatting), you will have a spreadsheet that is sortable by rank, position, adp, etc.
Posted by SlowFlowPro
Simple Solutions to Complex Probs
Member since Jan 2004
421188 posts
Posted on 7/20/17 at 3:05 pm to
i know even less about excel than i do about preparing for FFB, just for the record
Posted by Peazey
Metry
Member since Apr 2012
25418 posts
Posted on 7/20/17 at 3:14 pm to
Ctrl+c and ctrl+v is literally probably all you need to do. Depending on the formating there might be a little more, but I doubt it.
Posted by Vicks Kennel Club
29-24 #BlewDat
Member since Dec 2010
31060 posts
Posted on 7/20/17 at 4:05 pm to
I think you would really like and appreciate having a beginner's level of knowledge in Excel. Sortable and filtered data >>>

One of us can do it for you literally in two minutes if needed.
Posted by SlowFlowPro
Simple Solutions to Complex Probs
Member since Jan 2004
421188 posts
Posted on 7/20/17 at 5:09 pm to
i know how to copy and paste but i didn't realize excel could handle and sort the data that easily. that's all
Posted by Jizzamo311
Member since Dec 2008
6341 posts
Posted on 7/20/17 at 8:56 pm to
JoJo's is the shite
Posted by OneMoreTime
Florida Gulf Coast Fan
Member since Dec 2008
61834 posts
Posted on 7/20/17 at 9:00 pm to
quote:

i know how to copy and paste but i didn't realize excel could handle and sort the data that easily. that's all

bruh
Posted by CJD4LSU
Ray-Vegas, La
Member since Sep 2006
3504 posts
Posted on 7/21/17 at 6:32 am to
quote:

i have my tiered sheet in excel. All you have to do is cut and paste.


Have you shared that with the board yet? I wait for it every year. Solid work year in and year out.
Posted by jojothetireguy
Live out in Coconut Grove
Member since Jan 2009
10484 posts
Posted on 7/21/17 at 9:30 am to
I've just finished the bye weeks, but I still have to go through the rankings. A lot of sites are all over the place with rankings and some I just don't see how they are ranking certain guys. I'll have it up soon.
first pageprev pagePage 1 of 2Next pagelast page

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on Twitter, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookTwitterInstagram