I'm working on a project to create an AI Quotation tool using the ChatGPT API trained on my data. The data I have spans the last 10 years and is mostly in Excel and PDF format, but it's not consistently structured. Each entry includes customer name, task required, and the price quoted, along with the list price for all tasks we offer.
However, here's the challenge: most companies have specific requirements for the same tasks, resulting in different prices for different companies. The AI needs to identify the company details, match it with the correct task price, and adjust for inflation if necessary. For example, if a company hasn't had a particular task done in 4 years and we've had 3 price increases during that time, the AI should calculate the correct amount for that company considering inflation.
I've done some research, and it seems that results might be inconsistent due to the varying data formats and complexities. I'm curious if anyone has experience with a similar project or has any ideas on whether this is achievable? Any insights, suggestions, or advice on how to approach this would be greatly appreciated! Thank you in advance for your help!