# Kingdom Tribute Calculator **URL:** \ **Category:** Community Guides\ **Created:** [July 24, 2016, 8:27am UTC](https://community.gemsofwar.com/t/kingdom-tribute-calculator/10221 "2016-07-24T08:27:42Z")\ **Posts on this page:** 7\ **Page:** 1
**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, 8:27am UTC](https://community.gemsofwar.com/t/kingdom-tribute-calculator/10221/1 "2016-07-24T08:27:42Z")
Edit: Updated to Include Leonis Empire Latest Link: [https://drive.google.com/open?id=0B\_JkzjaHN8hkU1RIM3EwbDhzREE](https://drive.google.com/open?id=0B_JkzjaHN8hkU1RIM3EwbDhzREE) After going through the brilliant Kingdom Bonus Guide by @KAYA43V3R I mentioned that it would be great if it also included a tribute calculator, and lo and behold, he has done another amazing job here. The file is Excel based and can be found here: [https://drive.google.com/open?id=0B9tzsrIwJ9FnRzZkSHgzVk90bzA](https://drive.google.com/open?id=0B9tzsrIwJ9FnRzZkSHgzVk90bzA) There are 2 worksheets with an image of each shown below. The first sheet is used to select which kingdoms you have unlocked and also for specifying your home kingdom. The second sheet requires you to input each kingdoms level, star level and quest completion status - your hero level can also be entered. ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/2X/9/90fc23872520556e020628f21462faba4cdd78f6.jpg) ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/2X/8/8281942b16f7c477111e3655a156a54bffb3ec78.jpg) The outputs from his excel are: (1) Average resources received per tribute (2) Subsequent resources expected each week (3) Daily gold income from kingdoms (4) A players attack, health, armour and magic stats due to hero and kingdom levels/stars (5) Mastery levels gained from kingdom level ---
**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, 8:31am UTC](https://community.gemsofwar.com/t/kingdom-tribute-calculator/10221/2 "2016-07-24T08:31:02Z")
Based on the calculator I am expecting: Per Tribute 264.25 Gold, 11.52 Glory, 38.28 Souls Per Week 4228 Gold, 184.32 Glory 612.48 Souls ---
**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 24, 2016, 9:19am UTC](https://community.gemsofwar.com/t/kingdom-tribute-calculator/10221/3 "2016-07-24T09:19:32Z")
Level 1000, approximately 30 log in a week Per Tribute 820 Gold, 30.4 Glory, 132.8 Souls Per Week 24600 Gold, 912 Glory 3984 Souls ---
**Author:** ![killerman3333](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/killerman3333/32/4068_2.png) [@killerman3333](https://community.gemsofwar.com/u/killerman3333)\ **Post date:** [July 24, 2016, 10:36am UTC](https://community.gemsofwar.com/t/kingdom-tribute-calculator/10221/4 "2016-07-24T10:36:32Z")
I needed this for no reason other than to have this. ---
**Author:** ![killerman3333](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/killerman3333/32/4068_2.png) [@killerman3333](https://community.gemsofwar.com/u/killerman3333)\ **Post date:** [November 12, 2016, 12:47am UTC](https://community.gemsofwar.com/t/kingdom-tribute-calculator/10221/5 "2016-11-12T00:47:07Z")
Now i actually need this to need this. ---
**Author:** ![Ariel](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ariel/32/17124_2.png) [@Ariel](https://community.gemsofwar.com/u/Ariel)\ **Post date:** [December 3, 2016, 9:47pm UTC](https://community.gemsofwar.com/t/kingdom-tribute-calculator/10221/6 "2016-12-03T21:47:29Z")
I updated the sheet đŸŽȘ It adds **_Blackhawk_, _Dragon’s Claw_, and _Leonis Empire_** to the bottom \* 🎁 Adds **_Guild Tribute Chance_ & _Amount Bonuses_** in a 3rd tab [https://drive.google.com/file/d/0B5LUIw1Py1J4eUdYbFhGWkNjcTQ/view](https://drive.google.com/file/d/0B5LUIw1Py1J4eUdYbFhGWkNjcTQ/view) \*I used an older version which was missing Leonis Empire. Newer sheets would show Leonis Empire in its correct alphabetical location. ## IMPORTANT NOTE: Enter 168 for Logins Per Week ---
**Author:** ![Ariel](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ariel/32/17124_2.png) [@Ariel](https://community.gemsofwar.com/u/Ariel)\ **Post date:** [December 3, 2016, 9:54pm UTC](https://community.gemsofwar.com/t/kingdom-tribute-calculator/10221/7 "2016-12-03T21:54:10Z")
Note1: if you don’t have Excel and just want to use it as a Google Sheet, you have two options: 1. Use this link and change TRUE and FALSE values appropriately [https://docs.google.com/spreadsheets/d/1S\_wRf0yBogTkOVB9J3s3I69ODtUOm3ZBRcEb3i4Y89E/edit](https://docs.google.com/spreadsheets/d/1S_wRf0yBogTkOVB9J3s3I69ODtUOm3ZBRcEb3i4Y89E/edit) 2a) Select Columns A through F, right click, and choose “UNHIDE COLUMNS” 2b) Click the little left/right arrows where Columns C and E should be Note 2: Quest column Red O = Not complete; Green P = Completed The easiest way to do those is just copy one P and paste it into every Kingdom with Completed Quests