v0.8.13 (Troubling Times) active on Google Play

Useful links
Source code of the game - Contribution guide - ATCS Editor - Translate the game on Weblate - Example walkthrough - Andor's Trail Directory - Join the Discord
Get the game (v0.8.13) from Google, Github, F-Droid, our server, or itch.io

Andor's Trail Battle/Stat Calculator

A place for general discussion about the content and gameplay of Andor's Trail.
Jon
Posts: 5
Joined: Thu Jul 26, 2012 1:45 am
android_version: 2.3 - Gingerbread

Andor's Trail Battle/Stat Calculator

Post by Jon »

Hello everybody,

I recently discovered this forum when wondering how the attack and block chances worked in the game. Fortunately, you guys made that information easy to find (it's in the wiki). When I saw how the battle system works, though, I realized that it is completely non-obvious how a change in one's stats will affect the outcome of a battle. This gave me the idea of creating a calculator will provide this information.

You simply need to plug some easy-to-find information into the calculator, and it will spit out some useful statistics, such as your hit probability, your average damage per swing (each time you press attack), your average damage per turn (each time you refill AP points in battle) and the average number of periods required to kill your opponent.

For simplicity, the calculator makes the following assumptions:

1.You will always attack in battle (it does not explicitly account for the use of healing items or moving)
2.There are no status effects imposed on you or the opponent

If somebody has any ideas on how to model any of those assumptions into the calculator to make it more robust, please let me know. Regardless, I think that the information it provides is still useful, only you will have to strategically account for healing item usage, moving, and status effects.

Image

This is how the calculator works:

1. In the left table, plug in your statistics and the monster you're fighting's statistics. Only the green spaces need to be filled in, as the red are calculated automatically. Your statistics can be found in-game by pressing the image of your character in the left-hand corner of the game, under the "Overview" tab. A monster's statistics can be found by clicking "Info" in the battle initiation prompt, or during battle by clicking the icon of the monster underneath the attack button (or in Pyrizzle's Bestiary). For all statistics, if you cannot find the value, just leave it at 0. The information in this table will be your current battle information.

NOTE: Do not use percentage signs anywhere in the calculator - it automatically converts from numbers to percentages. Thus, a 162% attack chance should be entered as 162, a 9% effective critical chance should be entered as 9, and a 63% block chance should be entered as 63.

2. Next, to see how a change in your stats will affect a battle, fill out the middle table, which asks for the stats you wish to see changed and by what magnitude of an increase or decrease they are changed by. These numbers can come from equipment and leveling or skill upgrades. For an increase, simply enter a positive number to represent the increase. For a decrease, use a negative number.

3. The table to the right should now show the updated battle statistics, given the change inserted in the middle table.

4. If you wish to use the calculator for comparison purposes, you may copy the middle and right-most table, then paste it directly below. Simply repeat step 2, using different increase/decrease parameters for the copy. This can be done as many times as desired. This method is especially useful when deciding what equipment to purchase, or what skills or stats to upgrade. See the picture below for a visual example.

Image

NOTE: To most easily and accurately see the effect of a change in equipment, you should remove any equipment that you are questioning replacing, then fill out the left-most table. You can then use steps 2, 3, and 4 to reflect an increase/decrease in statistics as a result of using the different pieces of equipment. Alternatively, you may keep your equipment on, but make sure you use the middle table to represent the difference in the piece of new equipment's statistics and your currently equipped equipment's statistics. That is, either way you do it, make sure you account for the loss or gain in statistics that occurs from unequipping a piece of equipment you are currently using.

I have attached the calculator to this post as an excel spreadsheet. I would have made it a Google Doc, but Google doesn't provide the option to make the document both view-able and editable, but not save-able. This would mean multiple people using it at the same time would pretty much break it. Plus, someone may accidentally tamper with it. I figure using excel is the most low-maintenance option and makes it more customizable for you. Please request a different file format if you cannot open excel files.

Also, I may come out with a new version that recommends what choices you should make when you level up your character (+5 HP, +5% Attack Chance, +1 Damage, or +3% Block Chance)

To make using the calculator easier, especially if you don't have some information readily available here are some useful resources created by other users:

Bestiary by Pyrizzle
Gear List by JohanX

Additionally, you may wish to use the opponent search feature. This requires downloading the .xlsm file. When using opponent search, simply click on the box that contains the list of monsters and pull down the dropdown list. Choose the monster you are looking for, then press search.

I hope you find this calculator both useful and fun (try plugging in other players' stats into the opponent column and see how you stack up). Now, instead of merely speculating on what equipment or upgrade is preferable over another, the calculator can actually give you a reasonably good idea. If you have any ideas on how to the calculator better, please let me know.

--------------
Change Log
--------------
V2.
Other minor consistency changes

V3.
Changed some wording
Changed the color of "Total AP" for the Opponent from Red to Green (thanks phydeaux)
Updated the Hit Probability to reflect the current version's battle system by removing the 50% minimum (thanks ncer)
Added a searchable database of every monster's stats - filling in the opponents' stats is now automated (requires the .xlsm file). See the screenshot below.

Image

V4.
Fixed the right-side table's hit probability calculation
Added a "None" option to the Opponent Selector
You do not have the required permissions to view the files attached to this post.
Last edited by Jon on Fri Jul 27, 2012 3:23 am, edited 7 times in total.
phydeaux
VIP
Posts: 339
Joined: Fri Dec 09, 2011 7:40 am
android_version: 5.1 - Lolipop
Location: Gargoyle cavern, blindly hacking mobs to pieces till I find a rols!
Contact:

Re: Andor's Trail Battle/Stat Calculator

Post by phydeaux »

Interesting, just one thing, not all mobs have 10 ap. :)
Welcome to the forums, and happy hunting :D
Jon
Posts: 5
Joined: Thu Jul 26, 2012 1:45 am
android_version: 2.3 - Gingerbread

