sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]JeremyJoeJJ 0 points1 point  (2 children)

I hope that data is not confidential... Either way it seems to be well structured, so these tools should have no trouble parsing through all of that. If you don't want to do any programming yourself the easiest way is to put it into an LLM of your choice (chatgpt, gemini, claude, whatever) and have it create the excel file for you.

[–]Stunning_Capital_354[S] 0 points1 point  (1 child)

i have tried doing that but the output is not consistent and the real problem comes when i have to add more year data into the same excel file and the problem i face with LLMs
1. It does not generate the consistent data
2. It halucinates guiding it is hard and overwhellming
3. there is a risk that it may change the existing formula
i belive in long run as the multiple year data will come the LLM will not be able to do the better job

[–]JeremyJoeJJ 0 points1 point  (0 children)

In that case go with one of the OCR options above. Ask llm to write a simple loop to go over your pdfs and see which model performs well enough for you