Averaging (Green, Amber, Red, Black) Ratings

[Michael Pavek]

I am designing a worksheet that allows users to determine
their status in terms of:
1) Green
2) Amber
3) Red
4) Black

I am trying to make a formula that will average several
worksheets cells of G-A-R-B and produce an average.

 

[Michael Pavek]

Paul,

Have to help me out here. CMYK? I am trying to get the
rollup worksheet to average 12 worksheets of people
assessing their status as either green (90%+), Amber (80-
90%), Red (70-80%), or black (0-70%). The output that I
want is either G,A,R, or B.

Mike

 

[Paul Corrado]

Michael,

I see you have your own values assigned to the colors. Since you did not
indicate a value I was assuming that you wished to generate an average color
value based on the color mix values from the RGB or CMYK color palettes.

You can calculate an "average color" using a VLOOKUP of the average of the
sheet values as follows

=VLOOKUP("average
value",{.0,"Black";.70,"Red";.8,"Amber";.9,"Green"},2,True)


Where "average value" is the average "score" of each sheet.

PC