Skip to content

Daily Coin Tracker

Screen Shot of Tracking Sheet
Screen Shot of Tracking Sheet

Abody0861 has kindly agreed to make this incredibly useful coin tracker tool available to assist your guild in tracking who is and who is not getting 600 guild coins a day.  If you find a way to improve it he asks you let him know via a Discord DM.

Link:

Copy of [Template] Guild Contributions – Google Sheets

JavaScript isn’t enabled in your browser, so this file can’t be opened. Enable and reload.

Copy of [Template] Guild Contributions

 Share

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

 

View only

 
 

ABCDEFGHIJKLMNOPQRSTUVW
1
Guild reset at
3:30 AM CET
6:30 PM PST
Date format YYYYMMDDSelect column I and insert new column to the left twice0000130000100000
2
Enter lifetime numbers for each member in the Column I12:00 PST 2100 CET12:00 PST 2100 CET12:00 PST 2100 CETT512:00 PST 2100 CET
3
00-120121-240241-360361-480481-599600Update Time>21:3021:3021:3021:3021:3021:3021:30
4
Possible T5 in month(Max):17(17)
Number of Members>
4949494949494949
5
Possible T6 in month(Max):16(16)
Maximum tickets for day>
2940029400294002940029400294002940029400
6
Possible T7 in month(Max):14(14)
Number of tickets short for day>
0000000
7
Possible T5/6 month(Max):14(14)
Number of Guildees who have maxed at 600>
49494949494949
8
Possible T6/7 month(Max):13(13)
Total tickets generated for day>
2940029400294002940029400294002940029900
9
Enter enter raid coins from Pit Raid in I1. At reset this number should exactly match H8.>>>
029400029400029400029400-8400011340030000-600100000-70600
10
Player NameNotesJoin DateLifetime Avg7 Day AvgLast 7 day TotalToday2017021020170210201702102017021020170210201702092017020820170110
11
Guild20170105295002940020580029400235200205800176400147000117600882005880029400
12
Guildite011017020160060042006004800600420060036006003000600240060018006001200600600
13
Guildite021017020160060042006004800600420060036006003000600240060018006001200600600
14
Guildite03CST1017020160060042006004800600420060036006003000600240060018006001200600600
15
Guildite051017020160060042006004800600420060036006003000600240060018006001200600600
16
Guildite061017020160060042006004800600420060036006003000600240060018006001200600600
17
Guildite071017020160060042006004800600420060036006003000600240060018006001200600600
18
Guildite08CET1017020160060042006004800600420060036006003000600240060018006001200600600
19
Guildite091017020160060042006004800600420060036006003000600240060018006001200600600
20
Guildite10CET1017020160060042006004800600420060036006003000600240060018006001200600600
21
Guildite111017020160060042006004800600420060036006003000600240060018006001200600600
22
Guildite121017020160060042006004800600420060036006003000600240060018006001200600600
23
Guildite131017020160060042006004800600420060036006003000600240060018006001200600600
24
Guildite14PST1017020160060042006004800600420060036006003000600240060018006001200600600
25
Guildite15EST1017020160060042006004800600420060036006003000600240060018006001200600600
26
Guildite161017020160060042006004800600420060036006003000600240060018006001200600600
27
Guildite17UTC-71017020160060042006004800600420060036006003000600240060018006001200600600
28
Guildite181017020160060042006004800600420060036006003000600240060018006001200600600
29
Guildite191017020160060042006004800600420060036006003000600240060018006001200600600
30
Guildite201017020160060042006004800600420060036006003000600240060018006001200600600
31
Guildite211017020160060042006004800600420060036006003000600240060018006001200600600
32
Guildite221017020160060042006004800600420060036006003000600240060018006001200600600
33
Guildite231017020160060042006004800600420060036006003000600240060018006001200600600
34
Guildite24GMT+31017020160060042006004800600420060036006003000600240060018006001200600600
35
Guildite251017020160060042006004800600420060036006003000600240060018006001200600600
36
Guildite26GMT+31017020160060042006004800600420060036006003000600240060018006001200600600
37
Guildite271017020160060042006004800600420060036006003000600240060018006001200600600
38
Guildite281017020160060042006004800600420060036006003000600240060018006001200600600
39
Guildite291017020160060042006004800600420060036006003000600240060018006001200600600
40
Guildite301017020160060042006004800600420060036006003000600240060018006001200600600
41
Guildite311017020160060042006004800600420060036006003000600240060018006001200600600
42
Guildite321017020160060042006004800600420060036006003000600240060018006001200600600
43
Guildite33GMT+31017020160060042006004800600420060036006003000600240060018006001200600600
44
Guildite341017020160060042006004800600420060036006003000600240060018006001200600600
45
Guildite351017020160060042006004800600420060036006003000600240060018006001200600600
46
Guildite361017020160060042006004800600420060036006003000600240060018006001200600600
47
Guildite371017020160060042006004800600420060036006003000600240060018006001200600600
48
Guildite381017020160060042006004800600420060036006003000600240060018006001200600600
49
Guildite3960060042006004800600420060036006003000600240060018006001200600600
50
Guildite4060060042006004800600420060036006003000600240060018006001200600600
51
Guildite4160060042006004800600420060036006003000600240060018006001200600600
52
Guildite4260060042006004800600420060036006003000600240060018006001200600600
53
Guildite4360060042006004800600420060036006003000600240060018006001200600600
54
Guildite4460060042006004800600420060036006003000600240060018006001200600600
55
Guildite4560060042006004800600420060036006003000600240060018006001200600600
56
Guildite4660060042006004800600420060036006003000600240060018006001200600600
57
Guildite4760060042006004800600420060036006003000600240060018006001200600600
58
Guildite4860060042006004800600420060036006003000600240060018006001200600600
59
Guildite4960060042006004800600420060036006003000600240060018006001200600600
60
Guildite5060060042006004800600420060036006003000600240060018006001200600600
61
62
63
64
65
66
67
68
xGuildite11(date_removed)
reason
69
xGuildite11(date_removed)
reason
70
xGuildite11(date_removed)
reason
71
xGuildite11(date_removed)
reason
72
xGuildite11(date_removed)
reason
73
xGuildite11(date_removed)
reason
74
xGuildite11(date_removed)
reason
75
xGuildite11(date_removed)
reason
76
xGuildite11(date_removed)
reason
77
xGuildite11(date_removed)
reason
78
xGuildite11(date_removed)
reason
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100

Loading…

 
 
 
Daily Energy
2 liner
 
 

One thought on “Daily Coin Tracker Leave a comment

Leave a Reply

%d bloggers like this: