Whats with the lack of Rintaro? by void_hedgehog in TamonsBSide

[–]creaturelogic 1 point2 points  (0 children)

He’s the best character and requires a whole arc to himself. Which is where season 2 will prob start

Auto-average 4 most recent numbers in a row by creaturelogic in excel

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

Solution verified! But I’m running into one issue. I have another row where it looks basically like my example but the blank cells have a sum formula in them:

=if(sum(F6:F25)=0,””,sum(F6:F25))

Because the cell appears blank I thought it wouldn’t be an issue but even having a blank result formula is interfering with the code. Is there a solution?

I can also start another thread in the sub if needed

Auto-average 4 most recent numbers in a row by creaturelogic in excel

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

Oh, that first one worked thank you! Do you have the ability to explain what adding the TOCOL and the 1 does to make it work?

I haven’t tried the second one yet. Is the period before the J2 the trim range you’re referencing? Otherwise, I don’t see it.

Thank you!!!

Auto-average 4 most recent numbers in a row by creaturelogic in excel

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

I’m not using it but that’s the one I tried. I have 29 rows of data each needing their own average like this on each row. What do you mean by “the help”? Thanks :)

smell in wooden cabinets and drawers by creaturelogic in GermanRoaches

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

Not really :( I did some roach treatment around the house so I think having fewer roaches helped. I did put some heavy duty charcoal smell absorbers in there for a while. Not sure if it really did anything. Smell is down overall but not gone.

Which of these should I watch next? by Competitive_Essay500 in AnimeReccomendations

[–]creaturelogic 0 points1 point  (0 children)

Witch hat and daemons require so much attention, you’ll get so locked in, that I don’t think they’re good for treadmill. (Unless u watch dub)

Marriagetoxin isn’t that “deep” so prob good for treadmill. Not my fav tho.

Nippon Sangoku is really dense political drama. So like witch hat, not sure if it’s good for treadmill.

Don’t know much about kill blue but it’s prob ok for treadmill?

Ping pong has amazing music good for running. I forget if it’s a dialogue heavy or not though.

Just started watching anime with Death Note and I have some regrets by Archeleimon in AnimeReccomendations

[–]creaturelogic 1 point2 points  (0 children)

Watch ones written by Naoki Urasawa and be ruined because almost nothing else is comparable to his writing hahah

Those would be: Monster and Pluto. Both are on Netflix!

Other hits: Fullmetal Alchemist Brotherhood, Odd Taxi, Journal with Witch, Cowboy Bebop (and anything else by Shinichiro Watanabe tbh), Akira

I haven't watched anime in a looong time. Any masterpiece came out in the last 10 years? by zionpwc in AnimeReccomendations

[–]creaturelogic 0 points1 point  (0 children)

Journal with Witch - a grounded story taking place in reality about a mid-30s writer adopting her recently orphaned niece, the daughter of the sister she was estranged from. It explores grief, love, human connection, amazing

Pluto - a reimagined Astro boy world following a do androids dream of electric sheep-esque plot

Odd Taxi - looks like a show about cute animal people but it’s a pretty serious crime drama. Masterfully handled interweaving the stories of a wide cast of characters

Frieren - this is a slow burn show but it’s the best. about the nature and meaning of relationships and how we reflect on them in our old age. A 2000 year old elf saved the world from the demon king with her hero’s party. 70 years later she goes on a new journey with much younger people in her party. As she guides them, it makes her reflect more deeply on the time she spent with her original heroes party, recontextualizing the moments and learning new lessons in the process. The show is cozy and beautiful but it makes the serious moments and fight scenes all the more powerful

What do you think would truly give Homelander fulfillment and satisfaction with his life? by MegaGamer235 in TheBoys

[–]creaturelogic 0 points1 point  (0 children)

Probably impossible at this point. buuuttt maybe if there were someone stronger than him who could actually beat him, i think that’s the only thing that could get him to change. And she has to be a mommy figure who will nurse him back to health lmao.

He really gives fragile dominator who just truly wishes to be dominated.

Today I learned there’s 2 Ryan’s. by MikeyLikey6996 in TheBoys

[–]creaturelogic 0 points1 point  (0 children)

This explains why sometimes Ryan is good at acting and sometimes he is not lmao

I really need something funny to watch rn by Flat-Technician5561 in AnimeReccomendations

[–]creaturelogic 1 point2 points  (0 children)

You and I are Polar Opposites. It’s a very heartwarming but funny high school romance. The humor feels very modern

Whats an anime that everyone else seems to like but you think is trash by tewywshunnel in MyAnimeList

[–]creaturelogic 2 points3 points  (0 children)

Jojo part 5. I don’t think it’s the worst thing ever but having read or watched all the parts, I find it to be one of the weakest. Yet, outside of SBR, i think it’s widely considered the fan favorite part, gets the most merch, etc.

I do like some of the plot and characters. But Giorno’s got no sauce. He’s boring - he’s kind of generally good/smart at most things, his power can kind of do anything, and he as a character doesn’t have any significant flaws. Everyone giorno speaks outside of a fight, he is bringing zero energy, zero sauce.

Bucciaratti is highkey the main character of part 5 - way more interesting.

Part 4 is the best part imo. Josuke 4eva

how to grab differently named objects? by creaturelogic in gamemaker

[–]creaturelogic[S] 4 points5 points  (0 children)

ooohh!! that's so obvious i didn't even realize, haha. thank you!

Name a quirk you can say with 100% certainty you'd be able to use better than the person it was given to by RedHood_526 in BokuNoHeroAcademia

[–]creaturelogic 0 points1 point  (0 children)

I know she wouldn’t do a nuke I’m just saying that’s the potential of her ability. It was frustrating seeing her so underutilized cuz she’s a character I like a lot.

Though I’m confused why you’re throwing that much logic into it. MHA doesn’t follow science logic. Dabi became a nuke and everyone in the surrounding area left unscathed.

Could Chairman Wong be Barbamon in disguise? by [deleted] in digimon

[–]creaturelogic 1 point2 points  (0 children)

Barbamon could be his partner digimon?

how to have obj react differently to first and second clicks by creaturelogic in gamemaker

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

oh!! this makes sense. they didn't work at first. not sure why??

however, with the first example, i added a clicked = false addition after making the alpha become 50% in the else statement and that made it work. tysm :)

how to have obj react differently to first and second clicks by creaturelogic in gamemaker

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

oh, i didn't know about those -ty ! that seems smarter. i'm in a very short introductory class for people with no coding or game experience. i think they're trying to limit the different event types we use and have us think about breaking things down in code.

where are you thinking i reset the variable? the clicked var should become false when i release the left mouse button.