I have several spreadsheets that currently require manual data entry before I can do any meaningful analysis. I want to replace as much of that routine work as possible with a clean, reliable Python-driven process. Here is what I need: • Accurate entry (or import) of new records into an Excel workbook, following the exact column order and naming I will supply. • A well-commented Python script—pandas, openpyxl, or similar—that takes the raw sheet, cleans and organises the data, and then performs the core analysis I specify. • The script should be easy for me to run on fresh data with a single command, producing an updated, ready-to-use Excel file plus any summary tables or charts required. I chose Data entry as the primary task and Data analysis as the specific Excel need, with the main focus on Automating data tasks with Python. Accuracy and punctual delivery are essential; if you have ideas that make the workflow even smoother, I’m happy to hear them. Once the job is complete, please provide the finished workbook, the Python code, and a brief read-me explaining setup and usage.