# Kingdom Bonuses Guide (updated to 2.0) **URL:** \ **Category:** Community Guides\ **Created:** [October 29, 2015, 10:03am UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047 "2015-10-29T10:03:17Z")\ **Posts on this page:** 20\ **Page:** 5
**Author:** ![KAYA43V3R](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/kaya43v3r/32/312_2.png) [@KAYA43V3R](https://community.gemsofwar.com/u/KAYA43V3R)\ **Post date:** [July 22, 2016, 8:26pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/81 "2016-07-22T20:26:32Z")
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 ---
**Author:** ![Robert](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/robert/32/12802_2.png) [@Robert](https://community.gemsofwar.com/u/Robert)\ **Post date:** [July 22, 2016, 8:40pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/82 "2016-07-22T20:40:46Z")
Great, I will. The tribute chance combines gold star 3 and kingdom level. If stars\<3 chance=level/100; if stars \>=3 tribute=(level\*2)/100 ---
**Author:** ![KAYA43V3R](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/kaya43v3r/32/312_2.png) [@KAYA43V3R](https://community.gemsofwar.com/u/KAYA43V3R)\ **Post date:** [July 22, 2016, 8:42pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/83 "2016-07-22T20:42:04Z")
for chance %chance for Adana =Somme(SI(F4\>=3;2;1)\*D4) add /100 if you need % then i’m not an expert in proba, so explain (with word or formula) the result you want to find ex 10% x 7 day x tributes…??? I can do you formula if you explain ---
**Author:** ![Robert](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/robert/32/12802_2.png) [@Robert](https://community.gemsofwar.com/u/Robert)\ **Post date:** [July 22, 2016, 8:52pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/84 "2016-07-22T20:52:41Z")
Does my previous message help at all? Once you know the chance, and you already had the total, then the average per tribute = chance\*total. If someone can then enter how many times they log in a week into a cell, then the weekly average = ( no. of weekly log ins)\*(average per tribute) ---
**Author:** ![KAYA43V3R](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/kaya43v3r/32/312_2.png) [@KAYA43V3R](https://community.gemsofwar.com/u/KAYA43V3R)\ **Post date:** [July 22, 2016, 8:54pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/85 "2016-07-22T20:54:35Z")
Ok just a minute plz ---
**Author:** ![KAYA43V3R](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/kaya43v3r/32/312_2.png) [@KAYA43V3R](https://community.gemsofwar.com/u/KAYA43V3R)\ **Post date:** [July 22, 2016, 9:16pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/86 "2016-07-22T21:16:26Z")
@Robert Try this plz and tell me what…? [https://drive.google.com/open?id=0B9tzsrIwJ9FnRzZkSHgzVk90bzA](https://drive.google.com/open?id=0B9tzsrIwJ9FnRzZkSHgzVk90bzA) updated for M4:N26 (forget to update formula) ---
**Author:** ![Robert](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/robert/32/12802_2.png) [@Robert](https://community.gemsofwar.com/u/Robert)\ **Post date:** [July 22, 2016, 9:28pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/87 "2016-07-22T21:28:58Z")
I am downloading it now 🙂 ---
**Author:** ![Robert](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/robert/32/12802_2.png) [@Robert](https://community.gemsofwar.com/u/Robert)\ **Post date:** [July 22, 2016, 9:58pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/88 "2016-07-22T21:58:43Z")
It looks great so far, I have some comments/queires, I should probably continue going through it all first? ---
**Author:** ![KAYA43V3R](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/kaya43v3r/32/312_2.png) [@KAYA43V3R](https://community.gemsofwar.com/u/KAYA43V3R)\ **Post date:** [July 22, 2016, 10:00pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/89 "2016-07-22T22:00:18Z")
> [@Robert](#): > > It looks great so far, I have some comments/queires, I should probably continue going through it all first? continue but explain I could improve waiting ---
**Author:** ![Robert](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/robert/32/12802_2.png) [@Robert](https://community.gemsofwar.com/u/Robert)\ **Post date:** [July 22, 2016, 10:05pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/90 "2016-07-22T22:05:43Z")
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)) ’ ---
**Author:** ![KAYA43V3R](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/kaya43v3r/32/312_2.png) [@KAYA43V3R](https://community.gemsofwar.com/u/KAYA43V3R)\ **Post date:** [July 22, 2016, 10:14pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/91 "2016-07-22T22:14:02Z")
> [@Robert](#): > > What does O and P stand for under quest? P is completed? This is for the sign validate or X (use windings2 font) but there’s a check list “O”= x or “P”= v > [@Robert](#): > > For the Gold daily Income is it true that completing the quests gives +25 gold each day? if you check in game the incomes, you’ll see this number appear +25 quest and +35 for khaziel kingdom > [@Robert](#): > > 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)) ’ 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…? and i thinking for the colum for silver stars so are you agree or i missing something…? ---
**Author:** ![Robert](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/robert/32/12802_2.png) [@Robert](https://community.gemsofwar.com/u/Robert)\ **Post date:** [July 22, 2016, 10:20pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/92 "2016-07-22T22:20:02Z")
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? ---
**Author:** ![KAYA43V3R](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/kaya43v3r/32/312_2.png) [@KAYA43V3R](https://community.gemsofwar.com/u/KAYA43V3R)\ **Post date:** [July 22, 2016, 10:24pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/93 "2016-07-22T22:24:52Z")
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 ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/2X/b/b38280b243114aaa6a554f14afceed2ca18a7ba6.PNG) ---
**Author:** ![Robert](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/robert/32/12802_2.png) [@Robert](https://community.gemsofwar.com/u/Robert)\ **Post date:** [July 22, 2016, 10:38pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/94 "2016-07-22T22:38:08Z")
Sounds like a plan. I guess there are multiple ways of ding it. I am in the middle of coming up with a checkbox on the Data sheet ---
**Author:** ![KAYA43V3R](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/kaya43v3r/32/312_2.png) [@KAYA43V3R](https://community.gemsofwar.com/u/KAYA43V3R)\ **Post date:** [July 22, 2016, 10:42pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/95 "2016-07-22T22:42:52Z")
ok we can decide this later with more reflexion: “unlock column or not” but for the stars there’s something wrong because we need silver stars…hmmm I’ve forget this… it’s a bit late for me, i’ll think about this, we keep contact Good game 😉 ---
**Author:** ![Robert](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/robert/32/12802_2.png) [@Robert](https://community.gemsofwar.com/u/Robert)\ **Post date:** [July 22, 2016, 10:45pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/96 "2016-07-22T22:45:55Z")
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 ---
**Author:** ![kzintiwife](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/kzintiwife/32/2350_2.png) [@kzintiwife](https://community.gemsofwar.com/u/kzintiwife)\ **Post date:** [July 24, 2016, 10:33pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/97 "2016-07-24T22:33:59Z")
Show me how and ill upload mine… Already modified for the changes in 11 troops. ---
**Author:** ![Robert](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/robert/32/12802_2.png) [@Robert](https://community.gemsofwar.com/u/Robert)\ **Post date:** [July 24, 2016, 10:47pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/98 "2016-07-24T22:47:13Z")
Hey, kaya43v3r finished it. The final excel is posted in community guides under ‘Kingdom Tribute Calculator’ ---
**Author:** ![kzintiwife](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/kzintiwife/32/2350_2.png) [@kzintiwife](https://community.gemsofwar.com/u/kzintiwife)\ **Post date:** [July 24, 2016, 11:15pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/99 "2016-07-24T23:15:15Z")
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 🙂 ---
**Author:** ![Robert](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/robert/32/12802_2.png) [@Robert](https://community.gemsofwar.com/u/Robert)\ **Post date:** [July 25, 2016, 6:01am UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/100 "2016-07-25T06:01:32Z")
@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? [Previous page](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047.md?page=4) [Next page](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047.md?page=6)