Eastside Hockey Manager - Part X Patch 1.5 Edition! (Open Beta)

GKJ

Global Moderator
Feb 27, 2002
192,891
43,435
Is there an easy way to take an entire schedule template, and move every game back an entire week?
 

GKJ

Global Moderator
Feb 27, 2002
192,891
43,435
It's easily the most labor-intensive part of editing
Yeah, i know we’ve talked in the past about scheduling tools or whatnot. I don’t have outlook on my laptop that on have the game on so I never looked further than that but I’ll check some things out on ms-word webapp while watching football or something.
 

archibalduk

EHM The Blue Line
Oct 29, 2005
391
349
England
Is there an easy way to take an entire schedule template, and move every game back an entire week?

If you just want to move dates backwards then Excel is the way to go. You'll want to concatenate the days and months into a column containing the full date of any year - e.g. dd/mm/yyyy and then subtract 7 days. Its really simple and I can post an example formula when I'm next at my PC.

If you want to create a new schedule from scratch then there is a Schedule Generator button on the Schedule Templates screen (iirc under the Tools sub-menu - I'm typing this on my phone, so don't have the Editor open in front of me). The generator is far from perfect but it can generate NHL-style schedules. EDIT: The button is in the bottom right corner of the screen on the Schedule Templates screen.
 
Last edited:

archibalduk

EHM The Blue Line
Oct 29, 2005
391
349
England
Is there an easy way to take an entire schedule template, and move every game back an entire week?

Apologies if I'm explaining something you already know, but here's how you would do it:

STEP 1 - Exporting the schedule template spreadsheet
1. Navigate to the relevant schedule on the Schedule Templates screen in the Editor;
2. Click on the Schedule List tab at the top of the screen; and
3. Click on the Export Items button beneath the schedule and save the csv spreadsheet somewhere.

STEP 2 - Editing the spreadsheet
1. Open the spreadsheet in Excel. You'll see that the day, month and year offset are at Columns C, D and E;
2. In Cell F3, enter the following: =date(2021+E3,D3,C3)-7
3. In Cell G3, enter the following: =DAY(F3)
4. In Cell H3, enter the following =MONTH(F3)
5. In Cell I3, enter the following =YEAR(F3)-2021
6. You might find that some of Cells G3, H3 or I3 appear as weird dates rather than numbers. Highlight/select all of Columns G, H and I -> Right-click -> Format Cells -> Select the Number category and set Decimal Places to zero -> OK;
7. Copy and paste Cells F3, G3, H3 and I3 into all of the rows below so that the formula is beside each schedule date. You should now have the new dates for each schedule date, like this:

Schedule dates 01.png


8. Highlight/select all of Columns G, H and I -> Right-click -> Copy;
9. Highlight/select all of Columns C, D and E -> Right-click -> Paste values. If you're not sure how to do this, instead of right-clicking, press Ctrl+Alt+V -> Click on "Values" under the Paste section -> OK. The new dates will now be in Columns C, D and E.
10. Delete Columns F, G, H and I. Your spreadsheet should now look like this:

Schedule dates 02.png


11. Save the spreadsheet and exit Excel.

STEP 3 - Importing the spreadsheet
1. Back in the Editor on the same Schedule Dates -> Schedule List screen, click on Import Items (Replace) -> select your spreadsheet and click on OK. Make sure you use the Replace import and not the Append import;
2. Go to Rules & Structures - > Select your league (e.g. NHL);
3. Click on the Stages tab and then the Schedule Dates sub-tab for the first stage. Change the two dates listed to the new start and end date for the schedule template you just edited.

That's it! You'll also need to repeat this for an alternative schedule date in the Schedule Templates screen if the league has one (e.g. the NHL does) - and then the Alt. Dates sub-screen for the first stage on the Rules & Structures screen per step 3(3) above.
 

GKJ

