3 ms·

"Oh.. but skip cell A.. 6? or whatever, the one with the .. uhh... " 'Error processing your request. I emailed your supervisor with my error condition.' "No,

"Oh.. but skip cell A.. 6? or whatever, the one with the .. uhh... " 'Error processing your request. I emailed your supervisor with my error condition.' "No, no! Stop. Just do whatever you did first, but now you do like the other thing too, with the skipping of the cell with the.. uh.. what's it called?! ampersand?" 'I will average the last 3 columns while adding random numbers to the rest of your document, sure. By the way, this is the information you requested. I have also forwarded it to the company CEO: 'The ampersand, also known as the and sign, is the logogram &, representing the conjunction "and". It originated as a ligature of the letters et—Latin for "and"'. SOURCE: wikipedia.' Proceeds to mess around with LLM for 3 years instead of learning wat AVERAGE() is and how it works

skummetmaelk 3y ago
You joke, but this is how people normally work. Do things in ways easy to lean, but ultimately slow and inefficient.
- SanderNL 3y ago
  I have learned this from experience. If you think this is bad, real people in real situations are actually worse. If you can get them to speak quasi-coherent sentences that’s a major win in itself. Sounds sad, but the reality these gadgets must operate under. It’s not that people are stupid, but they operate under a surprising amount of varying conditions ranging from fully inebriated to severely demotivated and/or burned out.
unsupp0rted 3y ago
"Oh.. but skip cell A.. 6? or whatever, the one with the .. uhh... " > Which column would you like me to skip? The one with the sales during covid. > Okay, I have averaged 2 of those last 3 columns, skipping the one with the sales during covid which had a header with the text "COVID data".
mewpmewp2 3y ago
It's not as simple as just using AVERAGE actually. I've had the exact problem with Google Sheets. I wanted to create a trailing average of last 7 of the numerical values in another column. I had to Google quite a bit to figure out how to handle it so the 1st to 6th row would work out well. Right now I described the issue to ChatGPT, and it was very quickly able to suggest me the following for Excel: =IF(ROW(A1)=1, A1, IF(ROW(A1)=2, AVERAGE(A1:A2), AVERAGE(OFFSET(A1,-2,0,3,1)))) For Google Sheets and trailing 7 it suggested me following: =IF(ROW(A2) < 8, AVERAGE(A$2:A2), AVERAGE(OFFSET(A2,-6,0,7,1))) If you know everything by heart, it may seem simple, but it's not just using one function, it's using multiple and knowing the exact parameters, intricacies. With Google Sheets, it would've faster for me to just use the JavaScript with Apps Script, to create this, rather than trying to figure out the syntax of this. So it uses 4 different functions there, 1. IF 2. ROW 3. AVERAGE 4. OFFSET And in such a way that I would just not come to think of it on my own out of the blue. I would try several different approaches before I were to try this one. Although it's really easy to just write a script for that. And maybe you also want to be able to dynamically configure the trailing average size, which this formula allows for very easily. Compared to when you Google, some of the articles suggest just using AVERAGE(A2:A8), but it's missing those other frequent requirements. And when you look at some Stack Overflow answers the formulas are even crazier: https://stackoverflow.com/questions/40779177/how-to-average-the-last-seven-values-in-a-column https://stackoverflow.com/questions/40779177/how-to-average-... =round(AVERAGE(OFFSET(H1,MAX(ARRAYFORMULA(ROW(H:H)--(H:H<>"")))-7,,7))) https://stackoverflow.com/questions/70282014/find-rolling-average-of-last-6-values-in-a-row https://stackoverflow.com/questions/70282014/find-rolling-av... =INDEX(AVERAGE(ARRAY_CONSTRAIN(SORT(INDIRECT("A1:"& ADDRESS(MAX(ISNUMBER(A:A)ROW(A:A)), 1, )), SEQUENCE(MAX(ISNUMBER(A:A)*ROW(A:A))), 0), 7, 1)))
- RadiozRadioz 3y ago
  It's odd to me how office people are totally fine wrangling with this mess, but are terrified of programming. This looks way more confusing, magic and brittle to me.

skummetmaelk 3y ago

You joke, but this is how people normally work. Do things in ways easy to lean, but ultimately slow and inefficient.

SanderNL 3y ago
I have learned this from experience. If you think this is bad, real people in real situations are actually worse. If you can get them to speak quasi-coherent sentences that’s a major win in itself. Sounds sad, but the reality these gadgets must operate under. It’s not that people are stupid, but they operate under a surprising amount of varying conditions ranging from fully inebriated to severely demotivated and/or burned out.

unsupp0rted 3y ago

"Oh.. but skip cell A.. 6? or whatever, the one with the .. uhh... " > Which column would you like me to skip? The one with the sales during covid. > Okay, I have averaged 2 of those last 3 columns, skipping the one with the sales during covid which had a header with the text "COVID data".

mewpmewp2 3y ago

It's not as simple as just using AVERAGE actually. I've had the exact problem with Google Sheets. I wanted to create a trailing average of last 7 of the numerical values in another column. I had to Google quite a bit to figure out how to handle it so the 1st to 6th row would work out well. Right now I described the issue to ChatGPT, and it was very quickly able to suggest me the following for Excel: =IF(ROW(A1)=1, A1, IF(ROW(A1)=2, AVERAGE(A1:A2), AVERAGE(OFFSET(A1,-2,0,3,1)))) For Google Sheets and trailing 7 it suggested me following: =IF(ROW(A2) < 8, AVERAGE(A$2:A2), AVERAGE(OFFSET(A2,-6,0,7,1))) If you know everything by heart, it may seem simple, but it's not just using one function, it's using multiple and knowing the exact parameters, intricacies. With Google Sheets, it would've faster for me to just use the JavaScript with Apps Script, to create this, rather than trying to figure out the syntax of this. So it uses 4 different functions there, 1. IF 2. ROW 3. AVERAGE 4. OFFSET And in such a way that I would just not come to think of it on my own out of the blue. I would try several different approaches before I were to try this one. Although it's really easy to just write a script for that. And maybe you also want to be able to dynamically configure the trailing average size, which this formula allows for very easily. Compared to when you Google, some of the articles suggest just using AVERAGE(A2:A8), but it's missing those other frequent requirements. And when you look at some Stack Overflow answers the formulas are even crazier: https://stackoverflow.com/questions/40779177/how-to-average-the-last-seven-values-in-a-column https://stackoverflow.com/questions/40779177/how-to-average-... =round(AVERAGE(OFFSET(H1,MAX(ARRAYFORMULA(ROW(H:H)--(H:H<>"")))-7,,7))) https://stackoverflow.com/questions/70282014/find-rolling-average-of-last-6-values-in-a-row https://stackoverflow.com/questions/70282014/find-rolling-av... =INDEX(AVERAGE(ARRAY_CONSTRAIN(SORT(INDIRECT("A1:"& ADDRESS(MAX(ISNUMBER(A:A)ROW(A:A)), 1, )), SEQUENCE(MAX(ISNUMBER(A:A)*ROW(A:A))), 0), 7, 1)))

RadiozRadioz 3y ago
It's odd to me how office people are totally fine wrangling with this mess, but are terrified of programming. This looks way more confusing, magic and brittle to me.