Search
View: 23197|Reply: 61

Combat Simulator (I made one) [Copy this link to quote]

Rank: 8Rank: 8

Point
4075
UID
664173
Post time 28-1-2010 06:53:08 |Show all posts
Post Last Edit by 553288752@facebook at 11-2-2010 13:20

Based on a formula I have found on this forum, as well as some others from Travian, I have made a combat simulator with Excel. Everything is updated and works.  Just needs data to verify the correctness of the equations.  Every possible variable has been taken into account.  However, if you upgraded units, you need to change values yourself.

EDIT:  I lied.  This does not calculate the Escort Guardian battles.  In order to do that, I need more data.  Can everyone instead post their Escort Guardian battle reports here?  Also, many aspects of Hero influence are still missing (armour and weapon values, scrollpurse, etc.), and the influence of the formations on each other (restriction) are not taken into account.  I would appreciate everyone's input.

EDIT:  PLEASE DO NOT PM me with your emails anymore.  If you have, against all common sense, posted your email in public view on the forum,please remove it.  Number-that-starts-with-a-6 has kindly pointed out that I can just upload the file to my post here, so you can all obtain it at will!

EDIT:  For those of you that have downloaded version 0.9.9, there was an error.  The defender's losses did not calculate correctly.  They do now.  In the new .zip, there is an Excel 1997-2003 version (.xls) and an Excel 2007 version (.xlsx).  Make sure you open the correct one.

Now let's face it.  Not everyone is going to read the readme, so to preempt the thread being flooded, I'll say it here (it's in the readme, too, but you didn't read it, did you?)

- "OMGWTFBBQ, my Excell 1997-2003 version has a butt-ton of #DIV/0 and #VALUE errors!  You f****d up!  Fix it!"
- Those aren't errors.  Well, they are, but I didn't f*** up.  In 2007, there is a function that allowed me to make everything pretty.  It doesn't work in earlier versions.  Deal with it.  Once you've inputted the numbers, you'll be fine.

- "I've inputted the numbers, and I'm NOT fine!  There are still errors!"
- Don't worry.  Use the trace function (click the little (!) beside the error) to find out where it starts.  If it is a #DIV/0, then you need to put in a number somewhere.  If it is a #VALUE, you need to remove instructional text somewhere and replace it with a number.  To avoid this problem entirely, put in everything IN THE ORDER mentioned in the readme, which you didn't read, right?

TKO Battle Calculator 0.9.9.4 with .xls.zip

37.7 KB, Downloads: 6558

Two versions: 1997-2003, and 2007

Have 1 people ratedPoint Pack Reason
aprillyw@hotmai + 12

Total score: Point + 12   View Rating Log

He who asks is a fool for five minutes, but he who does not ask remains a fool forever.

Rank: 1

Point
7
UID
509837
Post time 2-2-2010 18:28:13 |Show all posts
hey i want one, i want to test ur formula, how about you send it by email veen_cent@hotmail.com, my microsoft office 2007 on  WIndows 7, thanks alot bro

Use magic Report

Rank: 1

Point
6
UID
814604
Post time 2-2-2010 21:33:18 |Show all posts
2# 700194927@facebook


Hi,

Could you send me one copy to lvungtau@yahoo.com

Thanks a lot.

HLong

Use magic Report

Rank: 1

Point
1
UID
837351
Post time 3-2-2010 00:08:45 |Show all posts
hi,

one to dragonchan427@yahoo.com please,

thanks very much

Use magic Report

Rank: 1

Point
13
UID
420989
Post time 3-2-2010 01:16:28 |Show all posts
Hi!
I want one. huangguan028@gmail.com.
Windows XP.
office 2003.
thanks.

Use magic Report

Rank: 2

Point
29
UID
848617
Post time 3-2-2010 01:23:22 |Show all posts
1# 553288752@facebook

Hi could i have a copy too ^^

bentley388@hotmail.com

cheers.

Use magic Report

Rank: 2

Point
24
UID
542737
Post time 3-2-2010 02:11:49 |Show all posts
hi.,

please send me a copy too....^-^

mulya_sugata@yahoo.com
windows xp


ty

Use magic Report

Rank: 2

Point
20
UID
432743
Post time 3-2-2010 05:21:57 |Show all posts
please send me
penjahit1@gmail.com

office 2007

Use magic Report

Rank: 1

Point
13
UID
469661
Post time 3-2-2010 16:13:25 |Show all posts
wouldn't it just be easier to post your 'simulator' into a zip file attachment so that others can paruse it?

Use magic Report

Rank: 8Rank: 8

