This is to help us with the timetabling of a sports centre. We require someone to provide some assistance in writing formulae or code so we can calculate the number of cells in a spreadsheet of different colours and automatically pick up any additions or subtractions of colours cells. . I have attached a sample sheet to show you what we mean.
We want the ability to differentiate between peak hours of use and off-peak hours of use in our spreadsheet. We would also like the ability to change the peak and off peak hours over time.
We will provide the winning bidder with the actual data to work with.