Pwd Rate Analysis In Excel Format Updated -

| Metric | Cell A2 | Cell B2 (Value/Formula) | |--------|---------|--------------------------| | Target PWD | Target | 150 | | Actual PWD | Actual | =AVERAGE(tblPWD[PWD Rate]) | | Efficiency % | Efficiency | =B3/B2 | | Total output to date | Total Output | =SUM(tblPWD[Output]) | | Total worker days | Worker Days | =SUM(tblPWD[Effective Days]) |