Point
4075
UID
664173
Post time 3-2-2010 19:46:42 |Show all posts
wouldn't it just be easier to post your 'simulator' into a zip file attachment so that others can peruse it?
612567698@facebook Post at 4-2-2010 07:13


Aaaaaand so it would.  I just figured out how.  Thanks for stating the incredibly-obvious-just-not-to-me, number-that-starts-with-a-6.  Will attach to original post.
He who asks is a fool for five minutes, but he who does not ask remains a fool forever.

Use magic Report

Rank: 2

Point
26
UID
410868
Post time 4-2-2010 01:52:55 |Show all posts
Hi,

Could you attach excel version 2003 file of the simulator please? Thanks

Use magic Report

Rank: 1

Point
1
UID
928232
Post time 4-2-2010 08:11:24 |Show all posts
thanks bro

Use magic Report

Rank: 2

Point
89
UID
608099
Post time 4-2-2010 23:43:06 |Show all posts
From cursory glance, your formula appears not to take into account weaponsmith and armorsmith upgrades, including individual upgrades.  Also, how about the city wall levels, and city wall devices (rolling stones/blindages etc)?  It probably does not factor in the morale of troops due to the heros' battles as the precursor to the actual fight.  Am i right?

Use magic Report

Rank: 8Rank: 8

Point
4075
UID
664173
Post time 5-2-2010 00:11:07 |Show all posts
From cursory glance, your formula appears not to take into account weaponsmith and armorsmith upgrades, including individual upgrades.  Also, how about the city wall levels, and city wall devices (rol ...
100000019038526@facebook Post at 5-2-2010 14:43


Read the readme.  In fact, read my first post.  I have asked that you update the values for your upgraded soldiers yourself.  City Wall and all devices are taken into account.  Unless I uploaded a previous version, and not the current one.  Morale boost from before battle is a hidden value - something I have not been able to find, much like the Ram/Demolisher's effect on cities.  As to troop death, everything really is taken into account, other than Escort Guardians, which I will include once I get battle reports.  Many, many battle reports.
He who asks is a fool for five minutes, but he who does not ask remains a fool forever.

Use magic Report

Rank: 1

Point
7
UID
862219
Post time 5-2-2010 11:45:42 |Show all posts
I downloaded it but after converting it for Excel 2003 there are errors in the table coz of the unknown formula =_xlfn.IFERROR(...
can anybody rewrite that ? ??
I heard there is w way to replace the formula with Excel2003

plzzzzz help me, wanna go into severe FIGHTING and kill my neighbor (who unfortunately is in MY 7x7 territory)
THX !!!

Use magic Report

Rank: 2

Point
17
UID
310493
Post time 9-2-2010 08:50:41 |Show all posts
Any chance to add support for "bandit" units like the kind guarding an oasis?

Use magic Report

Rank: 2

Point
17
UID
310493
Post time 9-2-2010 09:00:54 |Show all posts
16# 1254438666@facebook

Nevermind, I'm an idiot. Didn't scroll to the left. Great job!

Use magic Report

Rank: 2

Point
89
UID
608099
Post time 10-2-2010 02:46:15 |Show all posts
Hi,

1. How did you come up with the attacker & defender losses? Does not seem to work, what could i have done wrong?

2. Just to confirm, cavalry, pioneer, lobbyist are NOT affected by Traps?

3. Game Play question - how do you attack with a mixed force from different countries? (v9.9.2.4 cell K2 - option 4 )  I can understand the bit on supporting defense, but not sure how to do coordinated attacks.

4. Archers in/out of towers - Not too sure how to see from your excel on this matter... blindages are said to affect and their defense=attack from the in-game advisor....  Do you resolve battle for city wall (archers) first before a pitch battle happens in city, i.e. a 2 phased battle, or its a single phased battle resolution?

Apologies for asking so many questions, your excel really piqued my interest in understanding the battle logic.

Use magic Report

Rank: 2

Point
89
UID
608099
Post time 10-2-2010 03:24:37 |Show all posts
Forget point 1 - my butter fingers keyed something i should not have....

Use magic Report

Rank: 3Rank: 3

Point
257
UID
135650

First Lieutenant

Post time 10-2-2010 06:07:39 |Show all posts
consider writing it into a VB.net program.
//SunLeung

Use magic Report

You have to log in before you can reply Login | Register

Archiver|Koramgame

23-1-2018 07:08 GMT-7 , Processed in 0.012882 second(s), 14 queries .

Powered by Discuz! X2

© 2001-2011 Comsenz Inc.

To Top