Clan War Attacking Ratings - Formula Change

Hello everyone.

I'm now lowering scores for loot attacks and highlighting those that used both attacks for loot in the rankings. If the loot attack's rating is lower than the other attack, the other attack will be used in its place, but cut down by three quarters. This is so members that didn't use loot attacks will be ranked higher than those that did.

I'm sure all of you have noticed the green highlighting for first place, and the red highlighting for our bottom-ranked members. Members who use both attacks as loot will be highlighted purple.

This will serve to show a pattern of sorts for those that may use their attacks for loot when the wars get serious. This was obviously not one of those wars, and the high number of purple is acceptable in this case.

While I'm still honing the formula, it will most likely not change much more into the process of me actually writing a program to do all this junk for me. In the mean time, I'm just doing it manually in a spreadsheet. The final revision to the formula will be to take into consideration who was attacked when there is nobody else within range that can be starred; I could only make this work in code, so it's not going to be done until I get around to writing the program.

I hope everyone is well, please ask if you have any questions.

Thanks.

B4 - Rankings VERSUS SpecOps

Clan War Attack Ratings

Rank		Player	War Rating	New Stars	Power
1		reaper	12.00	6	11.00
2		roy	12.00	5	10.17
3		morgrym	10.00	6	10.00
3		hecken	10.00	6	10.00
5		b4	12.00	4	9.33
6		smoke	9.33	5	8.83
7		ironmorty	10.00	4	8.33
8		chris	8.33	5	8.33
9		bestie	8.00	5	8.17
9		warrior	8.00	5	8.17

B4 - Rankings VERSUS Asian Clan 9

Clan War Attack Ratings

Rank		Player	War Rating	New Stars	Power
1		smoke	11.00	6	10.50
2		ironmorty	10.00	6	10.00
3		reaper	12.00	4	9.33
4		ashish	10.00	5	9.17
5		that guy	12.00	3	8.50
6		warrior	8.67	5	8.50
7		morgrym	8.33	5	8.33
8		ceazar	8.00	5	8.17
9		hjj	10.00	3	7.50
10		darren	8.33	4	7.50

B6 - Rankings VERSUS Toilet Army

Clan War Attack Ratings

Rank		Player	War Rating	New Stars	Power
1		gilgamesh	11.50	5	9.92
2		arunava	8.33	5	8.33
3		jaymel	5.00	6	7.50
3		anine	5.00	6	7.50
5		bullet	4.00	6	7.00
6		lucifer	3.33	6	6.67
7		lord bullet	8.00	3	6.50
8		amer	2.67	6	6.33
9		peter	6.67	3	5.83
10		the fallen	8.11	2	5.72

B6 - Rankings VERSUS Asian Clan 4 (thereabouts)

Clan War Attack Ratings

Rank		Player	War Rating	New Stars	Power
1		bestie	10.00	6	10.00
2		arunava	8.33	5	8.33
3		jerrai	3.33	6	6.67
4		peter	6.44	4	6.56
5		general	4.00	5	6.17
6		daniel	2.44	5	5.39
7		omar	1.67	5	5.00
8		hecken	5.00	3	5.00
9		the fallen	0.00	6	5.00
10		dustin	5.50	2	4.42

B6 - Rankings VERSUS Furia Roja

Clan War Attack Ratings

Rank		Player	War Rating	New Stars	Power
1		dustin	10.00	6	10.00
2		hecken	9.67	6	9.83
3		kam	10.00	5	9.17
4		kevytlad	8.33	5	8.33
4		bestie	8.33	5	8.33
6		anine	6.67	6	8.33
7		peter	3.67	6	6.83
8		razor	6.67	4	6.67
9		jaymel	6.44	4	6.56
10		the fallen	1.67	6	5.83

B4 - Rankings VERSUS Random Asian Clan #8 (Probably)

Clan War Attack Ratings

Rank		Player	War Rating	New Stars	Power
1		reaper	12.00	6	11.00
1		jacob	12.00	6	11.00
3		smoke	12.00	5	10.17
4		wakeboarder	10.00	6	10.00
4		christian	10.00	6	10.00
4		chrissy	10.00	6	10.00
7		ceazar	10.00	5	9.17
8		hjj	12.00	3	8.50
9		morgrym	8.00	5	8.17
10		b4	11.00	3	8.00
		newworldorder	0.00	0	0.00
		becman	0.00	0	0.00
		the q	0.00	0	0.00

The entire clan wasn't posted because of the extreme difficulty several of our members had attacking; all in all the rankings were pretty decent, but I said I wouldn't count this war so I won't unless I hear objections. 

I did want to recognize the top 10 at the very least, and make note of those not attacking. In the future, I've decided I probably won't throw out rankings again.

For future reference, all clan rankings for each war will be listed in order on the War Rankings page, the most recent at the top.

