AI-Driven Spreadsheet Automation

I need a streamlined application that lets me move seamlessly from raw files to a fully populated, insight-ready workbook.

Scope
1. Spreadsheet-to-spreadsheet transfer
• Read both data entries and the underlying formulas from a source workbook.
• Push them into matching or user-defined ranges in a target workbook without breaking references.

2. PDF-to-Excel converter
• Take recurring PDF reports and drop the contents into Excel using a custom layout I will share.
• Handle multi-page files, merged cells, and mixed text/number columns while keeping column order intact.

3. AI-powered predictive analytics
• Call an AI model (OpenAI API, Azure OpenAI, or a comparable engine) to generate forward-looking insights—forecasts, trend lines, risk flags, or similar predictive analytics—based on the transferred data.
• Write those AI results back into specific worksheet columns so everything stays in one place.

Deliverables
• Executable tool or scripted solution (Python, .NET, or VBA—whichever achieves the above reliably).
• Well-commented source code plus a brief setup & user guide.
• Quick demo session to confirm the data flow, PDF mapping, and AI output are all functioning as expected.

This is a self-contained project; once it works reliably and is documented, we are done—no long-term maintenance required.