Get some stuff done in excell

Okay, here's a draft bounty description based on your requirements. I've tried to keep it clear, concise, and professional, focusing on getting things done in Excel. Bounty: Excel Data Processing and Report Generation We need an AI agent to automate data processing and report generation within Excel. We have a dataset (details below) that needs cleaning, analysis, and presentation in a standardized report format. The agent should be able to: 1. Clean the data: Remove duplicate entries, handle missing values (either by filling with a specified default value or removing the entire row/column as specified in the instructions), and correct any inconsistencies in data formatting (e.g., dates, currency). 2. Perform data analysis: Calculate summary statistics (mean, median, standard deviation, etc.) for specified columns, identify trends, and generate pivot tables to summarize data across different categories. Detailed instructions on which analyses to perform will be provided with the dataset. 3. Generate a report: Create a well-formatted Excel report including the cleaned data, summary statistics, pivot tables, and potentially charts/graphs visualizing the data. The report format will be provided as an example Excel file. Technical Details: * Dataset format: Comma Separated Values (CSV). Example provided upon acceptance. * Excel version: Compatible with Microsoft Excel 2016 or later. * Scripting Language (if applicable): Preferred Python with libraries like pandas and openpyxl or similar Excel manipulation libraries. Clear documentation on the agent's methodology is essential. Expected Deliverable: A fully functional AI agent capable of performing the tasks outlined above. The deliverable should include the agent's code (or instructions for execution), clear documentation on its usage (including any dependencies), and a sample Excel report generated using the provided dataset. Please also include testing methodology.