Title: All in One Calc for War of Empires
Description: Now Featuring an Online Recruit Calc
Genocide - October 31, 2007 12:30 PM (GMT)
Created by Genocide and Rubgish
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
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
daviep - October 31, 2007 12:54 PM (GMT)
Trollvana - October 31, 2007 01:12 PM (GMT)
Sorry. You can not download this file today. Download traffic for your country is empty.
Genocide - October 31, 2007 01:19 PM (GMT)
Added a second download link for those where thr first link doesnt work
Trollvana - October 31, 2007 01:23 PM (GMT)
Yay it worked! For a min there I thought you had something against us americans.
Nosiin Arayla - October 31, 2007 01:29 PM (GMT)
Genocide - November 1, 2007 06:58 PM (GMT)
Updated now its Beta 0.9 Check out the latest version!!
Mawhrin Skell - November 1, 2007 07:12 PM (GMT)
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 ;)
Genocide - November 1, 2007 07:16 PM (GMT)
Weve found a slight bug this will be fixed soon
Rubgish - November 1, 2007 07:18 PM (GMT)
|QUOTE (Mawhrin Skell @ Nov 1 2007, 07:12 PM)|
| 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 ;) |
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.
Genocide - November 1, 2007 07:21 PM (GMT)
Added Known Bug list to the first post
Mawhrin Skell - November 1, 2007 07:32 PM (GMT)
|QUOTE (Rubgish @ Nov 1 2007, 07:18 PM)|
| 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. |
You could always include manual inputs to override the input screen details, twas just a thought :D
Genocide - November 1, 2007 07:38 PM (GMT)
Right now were (Rubgish) are adding some sort of Race thing that auto inputs your race bonuses Rubgish can explain it better :P
Mawhrin Skell - November 1, 2007 07:41 PM (GMT)
|QUOTE (Genocide @ Nov 1 2007, 07:38 PM)|
| 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
Genocide - November 1, 2007 07:42 PM (GMT)
We mainly need people to scour through it and find bugs!
Mawhrin Skell - November 1, 2007 07:51 PM (GMT)
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 ;)
Genocide - November 1, 2007 07:54 PM (GMT)
Forge and Armoury levels dont matter as they stand its all correct ;)
and its in the first post
Genocide - November 2, 2007 09:00 PM (GMT)
daved_helmaker - November 2, 2007 09:19 PM (GMT)
i'm in shock over Geno doing something useful!!!
Genocide - November 2, 2007 09:28 PM (GMT)
I was the one who got the Woekipedia....
And its not only me its Rubgish too ;)
Rubgish - November 2, 2007 09:57 PM (GMT)
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
Genocide - November 2, 2007 10:20 PM (GMT)
and steal everything i start to work on
like our newest addition
WarkaiD - November 2, 2007 10:21 PM (GMT)
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...
Genocide - November 2, 2007 10:24 PM (GMT)
Hmmm Nothing I can think of could you posibbly get it to do it again and take a screenshot?
acneboy - November 2, 2007 11:22 PM (GMT)
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
Rubgish - November 3, 2007 09:41 AM (GMT)
|QUOTE (WarkaiD @ Nov 2 2007, 10:21 PM)|
| 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... |
I think Acneboy is right here, did you try and type in the name of the siege in the siege level box?
Headhunt - November 3, 2007 10:52 AM (GMT)
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.
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.
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
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!!!
Rubgish - November 3, 2007 01:04 PM (GMT)
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:
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.
Genocide - November 3, 2007 01:28 PM (GMT)
the level*level bit was taken strait out of the rank formula
Genocide - November 3, 2007 01:32 PM (GMT)
+(Percentage Experience bonus and research bonuses*0.02)
+(siege research bonuses*0.02)
Also this was working fine before you played with it Rubgish according to Robius anyway
So it has to be your editting somewhere
Rubgish - November 3, 2007 01:34 PM (GMT)
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.
Genocide - November 3, 2007 01:44 PM (GMT)
An update should be out tonight :)
Headhunt - November 3, 2007 01:47 PM (GMT)
|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.|
use keyword "int". That takes the integer part of the answer. for an example int (10.76) gives 10.
Use int for final answers or answers that matters to user. But DO use the exact values with decimals for middle calculations.
|Genocide Posted on Nov 3 2007, 01:28 PM|
the level*level bit was taken strait out of the rank formula
My bad. I totally forgot abt it. But if u can have one text box just to add "Citadel" or "Fortress" would be great. Or u can completely remove the wall strength option and just keep with wall lvl. So if some one has citadel then he ll put lvl 15 there and u can do the calculation. And have a not saying 0-tent, 1-armed camp .. .
|If anyone knows the right defense calculation that would be great, currently its down as:|
That s correct
Genocide - November 3, 2007 01:49 PM (GMT)
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
Rubgish - November 3, 2007 02:06 PM (GMT)
roughly 90 if commands involved, just isn't worth it.
Headhunt - November 3, 2007 02:07 PM (GMT)
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.
Rubgish - November 3, 2007 02:13 PM (GMT)
Of course, i thought that is wasn't a fixed increase for each level, its only actually 21 if commands.
Headhunt - November 3, 2007 07:33 PM (GMT)
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.
Rubgish - November 3, 2007 08:05 PM (GMT)
HH, what is needed is the following:
etc etc, it all has to be done with if commands somewhere.
Headhunt - November 3, 2007 09:40 PM (GMT)
Rubgish, do u have base strengths for each lvl? If so can u post it here?