Home

My EA NHL Franchise tracker

This is a discussion on My EA NHL Franchise tracker within the EA Sports NHL forums.

Go Back   Operation Sports Forums > Hockey > EA Sports NHL
MLB The Show 24 Review: Another Solid Hit for the Series
New Star GP Review: Old-School Arcade Fun
Where Are Our College Basketball Video Game Rumors?
Reply
 
Thread Tools
Old 03-11-2018, 08:44 AM   #1
Pro
 
OVR: 2
Join Date: May 2007
My EA NHL Franchise tracker

As has been discussed before on these forums and elsewhere, companion spreadsheets for Franchise mode are a nice help to track the history that the game does not. I’ve been doing this for a while and I wanted to share what I’ve come up in order to help someone else who doesn’t enjoy spending hours creating their own.

First, I’ll admit that these are far from exhaustive. There are countless additional things that could be tracked but I had to cut it off somewhere. I would like feedback, however. Let me know if I’m missing something obvious.

What I’m tracking so far:
- team records & playoff series
- team scoring and goaltending leaders
- annual depth chart
- team trade history
- cup winners and division standings
- award winners
- retired player career stats
- team draft picks
- league 1st round draft picks

All of these allow 25 years of tracking for both NHL and AHL, and it’s all designed so you can use just the sections you care about, and not the one you don’t.

EDIT: v2 (3/17/18). Added trade tracker and minor cosmetic changes. Thanks to Reddit’s redx242 for the ideas.

https://docs.google.com/spreadsheets...wzUVbqnifvqqtA


Sent from my iPhone using Operation Sports

Last edited by CgyFlames; 03-17-2018 at 09:25 AM.
CgyFlames is offline  
Reply With Quote
Advertisements - Register to remove
Old 03-11-2018, 09:05 AM   #2
Pro
 
SeattleBattleCat's Arena
 
OVR: 0
Join Date: Nov 2017
Blog Entries: 2
Re: My EA NHL Franchise tracker

Great work!

I had the idea of doing this at the start of my Battle Cats Franchise but yes I found it way too exhaustive building the spreadsheet on top of everything else going on in life in general.

Although it is way too late for me to start using this template now, I think this would be very handy for GM's who are just embarking on the journey. I'm going to save this post as a favourite so when NHL 19 comes I'll have a framework to use.

Everything you have listed as noteworthy stats is certainly on the money.

Thanks very much for your contribution.


Sent from my iPhone using Operation Sports
SeattleBattleCat is offline  
Reply With Quote
Old 02-02-2019, 09:15 AM   #3
Rookie
 
Lumpjaw's Arena
 
OVR: 0
Join Date: Nov 2013
Location: Sweden
Re: My EA NHL Franchise tracker

Now this thread is old, but do anyone have a copy of this? I can't open it as it says it's been moved to the trashcan.
__________________
Lumpjaw is offline  
Reply With Quote
Old 02-02-2019, 10:07 AM   #4
Rookie
 
blueline369's Arena
 
OVR: 0
Join Date: Jan 2019
Re: My EA NHL Franchise tracker

I believe you have to be logged into your google account to then save the file.

I am also building out something similar for my franchise with google sheets and google sites and will share once in a good spot. I have a game log file that builds out an entire site stats, scores, history, etc...

Love reading about the Dragons of Houston and the Seattle Battle Cats!
blueline369 is offline  
Reply With Quote
Old 02-02-2019, 12:53 PM   #5
Rookie
 
Lumpjaw's Arena
 
OVR: 0
Join Date: Nov 2013
Location: Sweden
Re: My EA NHL Franchise tracker

Quote:
Originally Posted by blueline369
I believe you have to be logged into your google account to then save the file.

I am also building out something similar for my franchise with google sheets and google sites and will share once in a good spot. I have a game log file that builds out an entire site stats, scores, history, etc...

Love reading about the Dragons of Houston and the Seattle Battle Cats!
I´m logged in, but could not open it on the phone. Tried on the computer and it worked as I could download a copy of it. However - it says that the "Owner has put the file in his trash can". But now I have a copy on ite saved to the computer.

Wow, that sounds like a big project! Looking forward to see what you come up with, I love me some excel/sheets
__________________
Lumpjaw is offline  
Reply With Quote
Advertisements - Register to remove
Old 02-11-2019, 03:29 PM   #6
Rookie
 
blueline369's Arena
 
OVR: 0
Join Date: Jan 2019
Re: My EA NHL Franchise tracker

Moved post below because you have to post 5 times before you can add links...

Last edited by blueline369; 02-11-2019 at 09:23 PM.
blueline369 is offline  
Reply With Quote
Old 02-11-2019, 09:21 PM   #7
Rookie
 
blueline369's Arena
 
OVR: 0
Join Date: Jan 2019
Re: My EA NHL Franchise tracker

I thought I would have this sheet in a good spot sooner rather than later, but then I realized this will never be done.

This sheet is a stat tracker for EA NHL 19 Franchise mode - tracking a single player on a single team.

This sheet is in no way perfect or complete. All data and formulas are in-tact so you can see where/what everything is. Follow the numbers, follow the formulas to answer the questions you have about this sheet. I do not offer tech support - sorry.

Almost the entire thing runs off the player season gamelog tab.

I urge you to make this your own, change it, edit it, tweak it, make something newer, better, bigger, awesomer.

Can’t wait to see what everyone else does - please post back and share your updates - I would love to see it!


Google Sheets Link:
http://bit.ly/2WXNjIA


SITE CONTEXT:
First and foremost, this is for fun

This site is a stat tracker for EA NHL 19 Franchise mode - tracking a single player and a single team.

If my player was/is injured, I sim those games. Otherwise, I play all games.

The site is mash up of the game, hockey-reference and everything else I wanted on the site.

I bought the domain so I could remember the dang name of my site when sharing it with others. Hopefully won’t get sued.

Please have fun!
https://www.easnhl.com/

Last edited by blueline369; 02-11-2019 at 09:26 PM.
blueline369 is offline  
Reply With Quote
Old 02-12-2019, 09:18 AM   #8
Rookie
 
gator21's Arena
 
OVR: 3
Join Date: Sep 2008
Location: Edmonton, Canada
Re: My EA NHL Franchise tracker

This is amazing!! Thanks for sharing.
gator21 is offline  
Reply With Quote
Reply


« Previous Thread | Next Thread »

« Operation Sports Forums > Hockey > EA Sports NHL »


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 10:37 PM.
Top -