OOTP Developments Forums - View Single Post - I made a thing! First usable results from my database

torpidbeaver · 04-19-2018, 02:43 AM

This is amazing. I’ve been beating the data visualization drum for a couple years now, but what you made here is amazing!

I’ve been trying to figure out a way to track players’ scouted ratings on excel and google Sheets but hit a wall with the problem of having hundreds or even thousands of players, each with multiple attributes, and each player/attribute further complicated by multiple years. It’s like I need a z-axis too, or something.

I came to a point where I could either make a new sheet for each player and have the X/Y be attributes/years (horribly inefficient, required more work cutting and pasting than I was willing to do), or I could go down the Pivot Table rabbit hole (tried but couldn’t get it to work).

I think the answer is somewhere in the pivot table realm. If anyone has some suggestions or advice (or even better, a working file with equations and visualization built in), I’d just be so delighted for the help.

04-19-2018, 02:43 AM	#22
torpidbeaver Major Leagues Join Date: Aug 2011 Posts: 391	This is amazing. I’ve been beating the data visualization drum for a couple years now, but what you made here is amazing! I’ve been trying to figure out a way to track players’ scouted ratings on excel and google Sheets but hit a wall with the problem of having hundreds or even thousands of players, each with multiple attributes, and each player/attribute further complicated by multiple years. It’s like I need a z-axis too, or something. I came to a point where I could either make a new sheet for each player and have the X/Y be attributes/years (horribly inefficient, required more work cutting and pasting than I was willing to do), or I could go down the Pivot Table rabbit hole (tried but couldn’t get it to work). I think the answer is somewhere in the pivot table realm. If anyone has some suggestions or advice (or even better, a working file with equations and visualization built in), I’d just be so delighted for the help.