Capgeek.com
So, I'm currently doing some prep work for an upcoming inaugural draft, and this league has a salary cap. It uses NHL cap hits and contracts.
Does anyone happen to know a place where I could easily find a master list with each player, his cap hit (current and future, if possible), and the number of years left on his contract/on all his contracts? Even if it's one list per team that's easy to inject into Excel, it will be great.
My current option is to just copy paste the team pages off Capgeek, but since this is a sim league that uses previous seasons as it's base for ratings and salaries, I'd have to do one for 2013-2014 and then one for 2014-2015 and beyond, which is 60 pages, that I then have to consolidate and then make into a master list. I'm sure there's a more efficient or currently availible option out there.
I currently have a way to get the 2013-2014 cap hits, but since this league is particular in that you can only resign 3 expiring contracts each year (rest go into an FA draft), knowing how long they have left on those deals would allow for further planning down the road. Crucial in an inaugural draft.
Thanks to anyone who can help!
UHL - Detroit Red Wings
24 team H2H (W-:L) Dynasty - 3C/LW/RW/F, 6D, 1G.
G/A/(+/-)/PIM/SOG/PPP/SHP/GWG/HIT/BLK/FOW
W/GAA/SV/SV%/SHO
NHL Cap + 1M salary cap (AAV)
Capgeek.com
14 team h/h dynasty
Stats, G A PTS PIM +/- PPP SHP GWG shts TOI hts/blks W sv% gaa SO
$89 mill salary cap, cap hits
minors- players under 60 gms, goalies under 30 gms
3c 3lw 3rw 4d 2util 1goal
max 23 plyr rstr, 15 minors
CENTERS Kuznetsov, Necas, Petterson, Hughes, D.Strome, Seguin, Hayes, Scheifele
LEFTWING Gaudreau, Mantha, Forsberg, Keller
RIGHTWING Kakko , Debrincat, Thomas, Konecny
D-MEN Girard, Provorov, McCavoy, Dobson, Makar
GOALIES Gibson, Shesterkin, Sorokin
IR
MINORS Brannstrom, Kostin, Dennisenko, Kaprizov, Tippett, Cozens, Tolvanen, Zegras, Byfield , Vessalainen, K.Miller, Kyrou, Janik, Bokk, Lundell, Heinola, Hoglander, Lundkvist
Can you download them from there though?
You cannot download from there.
http://capgeek.com/data-usage/
The Best Fantasy Hockey Site
15-Team Keeper, points only, best 12 fwd, 4 dman, 2 G count. Playoffs count.
F - T. Thompson, Thomas, Nylander, Tarasenko, Arvidsson, Guentzel, Fiala, Quinn, Mittelstadt, Hagel, Zacha, Roslovic, Berggren, Brink, Ostlund
G - Kahkonen, Vejmelka, L. Thompson, Levi, Comrie
D - Hronek, Morrissey, Lundkvist, Girard, Brannstrom, Rathbone, Hanifin, Severson, Durzi
not download but how about something like this
http://www.spotrac.com/nhl/anaheim-ducks/
UHL - Detroit Red Wings
24 team H2H (W-:L) Dynasty - 3C/LW/RW/F, 6D, 1G.
G/A/(+/-)/PIM/SOG/PPP/SHP/GWG/HIT/BLK/FOW
W/GAA/SV/SV%/SHO
NHL Cap + 1M salary cap (AAV)
nhlnumbers.com
not sure if you can download or not.
10 team Full Keeper Roto League
4C-4LW-4RW-6D-2G-5bench-unlimited farm.
C= eichel,horvat,malkin,kuznetsov
LW= forsberg,kreider,lee,b.tkchuch,hertle,granlund
RW= reinhart,radulov,hoffman,laine,hayes
D= doughty,ghostebehere,karlsson,jones,klefbom,dahlin ,skjei
G= price,murray,grubauer,georgiev,ullmark,samsonov
under250gp=nichushkin,tuch,mathesson,marino,pujuja rvi,hosang,terry,andersson,j.hughes,patrik,crouse, zadina,podkolzin,k.miller,nedeljkovic,kravtsov,hay ton
--G,A,P,PPP,SHP,GWG,PIMS,+/-,SOG,hits,FOW,blks-Wins,GAA,SV%,saves,SO
I just cut & paste 30 screen from CapGeek...
that's not helpful though, sorry.
Nights,
The spreadsheet you shared with us all (in the league) was awesome! Nice job!
UHL - Detroit Red Wings
24 team H2H (W-:L) Dynasty - 3C/LW/RW/F, 6D, 1G.
G/A/(+/-)/PIM/SOG/PPP/SHP/GWG/HIT/BLK/FOW
W/GAA/SV/SV%/SHO
NHL Cap + 1M salary cap (AAV)
In all honesty, what you are asking for is something I would pay to get each year this time of year. All the salary sites, capgeek, nhlhumbers, hockeybuzz, etc. don't provide downloads.
You can copy and paste, which not only takes a long time, but is also illegal.
Dobber's Draft List has salaries, and that is by far the best source I have found, but it isn't released early enough for me. I really need something I can get 1 to 2 weeks after Free Agency.
Like I said, I would seriously pay money to get that. It would be more valuable to me than any pool guide out there, but unfortunately I am not aware of any service that provides this. Most of the salary sites don't want to give anyone their data over fear their work would be exploited.
12 team, H2H, salary cap
1 pt/G or A, 2 pts/W, 1 pt/OTL, 1 pt/SO
Forward: B. Point, M. Necas, A. Debrincat, T. Zegras, J. Bratt, L. Raymond
Defense: J. Morrissey, A. DeAngelo, S. Gostisbehere, D. Doughty
Goalie: T. Demko, E. Merzlikins
Bench: M. Rossi, C. Glass, M. Maccelli, M. Dumba, K. Shattenkirk, F. Andersen
Prospects of Note: L. Stankoven, J. Lekkerimaki, D. Yurov, B. Clarke
League has been running continuously since 1997-98