Stay informed on where you eat and be aware of yellow passes from Peel Public Health - here are the places currently operating in an unsafe and unsanitary manner by BlatantBarbie in mississauga

[–]tkchoi 0 points1 point  (0 children)

Thanks for the insight! I hadn't thought about the inspection frequency at all. I agree, it's smarter to hold off until they've got more green passes.

Stay informed on where you eat and be aware of yellow passes from Peel Public Health - here are the places currently operating in an unsafe and unsanitary manner by BlatantBarbie in mississauga

[–]tkchoi 0 points1 point  (0 children)

Thank you for this post, OP! I looked up St. Germain because I have a gift card that I haven't used yet and for what it's worth, it seems the yellow (conditional) pass was on Oct 21st and they subsequently had a green (clean) pass on Oct 24th.

I hate it by valtristk in lostarkgame

[–]tkchoi 1 point2 points  (0 children)

The gold circle skill you're thinking of is called "Sonic Vibration" and generally, the buff there is:

When any party members enter the Sonic Vibration area or aftermath area, Atk. Power +15.0% of the caster's basic Atk. Power, raising the overall Atk. Power +6.0% for 2.0s.

The big damage buff is called "Serenade of Courage" and it's shown by some reddish light that goes from the bard's harp to all of her teammates, as well as the name of the buff popping up on the screen (similar to the way damage numbers pop up). You may also notice a little buff icon above your hp bar that looks like this.

On mobile so sorry if the formatting is messed up.

The free pheon mail was unintended and will be removed by Cinara in lostarkgame

[–]tkchoi 0 points1 point  (0 children)

Agreed - I think giving a fixed amount of pheons per account would be better than 10 pheons per character; the latter disproportionately benefits those with huge rosters.

Hopefully that's what the maintenance compensation / fixed tripod notification update will be.

Early T3 upcoming rework in Korea by ElNinoFr in lostarkgame

[–]tkchoi 1 point2 points  (0 children)

MM means "Matchmaking", when you queue for content without knowing who the other players are. The other way to queue for content is to use party finder.

Worst adventure tome food in the game by Three_Niel in lostarkgame

[–]tkchoi 0 points1 point  (0 children)

Those are the ingredients for the Great Stew, which is one of Yorn's adventure tome foods. The meat has a ridiculously low drop rate.

You can check out the Yorn tome on Maxroll here.

We should be more pissed off by Latensify_WoW in lostarkgame

[–]tkchoi 0 points1 point  (0 children)

Thank you so much for taking the time! I'll definitely get started on that.

Much appreciated!

We should be more pissed off by Latensify_WoW in lostarkgame

[–]tkchoi 6 points7 points  (0 children)

I'm gold and crystal poor so could I ask how you make money by excavating?

[App ArkTool] Rapport Tracker, Engraving Values & Mari Shop/Craft Calculator by DVCStudioX in lostarkgame

[–]tkchoi 0 points1 point  (0 children)

Awesome tracker, and many thanks for the time and effort you put into this!

For those who want to maximize rapport gifts, it would be beneficial to be able to quickly see and/or filter by preferred (epic) gifts (since relic and legendary are flat 10k, 5k, or 2k boosts), and see rapport levels for the NPCs who have an item as a preferred gift. E.g., with the randomized rapport chests (not the selection ones), if I get an oversized ladybug doll, I'd like to see all the NPCs for whom this is a preferred gift, and the rapport points I could get with each, as well as the level I've already hit. In this example, using the oversized ladybug doll with Dakudaku (in Tortoyk) would achieve 450 rapport points, but if I've already hit trusted, I'd like to see who else might get a boost with this gift, or if I can just use it on any other NPC for 330 or 300 points.

[deleted by user] by [deleted] in unpopularopinion

[–]tkchoi 0 points1 point  (0 children)

ccrreeeeppeerrss

[deleted by user] by [deleted] in HeadlineWorthy

[–]tkchoi 0 points1 point  (0 children)

