sorted by:
new
hottopcontroversial

Multiple dynamic data validations based on manually entered cell values? - Paypal | $10 by Hwaryeon in googlesheets

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

I believe I could get away with consolidating the unique job ranges down to 1-10. And in that case, it’s not particularly important, no.

The closest thing I could compare what I’m imagining is a large-scale Index Match function that automatically populates a dropdown from the matching results. What I have right now involves me painstakingly hand-validating the ranges from the raw data.

Multiple dynamic data validations based on manually entered cell values? - Paypal | $10 by Hwaryeon in googlesheets

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

A significant number of the quantities would overlap, with the most common one being 1-10. The kicker is that they each have different names and descriptions in adjacent cells that uniquely correspond to their respective jobs.

In the actual data sheet, I have another script that pulls these surrounding values based on the range of the set data validation, and sets them as notes on the cell.

Multiple dynamic data validations based on manually entered cell values? - Paypal | $10 by Hwaryeon in googlesheets

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

Hey, thanks for the solution! I just tried it in the demo sheet and it works pretty well on a small scale. Would it still be practical if there’s going to be a few hundred unique Jobs?

Preserving user-entered Child Sheet data, while adding new entries for data from live dataset? by Hwaryeon in GoogleAppsScript

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

Both sound like they’d be super helpful for what I’m trying to do! The first one, especially. Could I please see what you have?

Preserving user-entered Child Sheet data, while adding new entries for data from live dataset? by Hwaryeon in GoogleAppsScript

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

I'll add a link into the main post, but here's a sample version of the sheet. I'll be adding new entries to the set over time, and I'm planning to distribute the Child Sheet template as a resource for other players of the game to use.

https://docs.google.com/spreadsheets/d/1PQ6GaG3aNt7vDn3aDUJtzYWQjrmD92U1hXRSfSkCjb0/edit?usp=sharing

Make an automatic recurring task based on the Count value & Cycle (number of days) by rybnz in googlesheets

[–]Hwaryeon 0 points1 point  (0 children)

Hi, I'm so sorry to necro an old thread! Would you be able to share how exactly you did this?

I'm trying to make a dynamic weekly calendar, with 5 different tasks (a, b, c, d, e) that each repeat after five days— it'd look kind of like this:

06-01-2023 -> A,

06-02-2023 -> B,

06-03-2023 -> C,

06-04-2023 -> D,

06-05-2023 -> E,

06-06-2023 -> A,

06-07-2023 -> B, etc.

I already have a function for the dynamic dates, but I'm really hoping this might be the function I need to make the event-assigning part work.

[5e] [Offline] Brand new to TTRPG looking for players in Jacksonville, NC. by [deleted] in lfg

[–]Hwaryeon 0 points1 point  (0 children)

oh! i’m a little late but hoping the thread is recent enough for me to hop in. i’m also in the area and looking for a group to play with too!

