Posted July 18, 2014
A game that is both pre-2k and 10+ years old gets added to both categories. A game that is 10+ years old but post-2k gets added only to the 10+ years old category. A game that is less than 10+ years but pre-2k gets added to the pre-2k only, but the 10+ years old in those 2 years aren't reported.
kalirion: Wait, are the pre-2k and 10+ year old numbers overlapping or not? That makes a big difference.
To find out if a game is older than 10 years, I subtract the original release date from GOG's release date and use the YEARFRAC function with parameter 1. If the result is 10 or more, then it's counted. So day and month are also counted, not just year.
There are four categories. Day One, pre-2K, 10+ and none of the above. Amnesia, Penumbra etc are in the none of the above category.
Ric1987: Another thing the data doesn't really cover are games like Amnesia, Penumbra, etc that are less than 10 years old but I guess they're lumped in with the day one releases?
Post edited July 18, 2014 by JMich