So I started playing with this and added a new trade analysis page just for fun. Its designed around putting an entire trade into one easy to look at trade
The first thing I did was create table values around cap space value and round draft pick value
Basically I decided on value vs type of players. a 5 million dollar cap swap might equal a 80 OA rated player down to no cap swap is no OA effect
I did the same thing with draft picks in terms of a first based on conversations while under probabtion will likely net you a top line player today or down the road
Then I created an entry point for your team and the offering team. There are drop downs for draft picks and cap. There is space for multiple draft picks and up to three players per side for now.
As for the attributes I chose the key speed, offensive and defensive and overall attributes, you would just need to pull them off of the ratings sheets, which btw I've added to this whole sheet
From there the analysis section will take account of the overall ratings and create an overall rating which combines both the actual OV but the draft pick and cap space equivalients. It will then combine them with the overall contract differences between players and come up with a plus or minus figure to rate the trade on your behalf.
So now the Hockeytron 5000 v6 has the following menu options
Please note that this is a fun little project on the side for me to keep my brain active during down times. Anyways, if anyone wants a copy let me know and I'll toss it on the google drive