Reddit PSN Tryhard Clan Wars

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1			THIS IS THE OLD SHEET. PLEASE USE THE NEW SPREADHSEET (LINK IN SIDEBAR OF SUBREDDIT)								0		0
2		Game Types	HCTDM	TDM	S&D	KC1	HCKC	DOM	BLITZ	KC2
3		%XP Bonus	30%	30%	30%	30%	30%	30%	30%	30%	CP Leader Board
4		Goal	36	88	36	88	64	64	64	36
5		CP Value	12	40	12	28	26	30	30	10
6		Place:	1st	1st	1st	1st	2nd	4th	2nd	1st	1st
7	TRYb	823	36	88	36	88	43	0	24	36	472	TRYb
8	Fil	514	0	60	0	76	62	64	1	5	246	Fil
9	SCUB	7	4	0	0	0	3	0	0	0	0	SCUB
10	KCCO	381	17	0	0	50	0	12	64	0	238	KCCO
11	DYC	114	0	35	0	53	0	0	15	1	10	DYC
12	DvLs	7	0	2	0	1	0	3	0	1	0	DvLs
13	cnG	7	0	0	4	1	0	0	2	0	0	cnG
14	FED		0	0	0	0	0	0	0	0	0	FED
15	Currently Owned By:		TRYb	TRYb	TRYb	TRYb		Fil	KCCO	TRYb	48.86		0
16	Owning Clan Points Left:		43	35	42	78		64	65	36	5/12/2015 18:50:50		5/12/2015 18:50:50
17	[AutoTarget]		0	!! LOSING !!	0	0	121	21	28	0
18	Wins Required to Capture		43	35	42	78	21	128	105	36
19	# Players On	18	2.4	1.9	2.3	4.3	1.2	7.1	5.8	2.0
20	Manual Target						X
21	Manual Target						X
22
23														Logic for Auto Target recommendations:	Updated for Costa Rica war	Points for algorithm
24														Auto target if:	Using this formula	TRUE	FALSE
25		Updated:	March			IF IT LOOKS OLD, UPDATE IT!!!!!							1	Not currently capped by us	C15<>$A$7	5	-30
26			21	st		IF IT LOOKS OLD, UPDATE IT!!!!!							2	CP value invserse rank	RANK(C$5,$C$5:$L$5,1)	varies 2-20	varies 2-20
27		@	15:20:00	cst		Instructions:							3	We're one of the top 3 teams on the point	RANK(C$7,C$7:C$14)<=3)	3	1
28			by	us		Sign 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							4	Diff from cap target and us is less than 50%	(C7/C4)>.5	2	-1
29					------->	1. Update CP Value for the 1st gametype (Row 5).						CP Value	5	Capping clan points left <50% target value	(C16/C4)<.5	1	0
30					/\	2. Update points for each clan in that gametype.						123	6	Party of XX wins inverse rank	RANK(C19,C19:L19,0)*2	varies 2-20	varies 2-20
31					\|	3. Repeat Steps 1 and 2 for each gametype.						123	7	Penalty for longer game modes	IF(INDEX(Refs!B:B,match(C2,Refs!A:A,0))>10,-1,0)	-1	0
32					\|	4. If a clan owns a node, change Row 16, and leave their value at the Goal						123	8	Within 15% of taking the point	(C7/C4)>=.85	2	0
33					\|	5. Update the CP leaderboard.						123	9	CP gained over wins required to cap	round((C5/C18)*40,0)	varies	varies
34					\|	6. Inform the clan of the targeting. (Higher value is better)						123	10	Manual targeting	IF(NOT(ISBLANK(C$20)))	20	0
35					<-------	7. TL;DR - Update Rows 5, 7-14 (except the orange), Row 16 and Column M							11	If we own it, no manual target, and CP/Goal<.75		!! LOSING !!	n/a
36						8. Change the Date/Time/By, Win & Repeat							12	If it's an open node	IF(ISBLANK(C$15),20,0)	20	0
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