Two Plus Two Publishing LLC Two Plus Two Publishing LLC
 

Go Back   Two Plus Two Poker Forums > >

Notices

Sporting Events Discussion centered around sporting events.

Reply
 
Thread Tools Display Modes
Old 07-26-2017, 04:34 PM   #76
aejones
Carpal \'Tunnel
 
aejones's Avatar
 
Join Date: Sep 2005
Location: Running the Streets
Posts: 20,017
Re: 2017/2018 NBA salary cap draft thread

Quote:
Originally Posted by vinivici9586 View Post
im not sure i follow. do you mean once you hit 80m you can sign any min players (like in the nba)? i think this makes the most sense rather than having to do annoying math a few picks out (tho im obv bias considering i just broke the bank)
im pretty sure that min slots are just all 800k against the cap, even if you have 6 years service or 10 years or w/e (those go to like 1.3 or 1.6m or w/e)
aejones is offline   Reply With Quote
Old 07-26-2017, 04:36 PM   #77
Seadood228
Carpal \'Tunnel
 
Seadood228's Avatar
 
Join Date: Apr 2004
Location: People's champ
Posts: 24,292
Re: 2017/2018 NBA salary cap draft thread

Can't we just put it in the "teams" tab, then add the 8 salaries' value, and have it subtracted from 80,000,000? Then we put the league minimum in everybody's empty roster spot and it'll spit out our available cap #.

It's easy in excel, never tried it in GD but I assume it's similar.
Seadood228 is offline   Reply With Quote
Old 07-26-2017, 04:39 PM   #78
aejones
Carpal \'Tunnel
 
aejones's Avatar
 
Join Date: Sep 2005
Location: Running the Streets
Posts: 20,017
Re: 2017/2018 NBA salary cap draft thread

Quote:
Originally Posted by Seadood228 View Post
Can't we just put it in the "teams" tab, then add the 8 salaries' value, and have it subtracted from 80,000,000? Then we put the league minimum in everybody's empty roster spot and it'll spit out our available cap #.

It's easy in excel, never tried it in GD but I assume it's similar.
this would basically be it in theory, yea, so like every roster spot carries a minimum hold of 815,615, so you can auto fill that in for every team, and then when you get a min guy he counts only as the min even if it's some vet who signed a min deal

edit: so in theory what teams have "left" as far as remaining space would be [first player] - 7x815,615 if that makes sense
aejones is offline   Reply With Quote
Old 07-26-2017, 04:39 PM   #79
RebeccaTwigley
Carpal \'Tunnel
 
Join Date: Jul 2010
Location: #freehoofball
Posts: 7,881
Re: 2017/2018 NBA salary cap draft thread

Quote:
Originally Posted by Seadood228 View Post
Can't we just put it in the "teams" tab, then add the 8 salaries' value, and have it subtracted from 80,000,000? Then we put the league minimum in everybody's empty roster spot and it'll spit out our available cap #.

It's easy in excel, never tried it in GD but I assume it's similar.
pm your email, ill give you access.
RebeccaTwigley is offline   Reply With Quote
Old 07-26-2017, 04:42 PM   #80
Seadood228
Carpal \'Tunnel
 
Seadood228's Avatar
 
Join Date: Apr 2004
Location: People's champ
Posts: 24,292
Re: 2017/2018 NBA salary cap draft thread

great now I have to figure out what to do.... jk I'll give it a go.
Seadood228 is offline   Reply With Quote
Old 07-26-2017, 04:43 PM   #81
aejones
Carpal \'Tunnel
 
aejones's Avatar
 
Join Date: Sep 2005
Location: Running the Streets
Posts: 20,017
Re: 2017/2018 NBA salary cap draft thread

then when you sign a 20m guy, now you have 1st round pick + 20m - 6x 815,615.

does this make sense?
aejones is offline   Reply With Quote
Old 07-26-2017, 04:45 PM   #82
aejones
Carpal \'Tunnel
 
aejones's Avatar
 
Join Date: Sep 2005
Location: Running the Streets
Posts: 20,017
Re: 2017/2018 NBA salary cap draft thread

idk how to do this in google sheets but im sure someone does (or you can google it), but you can make sheet 1 feed into sheet 2, and (much easier) just make b4 on sheet 2 be jokic's salary, then have b5-b11 be the rest of your team's salary, and fill in 815,615 for your other spots, and then have total salary be in b12, then remaining salary be in like b15 where b15=80,000,000-b12
aejones is offline   Reply With Quote
Old 07-26-2017, 04:56 PM   #83
Cinarocket
Carpal \'Tunnel
 
