Unlike last time, we are no longer using the History Editor. Instead, all that needs to be done is to complete a simple Excel spreadsheet - there is no longer any need to install Microsoft Access. Therefore the research will be much quicker and easier than last time. Furthermore, for the vast majority of players, we only need to add one season's worth of stats because most of the major players now have histories in the database up until 2010/11 (because we added the 2006/07 - 2010/11 histories in the previous project).
If you would like to help then please add you name to the list in this thread along with the list of teams you would like to research. You will then need to download the research zip file: https://skydrive.live.com/redir?resid=A ... 29C5C5!504
The zip file contains two spreadsheets: 1) Database List and 2) Research Spreadsheet.
First of all, open the Database List and find the roster you want to add histories to. You can either do this by pressing Ctrl + F to search for the team name or you can alternatively use the drop down arrow to find the team (as in the screenshot below). You will then see the team's rosters listed like this:
You should research the ALL of the players listed for the team in the Database List. You should NOT research players who are not listed. If a player has since been traded to another team, he should be researched for the team he appears for in the list and not his new team.
The Database List shows what the latest season of career history exists in the database for each player. For example, if it says '2010' then it means that the most recent history in the database for that player is 2010/11. Therefore all you need to research for that player is the 2011/12 season. If is says a different year then you should research all of the seasons after that season up to and including 2011/12. For example, if the player only has histories until 2005/06 then you should research all histories from 2006/07 until 2011/12. If it lists '0' for a player then all histories must be added for that player (because it means no history exists for this player in the database).
You can copy and paste the roster list for a team from the Database List into the Research Spreadsheet. This will help make things a bit quicker and easier. Many players will need more than one entry (because they will have played in both the regular season and playoffs, meaning that they need two separate entries) and so you may need to list each player more than once. Make sure that you include the player's date of birth in the Research Spreadsheet because this is needed in order to import the history into the database.
Note that you DO NOT have to complete the 'Pts' column. I just included this in order to make it easier to copy and paste the stats from websites. You can leave this column blank - or you can delete it if you like.
The stats columns have been put in the same order as they appear on HockeyDB.com. Note that the order of the PIM and +/- columns is reversed on nhl.com.
Once you have completed all of your research, simply email your Research Spreadsheet to me: archibalduk AT gmail DOT com. Please include in the email your TBL username and a list of teams you researched. You can include as many teams's research in one spreadsheet as you like.
Note that the Database List shows the correct spelling that should be used for all team and competition names. Please ensure that you use identical spelling as shown in the Database List - otherwise the research cannot be imported into the database.
Finally, here's an example of showing how the research can look in the spreadsheet (note that I've just entered stats for two players just to show how it works - I will now be completing the research for the remaining Bruins players):
*** ADDITIONAL IMPORTANT INFORMATION ***
I want to further emphasize it because this rule is absolutely vital for the success of this project:
Which players to research
The rule we need to follow is that you research the history for every single player listed for that team in the Database List. It's the only way I can successful manage this project and ensure that every player is covered. Please research every single player listed for that team's roster in the Database List - Manimal 4.2b.xls file - please do not research players who are not listed next to that team.
Here are some examples of what I mean:
1) Zach Parise is listed as a player for the New Jersey Devils on the Database List. Therefore he should be researched by the person doing the New Jersey research. I know he has moved to Minnesota, but he is listed in the Database List as a New Jersey player and therefore should be researched by the New Jersey researcher.
2) Zach Hamill is listed as a player for the Providence Bruins on the Database List. Therefore he should be researched by the Providence Bruins researcher. I know he is technically a Boston Bruin player, but he is listed as a Providence player in the Database List and therefore should be researched by the Providence researcher. [ I have deliberately listed some of the NHL players with their AHL affiliates in the Database List in order to allow a more even spread of players across the NHL and affiliate teams and to break up the task a little more evenly (last time we did the research, we had something like 50 players per NHL team and 10 per AHL team - I've tried to distribute them more evenly this time around). ]
Which stats to research
You should research all of the stats for the player. For example, if he has played for a number of different teams and/or different leagues, you should research all of these. So to take Aaron's example of Darryl Boyce:
Darryl Boyce is listed in the Database List as a Columbus Blue Jackets player and it indicates that his most recent career history is 2010:
As his most recent history is 2010 (i.e. 2010/11), you will need to research all of his history for 2011/12. If it had said something like 2007 (i.e. 2007/08) then you would have had to research seasons 2008/09 onwards. So, when researching Boyce's 2010/11 stats, you'll see he's played for several teams:
As I mentioned, you need to add all of the history for the relevant seasons. Therefore this is how Boyce would look like in your research sheet:
NHL.com stats
Please note that the stats shown on NHL.com have the +/- and PIM columns in the opposite order to the way they're shown in the Research Spreadsheet. Please make sure you get the PIM and +/- stats in the correct columns in the Research Spreadsheet if you use NHL.com for any stats. The reason for this difference is because I designed the Research Spreadsheet to follow the HockeyDB.com column order.
If you need any further clarification, please let me know and I'll do my best to help.
I know once trades/updates have been made to the Manimal Rosters, that there will some new players appearing on rosters whose stats haven't been researched. I will be picking these up at a later date to ensure that there are no gaps.
Leagues to list entries under
Manimal wrote:Type the league that it played in 08/09Reave wrote:Just one question.
Example: Mats Rosseli Olsen played with Furuset IF in 2008/2009. During that year that team was located in the top league in Norway. Now, as I can read in the database list it's located in the 2nd league (Norwegian First Division). Which league should I type in the history file?
That's completely the right approach to take. Always go with the real life league name. EHM will accept any combination of team and league name - so just go with whatever the actual league was.B. Stinson wrote:Oh and a couple more notes:
- Brad Phillips played for Bloomington PrairieThunder in the Central Hockey League, but they're now Bloomington Blaze on the data list, so I used this new name in Phillips' stats.
- Phillips' real-world stats say he played in the NAHL when he was on the USNTDP, while the data list has the USNTDP listed under the USHL. Since the USNTDP is in a weird situation, I just went with the real-world stats and listed his league as the NAHL. So if this will cause technical problems, he can be found at the bottom of my NYR/NYI/NJ data.
Whilst I think of it: If you deal with any Memorial Cup games (i.e. the actual Memorial Cup and not the OHL/QMJHL/WHL Playoffs), make sure you enter the league name as "Canadian Hockey League Memorial Cup" and set the Playoffs box to "N".
