Compete Level

Advanced statistics are old news, friendship is the best way to judge players
It is currently Fri Dec 14, 2018 3:27 pm

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 109 posts ]  Go to page Previous  1, 2, 3, 4, 5  Next
Author Message
 Post subject: Re: 2018-19 CFL Season
PostPosted: Sun Sep 23, 2018 5:38 pm 
Offline
User avatar

Joined: Tue Dec 15, 2009 1:52 am
Posts: 39310
Location: Ice District
Custom Title: Hockey Facts.
Oh and just one other note that came up from looking through everyone's spreadsheets this morning.

A few of you have copied my roster spreadsheet, which is fine. One of the columns I use is "End of Contract Age" which has color-coding to signify whether a player will be RFA or UFA eligible at the end of their contract.

The formula is as follows:
"=INT((DATE(2018+G2,7,1) - N2)/365.25)"

If you are using this formula, you need to make sure you update the calendar year each season. Just as an example, Sutterman is using this spreadsheet but his EoC Age formula is still using 2016 as a year, which means he is getting inaccurate results about who is RFA or UFA eligible.

It works great, you just have to update the year!


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Sun Sep 23, 2018 5:38 pm 
Offline
User avatar

Joined: Tue Dec 15, 2009 1:52 am
Posts: 39310
Location: Ice District
Custom Title: Hockey Facts.
Special shoutout to DTMB and Nick for their impeccable spreadsheets and record keeping.


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Sun Sep 23, 2018 6:40 pm 
Offline
User avatar

Joined: Sun Dec 20, 2009 3:21 am
Posts: 17140
Location: Toronto
Custom Title: The clutchiest
:barnaby:


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Sun Sep 23, 2018 8:26 pm 
Offline
User avatar

Joined: Tue Dec 15, 2009 1:52 am
Posts: 39310
Location: Ice District
Custom Title: Hockey Facts.
Thanks for a great draft everyone. Too bad our big spenders never showed up, although we all benefitted.

Be sure to assign contract lengths for all of your new players in this thread before the season begins.


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Sun Sep 23, 2018 8:27 pm 
Offline
User avatar

Joined: Tue Dec 15, 2009 1:52 am
Posts: 39310
Location: Ice District
Custom Title: Hockey Facts.
Oh and I'll remove the owned prospects that were autodrafted sometime tomorrow.


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Sun Sep 23, 2018 8:28 pm 
Offline
User avatar

Joined: Tue Dec 15, 2009 1:52 am
Posts: 39310
Location: Ice District
Custom Title: Hockey Facts.
I'm sorry to say this but I'm going to win again


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Sun Sep 23, 2018 8:43 pm 
Offline
User avatar

Joined: Thu Jul 22, 2010 11:32 am
Posts: 10989
Location: west island
I suck at auction drafts, but at least I'm fast!


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Sun Sep 23, 2018 8:53 pm 
Offline
User avatar

Joined: Tue Dec 22, 2009 2:33 am
Posts: 5290
Location: Urbana, IL
Custom Title: Celestial Incinerators
Another year, another blown draft.

And my spreadsheet is pretty great so FU Kev.


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Sun Sep 23, 2018 9:04 pm 
Offline
User avatar

Joined: Tue Dec 22, 2009 2:33 am
Posts: 5290
Location: Urbana, IL
Custom Title: Celestial Incinerators
Hornqvist - 1 year at 6per
Brown - 1 year at 3
Ekholm - 2 years at 3
Mrazek - 1 year at 3
Vlasic - 3 years at 2
Saad - 2 years at 1


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Sun Sep 23, 2018 9:33 pm 
Offline
User avatar

Joined: Tue Dec 22, 2009 2:33 am
Posts: 5290
Location: Urbana, IL
Custom Title: Celestial Incinerators
Man I'm all in on 12th


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Mon Sep 24, 2018 6:25 am 
Offline
User avatar

Joined: Mon Dec 14, 2009 4:03 pm
Posts: 28003
Custom Title: space, punctuated by planets
sorry for auto drafting Casey M!

Patrick Kane $17 - 2 years
Dougie Hamilton $13 - 3 years
Jeff Petry $2 - 1 year
James Reimer $3 - 2
Cory Schneider $6 - 1 year
Oskar Lindblom $2 - 3 years
Josh Bailey $3 - 1
Zach Hyman $2 - 2
Cody Ceci $1 - 1
Mikko Koskinen $1 - 2 years
Craig Smith $2 - 1


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Mon Sep 24, 2018 7:14 am 
Offline
Site Admin
User avatar

Joined: Sun Dec 13, 2009 11:16 pm
Posts: 34360
Location: The Moon
Custom Title: Doggles TM Doggles
William Karlsson $9m - 1 year
Patrice Bergeron $10 - 1 year
Logan Couture - $8 - 2 years
Sam Reinhart - $4 - 1 year
Roman Josi - $10 - 2 years
Morgan Rielly - $10 - 2 years
Devan Dubnyk $10 - 2 years


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Mon Sep 24, 2018 11:12 am 
Offline
User avatar

Joined: Sun Dec 20, 2009 3:21 am
Posts: 17140
Location: Toronto
Custom Title: The clutchiest
Jake Guentzel $8 - 2 years
Vinnie Hinostroza $1 - 2 years
David Krejci $1 - 1 year
Thomas Vanek $1 - 1 year
Jared Spurgeon $1 - 1 year
Philipp Grubauer $3 - 2 years


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Mon Sep 24, 2018 8:40 pm 
Offline
User avatar

