I've been read-only mode for the past two months, since i haven't played civ since November and too much things have changed. I can't comment on almost any part of the game now, cause everything is upside down, i need to try it first. But this assumptions are totally broken and all numbers are wrong for sure.
Really, please do not make any decisions based on current numbers, i appreciate the effort, and the approach is right, i used it for more than two years to compare the pantheons. But there are too many mistakes.
You can't compare pantheons without taking playstyle into consideration. For example you take Expanse ONLY if you play Tradition, otherwise it is just a bad choice (no, you do not take Expanse with Authority, it does not make any sense), and you can't compare bad choices with good choices.
You take Commerce only for Carthage/Songhai/Hiawatha or if you play Progress.
You take Festivals only when you have high gold income an resources that are easy to improve (typically mining resources only) - and i think that Festivals is one of the strongest pantheons faith-wise, with Willie you are guaranteed to get a religion no matter what.
And there are a lot of things like this
Well, first of all, I did mention that i chose close to ideal, or at least good scenarios for each pantheon. The ideal balance is to have no real outliers in ideal scenarios, average or bad scenarios don't matter. And since some pantheons require the literal perfect storm for the best results, the ideal balance should also take into consideration probability. So what i did is i used "close to ideal, but realistic scenarios" for each individual pantheon, as i said.
Since you mentioned expanse - which i played a test game as russia to get some rough estimates - I of course did take tradition. I even considered authority's garrisons if they'd be better for border growth. But in the end, it wasn't.
For commerce it's the same thing. I even mentioned that those numbers are estimates for iroquois, carthago and songhai. I did not mention progress, because it's irrelevant, when you're cities are instantly connected. If you take commerce as none of those civs, you're most certainly not gaining as much from commerce as they would, even with progress.
Concerning Festivals, I did not take the dutch into account, because who the heck knows that they are treated differently, seriously? Well, tbh that's an excuse for "i didn't know", but either way - this is the opposite of constructive criticism. I told everyone that, if they might have an idea on how to do better, please to share it. And all you did was discredit all the work and leave, like a troll. thanks for that. Now, since you threw in that knowledge, how about you share some of your experience and data. how many ressources can you gather as dutch and trade for other ressources? how much is a likely number? in what turns do they connect/trade their ressources on average? and i hardly believe "No matter what" is very scientific. so please come again and share some realistic data with us.
what triggers me the most is tat last phrase. "And there are a lot of things like this". So now i'm either forced to tell everyone "hey he's right, my list is garbage, please forget everything, because he said so" and we leave it like that. Or, I can kindly ask you sir, WHAT ARE THOSE THINGS. Oh and this time, please read the sheet thoroughly.