OOTP Spreadsheets

[freerufdog]

I was looking into building a spreadsheet for draft rankings and other aspects of my dynasty to improve performance. I was wondering if anyone had built some on their own that that they would be willing to share to help me get started. It would be greatly appreciated!

[joefromchicago]

Check out this thread. It's old, but I'm sure it still has some useful links.

[Hoolix]

I have a spreadsheet that I use....I haven't updated it for this year yet though. Haven't added in the BABIP ranking info. I'm sure there are some other things that have been updated on my spreadsheets yet.

[NoOne]

Build it in a re-useable way so you don't repeat needless work.

Link to the exported file, that way it can update each time you open it.. new exported file = updated spreadsheet.

This dumps the raw comma delimited data into it's own worksheet... never touch it. You create the first row of the table youw ant to see using cell references, then use the 'fill' function to auto-increment all those cell references to create the table.

done in a matter of seconds.if just making a simple table and sorting by overall or whatever. Can even make little sort buttons at top of each table column.

I have something like this for honing LTM using 100 years or more of deta. i turn on the autoexport options and it spits out the necessary csv files while it simulates. can spot check as it runs. just drop the files into the directory where i keep the data files for the spreasheet, open it up, asks to 'update links to files' and bob's your uncle. Entire thing is updated or new lines are added or whatever changed etc.

some things may require you to make the first 2 rows - having sub leagues means each year of stats is 2 rows. the 'fill' function merely repeats a pattern, so you need to make the first iteration of the pattern only.

[NoOne]

.

[Hoolix]

Here are few screenshots from different spreadsheets that I have. I have a few more other than these.

The first image is my organizational depth chart. Below that is my end of year stat analysis spreadsheet. On the right is my draft board from last season. When pulling this info I noticed on my Org Depth Chart that I must have H/9 instead of HR/9 as those numbers are out of whack.

I also have to do more tweaking with how my draft board evaluates relievers as I think it's making them more valuable compared to SP than it should.

[nebben]

These are great, Hoolix. Are you comfortable/able to share them?

[Hoolix]

Testing to see if this works.Depth Chart

[Hoolix]

Draft Class Ranking


MLB Stats

Team Almanac


I have a couple more, but I've got to head to bed. Will get the others on here tomorrow.

[nebben]

Those work. Thanks so much for sharing! I'm always looking to geek out more on OOTP.

[Hoolix]

Originally Posted by nebben

Those work. Thanks so much for sharing! I'm always looking to geek out more on OOTP.

No Problem. If you make any changes that you feel are an improvement let me know. I'm always wanting to add things and sometimes I miss the little things.

[NoOne]

These are just tables you could make in a word processor. Looks like you typed all that info in by hand? You can avoid that.

insert sheet from file - the csv. This should be it's own worksheet and nothing else in it. Use the "link" or "data link" option. this way each time you open your spreadhseet it'll update all the data if you update the csv file / replace it with a new one.

The table you want to create should be its own worksheet, too.

Do your table headers and formatting the way you want it... use borders etc.. but you only fill out the first row of the table data by hand using references to the first row of the "data-from-file" worksheet. The fill will also keep all your formatting... zero work after typing in headers, first row of table and any formatting

Same goes for any math applied to that data.. formulas and cell references only. Make use of "!" if you need to lock row, column or both. Stock convrsion factors or constants can be typed in but better to reference a cell.. can more easily 'fix' the table that way if it needs to be changed. edit 1 cell, and it's fixed.

When you use the fill function to complete the table, it will auto-increment cell references where no "!" is used.

You should never have to fill out that table again... everything will auto-update each time you open or tell the program to update links. (depending on default settings, it may be one or the other, initially, but whatever you prefer it to be can be the case going forward).

you should never have to type in data... that should be automatic. It's worth the effort to do this. each time you hand type in all that info, think about it.


you can add sorting optiosn and such to various columns using macro editor. This makes it a bit sketchy when you share it, though.. macros can be malicious but if you are the creator, no worries.. doesn't happen on accident, obviously.

settings of the spreadhseet program you use may be different defaults. if anything i said doesn't play out properly, it's a setting regarding updating links or autoupdating spreadsheet in real time vs when you press a shortcut key to recalculate everything given new data entered etc....

The effort to use these sheets should simply be opening them up then clicking a button to update... you should never have to hand-type anything into a spreadsheet. once it is created it should do it all on its own or by simple 1-step command.

[Hoolix]

Originally Posted by NoOne

These are just tables you could make in a word processor. Looks like you typed all that info in by hand? You can avoid that.

