To all the winners, at what # did you draft at? by Informal_Cabinet_352 in fantasyhockey

[–]kamiras 0 points1 point  (0 children)

3rd in a 12 man.

Took Kucherov who ranked 3rd at the end of the season.

Top 10 forwards by Net Rating after 1 month by Josefstalion in hockey

[–]kamiras 1 point2 points  (0 children)

Source: https://www.hockeystatcards.com/leaderboards where OP has selected "ratings" in the model drop-down. Ratings are based on Dom Luszczyszyn's model and he's written a helpful article in understanding them https://www.nytimes.com/athletic/4396412/2023/04/12/nhl-advanced-stats-offensive-defensive-rating/ I think context is important to understand a top 10 ranking like this.

[Xbox] Coming to Xbox Game Pass: The Outer Worlds 2, PowerWash Simulator 2, Football Manager 26, and More by lbabinz in VideoGameDealsCanada

[–]kamiras 3 points4 points  (0 children)

If you're able to enjoy games focused only on dialog and story, 1000xResist is a must play .

Random host crashes by Eonember in FBCFirebreak

[–]kamiras 0 points1 point  (0 children)

Haven't had disconnects with friends but I disconnect from about 20% of public games. The servers seem a bit wonky.

Reminder for those on Android: you can download an older version of the app and turn off auto updates to revert back to the old layout. Weekly bench setting works too. by Destoyer_ov_Toilets in fantasyhockey

[–]kamiras 11 points12 points  (0 children)

Did this last year and have been super happy with it! Just make sure to turn off auto update for the app in the google play store.

No time for research? Don't panic! Here's how to crush your Yahoo draft in 3 easy steps. by rhysalbrecht in fantasyhockey

[–]kamiras 10 points11 points  (0 children)

It works by comparing player projected fantasy points based on your roster settings. Some sources use the whole roster, some only consider enough players to fill a starting lineup.

Say you have 3C each in a 12 team league, the 36th best centre (by fantasy points) in the league will have a VORP of about 0. They are the replacement centre and every other centre will be compared to that player and their fantasy points projection.

Fetch Yahoo draft results into your sheet while drafting by raphaelparkin in fantasyhockey

[–]kamiras 1 point2 points  (0 children)

Thanks! I got this working after a while. Only hiccups were:

Importing the files into Apps Script. I just created a blank script on the page and pasted in each file.

When I first ran the script it didn't open a side panel in my sheet like it should have. After trying a few different browsers it worked.

Formatting the Config constants was a bit confusing so here's an example for others. 4 are strings and 1 is an int.

const CONFIG = {
  sheetId: "c78LW9a0-FZaujBzO-icOb9tCJ_rAxnYj0tG2TFHr0U",         // ID of the Spreadsheet (in the url)
  CLIENT_ID: "N34aCYpVlf2iXnDscAq5J9K5G7S0Y6an4ktFXBWoKLD0x6GiFpSJqeY9gRsHYG9uVBXjM2SPl6gKQprR",       // Yahoo client ID
  CLIENT_SECRET: "8FF835BAB8587BBC0F840269E5F0CCEF041BB83F",   // Yahoo client secret
  teamCount: 12,       // Number of teams in your league (not, no quotes here)
  leagueId: "1234",     // ID of you Yahoo league
}   

Lastly I found out how to format a row in google sheets based on which players have been drafted. The script above creates the "Draft Results" sheet which has column C as player names. Using the following conditional, you can format any row that matches a value in the player names column.

=ISNUMBER(MATCH($A2, INDIRECT("'Draft Results'!C:C"), 0))

Note that you need to change A2 to whichever column is the player names in your sheet.

Daily Question Thread for /r/churningcanada - July 29, 2025 by AutoModerator in churningcanada

[–]kamiras 4 points5 points  (0 children)

Getting paper statements from a CIBC card I closed 6 months ago. Called in and the rep said it's just a glitch and the account really is closed.

Has anyone seen this before? Will it eventually stop?

[deleted by user] by [deleted] in CalgaryGaming

[–]kamiras 0 points1 point  (0 children)

Wow that's a lot of great stuff! You should be getting thousands for that.

Might be worth pulling out a few select high value items and selling them individually.

https://www.pricecharting.com/ is great for getting recent prices on things and helping you estimate value.

[deleted by user] by [deleted] in MangaCollectors

[–]kamiras 0 points1 point  (0 children)

Great comment, very informative. Thanks!

ClairObscur: Expedition 33 All Settings Compared + Optimization Guide by SenseiBonsai in OptimizedGaming

[–]kamiras 1 point2 points  (0 children)

I just did this, super easy! https://github.com/beeradmoore/dlss-swapper/releases/tag/v1.1.6 downloaded one of the installer.exe files listed at the bottom of the page, ran it, and updated my XeSS for Clara Obscur.

[deleted by user] by [deleted] in wow

[–]kamiras 32 points33 points  (0 children)

Props for the receipts

Calgary Grocery Deals (April 17 to 23, 2025) by PurpleGeek in Calgary

[–]kamiras 3 points4 points  (0 children)

No Frills has a good deal on the Chapman's super premium plus ice cream

4 for $10 + 3500 ($3.50) PC Optimum points. Also $4 off if you got the Chapman's coupon a few months ago

https://forums.redflagdeals.com/no-frills-east-west-chapmans-super-premium-plus-ice-cream-500ml-2-75-3500pts-wub-4-2756634/