How does the attached work for you?
The price sheet contains a simple grid to give a basic price for refresh, normal or deep cleans by job size.
The jobs sheet lists each job, multiplies the type of job by the number of days and then checks how many staff days have been put in on that job to get a day rate/staff member
The staff sheet lists all of the staff and, by day, which job they were assigned to. The pay column multiples their day rate for each job by the number of days they spent on that job.
Is that close to what you were looking for?
Bookmarks