insert sheet from file - the csv. This should be it's own worksheet and nothing else in it. Use the "link" or "data link" option. this way each time you open your spreadhseet it'll update all the data if you update the csv file / replace it with a new one.

The table you want to create should be its own worksheet, too.

Do your table headers and formatting the way you want it... use borders etc.. but you only fill out the first row of the table data by hand using references to the first row of the "data-from-file" worksheet. The fill will also keep all your formatting... zero work after typing in headers, first row of table and any formatting

Same goes for any math applied to that data.. formulas and cell references only. Make use of "!" if you need to lock row, column or both. Stock convrsion factors or constants can be typed in but better to reference a cell.. can more easily 'fix' the table that way if it needs to be changed. edit 1 cell, and it's fixed.

When you use the fill function to complete the table, it will auto-increment cell references where no "!" is used.

You should never have to fill out that table again... everything will auto-update each time you open or tell the program to update links. (depending on default settings, it may be one or the other, initially, but whatever you prefer it to be can be the case going forward).

you should never have to type in data... that should be automatic. It's worth the effort to do this. each time you hand type in all that info, think about it.


you can add sorting optiosn and such to various columns using macro editor. This makes it a bit sketchy when you share it, though.. macros can be malicious but if you are the creator, no worries.. doesn't happen on accident, obviously.

settings of the spreadhseet program you use may be different defaults. if anything i said doesn't play out properly, it's a setting regarding updating links or autoupdating spreadsheet in real time vs when you press a shortcut key to recalculate everything given new data entered etc....

The effort to use these sheets should simply be opening them up then clicking a button to update... you should never have to hand-type anything into a spreadsheet. once it is created it should do it all on its own or by simple 1-step command.

I don't hand type the data in (other than changing part of the formula in the first column if I decide I want something different). Copy/paste the data and it updates automatically. I've had these spreadsheets since 2020.

I will look into the auto updating, but the copy and past is pretty quick work. I use Google Sheets.

[Yanksrock02]

I use a trade calculator I found that is awesome, but does anyone have something similar for evaluating contract values in free agency?

[Guthrien]

The user squirrel has created a Projection System called pistachio. It's pretty excellent and there's a fair amount of statistical study of OOTP that's gone into it, including some of the work of the old Projection Calculator that was popular here (web page). If nothing else, it taught me a lot about how the game values certain ratings translated to runs earned / runs saved.

Long story short, it's python code, but if that sounds intimidating he has made some beginner friendly videos of how to use it, and it runs off of simple exports from the game. You can do it all free with a little self-teaching (I needed to). I don't find it's WAR evaluations super accurate, but wOBA and others are there. The MAIN point is, it lets you compare players value, a lot of them, or a little, on every team. It takes into account your scout so it's not a cheat code in any way. Worth checking out.

https://forums.ootpdevelopments.com/...d.php?t=361580

Those Google Sheets are nice. I know some people use AI, some don't, but if you do, you can do some really quick creative things with OOTP exports or screenshots.

[Hoolix]

Originally Posted by Guthrien

The user squirrel has created a Projection System called pistachio. It's pretty excellent and there's a fair amount of statistical study of OOTP that's gone into it, including some of the work of the old Projection Calculator that was popular here (web page). If nothing else, it taught me a lot about how the game values certain ratings translated to runs earned / runs saved.

Long story short, it's python code, but if that sounds intimidating he has made some beginner friendly videos of how to use it, and it runs off of simple exports from the game. You can do it all free with a little self-teaching (I needed to). I don't find it's WAR evaluations super accurate, but wOBA and others are there. The MAIN point is, it lets you compare players value, a lot of them, or a little, on every team. It takes into account your scout so it's not a cheat code in any way. Worth checking out.

https://forums.ootpdevelopments.com/...d.php?t=361580

Those Google Sheets are nice. I know some people use AI, some don't, but if you do, you can do some really quick creative things with OOTP exports or screenshots.

I followed those videos from Squirrel but I keep getting errors. I sent him a message, but he hasn't responded yet. It's only been 2 days and I understand not everyone checks these messages daily.

[Hoolix]

Originally Posted by nebben

Those work. Thanks so much for sharing! I'm always looking to geek out more on OOTP.

Sorry this slipped by me and I didn't respond. One of those screen shots does contract value. It does it for my team, but could easily be modified for FAs.

Could you share the trade calculator that you have also.

[cmcgill]

Originally Posted by Hoolix

Sorry this slipped by me and I didn't respond. One of those screen shots does contract value. It does it for my team, but could easily be modified for FAs.

Could you share the trade calculator that you have also.

This might be the one that was mentioned:

https://forums.ootpdevelopments.com/...hlight=surplus