I think the concern is that you can come up with a number of formulas that will get correct answers for some combinations of values and not others.
If you do not understand the logic of the formula, and what each function does, how do you verify they are correct and will always give you the results you think they will? Double check every result in it’s entirety?
Verification is important, but I think you’re omitting from your imagination a real and large category of people who have a basic familiarity with spreadsheets and computers, so are able to understand a potential solution and see whether it makes sense, but who do not have the ability to quickly come up with it themselves.
In language it’s the difference between receptive and productive vocabulary: there are words which you understand but which you would never say or write because they’re part of your receptive, but not productive knowledge.
There are times when this will go wrong, because the LLM will can produce something plausible but incorrect and such a person will fail to spot it. And of course if you blindly trust it with something you’re not actually capable of (or willing to) check then you will also get bad results.
percent@infosec.pub 17 hours ago
By verifying that they’re correct…? 🤔
theparadox@lemmy.world 17 hours ago
I think the concern is that you can come up with a number of formulas that will get correct answers for some combinations of values and not others.
If you do not understand the logic of the formula, and what each function does, how do you verify they are correct and will always give you the results you think they will? Double check every result in it’s entirety?
Lightfire228@pawb.social 14 hours ago
That’s my thinking
If you know what you’re doing, it’s significantly easier to do it yourself
You at least have some reassurance it’s correct (or at least thought through)
FishFace@lemmy.world 3 hours ago
Verification is important, but I think you’re omitting from your imagination a real and large category of people who have a basic familiarity with spreadsheets and computers, so are able to understand a potential solution and see whether it makes sense, but who do not have the ability to quickly come up with it themselves.
In language it’s the difference between receptive and productive vocabulary: there are words which you understand but which you would never say or write because they’re part of your receptive, but not productive knowledge.
There are times when this will go wrong, because the LLM will can produce something plausible but incorrect and such a person will fail to spot it. And of course if you blindly trust it with something you’re not actually capable of (or willing to) check then you will also get bad results.