+ Reply to Thread
Results 1 to 7 of 7

How to Calculate On-Time Delivery Performance %

  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    How to Calculate On-Time Delivery Performance %

    I need help in calculating the Customer on-time delivery performance in %. Please see the last tab of the excel file attached. Any help will be greatly appreciated. This will be for Column N. Thanks
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-11-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: How to Calculate On-Time Delivery Performance %

    Any help with this will be appreciated. Thanks

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: How to Calculate On-Time Delivery Performance %

    Maybe this?
    =1-(H2/G2)

    What was your expected answer?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    02-11-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: How to Calculate On-Time Delivery Performance %

    Sorry just comes up with 0% I would like to know the Customer On-Time Delivery Performance on the last tab and column "N". Thanks

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: How to Calculate On-Time Delivery Performance %

    increase the decimal places

    What was your expected answer?
    Last edited by FDibbins; 02-27-2014 at 07:28 PM.

  6. #6
    Registered User
    Join Date
    02-11-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: How to Calculate On-Time Delivery Performance %

    I did that and comes up with the wrong %. Please do it in the excel file attached to this thread and resend I would appreciate it. Thanks again

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: How to Calculate On-Time Delivery Performance %

    I ask again...what is your expected answer??

+ 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] help to find a formula to calculate the delivery charge !
    By rmp123 in forum Excel General
    Replies: 7
    Last Post: 02-22-2014, 09:28 AM
  2. Replies: 2
    Last Post: 06-05-2013, 12:14 PM
  3. calculate formula for on-time delivery
    By birgiths in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-28-2012, 10:37 AM
  4. Excel 2007 : Calculate On Time Delivery
    By Smartfabrication in forum Excel General
    Replies: 3
    Last Post: 03-14-2011, 09:23 PM
  5. Tried to get my delivery charge calculate base on the table but failed
    By kevinlau85 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-26-2009, 12:11 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