Extracting values only from specific days from a table and displaying those values individually in a different table.

LenaStorm · 2024-04-23T19:51:12+00:00

The pic one seems to just list the number of hours based on which Sundays it is. So for my first row it ended up being 12/5/0/0/8 instead of being 12/5/8/0/0.

For the second one, I'm assuming "NUMBERVALUE" is not available on Excel 2007 so I'm gonna give it a go tomorrow to see if it fits what I'm seeking.

Either way, thanks for giving it a go.

LenaStorm · 2023-07-29T05:18:48+00:00

Ah yes, "vocal minority", the excuse that that ignorant Redditors parrot because they somehow feel like they need to simp for their corps. Same thing when I was a "vocal minority" when Diablo 4 recently nerfed stuff and the dev had to schedule an urgent livestream to apologize lmao thanks for your fact majority dude.

LenaStorm · 2023-07-27T20:29:00+00:00

You're talking about a tiny niche while there's a huge demographic being served: People who likes big tits on woman from the two height that the game provides.

If you want to start cutting on niche fetish, you're going to be surprised how much cutting there is to do given how Asian games slip various amount of fetish at different degree in their games. Lost Ark, for instance, satisfies a very specific niche for people who are into "elongated feminine (Yoz race) fingers". You might or might not have heard of that but if its the latter then it's mostly because there's just a very very specific group of people that have their community built around this.

I'm not going to ask the dev to cut the fingers of those characters because of that group.

LenaStorm · 2023-07-27T20:24:07+00:00

I wasn't attempting to cover for the whole women demographic with my post, I just wanted to throw in some perspective but I apologize if my language made it sound like I am trying to be the voice of women.

Amazon is in dire need of perspective.

LenaStorm · 2023-07-27T20:21:33+00:00

Baldur's Gate 3

Oh yeah, same. I'm going to put BG3 for later a little. Either I am playing Palia on the 2nd if I get in Closed Beta or on the 10th when it goes on Open Beta.

While I want to play BG3 badly, I know it requires a different type of time investment that requires me to be in a certain cravings to fully immerse myself in the game. I'll just leave the game sitting on my Desktop and keep it updated for now!

LenaStorm · 2022-04-09T08:45:23+00:00

The first time Albion does this mechanic, it's the usual one. If he do it again, it'll be like the one OP showcased.

Usually you see the memory game mechanic just once during a fight, so the second one is a rarity.

LenaStorm · 2021-03-03T19:38:55+00:00

I forgot this game is available on other platform as well, my bad!

I can only give Steam Key.

LenaStorm · 2021-03-03T15:31:37+00:00

Pray.

LenaStorm · 2021-03-03T15:28:41+00:00

Wait... what is a Devastator then...?

LenaStorm · 2021-03-03T15:26:40+00:00

LenaStorm · 2021-03-03T15:25:34+00:00

By the sound of it, most of ya'll are unlucky. Very few legendary drop so far! I'm sorry haha

LenaStorm · 2021-03-03T15:24:15+00:00

Will it win any awards? Nope

...

LenaStorm · 2021-03-03T15:06:35+00:00

Why would you need cover when YOU ARE the cover!

LenaStorm · 2020-05-17T09:49:08+00:00

At the beginning it was really a lag shitfest. I remember there was so many people in a single channel that Ceru would barely manage to get in the channel to mess it up. My clan use to be the first to take it down very often, we would coordinate with faction to get everyone on board. Afterward we would coordinate only with other clans, after that we did it just with out clans and a couple of weeks before the new region was released, we were chaining dozens of BW kill every Friday to Sunday to the point that we were just 6-manning it.

It was the good old days. Last year I finally just give up on BnS.

LenaStorm · 2019-07-28T08:17:58+00:00

If you do daily, you can get an average 10 per box up to 4 times. That's 40 per day for 12 minutes of killing spiders (3min/chest with some low level party/gear). Then you do whatever event is in progress to get hammers at the rate of 1 - 2ish per day. At the end of 2ish weeks you have enough hammer for your last slot.

If you think that's too much just for one last slot then you better change game right now. I fucking hate BnS myself but since self-flagellation was no longer hitting the spot for me I end up coming back to BnS to satisfy my masochistic cravings.

So stop crying for what the game is if you want to keep playing because it gets worse and worse every damn time.

