Comment on Found at work. Send help.

TempermentalAnomaly@lemmy.world ⁨1⁩ ⁨week⁩ ago

=TEXTJOIN("",TRUE,A330,A443,A556,A669,A782,A895,A1008,A1121,A1234,A1347,A1460,A1573,A1686,A1799,A2112,A2225,A2338,A2451,A2564,A2677,A2790,A3303,A3316,A3329,A3342,A3355,A3368,A3381,A3394,A5407,A5420,A5433,A5446,A5459,A5472,A5485,A5498,A5511,A5524,A5537,A5550,A5563,A5576,A5589,A5602,A5615,A5628,A5641,A5654,A5667)

• sunbrrnslapper@lemmy.world ⁨1⁩ ⁨week⁩ ago

  OMG. Which AI tool produced this?

  source

  • TempermentalAnomaly@lemmy.world ⁨1⁩ ⁨week⁩ ago

    Claude. To be fair, it had trouble OCR-ing it. After way too much back and forth about the pattern, it produced this:

    =LET(
        rows, SEQUENCE(INT((667-30)/13+1),1,30,13),
        SUM(INDEX(AA:AA,rows))
    )
    

    Which is correct, but obviously the calculations would be best served by reorganizing the table and probably using a pivot table or at least grouping and subtotaling.

    source