ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Vikings Materials & Equipment
2
Version 1.1
3
4
How to Use
5
This spreadsheet is set up to need minimal user changes.
6
Once you enter the materials and choose what you need, it will show you your progress towards those goals.
7
1Save this document for your own use. (File -> Make a Copy)
8
2Enter your materials in the "Materials" Tab. Click here:Materials
9
This is easier to do if you can access the game on the computer and see the list of materials in the Forge.
10
I have kept my materials in there so you can see how it works. Delete mine before entering yours.
11
The Standard Materials are highlighted in yellow to make them easier to spot.
12
If you only want to change one Invader's drops, type its exact name into the blue box. Its items will highlight.
13
DO NOT CHANGE THE MATERIALS ON ANY OTHER SHEET. THEY PULL FROM THIS ONE.
14
3If you want to see how close you are to Invader sets, click here:Invader Items
15
4When you've created equipment necessary for a special item, click the check box corresponding to it.
16
The yellow highlighted items are availabe to be made based on the materials you currently have.
17
5When you've created a special item, click the check box corresponding to it.
18
Note that amulets have two boxes, one to either side of the name.
19
6Minimize the sections that you don't need in Special Equipment
20
21
If I update this sheet and come out with a second version, all you need to do is replace the Materials and update the Special Equipment sheet with your preferences.
22
23
ProgressSuggested order:HeroShaman
24
Guardsman (Invader)Guardsman (Invader)
25
59.30%KnowledgeKnowledge65.47%Inga--Knowledge
26
69.24%BuildingBuilding60.08%Baggi--Building
27
59.47%Troop 1
Whatever your preferred troops are
28
87.80%Lynx (Defense)Lynx (Defense)
29
73.49%TrainingTroop Training
30
83.45%Centurion (Rss gathering)
Centurion (Rss Gathering)
31
79.37%Troop Capacity? (looting)Troop Capacity
32
33
34
35
To Do:
36
done1a
Add a sheet that includes all items, then allow a search function to return the progress on that item.
37
1b
Once this is done, provide a list of materials that are needed to complete this item if it is unfinished
38
2
Create sheet that ranks the invaders according to which materials are needed the most.
39
3
Highlight Uber drop items in "materials"
40
41
Change Log:
42
1.0
Created and published the spreadsheet
43
1.1
Added Shaman tab, renamed "Special Equipment" to "Hero Equipment"
44
Added checkboxes next to T2 Hero Equipment
45
Added invader sets (Guardsman, Lynx, Centurion) in Invader Items tab
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