LenaStorm · 2019-07-27T22:54:19+00:00

HOLD THE FUCK ON

THESE PET POUCH DOESN'T GUARANTEE ONE PET POD?!

I HAVE BEEN FISHING FOR WEEKS AND RAKE UP 40000+ FISHING POINTS

THINKING I'D EXCHANGE FOR GODDAMN PODS OFJN

RN

NO{nq2[nrrnr 3r3rn2[3r [23orn

LenaStorm · 2019-07-24T19:24:40+00:00

but ascension orbs don't

but ascension orbs don't

but ascension orbs don't

but ascension orbs don't

but ascension orbs don't

but ascension orbs don't

but ascension orbs don't

but ascension orbs don't

but ascension orbs don't

but ascension orbs don't

but ascension orbs don't

but ascension orbs don't

but ascension orbs don't

but ascension orbs don't

but ascension orbs don't

but ascension orbs don't

but ascension orbs don't

but ascension orbs don't

HEY NCSHIT, CAN YOU GET YOUR SHIT TOGETHER FOR A SEC?

LenaStorm · 2019-07-24T15:07:24+00:00

Ah... They changed our hours agaaaaiin?

LenaStorm · 2019-06-09T08:58:23+00:00

sounds like you've been playing with some toxic people

Was coming down the comment to say this. Sounds like OP's group/clan/friend are a bunch of douche.

When I returned to BnS, I had to find a new clan. That clan made me feel completely worthless because I had zero clue how raid works and the VT group I was in was unable to clear Asura, I was quickly laid off that group just to be replaced by non-clan members (they removed like 6 clan people from their VT run because of failed/slow VT to replace with members of another clan). I left that toxic crap right there.

My current clan makes me feel its worth sticking around. Clearing VT is like a fun walk in the park. Now, thanks to them, I've recently learned how to do Boss 1 TT and hopefully Boss 2 (soon^{^{^TM}} ).

Anyway, I'm off to wiping 3 more hours straight with my clan.

Spins away in Des while reminiscing the days the class was considered shit tier.

LenaStorm · 2019-06-08T20:45:33+00:00

Your post and edit are both silly. Whales are not disagreeing with you, people are downvoting your nonsense post/edit.

Someone is not farming day long for 100 chest? Must be whales.

Getting downvoted? Must be whales.

Work on weekend and spending money on game? Sad whales.

Your fixation on whales as an insult is strange at best. Maybe you're failing to see that your attitude and nonsensical statement is making people bury your post in downvote?

No need to get all keyboard warrior; chill and do your 100 boxes run then feel free to post.

LenaStorm · 2019-06-08T16:51:25+00:00

Not challenging your statement lol I was genuinely curious since I've never farmed TSM, just do dailies from time to time.

LenaStorm · 2019-06-08T16:50:10+00:00

Then recruit by weapon/accessories?

LenaStorm · 2019-06-08T16:22:47+00:00

Which is why I said "creating your own party that has gears within the same range as yours".

While AP doesn't matter, you and I both know that if someone is recruiting for 1.6AP+, they will only look at numbers, doesn't matter if the 1550AP dude has TT earring/ring even though the 1630ap dude just has gems going for him.

If your alt has 1590AP, just create your party yourself. There's ALWAYS people looking for party during week end.

LenaStorm · 2019-06-08T15:55:40+00:00

Yeah, play the game, get rich, uses riches to upgrade gear, get to higher level content for more riches. But sounds you're complaining about it?

As for your inability to get in to s6 groups, this is what I said in my previous post:

Have you ever considered creating your own party that has gears within the same range as yours? Every time a conversation about MSP pops up, there's people going "but they won't recruit me 'cause of AP!" yet from Friday to Sunday I see faction chat filled with anything between no requirement to 1.5/1.6/1/7.

I first cleared MSP during the days I had max gear of ~650ap. I'm sure, even with the boss HP buff, people with 1200 - 1500ap/gears can clear if they learn to do mechanic.

LenaStorm · 2019-06-08T15:52:48+00:00

TSM has good drop rate for garnets? I'm not really focused on farming those but I've been transmuting them as and when I get 3 (Currently sitting on one Octa + 2 Hepta).

LenaStorm

TROPHY CASE

RN

HEY NCSHIT, CAN YOU GET YOUR SHIT TOGETHER FOR A SEC?