New Challenge Stat Recoding Sheet (ver. 4.1)

Think you're a good EHM GM? Our GM Challenges dare you to take over a team and make it a winner. The Challenge Forum and Centre are the hubs of our Challenges.

Moderator: Challenge Moderators

Post Reply
User avatar
bruins72
TBL Admin Team
Posts: 14513
Joined: Fri Jan 20, 2006 3:13 pm
Custom Rank: Challenge Guy
Favourite Team: Boston Bruins
Location: Taunton, MA

New Challenge Stat Recoding Sheet (ver. 4.1)

Post by bruins72 »

Hey folks! I just wanted to let you know that there is a new Excel spreadsheet for recording your stats from the challenges. I've made this new version to allow for recording 7 seasons worth of data. It's also got a page in it for tracking your core roster and homegrown players (a part of the new challenge rules).

You can download Version 4.1 of the file here.

If you don't have a copy of Microsoft Excel, you should be able to use Open Office to work with the spreadsheet. I haven't used this program myself but I hear it works very well.

Please use this thread for any comments, questions, suggestions, or problems regarding the spreadsheet.
Last edited by bruins72 on Wed Jul 25, 2007 2:26 pm, edited 1 time in total.
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Post by archibalduk »

This file is a must-have for playing the Challenges. I've had the privilege of testing it whilst B72 was developing it. It's much better laid out than the previous version of the spreadsheet (designed by myself and Rubbinio) and is going to prove vital in keeping track of your core and homegrown players.

There's the possibility of adding graphs and stats, etc to chart your progress throughout the quarters and the seasons. B72 will be adding these functions if there is sufficient demand/interest in them and we can come up with some good ideas as to what we'd like to see in the way of stats/graphs/comparision. If anyone has any suggestions as to what stats/graphs, if any, they'd like to see added to the spreadsheet then let us know.
User avatar
Danny
Stanley Cup Winner
Posts: 1258
Joined: Wed Feb 21, 2007 5:40 pm

Post by Danny »

Thanks B72 :thup:

I can confirm it works perfectly with Open Office
User avatar
CatchUp
TBL Mod Team
Posts: 1879
Joined: Sun Dec 10, 2006 9:01 pm
Custom Rank: CEO Of Avatars Inc.
Location: Toronto, ON

Post by CatchUp »

New rules, new spreadsheet, new database! We're rockin! :rock:
User avatar
bruins72
TBL Admin Team
Posts: 14513
Joined: Fri Jan 20, 2006 3:13 pm
Custom Rank: Challenge Guy
Favourite Team: Boston Bruins
Location: Taunton, MA

Post by bruins72 »

That we are, Catchup! Hopefully, all of that will help keep the game fresh and maintain people's interest. If people keep playing and talking about the game, maybe someday they're bring it back?
User avatar
Shadd666
Super Mario
Posts: 2996
Joined: Mon Mar 27, 2006 5:47 pm
Custom Rank: Smiley Crazy Goodwill Ambassador!
Location: Toulouse (France)

Post by Shadd666 »

Finally get OpenOffice to be able to download the spreadsheet... (don't have Office on my actual computer :roll:) Nice work B72! :thup:
User avatar
Lidas
Stanley Cup Winner
Posts: 1494
Joined: Sun Jul 29, 2007 12:08 pm
Custom Rank: Rosters Legend
Location: Osaka, Japan

Post by Lidas »

Im having problems with the sheet when I get to season 4.

The sheet gives me the team stats for season 3, but still the player stats from season 4.
User avatar
bruins72
TBL Admin Team
Posts: 14513
Joined: Fri Jan 20, 2006 3:13 pm
Custom Rank: Challenge Guy
Favourite Team: Boston Bruins
Location: Taunton, MA

Post by bruins72 »

Ugggh! I thought I had all the bugs worked out. I'm a little tied up until next week. I'll take a look at it then and get a fixed version up. Sorry about that.
User avatar
batdad
The Great One
Posts: 12616
Joined: Thu Aug 17, 2006 7:46 pm
Custom Rank: Mr Technology
Favourite Team: Syracuse Bulldogs.
Location: Look behind you, you peon

Post by batdad »

Not sure...but did you get a new version done? I am having the same problem that Lidas had. It just took season 3's stats.
User avatar
bruins72
TBL Admin Team
Posts: 14513
Joined: Fri Jan 20, 2006 3:13 pm
Custom Rank: Challenge Guy
Favourite Team: Boston Bruins
Location: Taunton, MA

Post by bruins72 »

Ooops! I've been busy at work and totally spaced on this. I'll try to get a fixed version up in the next day or two.
User avatar
bigargon
Minor League
Posts: 225
Joined: Thu Jul 26, 2007 10:12 pm
Location: Connecticut, USA

Post by bigargon »

:-? Good i wondered if I was to only one who had problems with season 4

other then that the spreadsheet is great, it makes data collection a breeze.

I wish my job used better data collection like this, my job is in the stone ages when it come to data collection.
User avatar
bruins72
TBL Admin Team
Posts: 14513
Joined: Fri Jan 20, 2006 3:13 pm
Custom Rank: Challenge Guy
Favourite Team: Boston Bruins
Location: Taunton, MA

Post by bruins72 »

Okay. I think it's been resolves. The new version is up. Check the main page.
User avatar
bigargon
Minor League
Posts: 225
Joined: Thu Jul 26, 2007 10:12 pm
Location: Connecticut, USA

Post by bigargon »

I just tried the new data sheet. only the player data displayed on season four (i didn't put the previous seasons on it ..too much typing..lol) none of the team info (i.e, wins, losses, ties, etc.).
User avatar
bruins72
TBL Admin Team
Posts: 14513
Joined: Fri Jan 20, 2006 3:13 pm
Custom Rank: Challenge Guy
Favourite Team: Boston Bruins
Location: Taunton, MA

Post by bruins72 »

Did it work okay for you?
User avatar
bigargon
Minor League
Posts: 225
Joined: Thu Jul 26, 2007 10:12 pm
Location: Connecticut, USA

Post by bigargon »

no it didn't...it does not record the year 4 data
User avatar
CatchUp
TBL Mod Team
Posts: 1879
Joined: Sun Dec 10, 2006 9:01 pm
Custom Rank: CEO Of Avatars Inc.
Location: Toronto, ON

Post by CatchUp »

I've emailed you about this B72. :-?
User avatar
bruins72
TBL Admin Team
Posts: 14513
Joined: Fri Jan 20, 2006 3:13 pm
Custom Rank: Challenge Guy
Favourite Team: Boston Bruins
Location: Taunton, MA

Post by bruins72 »

Sorry. I've been totally spacing. I'll have another version posted soon.
User avatar
bruins72
TBL Admin Team
Posts: 14513
Joined: Fri Jan 20, 2006 3:13 pm
Custom Rank: Challenge Guy
Favourite Team: Boston Bruins
Location: Taunton, MA

Post by bruins72 »

Okay, a new corrected version should be available to download soon. The problems should be resolved this time. Thanks to Catchup for testing.
Post Reply