Excel Production Data Analysis
Budget: ₹1,000 – ₹5,000 INR
I have a set of operational production data that I need to explore in depth. The goal is to turn raw exports into a clean, well-structured Excel workbook that can perform meaningful data analysis at the click of a button.
Here is what I need done:
1. A clear data-input area where I can paste or import the latest production records.
2. Automatic cleansing steps (simple formulas or Power Query) that standardise dates, units, and any missing values.
Please keep everything inside one workbook, label sheets logically, and document any custom formulas or macros you use so I can maintain or expand the file later. If VBA is required for efficiency, a brief comment header explaining each procedure will be enough.
Once the workbook reliably ingests new operational data and returns the analyses described above, we’re done.
Here is what I need done:
1. A clear data-input area where I can paste or import the latest production records.
2. Automatic cleansing steps (simple formulas or Power Query) that standardise dates, units, and any missing values.
Please keep everything inside one workbook, label sheets logically, and document any custom formulas or macros you use so I can maintain or expand the file later. If VBA is required for efficiency, a brief comment header explaining each procedure will be enough.
Once the workbook reliably ingests new operational data and returns the analyses described above, we’re done.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Data Cleansing
Data Visualization
Data Analysis
Data Management