I have a pivot table in Excel and I don't understand stand how mathematically it arrived with 70% for the % completion of our project.
There are 32 total line items, so I tried adding the 9 100%s as 9 1's, so 9 + .67 = 9.67/32 = .3021875 then - 1 = .6978125 = 70%. Is that how they did it (there is a link to see a picture of the pivot table below)?
B/c I tried also removing the 67% in Stake 2, so that I just had to add 9 1's (for the 9 100%s) and I divided 9/32 = .28125 -1 = .71875 = 72% but Excel has 63% for the total % completion.
I don't understand, and the internet just talks in terms of Accounting and I can't translate that into what I need it for. Can anyone help? Thank you.
Total Nodes Completed / Total Nodes = $308/441 \approx 69.84\%$.