My 2010 nhl mock draft creator spreadsheet might be helpful to people in this draft. I will have an updated version once the season ends with the proper picking order but this version was from a little while ago and gives you an idea of what it can do.
Here is a run down on the features the link you can download it from:
Here is my 2010 NHL Mock Draft Creator Spreadsheet. Some of you may remember the sheet from previous years. (I’ve created these sheets for the NFL draft for about the last 5 years and for the NHL draft each of the last 2 or 3 years). As a refresher here are some of the features of the spreadsheet.
Over 350 players (Name, Position, Height, Weight, Team) ranked by averaging various player rankings on the net.
Ability to view by specific player position.
Team statistical rankings from this past year (Standings and goals for and against.)
(This will be filled in at year end.)
Easy to use, just put the number where you think a player will be picked next to his name on the Player Data page and it fills in his position on your mock draft page. The final draft position obviously won’t be up to date until the end of the regular season. This draft order is as of a couple weeks back so it will be different as of today.
Ability to filter the mock draft page to only include the picks for the team you cheer for.
List of 2010 Free Agents.
Sheet allowing you to create salary cap mock ups for your teams roster for next year.
Here is the link to download the spreadsheet: (Scroll down and click on the download link for the spreadsheet file.)
well this sounds like it could be fun... i might be interested in participating i would even take Calgary... however my knowledge off the draft eligibles isn't very deep... i'll leave it up to you guys if you want to let me join you
No one. However, C Berglund, C McDonald and one of the young defensemen would be made available in exchange for help up front. The Blues can take on salary. No interest in trading out of the first round, but would be willing to move down from #16 if the deal is right.
GM:Yummy Snack Contact Via PM Cap Hit: Cap Space: TBD
The Phoenix Coyotes Select
Round 1 - Round 1 - Round 2 - Round 4 - Round 6 -
Active Roster 2010/2011 Player with contracts
Center: Vernon Fiddler (1.1M) Petteri Nokelainen (950K)
Left Wing: Petr Prucha (1.2M) Lauri Korpikoski (700K) Paul Bissonnette (612.5K)
Right Wing: Shane Doan (4.55M) Radim Vrbata (3.0M) Victor Tikhonov (1.175M)
Defense: Ed Jovanovski (6.5M) Jim Vandermeer (2.3M) Kurt Sauer (1.75M) Keith Yandle (1.2M)
Unrestricted Free Agents
Center: Matthew Lombardi (1.8M) Robert Lang (1.7M)
Left Wing: Taylor Pyatt (600K)
Right Wing: Lee Stempniak (2.5M)
Defense: Derek Morris (3.3M) Mathieu Schneider (2.75M) Adrian Aucoin (2.25M) Zbynek Michalek (1.25M)
Restricted Free Agents
Center: Martin Hanzal (980K) Daniel Winnik (600K)
Left Wing: Wojtek Wolski (2.8M)
Right Wing: Scottie Upshall (1.5M)
Defense: Sami Lepisto (550K) David Schlemko (516K)
F: Kyle Turris
F: Mikkel Boedker
D: Chris Summers
F: Brett MacLean
D: Michael Stone
G: Joel Gistedt
D: Nick Ross
F: Colin Long
D: Jonas Ahnelov
D: Jeff May
Number 1 center
Top six forwards
Well rounded defense
Plenty of forward depth
On The Trade Front
Defense: Ed Jovanovski; Jim Vandermeer; Kurt Sauer
Forward: Shane Doan; Petr Prucha; Petteri Nokelainen
Goaltending: Jason Labarbera
Willing to deal prospects Kyle Turris, Brett MacLean, Michael Stone, Alexandre Picard, and Al Montoya if a good deal is offered.
Last edited by Orochimaru: 04-04-2010 at 02:19 PM.