Updating the physical progress of the project with physical % complete

admin
July 28, 2020
No Comments

According to this, all the values of this column are entered manually and the calculation of the summary of this field in the software is associated with problems, there is no principled and scientific formula for its calculation.
To solve the problem mentioned in row 1, we act as follows.
Define a project with 3 activities and two-day times in the form of FS. The project start date is August 24, 2015. Enter %Complete and Physical %Complete columns.
Create three columns named number2, number3, number1.
Name their titles in order, “physically finished%”, “weighted worth”, “physically finished weight”.

Weighted Value is the weighted values of activities that are entered manually. Select Rull Up from Sum type.
The physically finished weight field is the product of the Physical % Complete value in the weighted value. To calculate this value, we need to write the following formula. For the above field, select Roll Up from Sum type.

8. The physically finished% field recalculates the new physical progress based on the weighting done. To calculate this column, we divide the value in the physically finished weight column by the weighted value.