Joined: Sat Feb 12, 2011 11:14 pm
Posts: 264
Custom Title: Peter Budaj Superstar
Braden Holtby - $26, 1 year
Antti Raanta - $15, 1 year
Blake Wheeler - $15, 3 years
Calvin de Haan - $3, 1 year
Justin Schultz - $2, 1 year
Nikita Zadorov - $1, 1 year
Brent Seabrook - $1, 1 year
Zdeno Chara - $1, 1 year


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Mon Sep 24, 2018 9:12 pm 
Offline
User avatar

Joined: Tue Dec 15, 2009 1:52 am
Posts: 39310
Location: Ice District
Custom Title: Hockey Facts.
Malkin - $20 - 3 Years
Benn - $17 - 2 Years
Getzlaf - $8 - 2 Years
Burakovsky - $3 - 3 Years
Perron - $1 - 3 Years

LeTang the Astronaut Drink for Astronauts to Drink in Space - $10 - 2 Years
McDonagh - $5 - 2 Years


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Mon Sep 24, 2018 9:17 pm 
Offline
User avatar

Joined: Tue Dec 15, 2009 1:52 am
Posts: 39310
Location: Ice District
Custom Title: Hockey Facts.
Oh I'm also entertaining trade offers on the following prospects. Looking for later draft picks:

JT Compher
Tyler Bertuzzi
Nikolay Goldobin

Let me know if you want to start your own YOUTH MOVEMENT


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Mon Sep 24, 2018 11:00 pm 
Offline
User avatar

Joined: Tue Dec 22, 2009 2:33 am
Posts: 5290
Location: Urbana, IL
Custom Title: Celestial Incinerators
captain wrote:
Malkin - $20 - 3 Years
Benn - $17 - 2 Years
Getzlaf - $8 - 2 Years
Burakovsky - $3 - 3 Years
Perron - $1 - 3 Years

LeTang the Astronaut Drink for Astronauts to Drink in Space - $10 - 2 Years
McDonagh - $5 - 2 Years


If Malkin went for $20 I really fucked up.

Having kids and working 2 jobs really screws stuff up if you want to be a fantasy success.


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Fri Sep 28, 2018 9:39 pm 
Offline
User avatar

Joined: Mon Dec 14, 2009 10:38 am
Posts: 22831
Custom Title: shermer high school
Boy did I forget completely about this!


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Fri Sep 28, 2018 10:43 pm 
Offline
User avatar

Joined: Mon Dec 14, 2009 1:01 pm
Posts: 4705
Custom Title: aggravated spearing, 46 min
cam talbot $19 / 2 yr
brent burns $20 / 1 yr
andreas johnsson $3 / 4 yr
matt duchene $5 / 3 yr
colton parayko $7 / 2 yr
ryan nugent-hopkins $6 / 3 yr
jake muzzin $6 / 4 yr
patrick marleau $3 / 1 yr


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Sat Sep 29, 2018 8:54 am 
Offline
User avatar

Joined: Mon Dec 14, 2009 10:38 am
Posts: 22831
Custom Title: shermer high school
Andreas Johnsson is my prospect, bahd.


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Sat Sep 29, 2018 10:21 am 
Offline
User avatar

Joined: Mon Dec 14, 2009 10:38 am
Posts: 22831
Custom Title: shermer high school
Alexander Radulov - $8 - 1yr
Yanni Gourde - $5 - 3 yrs
Reilly Smith - $4 - 3yrs
Derek Stepan - $2 - 2yrs
Sami Vatanen - $1 - 3yrs
Colin Miller - $1 - 4yrs
Thomas Greiss - $1 - 2yrs
David Schlemko - $1 - 1yr
Alec Martinez - $1 - 1yr

Klas Dahlbeck is immediately thrown back to the ocean. Seriously what in the hell.

I have respectfully not decided to honour my agreed upon contracts with Svechnikov, Zadina, and Heskeinen


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Sat Sep 29, 2018 11:18 am 
Offline
User avatar

Joined: Mon Dec 14, 2009 1:01 pm
Posts: 4705
Custom Title: aggravated spearing, 46 min
ah yeah sorry ignore johnsson


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Mon Oct 01, 2018 6:37 pm 
Offline
User avatar

Joined: Mon Oct 07, 2013 3:27 pm
Posts: 62
Marc-Andre Fleury $14 2 years
Henrik Lundqvist $8 2 years
Cam Atkinson $3 2 years
Jeff Carter $5 1 year
Will Butcher $6 2 years
Roberto Luongo $4 1 year
Duncan Keith $3 2 years
Kevin Labanc $1 3 years
Pat Maroon $2 2 years
Nick Bjugstad $1 2 years


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Tue Oct 02, 2018 6:41 am 
Offline
User avatar

Joined: Mon Dec 14, 2009 8:57 pm
Posts: 15368
Location: Panik on the Streets of Carlyle
Max Pacioretty $10 - 3 years
Pekka Rinne $26 - 1 year
Claude Giroux $18 - 3 years
Sergei Bobrovsky $19 - 2 years
Nazem Kadri $6 - 2 years
Keith Yandle $5 - 2 years
Joe Thornton $3 - year
Corey Crawford $8 - 1 year
Justin Faulk $2 - 2 years
Tyler Myers $3 - 1 year
Bryan Little $3 - 1 year
Shea Weber $2 - 2 years
Tyler Johnson $1 - 2 years


Top
 Profile  
 
 Post subject: Re: 2018-19 CFL Season
PostPosted: Wed Oct 03, 2018 3:10 am 
Offline
User avatar

Joined: Tue Dec 15, 2009 1:52 am
Posts: 39310
Location: Ice District
Custom Title: Hockey Facts.
just need cashin and kesse to assign contracts and we're all set


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 109 posts ]  Go to page Previous  1, 2, 3, 4, 5  Next

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group