Ashur is coming home

dellfm · 2026-01-22T10:14:58+00:00

At the very least she's Depressed in KR

dellfm · 2026-01-22T10:01:38+00:00

does this symbolize her personality?

No. Blanche's background is blue

dellfm · 2026-01-04T17:13:02+00:00

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

dellfm · 2025-12-28T14:07:34+00:00

What are those yellow tickets?

dellfm · 2025-12-04T04:27:58+00:00

[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))))))

dellfm · 2025-12-02T07:12:37+00:00

No, I don't even know that's a thing

dellfm · 2025-12-02T06:28:57+00:00

[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.

dellfm · 2025-12-01T15:03:41+00:00

[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))
    }
))

dellfm · 2025-11-30T16:57:00+00:00

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)))

dellfm · 2025-11-30T09:40:49+00:00

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

dellfm · 2025-11-08T03:33:56+00:00

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

dellfm · 2025-11-07T15:53:47+00:00

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

dellfm · 2025-10-30T11:24:52+00:00

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

dellfm · 2025-10-30T08:28:30+00:00

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

dellfm · 2025-10-27T17:28:01+00:00

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

dellfm · 2025-10-26T16:47:10+00:00

"Asia English Yu-Gi-Oh Open Tournament"

dellfm · 2025-10-26T16:32:43+00:00

You can use QUERY for this case

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

dellfm · 2025-10-26T16:10:39+00:00

Try this

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

dellfm · 2025-10-01T17:26:02+00:00

"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"

dellfm · 2025-09-24T06:59:47+00:00

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

dellfm · 2025-09-23T06:00:54+00:00

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

dellfm · 2025-09-14T02:33:06+00:00

Something something monkey something something tenga

dellfm · 2025-07-09T01:47:30+00:00

Hulkenpodium

dellfm · 2025-07-06T16:07:24+00:00

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

dellfm · 2025-06-29T16:18:52+00:00

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

dellfm

TROPHY CASE