Cinarocket's Avatar
 
Join Date: Nov 2009
Location: Ruining spuds dreams
Posts: 10,006
Re: 2017/2018 NBA salary cap draft thread

**** it's on me apparently, have no clue who i'm going to pick yet but gonna try to make it quick. be ready for the lols
Cinarocket is offline   Reply With Quote
Old 07-26-2017, 04:56 PM   #84
Krayz
Carpal \'Tunnel
 
Krayz's Avatar
 
Join Date: Dec 2010
Posts: 45,847
Re: 2017/2018 NBA salary cap draft thread

It would be easiest just to have the min contract prefilled in for every pick and then replaced when it is made.
Krayz is offline   Reply With Quote
Old 07-26-2017, 04:57 PM   #85
kkcountry
BBV MS Paint Rapid Response Squad
 
kkcountry's Avatar
 
Join Date: Jun 2006
Location: dimichele ripped
Posts: 31,084
Re: 2017/2018 NBA salary cap draft thread

Man last round is gonna be grate when multiple teams have max money left 😂😂😂
kkcountry is offline   Reply With Quote
Old 07-26-2017, 04:57 PM   #86
tchaz
Carpal \'Tunnel
 
tchaz's Avatar
 
Join Date: Jul 2008
Posts: 11,632
Re: 2017/2018 NBA salary cap draft thread

Grunch - is McLovin still looking for a co owner? I'll volunteer, eurolandia time zone tho
tchaz is offline   Reply With Quote
Old 07-26-2017, 05:06 PM   #87
LFC_USA
Carpal \'Tunnel
 
LFC_USA's Avatar
 
Join Date: Aug 2012
Posts: 8,807
Re: 2017/2018 NBA salary cap draft thread

I'm so confused by the actual format of this. Forgive me.

So now we are maxing out our 80m on a starting 5? And then the 3-man bench is just minimums? So the bench is basically irrelevant to our team? Bench is way more important than people are giving it credit for especially on an 8-man roster
LFC_USA is offline   Reply With Quote
Old 07-26-2017, 05:07 PM   #88
Seadood228
Carpal \'Tunnel
 
Seadood228's Avatar
 
Join Date: Apr 2004
Location: People's champ
Posts: 24,292
Re: 2017/2018 NBA salary cap draft thread

The TEAMS Sheet is almost done for 800k, I'll adjust it to the correct amount in a bit.

Can you guys let me know if this works before filling out the rest?
Seadood228 is offline   Reply With Quote
Old 07-26-2017, 05:08 PM   #89
Cinarocket
Carpal \'Tunnel
 
Cinarocket's Avatar
 
Join Date: Nov 2009
Location: Ruining spuds dreams
Posts: 10,006
Re: 2017/2018 NBA salary cap draft thread

Man I feel like there is no obvious super elite players on non-max contracts (i had one in mind making around 20M/year). Could go with BPA but since the format is fun and you play to win the game I'm going with

KAT. The 3rd season is usually when guys enter their prime and see a big jump in their game and he's already an absurd offensive player who fits the modern NBA. Has the tools to be a monster defensively and still the best nba prospect in the league right now.

Best rookie season since Duncan 25.9 PER, 61.8% TS last season while spreading the floor.



Towns - $6,216,840
Cinarocket is offline   Reply With Quote
Old 07-26-2017, 05:12 PM   #90
LFC_USA
Carpal \'Tunnel
 
LFC_USA's Avatar
 
Join Date: Aug 2012
Posts: 8,807
Re: 2017/2018 NBA salary cap draft thread

KAT is a great pick there imo
LFC_USA is offline   Reply With Quote
Old 07-26-2017, 05:12 PM   #91
King~of~Diamonds
old hand
 
Join Date: Jul 2012
Posts: 1,864
Re: 2017/2018 NBA salary cap draft thread

Quote:
Originally Posted by LFC_USA View Post
I'm so confused by the actual format of this. Forgive me.

So now we are maxing out our 80m on a starting 5? And then the 3-man bench is just minimums? So the bench is basically irrelevant to our team? Bench is way more important than people are giving it credit for especially on an 8-man roster
No. everyone counts toward 80 MM and is relevant.
King~of~Diamonds is offline   Reply With Quote
Old 07-26-2017, 05:14 PM   #92
RebeccaTwigley
Carpal \'Tunnel
 
