https://drive.google.com/file/d/1hf_...ew?usp=sharing
For all who want it. Simple instructions once you download it
All you need to do is go to page two
Copy and past your players and ratings into their slots based on your depth charts,
For forwards it goes top to bottom
For blueliners it goes LD RD LD RD etc, I believe. Enter in your contract details at the end of each player and if you want to a link to your favorite tracking page for the player.
This will take that information to page one which is your main page and roster page. And also page three which is the reports page.
Now on Page one I haven't done the automation for the AHL and ECHL players, so you'll have to manually enter them there if you want to track those teams and contracts.
Just an addon the tables for the draft pick value and for the cap value are based around the idea of a total overall rating for each side of the trade. You have the ability to adjust them however you wanted. But I basically went with the concept of a 1st rounder should get you either a top line pairing player for now or the future, a second might get you a second liner or 2nd pairing blueliner etc. Same with the cap figures.
The idea, and it might be flawed was to create a valuation formula of
Total overall of players in the trade + overall valuation of picks or cap space = Overall trade rating. Then the differences in contracts or real cap space trade effects is added as a figure of 1 to million ration (ie 1 million = 1) that can be adjustable.
In the case of prospects without ratings in the table you can kind of make one up. I was thinking of adding on later where we could create a selectable table and create ratings around blue chipper good etc.