Strongholds - Info Spreadsheet
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Created by JayAgeDee of the awesome guild "Besser Du als Ich".
2
Version History:
Questions and bug reports at u/jayagedee on reddit.
3
28.09.15Created
4
29.09.15
Added missing lower sections
5
Added PVP support structures with total PVP calculation
6
02.10.15
Calculator for YOUR guild. Enter coffer values and check buildings you already built to calculate your progression %.
7
10.10.15
Fixed %Progress calculation as I was using an old version's formula. Credits go to boltzmann42 for the discovery.
8
10.03.16
Updates for value changes MOD 9. Renamed TABs to "mod 8" and "mod 9".
9
VALUES ARE: UP TO DATESPREADSHEET IS CURRENTLY:NOT UNDER CONSTRUCTIONVALUES FOR PC AND CONSOLES ARE:IDENTICAL22.05.16
Update to the calculator, all buildings and all ranks. Includes alliance multiplicator and choice to include certain structures.
10
11
CALCULATORAlsoMY STRONGHOLD GUIDES ON REDDIT:
12
13
14
MY UNDERDARK GUIDES ON REDDIT:
15
How does the calculator work?After copying this ENTIRE sheet into a new one, simply enter the values of YOUR current guild depot/coffer below under "coffer" and mark which building ranks you have constructed already (note that all except shards, gold and AD are *1000).
16
But how do I tell the calculator I built something?Under the "PROGRESS" column you can substitute "built" for "pending" in order to signal the sheet this specific rank has been finished (without the " "). It should then show you how much you still need.
17
What are the options for?
Every guild has a different plan in mind. Also guilds will have different alliance bonuses depending on their position within the alliance and their alliance's level. Just set the options to your guild's current situation.
18
MY MAZE ENGINE GUIDES ON REDDIT:
19
Options:Alliance structure discount:0%Build a second warehouse?yes
20
Average Progression:
21
Which boon structures did you decide for?Temple:yesBarracks:yesStable:yesWizard's Workshop:yesMAIN:0%
22
23
Training Yard
no
Merc Outpost
noBoon structuresExplorer's Guild:noTOTAL:0%
24
25
MAIN TARGET:
GH 12, marketplace 6, and 4 other structures rank 5. No boon structures.
TOTAL:
All possible PVE structures to max level. 4 selected boon structures.
26
27
IN DEPOT:IN DEPOT:
28
Coffer:000000000000000Coffer:
Insert YOUR guild's current depot/coffer standings.
29
30
Left for MAIN:
7.1145111370420005860043200059141310158917542143100812980
Shows negatives if coffer values are above "Left for Main", if so, you should already have reached the main target and you can ignore it.
31
Left for TOTAL:
84.610100626501477003778002088008140023892.4601476299549100573609.266820
This will update as you change options.
32
33
% MAIN:000000000000000% Progress
Progression percentage based on what you have built and what is currently in your depots. Calculated for buildings included in the main target.
34
% TOTAL:000000000000000% Progress
Progression percentage based on what you have built and what is currently in your depots. Calculated for all possible PVE buildings.
35
36
PVE STRUCTURES
37
38
39
40
41
Guild Hall:
(Rank 1 is achieved by default)
42
Rank 20.13210060060015Rank 2pending
43
Rank 3632001100435215Rank 3pending
44
Rank 40.330016002044722Rank 4pending
45
Rank 50.412640021009959Rank 5pending
46
Rank 60.51585002700128Rank 6pending
47
Rank 70.61896003200408128Rank 7pending
48
Rank 87003700370010817950Rank 8pending
49
Rank 90.8252800544198118Rank 9pending
50
Rank 100.9284900480014065Rank 10pending
51
Rank 111100053005300679256Rank 11pending
52
Rank 121.1347110017023580Rank 12pending
53
Rank 13130065006500822300180Rank 13pending
54
Rank 141.742115007200343Rank 14pending
55
Rank 151.946417008000227106Rank 15pending
56
Rank 162.151119008800346240Rank 16pending
57
Rank 172.4210097001210275Rank 17pending
58
Rank 182.7620240010700484504Rank 18pending
59
Rank 192.7682270011800334462155.4Rank 19pending
60
Rank 203.3751300013000587Rank 20pending
61
TOTAL:22.5490023200363004200038600038671301121416681462493.46120
62
MAIN TARGET:
5.71451660096001280012300018354654062976152321920
63
64
Marketplace:
65
Rank 1100130023303622Rank 1pending
66
Rank 20.2150190034535616Rank 2pending
67
Rank 321028002122346Rank 3pending
68
Rank 40.428036002788510530Rank 4pending
69
Rank 53404500781233775Rank 5pending
70
Rank 60.84105300124147154Rank 6pending
71
Rank 7470610047310750103Rank 7pending
72
Rank 815206800521196Rank 8pending
73
Rank 9580750013020661126Rank 9pending
74
Rank 101.3680840019923424669.3Rank 10pending
75
TOTAL:3.703740048200001484372438799757286.33720
76
MAIN TARGET:
1.401490019400004901352393593151061430
77
78
Warehouse:
79
Rank 170240021222718Rank 1pending
80
Rank 21103600208475035Rank 2pending
81
Rank 3130520071725952Rank 3pending
82
Rank 41606800758056101Rank 4pending
83
Rank 5200840043383174163Rank 5pending
84
Rank 6230100009221868148Rank 6pending
85
Rank 72701160067020424176Rank 7pending
86
Rank 83001280011383Rank 8pending
87
Rank 93301410012529391.3208Rank 9pending
88
Rank 1037016000924281Rank 10pending
89
TOTAL:002170090900002235556658830467409.35270
90
MAIN TARGET:
0067002640000641226173296249911710
91
92
Mine:
93
Rank 170150013922341618Rank 1pending
94
Rank 211022004764527Rank 2pending
95
Rank 3130320030171725171Rank 3pending
96
Rank 416042003937514856Rank 4pending
97
Rank 5200510043399174124Rank 5pending
98
Rank 6230610057811721868Rank 6pending
99
Rank 72707100102253171Rank 7pending
100
Rank 8300790073722526683Rank 8pending