Yet another Spreadsheet

[ubernoob]

Just gonna drop this here.

Feel free to use it or not, fill out the info in boxes that don't have a dash it's pretty self-explanatory. Thanks to everyone here for all their work on spreadsheets and formulas (DonkeyKongSr and ASURay come to mind) and also a couple reddit users.

Formulas are listed, it's what I could find as the most current. It'll color code and rank itself.

https://drive.google.com/open?id=1Ih...yXTcxU3BhmL7PT

I'll edit this post too because my brain doesn't work properly:

I hadn't used excel for a long time, and frankensteined this dumb thing together. If you find any mistakes (very likely) or have any requests/tips/etc - feel free to ask. This sheet is mainly for myself that I am sharing so do what you will with it, request anything you want... just know that requests might not get put in for one of a couple reasons:

1) I'm too dumb to do it.
2) I wouldn't use it/don't see the need for it on my sheet.

[Jeff1787]

Thank you very much!! I couldn't figure out how to fill in pitchers!!

[ubernoob]

Originally Posted by Jeff1787

Thanks you very much!! I couldn't figure out how to fill in pitchers!!

No worries, I just did the batters tab last night. Pitching isn't filled out yet (slowing doing it throughout the day/night as I get free time) and I'm trying to figure out if there is more than the FIP formula right now to add for that. So far that's the best I have found.

[QuantaCondor]

I'm still not convinced that the editor projections bear out correctly for PT performance. Editor is based on offline engine/game world, which won't necessarily act the same way as PL. But these are a great way to understand what breakpoint values are important, and are definitely better than going by feel.

[ubernoob]

Originally Posted by QuantaCondor

I'm still not convinced that the editor projections bear out correctly for PT performance. Editor is based on offline engine/game world, which won't necessarily act the same way as PL. But these are a great way to understand what breakpoint values are important, and are definitely better than going by feel.

Yeah, this isn't meant to be a "Plug in your players and figure out what they will produce."

The engine *should* be the same (save for tournaments that take place in other years, in which case I'm sure we have the info on those years and could work out formulas) as offline, you just end up facing such a wide variety of cards (and much better cards in general.)

I tucked the numbers projections at the end because I feel that's not what's important to see, but I don't want to fully hide them. It's more a player comparison tool and (once you get more data points entered) can be helpful in finding players that you may have missed on first glance. Far too many variables to keep track of for raw projections to be that accurate. Crazy park factors, inflated values, etc.

[QuantaCondor]

Originally Posted by ubernoob

Yeah, this isn't meant to be a "Plug in your players and figure out what they will produce."

The engine *should* be the same (save for tournaments that take place in other years, in which case I'm sure we have the info on those years and could work out formulas) as offline, you just end up facing such a wide variety of cards (and much better cards in general.)

I tucked the numbers projections at the end because I feel that's not what's important to see, but I don't want to fully hide them. It's more a player comparison tool and (once you get more data points entered) can be helpful in finding players that you may have missed on first glance. Far too many variables to keep track of for raw projections to be that accurate. Crazy park factors, inflated values, etc.

Not just that the players will be better or more varied, but their stat distributions will be potentially different than what we'd see in 2010 data or whatever era they use to normalize PT. You might see more stuff or more HR power in the average PT player, but maybe a similar amount of EYE or a lesser amount of GAP; something that would change the relative importance of each of these stat calculations, not just add an overall scale factor to their production. For that, you really need actual league data.

That doesn't mean these are unusable, just they they're a (pretty decent) starting point. And here it's been put into a really great format so the results are easy to parse.

[Jeff1787]

Originally Posted by ubernoob

No worries, I just did the batters tab last night. Pitching isn't filled out yet (slowing doing it throughout the day/night as I get free time) and I'm trying to figure out if there is more than the FIP formula right now to add for that. So far that's the best I have found.

The FIP formula that you are using was used in both OOTP19 and OOTP20 I think.

[ubernoob]

Link in the OP updated, both pitcher sheets ready to be filled out.

Again I pre-populated it with a couple different cards to show how the sheet sorts and what it looks like if you ignore ratings fields.

https://drive.google.com/open?id=1Ih...yXTcxU3BhmL7PT

[Charlatan]

This is a great spreadsheet. I downloaded a copy this morning and have been fiddling with it a bit. Thank you for all the work you put into it.

I will probably adapt to using this for my analysis (I'm going to move some of the columns around so I can see the "bottom line" evaluations easily on one screen. But this is an awesome tool.