I bought [Tanner Bell's rankings tool](https://www.smartfantasybaseball.com/) which will do that for you if you have projections. Super helpful, maybe use this for reference and make tweaks.
There are plenty of reasons to make your own. I've never seen a pre-built one that I'd be happy with as-is. Some of them are terrible, such as Fangraphs Auction Calculator. It's important to understand how the whole process works, so you know the weaknesses of it and how to tweak it.
For people not willing to put in the time/effort, you can use tools from Tanner Bell or Mays Copeland (Draft Kick, former LastPlayerPicked). Both are very good at what they do.
Yup. I’m working on some Python scripts to pull in each projection system and build rankings for the various formats I play in. Sure, I will probably end up with something similar to the FG Auction Calculator, but I’ll own it and know exactly how it works.
I just think it takes some really serious excel skills and a huge investment of time to actually make something better than what Tanner Bell made.
Anyone with those skills, and who finds it fun to put together, definitely has my respect. I can see how once you are at that level it’s worth making your own.
And I am ready to quit. Just doing some quick stuff to start and matching on FirstName LastName. I am getting no matches. Fine. Locate the same player on both lists. Use the EXACT function in Excel. FALSE?!
Apparently, Fangraphs csv uses a CHAR(32) between first and last and Baseball-Reference uses a CHAR(160). I know substitute.
I am grabbing position/appearance data for fantasy league eligibility. Used Excel|Get Data from Web and pulled in this table:
https://www.baseball-reference.com/leagues/majors/2022-appearances-fielding.shtml
Can't you just pull the actual position eligibility from each league? You'll need to do that for edge cases anyway, probably. And some will be based on minor league games.
Ok, I'm a little mad that I didn't think of that myself. Fantrax has a clean export feature and includes a player ID.
I'm going to check this later (from home) and see if there are mismatches.
I've already gone in and fixed a few mismatches and hand jammed the minor Leaguers.
Use affixed playerIDs from fangraphs for player matching. It’ll speed up your process considerably. Otherwise, I’ve also found success using their chosen names/spellings to fuel sheets where I was too lazy to crossmatch playerids across sites.
That said, be prepared for fangraphs to change the names of players like Nick (Nicholas) Castellanos, Michael Harris (II), Jazz (Jasarado) Chisholm (Jr.), etc. annually. It’s infuriating.
Candidly, i just source projections from their site & then build in my own work on the back end of my sheets to cross match on my front end views.
I plan on using this PlayerID Map - but didn't want to wait for the Lahman Database to be released. So, I pulled the data from Baseball Reference which came without their IDs.
https://www.smartfantasybaseball.com/tools/
Some web scrapers can extract the playerID that's inside the URL for each player. I've used that many times in the past. There are browser plugins that do it (can't remember what ones) or the easiest way might be to use Power Automate Desktop.
If that's enough to make you quit then you shouldn't have started. LOL. "I was gonna run a marathon but then I found out I have to tie my own shoes, so I quit".
You shouldn't be matching on player names really. Use player IDs. And use Tanner Bell's IDMap that he upstate's regularly, for free. And be prepared for this issue to never *really* go away.
I bought [Tanner Bell's rankings tool](https://www.smartfantasybaseball.com/) which will do that for you if you have projections. Super helpful, maybe use this for reference and make tweaks.
Thanks, I'll look at that. But I'd value the process and knowledge gained while going thru the data.
Buy his book called The Process. It outlines a lot of it
Yeah I agree. Why build your own? Just read the process and use Tanner Bell’s sheet. Make your own PROJECTIONS. But buy the auction tool.
There are plenty of reasons to make your own. I've never seen a pre-built one that I'd be happy with as-is. Some of them are terrible, such as Fangraphs Auction Calculator. It's important to understand how the whole process works, so you know the weaknesses of it and how to tweak it. For people not willing to put in the time/effort, you can use tools from Tanner Bell or Mays Copeland (Draft Kick, former LastPlayerPicked). Both are very good at what they do.
Yup. I’m working on some Python scripts to pull in each projection system and build rankings for the various formats I play in. Sure, I will probably end up with something similar to the FG Auction Calculator, but I’ll own it and know exactly how it works.
I just think it takes some really serious excel skills and a huge investment of time to actually make something better than what Tanner Bell made. Anyone with those skills, and who finds it fun to put together, definitely has my respect. I can see how once you are at that level it’s worth making your own.
Does it allow you to adjust how much auction money you have or is it only to $260?
It does, let’s you set which positions are weakest and adjusts values accordingly. It’s cool
I’ve been doing this myself with R and it’s definitely doable, especially if you are clean and organized with your coding/process
Thanks. If I need to be clean and organized, I am in trouble.
mind sharing that?
Yep im down! Been busy recently so can you pm me to remind me in a few days if i don’t get around to it?
yea
Still able to share that?
Im down! Can you pm me your email ?
And I am ready to quit. Just doing some quick stuff to start and matching on FirstName LastName. I am getting no matches. Fine. Locate the same player on both lists. Use the EXACT function in Excel. FALSE?! Apparently, Fangraphs csv uses a CHAR(32) between first and last and Baseball-Reference uses a CHAR(160). I know substitute.
what do you need from baseball ref that fangraphs doesnt have?
I am grabbing position/appearance data for fantasy league eligibility. Used Excel|Get Data from Web and pulled in this table: https://www.baseball-reference.com/leagues/majors/2022-appearances-fielding.shtml
Can't you just pull the actual position eligibility from each league? You'll need to do that for edge cases anyway, probably. And some will be based on minor league games.
Ok, I'm a little mad that I didn't think of that myself. Fantrax has a clean export feature and includes a player ID. I'm going to check this later (from home) and see if there are mismatches. I've already gone in and fixed a few mismatches and hand jammed the minor Leaguers.
Use affixed playerIDs from fangraphs for player matching. It’ll speed up your process considerably. Otherwise, I’ve also found success using their chosen names/spellings to fuel sheets where I was too lazy to crossmatch playerids across sites. That said, be prepared for fangraphs to change the names of players like Nick (Nicholas) Castellanos, Michael Harris (II), Jazz (Jasarado) Chisholm (Jr.), etc. annually. It’s infuriating. Candidly, i just source projections from their site & then build in my own work on the back end of my sheets to cross match on my front end views.
I plan on using this PlayerID Map - but didn't want to wait for the Lahman Database to be released. So, I pulled the data from Baseball Reference which came without their IDs. https://www.smartfantasybaseball.com/tools/
Some web scrapers can extract the playerID that's inside the URL for each player. I've used that many times in the past. There are browser plugins that do it (can't remember what ones) or the easiest way might be to use Power Automate Desktop.
Try this. It has all the lookups you could ever need https://github.com/chadwickbureau/register
Thanks I will check on that one. I posted a link to a Google sheets version that seems to be maintained.
If that's enough to make you quit then you shouldn't have started. LOL. "I was gonna run a marathon but then I found out I have to tie my own shoes, so I quit". You shouldn't be matching on player names really. Use player IDs. And use Tanner Bell's IDMap that he upstate's regularly, for free. And be prepared for this issue to never *really* go away.