EHM Editor v0.3.5 Released

A new version of the Eastside Hockey Manager 1 Editor is now available for download from here:

This is essentially a hotfix and features just two changes:

New Features:

  • Added Playable League Dates spreadsheet export via File -> Export Spreadsheet.

Fixes and Improvements:

  • Fixed bug on the Staff filter screen which would cause players or non-players to be filtered out when no non-player or player specific filters were enabled.

I’m hoping the Playable League Dates spreadsheet might help with debugging some of these in-game crashes. The spreadsheet will generate a list of all stages of each playable league in the database (i.e. every league from the Rules & Structures screen). The data it shows for each stage depends on whether the stage is a league stage or a cup stage. A league stage is shown as a single row whereas cup stages are listed round by round.

I have set out below a brief summary of what detail is shown. This isn’t 100% perfect but it should hopefully help when we get date-related crashes. For instance, xECK29x recently mentioned a crash on 22 March 2020. You could then filter out the Draw Dates and End Dates (Columns H and J) in the spreadsheet (and possibly also the Start Dates) to see what might relate to 21-23 March 2020. For example, the first round of the SHL playoffs finishes on 21 March 2020.

It is important to note that there is a one day margin of error in the spreadsheet and in the Editor where the schedule date in question falls on a leap year. When you look at the Schedule Dates in the Editor, you will see that it allows you to set the Day & Month along with the Year Offset. The database actually stores the Day and Month simply as a Day Number (e.g. 0 = 1st day of the year aka 1 January; 1 = 2nd day of the year aka 2 January; etc) – the Editor shows this as Day & Month so that it is easy to understand. What I hadn’t appreciated until now is that if the year on which the date falls is a leap year (such as 2020) then there is a one day margin for error because the 60th day of the year will fall on 29 February on a leap year and on 1 March on a non-leap year. So you will find that dates are one year out in game in comparison to the Editor/spreadsheet. Hence it is worth assuming that dates listed in the spreadsheet for any leap year have a one day margin of error.

League Stages
Stage No: Stage number of the league stage.
Start Date: The date on which the first league game is played.
End Date: The date on which the final league game is played.

Note: Certain league stages do not have any schedule dates (e.g. the various additional simultaneous initial stages where a schedule template is used) and therefore the State Date and End Dates will be blank.

Cup Stages
Stage No: Stage number of the cup round.
Round: Round number of cup round.
Start Date: The date on which the first game of the cup round is played.
End Date: The date on which the first game of the cup round is played.

Additional Columns
Last Stage: No: This is the “Stage to Draw Teams” setting from the Editor. In other words, this shows the stage number from which the current stage draws its teams (the “Last Stage“).
Last Stage: End Date: This is the date on which the Last Stage finishes. This is useful because you can compare it with the Draw Date of the current stage.
Last Stage: Date Clash: The Draw Date of the current stage should occur on either the end date of the Last Stage or any time afterwards. If it does not then it will state “_ERROR_” in this column. It’s worth noting that this isn’t 100% reliable because if the preceding stage does not have any dates (such as certain league stages) then there is nothing to compare against. Also, it doesn’t take into account third/fourth place cup rounds because it will compare against the end date of the final rather than the semi finals. So you might see some errors listed because of the fact there is a third/fourth place cup game (which you can safely ignore).


Founder and webmaster of The Blue Line