Global Moderator
Feb 27, 2002
192,891
43,435
If you just want to move dates backwards then Excel is the way to go. You'll want to concatenate the days and months into a column containing the full date of any year - e.g. dd/mm/yyyy and then subtract 7 days. Its really simple and I can post an example formula when I'm next at my PC.

If you want to create a new schedule from scratch then there is a Schedule Generator button on the Schedule Templates screen (iirc under the Tools sub-menu - I'm typing this on my phone, so don't have the Editor open in front of me). The generator is far from perfect but it can generate NHL-style schedules.

My experience with the schedule generator from scratch was such that it kept creating schedules where teams were playing 3 or 4 games in the same amount of days. For the one league I created I may want to look at that again though.

Apologies if I'm explaining something you already know, but here's how you would do it:

STEP 1 - Exporting the schedule template spreadsheet
1. Navigate to the relevant schedule on the Schedule Templates screen in the Editor;
2. Click on the Schedule List tab at the top of the screen; and
3. Click on the Export Items button beneath the schedule and save the csv spreadsheet somewhere.

STEP 2 - Editing the spreadsheet
1. Open the spreadsheet in Excel. You'll see that the day, month and year offset are at Columns C, D and E;
2. In Cell F3, enter the following: =date(2021+E3,D3,C3)-7
3. In Cell G3, enter the following: =DAY(F3)
4. In Cell H3, enter the following =MONTH(F3)
5. In Cell I3, enter the following =YEAR(F3)-2021
6. You might find that some of Cells G3, H3 or I3 appear as weird dates rather than numbers. Highlight/select all of Columns G, H and I -> Right-click -> Format Cells -> Select the Number category and set Decimal Places to zero -> OK;
7. Copy and paste Cells F3, G3, H3 and I3 into all of the rows below so that the formula is beside each schedule date. You should now have the new dates for each schedule date, like this:

View attachment 503556

8. Highlight/select all of Columns G, H and I -> Right-click -> Copy;
9. Highlight/select all of Columns C, D and E -> Right-click -> Paste values. If you're not sure how to do this, instead of right-clicking, press Ctrl+Alt+V -> Click on "Values" under the Paste section -> OK. The new dates will now be in Columns C, D and E.
10. Delete Columns F, G, H and I. Your spreadsheet should now look like this:

View attachment 503558

11. Save the spreadsheet and exit Excel.

STEP 3 - Importing the spreadsheet
1. Back in the Editor on the same Schedule Dates -> Schedule List screen, click on Import Items (Replace) -> select your spreadsheet and click on OK. Make sure you use the Replace import and not the Append import;
2. Go to Rules & Structures - > Select your league (e.g. NHL);
3. Click on the Stages tab and then the Schedule Dates sub-tab for the first stage. Change the two dates listed to the new start and end date for the schedule template you just edited.

That's it! You'll also need to repeat this for an alternative schedule date in the Schedule Templates screen if the league has one (e.g. the NHL does) - and then the Alt. Dates sub-screen for the first stage on the Rules & Structures screen per step 3(3) above.
OK, thanks for the directions here, the actual date is a look I don't have, only the first 4 columns. I'll definitely take a look at all of this.

edit: My extent right how has just been switching dates in the NHL alternative schedule, and also worked on switching some dates (copy and paste and changing the date) of converting an ECHL schedule to a USHL schedule where teams are playing multiple times in a row.
 
Last edited:

3074326

Registered User
Apr 9, 2009
11,738
11,355
USA
Are injuries completely random?

Because I’ve now gone through the regular season pretty much completely healthy. Made the playoffs, healthy until the finals. Then everyone got hurt. I was curious, so I re-simmed four more times and the same thing. Injuries literally every game, different players though. Curious if there’s a “someone is getting hurt in this game” setting somewhere. lol

And we are talking injuries that would not allow me to ice a full roster. Would have to be using like 6 players from the minors. Never really seen anything like it.

EDIT: Tried round 5, just to see. First game. Two injuries, one of them I know was identical to an injury another player had last time.
 

