Buds Board Keepers League

1. "Draft Results" sheet is new for this year. I've got the previous 4 draft years plus 2019 showing the players your franchise selected. The logo next to the player shows their current team affiliation. The 2019 draft results will fill in as we do the draft. I have both the entry and waiver draft results listed.

2. The "Roster" sheet is redone (and improved). I've got all your players categorized by "Contracts" (signed players), "Reserve List" (unsigned prospects) and "Free Agents" (previously signed players without a current contract). "Contracts" are split up by position. That sheet will update with each new week and will reflect any roster moves you might make.

3. I'm only displaying three weekly sheets right now but I'll have all 21 regular season weeks and the playoff rounds included.

4. You'll see the new checkbox shortcuts on the weekly sheets. On "Wk 1", the box in cell A1 is checked and it auto-fills the lineup from "Preseason".

5. The other new checkbox feature is in regards to LTIR and relief. You'll notice I'm using Mike Green as my example under IR. I've checked the box next to him so he appears in "LTIR". In my lineup, I've checked the box next to Jeff Carter to serve as my example for "Relief". He'll show up as relief under the LTIR boxes.

6. New waiver icons are being used. Orange circle with a W means the player must clear waivers. The purple circle with a down arrow means waiver exempt. I don't have a current slide-eligible contract on my team but that icon is now a blue circle with an S.

7. I've added a new set of icons for player status for players under contract. This status comes from CapFriendly. A player that is active in the NHL has a grey shield (resembles the NHL logo). A player in the minor leagues has a green star. I don't have a player that applies to this but a player in Europe or junior hockey has an orange star. For the case of Mike Green, he has the red cross meaning he's on IR. These icons don't control anything, they're just extra information.

8. All players under "MINORS" are any player under contract that you don't have in your lineup. Players that need to clear waivers or are sliding contracts will appear in the appropriate lists. You can see my "Wk 2" sheet that illustrates a sheet that's not filled out.

9. The "RESERVE LIST" and "FREE AGENTS" are the same lists as what you'll see on the "Roster" sheet. Any player without a contract will appear under either category. "Affiliate Prospects" are any unsigned prospect that has their rights owned by an NHL team. "Unaffiliated Prospects" are any unsigned prospect that is undrafted or isn't affiliated with an NHL team. The free agent lists are split up by RFA and UFA. As players sign new contracts, those names will move back into your options to use in your lineup. You can only fill out your lineup with signed players.

Matthew wroteCOLONImo, we shouldn't be able to retain for more than 1 or 2 seasons on a contract, in the same way we cannot trade picks far out. It would help us not cripple teams. I'd also say teams cannot acquire too many and teams cannot trade too many of these contracts so as not to make teams too dominant, or make teams too weak.

Shoalzie wroteCOLONI've finalized the design and the formulas for the sheets. I've duplicated them for each team. You can view all the sheets in that folder where I posted the link.

I've got to go through each set of sheets to make sure links to other database sheets are established. It'll take a couple days to work through all of it but sometime next week, I'll send them out to you so you can start working with them.

I'll be updating contracts throughout the offseason as well as adding the information for the 2019 draftees.

Shep wroteCOLON

Shoalzie wroteCOLONI've finalized the design and the formulas for the sheets. I've duplicated them for each team. You can view all the sheets in that folder where I posted the link.

I've got to go through each set of sheets to make sure links to other database sheets are established. It'll take a couple days to work through all of it but sometime next week, I'll send them out to you so you can start working with them.

I'll be updating contracts throughout the offseason as well as adding the information for the 2019 draftees.

I've noticed I'm missing "at least" one player that was on my old sheet but not my new sheet.

My numbers show that there are three missing, but I am just looking to see who the other two are.

Alexander Khovanov is the one I know for sure.

Shoalzie wroteCOLONI do have all your sheets linked up to the database and I'll send our your individual shared link in the next day or so.

If you do have a name missing on your sheet, it's based on information that I have entered. Your entire roster is there but certain players don't fall under "CONTRACTS", "RESERVE" or "FREE AGENTS" is a certain value is missing. I will go team-to-team and get those players updated so they'll show up on your sheet. Most likely, those are players that would fall under the "FREE AGENT" category and just don't have "UFA" or "RFA" status.

As an example, I was looking at Cliff's sheet. He's got 75 players on his roster but only 70 were showing up under the categories. I had to add some information for those other players to appear.

I will get that corrected...everything else is working as I expected.


Once all you have access to your sheets, I'll put together some kind of cheat sheet/tutorial and I'm obviously be available for questions.