We need the assistance of an advanced Excel practitioner.
The file has a worksheet for:
- core data
o The core data includes: service type/normal/overtime rates/rates by consultant type.
Rates, minimum duration, billing increments (i.e. hourly, per 15 minutes and per minute) vary based on the service type
- source data
o The source data will be updated frequently (but will be in the same column format with variations on the number of rows).
- calculated data
Need calculated billing amount for each line (assignment). this needs to be able to refresh each time we update the source data.
I am a professional with a decade of experience working in a US based NASDAQ registered company and can help you with this project as per your requirements.