Results 1 to 4 of 4

I need a formula to create productivity report based on expended manhours against estimate

Threaded View

  1. #1
    Registered User
    Join Date
    03-10-2007
    Location
    Scotland
    Posts
    38

    I need a formula to create productivity report based on expended manhours against estimate

    Hi
    I need to create a productivity report based on actual expended man hours against the estimated hours. For instance: If the expended hours are equal to the estimated hours then a return of 1 is required. If the expended hours are 10% less than estimated then a return of 0.9 is returned. If the expended hours are 14% greater than estimated then a return of 1.14 is required and so on & so forth. What formula do I need to achieve this result?

    Thanks in anticipation
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Split productivity report into two lines of business
    By Detritus Of Sparta in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-15-2015, 11:32 AM
  2. create a master list from a estimate
    By rkshelburne in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-27-2013, 01:23 AM
  3. Point Estimate
    By smallexcel in forum Excel General
    Replies: 1
    Last Post: 08-12-2012, 03:48 PM
  4. Speed up the data entry - Productivity report
    By raviexcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2010, 11:09 AM
  5. Finding point estimate and interval estimate
    By Codedzero in forum Excel General
    Replies: 1
    Last Post: 10-11-2009, 02:46 PM
  6. [SOLVED] How do I make a productivity report?
    By merniewlt in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-23-2006, 09:50 AM

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