Also, the Clan Rules page will contain a link to the Clan War Attack Ratings formula page.

Thanks everyone for making this a great clan, I look forward to our future victories.

Clan War Attack Ratings

This is a comprehensive list of the attack ratings received based on a member's selection of an opponent's rank and the number of stars scored against that target. 

This list should be used to determine who should be attacked based on the remaining opponents available for stars.

B4 - Rankings VERSUS DestroyingForce

Clan War Attack Ratings

Rank		Player	War Rating	New Stars	Power
1		airolge	10.00	6	10.00
1		christian	10.00	6	10.00
3		smoke	10.00	5	9.17
4		reaper	9.00	5	8.67
5		roye	10.00	4	8.33
5		ape gravy	10.00	4	8.33
5		diarmuid	10.00	4	8.33
8		tyler	8.33	5	8.33
8		ironmorty	8.33	5	8.33
10		caevyn	6.00	6	8.00
11		chrissy	10.33	3	7.67
12		chuck	10.17	3	7.58
13		chris	10.00	3	7.50
14		jacob	8.00	4	7.33
15		mrsteal	9.33	3	7.17
16		cezar	4.00	5	6.17
17		dundundahh	6.67	3	5.83
17		ragecage	6.67	3	5.83
17		mark	6.67	3	5.83
20		that guy	8.00	2	5.67
21		lee	3.83	4	5.25
22		ashish	6.67	2	5.00
22		gutter munky	6.67	2	5.00
22		listerine	6.67	2	5.00
25		daniel	5.00	3	5.00
25		chrysknife	5.00	3	5.00
25		b4	5.00	3	5.00
28		ceazar	4.89	3	4.94
29		saiken	5.67	2	4.50
30		ciranoush	5.00	1	3.33
31		darren	3.33	2	3.33
31		ocmersh	3.33	2	3.33
33		ninetysparks	6.33	0	3.17
34		jarosz	3.67	1	2.67
35		zack	3.33	1	2.50
35		morgrym	3.33	1	2.50
37		super hot	1.67	1	1.67
38		sinister	0.00	0	0.00
38		omar	0.00	0	0.00
38		hjj2	0.00	0	0.00
38		the q	0.00	0	0.00
38		thatguypursue	0.00	0	0.00
38		chrissssssss	0.00	0	0.00
38		becman	0.00	0	0.00

B4 - Rankings VERSUS *All Stars*

Clan War Attack Ratings

Ranks		Player	War Rating	New Stars	Power
1		reaper	15.00	6	12.50
2		super HOT	10.00	6	10.00
2		ironmorty	10.00	6	10.00
2		tyler	10.00	6	10.00
2		ninetysparks	10.00	6	10.00
2		gutter munky	10.00	6	10.00
2		sinister	10.00	6	10.00
8		ape gravy	9.33	6	9.67
9		jacob	11.50	4	9.08
10		trefallin	9.00	5	8.67
11		hjj 2	10.00	4	8.33
11		chrysknife	10.00	4	8.33
11		b4	10.00	4	8.33
14		chris	8.33	5	8.33
14		Morgrym	8.33	5	8.33
14		cezar	8.33	5	8.33
14		smoke	8.33	5	8.33
18		diarmuid	9.33	4	8.00
19		lee	9.00	4	7.83
20		daniel	6.67	4	6.67
20		that guy	6.67	4	6.67
20		ceazar	6.67	4	6.67
23		darren	6.33	4	6.50
24		ragecage	5.17	3	5.08
25		slenderbrine	6.67	2	5.00
25		omar majdi	6.67	2	5.00
27		christian	5.00	3	5.00
27		warrior	5.00	3	5.00
27		airolge	5.00	3	5.00
27		jarosz	5.00	3	5.00
27		ashish	5.00	3	5.00
32		listerine	4.50	3	4.75
33		thatguypursue	3.67	3	4.33
34		ciranoush	5.00	2	4.17
35		dundundahh	3.33	2	3.33
36		mrstealyogirl	3.11	2	3.22
37		mark	1.67	1	1.67
38		ocmersh	0.50	1	1.08
38		chrissy	0.50	1	1.08
40		caevyn fris	1.67	0	0.83
41		newworldorder	0.00	0	0.00
41		zack	0.00	0	0.00
41		becman	0.00	0	0.00
41		the q	0.00	0	0.00
41		chrissssssss	0.00	0	0.00
41		justice	0.00	0	0.00
41		noob	0.00	0	0.00

Leaderboard

After reviewing the previous wars, thought it would be nice to recognize some individual efforts!

Please see the leaderboard for top performers in recent wars!

This ranking only shows clan members with a minimum of six attacks in recent Clan Wars and ranks the top 15 clan members for Total Stars per attack and New Stars per attack.

Thought this would be more motivating than the "other" list.