There are 5 sheets (activity, small project, medium project, large project and program) I have included rules at the bottom of the activity and small project sheets. These rules need to be scaled up for medium project etc. Activity has 7 boxes with 5 lines each but only 1 criteria of each box completed. small project has 7 boxes with 5 lines each with 2 criteria of each box completed etc until program which has 7 boxes with 5 criteria of each box completed.
Using the rules the corresponding health status diamond will change to the key's colour and letter. For example if schedule is +5% over then the health status schedule diamond will automatically change to red with the R in the middle and so on. All criteria weightings need to be the same % but in the future if I wish to change these weightings then I need an easy method to do so. Maybe adding a weighting column. Please note criteria needs to be editable. So only the criteria or weighting will be changed. The input result won't.
To ensure you have read the scope of work please insert "Purple Bird" at the start of your response. Failure to do so will mean no reading of bid.