GiantsFan14's 2nd Annual Spreadsheet v9 (w/ Draft Tracker!)

[Lickitysplit131]

Hey man..I just sent you a donation from JManeri131@aol.com

Can you send the spreadsheet to the e-mail:

JManeri131@gmail.com

[AHF]

I was playing around with the spreadsheet and noticed that the names are all hyperlinks and not text. Is there a way to search for a given player akin to the Cntrl-F search function? Alternatively, is there a way to convert the text that appears with the hyperlink into actual text so it is searchable?

I am just picturing myself in the draft trying to find a player that has been nominated and not having anyway better than sorting by position and then trying to find them while the bids are being called. It is more likely I am overlooking an obvious solution.

Thanks!

[GiantsFan14]

Hey man..I just sent you a donation from JManeri131@aol.com

Can you send the spreadsheet to the e-mail:

JManeri131@gmail.com

Sent. Thanks!

[GiantsFan14]

I was playing around with the spreadsheet and noticed that the names are all hyperlinks and not text. Is there a way to search for a given player akin to the Cntrl-F search function? Alternatively, is there a way to convert the text that appears with the hyperlink into actual text so it is searchable?

I am just picturing myself in the draft trying to find a player that has been nominated and not having anyway better than sorting by position and then trying to find them while the bids are being called. It is more likely I am overlooking an obvious solution.

Thanks!

I've actually realized that problem as well and have been trying to figure out a solution. So far the best I can come up with is to create another column with the players name. If anyone knows of an other way to do this I'd love to hear it.

[AHF]

I've actually realized that problem as well and have been trying to figure out a solution. So far the best I can come up with is to create another column with the players name. If anyone knows of an other way to do this I'd love to hear it.

The easiest way I have found to do that is to cut and paste the names into another forum (like this response itself, actually) and then cut and paste that from the other forum (in this case, this post) back into the spreadsheet in a new column. I am sure there are more elegant solutions.

[GiantsFan14]

I've actually realized that problem as well and have been trying to figure out a solution. So far the best I can come up with is to create another column with the players name. If anyone knows of an other way to do this I'd love to hear it.

The easiest way I have found to do that is to cut and paste the names into another forum (like this response itself, actually) and then cut and paste that from the other forum (in this case, this post) back into the spreadsheet in a new column. I am sure there are more elegant solutions.

I can do that and just do it for the overall rankings so that it doesn't clutter up all the other pages.

[GiantsFan14]

Just sent out an e-mail with version 6. If you didn't get it, please let me know so I can make sure I have the correct e-mail address on my list.

[GiantsFan14]

Version 7 coming out. Updated a bunch of projections. Added some notes. Tweaked auction values some to reduce the value of positional scarcity.

I would like to do an overvalued/undervalued sheet comparing my rankings to Yahoo/ESPN/CBS but I can't find a good way to get a hold of their rankings. If anyone knows of a way to get those rankings in spreadsheet form I'd really appreciate it.

-Mike

[grizfan]

Just sent a donation. Please send.
Thanks!

[pitching51]

I've actually realized that problem as well and have been trying to figure out a solution. So far the best I can come up with is to create another column with the players name. If anyone knows of an other way to do this I'd love to hear it.

The easiest way I have found to do that is to cut and paste the names into another forum (like this response itself, actually) and then cut and paste that from the other forum (in this case, this post) back into the spreadsheet in a new column. I am sure there are more elegant solutions.

I can do that and just do it for the overall rankings so that it doesn't clutter up all the other pages.

Copy all of the names then click paste special and only choose "Values"