strange! yeah i like to export all the individual pitch types and only count them in my =COUNTIFS formula if they are at least a 25 current and or 40 potentials so sometimes I Get that too.
@@ootpvideos4677 Interestingly, I keep coming up with Vance Honeycutt as the top batter. It's because he's a center fielder with 75 range so maybe the offense/defense weights are out of whack.
@@mattgriffin8383 Yeah that can be the tricky part is getting the weights how u want them. for CF I have it set to 68% offense 30% defense and 2% baserunning and it seems okay. (They only qualify for CF = or CF + in my thing if they have at least 65 OF range)
I know it's been a year since you put this together, but I'm pretty sure I got aroused watching OOTP get completely nerded up. I'm working on this when I get home.
nice! yeah it's so fun haha. I have been working away on my spreadsheet alot too. Took a lot of editing with the new ootp25 ratings (babip and HR against ratings and such. You got yours on excel or google sheets?
@@ootpvideos4677 It'll be Excel. I work with a lot of data for my job so Excel is the way to go for me. Would be cool to plop it into a SQL database. Raw data and then a whole bunch of lookups and arithmetic. Knowing the arithmetic to do is the hard part of course. Not gonna lie. I kinda wanna see it. :)
Man, this is so dope. I'd seen in the SOBR discord that you're still working on some elements of this. Wil you ever consider sharing it? I only play single player but could scroll through this sort of thing for hours just looking at all the data lol
thanks a lot. I will be sharing it soon yeah I just keep wanting to have it flawless before I share it and keep thinking of new ideas to add to it and delaying it but I'll try to have it out soon.
When I was going through it I found some cases where a pitcher had three non-zero pitches but OOTP said he had four pitches.
strange! yeah i like to export all the individual pitch types and only count them in my =COUNTIFS formula if they are at least a 25 current and or 40 potentials so sometimes I Get that too.
If you have discord I would be happy to chat about it and help eachother on our spreadsheets
@@ootpvideos4677 I do: mattg.1707
Do you have your own server?
@@ootpvideos4677 Interestingly, I keep coming up with Vance Honeycutt as the top batter. It's because he's a center fielder with 75 range so maybe the offense/defense weights are out of whack.
@@mattgriffin8383 Yeah that can be the tricky part is getting the weights how u want them. for CF I have it set to 68% offense 30% defense and 2% baserunning and it seems okay. (They only qualify for CF = or CF + in my thing if they have at least 65 OF range)
Do you have a video where you go over the pitching?
I know it's been a year since you put this together, but I'm pretty sure I got aroused watching OOTP get completely nerded up. I'm working on this when I get home.
nice! yeah it's so fun haha. I have been working away on my spreadsheet alot too. Took a lot of editing with the new ootp25 ratings (babip and HR against ratings and such.
You got yours on excel or google sheets?
@@ootpvideos4677 It'll be Excel. I work with a lot of data for my job so Excel is the way to go for me. Would be cool to plop it into a SQL database. Raw data and then a whole bunch of lookups and arithmetic. Knowing the arithmetic to do is the hard part of course. Not gonna lie. I kinda wanna see it. :)
Any update on the sharing of this? I love how this looks.
Man, this is so dope. I'd seen in the SOBR discord that you're still working on some elements of this. Wil you ever consider sharing it? I only play single player but could scroll through this sort of thing for hours just looking at all the data lol
thanks a lot. I will be sharing it soon yeah I just keep wanting to have it flawless before I share it and keep thinking of new ideas to add to it and delaying it but I'll try to have it out soon.
@@ootpvideos4677 That's awesome to hear, every little improvement and addition you make always look cool, it'll definitely be worth the wait!
@@ootpvideos4677 Any word on sharing this? Appreciate it!
Would you sell this spreadsheet to me, LOL?
Update???
Sorry for slowww reply haha. You still playing OOTP I can do that if you are still interested.
no $ all good I can just send er for free :) always nice to chat with fellow OOTP nerds
@@ootpvideos4677 Yes!
@@ootpvideos4677 yes we are still interested!