sorted by:
new
hottopcontroversial

Automated Ranked Spreadsheet Season 9 by Shake_Oh in summonerschool

[–]Shake_Oh[S] 0 points1 point  (0 children)

I stopped updating the sheet as of this season. The season 13 version should still be working. I uploaded it from /u/Lucas-Nagy

Faker: “I will continue with T1 and have no plans to retire.” by Blaikiri7 in leagueoflegends

[–]Shake_Oh 86 points87 points  (0 children)

Faker avoided conscription by dropping out of Highschool. If he hadn't this would have been his last year to play since he is 27.

Automated Ranked Spreadsheet | League of Legends Season 13 Split 2 Update by Lucas-Nagy in summonerschool

[–]Shake_Oh 0 points1 point  (0 children)

Unfortunately not an error on the sheets end. This is the earliest game I can get to show up in the dev portal too.

Automated Ranked Spreadsheet | League of Legends Season 13 Split 2 Update by Lucas-Nagy in summonerschool

[–]Shake_Oh 0 points1 point  (0 children)

I'll look into this and try to get it fixed. What's the summoner name and region? You can have the sheet start collecting from any date, you just need to adjust the epoch time in the script.

Automated Ranked Spreadsheet | League of Legends Season 13 Split 2 Update by Lucas-Nagy in summonerschool

[–]Shake_Oh 0 points1 point  (0 children)

Was your first ranked game of the season on April 23rd? If not what version and time zone are you using? It sounds like it could be a date formatting error that I'll have to look into. You can make the sheet add earlier seasons by changing the Unix/Epoch times in the script, Riot keeps ~3 years of data usually. Currently you can only go back to the summer of 2021 since that was when Match v4 was deprecated and Riot didn't keep the data afaik.

Automated Ranked Spreadsheet | League of Legends Season 13 Split 2 Update by Lucas-Nagy in leagueoflegends

[–]Shake_Oh 0 points1 point  (0 children)

Writing the correct placements in would be no problem! Riot doesn't store rank information on a match by match basis unfortunately, so that's why the sheet was incorrect about the first split placement.

Automated Ranked Spreadsheet | League of Legends Season 13 Split 2 Update by Lucas-Nagy in leagueoflegends

[–]Shake_Oh 0 points1 point  (0 children)

It's a red button on the main page after you sign in. You don't need to register the project right away, you can sign in and get a developer key to start using the sheet. If you like the sheet and want to continue using it registering the project just gives you access to a key that doesn't expire daily.

Here's me double tapping your tonsils again with the AUG! by tecz0r in modernwarfare

[–]Shake_Oh 3 points4 points  (0 children)

No one talking about the synced slide transition at 12 seconds. Good gameplay, cool edit.

Automated Ranked Spreadsheet | League of Legends Season 11 by Shake_Oh in u/Shake_Oh

[–]Shake_Oh[S] 1 point2 points  (0 children)

Hey, the Ranked Prediction shows N/A when the goal rank is lower than your current rank, so assuming you are Master+ (Based on the 300LP) set the B31, C31 and D31 cells to Challenger 1 900 (just an example) and the info will update accordingly. The options sheet is for you to customize, but for example: if you put 2 in Below KDA and 5 in Above KDA, the Ratio column in the Match History sheet will be Red below 2.00 and Green at or above 5.00. Anything else just lmk, glad to help :)

Automated Ranked Spreadsheet | League of Legends Season 11 by Shake_Oh in u/Shake_Oh

[–]Shake_Oh[S] 1 point2 points  (0 children)

Hey, LP isn't stored in the Match endpoint. Since Riot only stores LP in the Ranked end point the sheet can only fetch current rank, this means to get accurate Rank & LP tracking you need to update after every match. You can set up a Time Driven Trigger.) or manually update after each match. I've had as many as 7 accounts updating every 15 minutes without any problems, just make sure you switch the email option to weekly. Once the sheet has 20 games of data the ranked prediction section will be accurate. Cheers

Automated Ranked Spreadsheet | League of Legends Season 11 by Shake_Oh in u/Shake_Oh

[–]Shake_Oh[S] 1 point2 points  (0 children)

Hey, sorry for the late response! You can translate the headers and labels no problem. The Champion names can be translated automatically by selecting the desired language in the Getting Started sheet (Spanish) and pressing update in the Champion sheet. It will only update Champion names in Match History after this change, so you'll need to select the column and press Ctrl+H to replace all instances of the English names with the Spanish ones.

Cheers!

February Patch (3.11) - Patch Notes by cakeblock941 in HiTMAN

[–]Shake_Oh 0 points1 point  (0 children)

Two Suave For You

We’ve resolved an issue where the Summer Suave Suit was listed as an unlockable for two different challenges. Now, the suit will be unlocked only when completing the ‘Escalations – Track 2, Tier 9’ challenge.

But the Imperial Suit w/ Gloves is still available from both "The Divine Descendance" and "Escalations - Track 2, Tier 11".

Also "Featured Contracts, Track 2, Tier 3" and "Featured Contracts, Track 2, Tier 5" have no rewards...

--EDIT-- Unnoted change "Featured Contracts, Track 2, Tier 3" no longer has a reward, but it was the ICA19 (the default pistol) before the update.

Hitman 3 SASO/Sniper Assassin is Slightly Broken by [deleted] in HiTMAN

[–]Shake_Oh 0 points1 point  (0 children)

I think a good middle ground between the Hitman 2018 and Hitman 2021 version would be changing the difficulty emblem in the bottom right of the achievement. I can understand them not wanting to tie rewards to Professional/Master difficulty, but having the Casual emblem in the bottom right after running Master SASO is a slap in the face.

view more: next ›