You need to go through the powerpoint and see every indicator/goal for each category (workforce, process improvement, productivity). Redo the current scoring table to only have those indicators and use a range to score them out of 5. 5 being the best and 1 being the worst. for example in process improvement if the goal is to get the claim denials to 3% or below. So the score 5 would be for 3% or below and then look at the chart to see the range and make least score ( which would be 1 ) the worst % in denial which in this case is 20. So use that range to create correct scores for them.
you have to fix the indicators, for example all staff does not make sense. a table should be able to be printed out and given to someone and make sense as-is. There should be enough information in the table so that it doesn’t need to be explained. If you look at publications the tables always include enough information that they could be taken out of the paper and would still be mostly understood.
the table has to have the key and the metric goals in it.
As it stands alone, it is without context. The actual metrics should be in table so that the numbers make sense
in the powerpoint it shows all the indicators for each focus area, Redo the scoring table and only add those indicators/goals that are mentioned in the power point using the right terms and metrics
After fixing the scoring table, in the first sheet of the excel i need you to add to the summary for the 3 companies and see who gets the highest score.