• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

KPI Report

V

Vpremakumar

New Member
I'd like to create a excel report to measure On-time delivery (OTD) and quality of documents of a engineering group for all submissions/passes. For an example, If I submit 10 documents today that were due two days back, OTD should be measured for this first submission/pass. And I receive the comments/changes for my first submission, report should be able to measure OTD and quality of second time submission. Please respond to me. thanks
 
Premakumar,


How is your data stored.. as this is simple date-date calculation and will give you the number of days as a difference.


~VijaySharma
 
Hello,

Data is stored with documents with date of submission. As you mentioned I need no. of days difference and also the OTD % for submitted documents. Same logic for quality also.
 
A1--------------------------- B1----------C1

Project Start Date ------ Due Date -------First Submission Date

12-Jan-2011 ------------- 13-Jan-201 -----14-Jan-2011


Formula in Cell D2 : =B2-A2 formatted as Number will give you 2

Formula in Cell E2 : =C2-B2 formatted as Number will give you 1


Depending on how OTD is defined, you can then calculate the % for OTD.


HTH

~VijaySharma
 
You must log in or register to reply here.
Back
Top