05-29-2020, 07:41 AM
|
#21
|
First Line Centre
|
Me too please!
|
|
|
05-29-2020, 10:15 AM
|
#22
|
Norm!
|
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.
__________________
My name is Ozymandias, King of Kings;
Look on my Works, ye Mighty, and despair!
|
|
|
The Following User Says Thank You to CaptainCrunch For This Useful Post:
|
|
05-29-2020, 10:25 AM
|
#23
|
Franchise Player
Join Date: Nov 2002
Location: Hamilton, Ontario
|
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
__________________
2018 OHL CHAMPIONS
2022 OHL CHAMPIONS
|
|
|
05-29-2020, 10:34 AM
|
#24
|
Norm!
|
Sent dude
__________________
My name is Ozymandias, King of Kings;
Look on my Works, ye Mighty, and despair!
|
|
|
The Following User Says Thank You to CaptainCrunch For This Useful Post:
|
|
05-29-2020, 06:26 PM
|
#25
|
Franchise Player
Join Date: Aug 2002
Location: Calgary
|
Same would love to check it out
|
|
|
05-29-2020, 07:12 PM
|
#26
|
Norm!
|
Sent
__________________
My name is Ozymandias, King of Kings;
Look on my Works, ye Mighty, and despair!
|
|
|
05-30-2020, 09:38 AM
|
#27
|
Franchise Player
|
Quote:
Originally Posted by savardandjokinen
Me as well please
|
geez do your own homework
|
|
|
05-30-2020, 09:39 AM
|
#28
|
Franchise Player
Join Date: Jun 2011
Location: Austria, NOT Australia
|
would love to take a look too. Thanks!
|
|
|
05-30-2020, 10:18 AM
|
#29
|
Norm!
|
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.
__________________
My name is Ozymandias, King of Kings;
Look on my Works, ye Mighty, and despair!
|
|
|
06-01-2020, 09:16 AM
|
#30
|
Franchise Player
|
Can I get a copy too
|
|
|
06-01-2020, 11:51 AM
|
#31
|
Norm!
|
Quote:
Originally Posted by agulati
Can I get a copy too
|
Sure
__________________
My name is Ozymandias, King of Kings;
Look on my Works, ye Mighty, and despair!
|
|
|
The Following User Says Thank You to CaptainCrunch For This Useful Post:
|
|
06-01-2020, 11:56 AM
|
#32
|
Norm!
|
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.
__________________
My name is Ozymandias, King of Kings;
Look on my Works, ye Mighty, and despair!
|
|
|
06-01-2020, 02:10 PM
|
#33
|
Norm!
|
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
__________________
My name is Ozymandias, King of Kings;
Look on my Works, ye Mighty, and despair!
|
|
|
06-01-2020, 03:23 PM
|
#34
|
Norm!
|
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
__________________
My name is Ozymandias, King of Kings;
Look on my Works, ye Mighty, and despair!
|
|
|
06-02-2020, 03:11 PM
|
#35
|
Norm!
|
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.
Let me know if you guys want me to post the spreadsheet up on the google drive
__________________
My name is Ozymandias, King of Kings;
Look on my Works, ye Mighty, and despair!
|
|
|
06-08-2020, 12:34 PM
|
#36
|
Norm!
|
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
__________________
My name is Ozymandias, King of Kings;
Look on my Works, ye Mighty, and despair!
|
|
|
The Following User Says Thank You to CaptainCrunch For This Useful Post:
|
|
06-08-2020, 02:37 PM
|
#37
|
Norm!
|
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
__________________
My name is Ozymandias, King of Kings;
Look on my Works, ye Mighty, and despair!
|
|
|
06-08-2020, 02:51 PM
|
#38
|
something else haha
|
Yea but can this new version do my taxes? If not, I would recommend starting over.
|
|
|
The Following User Says Thank You to Swayze11 For This Useful Post:
|
|
06-08-2020, 02:56 PM
|
#39
|
Norm!
|
How did you know?
__________________
My name is Ozymandias, King of Kings;
Look on my Works, ye Mighty, and despair!
|
|
|
06-08-2020, 04:59 PM
|
#40
|
something else haha
|
Now we are talking, send it over!
|
|
|
The Following User Says Thank You to Swayze11 For This Useful Post:
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -6. The time now is 11:18 AM.
|
|