Hi all I am newer to chat GTP and am starting to finally understand the ins and outs of prompting it correctly to get the results I need. More recently I have found a issue I have not been able to get around and looking for some insight.
I am working on an excel sheet that has a problem, solution, and possible root cause. I am working with chat gtp to analyze these three columns to break each of them into a disclipline and problem component. The sheet consists of around 1500 rows. I trained chatgtp with various documentation and it is able to answer correctly in chat. But when it gets to the excel sheet it answers a large chunk if not all the values incorrectly. I have tried various ways of prompting it, and the last attempt even went through debugging its issues with it. It found that it was an issue with a loop it was using for the data in excel, but as we progressed it was never really able to find a solution. It works when I prompt it to do one row but not multiple (which confirms the loop issue it gave me).
Is anyone else seeing something similar and is there a way to prompt it better to get the results in the excel sheet that its giving me directly in the chat.
This is besides the issue I am having with it where if we talk for a few hours or it times out it cant save or read files any more and I have to start over in a new chat.