Join Date: Jul 2010
Location: #freehoofball
Posts: 7,881
Re: 2017/2018 NBA salary cap draft thread

Was either KAT or LeBron. I wenty with the better player over smaller contract
RebeccaTwigley is offline   Reply With Quote
Old 07-26-2017, 05:17 PM   #93
Seadood228
Carpal \'Tunnel
 
Seadood228's Avatar
 
Join Date: Apr 2004
Location: People's champ
Posts: 24,292
Re: 2017/2018 NBA salary cap draft thread

So are we set on 815,615 as the minimum? I can edit that into the doc.

KAT makes my Jokic pick look worse, I think Jokic is the better player right now but that gap could narrow next year, and definitely not 5 picks better at the top.

I thought he might go #1 prior to being randed there.
Seadood228 is offline   Reply With Quote
Old 07-26-2017, 05:22 PM   #94
DodgerIrish
Fraudulent Zodiac
 
DodgerIrish's Avatar
 
Join Date: Dec 2007
Location: between overconfident and insecure
Posts: 18,852
Re: 2017/2018 NBA salary cap draft thread

wtf is Magnummike?

I'd make sure he drafts on his turn before pairing tchaz with AIM.
DodgerIrish is offline   Reply With Quote
Old 07-26-2017, 05:23 PM   #95
aejones
Carpal \'Tunnel
 
aejones's Avatar
 
Join Date: Sep 2005
Location: Running the Streets
Posts: 20,017
Re: 2017/2018 NBA salary cap draft thread

I don't think the 5m between them is THAT important. as you get to 10ish, that's where the gape between players in the later rounds starts to get pretty important
aejones is offline   Reply With Quote
Old 07-26-2017, 05:23 PM   #96
aejones
Carpal \'Tunnel
 
aejones's Avatar
 
Join Date: Sep 2005
Location: Running the Streets
Posts: 20,017
Re: 2017/2018 NBA salary cap draft thread

i'm fine with 815,615 as the min. i saw the number in two different places so i'd be cool using that. and yes i think how you did it is good
aejones is offline   Reply With Quote
Old 07-26-2017, 05:24 PM   #97
diskoteque
Joey Local
 
diskoteque's Avatar
 
Join Date: Aug 2010
Posts: 29,711
Re: 2017/2018 NBA salary cap draft thread

KAT
diskoteque is offline   Reply With Quote
Old 07-26-2017, 05:26 PM   #98
aejones
Carpal \'Tunnel
 
aejones's Avatar
 
Join Date: Sep 2005
Location: Running the Streets
Posts: 20,017
Re: 2017/2018 NBA salary cap draft thread

KAT was #1 on my board, but I had him basically tied with this guy (I also think there are several different directions you could plausibly go here, I'm not sure how the draft will go just yet so I can't definitively say this is the right direction)...

Spoiler:


If you're gonna win, you have to do it with two way players. Major positive floor spacer for his position, incredible numbers on both ends of the floor, and for just 6.1m!

Spoiler:
aejones is offline   Reply With Quote
Old 07-26-2017, 05:42 PM   #99
MagnumMike357
enthusiast
 
Join Date: Dec 2012
Posts: 84
Re: 2017/2018 NBA salary cap draft thread

Quote:
Originally Posted by DodgerIrish View Post
wtf is Magnummike?

I'd make sure he drafts on his turn before pairing tchaz with AIM.
magnummike=pick 16
Ill be there and be square
MagnumMike357 is offline   Reply With Quote
Old 07-26-2017, 05:43 PM   #100
Seadood228
Carpal \'Tunnel
 
Seadood228's Avatar
 
Join Date: Apr 2004
Location: People's champ
Posts: 24,292
Re: 2017/2018 NBA salary cap draft thread

Spreadsheet should be fully updated. Can we get a few volunteers to PM RT their emails for access to update?

You should be able to put the salaries into the TEAMS tab and it will do the math... If it doesn't work let me know and I'll try to fix it.
Seadood228 is offline   Reply With Quote

Reply
      

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Forum Jump


All times are GMT -4. The time now is 04:50 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © 2008-2010, Two Plus Two Interactive
 
 
Poker Players - Streaming Live Online