sunbrrnslapper@lemmy.world to Lemmy Shitpost@lemmy.world · 1 day agoFound at work. Send help.lemmy.worldimagemessage-square15fedilinkarrow-up179arrow-down13
arrow-up176arrow-down1imageFound at work. Send help.lemmy.worldsunbrrnslapper@lemmy.world to Lemmy Shitpost@lemmy.world · 1 day agomessage-square15fedilink
minus-squareTempermentalAnomaly@lemmy.worldlinkfedilinkarrow-up4·20 hours agoWait till AI is able to help. =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)
minus-squaresunbrrnslapper@lemmy.worldOPlinkfedilinkarrow-up3·17 hours agoOMG. Which AI tool produced this?
minus-squareTempermentalAnomaly@lemmy.worldlinkfedilinkarrow-up4·12 hours agoClaude. 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.
Wait till AI is able to help.
=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)OMG. Which AI tool produced this?
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.