View Single Post
Old 06-22-2020, 05:13 AM   #7
Squirrel
Mascot
 
Join Date: Jul 2016
Heh OpenTTD is my son's favourite at the moment. He's a bit young for FOF but that time will come.

The thing you might need to learn if you're working on Excel for affinities is the combination of using INDEX and MATCH. That's a key thing to use if you're going that way...in my opinion more flexible than the various varieties of LOOKUP.

If you want to take it to the next level of speed / automation, perhaps have a go at figuring out how to use Powerquery in Excel.

Then there's learning python or SQL, which is another way do to it but that bit more hardcore again.

For me the main thing tools like this do is reduce the time it takes to zero in on the parts of the game I want to think about. I just want a pre-filter to tell me the ten or so players in the game population that I would have shortlisted had I taken the time to do so...then I will decide what to do from there. It's more fun for me to play that way.
Squirrel is offline   Reply With Quote