If someone didn’t even have a silver star for their kingdom the gold reward would still apply as we are using 0 stars for having a silver star. Bit messy separating Silver and Gold columns and adding in extra IF statements though isn't it?
What does O and P stand for under quest? P is completed?
For the Gold daily Income is it true that completing the quests gives +25 gold each day? and a Level 1+ kingdom gives 20 gold each day? I am unfamiliar with these so just making sure...
The formula for a given kingdoms gold, souls etc included the D column. I have started deleting those from the formula. For example, instead of '=SUM(IF(AND(F6>=0,D6>0),Data!D5,0),IF(AND(F6>=1,D6>0),Data!D5,0))' ......................... I have '=SUM(IF(F5>=0,Data!D4,0),IF(F5>=1,Data!D4,0)) '