Here is the scenario:
I have an "Estimated Work Hours (Calculated)" value to complete a task. That task will span multiple work weeks or months - based on Estimated Start Date (manually entered) and Estimated Completion Date (Calculated). The assumption is that the Estimated k Hours (Calculated) are distributed equally across the work weeks.
Formulas:
This calculates the "Estimated Completion Date (Calculated)" =IF(D5="","",WORKDAY(D5,Setup!$C$8/8,Holidays_2022)) The value in Setup!$C$8 is 835
This calculates the "Estimated Work Hours (Calculated)" =IF(D5="","",NETWORKDAYS(D5,E5,Holidays_2022)*8)
This calculates the "Elapsed Days" =IF(D5="","",DATEDIF(D5,E5,"D"))
I would like to have the net work hours distributed equally by month (in this example, between March and July) based on the Start and End month. This is only one parameter on the project but if I could solicit assistance on the Implementation Engineer, I can extrapolate it to the other duties. Any assistance is appreciated. Thanks.
I have an "Estimated Work Hours (Calculated)" value to complete a task. That task will span multiple work weeks or months - based on Estimated Start Date (manually entered) and Estimated Completion Date (Calculated). The assumption is that the Estimated k Hours (Calculated) are distributed equally across the work weeks.
Formulas:
This calculates the "Estimated Completion Date (Calculated)" =IF(D5="","",WORKDAY(D5,Setup!$C$8/8,Holidays_2022)) The value in Setup!$C$8 is 835
This calculates the "Estimated Work Hours (Calculated)" =IF(D5="","",NETWORKDAYS(D5,E5,Holidays_2022)*8)
This calculates the "Elapsed Days" =IF(D5="","",DATEDIF(D5,E5,"D"))
Project | Client | Role | Estimated Start Date | Estimated Completion Date (Calculated) | Estimated Work Hours (Calculated) | Elapsed Days |
Project 1 | Implementation Engineer | 3/2/2022 | 7/29/2022 | 840 | 149 |
I would like to have the net work hours distributed equally by month (in this example, between March and July) based on the Start and End month. This is only one parameter on the project but if I could solicit assistance on the Implementation Engineer, I can extrapolate it to the other duties. Any assistance is appreciated. Thanks.
January | February | March | April | May | June | July | August | September | October | November | December | |
Implementation Engineer |