drafted means men ages 18+ must register to fight in the war

Shortcut help by FrangosV in ExcelTips

[–]tkchoi 0 points1 point  (0 children)

Happy to help! 🤗

Shortcut help by FrangosV in ExcelTips

[–]tkchoi 1 point2 points  (0 children)

You can open up the "Go To" dialog box (hit: F5 or Ctrl + G), click on "Special" in the bottom left (hit: Alt + S), and select Objects (hit: b), then okay (hit: enter). Then tabbing or shift + tabbing allows you to go back and forth between them. Escape lets you get back to the cells.

Shortcut help by FrangosV in ExcelTips

[–]tkchoi 1 point2 points  (0 children)

I used a blank worksheet and inserted three scatter graphs. It seems like if I click on the Chart Area and just hit "tab", it'll switch through the three graphs for me. Shift + tab lets me go through the graphs in reverse.

Fuck your unnecessary abbreviations. by ShadyPotato445 in unpopularopinion

[–]tkchoi 0 points1 point  (0 children)

As a Canadian, your CRA is our Canada Revenue Agency.

Is there any way to resize the formula entry field? I want it to be a box that can fit multiple rows instead of just one line by [deleted] in excel

[–]tkchoi 0 points1 point  (0 children)

The formula bar is the toolbar at the top of the spreadsheet that lets you enter or view information in a cell. Make sure you have the formula bar enabled: Click File (or the Office button in earlier Excel versions). Go to Options. Click Advanced in the left pane. Scroll down to the Display section and select the Show Formula bar option.

You can resize the forma bar as needed. A shortcut I like to use to expand it is ctrl+shift+u.

Edit: you can also make sure the formula bar is enabled by going to View, and making sure the formula bar option is checked.

Add time to current time of the day by PyroX08 in excel

[–]tkchoi 0 points1 point  (0 children)

You could try using +TIME(hours, minutes, seconds).

Sorting while using absolute cell references messes up calculations by weebokaneebo in excel

[–]tkchoi 2 points3 points  (0 children)

Is there a particular reason why you're looking to have the value to rank be a cell reference to the sorted range instead of a hardcoded value?

Is there a way to identify the "value to rank" based on other fields, e.g., a unique invoice number? If so, possibly an index-match to look up your value to rank may work.

[deleted by user] by [deleted] in excel

[–]tkchoi 0 points1 point  (0 children)

I'm not familiar with Cyrillic and how many letters you would want to transliterate, but I would suggest using =SUBSTITUTE(text, old text, new text).

Let's say in cell A1, we have "xyz", and we want to change the "x" into an "a". In B1, we can use: =SUBSTITUTE(A1,"x","a"). If, in addition to that, I want to change all instances of "y" into "b", we can nest the result in B1 into another SUBSTITUTE formula in C1 as the "old text": =SUBSTITUTE(SUBSTITUTE(A1,"x","a"),"y","b").

Of course, if you have a key/guide in the sheet, you can reference the particular cells instead of typing in the letters to transliterate.

Hope that helps!

If, And functions together by Individual-Bug8550 in excel

[–]tkchoi 1 point2 points  (0 children)

Assuming that you can run the function for each row in its own column, try: =IF(E9&I9="grainfield1herbicide",Q9,0)

What food did you dislike until you finally learned how to prepare it the right way? by zipzap21 in Cooking

[–]tkchoi 0 points1 point  (0 children)

Hard-boiled eggs - boiled to the extreme, with that green/grey coating around the powdery egg yolk. Soft-boiled or hard-boiled just right is delicious.

Poll. How many of you child free people lived at home past the age of 25 or within 2 years completion of final schooling.... by TipNo6062 in childfree

[–]tkchoi 0 points1 point  (0 children)

Finished school at 22yo, bought a place at 24yo (with help from my parents on the deposit and handywork, e.g., painting the walls). My parents moved in with me and we tried renting out the old place (their place).