Excel Gantt Chart Enhancement for Construction

I run a construction company and am currently using an Excel template to visually represent all our projects in a Gantt chart. I need an expert to enhance this template for me by adding a sales target function. This function should calculate and sum up the revenue for each job based on the percentage of the job completed in each month. - Example: For a $100k job with 75% of the work days in January and 25% in February, the system should automatically allocate $75k to January and $25k to February, and sum up all the jobs for each month. The work days are automatically calculated by the existing template. The only adjustment needed is the division of revenue by month and the presentation of this in total. I have an example of the desired output, just built manually. Ideal skills and experience: - Proficiency in Excel, particularly with Gantt charts and financial calculations - Experience with creating and enhancing Excel templates - Ability to implement automatic updates tied to project changes The existing template is manually updated with new project data. I need the new revenue calculation to also update automatically when project details change. Please reach out if you have the relevant skills and experience to help me with this project.