Shop Titans Guild Tick & Goal Tracker

	B	C	E	H	I	K	L
1
2
3			Welcome to Shop Titans Guild Tick & Goal Tracker! Created and Maintained by gumdrops#2650 Shareable Link: https://bit.ly/shoptitansticktracker			Localisations:
4						Deutsch	Link
5
6
7
8	What is different to Gunnolf25's Building Tracker sheet? Why should I use it? I wanted a quick way to see where each individual member in the guild was when working towards the guild invest goals. My spreadsheet accommodates a scenario where one person may have met the first and second invest goal of a building, while someone else is still working towards the first goal.			How does it work? The conditional formatting and colours are based on the goals you define in Step 2 of the next section. Entering a number in Goal #1 and Goal #2 for a building, any member with ticks between those numbers will have their cell coloured according for Goal #1. This allows tracking of invests for players with different stages of progress.
9
10
11
12
13	How do I use it? After going to File > Make a Copy, fill in this information in the Guild Ticks tab: 1. The level of each building in column F 2. Your preferred invest goals for the guild in column H, I, J, and K 3. The current invested ticks for each guild member in column M through AF			I have a question or need help! Join the official Discord and tag me in the #projects-and-resources channel! Discord invite: https://discord.gg/shoptitans
14
15
16
17
18	Colour Coding			Change Log
19		No Value Entered		2021-08-08	First release
20		Resource Building Below Goal #1		2021-10-06	Contact info updated
21		Worker Building Below Goal #1		2021-10-11	Fixed conditional formatting for Training Hall
22		City Building Below Goal #1		2022-03-01	Added support for Summoner's Tent
23		Guild Member has Met Goal #1		2022-03-22	Added new levels for Tavern & Emerald Inn
24		Guild Member has Met Goal #2		2022-03-23	Fixed tick requirements for Tavern & Emerald Inn
25		Guild Member has Met Goal #3
26		Guild Member has Met Goal #4
27
28
29	Note: There are a bunch of hidden tabs that contain underlying building data, but they don't need to be viewed or modified for this sheet to work. You also do NOT need to edit column L, this is populated automatically.			This spreadsheet is based on: Shop Titans Building Tracker (version 1.6) Created by Gunnolf25#3434 Original Link: https://rebrand.ly/guildtracker
30
31
32
33
34
35
36
37
38
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