1

Link: https://docs.google.com/spreadsheets/d/1KcYqRRqxZ3GWNAIUWgg9AGraTAzkrVxkDrk4ZsI5axY/edit?usp=sharing

So I do sports spreadsheets for fantasy sports. I’m filling out my baseball spreadsheet right now and I'm planning on doing this for football too if it works. A couple weeks ago I learned that you can make the spreadsheet calculate the number in a cell based on the numbers in other cells by making a formula. This helps shave off a lot of my workload.

Right now I’m trying to get it to calculate fantasy points.

A pitcher gets:

  • 5 points for a Win
  • 5 points for a Save
  • -0.5 points for an earned run
  • 1 point for an inning pitched
  • 2 points for a strikeout

—————

  • Wins are in the M column
  • Saves are in the N column
  • Earned runs are in the O column
  • Innings pitched is in the L column
  • Strikeouts are in the P column

So my formula is:

=M3*5+N3*5+O3*-0.5+L3*1+P3*2

Some of them are right on the money. I’ve put in eight of them. 3 are exactly correct. 4 of them, the decimal is wrong, 1 of them is off by a whole ten points. I don’t know what I’m doing wrong.

4
  • Welcome. The likelihood is that there is an issue with the order of precedence. Please provide an actual example where the results difference from the expected results.
    – Tedinoz
    Oct 19, 2019 at 14:41
  • I can’t imagine that the order they’re in is the problem because it’s just addition. The worst of them is Verlander. Yahoo says he got 896 fantasy points this year, but the spreadsheet says he got 906. Like I said before, the other ones are just off by their decimals.
    – Lizzie C
    Oct 19, 2019 at 15:20
  • Did you try to do the calculation by hand to double check the results ? Anyhow we need you to provide us more data in order to help you.like a public sheet
    – pjmg
    Oct 19, 2019 at 19:44
  • Alright I made a public version and posted the link docs.google.com/spreadsheets/d/…
    – Lizzie C
    Oct 19, 2019 at 20:17

1 Answer 1

0

Check the Verlander data That is the only one in your example that doesn't calculate the expected value.

The other discrepancy is that you have misunderstood partial innings. X.1 means x & 1/3 innings not x & 1/10 innings. All except Verlander will be correct when you make that adjustment.

3
  • Yep that’s it! Thank you!!!
    – Lizzie C
    Oct 19, 2019 at 22:26
  • I’m an idiot. Verlander pitched 223 innings not 233. It was a typo haha
    – Lizzie C
    Oct 19, 2019 at 22:35
  • And an Aussie who knows nothing about Baseball, learns something new about decimals ;-)
    – Tedinoz
    Oct 19, 2019 at 22:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.