An offer around the hideously expensive Hockeytron 5000

[Hanni]

Me too please!

[CaptainCrunch]

I think I've filled all the requests, let me know if I missed you.


Also let me know if there's anything else that you would like to see tracked on this. I've got pretty basic measurements.



Goals per dollar, assists per dollars, points per dollar.
As well as calculating production in real life over 82 games.
Break down by position
Offensive distribution breakdown forward and defensemen
Attributes as a percentage per line and per defensive pair (Ie you might have a forward line with a 79% defensive rating, or speed rating or whatever.


What else can I break down.


I was thinking if there was a way to create something around line fit, but that might be tough. What I mean about line fit is combination of do you have a playmaker with a scorer with a defensive presence but I'm not sure how that would work.

[Hanna Sniper]

I'm late to the party but I'll love to take a look.

It sounds a lot more in depth then what I have so I
m not sure what comments I could add. But maybe something I think is not important may be exactly what you're looking for

Doug
Hurricanes

[CaptainCrunch]

Sent dude

[flambers]

Same would love to check it out

[CaptainCrunch]

Sent

[looooob]

Originally Posted by savardandjokinen

Me as well please

geez do your own homework

[devo22]

would love to take a look too. Thanks!

[CaptainCrunch]

Sent.


Note I did get one brilliant modification idea that I really like.


On the draft board on page 4.




Insert a column in front do for example because they line up, insert a column at the start of the NA skaters which will also insert a column for the European skaters. And insert a column at the start of the goalie tables which will insert for the Eur goaltenders and the HN first round.


Label these two new columns as drafted or whatever


Select a whole table including headers ie NA skaters.


Insert a filter in the drafted column and set show if blank.


Repeat for the other columns.


Now on draft day, if a player gets picked and you put an x in that column, that player will be hidden.

[agulati]

Can I get a copy too

[CaptainCrunch]

Originally Posted by agulati

Can I get a copy too

Sure

[CaptainCrunch]

So with the rerates.


It was pretty easy to just copy and the new ratings into page two, however I did have to add the MO rating, to make things match. This didn't effect any of the calculations on the report page at all.


It took me about 20 minutes in total, to find the ratings on the new re-rates spreadsheet, and then past them to their players on the page two of the Master Spreadsheet.

[CaptainCrunch]

Link for all to my google drive


https://drive.google.com/file/d/1sCD...ew?usp=sharing


Things changed.


Modified page two ratings to fit re rates.
Page 3 report, created Attributes charts for all four lines and 3 defensive pairings.

Examples

[CaptainCrunch]

Mark 2 mod for those that want it. All entries take place on the rating page. Just enter in contract status and contract amount and it will enter on the first master page and the 3rd reporting stage. This reduces to one place of entry and should be easier.


https://drive.google.com/file/d/1Kj7...ew?usp=sharing

[CaptainCrunch]

I did a last update today. Let me know if you want me to put this in the google drive


1) Fixed an issue on the masterpage that prevented all data entry to take place in the Player rating page. Now you enter in your player and ratings and contract length and cost on the Player rating page and it will translate to the master page and the report page.


2) Added all of the Calgary Puck rating pages to their own sheets here labeled Defense Mastar Attributes, forward master Attributes and goalie master attributes


3) Besides adding graphs around attributes per player per line and blueline pairings have now added average ratings per line versus league averages per attributes.

Spoiler!

Spoiler!

Let me know if you guys want me to post the spreadsheet up on the google drive

[CaptainCrunch]

If anyone is interested I'm going to add the salary grid pages to the sheet, as well, I'm working on a trade analysis page that you can use when doing trade discussion.


I'm working on creating rough draft pick numeric values and salary space numeric values that when combined with ratings and age should help valuate trades.


This will probably take a couple of days to figure out, but I would value anyone's feedback or ideas on how to evaluate a trade as a formula

[CaptainCrunch]

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

Spoiler!

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.

Spoiler!

So now the Hockeytron 5000 v6 has the following menu options

Spoiler!

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

[Swayze11]

Yea but can this new version do my taxes? If not, I would recommend starting over.

[CaptainCrunch]

How did you know?

[Swayze11]

Now we are talking, send it over!