Created by Genocide and Rubgish

Version:
Beta 1.4

Version History:
Alpha 0.1 - Recruiting Calc
Alpha 0.2 - Troop to Worker Ratio Calc
Alpha 0.3 - Fixed a Few Bugs and Colors
Alpha 0.4 - Ranking Point Calc
Alpha 0.5 - Wall Repair Calc
Beta 0.1 - Added Contributer List
Beta 0.2 - Added Links to Each Calc
Beta 0.3 - Added Links to Game, Forums, WoEkipedia
Beta 0.4 - Released to Public
Beta 0.5 - Edited Recruiting Calc Code
Beta 0.6 - Added Warnings to Recruiting Calc
Beta 0.7 - Edited Wall Repair Calc Code
Beta 0.8 - Cosmetically Fixed Version History and Recruiting Calc
Beta 0.9 - Cosmetically Fixed Contributers
Beta 1.0 - Fixed Couple of Bugs
Beat 1.1 - Massive Rank Calculator Overhaul
Beta 1.2 - Rank Calculator Bug fixes
Beta 1.3 - Added Race Selection and Automated Score Section
Beta 1.4 - Cosmetically Fixed TroopWorker Ratio and Information Pages

Known Bugs:
None

ScreenShots:
http://img.photobucket.com/albums/v473/fre...ScreenShot1.png
http://img.photobucket.com/albums/v473/fre...ScreenShot2.png
http://img.photobucket.com/albums/v473/fre...ScreenShot3.png
http://img.photobucket.com/albums/v473/fre...ScreenShot4.png
http://img.photobucket.com/albums/v473/fre...ScreenShot5.png

Download Link:
http://files-upload.com/files/595222/AllinOneCalc.xls
http://www.2shared.com/file/2453588/3d7a8c...linOneCalc.html

Please Post here or PM me with any bugs, or features you would like added.


EDIT: Online Recruiting Calc: http://spam.redial.net/WoECalc.php

Very nice work Geno ;)

Sorry. You can not download this file today. Download traffic for your country is empty.

Noooooo!!!!

Added a second download link for those where thr first link doesnt work

Yay it worked! For a min there I thought you had something against us americans.

nice work :)

Updated now its Beta 0.9 Check out the latest version!!

All good work Geno :D you could possibly automate it a bit & centralise all info to come from one page, your choice! It's cool though. Anyone produced an optimal upgrade calc? Been puxxling over this one last night & haven't gotten it quite right. It also seems kinda long winded & troublesome at the moment ;)

Weve found a slight bug this will be fixed soon

We have talked about this, and decided its not the best idea, as people will want to keep separate things on different pages. Such as keep the same troops on the recruitment page, but mess around on the score page and see what they can get.

Added Known Bug list to the first post

You could always include manual inputs to override the input screen details, twas just a thought :D

Right now were (Rubgish) are adding some sort of Race thing that auto inputs your race bonuses Rubgish can explain it better :P

If you need any assistance give me a shout, I'm happy to give any assistance you'd like

We mainly need people to scour through it and find bugs!

I can have a look see what I find. As a first note you've not included Forge or Armoury in the ranking calc. What was the previous bug if you don't mind me asking.

If you want to discuss off forum drop me a PM & I'll forward my MSN or Yahoo ID ;)

Forge and Armoury levels dont matter as they stand its all correct ;)

and its in the first post

Beta 1.4 OUT NOW!!

i'm in shock over Geno doing something useful!!!

nice job.

I was the one who got the Woekipedia....

And its not only me its Rubgish too ;)

Hehe, nearly all of the coding since beta 0.5 is me, Geno is just good at the making stuff look nice and pointing out bugs to me, plus he put all the hard graft in at the start :D I'll just come along at the end and take all the credit :P

and steal everything i start to work on

like our newest addition

While i was typing stuff in ranking calc, I had one of the square, Siege that changed to " #VALUE! " and the result of the ranking point became #VALUE! too ... I just exit and came back ( Of excel document without saving) and it came back to normall...

Hmmm Nothing I can think of could you posibbly get it to do it again and take a screenshot?

