Excel Tool for Consultant Management

Job ID: 39871843

Budget: $75 – $100 CAD

I need a customized Excel tool that enables me to efficiently manage consultants in a structured manner. The tool should allow me to add and remove consultants seamlessly while keeping a clear audit log of these changes on a dedicated worksheet. I’d like the tool to calculate payments that incorporate elements such as taxes, discounts, or additional fees, using exchange rates that I will enter manually.

Additionally, the Excel file should include client-specific worksheets where consultants’ data can be copied from a global payment sheet. It’s important to have all payment calculations tied to the respective client worksheets for streamlined tracking. For each consultant, I only need to track their basic details, such as name and contact information. I already have a rough structure in mind to guide the development.

To be completed before 17th October so I can test and have the fixes done before October 21