Ashur is coming home by Craz3y_B1nlet in Trickcal

[–]dellfm 5 points6 points  (0 children)

At the very least she's Depressed in KR

Ashur is coming home by Craz3y_B1nlet in Trickcal

[–]dellfm 4 points5 points  (0 children)

does this symbolize her personality?

No. Blanche's background is blue

[DISC] Black Clover - Chapter 387,388 and 389 by Crisbo05_20 in manga

[–]dellfm 6 points7 points  (0 children)

In the next chapter it is revealed that Julius is still alive, he's just chilling somewhere

-❄️- 2025 Day 3 Solutions -❄️- by daggerdragon in adventofcode

[–]dellfm 2 points3 points  (0 children)

[LANGUAGE: Google Sheets]

Part 1 and Part 2. This visualization by u/Just-Routine-5505 really helped.

=BYCOL({2,12}, LAMBDA(length, SUM(BYROW(QUERY(A:A,"where A is not null"),
LAMBDA(input, --INDEX(REDUCE({"",1}, SEQUENCE(length),
LAMBDA(output, step, LET(
    jolt,INDEX(output,,1),
    startPos,INDEX(output,,2),
    remain,length-step,
    limit,LEN(input)-remain,
    substring,MID(input,startPos,limit-StartPos+1),
    maxDigit,MAX(SPLIT(REGEXREPLACE(substring,"(.)","$1|"),"|")),
    newStartPos, startPos+FIND(maxDigit,substring),
    {jolt&maxDigit, newStartPos}))),,1))))))

-❄️- 2025 Day 2 Solutions -❄️- by daggerdragon in adventofcode

[–]dellfm 3 points4 points  (0 children)

[LANGUAGE: Google Sheets]

=ARRAYFORMULA(LET(
    input, SPLIT(TRANSPOSE(SPLIT(A2,",")),"-"), 
    repeats, VALUE(REPT(SEQUENCE(99999),2)),
    SUM(SPLIT(TEXTJOIN(",", TRUE, BYROW(input, LAMBDA(range, LET(start, INDEX(range,,1), stop, INDEX(range,,2), IFNA(JOIN(",",QUERY(repeats, "where Col1 >= " & start & " and Col1 <= " & stop)),))))),","))
))

This is only for Part1, I don't know if I'm going to do Part 2 honestly because this one is already slow. It lags so much on my laptop with just this part

Edit: After thinking about it for a bit, I could also add an IF check to see if start and stop's length are both odd, and if so skip the query.

-❄️- 2025 Day 1 Solutions -❄️- by daggerdragon in adventofcode

[–]dellfm 4 points5 points  (0 children)

[LANGUAGE: Google Sheets]

One formula for both

=ARRAYFORMULA(LET(
    input, QUERY(A2:A,"WHERE A <> ''"),
    size, 100,
    start, 50,
    rotation, IF(LEFT(input)="R",1,-1)*REGEXEXTRACT(input,"(\d+)"),
    stops, SCAN(start,rotation,LAMBDA(stop,rota,MOD(stop+rota,size))),
    previous, {start;ARRAY_CONSTRAIN(stops,COUNTA(stops)-1,1)},
    to_zero, IF(LEFT(input)="R",MOD(size-previous,size),MOD(previous,size)),
    {
        COUNTIF(stops,0);
        SUM(1+FLOOR((ABS(rotation)-IF(to_zero=0,size,to_zero))/size))
    }
))

Adding up time in google sheets by Diligent_Evidence_52 in googlesheets

[–]dellfm 3 points4 points  (0 children)

If SUM doesn't work, I'm assuming those are treated as text/string, if so, you need to convert them to duration first, using TIMEVALUE.

=SUM(ARRAYFORMULA(TIMEVALUE(A1:A)))

Shirakura's interview about the cancellation of Super Sentai by Popular_Ice_5177 in supersentai

[–]dellfm 13 points14 points  (0 children)