xECK29x

Moderator
Sponsor
Jul 19, 2006
18,240
11,945
Deer Park, NY
Are injuries completely random?

No, if you use the editor you can see the injuries and the "chance" modifier of them happening. I'm sure how if there is any documentation anywhere to give a sense of what these values translate to. I have not modified injuries in my DB from that of the original TBL database.

upload_2022-1-31_14-22-48.png
 
  • Like
Reactions: 3074326

3074326

Registered User
Apr 9, 2009
11,738
11,355
USA
No, if you use the editor you can see the injuries and the "chance" modifier of them happening. I'm sure how if there is any documentation anywhere to give a sense of what these values translate to. I have not modified injuries in my DB from that of the original TBL database.

View attachment 503795

Much appreciated. The sixth sim had no injuries. Just had a bad run there.

I lost all six of the simmed finals. lol. Healthy or not.
 

GKJ

Global Moderator
Feb 27, 2002
192,891
43,435
No they are hard coded into the game itself, we can only modify some small details regarding the draft.
Ah, I see. I was hoping to get it moved back at least a week. Is the July 1 date hard coded as well? I thought I saw a screen when I was editing before about the date contracts end since some leagues' free agency starts on different days.
 

xECK29x

Moderator
Sponsor
Jul 19, 2006
18,240
11,945
Deer Park, NY
Ah, I see. I was hoping to get it moved back at least a week. Is the July 1 date hard coded as well? I thought I saw a screen when I was editing before about the date contracts end since some leagues' free agency starts on different days.

AFAIK these are the hard coded free agency dates (and when the season changes years):

Europe/Asia/Africa (All): May 1st
Canadian Major Junior: June 15th
College (all): May 1st
NHL/AHL/ECHL/everything else: July 1st
 

GKJ

Global Moderator
Feb 27, 2002
192,891
43,435
I gotta say, editing schedule templates, I have a bizarre enjoyment of it. It's like how I feel about doing sudoku puzzles. Just as long as it's not too much at a time. I made an error doing that mass-moving a dates and had like 3 full days I had to edit, and a few others where it put 3-in-3's. I guess good thing I'm not working right now.
 

BKarchitect

Registered User
Oct 12, 2017
8,170
14,593
Kansas City, MO

GKJ

Global Moderator
Feb 27, 2002
192,891
43,435
No they are hard coded into the game itself, we can only modify some small details regarding the draft.

Ah, I see. I was hoping to get it moved back at least a week. Is the July 1 date hard coded as well? I thought I saw a screen when I was editing before about the date contracts end since some leagues' free agency starts on different days.

OK, here's a question about this again. So, the first year the draft is set for June 18. I had made an edit for trading to resume to June 16. In subsequent years that I've simmed, the draft got pushed back to June 24, 2023 and June 22, 2024. I have my finals to end on either June 13 or 14 at the moment. None of this is an issue of course, it's what I wanted, but did I trigger something that pushed the draft back a week? Because I could use the extra couple days to spread things out some more.
 

xECK29x

Moderator
Sponsor
Jul 19, 2006
18,240
11,945
Deer Park, NY
OK, here's a question about this again. So, the first year the draft is set for June 18. I had made an edit for trading to resume to June 16. In subsequent years that I've simmed, the draft got pushed back to June 24, 2023 and June 22, 2024. I have my finals to end on either June 13 or 14 at the moment. None of this is an issue of course, it's what I wanted, but did I trigger something that pushed the draft back a week? Because I could use the extra couple days to spread things out some more.

It's possible you did something to push it back but I've had the draft happen while the SCF was still going on! I know the draft dates differ in Olympic years, that could be confusing you too.
 

Dirty Dog

Wooftastic
Sponsor
Jul 11, 2013
12,050
14,769
The doghouse
If the game crashes (no error message, it just closes down) on the same date, is there any trouble shooting to save that save file? Or am I doomed?
 

Ad

Upcoming events

Ad

Ad