Hello, I’m developing a tool using excel that will facilitate the operations assessment process for a company and we are using a five point scale: Fully completed (FC), partially completed PC 1, PC 2, PC 3 and not completed. The assessments are done for the task level, but we need to get an average of the task assessments to determine the assessment of the overall project, which then will be averaged to determine the assessment of each unit. What I am asking is first what formula do I use to associate a numerical value to the task assessments. For example FC=5, PC1=4, PC2=3,PC3=2,and NC=1. Secondly what formula can I use to get the average of the task assessments to assess the projects and then the formula to get the average of the project assessments to determine the unit assessment status. I know this is very confusing, but I’d like to get your suggestions if you could assist, thank you.
