4 ms·

Did you actually try running the code vs the formula and compared it works the same way in the expected cases? The times I've tried using ChatGPT, it has mostl

Did you actually try running the code vs the formula and compared it works the same way in the expected cases? The times I've tried using ChatGPT, it has mostly giving me code that seems like it'd work but doesn't.

dmurray 4y ago
"ChatGPT, can you give me some test cases for the code?"
- omgomgomgomg 4y ago
  This is interesting, would ChatGPT know to wrap everything in am iferror and can it create new sheets and book and save them as csv on any os? This took me a full week to make it work and got me a raise, but it is so hacky, I rather not want to maintain that. Can it run cron jobs, handle api responses etc?
logicallee 4y ago
(not OP) over on reddit people are saying it is fantastic for giving them excel formulas they ask for. I guess it means the formulas work!
- hermitcrab 4y ago
  That is one of the big issues with AIs like ChatGPT though. It gives you a plausible sounding answer, but that answer might be total BS. It doesn't tell you what degree of confidence it has in the answer. Maybe the formulas it gives are right 100%, 99% or 0% of the time.
  - Sharlin 4y ago
    Yes, and I think that in order for helper AIs like ChatGPT to really break through, people (especially in marketing) will have to learn to embrace confidence intervals, or at least some quantitative concept of confidence. The AI already knows how confident it is in its prediction, it's just a UI question. If plain numbers are too nerdy or Spock-y, at least tell me something like "I'm fairly sure" or "I'm not sure, but..."
  - otabdeveloper4 4y ago
    Good lord, it doesn't have any confidence at all. It's just a database query with a lossy compression step. What's the confidence level of copy-pasting random code snippets from Stackoverflow?
    - hermitcrab 4y ago
      With Stackoverflow you can base your confidence in an answer on: -the number of upvotes -the reputation of the poster -the post - sometimes posters will say "I haven't tested this" -comments With ChatGPT you have no idea.
jmkni 4y ago
Ok so you're right, looks like it will work, but actually doesn't! I wonder if ChatGPT can fix it? (will update if so)
- mcbishop 4y ago
  The VBA code seems to be a good starting point. I'm impressed!

dmurray 4y ago

"ChatGPT, can you give me some test cases for the code?"

omgomgomgomg 4y ago
This is interesting, would ChatGPT know to wrap everything in am iferror and can it create new sheets and book and save them as csv on any os? This took me a full week to make it work and got me a raise, but it is so hacky, I rather not want to maintain that. Can it run cron jobs, handle api responses etc?

logicallee 4y ago

(not OP) over on reddit people are saying it is fantastic for giving them excel formulas they ask for. I guess it means the formulas work!

hermitcrab 4y ago
That is one of the big issues with AIs like ChatGPT though. It gives you a plausible sounding answer, but that answer might be total BS. It doesn't tell you what degree of confidence it has in the answer. Maybe the formulas it gives are right 100%, 99% or 0% of the time.
- Sharlin 4y ago
  Yes, and I think that in order for helper AIs like ChatGPT to really break through, people (especially in marketing) will have to learn to embrace confidence intervals, or at least some quantitative concept of confidence. The AI already knows how confident it is in its prediction, it's just a UI question. If plain numbers are too nerdy or Spock-y, at least tell me something like "I'm fairly sure" or "I'm not sure, but..."
- otabdeveloper4 4y ago
  Good lord, it doesn't have any confidence at all. It's just a database query with a lossy compression step. What's the confidence level of copy-pasting random code snippets from Stackoverflow?
  - hermitcrab 4y ago
    With Stackoverflow you can base your confidence in an answer on: -the number of upvotes -the reputation of the poster -the post - sometimes posters will say "I haven't tested this" -comments With ChatGPT you have no idea.

jmkni 4y ago

Ok so you're right, looks like it will work, but actually doesn't! I wonder if ChatGPT can fix it? (will update if so)

mcbishop 4y ago
The VBA code seems to be a good starting point. I'm impressed!