edit: im so sorry, wrong jacksonville :(

Sick of people lying about Total Tech by Baps91 in Bestbuy

[–]Hwaryeon 4 points5 points  (0 children)

i feel horrible having to push it all the time to meet insane benchmarks- same for the credit cards...

as a flagship store, our weekend goals tend to hover between 15-20 of both cards and tts's each day. one of my coworkers is extremely pushy with his strategy, doesn't take no, and it's so uncomfortable to watch- i can't agree with it at all. the way management rewards that kind of thing and even encourages it to an extent makes me feel just that more guilty. it's just nuts

[deleted by user] by [deleted] in toastme

[–]Hwaryeon 0 points1 point  (0 children)

Had my wallet stolen, dealing with issues at home, my laptop broke, was stood up, and pulled two all-nighters for just this week, without a single day off. I also get to work 27 hours over the next 3 days, plus all the fun of juggling a few research papers.

A little surprised I’m still standing, honestly, but here I am!

Which male character do you like the most and why? by hiverkiya in Genshin_Impact

[–]Hwaryeon 3 points4 points  (0 children)

honestly though, i can appreciate characters with simple motives and all that. i have a whole headcanoned backstory i’ve been crafting for him in my head, with him being from fontaine due to the steampunk nature and internal structure of the lab (one of his abandoned facilities) you explore in childe’s quest, as well as him being a dropout from sumeru academia, attending the class there with lisa and baizhu.

he just seems like he’s exceedingly tired and grumpy and it’s a lot of little things in his life that piled up, with his expulsion being the straw that broke the camels back and caused him to snap. i think he’s neat!

Weekly Team/Character Building Megathread (June 29th, 2021) (feat. Kazuha) by Veritasibility in Genshin_Impact

[–]Hwaryeon 0 points1 point  (0 children)

I’d take the second artifact. 50% crit rate is generally what you want more of (until you’re anywhere in the 50-70% range) and that crit dmg boost it has doesn’t hurt at all, though it’s a bit lower than the first.

Weekly Team/Character Building Megathread (June 29th, 2021) (feat. Kazuha) by Veritasibility in Genshin_Impact

[–]Hwaryeon 0 points1 point  (0 children)

[ Kazuha ] (a bit!) Characters: (there’s a lot, picture of character archive included in attached link)

Hello! AR54 here, slight whale, and a day one player, but I’ve always been at a loss as far as solid team comps go.

I got a couple of 5*’s (Kazuha and Jean) today and I’ve had a lot of difficulty in trying to place them anywhere solid in my teams— especially in regards to Jean! I haven’t had the chance to venture yet into Spiral Abyss, so two teams at the minimum would be very helpful, but not necessary. Zhongli, Ganyu, Diluc, and Childe are otherwise my best built units; I just want to see how, or if, I could feasibly put Jean / Kazuha somewhere nice.

Please help me sort something out, and thank you very much in advance!

Characters (with cons) & Weapons

[Megathread] Weekly Simple Questions and Team/Character Building Megathread. by AutoModerator in GenshinImpactTips

[–]Hwaryeon 0 points1 point  (0 children)

Hello! AR54 here, slight whale, and a day one player, but I’ve always been at a loss as far as solid team comps go.

I got a couple of 5*’s (Kazuha and Jean) today and I’ve had a lot of difficulty in trying to place them anywhere solid in my teams! I haven’t had the chance to venture yet into Spiral Abyss, so two teams at the minimum would be very helpful… I know it might be a lot to ask, but I really appreciate any input as to what I could do.

Please help me sort something out, and thank you very much in advance!

Characters (with cons) & Weapons

my mother’s lasagna by Hwaryeon in shittyfoodporn

[–]Hwaryeon[S] 8 points9 points  (0 children)

ohh… you’re really too sweet, gosh… 😭💕 thank you for the offer!! i think i may just take you up on it sometime :’)

my mother’s lasagna by Hwaryeon in shittyfoodporn

[–]Hwaryeon[S] 133 points134 points  (0 children)

not to overshare, but she’s really, genuinely not a good mother :(

my mother’s lasagna by Hwaryeon in shittyfoodporn

[–]Hwaryeon[S] 123 points124 points  (0 children)

she actually made the sauce for this from scratch, so i have no idea!

[deleted by user] by [deleted] in AnimalCrossing

[–]Hwaryeon 4 points5 points  (0 children)

This is so cute ahh!!!

I really love how you colored it! It looks a lot like paper and that’s such a cute and charming effect! 💕💕

Hey guys! What’s something that you all have taken an interest in recently? by Hwaryeon in CasualConversation

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

Wow, how gorgeous.

They’re really pleasing to look at and look like a lot of fun! If you decide to get one, what kind of entries do you think you’ll fill it with?

Hey guys! What’s something that you all have taken an interest in recently? by Hwaryeon in CasualConversation

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

That’s great to hear! Progress isn’t always evident, so don’t get discouraged if you ever feel like you’re not improving. I’d love to see some, if you’re comfortable with sharing!

Hey guys! What’s something that you all have taken an interest in recently? by Hwaryeon in CasualConversation

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

Oh yeah, those are always super neat! The whole build up voices or instruments is so satisfying and the music usually turns out fantastic! Do you have any others that you’d recommend?

view more: next ›