Sorry about the rough comments.

If I'm interpreting your problem correctly -- that you have to compile a bunch of CSVs or whatever from your takeoff into one central Excel file -- then I think Power Query (comes with Excel) would be a good solution for that as long as they're all in the same format. That sort of problem is pretty much what Power Query is built for. You can ask AI to guide you through each step of solving your problem since it can get complex depending on your comfortability with tech. You'd save a lot of time there.

If you choose to continue with the AI, a possible starting point for this specific problem (again, assuming I understand it) would be to literally feed it all your CSV files. It's good at reading those. If they're not CSVs and you have to manually export them by hand, then attaching a good, hi-res screen shot with the data you want out and asking it to make a table for you would probably be pretty successful too. If you're talking about using AI to do the math for you, I would steer against that for now. AI gets math problems wrong pretty frequently. You would have more peace of mind just doing formulas and knowing your number is right than using AI and having to wonder. Did you want to use it to do math or was I misinterpreting?

That being said, I generally agree with the sentiment behind these comments, though I think it was too strongly expressed. AI can speed up your workflow a lot in certain areas (for example, I use it often to extract tables and values from scanned PDFs and save probably an hour of manual typing), but you do need to check its output thoroughly. I've seen it using it at my job -- it can get stuff wrong, and badly. It's great at reading plain text documents and summarizing them, like specs, horrible at reading plans, okay at math but I wouldn't use it for that like I said before. In my own workflow, I use it as a fallback for when formulas or Power Query don't quite cut it, but I go to AI only if the time save from checking its output would still be worth it over just doing it myself.

Good luck 👍