The spreadsheet below shows the number of contracts won by various sales staff each week.

Making calculations based on cell colour
You'd like to find out some information about the contracts won by your experienced sales staff.
Previously, the background of the cells in your spreadsheet was colour-coded according to the level of experience of the sales staff.

Cells with a green background show information relating to experienced staff members.
ColorCalc can, therefore, take the cells coloured green and make calculations with them.
So you can quickly find out the total number of contracts won by the experienced sales staff, based on the fact the cells are green.
You can also find the average number of contracts won by your experienced sales staff.
Selecting sections of your spreadsheet
ColorCalc will allow you to select the whole spreadsheet or choose specific sections.
This means you can find the number of contracts the experienced sales people won in a particular week, over the course of several weeks, or the whole time period.
Combining calculations
You'd like to compare the number of contracts won by your experienced sales people with your new, less-experienced staff.
Cells containing information about new staff members have a tan background (see above).
ColorCalc can combine calculations.
So you can ask ColorCalc to:
-
Calculate the average number of contracts won by experienced staff (green background).
-
Calculate the average number of contracts won by new staff (tan background).
-
Then subtract one from the other.
... thereby showing the difference in the average number of contracts won by each these groups of staff.
Calculations based on text colour
Any of the calculations above could have been based on text colour.
In this particular spreadsheet, each sales team is indicated using a different text colour.
So if you were looking to find out information about a particular sales team, you would simply instruct ColorCalc to calculate based on text colour.