ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Welcome to the Shop Titans Building Tracker version 1.7
2
Thank you for your interest in using this spreadsheet. My goal was to create something easy enough for anyone to use while still being robust enough to provide useful information for top ranking guilds. If you have questions, feedback, or suggestions for the next version please contact me on Discord: Gunnolf25#3434
3
4
Setup:
5
1On the Data Entry tab across the top put your player names, leave unused spaces blank.
6
2Using the drop down menu chose the level of each building and in the grey square chose the investment goal you would like each player to achieve.
7
3Look through the buildings in game and mark down the number of ticks each person has in each building.
8
Once all the data is entered you will notice different colors have appeared.
9
Your top 3 investors in each building will be colored Gold (top investor), Silver (2nd highest) and Bronze (3rd Highest).
10
Any member not meeting the investment goal set by the guildmaster will be automatically highlight in a darker primary color (red, blue, or orange)
11
Under the player name you can see how many of the guild goals each player has achieved (number achieved / total goals chosen)
12
Optional: Customize by inserting your guild name and logo.
13
Updating:
14
1Compare the in game display to the in game building display, if it matches nothing has changed. If it doesn't match find the memebers scores who have changed and update their number of ticks
15
16
Version
17
1.7Summoners Tent added, projected tab requires update still
18
1.61Fixed an error in Tavern in game display.
19
1.6Added images for Sol & Luna Tower, New max level for Emerald Inn is 19, New max level for Tavern is Tavern is 28
20
1.51Updated Town Hall levels to correct reflect new investments and levels
21
1.5Added Sol & Luna Towers
22
1.42Corrected a few errors, Thank you Xerrit. Tavern drop down now correctly goes to lvl 25 & Tavern in game display now shows the correct amount.
23
1.41
Corrected a formula mistake on the projected tab in columns P & Q, Thank you Neal5227 for pointing it out. Also corrected building level not autoupdating on projected tab
24
1.4Updated Tavern and Emerald Inn for additional levels
25
1.3Added a new column to allow you to set a minimum number of ticks per day and show how many days it will take to level a building.
26
Thank you to Glitter for the idea, and thank you again to BiscuitCookie for help finding and fixing a few missed errors
27
1.21Corrected formulas for cell I6 on the data entry tab and gem totals on the projected tab. Thank you to BiscuitCookie for pointing these out.
28
1.2 Moved a few columns around on the Data Entray Tab to improve the flow when looking at the data.
29
The individual goal on the Data Tab has been renamed to Guild Goal to help reduce confusion.
30
Added new tab "Projections" to show how much gold/gems is needed by each member to complete the set objectives.
31
1.1
Fixed formula in Oil Press and Smelter. Added the Equal Ticks column to assist Guild leaders in assigning goals since it shows how many ticks each person needs to level up a building
32
Corrected the goal met formula to display that a goal had been met when the designated ticks were reached, previously in order to display you had to be one over.
33
1.0Initial Release
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