Spreadsheet: 64210d1265105572-excel-2003-chart-not-displaying-items-tempct
Sheet: Monthly Summary

Graph Summary
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Orders | Early | Late | On-time/Early | % OTD | Six-month sum | Early-late sum | On-time sum | 6 Mth Rolling Ave | AP Level | Adjusted OTE
2009-02-01 00:00:00 | 11 | 0 | 2 | 9 | 0.8181818181818182 | 122 | 20 | 108 | 0.8763714063714064 | 0.95 | #N/A
2009-03-01 00:00:00 | 22 | 0 | 0 | 22 | 1 | 126 | 14 | 115 | 0.9041491841491842 | 0.95 | #N/A
2009-04-01 00:00:00 | 20 | 0 | 3 | 17 | 0.85 | 121 | 14 | 109 | 0.8924825174825175 | 0.95 | #N/A
2009-05-01 00:00:00 | 8 | 0 | 0 | 8 | 1 | 103 | 12 | 93 | 0.9053030303030303 | 0.95 | #N/A
2009-06-01 00:00:00 | 8 | 0 | 2 | 6 | 0.75 | 89 | 12 | 80 | 0.8863636363636364 | 0.95 | #N/A
2009-07-01 00:00:00 | 5 | 0 | 0 | 5 | 1 | 74 | 9 | 67 | 0.903030303030303 | 0.95 | #N/A
2009-08-01 00:00:00 | 5 | 0 | 1 | 4 | 0.8 | 68 | 8 | 62 | 0.8999999999999999 | 0.95 | #N/A
2009-09-01 00:00:00 | 7 | 0 | 0 | 7 | 1 | 53 | 6 | 47 | 0.9 | 0.95 | #N/A
2009-10-01 00:00:00 | 10 | 0 | 0 | 10 | 1 | 43 | 6 | 40 | 0.9249999999999999 | 0.95 | #N/A
2009-11-01 00:00:00 | 14 | 0 | 5 | 9 | 0.6428571428571429 | 49 | 8 | 41 | 0.8654761904761905 | 0.95 | #N/A
2009-12-01 00:00:00 | 20 | 0 | 11 | 9 | 0.45 | 61 | 19 | 44 | 0.8154761904761906 | 0.95 | #N/A
2010-01-01 00:00:00 | 31 | 0 | 11 | 20 | 0.6451612903225806 | 87 | 28 | 59 | 0.7563364055299538 | 0.975 | #N/A
2010-02-01 00:00:00 |  |  |  |  | #N/A |  |  |  | #N/A | 0.975 | #N/A
2010-03-01 00:00:00 |  |  |  |  | #N/A |  |  |  | #N/A | 0.975 | #N/A
2010-04-01 00:00:00 |  |  |  |  | #N/A |  |  |  | #N/A | 0.975 | #N/A
2010-05-01 00:00:00 |  |  |  |  | #N/A |  |  |  | #N/A | 0.975 | #N/A
2010-06-01 00:00:00 |  |  |  |  | #N/A |  |  |  | #N/A | 0.975 | #N/A
2010-07-01 00:00:00 |  |  |  |  | #N/A |  |  |  | #N/A | 0.975 | #N/A
Data Summary
Enter summarised data in white area and chart date in green box
2010-01-01 00:00:00 | Orders | Early | Late | On-time/Early | % OTD | Six-month sum | Early-late sum | On-time sum | 6 Mth Rolling Ave | AP Level | Adjusted OTE | Comments
2008-01-01 00:00:00 | 28 |  | 4 | 24 | 0.8571428571428571 |  |  |  |  | 0.925
2008-02-01 00:00:00 | 25 |  | 7 | 18 | 0.72 |  |  |  |  | 0.925
2008-03-01 00:00:00 | 19 |  | 6 | 13 | 0.6842105263157895 |  |  |  |  | 0.925
2008-04-01 00:00:00 | 23 |  | 0 | 23 | 1 |  |  |  |  | 0.925
2008-05-01 00:00:00 | 17 |  | 4 | 13 | 0.7647058823529411 |  |  |  |  | 0.925
2008-06-01 00:00:00 | 21 |  | 4 | 17 | 0.8095238095238095 | 133 | 25 | 108 | 0.8059305125558995 | 0.925
2008-07-01 00:00:00 | 30 |  | 3 | 27 | 0.9 | 135 | 28 | 111 | 0.8130733696987568 | 0.925
2008-08-01 00:00:00 | 20 |  | 6 | 14 | 0.7 | 130 | 30 | 107 | 0.8097400363654234 | 0.925
2008-09-01 00:00:00 | 18 |  | 3 | 15 | 0.8333333333333334 | 129 | 26 | 109 | 0.8345938375350138 | 0.925
2008-10-01 00:00:00 | 25 |  | 2 | 23 | 0.92 | 131 | 22 | 109 | 0.8212605042016806 | 0.925
2008-11-01 00:00:00 | 26 |  | 2 | 24 | 0.9230769230769231 | 140 | 24 | 120 | 0.8476556776556778 | 0.925
2008-12-01 00:00:00 | 22 |  | 3 | 19 | 0.8636363636363636 | 141 | 23 | 122 | 0.8566744366744367 | 0.925
2009-01-01 00:00:00 | 20 |  | 2 | 18 | 0.9 | 131 | 21 | 113 | 0.8566744366744367 | 0.95
2009-02-01 00:00:00 | 11 |  | 2 | 9 | 0.8181818181818182 | 122 | 20 | 108 | 0.8763714063714064 | 0.95
2009-03-01 00:00:00 | 22 |  | 0 | 22 | 1 | 126 | 14 | 115 | 0.9041491841491842 | 0.95
2009-04-01 00:00:00 | 20 |  | 3 | 17 | 0.85 | 121 | 14 | 109 | 0.8924825174825175 | 0.95
2009-05-01 00:00:00 | 8 |  | 0 | 8 | 1 | 103 | 12 | 93 | 0.9053030303030303 | 0.95
2009-06-01 00:00:00 | 8 |  | 2 | 6 | 0.75 | 89 | 12 | 80 | 0.8863636363636364 | 0.95
2009-07-01 00:00:00 | 5 |  | 0 | 5 | 1 | 74 | 9 | 67 | 0.903030303030303 | 0.95
2009-08-01 00:00:00 | 5 |  | 1 | 4 | 0.8 | 68 | 8 | 62 | 0.8999999999999999 | 0.95
2009-09-01 00:00:00 | 7 |  | 0 | 7 | 1 | 53 | 6 | 47 | 0.9 | 0.95
2009-10-01 00:00:00 | 10 |  | 0 | 10 | 1 | 43 | 6 | 40 | 0.9249999999999999 | 0.95
2009-11-01 00:00:00 | 14 |  | 5 | 9 | 0.6428571428571429 | 49 | 8 | 41 | 0.8654761904761905 | 0.95
2009-12-01 00:00:00 | 20 |  | 11 | 9 | 0.45 | 61 | 19 | 44 | 0.8154761904761906 | 0.95
2010-01-01 00:00:00 | 31 |  | 11 | 20 | 0.6451612903225806 | 87 | 28 | 59 | 0.7563364055299538 | 0.975
2010-02-01 00:00:00 |  |  |  | 0 | 0.8332731978697424 | 82 | 28 | 55 | 0.7618819385082443 | 0.975
2010-03-01 00:00:00 |  |  |  | 0 | 0.8332731978697425 | 75 | 27 | 48 | 0.7340941381532015 | 0.975
2010-04-01 00:00:00 |  |  |  | 0 | 0.8332731978697425 | 65 | 27 | 38 | 0.7063063377981585 | 0.975
2010-05-01 00:00:00 |  |  |  | 0 | 0.8332731978697426 | 51 | 27 | 29 | 0.7380423469669252 | 0.975
2010-06-01 00:00:00 |  |  |  | 0 | 0.8332731978697426 | 31 | 22 | 20 | 0.8019212132785488 | 0.975
2010-07-01 00:00:00 |  |  |  | 0 | 0.8332731978697426 | 0 | 11 | 0 | #N/A | 0.975
2010-08-01 00:00:00 |  |  |  | 0 | 0.8332731978697427 | 0 | 0 | 0 | #N/A | 0.975
2010-09-01 00:00:00 |  |  |  | 0 | 0.8332731978697427 | 0 | 0 | 0 | #N/A | 0.975
2010-10-01 00:00:00 |  |  |  | 0 | 0.8332731978697427 | 0 | 0 | 0 | #N/A | 0.975
2010-11-01 00:00:00 |  |  |  | 0 | 0.8332731978697429 | 0 | 0 | 0 | #N/A | 0.975
2010-12-01 00:00:00 |  |  |  | 0 | 0.8332731978697429 | 0 | 0 | 0 | #N/A | 0.975