Re: Andor's Trail Battle/Stat Calculator

Post by Jon »

phydeaux wrote:Interesting, just one thing, not all mobs have 10 ap. :)
Welcome to the forums, and happy hunting :D
Ah, I never noticed - I'll update the spreadsheet, though it still shouldn't be a problem if you change the Opponent AP parameter.

Thanks for the warm welcome.

EDIT: Actually, can I get a clarification? I noticed that on these forums "AP" is sometimes used to denote the amount of AP used in an attack. I meant for it to be used as a measure of a monster's total AP. I am using the "Attack Cost" parameter as a measure of the amount of AP used in an attack. Which one were you referring to? I'll try to make things more clear in the calculator.
phydeaux
VIP
Posts: 339
Joined: Fri Dec 09, 2011 7:40 am
android_version: 5.1 - Lolipop
Location: Gargoyle cavern, blindly hacking mobs to pieces till I find a rols!
Contact:

Re: Andor's Trail Battle/Stat Calculator

Post by phydeaux »

Ap = action points
You use ap to do everything during battle, from attack to heal to flee to change gear
Jon
Posts: 5
Joined: Thu Jul 26, 2012 1:45 am
android_version: 2.3 - Gingerbread

Re: Andor's Trail Battle/Stat Calculator

Post by Jon »

phydeaux wrote:Ap = action points
You use ap to do everything during battle, from attack to heal to flee to change gear
Ok. And when you say "mobs," does that refer to multiple monsters? I'm not very familiar with the terminology. I should find a way to include multiple monsters into the calculator anyway.

For instance, is it that two monsters together have 20 AP, or can one have more or less than 10 AP on its own?
Sarumar
VIP
Posts: 3275
Joined: Sat May 07, 2011 4:36 pm
android_version: 4.1 - Jellybean
Location: www.hel.fi

Re: Andor's Trail Battle/Stat Calculator

Post by Sarumar »

Welcom to the forums !

Nice to meet someone like me who loves excel. Nice work :!:
Sarumar
..dansing left foot polka with Hirathil

Lvl 313|XP 559721474|Gold 7965188|AP 3/12|AC 516|AD 161-175|ECC 48|CM 6|BC 311|HP 591|DR 2|RoLS 3|RoL 2|ElyR 2|ChaR 45|GoLF 3|ShaF 9|SRoV 28|VSH 13|GoW 1|WMC 1
phydeaux
VIP
Posts: 339
Joined: Fri Dec 09, 2011 7:40 am
android_version: 5.1 - Lolipop
Location: Gargoyle cavern, blindly hacking mobs to pieces till I find a rols!
Contact:

Re: Andor's Trail Battle/Stat Calculator

Post by phydeaux »

Mob = monster object
So, yes, mobs is plural for monsters... I'm completely phone based, and auto correct changes monster to minarets, so I use the mob abbreviation instead :)
ncer
Posts: 121
Joined: Sun Oct 16, 2011 8:40 am
android_version: 2.2

Re: Andor's Trail Battle/Stat Calculator

Post by ncer »

Is it correct that an opponent's hit probability is always at least 50%? Having a block chance of 199% and very rarely getting hit I would guess that is not correct? The page I found on the wiki is for 0.6.6, perhaps the combat system has been changed since then?
Lvl: 195, XP: 135178554, Gold: 1004501
HP: 88 AC: 345%, AD: 109-120, AP: 5, ECC: 15%, CM: 0, BC: 222%, DR: 6
RoLS: 2, ElyR: 1, RoL: 1, ChaR: 1, GoLF: 1, ShaF: 1, SRoV: 1, VSH: 2, WMC: 0, GoW: 0
Jon
Posts: 5
Joined: Thu Jul 26, 2012 1:45 am
android_version: 2.3 - Gingerbread

Re: Andor's Trail Battle/Stat Calculator

Post by Jon »

phydeaux wrote:Mob = monster object
So, yes, mobs is plural for monsters... I'm completely phone based, and auto correct changes monster to minarets, so I use the mob abbreviation instead :)
Ok, thanks for your help. I found at least one monster that has an AP of 5, but since that information isn't readily available within the game (as far as I'm aware), I might try to build in a drop-down list to automatically fill in monster statistics.
ncer wrote:Is it correct that an opponent's hit probability is always at least 50%? Having a block chance of 199% and very rarely getting hit I would guess that is not correct? The page I found on the wiki is for 0.6.6, perhaps the combat system has been changed since then?
You would be correct. I just checked the source code of the newest version and the 50% minimum has been removed. Everything else in the battle system appears to have remained intact.
SirGrindsalot
Posts: 76
Joined: Fri Jul 20, 2012 1:04 am
android_version: 2.0

Re: Andor's Trail Battle/Stat Calculator

Post by SirGrindsalot »

phydeaux wrote:Mob = monster object
So, yes, mobs is plural for monsters... I'm completely phone based, and auto correct changes monster to minarets, so I use the mob abbreviation instead :)
http://en.wikipedia.org/wiki/Mob_(computer_gaming)
NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO
Mobile!!

lol youngsters, they don't know this stuff
Post Reply