Tier 5 KaW Build Calculator

Check out our featured guides.

Moderator: Kingdoms at War

Re: Tier 4 KaW Build Calculator V2.2 by StoneFord

Postby *Rubra (01) on Dec 27 2010, 10:18am

bump
Wir tragen dich in unseren Herzen, Du bist die Treue, Du bist die Liebe, Unser Glauben


Der_oberst wrote:do i have to wear clothes? i think you'll find nobody complained


i hit you x3. please do not add numbers you cannot count to
*Rubra (01)
 
Posts: 143
Joined: Dec 13 2010, 12:34pm
Location: Here

Re: Tier 4 KaW Build Calculator V2.2 by StoneFord

Postby Dark_assassin_lIllI on Dec 27 2010, 8:45pm

Thanks for the feedback. I know I have a few mistakes. Like the tier 4 lvl 2 def stats for one of the troop builds. But since I left the spreadsheet unlocked, you can fix it easily. LOL! I will fix these typos. Again, I really appreciate the feedback and all suggestions for improvement.
Dark_assassin_lIllI
 
Posts: 223
Joined: Oct 10 2010, 4:01am

Re: Tier 4 KaW Build Calculator V2.2 by StoneFord

Postby Dark_assassin_lIllI on Jan 15 2011, 5:51am

A-Dubb has made some modifications to the KaW Build Calculator posted above. As soon as I get the changes from him, I will post the next revision with fixes to some of the stat columns. Thank you all for your help!

Also, any thoughts on the max plunder column? I am on the verge of removing it. Or calling it "theoretical".
Dark_assassin_lIllI
 
Posts: 223
Joined: Oct 10 2010, 4:01am

Re: Tier 4 KaW Build Calculator V2.2 by StoneFord

Postby midnightrosedg on Jan 17 2011, 11:01pm

Bump.
midnightrosedg
 
Posts: 168
Joined: Sep 26 2010, 9:34am

Re: Tier 4 KaW Build Calculator V2.2 by StoneFord

Postby WarriorMonk on Feb 5 2011, 6:11pm

Bump
WarriorMonk
 
Posts: 22
Joined: Jun 30 2010, 5:06pm

Re: Tier 4 KaW Build Calculator V2.2 by StoneFord

Postby iisar on Feb 18 2011, 3:13pm

Thank you for a wonderful and extremely helpful calculator. What an amazing effort!

Thought I'd bring to your attention a small error: the unit def strength for lvl2 Cursed Foundry should be 1720, not 1000.

Obviously, what would make this even more incredible is a way of calculating ally value needed for max plunder, and ally bonus. But I think it will be a while before those formulas have been agreed upon.

Small wishlist: a cell for total stats, and a calculation of value range (from total stats x 10,000 to total stats x 30,000).

Thanks again!!
iisar
 
Posts: 1
Joined: Dec 29 2010, 12:06pm

Re: Tier 4 KaW Build Calculator V2.2 by StoneFord

Postby *jo-jo-jo (01) on Mar 11 2011, 8:18am

I was using it all the time! The job u did is amazing. But are you going to update it? Are u going to include the new lands? I need to know the new prices...
*jo-jo-jo (01)
 
Posts: 6
Joined: Feb 3 2011, 11:23am

Re: Tier 4 KaW Build Calculator V2.2 by StoneFord

Postby IlINightmare_0F_RetributionIlI on Mar 17 2011, 9:48am

StoneFord,

First off, great work on the Build Calculator. It's fantastic.

I've downloaded it an tweaked it a bit and I have a couple of upgrade suggestions for you :-) Specifically, in terms of helping a player answer the question, 'Should I explore a new land and build on it, or should I upgrade an existing building'. The answer being: whichever has the cheaper gold-to-stat ratio.

The summary below includes formulas that you should be able to paste directly into your calculator. It shows, for example, that it is more beneficial to upgrade from T3 to T4 than to explore the 5th highland.

Gold to stat ratio for exploring a new land and building on it
[Cost of bldg + Cost of Next Land] / [Stats from Bldg]
=($I9 + VLOOKUP($G$66+2,$G$73:$G$122,2))/(sum($O9:$R9) * 50)
  • Paste the above in cell Y9.
  • I only copy and past this on the lines for the lvl3 buildings.
  • I multiple by 50 to get the raw strength figure instead of 'bonus to allies' figure. However, as it is just a scalar multiple, its inclusion or exclusion is irrelevant.
  • The VLOOKUP has a "+2" because the first land is a castle (not counted in your #Built figure) and then one more to get to the 'next land'.
  • The formula references the highlands cost which are not yet in your build calculator. But as soon as you add them, then the formula will correctly reference them.


Gold to stat ratio for upgrading a building
[Cost of bldg] / [*Marginal increase* in stats from bldg]
=$I18/((sum($O18:$R18)-sum($O9:$R9))*50)
  • Paste the above in cell Z18.
  • I only copy and past this on the lines for the lvl3 buildings.
  • This takes T2 Def and compares it to T1 Def (both lvl3).
  • I multiple by 50 to get the raw strength figure instead of 'bonus to allies' figure. However, as it is just a scalar multiple, its inclusion or exclusion is irrelevant.

Hope this helps!

Thanks again for your work on this project
IlINightmare_0F_RetributionIlI
 
Posts: 154
Joined: Aug 28 2010, 6:19am

Re: Tier 4 KaW Build Calculator V2.2 by StoneFord

Postby *Kingdomsslayer (01) on Mar 29 2011, 4:34pm

Where do you get the calculator. They make things so difficult to find should have a tab for it.
*Kingdomsslayer (01)
 
Posts: 1
Joined: Jan 14 2011, 1:49pm

Re: Tier 4 KaW Build Calculator V2.2 by StoneFord

Postby Platinum on Apr 8 2011, 9:03am

Any update for the highlands soon? would love to see it :)
Platinum
 
Posts: 1202
Joined: Dec 28 2010, 1:40pm

PreviousNext

Return to Guides

Who is online

Users browsing this forum: oO_JiP_Oo and 0 guests