Washington-OregonPremierSoccer.Com Forum

Please login or register.

Login with username, password and session length
Advanced search  
Currently:
  • Tournament Guide from the LastPlanet database 5 1
Pages: [1]   Go Down

Author Topic: Tournament Guide from the LastPlanet database  (Read 657 times)

0 Members and 1 Guest are viewing this topic.

lastplanet

  • WPS Premier Poster
  • ***
  • Karma: +66/-8
  • Posts: 677
  • Joined 26/04/2011
    YearsYearsYears
    • View Profile
Tournament Guide from the LastPlanet database
« on: May 18, 2013, 03:51:17 PM »

Since I have a database of most of the summer tournament data from the U12-U17 boys, I assembed that into a table with some info about the median strength of the teams in the tournament division (last year), numbers of teams in the division, along with tournament date and place. 

Go here and then click 'Tournament Guide' in the top nav bar.
http://www.lastplanetranking.blogspot.com

It's a pretty big table.  You can sort by clicking the table headers but it might be easier to download the comma-delimited files and open in Excel (there's a link to do that on the page with the table).   You'll need to look up your team's 2012-2013 (last season) B00 (yes, B00) strength.  The median strengths shown are B00 strengths, so that all teams (6 age groups) are on the same scale.  Once you have your team's B00 strength, you can look up all the tournaments and divisions near that strength range.   Tournaments mainly in WA & OR, but there are a number of higher level CA tournaments there too.



Logged

lastplanet

  • WPS Premier Poster
  • ***
  • Karma: +66/-8
  • Posts: 677
  • Joined 26/04/2011
    YearsYearsYears
    • View Profile
Re: Tournament Guide from the LastPlanet database
« Reply #1 on: May 18, 2013, 04:04:02 PM »

I have data for U12 to U17 (boys only).  Guide shows you # of teams in each division.  Strength of teams in that division.  Max GD for games (single game).  Dates, City (approx) and State.  Here's an example of the tournaments I have at the U13 level. 

Baker Blast Premier U13
Beaverton Cup Gold U13
Beaverton Cup Silver U13
Bend Premier Gold U13
Bend Premier Silver U13
Bigfoot Gold U13
Bigfoot Silver U13
Capital Cup U13
Chinook Cup Gold U13
Chinook Cup Silver U13
Clash at the Border Bronze U13
Clash at the Border Gold U13
Clash at the Border Silver U13
Cranberry Cup U13
Crossfire Challenge Gold U13
Crossfire Challenge Silver U13
Crossfire Select Cup Gold U13
Crossfire Select Cup Silver U13
Dungeness Cup U13-14
Federal Way Blast Off U13
Island Cup U13
Jack Frost Winter U13-15
Kent Cornucopia Cup U13
Kick in the Grass Green U13
Kick in the Grass Red U13
King of the Hill U13
Mt Hood Challenge Gold U13
Mt Hood Challenge Silver U13
Norpoint Lighthouse Cup U13-14
Northwest Cup U13
OPL Directors Cup Gold U13
OPL Directors Cup Silver U13
OSSA Winter Challenge U13-14
Oswego Nike Cup Gold U13
Pacific Coast Challenge Copa U13
Pacific Coast Challenge Premier U13
PacNW Memorial Cup U13
PacNW Winter Classic U13
Pend Oreille Cup U13
Rainier Challenge Copa U13
Rainier Challenge Samba U13
Rainier Valley Slammers U13
River Jam U13
Sagebrush Classic U13
Seattle United Cup U13
Skagit Firecracker U13
Skagit Labor Day Kick U13
Skagit River Cup Silver U13
Skagit River Cup U13-14
Snohomish United Invitational U13
Sounders FC Cup U13
South Mason Kick-off U13
Starfire Extreme Cup U13
Starfire Labor Day Cup U13
Starfire Spring Classic U13
Surf Cup U13
United Cup U13
US Club NW Regionals Premier U13
US Club NW Regionals Super U13
VUSA Summer Slam Gold U13
VUSA Summer Slam Silver U13
WA Rush Cup Gold U13
WA Rush Cup Silver U13
WA Rush Cup Silver U13
Logged

NKSoccerFan

  • WPS-SpamKing Special Agent
  • ****
  • Karma: +1489/-68
  • Posts: 1289
  • Joined 15/04/2010
    YearsYearsYearsYears
    • View Profile
Re: Tournament Guide from the LastPlanet database
« Reply #2 on: May 18, 2013, 09:57:39 PM »

Oooh, a new toy!   :D
Way cool.

 :drinks:
Logged

lastplanet

  • WPS Premier Poster
  • ***
  • Karma: +66/-8
  • Posts: 677
  • Joined 26/04/2011
    YearsYearsYears
    • View Profile
Re: Tournament Guide from the LastPlanet database
« Reply #3 on: May 19, 2013, 06:16:10 PM »

Oooh, a new toy!   :D
Way cool.
Thanks!  Entertainment before actual tourny season begins....
Logged

lastplanet

  • WPS Premier Poster
  • ***
  • Karma: +66/-8
  • Posts: 677
  • Joined 26/04/2011
    YearsYearsYears
    • View Profile
Re: Tournament Guide from the LastPlanet database
« Reply #4 on: May 19, 2013, 06:17:47 PM »

I made another change to the tables.  Now you can click on a tournament/division name and you can see all the scores, so you can you can see who played, what the scores were, and surface (if I have that info).

Direct link: http://dl.dropboxusercontent.com/u/31164092/boys-tournament-guide.html

--LP
« Last Edit: May 19, 2013, 06:32:43 PM by lastplanet »
Logged
Pages: [1]   Go Up