Marauders' hunting calc.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
To use this spreadsheet it's better to know basics of Illy battle mechanics. The calc assumes that 1) attacking is performed with alike (of the same troop type - cavalry, infantry, etc) commanders leading the same troop type (mixed army requires much more complex calculations); 2) all commanders have Heroism at level 10; 3) You have minimum required troops quantity in the army (61 t2 or 95-110 t1 depending on the race and troop type), distributed between 5 elite divisions, or 4 elite and 1 non-elite if the previous one is not enough; 4) troops are not equipped with crafted. Anti-animal crafted (boar spear, overpadded chains etc) is not to be used here for I could never find out the way its' bonus is calculated, and little did I care to be honest as that bonus is utterly low. Hence avoid it at any cost.
2
3
4
5
6
7
8
9
The calc works as following: NPC's def score is calculated; all commaders attack score is calculated; the difference between the former and the latter shows how much should be covered by troops. Troops number is determined based on that value and single troop attack score calculated with all the applicable modifiers.
10
11
12
13
Cells shaded in green show where values are to be manually entered by user. Yellow ones show calculated values and should net be altered unless you have a good understanding how it all works and what are you going to get. Figures in bold red are key values. To not get confused, input NPCs data first in the 'Defense score' section, then multipliers and, finally, commanders/troops attack values. Troops and NPCs basic attack and defense values can be found by clicking the corresponding unit icon (in scout report or barracks): it will show its' type, level (experience), its' attack and 4 (against each troop type) defense values. If you attack with cavalry, seek 'Defense - Cavalry' figure; eg. ratlings' basic defense against cavalry is 6, elder bucks' is 16.
14
15
16
17
18
19
20
21
Be careful when entering NPCs numbers from scout report. The system often shows NPC levels/tiers at random order. Level 1 NPCs are those that have 'Experience 1' line in their description, Level 2 - 'Experience 2', Level 3 - 'Experience 3' and Level 4 has 'Experience 5' (sic!). Always check those values before you enter NPCs troop numbers. In the end it doesn't matter in which order you put NPCs in the spreadsheet, but it's vital to use corresponding basic defense valuse and terrain modifiers. And keeping the order straight decreases mistake chance. Just as an example: rats L1 is 'ratlings', L2 is 'rats', L3 is 'deseased rats' and L4 is 'elder bucks'.
22
23
24
25
26
27
28
IMPORTANT! I'm gonna repeat it once again as it's a crucial point: always bear in mind that final 'Troops required figure' is subject to 1) minimum amount of troops in the army requirement (61 t2 or 95-110 t1 depending on the race and troop type); and 2) proper troops distribution between divisions. I recommend 1-1-1-1-rest as the easiest.
29
30
31
32
As you would be likely perfoming many similar attacks over and over again (cavalry on plains, infantry in the woods etc), it could be a good idea to copy the calc sheet few times and make several templates with preset commanders, troops and multipliers values; if you often attack the same NPCs, it could be even better idea to make an NPC template (eg. "Cavalry VS Rats on plains ", "Infantry VS Poison crawlers in the woods", etc) with corresponding NPC defense values and terrain modifiers added. It's better to make your calc file 'read only' to not alter it accidentally.
33
34
35
36
37
38
Nuff said. Let's roll.
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...