Je voulais partager ma feuille Light the Lamp que j’ai préparée pour cette saison. Tout le monde est invité à l’utiliser (lien dans les commentaires).

2 Comments

1. R1PKEN 2 ans ago

   Last year was the first year my friends and I decided to join in on light the lamp as a way to stay engaged throughout the season. I was tired of manually calculating the scores after each game and figured there had to be a better way.

   So I ended up putting this together: https://docs.google.com/spreadsheets/d/1oN-BKKpePrZL2O0xvWsYccb2fwQdwD2S2kexD8IY1lg/edit

   Hopefully that link works, you might have to make a copy of it I think I have this set to read only to keep this template in tact. It’s set up for 8 people and adding or removing people is a little tedious so if you want to use this for your group I’m more than happy to help make it work for your situation.

   Basically, we go through and draft every game like the pregame crew does, and then I fill in the final score and individual stats for everyone that was picked for that game. The formulas do all the work from there, and tally up the scores onto the Standings tab.

   It’s super easy to maintain and figured I’d share it in case anyone finds it useful. I’m sure there’s plenty of other ways to set up something like this but this was the easiest way I could come up with for keeping up with the LTL scoring throughout the season.

   Anyways if you’ve read this much, thanks for taking the time and let me know if you do end up using this or if you have any feedback or tips to make it better. LGRW!

2. shoostar813 2 ans ago

   At first I thought, « oh wow, this guy is absolutely BATSHIT CRAZY to be tracking this silly ass game », but then I read on and saw that it’s intended for you and your crew, not that you’re tracking what the Detroit pundits are doing. Now it seems a little more fun and meaningful that you’re doing it for that reason, lol. Have fun, and oh guess what?

   GUESS WHAT?

   80 MINUTES TILL GAME TIME WOOOOOOOOOOO

   LET’S GO RED WINGS!!!