that happens in excell when the a cell is referencing another cell and expecting a number and finds any type of no numberical symbol instead, for example when I hit the \ button as I hit enter, if I meant to say 18 and I say 18\ instead it messes up the rest of the referring cells.

not sure that is what you are talking about but I know that is how I get it

I think Acneboy is right here, did you try and type in the name of the siege in the siege level box?

I only went through "rank points". comments on "Rank points":

1. Construction research is not taken into consideration.

2. Every figure should be rounded DOWN.

3. Armory / forge not taken into consideration.

4. Defense calculation is incorrect.

5. Troop attack/heath taken incorrectly. Bhaal mentioned bonuses are multiples not additives. In the calculations it s taken as additives.

6. Rank points for troops incorrect due to same error.

I tested for humans only, and have absolutely no time these days. But i ll prove my points.

point 4:

For humans wall lvl 15 (citadel) gives 46000 basic value.

Now if we calculate rank points for this we get 46000 * 0.025 = 1150. On the calc, with all others set to 0, if we just put wall lvl 15, we get 2250 rank points. 1100 more rank points.

If we take 20% construction bonus then the value would be 46000 * 1.2 * 0.025 = 1380 rank points.

so to get 2250 there should be some radical error in calcs.

point 5:

So if u take 1 heavy troop and put 0.25 exp bonus and .2 medicine and tactic bonuses:

Attack power = 50 * 1.2 * 1.25 = 75
Health power = 41 * 1.2 * 1.25 = 61.5 (61 after rounding down)

In ur calc's those are taken as:

Attack power = 50 * (1.2 + 1.25) = 72.5
Health power = 41 * (1.2 + 1.25) = 59.45

point 6:

Same error. Take bonuses as multiples and u ll get the correct answer.

Edit : If we put the wall strength value as 46000 we get the correct answer. But then again if u use lvl 15 then the answer is wrong. So have a connection between two two text boxes so that with the change of one the other will give the exact value.

For an example, if it s lvl 15 and construction lvl 4 then the wall strength will be 55200 for humans.

But the calc is neat and user friendly. Keep it up!!!

Thanks for the bug testing HH, feel free to do some more :D And as for the rounding down, i'm not sure how to do that on excel, so if someone can give me a shout as to tell me how then that would be great.

I'll add armoury and forge now, and make everything multiples.

If anyone knows the right defence calculation that would be great, currently its down as:

(Strength*0.025)+((Level*Level)*10)

Not sure what the level bit there is meant to be, cause thats were the wrong values come from. Once thats sorted i'll add construction to that as well.

the level*level bit was taken strait out of the rank formula

Also this was working fine before you played with it Rubgish according to Robius anyway

So it has to be your editting somewhere

I never touched the ranking formula :D Either the formula there is wrong or HH has it wrong. Either way, when it comes down to it, that 15*15*10 is exactly the same for every race, so it doesn't affect the difference between scores anyway.

An update should be out tonight :)

That s correct

Adding auto wall strength would be hard and would use too many IF commands as far as i can think of the top of my head so out the question unfortunatly

roughly 90 if commands involved, just isn't worth it.

U dnt have to use any IF commands. Have something like when someone selects the particular race the basic wall strength of that race will be saved to a variable or a hidden cell.

So originally is u run with 6 IF commands or using "case" then u can embed that in that original code rather than adding another code.

Edit: I think u can find some correlation between basic wall strength of each lvl. So u can multiply the variable part and add the fixed component and get the final figure. But if there s no correlation then that wont be possible.

Of course, i thought that is wasn't a fixed increase for each level, its only actually 21 if commands.

U dnt need any IF commands what so ever if u can make an equation for wall strength (basic) for each lvl. Say wall lvl is x and wall strength is y. Then u read the input to x and calculate y. And anyway u have to have bonus % for each race to calculate rank points, so multiply y by (1+bonus %) and u ll have it.

User would need the calc not only to find out his score. But also to figure out his opponent's score of another race. Or rather before selecting a particular race he would want to get the finer details regarding rank.

HH, what is needed is the following:

=If(Wall_level=1,Defence=200*(IF(Race="Gnoll",1.2,IF(Race="Human",1.1

etc etc, it all has to be done with if commands somewhere.

Rubgish, do u have base strengths for each lvl? If so can u post it here?