Repair Log report by john
Created by: john

 

In this article we will learn about the how to prepare the repair log report in Microsoft Excel 2010 and 2013.
 
img1
 
Chart:- PO Metrics
 
img2
 
Column chart used to show the PO metrics, where we can see the numbers according to Tools received, Tools W/PO and Tools W/O PO month wise.

Through this chart we can see the numbers of tools:- Tools Received is 315, Tools W/PO- 186 and Tools W/O PO is 31.

Chart:- Average days of PO Recvd to Shipped
 
img3
 
Pie chart used to show the average of days PO received to ship and average of days received to shipped.

Chart:- Recvd VS Shipped
 
img4
 
Bar chart used to show the comparison in between received vs shipped.  Through this chart we can see that Total received is 315 and total shipped is 157.
 
img5
 
In the matrix tab we can see the summary of data such as:- Total tools received, Total tools shipped, total repairs received W/PO, % of total tools W/PO, total repairs received w/o PO’s, % of Total tools W/O PO, total items with back-ordered parts, % of total w/back- orders, avg # of the days to receive back ordered parts, avg # of days to ship from date received, Avg # days to ship from date PO received.
 
 

Users are saying about us...

  1. Pingback: Google

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube