Fantasy baseball 2023 Customizable leaderboard and projection tool

This 2023 fantasy baseball kit has a lot of sleepers, tips, ratings, and more, but none of them can fit your league. Exactly. You now have the tool that can take your “2.75 points to save” and put your personalized ratings into proper context.

  • Dom Luszczyszyn is the brains behind the Fantasy Hockey Cheat Sheet and works with Jake every year to create this cheat sheet that allows you to enter your league settings, change your projections and basically draft with an improved list of ratings Fully customized for your league.
  • We try to improve and adapt it every year, but there might still be some small bugs. Your feedback is essential to get this perfect result. So please let us know if you have any problems.
  • NB: We are still trying to find a solution/method to allow CI, MI, DH/UTIL, Joint Eligibility, P and Multifunction. It’s hard work with VORP accounts and more, but we try; We promise!

How to use this fantasy baseball cheat sheet – read on

Step 1: Enable editing

You only need to do this the first time you open a new download.

Step 2: Registry settings

The bottom leftmost tab is Settings. If you are in a points league, enter the points values ​​in the cells next to the corresponding category. So if your league gives you 10 points for a win, put the 10 in the cell to the right of the “W”:

You also need to drop all ‘1s’ in ‘Category’ in the Hit and Promote categories, as this relates to Roto leagues.

For Roto championships, omit the point values ​​and put a “1” in the categories you score. So an OBP rated Roto League 5 x 5 instead of Average would look like this:

Now go to the right of this page and enter your squad tally (10/12/15 any) – the ‘Players picked before substitution’ numbers will turn yellow. Here’s something for more advanced spreadsheets. If you want to give a specific position more oomph, change “Replace selected players above” to that position and the sheet will adapt. Higher number = This position becomes more valuable. Lower number = importance has been reduced. It’s currently optimized for Jake’s ratings, but your tastes may differ.

Finally – and this is very important – Enter your “Format”. (points O categories).

Then go to the “Arrangement” tab.


Step 3: Sort tab

The easiest way to do this is to sort by rank. Hit the little triangle, sort by “ascending” and it will sort automatically for you. If you want to dig deeper, you can also sort by VORP, in which case you want to go Descending and you may have to double-click to activate it.

We realize it sounds simple, but it takes into account months of projections, some very serious spreadsheet calculations, standard deviation, substitution-level operators, and much more.


Step 4: Miscellaneous and Fixes

1. You can do a lot with this tool. If you don’t like the predictions, you can change them. For example, we went to the “Hitters” tab and knocked out Pete Alonso from 39:

Up to 22 home games:

When you go back to the Ranking tab, you can see it’s dropped from 80 to 136:

*** IMPORTANT: CHANGE ONLY THE DESCRIPTIONS IN THE “HITTERS” OR “JUGS” TAB **** They won’t take it anywhere else.

2. League players can also score points Some marginal categories are missing, such as CG, SHO and CYC. We cannot predict who will bat on the field. And blocks and full games are such a rarity that we leave it up to you to dedicate one or two a year to shooters and manually increase their value.

3. “Visits” = Single / 1 pointSo, they are the same thing. Doubles, triples, and home runs are worth 2, 3, and 4 runs, so the “hit” is already included for these runs.

4. If you play AL or NL league only-Just tap the triangle under “League” in the leaderboard tab and check the corresponding league. If you want to include crop free agent, make sure you have activated FA.

5. ADP is intentionally empty. That’s there if you want to compile it, depends on the draft time. Unfortunately, with frequent (sometimes daily) changes and depending on your site (NFBC, Yahoo, etc.), there is no way to get an automated ADP.

6. Save + bookings It works for me if I use 1 point to save and 0.75 to keep.

7. If you have odd number of teamsall items will turn yellow in decimal like this (causing the Labels tab to populate with “N/A”):

…go to the yellow squares and round to integers and everything will be back to normal:


Step 5: My team

There is a My Squad tab that will allow you to hit your squad (or coaching squad) and see the expected totals. This is especially important if you are doing a simulation (or simulating solitaire) and want to know if your team will compete for a title in Roto, as you can look at past totals and see where you would finish in the standings. the player’s name (or type it, but type it correctly). !) from the Leaderboards tab and paste it into the My Squad site.


Special “steps”.

guards ✔

  • You have to eliminate the player from four tabs: Center, Hitters (or Pitchers), Std Dev and Ranking. Also, this will distort your VORP a bit, which you may/may not want.

Single Leagues (AL or NL only)

  • In the Standings tab, there is a column to sort by AL or NL for league only. Just choose what you like and voila!

Shuhei Ohtani

  • Yes, there is a special rule for Ohtani (Shohei Ohtani – H is DH, Shohei Ohtani is pitcher, and he is not a common player for both).

Add categories, etc.

Our columns/categories/stats/fields will all be there. Between my predictions and the creation of Dom’s cheat sheet, we are limited in what we have the ability to do. But! To combine all jugs or generate a CI or MI list, this is from Dom:

  • Go to SP
  • Find someone with VORP = 0
  • See how many points it has
  • Find a relief pitcher with these total points
  • Enter its rank in the settings
  • Do the same with 1B/3B and 2B/SS

Well! Are you ready to try the tool?! (updated 2/20)

(Foto di Daniel Cherry/MLB Images via Getty Images)

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *