Results 1 to 9 of 9

Help on designing a workbook

Threaded View

charliebeth Help on designing a workbook 09-16-2011, 11:20 AM
Richard Buttrey Re: Help on designing a... 09-16-2011, 11:30 AM
charliebeth Re: Help on designing a... 09-16-2011, 11:51 AM
charliebeth Re: Help on designing a... 09-16-2011, 11:53 AM
Andrew-R Re: Help on designing a... 09-16-2011, 12:02 PM
charliebeth Re: Help on designing a... 09-22-2011, 07:52 AM
Andrew-R Re: Help on designing a... 09-22-2011, 07:58 AM
charliebeth Re: Help on designing a... 09-26-2011, 06:36 AM
charliebeth Re: Help on designing a... 09-26-2011, 06:36 AM
  1. #5
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Help on designing a workbook

    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?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1