I might be missing something in your query but if it helps, my spreadsheet uses a combination of vlookup and sumif to give me total wages and cost per site. If you'd like some help in prepping a spreadsheet which meets your needs, drop me an e mail to
callumiain@aol.com.
The issue of controlling wages (which represents about 80% of my costs) has become something of an obsession with me because, and no offence to the TimeAttends and Ezitrackers of the world, it annoyed me so much that I had to pay a monthly fee for remote time recording and a service which only partly met my requirements that I had a unit developed which would do everything I wanted but which wouldn't cost me money every month. It's taken me two years (so far!) to have my system set up to do this so that, among other things, actual as against forecast hours cleaners are recorded via a remote logging device which populates a spreadsheet and gives me my wages bill; all that by way of saying that the easiest part of it was creating an Excel sheet which handles and processes the information.
