Elvenar Guest Races
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This spreadsheet is locked for editing. But please create your own copy (File>Make a copy) to keep track of your progress and drop a message at DreamsOfGerontius.com if you find it useful (or not!)
2
Short link to spreadsheet: https://bit.ly/2JxwFIQ
3
Orcs and Goblins guest race
By DreamsOfGerontius.com
Introduction to the Buildings
4
This spreadsheet keeps track of the costs for building and upgrading Orc and Goblin buildings, and for unlocking the research tree
The Orc Portal is the Orc central building. Upgrading it increases Orc resource capacity and the output of all Orc buildings by 20% per level up to level 4
5
It only counts Orc resources and manufactured goods (apart from those required for the research tree), not supplies or gold coins
Mushroom Farms produce 4 different types of mushroom and can be upgraded to level 4 to increase production by 50% per level
6
Cells against a Magenta background are values taken from the game
Rally Points produces 4 different types of orc detritus and can be upgraded to level 4 to increase production rate
7
Cells against an Orange background are table headings and info
The Blooming Trader Guild also increases the output of all orc buildings
8
Cells against a Green background are intended to be edited to update your progress through the chapter
9
Cells against a Blue background use data from other cells
10
Do not edit any cells except the Green ones unless you know what you're doing!
11
12
Resources required to complete chapter
Mushrooms (Mushroom Farm)
Orc Detritis (Rally Point)
13
GemsDustElixirOrcHardshroom
Psychoshroom
Powershroom
Wisdom shroom
ArmamentDungDebrisLoot
14
Total Cost7650077006918526293729750014808947103119007518023800520214320
15
In Storage
16
Left for chapter7650077006918526293729750014808947103119007518023800520214320
17
~Days to complete12139.454.843.644.129412737
18
Farm Total Days
181.9
Rally Point Total Days
133
19
20
Research and Building Costs
Resource Production
21
22
Research Tree Costs
Production bonuses
Orcs
23
The Research Tree requires Wisdom Shrooms and Loot to unlock each tech
Orc Portal
Blooming Trader Guild (Ancient Wonder)
Orcs come from high level armories and some event buildings
24
Gold, supplies and manufactured goods are also required but not included in this list
LevelBonus / %LevelBonus / %
Each top level armory production 520/day
25
Tech
Wisdom Shroom
Loot
Unlocked? (Tick box)
11000100
At least 1 top level armory is recommended
26
Squad Size 252000FALSE
Enter your total daily production
27
City Expansion 334500FALSE
Mushroom Farm Production
Orc production
28
Orc Style Workshop200150FALSE
The output of Mushroom Farms is boosted by the Farm level, Orc Portal and Blooming Trader Guild
per day
29
Orc Style Main Hall175175FALSE
The Portal and Farm level bonuses hugely reduce the time required to complete the chapter
520
30
Orc Style Barracks375275FALSE
Calculations are based on the average level of all your Farms.
31
City Expansion 345500FALSE
In reality, use level 4 Farms to make Wisdom Shrooms while other Farms produce the other shroom types to do upgrades
32
Sinister Cerberus800770FALSE
To see the real production of different levels of Farm, put the level in the box below, otherwise leave it at 0
These are estimated numbers of
33
Elixir800800FALSETest Farm Level0
collections for an medium active player
34
Squad Size 2601250FALSE
Uses "average" farm level unless test value enter above
Change if you are more/less active
Collections neededDivided by no.Divided by no.
35
Dust9501000FALSEResource
Level 1 production
+Farm level bonus
Portal bonusBTG bonus
Total production
Time / hours
Collections / day
to complete chapterof buildings
collections/day
36
Gems850900FALSEHardshroom14014000140121.8212570.8333333339.35185185
37
Rocky Road12001800FALSEPsychoshroom10010000100240.91480.88888949.3629629654.84773663
38
City Expansion 3510000FALSEPowershroom60600060360.6785.055555626.1685185243.61419753
39
Campfire BBQ1750700FALSEWisdom shroom20200020480.4559519.8333333344.07407407
40
Rewards, Kisses etc6002500FALSETotal181.8878601
41
Squad Size 2701000FALSE
Mushroom Farm Costs
Equals approximate number
42
Ancient Wonders20003000FALSE
The production costs of Mushroom Farms also increase with Farm level
of days to produce all resources
43
Total for chapter1190014320
Only upgrading the Portal and the BTG makes production more efficient
required for chapter
44
Remaining to unlock1190014320Resource / CostLevel 1 cost
+Farm level bonus
Cost/unit
45
Hardshroom / Gems
36360.3
46
Orc Portal Upgrade Costs
Psychoshroom / Dust
52520.5
47
The Orc Portal must be upgraded to level 4 to provide sufficient capacity to complete the chapter.
Powershroom / Elixir
1171172.0
48
Each level adds a 20% bonus to all Mushroom Farm and Rally Point production
Wisdom shroom / Dung
40402.0
49
Upgrade costHardshroomDebrisOutput bonus
50
Portal Level 210100175120%
Rally Point Production
51
Portal Level 320000350140%
The output of Rally Points is boosted by the Orc Portal and Blooming Trader Guild
52
Portal Level 430000520160%
The production time of Rally Points decreases with level, but cost and output stays the same
53
To see the real production time of different levels of Rally Point, put the level in the box below, otherwise leave it at 0
54
Current Portal level1
(enter Portal level in Resource Production section at top right)
Test Rally Point Level
0
55
Cost to uprade to level 4
HardshroomDebris
Uses "average" Rally Point level unless test value enter above
Collections neededDivided by no.Divided by no.
56
Total601001045ResourceProductionPortal bonusBTG bonus
Total production
Level 1 Time / hours
With level bonus
Collections / day
to complete chapterof buildings
collections/day
57
Armament100001002.52.58.64751.8250.629.00462963
58
Mushroom Farm Upgrade Costs
Dung450045554.32528.8888889176.296296340.80932785
59
Mushroom Farms can be upgraded to level 4 to gain a huge production boost
Debris30003010102.16173.457.826.75925926
60
It is recommended to build and upgrade at least 30 Mushroom Farms
Loot1200012020201.08119.333333339.7777777836.83127572
61
Upgrade costHardshroomDebrisOutput bonusTotal133.4044925
62
Farm Level 255019150%Rally Point Costs
Equals approximate number
63
Farm Level 3110029200%
Rally Point costs are fixed and do not change
of days to produce all resources
64
Farm Level 4165040250%Costs
required for chapter
65
ResourceOrcs
Psychoshroom
PowershroomArmament
66
Number of FarmsTotal buildingsArmament40
67
Unbuilt or at level 13030Dung40280
68
At level 20Debris40630
69
At level 30Average levelLoot40370630
70
At level 401
71
Production Efficiency
72
Cost to upgrade to level 4
HardshroomDebris
To calculate the resources required to complete the chapter, the cost of each step in the production chain is calculated
73
Total990002640
The results of these calculations are combined with the quantities of each resource required to produce a final tally
74
Cost / unit
75
Rally Point Build and Upgrade Costs
ResourceGemsDustElixirOrcPsychoshroomPowershroomArmamentDung
76
Rally Points can be upgraded to level 4 to decrease production time (bonus to production rate)
Hardshroom0.2571428571
77
It is recommended to build and upgrade at least 3 Rally Points (or build more but level them up less)
Psychoshroom0.52
78
Build/Upgrade costsHardshroomDebris
Production rate bonus
Powershroom1.95
79
Rally Point 134000100%Wisdom shroom1.77777777812.444444442
80
Rally Point 2760073125%Armament0.4
81
Rally Point 311800146166%Dung3.2355555560.88888888896.222222222
82
Rally Point 416000220250%Debris10.921.33333333321
83
Loot6.01250.33333333333.0833333335.25
84
Number of Rally Points
85
Unbuilt3Total buildings
Dark blue figures in the above are cumulative costs from previous steps in the production chain
86
At Level 103
The Orc / Loot value ignores the cumulative costs of the Orc / Armament
87
At level 20
88
At level 30Average level
89
At level 401
90
91
Cost to upgrade to level 4
HardshroomDebris
92
Total1164001317
93
94
Orc Trails
95
Orc Trails cost Hardshroom, Powershroom and Debris
96
Enter the numer of steps of road in your city left to upgrade (you should leave upgrading trails until near the end of the chapter)
97
Number of steps
Cost per step
98
of roadHardshroom
Powershroom
Debris
99
50440594
100
Total cost220002950200
Loading...
 
 
 
Orcs
Woodelves
Sorcerers and Dragons
 
 
Main menu