+ Reply to Thread
Results 1 to 4 of 4

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

  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

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,783

    Re: I need a formula to create productivity report based on expended manhours against esti

    Try this in O3 copied down:

    =ROUND((K3/H3),2)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

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

    Re: I need a formula to create productivity report based on expended manhours against esti

    Works perfectly. Thank you so much Ali. Much appreciated

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,783

    Re: I need a formula to create productivity report based on expended manhours against esti

    Happy to help!

+ Reply to Thread

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