• thepacificocean


  • smutpeddlers

    The pitching seems a lot cleaner then the batters…… Do you have ability to sort by position? Never used google docs before….. BTW not using your sheets for my lines. Just wondering…

  • thepacificocean

    I have the ability to sort by position, yes. I’m not sure how to enable that for others though. And yes, there is a lot going on there, but I prefer having all pertinent information contained within one sheet as opposed to having to go between sheets for different stats, weather, and what not.

  • smutpeddlers

    Cool….. Yeah no need to sort was just curious…. I’m not a Stat sheet kinda guy…. mainly because Imy not all that excel savvy

  • tonytone1908

    Sheets of Shaolin. Love it. Been looking for an all in one sheet like this. Let’s see if it’s helpful to me tomorrow. When does it update?

  • thepacificocean

    @TONYTONE1908 , it updates every five minutes on it’s own. I’ve already ran early slate, and have just put in the numbers for the PM slate. So those should be updating any minute now. A top down version by my SOLO metric will be available around 5 or 5:30 CST. I like to wait as long as I can for starting LUs to drop.

  • VChair23

    Thanks for sharing. Always enjoy looking at other peoples sheets. Few comments below, hope it’s working for you.

    -Can’t see how your ratings are calculated but I think you should consider changing WRC+7 and Siera L14.
    -For a recent batting performance metric: Maybe consider switching to EV L14 vs Season or L365 avg EV.
    -Pitching Metric: Keep SIERA but push it to L30 and consider a velocity comparison over L14 vs Season average

    Thanks again for sharing.

  • thepacificocean

    Thank @Vchair23 . I especially like the velocity idea, as for SIERRA L30, I did have it L30 but then I felt that was a little too long to get a good read on a pitcher’s recent performance; at the same time I do feel that L14 is too small though. To be honest, it’s not something that I weigh too heavily, but more something I give a glance to and then investigate further if need be, as I feel the other numbers tell enough of the story.

    As for how my rankings are calculated, I run a weighted average of my own projections along with a few other expert projections. I then figure slate average for both projection and FP/$$ and then calculate what each player’s projection and FP/$$ is relative to the slate average for all starters, i.e. if Player X had a projection of 12 FP and the slate average is 9, Player X would receive a 1.33 (12/9) for the projection part of his SOLO value, indicating his projection is 33% higher than the slate average. Similarly, if Player X has a FP/$$ of 4, where the slate average is 3.5, he would receive a 1.14 (4/3.5) for the FP/$$ portion of his SOLO value. These two numbers combined, give him a SOLO value of 2.57. It is by this ranking that I rank all the POSITION players. I find that it’s a pretty good way of being able to see value along with projection is one metric. It certainly keeps me from having to do two different looks ups, and I can see where one players value might outweigh another players projection and vice versa.

    For pitchers, I do the same thing, but it’s weighted more towards their projection as I feel total points is much more important than value when it comes to SP than it is for position players. Not to say that it’s not for POS players.

  • thepacificocean

    I’ve updated the sheets for today (Thursday)

  • wilsonda1

    Thanks Pacific. If i copy a version of the sheet to my own google sheets drive then i can sort. But how do i force updates? Calling google sheets gurus !!!

  • thepacificocean

    It’ll update sooner than the five minutes it says if you refresh it, but updates only really occur when I update the real sheet.

  • JBer89

    Just curious if you run a formula to get the FB/ABG/GB and POW/AVG/FIN. Sometimes my calcs show different numbers when I try to match up with you sheet?

    Great Work BTW!!

  • thepacificocean


    Not quite sure what you are asking about ? If you are asking about whether or not I run a formula for the OPS, in general the answer is no. There is a formula of sorts or rather thresholds determined by GB% and FB% that determines whether the opposing SP is GB, FB, or AVG and that will then determine which OPS for the batter is used. It should also be noted that I’m using a league relative OPS per situation where average is always 100.

    As for the OPS that relates to Power, Finesse, and Average, I had a problem with using strict thresholds in determining the SP type or at least in how that relates to the hitter.The rating (POW, FIN, or AVG) for the SP is determined by K/9 + BB/9 ( Baseball-Reference defined this as “Power pitchers are in the top third of the league in strikeouts plus walks. Finesse are in the bottom third of the league in strikeouts plus walks”). My problem lied in that, for example, Jose Fernandez sits atop of the POW SPs, with a K/9+BB/9 of around 16 and the SP at the lower end of the POW threshold is around 12 or so. Now for the purposes of determining which batter OPS to use, the batter’s POW OPS would be used in both these instances, even though the SP in the latter situation is much closer to an AVG SP, albeit more on the power end of that spectrum, than he is to the apex of the POW spectrum like Fernandez is. The same held true as you moved down the ranks, i.e. there were AVG SPs that were closer to FIN and FIN SPs that were closer to AVG and so forth…

    So what I sought to do, was to quantify the spectrum as it were. So, when an SP moved away from the POW apex and closer to AVG, the batters OPS would be reflective of this and for example, create the OPS from 75% of the batters OPS vs POW and 25% from the batters OPS vs AVG. Similarly, if the SP was in the average zone leaning FIN, it would create the batters OPS using 75% of their OPS vs AVG and 25% of the batters OPS vs FIN. Naturally, these numbers fluctuate based on the pitcher.

  • joeunc

    did not/do not see all the games in the sheet today,,,thx

  • thepacificocean

    @joeunc I only ran it for the FD main slate of games. I usually only do the FD main slate.

  • joeunc

    ok thanks,,I was out early and was researching afternoon and late slate

  • BennyRamirez

    First off, cheers for doing the Lord’s work, man. This is really cool of you.

    But I’ve never actually looked through your sheets because it’s so hard on the eyes. Too many cold pallets or bold fonts, maybe. I don’t know, but I look at it almost every time you post and my head hurts within a minute.

  • JBer89

    Thanks for the reply! The reason I was wondering is because I use more of a K% and BB% since (from what I understand anyway) the matchup is based “in that moment” almost and it doesnt matter how long a pitcher goes but what he does when he is facing that batter. Every little edge helps in fantasy baseball, and I noticed that some hitters fare very well against certain types. I wish it was defined better on BBREF. Thanks again!

  • joeunc

    how about a glossary on what all the columns are,,I know many of them but some of them I am not,,thx

  • thepacificocean


    A Glossary is now available for the hitter’s. I will look to do one for the SPs in the future, but for now much of what is in the batter’s glossary should explain most of what you see in the SP page. Also, I’ve provided some links to fangraph definitions for some of the terms and statistics.


    Please let me know what would make this easier on the eyes for you and I will see what I can do. I’ve already taken note on the excess of bold fonts, so let me know some other general and simple suggestions and I can whip up an easy on the eyes version.

  • joeunc

    thx Benny much appreciated and keep up the good work

  • Codith

    Are these sheets not updating automatically?

  • thepacificocean

    It’s somewhat automatic. I have to input some information for it to do so and some days I don’t play, i.e. yesterday.

  • topspinner

    Thank you for posting, is there anyway to sort the columns highest to lowest?

  • thepacificocean

    I can’t or havent figured out how to make that available in google sheets. That said, the RAMBO rating to the far right is a composite rating of most the pertinent stats. Additionally, one could always hunt for dark green.

  • thepacificocean

    Updating for AUG 6.

  • X Unread Thread
  • X Thread with New Replies*
  • *Jumps to your first unread reply

Subforum Index is the home of the daily fantasy sports community. Our content, rankings, member blogs, promotions and forum discussion all cater to the players that like to create a new fantasy team every day of the week.

If you or someone you know has a gambling problem, crisis counseling and referral services can be accessed by calling 1-800-GAMBLER (1-800-426-2537) (IL). Gambling problem? Call 1-800-GAMBLER (NJ/WV/PA/MI), 1-800-9-WITH-IT (IN), 1-800-522-4700 (CO), 1-800-BETS OFF (IA), 1-888-532-3500 (VA) or call/text TN REDLINE 1-800-889-9789 (TN).