Ok the formula match for this Robert
For tribute chance, add line for sure to calculate the average
if you give me the formula i can had this at the bottom
You can customize your own spreadsheet, i made this for you
so in L4 change formula for this:
=SOMME(SI(ET(F4>=0;D4>0);Data!C3;0);SI(ET(F4>=1;D4>0);Data!C3;0))
and expand formula to L26
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)) ā
This is for the sign validate or X (use windings2 font) but thereās a check list āOā= x or āPā= v
if you check in game the incomes, youāll see this number appear +25 quest and +35 for khaziel kingdom
If you donāt consider this colum and if a guys missing one of the kingdom it doesnāt workā¦he canāt earn tribute if he donāt unlock the kingdom. So i think we must keep thisā¦noā¦?
I see what you are saying about not unlocking a kingdom. It is a cleaner formula without he D column though? Could leave the D column in the formula or have a checklist on the Data worksheet. If the box is ticked the values are filled in, otherwise they are zeros?
We can add this, a Unlock column if you prefer than a 0 in level column, then we can delete D parameters, but add another one in the formula for this unlock column
PS : I can format the cell in this way also to denote the fact that 0 = locked
Indeed, the silver stars thing makes it untidy. Assuming people have unlocked all kingdoms and have them to silver would make it much simpler. Enjoy your rest
does it just up load here and people can get it or does it need to be hosted somewhere? im still trying to figure it out because someone asked about mine with the lvls and traits for next stars
@KAYA43V3R hosted it on google drive then you post the link here. I am not completely sure of the details. If he reads this maybe he can explain properly?