Page 1 of 9
Hornets Cap Outlook
Posted: Thu May 15, 2014 10:11 pm
by BlackOutBuzz
So I've been working on a cap spreadsheet for the Bobcats/Hornets, and I felt I would share. The basis of it is this past season, but extends five years into the future (when this year's draft picks will be due qualifying offers). When I first started this I used a layout similar to spotrac, so some similarities are there, but I kept making changes (mainly due to preference) as well as adding additional features like a rookie salary table and draft pick vlookups. Here's a snapshot (you'll need to open a new tab to see the whole thing):

Very colorful I know, but there's a legend below the screenshot that details everything (dead money, qualifying offers, non-guaranteed money, etc.). I learned some stuff putting this together: like the fact that Pargo and Tolliver made more money than their cap hit due to taking the veteran minimum, how JT's salary was configured (which I use to make a formula to determine an estimate of what our 2nd round pick may make), how to calculate 10-day contract amounts, etc.
The most relevant thing right now is the draft pick table. As you can tell, right now the Detroit pick is listed as "Stays in Detroit." However, if they fall back in the lottery, changing the "8" to a "9" (or later) will instantly return the cap hits of that pick for the next four years and the fifth-year qualifying offer (listed like the Portland pick below it). I also added an "Acquired Pick" option, just in case we swing a trade. Say you wanted to play with the possibilities and see the cap impact of acquiring the 14th pick, simply type "14" where the "0" is and the yearly cap hits will pop up.
This is all tied to the "Cap Space" option toward the bottom of the screenshot, so you can see the cap impacts of McBob not returning, getting the Detroit pick, trading up for a higher pick, etc. For instance, right now we're on pace for about $16.5m in cap space if the picks fall as they are listed now, but getting the ninth pick immediately takes our cap space to just shy of $14m.
There's also other tabs for future RFA, UFAs, Rookie salary table, and minimum salary table. Here's a link to the file if you'd like to play with it:
https://www.mediafire.com/?6bc9zxlt1tfcl9r
Re: Hornets Cap Outlook
Posted: Thu May 15, 2014 10:20 pm
by JDR720
Good job, very useful
Re: Hornets Cap Outlook
Posted: Thu May 15, 2014 10:21 pm
by MasterIchiro
What about the possibility Al Jefferson can opt out after 2014-2015?
Is that on there?
And do you think the front office will take action now and pursue Greg Monroe a year in advance of Al possibly opting out as free agency rumors suggest?
Re: Hornets Cap Outlook
Posted: Thu May 15, 2014 10:25 pm
by JDR720
I dont think Al will opt out, he isn't getting more than 13.5 being 30 years old and most teams would have to redo their offense for him, also he seems to really like Charlotte
Re: Hornets Cap Outlook
Posted: Thu May 15, 2014 10:27 pm
by BlackOutBuzz
I tried to add buttons on there for guys with Player Options, like "Check if opts out." However, my excel skills failed me there. I can maybe do an IF statement for them, but you can just reduce Al's salary to 0 and the cap space for that year will reflect it.
I'm personally not a fan of Monroe, but I could see it. They seemed determined to spend sooner rather than later. With $16.5 million to spend pending the lottery and McBob's decision, they'll likely be compelled to make a move.
Sent from my SM-G900V using RealGM Forums mobile app
Re: Hornets Cap Outlook
Posted: Thu May 15, 2014 10:29 pm
by Liver_Pooty
I use this most of the time.
http://hoopshype.com/salaries/charlotte.htmWell done, though.
Re: Hornets Cap Outlook
Posted: Thu May 15, 2014 10:48 pm
by MasterIchiro
What is the cap space if the Pistons pick does not convey and if they let McRoberts walk?
Re: Hornets Cap Outlook
Posted: Thu May 15, 2014 10:54 pm
by Liver_Pooty
MasterIchiro wrote:What is the cap space if the Pistons pick does not convey and if they let McRoberts walk?
Off the top of my head around 20 million maybe? Can go to the website I posted above and figure it out. Im on my phone.
Re: Hornets Cap Outlook
Posted: Thu May 15, 2014 10:55 pm
by MasterIchiro
Holy crap it's like 19 million if Detroit keeps their pick and McRoberts walks.
I think we're going to see Monroe here and our shooter will come via trade instead of free agency.
I'd love to see pick 24 dealt for Tim Hardaway Jr.
Kemba Walker
Tim Hardaway Jr.
Michael Kidd-Gilchrist
Greg Monroe
Al Jefferson
Re: Hornets Cap Outlook
Posted: Thu May 15, 2014 10:57 pm
by MasterIchiro
Liver_Pooty wrote:MasterIchiro wrote:What is the cap space if the Pistons pick does not convey and if they let McRoberts walk?
Off the top of my head around 20 million maybe? Can go to the website I posted above and figure it out. Im on my phone.
I figured it out.
You have to enter 0 in the yellow box for McRoberts salary in 2014-2015 and then when you click on the salary cap space box the total changes. It doesn't change until you click on it.
Re: Hornets Cap Outlook
Posted: Thu May 15, 2014 10:58 pm
by JDR720
MasterIchiro wrote:Holy crap it's like 19 million if Detroit keeps their pick and McRoberts walks.
I think we're going to see Monroe here and our shooter will come via trade instead of free agency.
I'd love to see pick 24 dealt for Tim Hardaway Jr.
Kemba Walker
Tim Hardaway Jr.
Michael Kidd-Gilchrist
Greg Monroe
Al Jefferson
gonna have to offer a lot more than the 24th pick for Tim, he was drafted 24th and played like a lottery pick
Re: Hornets Cap Outlook
Posted: Thu May 15, 2014 11:02 pm
by Liver_Pooty
JDR720 wrote:MasterIchiro wrote:Holy crap it's like 19 million if Detroit keeps their pick and McRoberts walks.
I think we're going to see Monroe here and our shooter will come via trade instead of free agency.
I'd love to see pick 24 dealt for Tim Hardaway Jr.
Kemba Walker
Tim Hardaway Jr.
Michael Kidd-Gilchrist
Greg Monroe
Al Jefferson
gonna have to offer a lot more than the 24th pick for Tim, he was drafted 24th and played like a lottery pick
Yeah, plus Knick fans are in love with him.
Re: Hornets Cap Outlook
Posted: Thu May 15, 2014 11:06 pm
by MasterIchiro
JDR720 wrote:MasterIchiro wrote:Holy crap it's like 19 million if Detroit keeps their pick and McRoberts walks.
I think we're going to see Monroe here and our shooter will come via trade instead of free agency.
I'd love to see pick 24 dealt for Tim Hardaway Jr.
Kemba Walker
Tim Hardaway Jr.
Michael Kidd-Gilchrist
Greg Monroe
Al Jefferson
gonna have to offer a lot more than the 24th pick for Tim, he was drafted 24th and played like a lottery pick
Not much more. This is a really deep draft. Shabazz is as good as anyone in last years lottery.
Re: Hornets Cap Outlook
Posted: Thu May 15, 2014 11:06 pm
by JDR720
Liver_Pooty wrote:JDR720 wrote:MasterIchiro wrote:Holy crap it's like 19 million if Detroit keeps their pick and McRoberts walks.
I think we're going to see Monroe here and our shooter will come via trade instead of free agency.
I'd love to see pick 24 dealt for Tim Hardaway Jr.
Kemba Walker
Tim Hardaway Jr.
Michael Kidd-Gilchrist
Greg Monroe
Al Jefferson
gonna have to offer a lot more than the 24th pick for Tim, he was drafted 24th and played like a lottery pick
Yeah, plus Knick fans are in love with him.
but Dolan is a certified dumbo so he will probably overrule Jackson and do it
Re: Hornets Cap Outlook
Posted: Thu May 15, 2014 11:08 pm
by JDR720
MasterIchiro wrote:JDR720 wrote:MasterIchiro wrote:Holy crap it's like 19 million if Detroit keeps their pick and McRoberts walks.
I think we're going to see Monroe here and our shooter will come via trade instead of free agency.
I'd love to see pick 24 dealt for Tim Hardaway Jr.
Kemba Walker
Tim Hardaway Jr.
Michael Kidd-Gilchrist
Greg Monroe
Al Jefferson
gonna have to offer a lot more than the 24th pick for Tim, he was drafted 24th and played like a lottery pick
Not much more. This is a really deep draft. Shabazz is as good as anyone in last years lottery.
deep draft yes, but who is to say they will draft Shabazz? and he might not even be there at 24, and Tim is somewhat proven even tho he is just a 2nd year player, i dont think a trade for Shabazz for Tim make them better
Re: Hornets Cap Outlook
Posted: Thu May 15, 2014 11:09 pm
by MasterIchiro
JDR720 wrote:MasterIchiro wrote:JDR720 wrote:gonna have to offer a lot more than the 24th pick for Tim, he was drafted 24th and played like a lottery pick
Not much more. This is a really deep draft. Shabazz is as good as anyone in last years lottery.
deep draft yes, but who is to say they will draft Shabazz? and he might not even be there at 24, and Tim is somewhat proven even tho he is just a 2nd year player, i dont think a trade for Shabazz for Tim make them better
It definitely makes them better. They have Shumpert at SG. Hardaway Jr. is not a huge upgrade over Shumpert but Felton really destroys that team.
Re: Hornets Cap Outlook
Posted: Thu May 15, 2014 11:37 pm
by BlackOutBuzz
Liver_Pooty wrote:MasterIchiro wrote:What is the cap space if the Pistons pick does not convey and if they let McRoberts walk?
Off the top of my head around 20 million maybe? Can go to the website I posted above and figure it out. Im on my phone.
That site has different numbers for Al compared to what I've seen reported most places. And Hamilton on the cap but nothing for White.
There are similar sites like spotrac and storytellers but with mine you can edit to look at different possibilities. Plus I haven't seen any that add the draft pick amounts. I sound defensive... but with my spreadsheet you can just punch the numbers in yourself.
Sent from my SM-G900V using RealGM Forums mobile app
Re: Hornets Cap Outlook
Posted: Thu May 15, 2014 11:38 pm
by BlackOutBuzz
MasterIchiro wrote:Liver_Pooty wrote:MasterIchiro wrote:What is the cap space if the Pistons pick does not convey and if they let McRoberts walk?
Off the top of my head around 20 million maybe? Can go to the website I posted above and figure it out. Im on my phone.
I figured it out.
You have to enter 0 in the yellow box for McRoberts salary in 2014-2015 and then when you click on the salary cap space box the total changes. It doesn't change until you click on it.
That's weird. You should be able to enter in the 0 and press enter to update it, unless it lost some functionality when I uploaded it.
Sent from my SM-G900V using RealGM Forums mobile app
Re: Hornets Cap Outlook
Posted: Fri May 16, 2014 12:17 am
by countryboi
Haywood is going to make 10 mil next season?
Re: Hornets Cap Outlook
Posted: Fri May 16, 2014 12:37 am
by HornetJail
countryboi wrote:Haywood is going to make 10 mil next season?
unguaranteed. basically we can pull off a reverse Tyson Chandler move if we wanted to