Excel Data - add 4 columns with values based on existing data ASAP
Budget: $10 – $30 USD
I'm urgently needing an Excel wizard to finesse my data and calculate some critical metrics for my project.
**Key Requirements:**
- **SLA Days Calculation**: Determine the Service Level Agreement days based on priority.
- **Actual Days Calculation**: Calculate the actual days using Date Difference functions.
- **Delay Days**: Find the delay by subtracting SLA Days from Actual Days.
- **Delay Status**: Categorize delay status into text labels based on a provided range of delay days.
- **Date Formatting**: Ensure date columns are correctly formatted to support accurate calculations.
**Skills Needed:**
- Proficiency in Excel functions and formulas (especially Date Difference).
- Ability to categorize data based on conditional ranges.
- Quick turnaround with attention to detail.
**Experience Required:**
- Extensive experience with Excel data manipulation.
- Familiarity with establishing and interpreting SLAs.
- Previous projects involving time-sensitive data reporting.
Let's get this Excel sheet in tip-top shape— urgently!
IT IS IMPORTANT TO INCLUDE VIDEO OF ALL DONE STEPS OR DOCUMENT SO THAT THE SAME CAN BE IMPLEMENTED ON OTHER DATA.
**Key Requirements:**
- **SLA Days Calculation**: Determine the Service Level Agreement days based on priority.
- **Actual Days Calculation**: Calculate the actual days using Date Difference functions.
- **Delay Days**: Find the delay by subtracting SLA Days from Actual Days.
- **Delay Status**: Categorize delay status into text labels based on a provided range of delay days.
- **Date Formatting**: Ensure date columns are correctly formatted to support accurate calculations.
**Skills Needed:**
- Proficiency in Excel functions and formulas (especially Date Difference).
- Ability to categorize data based on conditional ranges.
- Quick turnaround with attention to detail.
**Experience Required:**
- Extensive experience with Excel data manipulation.
- Familiarity with establishing and interpreting SLAs.
- Previous projects involving time-sensitive data reporting.
Let's get this Excel sheet in tip-top shape— urgently!
IT IS IMPORTANT TO INCLUDE VIDEO OF ALL DONE STEPS OR DOCUMENT SO THAT THE SAME CAN BE IMPLEMENTED ON OTHER DATA.