Draft Trade Calculator

[kccrow]

Interesting little calc but I'm left wanting a lot more functionality lol.

Here's some other references to the charts in there:

• Chase Stuart Draft Trade Value Chart
  
• Ben Baldwin Surplus Value Trade Chart
  
• OTC Fitzgerald-Spielberger Draft Trade Value Chart
  
• Rich Hill Draft Trade Value Chart
  
• Jimmy Johnson Draft Trade Value Chart

[The Franchise]

Originally Posted by kccrow

Interesting little calc but I'm left wanting a lot more functionality lol.

Here's some other references to the charts in there:

• Chase Stuart Draft Trade Value Chart
  
• Ben Baldwin Surplus Value Trade Chart
  
• OTC Fitzgerald-Spielberger Draft Trade Value Chart
  
• Rich Hill Draft Trade Value Chart
  
• Jimmy Johnson Draft Trade Value Chart

It would have been nice if the teams picks were already a part of it. That way I didn't have to go look up numbers and put them in but for something free...I can't complain too much.

[kccrow]

Originally Posted by The Franchise

It would have been nice if the teams picks were already a part of it. That way I didn't have to go look up numbers and put them in but for something free...I can't complain too much.

True. Although I have a Google sheet developed that's similar and lets me select teams via dropdown then check boxes to select the picks. I'd just have to extend it to include the other chart values outside of the Hill model.

From what I've seen in practice, it seems like the Hill model is really close early on (like first 3 rounds), then it tends to deviate more towards the Johnson model.

I might take the time one of these years to actually dive into the historical trades and develop my own but its a project.

I do like a bit of the stuff out there from Baldwin and Fitzgerald on salary cap value effects and things like that but I haven't seen alot in their literature on actual correlation to real trades.

[DJ's left nut]

Originally Posted by kccrow

True. Although I have a Google sheet developed that's similar and lets me select teams via dropdown then check boxes to select the picks. I'd just have to extend it to include the other chart values outside of the Hill model.

From what I've seen in practice, it seems like the Hill model is really close early on (like first 3 rounds), then it tends to deviate more towards the Johnson model.

I might take the time one of these years to actually dive into the historical trades and develop my own but its a project.

I do like a bit of the stuff out there from Baldwin and Fitzgerald on salary cap value effects and things like that but I haven't seen alot in their literature on actual correlation to real trades.

Overachiever...

[kccrow]

Originally Posted by DJ's left nut

Overachiever...

I know lol. I'm an accountant so all I do all day outside of use the ledger software is play with spreadsheets. Everything goes in a damned spreadsheet lol.

[Couch-Potato]

Originally Posted by kccrow

I know lol. I'm an accountant so all I do all day outside of use the ledger software is play with spreadsheets. Everything goes in a damned spreadsheet lol.

I work in analytics, and absolutely love excel.

It's my happy place.