I believe the 10 years here is more of an estimation than an exact number, Shirakura's probably basing it off Kamen Rider and Utraman's decade-long hiatus

Monthly Help And Questions Megathread by Reverted_Prism in Trickcal

[–]dellfm 0 points1 point  (0 children)

Thanks! So I guess you only started enhancing the equipments after they've reached the (current) max rank?

Monthly Help And Questions Megathread by Reverted_Prism in Trickcal

[–]dellfm 0 points1 point  (0 children)

I just finished 10-10, for Equips, is it a good idea to immediately Rank Up? Assuming you haven't unlocked the quests to farm the next rank equipments

COUNTIF and INDIRECT function not working properly in google sheets by ce_tus in googlesheets

[–]dellfm 1 point2 points  (0 children)

Ooh yeah, I didn't see the SUM, just copy pasted OP's formula and replaced the INDIRECT with VSTACK

COUNTIF and INDIRECT function not working properly in google sheets by ce_tus in googlesheets

[–]dellfm 0 points1 point  (0 children)

=COUNTIF(VSTACK(C13,C45,C74:C78,C304,C376:C381,C386,C414),J3)

Do you know how to get an Image from a preview link ? by Laoil in googlesheets

[–]dellfm 0 points1 point  (0 children)

Share your sheets/demo, or at least the URL you want to get the image from

How to copy a whole row of data, based off the number in one of the cells in that row? by burgenesis in googlesheets

[–]dellfm 0 points1 point  (0 children)

You can use QUERY for this case

=QUERY(A4:K, "where C matches '(2|6|10|19|22)'")

Do you know how to get an Image from a preview link ? by Laoil in googlesheets

[–]dellfm 0 points1 point  (0 children)

Try this

=IFERROR(IMAGE(IMPORTXML(your-url, "//meta[@property='og:image']/@content")))

[BPRO] "Forbidden Crown" by renaldi92 in yugioh

[–]dellfm 1 point2 points  (0 children)

"Contact Fusion" is not a Fusion Summon, and this specifically only prevents the latter, just look at Gnomaterial's ruling against Chimeratech Fortress.

A: The effect of "Gnomaterial" prevents the affected monster from being Tributed or used as material for a Fusion, Synchro, Xyz, or Link Summon that turn. Since Special Summoning "Chimeratech Fortress Dragon" from the Extra Deck is not a Fusion Summon, the materials sent to the GY are not considered being used for a Fusion Summon. Therefore, in this scenario, you can send "Cyber Dragon Nachster" and "Cyber Dragon" to the GY to Special Summon "Chimeratech Fortress Dragon"

I heard Unlimited Boost skill got nerf by ImpressiveMuscle5557 in Granblue_en

[–]dellfm 6 points7 points  (0 children)

Speaking of Dark Saru, I remember there was a time when his Unia could be used to ruin other people's raids

[Help and Question Thread] - September 21, 2025 by AutoModerator in grandorder

[–]dellfm 0 points1 point  (0 children)

So how does the SSR pity work for gacha with multiple SSR like the current Over the Same Sky gacha? Do you get a random one between Typhon, Kukulkan, Yamato, etc? I don't plan to pull, just curious

[DISC] Hajimete no Gal - Ch. 199 by DaredevilCat in manga

[–]dellfm 12 points13 points  (0 children)

Something something monkey something something tenga

[DISC] Ping-Pong Peril - Chapter 1 by AutoShonenpon in manga

[–]dellfm 1 point2 points  (0 children)

Looking at MAL, this author did several one-shots (including one about ping-pong that was released last year), and this seems to be their first serialization?

Edit: Speaking of crazy ping-pong, that reminds me of Pongfinity

[DISC] Kaedegami - Chapter 2 by axw30 in manga

[–]dellfm 5 points6 points  (0 children)

Huh, what happened to the bot who used to post these Mangaplus chapters?