+ Reply to Thread
Results 1 to 2 of 2

correlate and determine productivity and utilization weekly, monthly and annualy

  1. #1
    Registered User
    Join Date
    12-09-2016
    Location
    CAPE TOWN SOUTH AFRICA
    MS-Off Ver
    7
    Posts
    1

    Question correlate and determine productivity and utilization weekly, monthly and annualy

    I have an exel spread sheet which I use to correlate and determine productivity and utility of company trucks. I easily determine the daily percentage achieved but am struggling to determine the weekly and annual percentages achieved.

    My spread sheet is from Monday to Sunday and each day's productivity (Deliveries) and utility (Daily mass) is entered on a daily basis. This is measured against predetermined quantities required. I need to conceive a formula whereby I can take the daily figures and convert them into percentages of the required quantities weekly and annually on the same spread sheet.

    Any assistance will be greatly appreciated.

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,927

    Re: correlate and determine productivity and utilization weekly, monthly and annualy

    kindly attach your sample file to clear idea about your data structure.
    Last edited by avk; 12-09-2016 at 08:56 AM. Reason: Subscribe to this thread and notify me of changes


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ 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] Multiple Condition i.e Monthly Quarterly Annualy
    By EmilVictor in forum Excel General
    Replies: 3
    Last Post: 06-26-2015, 02:16 AM
  2. Weekly,Monthly,Annualy results
    By Benjamin2008 in forum Excel General
    Replies: 4
    Last Post: 12-24-2013, 03:17 AM
  3. Efficiency,Productivity & Utilization.
    By abhijeetkadam in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-26-2013, 08:48 AM
  4. [SOLVED] Determine monthly volume from weekly figures where weeks cross over at month end
    By Grimace in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-21-2012, 09:03 PM
  5. Need to count productivity by weekly and daily basis
    By marc5354 in forum Excel General
    Replies: 4
    Last Post: 10-06-2010, 01:36 PM
  6. Replies: 1
    Last Post: 07-11-2008, 05:57 AM
  7. Template track phone traffic to determine weekly, monthly trends.
    By JKPierce in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 04-06-2006, 11:35 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