I’m going to make this post short and sweet. Even though I said I wasn’t going to update my spreadsheet, I’ve changed my mind. Why, you ask? The answer is mostly simple. In fact it’s one word. Razzball Nation. Ok perhaps that was two words, but who’s counting. I’ve got two more words, Grey and Rudy. Those two SOBs have busted their nuts (did I mean tails) over the last many, many years delivering first class content to the fantasy baseball community. This is my sixth season being part of the Razzball Crew and I just wanted to do my part. And my part is very simple. While I do write a weekly post on points leagues, what everyone wants is my spreadsheet. This one’s for you Razzballers!
Sorry for the short post. Hit me up in the comments with questions.
malamoney’s Updated 2020 Fantasy Baseball Points Spreadsheet
Follow malamoney on Twitter at @malamoney
First time user of your Points Spreadsheet. Can you provide a little help on how to best use the Rankings tab? I have all my league info entered. I figured out “1” and “2” for “Drafted”. But I’m curious how to use “Rank”, “FVARz”, and “Draft Score”. Thanks!
Take a look at my previous posts about the spreadsheet.
https://razzball.com/points-league-which-way-does-the-alligator-mouth-face/
https://razzball.com/points-leagues-start-spreading-the-sheets-im-sharing-today/
My fucking man! Thanks
Anything for my boy Frank Thomas!
Hey Malamony, hope you see this. Im trying to use your spreadsheek for points leagues–ive used it before but i have a new computer–now when i go to settings i can change the numbers on the spreadsheet to customize scoring. Help me please!
Are you saying you cannot change the numbers? Are you using Excel? Which numbers are you trying to change? What errors are you getting?
Ok i changed computers and was able to change the numbers to my leagues points scheme. I used custom scoring 1.
I changed the numbers to fit but i dont see where i can “calculate rankings”
There is a grey box saying “no changes detected”
Grey has his own box in the spreadsheet?
You dont know how i can get it to calculate my rankings?
Thanks so much for doing this. I’ve been using it for a few years now. What is your position eligibility formula set at? Is there a way to adjust the position eligibility requirements?
Sure thing. I guess you could copy and paste a player’s row from another position tab into the position you want him. But otherwise it’s not a supported feature in this version.
What a great day! thank you so much for putting this together in a very difficult year.
Also, not sure if I am doing it wrong but when I added keepers for all of our teams, I did it in the positions tab but the draft status is not transferring to the rankings tab. Is there something special I need to do?
thanks again, this is such a huge help.
You mark off keepers on the “Rankings” tab by marking them as drafted. Put a 1 if they are on someone else’s team and a 2 if they are on your team.
I would suggest you download a fresh copy and start over if you’ve updated fields on other tabs.
Take a look at my previous posts about the spreadsheet.
https://razzball.com/points-league-which-way-does-the-alligator-mouth-face/
https://razzball.com/points-leagues-start-spreading-the-sheets-im-sharing-today/
Thank you, will do it.
Whats up man? I really need some help with your spreadsheet. I have a draft in a few days. Ive changed the custom settings to fit my league scoring, but there is nothing that says “calculate rankings” so the rankings never change to fit my league.
The box says “no changes detected”
Please help me. Thanks.
Here’s my suggestion. Download a fresh copy and read these previous posts on how to use the spreadsheet.
https://razzball.com/points-league-which-way-does-the-alligator-mouth-face/
https://razzball.com/points-leagues-start-spreading-the-sheets-im-sharing-today/
Are you using Excel? Are you getting any specific errors? Did you enable macros when you opened it?
Ive read your posts trying to figure whats wrong a hundred times. I dont know if im using excel. All i know is that i can input my info but i cant calculate the rankings.
There is a box that says “no changes detected”
And a quote from you about wisdom. Do you know what box/square i mean?
Malamony, any other advice? Im using excel, im inputting my custom league scoring system but there is nothing that says ” calculate rankings”
Please help
Can you send me a screenshot of your “Settings” tab?
What is you email?
Can you post it here?
Cant figure out how to post a screen, Don’t think you can.
Here is a copy past of our league settings.
Scoring
Batting
Runs Scored (R) 1.5
Singles (1B) 1.5
Doubles (2B) 3
Triples (3B) 4.5
Home Runs (HR) 6
Runs Batted In (RBI) 1.5
Walks (BB) 1
Intentional Walks (IBB) 1
Strikeouts (K) -1
Hit by Pitch (HBP) 1
Sacrifices (SAC) 0.5
Stolen Bases (SB) 2
Caught Stealing (CS) -1
Ground into Double Plays (GIDP) -1
Hitting for the Cycle (CYC) 20
Grand Slam Home Runs (GSHR) 3
Pitching
Innings Pitched (IP) 1.5
Earned Runs (ER) -1.5
Walks Issued (BB) -1
Hit Batsmen (HB) -1
Strikeouts (K) 1.5
Balks (B) -1
Quality Starts (QS) 7.5
Complete Games (CG) 7.5
Shutouts (SO) 5
No Hitters (NH) 20
Perfect Games (PG) 23
Wins (W) 5
Losses (L) -2.5
Saves (SV) 10
Blown Saves (BS) -5
Holds (HD) 5
The comment box doesnt have any option where i can put in a picture.
My email is [email protected]
Email sent
Love you for this. How big of an impact does the Corona Sucks factor have?
You can ignore that. It was added for the version I did back in March. Forgot to remove it.
Just wanted to thank you again for this – I look forward to your sheet and posts every season.
Definitely tough getting into it this year, hopefully my meh disappears when we get some games.
You’re welcome. Hope it helps…
Mala! Gotta love some preseason trade talk.
Got offered Gerrit Cole and Eddie Rosario for Aaron Nola, Kris Bryant, and Kyle Lewis.
14 team H2H points, scoring:
1 point for 1B, BB, HBP, R, RBI, SB
2 points for a 2B
3 for 3B
5 for HR
10 for GSHR
NO MINUS
Pitchers:
1 K
0.25 INN
10 W
-5 L
5 CG
10 shutout
7 save
Whatcha think?
Probably as Cole is the best player in the league based on your scoring system. What are your keeper rules?
Redraft league, no keepers
I’d take the Cole side.