GKJ
Global Moderator
- Feb 27, 2002
- 193,394
- 43,677
My real issue so far is not playing and wanting to just keep editing thingsEHM editing is simply a sequence of dumb oversights until you get it to work
My real issue so far is not playing and wanting to just keep editing thingsEHM editing is simply a sequence of dumb oversights until you get it to work
My real issue so far is not playing and wanting to just keep editing things
My real issue so far is not playing and wanting to just keep editing things
Does the prospect generator take in to account regional nationalities? Like Asian players?
Is there an easy way to take an entire schedule template, and move every game back an entire week?
Might have some spreadsheet fun then!
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.It's easily the most labor-intensive part of editing
Is there an easy way to take an entire schedule template, and move every game back an entire week?
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.
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.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.
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.
View attachment 503795
Is there a way to change the date of 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.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.
So I've finally updated my facepacks for the 21/22 season. NHL and Sweden.
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.