2016 - Champions, Runner Ups, and Club Semis

[Unregistered]

here is U11-U14, based on lastplanet's average rank, and the number of teams each club fields:

U11-U14
TOP 25 OVERALL CLUBS TOP 25 BOYS CLUBS TOP 25 GIRLS CLUBS
1 FC Portland 1 4-H 1 Crossfire OR
2 Crossfire OR 2 FC Portland 2 FC Portland
3 Westside Timbers 3 Westside Timbers 3 Westside Timbers
4 Capital FC Timbers 4 Crossfire OR 4 Capital FC Timbers
5 Eastside Timbers 5 Capital FC Timbers 5 THUSC
6 ETFC 6 Eastside Timbers 6 ETFC
7 NEU 7 HSC 7 NEU
8 HSC 8 RPSC 8 Bend FC Timbers
9 Bend FC Timbers 9 NEU 9 CSC
10 BSC 10 ETFC 10 Eastside Timbers
11 CSC 11 BSC 11 HSC
12 R. Valley Timbers 12 Bend FC Timbers 12 PCU
13 PCU 13 WUSC 13 Rogue Valley Timbers
14 THUSC 14 R. Valley Timbers 14 BSC
15 4-H 15 FC West 15 WAFC
16 Grants Pass YSC 16 CSC 16 Grants Pass YSC
17 WAFC 17 LASC 17 Canby United
18 RPSC 18 Grants Pass YSC 18 Kidsports FC
19 WUSC 19 PCU 19 Irish United
20 FC West 20 Salem Chelsea 20 Thelo
21 Thelo 21 WAFC 21 FC Columbia County
22 Southside SC 22 Thelo 22 Southside SC
23 LASC 23 Foothills SC 23 Aloha United
24 Foothills SC 24 Southside SC 24 Azul FC
25 Salem Chelsea 25 Academia Leon 25 Oregon City

and before i get accused of bias... i just moved away from portland, my old club is in there, thankfully above that club i really hate, but not above that other club i hate.

Nice thing about lastplanet rankings is that they use every game the teams play, not just a handful of cherry-picked wins...

[Unregistered]

After the last column try the following code:

=CONCATENATE($A2," ",$B2," ",$C2)

Explanation of what functions does (also note the function changes in future versions of excel)

that might work, but the misformatting was a result of bbcode issues -not exactly spreadsheet or table issues. either way, maybe this will work.

[pre]
U11-U14
TOP 25 OVERALL CLUBS TOP 25 BOYS CLUBS TOP 25 GIRLS CLUBS
1 FC Portland 1 4-H 1 Crossfire OR
2 Crossfire OR 2 FC Portland 2 FC Portland
3 Westside Timbers 3 Westside Timbers 3 Westside Timbers
4 Capital FC Timbers 4 Crossfire OR 4 Capital FC Timbers
5 Eastside Timbers 5 Capital FC Timbers 5 THUSC
6 ETFC 6 Eastside Timbers 6 ETFC
7 NEU 7 HSC 7 NEU
8 HSC 8 RPSC 8 Bend FC Timbers
9 Bend FC Timbers 9 NEU 9 CSC
10 BSC 10 ETFC 10 Eastside Timbers
11 CSC 11 BSC 11 HSC
12 R. Valley Timbers 12 Bend FC Timbers 12 PCU
13 PCU 13 WUSC 13 Rogue Valley Timbers
14 THUSC 14 R. Valley Timbers 14 BSC
15 4-H 15 FC West 15 WAFC
16 Grants Pass YSC 16 CSC 16 Grants Pass YSC
17 WAFC 17 LASC 17 Canby United
18 RPSC 18 Grants Pass YSC 18 Kidsports FC
19 WUSC 19 PCU 19 Irish United
20 FC West 20 Salem Chelsea 20 Thelo
21 Thelo 21 WAFC 21 FC Columbia County
22 Southside SC 22 Thelo 22 Southside SC
23 LASC 23 Foothills SC 23 Aloha United
24 Foothills SC 24 Southside SC 24 Azul FC
25 Salem Chelsea 25 Academia Leon 25 Oregon City
[/pre]