Hi,
I'm trying to create an interactive databook. I'm needing to represent the percentage ranges below with the grid number associated with them - and then to have the combination of the two numbers that represent a point on the grid with a corresponding colour.
The objective of the databook is to be able to input results into the matrix/grid and be able to determine what results you might need in the future to move to a more desirable cell in the matrix/grid.
Several grid results then add up to an overall result, and I have a formula I need to sit behind the cells that will automatically calculate whatever grid numbers they put in.
Any help is greatly appreciated.
<tbody>
</tbody><colgroup><col span="6"></colgroup>
I'm trying to create an interactive databook. I'm needing to represent the percentage ranges below with the grid number associated with them - and then to have the combination of the two numbers that represent a point on the grid with a corresponding colour.
The objective of the databook is to be able to input results into the matrix/grid and be able to determine what results you might need in the future to move to a more desirable cell in the matrix/grid.
Several grid results then add up to an overall result, and I have a formula I need to sit behind the cells that will automatically calculate whatever grid numbers they put in.
Any help is greatly appreciated.
Level | 1 (Decreased Significantly) <= -7% | 2 (Decreased) >-7% and <= -2% | 3 (Maintained) > -2% and < 2% | 4 (Increased) >= 2% and < 7% | 5 (Increased Significantly) >= 7% |
5 (Very high) >= 50% | |||||
4 (High) >=40% and < 50% | |||||
3 (Medium) >=30% and < 40% | |||||
2 (Low) >= 20% and < 30% | |||||
1 (Very Low) < 20% |
<tbody>
</tbody><colgroup><col span="6"></colgroup>