Hacker News Reader

Comment by capableweb | Hacker News Reader

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.

(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!

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.

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

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?

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.

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)

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

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

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?

Reply on news.ycombinator.com