# 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:** 4
**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:29am UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/61 "2016-07-22T10:29:42Z")
Ok i’ll try to do an excel one. But I like when things are pleasant visually, so a little patience ---
**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:51am UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/62 "2016-07-22T10:51:35Z")
@Robert, for this spreadsheet, you want only tribute or you need gold incomes from kingdoms…? In that case the incomes increase with kingdom level & stars, but i don’t know the basis incomes for each kingdoms. example: Adana level 1 = xxx gold level 2 = xxx level 3 = xxx … does anyone know this…? i know this: quest = +25 gold and basis +20 (but my kindom are level 10…level 1, basis = +20 gold…???) ---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [July 22, 2016, 12:04pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/63 "2016-07-22T12:04:11Z")
I have a work in progress if anyone is interested, on my site: > **[Kingdom Table - Gems of War Database](https://gowdb.com/kingdomtable)** > > A table of all kingdoms in Gems of War and their statistics. Doesn’t have banner info or 2x tribute info yet, or links to related stuff like troop lists, but it’s a start – and should stay in sync as I update the site with new stuff. ---
**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, 12:14pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/64 "2016-07-22T12:14:11Z")
I was thinking solely for tribute to ascertain what someone can expect on average each log in - discarding any daily bonuses etc. It would take a lot more time tarting it up to your standard than creating the calcs 🙂 Maybe it would help if I sent on the base calc for you to fix and complete? Could do it if I have time after work ---
**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, 12:17pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/65 "2016-07-22T12:17:33Z")
ok just send me a pm with a dl link (onedrive, googledrive, …), if you have a base it would help sure ---
**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, 4:49pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/66 "2016-07-22T16:49:29Z")
@Robert I hope it pease you 😉 Excel only (some function don’t work otherwise) [https://drive.google.com/open?id=0B9tzsrIwJ9FnRzZkSHgzVk90bzA](https://drive.google.com/open?id=0B9tzsrIwJ9FnRzZkSHgzVk90bzA) you can download it `screenshoot`: ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/2X/f/f0a96259b8f91e5a0ac166e13ee9e517c6c39c52.png) Enjoy 😋 ---
**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, 4:55pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/67 "2016-07-22T16:55:11Z")
Great stuff, very efficient, didnt even give me enough time to finish work so i could help 😆 ---
**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, 5:08pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/68 "2016-07-22T17:08:16Z")
> [@Lyya](#): > > work in progress That would be good, because everyone don’t have Excel Good luck @Lyya ---
**Author:** ![Stan](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/stan/32/29888_2.png) [@Stan](https://community.gemsofwar.com/u/Stan)\ **Post date:** [July 22, 2016, 6:32pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/69 "2016-07-22T18:32:37Z")
I was thinking of doing and quick and dirty version of this for myself this very morning (just to get a sense of what level of tribute I could expect on average). Thanks so much! ---
**Author:** ![Stan](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/stan/32/29888_2.png) [@Stan](https://community.gemsofwar.com/u/Stan)\ **Post date:** [July 22, 2016, 6:44pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/70 "2016-07-22T18:44:16Z")
Question for you: the ‘stars’ column has options for 0 to 5. Does this mean that “0” is actual one white star and the 50 bonus for achieving that is in the base gold number? I think you would actually need 7 options to capture all of the possibilities… Also, there seem to be some weird interactions between star #'s and tribute. For example, with Adana at 0 stars, it shows no tribute amounts. With any other number of stars, the correct base tribute appears (175 gold, 2 glory, 4 souls). The double tribute reward doesn’t appear at 1 gold star or above. Other kingdoms have some weird stuff too. Groshnak shows 45 gold for tribute with zero stars. The Gold tribute column seems to be increasing for power level stars, when it should be just the Gold income amount. I haven’t checked all the cells, but I think you need to check your formulas. ---
**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, 7:52pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/71 "2016-07-22T19:52:02Z")
Ok my bad ,I forget to expand formula in L4 to the entire colum. But i don’t understand: [quote=“Stan, post:70, topic:1047”] with Adana at 0 stars, it shows no tribute amounts [/quote] The tributes come when you achieve level 10 with 0 stars…? if the level is \<10 do you earn any tributes? I can correct but i don’t remember some point, all my kingdom are level 10. This is the formula in tribute for adana =SOMME(SI(ET(F4\>=0;D4=10);Data!C3;0);SI(ET(F4\>=1;D4\>0);Data!C3;0)) Data!C3 = 175 translate: (if stars \>=0 and Level =10 then Tribute = 175) + (if stars \>=1 and level \>=1 then tribute=175) Isn’t it right…? > [@Stan](#): > > Groshnak shows 45 gold for tribute with zero stars Hmm Groshnak tributes for gold =0 …you find 45…??? probably because i forget to expand formula Ok I update for the formula in tributes colum, waiting if you find something wrong… [https://drive.google.com/open?id=0B9tzsrIwJ9FnRzZkSHgzVk90bzA](https://drive.google.com/open?id=0B9tzsrIwJ9FnRzZkSHgzVk90bzA) ---
**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:12pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/72 "2016-07-22T20:12:32Z")
I believe the base tribute is always there regardless of stars or level. Increasing level increases %chance. 1 gold star doubles tribute. 3 gold stars doubles chance. ---
**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:14pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/73 "2016-07-22T20:14:29Z")
ok so formula must be: =SOMME(SI(ET(F4\>=0;D4\>0);Data!C3;0);SI(ET(F4\>=1;D4\>0);Data!C3;0)) ??? right…??? ---
**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:15pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/74 "2016-07-22T20:15:38Z")
Sorry can you translate please? ---
**Author:** ![Stan](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/stan/32/29888_2.png) [@Stan](https://community.gemsofwar.com/u/Stan)\ **Post date:** [July 22, 2016, 8:17pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/75 "2016-07-22T20:17:12Z")
> [@KAYA43V3R](#): > > The tributes come when you achieve level 10 with 0 stars…?if the level is \<10 do you earn any tributes?I can correct but i don’t remember some point, all my kingdom are level 10.This is the formula in tribute for adana > > =SOMME(SI(ET(F4\>=0;D4=10);Data!C3;0);SI(ET(F4\>=1;D4\>0);Data!C3;0))Data!C3 = 175 > > translate: (if stars \>=0 and Level =10 then Tribute = 175) + (if stars \>=1 and level \>=1 then tribute=175) > > Isn’t it right…? The chance of getting a tribute is determined mostly by kingdom level. Once a kingdom is unlocked, it is level 1 and has a 1% chance of delivering the tribute amount each time tribute is checked. As the levels are increased, the % chance of receiving tribute increases to a maximum of 10% at level 10. Independent of that, the kingdom power level (measured by stars) can double the tribute chance at 3 gold stars. So, the % chance can be anywhere from 1 to 20% depending on the combination of BOTH kingdom levels. The tribute amount starts at a base of whatever combination of gold, glory and souls, and is doubled when one gold star is achieved. I’m not sure how to translate that into a single formula. If it was me, I would do it with more columns. One to determine the base probability of tribute (dependent on kingdom level 0 to 10, doubled if power level \>= 3 gold stars) and a second to determine the eligible tribute (doubled if power level \>=1). ---
**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:17pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/76 "2016-07-22T20:17:18Z")
ok si level \>0 et stars \>=0 tribute = 175 + si level \>0 et stars \>=1 tribute =175 ---
**Author:** ![Stan](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/stan/32/29888_2.png) [@Stan](https://community.gemsofwar.com/u/Stan)\ **Post date:** [July 22, 2016, 8:19pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/77 "2016-07-22T20:19:35Z")
If it were me, I would separate the two issues. I would calculate and display both the probability of receiving tribute by kingdom and the expected value of tribute. Then by muliplying one by the other, you would get the expected value of tribute per tribute check by kingdom, which could be summed up to give a global expected 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:19pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/78 "2016-07-22T20:19:39Z")
> [@Stan](#): > > the % chance I don’t take care about % of chance, it’s just the total actualy ---
**Author:** ![Stan](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/stan/32/29888_2.png) [@Stan](https://community.gemsofwar.com/u/Stan)\ **Post date:** [July 22, 2016, 8:21pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/79 "2016-07-22T20:21:36Z")
Then the kingdom level is irrelevant to you and this doesn’t solve Robert’s problem. ---
**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:22pm UTC](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047/80 "2016-07-22T20:22:01Z")
If stars\<1 tribute=175; if stars \>=1 tribute=175\*2 Assuming 175 is the base value @kaya43v3r is it ok if I change your excel to include tribute chance? Then we can use it to calculate the average that we can expect each time we get a tribute. And multiply it by a defined amount of log ins a week to get a weekly value [Previous page](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047.md?page=3) [Next page](https://community.gemsofwar.com/t/kingdom-bonuses-guide-updated-to-2-0/1047.md?page=5)