Reddit PSN Tryhard Clan Wars
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
|
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXY
1
THIS IS THE OLD SHEET. PLEASE USE THE NEW SPREADHSEET (LINK IN SIDEBAR OF SUBREDDIT)00
2
Game TypesHCTDMTDMS&DKC1HCKCDOMBLITZKC2
3
%XP Bonus30%30%30%30%30%30%30%30%CP Leader Board
4
Goal3688368864646436
5
CP Value1240122826303010
6
Place:1st1st1st1st2nd4th2nd1st1st
7
TRYb823368836884302436472TRYb
8
Fil514060076626415246Fil
9
SCUB7400030000SCUB
10
KCCO381170050012640238KCCO
11
DYC1140350530015110DYC
12
DvLs7020103010DvLs
13
cnG7004100200cnG
14
FED000000000FED
15
Currently Owned By:TRYbTRYbTRYbTRYbFilKCCOTRYb48.860
16
Owning Clan Points Left:433542786465365/12/2015 18:50:505/12/2015 18:50:50
17
[AutoTarget]0!! LOSING !!0012121280
18
Wins Required to Capture433542782112810536
19
# Players On182.41.92.34.31.27.15.82.0
20
Manual TargetX
21
22
23
Logic for Auto Target recommendations:Updated for Costa Rica warPoints for algorithm
24
Auto target if:Using this formulaTRUEFALSE
25
Updated:MarchIF IT LOOKS OLD, UPDATE IT!!!!! 1Not currently capped by usC15<>$A$75-30
26
21st2CP value invserse rankRANK(C$5,$C$5:$L$5,1)varies 2-20varies 2-20
27
@15:20:00cstInstructions:3We're one of the top 3 teams on the pointRANK(C$7,C$7:C$14)<=3)31
28
by usSign in to your Google Account (read-only if you're not signed in)
Send your Google Account email to someone in chat to get edit access, or email ironrectangle@gmail.com
4Diff from cap target and us is less than 50%(C7/C4)>.52-1
29
------->1. Update CP Value for the 1st gametype (Row 5).CP Value5Capping clan points left <50% target value(C16/C4)<.510
30
/\2. Update points for each clan in that gametype.1236Party of XX wins inverse rankRANK(C19,C19:L19,0)*2varies 2-20varies 2-20
31
|3. Repeat Steps 1 and 2 for each gametype.7Penalty for longer game modesIF(INDEX(Refs!B:B,match(C2,Refs!A:A,0))>10,-1,0)-10
32
|4. If a clan owns a node, change Row 16, and leave their value at the Goal1238Within 15% of taking the point(C7/C4)>=.8520
33
|5. Update the CP leaderboard.1239CP gained over wins required to capround((C5/C18)*40,0)variesvaries
34
|6. Inform the clan of the targeting. (Higher value is better)12310Manual targetingIF(NOT(ISBLANK(C$20)))200
35
<-------7. TL;DR - Update Rows 5, 7-14 (except the orange), Row 16 and Column M11If we own it, no manual target, and CP/Goal<.75!! LOSING !!n/a
36
8. Change the Date/Time/By, Win & Repeat12If it's an open nodeIF(ISBLANK(C$15),20,0)200
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
Loading...
 
 
 
Clan Wars
Schedule
War Roster Time
rSFT War Time
Clan Stats
Refs
Non-War Roster Time
Clan Wars10
CW
Data
TRYbs1
TRYbs2
TRYbs3
TRYbe1
TRYbe2
TRYbe3
rSFT1
rSFTend