Spreadsheet: 65178d1265895404-print-range-of-cells-factory-kpis-2010-2011new
Sheet: Calculations

 |  |  |  | This is the calculation for the yearly complaints, the information is pulled from "Complaints" then displayed in "Yearly complaints" as a graph
 |  |  | Month | Complaint | Amount |  | Complaint | Amount |  | Complaint | Amount |  | Complaint | Amount |  | Complaint | Amount |  | Complaint | Amount |  | Complaint | Amount |  | Complaint | Amount |  | Complaint | Amount |  | Complaint | Amount
 |  |  | May | Processing Errors | 2 |  | Doors Damaged | 2 |  | Panels Damaged | 2 |  | Missing Items | 2 |  | Wrong Items Sent | 2 |  | Manufacture Error | 2 |  | Operator Error | 0 |  | Fitter Error | 0 |  | Trade Error | 0 |  | Supplier Error | 0
 |  |  | June | Processing Errors | 2 |  | Doors Damaged | 2 |  | Panels Damaged | 2 |  | Missing Items | 2 |  | Wrong Items Sent | 2 |  | Manufacture Error | 2 |  | Operator Error | 0 |  | Fitter Error | 0 |  | Trade Error | 0 |  | Supplier Error | 0
 |  |  | July | Processing Errors | 0 |  | Doors Damaged | 0 |  | Panels Damaged | 0 |  | Missing Items | 0 |  | Wrong Items Sent | 0 |  | Manufacture Error | 0 |  | Operator Error | 0 |  | Fitter Error | 0 |  | Trade Error | 0 |  | Supplier Error | 0
 |  |  | August | Processing Errors | 0 |  | Doors Damaged | 0 |  | Panels Damaged | 0 |  | Missing Items | 0 |  | Wrong Items Sent | 0 |  | Manufacture Error | 0 |  | Operator Error | 0 |  | Fitter Error | 0 |  | Trade Error | 0 |  | Supplier Error | 0
 |  |  | September | Processing Errors | 0 |  | Doors Damaged | 0 |  | Panels Damaged | 0 |  | Missing Items | 0 |  | Wrong Items Sent | 0 |  | Manufacture Error | 0 |  | Operator Error | 0 |  | Fitter Error | 0 |  | Trade Error | 0 |  | Supplier Error | 0
 |  |  | October | Processing Errors | 0 |  | Doors Damaged | 0 |  | Panels Damaged | 0 |  | Missing Items | 0 |  | Wrong Items Sent | 0 |  | Manufacture Error | 0 |  | Operator Error | 0 |  | Fitter Error | 0 |  | Trade Error | 0 |  | Supplier Error | 0
 |  |  | November | Processing Errors | 0 |  | Doors Damaged | 0 |  | Panels Damaged | 0 |  | Missing Items | 0 |  | Wrong Items Sent | 0 |  | Manufacture Error | 0 |  | Operator Error | 0 |  | Fitter Error | 0 |  | Trade Error | 0 |  | Supplier Error | 0
 |  |  | December | Processing Errors | 0 |  | Doors Damaged | 0 |  | Panels Damaged | 0 |  | Missing Items | 0 |  | Wrong Items Sent | 0 |  | Manufacture Error | 0 |  | Operator Error | 0 |  | Fitter Error | 0 |  | Trade Error | 0 |  | Supplier Error | 0
 |  |  | January | Processing Errors | 0 |  | Doors Damaged | 0 |  | Panels Damaged | 0 |  | Missing Items | 0 |  | Wrong Items Sent | 0 |  | Manufacture Error | 0 |  | Operator Error | 0 |  | Fitter Error | 0 |  | Trade Error | 0 |  | Supplier Error | 0
 |  |  | February | Processing Errors | 0 |  | Doors Damaged | 0 |  | Panels Damaged | 0 |  | Missing Items | 0 |  | Wrong Items Sent | 0 |  | Manufacture Error | 0 |  | Operator Error | 0 |  | Fitter Error | 0 |  | Trade Error | 0 |  | Supplier Error | 0
 |  |  | March | Processing Errors | 0 |  | Doors Damaged | 0 |  | Panels Damaged | 0 |  | Missing Items | 0 |  | Wrong Items Sent | 0 |  | Manufacture Error | 0 |  | Operator Error | 0 |  | Fitter Error | 0 |  | Trade Error | 0 |  | Supplier Error | 0
 |  |  | April | Processing Errors | 0 |  | Doors Damaged | 0 |  | Panels Damaged | 0 |  | Missing Items | 0 |  | Wrong Items Sent | 0 |  | Manufacture Error | 0 |  | Operator Error | 0 |  | Fitter Error | 0 |  | Trade Error | 0 |  | Supplier Error | 0
 |  |  | Total: |  | 4 |  |  | 4 |  |  | 4 |  |  | 4 |  |  | 4 |  |  | 4 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  |  | Error: | Total:
 |  |  | Processing Errors | 4
 |  |  | Doors Damaged | 4
 |  |  | Panels Damaged | 4
 |  |  | Missing Items | 4
 |  |  | Wrong Items Sent | 4
 |  |  | Manufacture Error | 4
 |  |  | Operator Error
 |  |  | Fitter Error
 |  |  | Trade Error
 |  |  | Supplier Error
 |  |  |  | This is the calculation for the monthly complaints graph's, the information is being pulled from the above table
 |  |  | May |  |  |  | June |  |  | July |  |  | August |  |  | September
 |  |  | Error: | Total: |  |  | Error: | Total: |  | Error: | Total: |  | Error: | Total: |  | Error: | Total:
 |  |  | Processing Errors | 2 |  |  | Processing Errors | 2 |  | Processing Errors | 0 |  | Processing Errors | 0 |  | Processing Errors | 0
 |  |  | Doors Damaged | 2 |  |  | Doors Damaged | 2 |  | Doors Damaged | 0 |  | Doors Damaged | 0 |  | Doors Damaged | 0
 |  |  | Panels Damaged | 2 |  |  | Panels Damaged | 2 |  | Panels Damaged | 0 |  | Panels Damaged | 0 |  | Panels Damaged | 0
 |  |  | Missing Items | 2 |  |  | Missing Items | 2 |  | Missing Items | 0 |  | Missing Items | 0 |  | Missing Items | 0
 |  |  | Wrong Items Sent | 2 |  |  | Wrong Items Sent | 2 |  | Wrong Items Sent | 0 |  | Wrong Items Sent | 0 |  | Wrong Items Sent | 0
 |  |  | Manufacture Error | 2 |  |  | Manufacture Error | 2 |  | Manufacture Error | 0 |  | Manufacture Error | 0 |  | Manufacture Error | 0
 |  |  | Operator Error |  |  |  | Operator Error |  |  | Operator Error |  |  | Operator Error |  |  | Operator Error
 |  |  | Fitter Error |  |  |  | Fitter Error |  |  | Fitter Error |  |  | Fitter Error |  |  | Fitter Error
 |  |  | Trade Error |  |  |  | Trade Error |  |  | Trade Error |  |  | Trade Error |  |  | Trade Error
 |  |  | Supplier Error |  |  |  | Supplier Error |  |  | Supplier Error |  |  | Supplier Error |  |  | Supplier Error
 |  |  | October |  |  |  | November |  |  | December |  |  | January |  |  | February |  |  | March
 |  |  | Error: | Total: |  |  | Error: | Total: |  | Error: | Total: |  | Error: | Total: |  | Error: | Total: |  | Error: | Total:
 |  |  | Processing Errors | 0 |  |  | Processing Errors | 0 |  | Processing Errors | 0 |  | Processing Errors | 0 |  | Processing Errors | 0 |  | Processing Errors | 0
 |  |  | Doors Damaged | 0 |  |  | Doors Damaged | 0 |  | Doors Damaged | 0 |  | Doors Damaged | 0 |  | Doors Damaged | 0 |  | Doors Damaged | 0
 |  |  | Panels Damaged | 0 |  |  | Panels Damaged | 0 |  | Panels Damaged | 0 |  | Panels Damaged | 0 |  | Panels Damaged | 0 |  | Panels Damaged | 0
 |  |  | Missing Items | 0 |  |  | Missing Items | 0 |  | Missing Items | 0 |  | Missing Items | 0 |  | Missing Items | 0 |  | Missing Items | 0
 |  |  | Wrong Items Sent | 0 |  |  | Wrong Items Sent | 0 |  | Wrong Items Sent | 0 |  | Wrong Items Sent | 0 |  | Wrong Items Sent | 0 |  | Wrong Items Sent | 0
 |  |  | Manufacture Error | 0 |  |  | Manufacture Error | 0 |  | Manufacture Error | 0 |  | Manufacture Error | 0 |  | Manufacture Error | 0 |  | Manufacture Error | 0
 |  |  | Operator Error |  |  |  | Operator Error |  |  | Operator Error |  |  | Operator Error |  |  | Operator Error |  |  | Operator Error
 |  |  | Fitter Error |  |  |  | Fitter Error |  |  | Fitter Error |  |  | Fitter Error |  |  | Fitter Error |  |  | Fitter Error
 |  |  | Trade Error |  |  |  | Trade Error |  |  | Trade Error |  |  | Trade Error |  |  | Trade Error |  |  | Trade Error
 |  |  | Supplier Error |  |  |  | Supplier Error |  |  | Supplier Error |  |  | Supplier Error |  |  | Supplier Error |  |  | Supplier Error
 |  |  | April
 |  |  | Error: | Total:
 |  |  | Processing Errors | 0
 |  |  | Doors Damaged | 0
 |  |  | Panels Damaged | 0
 |  |  | Missing Items | 0
 |  |  | Wrong Items Sent | 0
 |  |  | Manufacture Error | 0
 |  |  | Operator Error
 |  |  | Fitter Error
 |  |  | Trade Error
 |  |  | Supplier Error