I know the spreadsheets look more complicated than they really are. I fully understand the importance and/or relevance of all the data so I knew what I was looking at for the most part. Anything that wasn't 100% clear by simply looking at your spreadsheets was cleary outlined in your original post. What might make it seem more complicated to some people is the amount of data presented in a small space. I never had a need to learn excel, nor do I now. But I'm definitely going to play with it a little more.
All my data logging/tracking was largely done by hand. I have a 3 subject spiral notebook that is almost full of nothing except JPB. About 25% of it is all my team building/balancing I've done up until now (figured team stats etc. on paper & with calculator... old school lol). The remainder of the notebook is largely "play by play" tourny data on the bots that I would log as I played. I then use that to determine % probabilities of when the bots will use specials. Same as your spreadsheets, its looks more complicated than it is. I dont track the bots anymore though, simply because I don't need to anymore.... I rarely lose. All I used excel for was to keep an easy to update log of all my creatures stats. So basically it was just logged into excel by hand. Only formulas were 1. Park total ferocity/ average ferocity 2. total & average ferocity of top 9 and top 18.Then I had a seperate row specifically to keep a running average of opponent ferocity (Which I reset whenever theres a noticable change in the bots patterns).
Your opponents are scaled quite high so playing 2 tournys is rather difficult. Mine used to be the same as yours... there was one time I even played an aquatic bot whose team ferocity was over 3800 (the highest possible is 3843 in aquatic!). My opponents are scaled a little bit lower than they used to be (in terms of ferocity). Now my opponents teams average around 3450 ferocity with an ocassional 3650+ in aquatic, average 3350 with an occasional 3550+ in glacier and in jurassic they average a whopping 2800 with an occasional 3100+. Like I said, my opponents have scaled down some and heres how I did that (note: I have every creature in the game, including the new market creatures. missing only the platybelondon which is not yet released)
In aquatic I sold all bronze and silver creatures, then re-purchased them and have left them at level 1 (resulting in a lower park average, which is why I bought them back) I have done the same with the following golds: styxosaurus, leviathan, bananogmius and ophtalmosaurus. All other golds are maxed level 40
In glacier, I did the same thing with all bronze and silvers. As for golds I sold/ repurchased peltephilus, arsinoitherium, kelenken & megalania. All other golds are maxed level 40.
Jurassic I sold & repurchased all bronze & silvers and leveled them upto 5 (in case I need them to farm claws ever again, which is unlikely). All golds are maxed level 40.
I play 2 tournaments/day in aquatic & glacier. This season I am 100% undefeated
As for your question about opponents ever using only 1 or 2 dinos... in jurassic round 1 they never use 3, always 2. Until very recently in glacier (and the recent change away from this pattern coincides with kaprosuchus purchase/full evolution) I had round 1 was always just a single indricotherium, nothing more. I reconfigured my teams to better match this pattern because this pattern was present 100% of the time.
Can I add you as a friend? I'd like to see your parks. If no, its cool. If yes, just send me/ my page a message via facebook messenger... that way facebook info isnt publically posted here.
Thanks for the kudos, btw.