Spreadsheet: 136957d1326898205-seperate-years-and-week-to-pivot-table-delivery-performance
Sheet: Data

 | Delivery Performance 2009/10
Year | Weeks | On Time 2004-2005 | On Time 2005-2006 | On Time 2006-2007 | On Time 2007-2008 | On Time 2008-2009 | On Time 2009-2010 | Mfg Date to X-off | On Time 2010-2011 | Target
2010 | Week 40 | 0.87 | 0.99 | 0.99 | 0.99 | 0.99 | 0.99 | 0.98 | 0.99 | 0.99 |  |  |  |  | Data
2010 | Week 41 | 0.87 | 0.98 | 0.99 | 0.97 | 1 | 0.99 | 0.96 | 0.99 | 0.99 |  |  | Year | Weeks | Mfg Date to X-off | On Time 2010-2011 | Target
2010 | Week 42 | 0.87 | 0.95 | 0.99 | 0.99 | 1 | 0.96 | 0.96 | 0.98 | 0.99 |  |  | 2011 | Week 50 | 0.99 | 1 | 0.99
2010 | Week 43 | 0.89 | 0.91 | 0.99 | 0.94 | 0.99 | 0.99 | 0.97 | 0.97 | 0.99 |  |  |  | Week 51 | 0.99 | 1 | 0.99
2010 | Week 44 | 0.89 | 0.9 | 0.99 | 0.96 | 0.99 | 0.98 | 0.95 | 1 | 0.99 |  |  |  | Week 52 |  |  | 0.99
2010 | Week 45 | 0.95 | 0.96 | 0.99 | 0.99 | 0.99 | 1 | 0.95 | 0.99 | 0.99 |  |  | 2012 | Week 50
2010 | Week 46 | 0.94 | 0.93 | 0.99 | 0.96 | 0.99 | 0.99 | 0.96 | 1 | 0.99 |  |  |  | Week 51
2010 | Week 47 | 0.92 | 0.97 | 0.99 | 0.96 | 1 | 1 | 0.96 | 1 | 0.99 |  |  |  | Week 52
2010 | Week 48 | 0.91 | 0.91 | 0.99 | 0.94 | 0.99 | 1 | 0.95 | 1 | 0.99 |  |  | Grand Total |  | 1.98 | 2 | 0.9899999999999999
2010 | Week 49 | 0.92 | 0.98 | 0.97 | 0.93 | 1 | 1 | 0.92 | 0.94 | 0.99
2010 | Week 50 | 0.94 | 0.92 | 0.98 | 0.99 | 0.99 | 0.99 | 0.94 | 0.99 | 0.99
2010 | Week 51 | 0.92 | 0.92 | 0.94 | 0.97 | 0.95 | 0.99 | 0.96 | 0.97 | 0.99
2011 | Week 1 | 0.98 | 0.88 | 0.98 | 0.94 | 1 | 1 | 0.9 | 0.98 | 0.99
2011 | Week 2 | 0.94 | 0.88 | 0.97 | 0.97 | 1 | 1 | 0.93 | 1 | 0.99
2011 | Week 3 | 0.91 | 0.9 | 0.92 | 0.98 | 0.99 | 1 | 0.94 | 0.99 | 0.99
2011 | Week 4 | 0.91 | 0.89 | 0.99 | 0.98 | 1 | 1 | 0.97 | 1 | 0.99
2011 | Week 5 | 0.89 | 0.92 | 0.96 | 0.97 | 0.98 | 0.99 | 0.99 | 1 | 0.99
2011 | Week 6 | 0.95 | 0.9 | 0.98 | 0.99 | 1 | 1 | 0.99 | 1 | 0.99
2011 | Week 7 | 0.91 | 0.94 | 0.98 | 0.98 | 0.98 | 0.96 | 1 | 1 | 0.99
2011 | Week 8 | 0.82 | 0.93 | 0.91 | 0.97 | 1 | 0.93 | 0.98 | 1 | 0.99
2011 | Week 9 | 0.87 | 0.93 | 0.97 | 0.93 | 0.96 | 0.98 | 0.99 | 1 | 0.99
2011 | Week 10 | 0.87 | 0.96 | 0.99 | 0.96 | 1 | 0.99 | 0.99 | 1 | 0.99
2011 | Week 11 | 0.84 | 0.97 | 0.96 | 0.97 | 0.99 | 1 | 0.98 | 1 | 0.99
2011 | Week 12 | 0.89 | 0.91 | 1 | 0.98 | 1 | 0.99 | 0.99 | 1 | 0.99
2011 | Week 13 | 0.83 | 0.99 | 0.98 | 0.92 | 1 | 0.99 | 0.99 | 1 | 0.99
2011 | Week 14 | 0.9 | 0.97 | 1 | 0.95 | 0.99 | 0.93 | 1 | 1 | 0.99
2011 | Week 15 | 0.86 | 0.99 | 0.97 | 1 | 0.99 | 0.94 | 0.99 | 1 | 0.99
2011 | Week 16 | 0.89 | 0.99 | 0.98 | 0.99 | 0.98 | 1 | 0.99 | 1 | 0.99
2011 | Week 17 | 0.81 | 0.97 | 0.92 | 0.97 | 0.97 | 0.98 | 0.97 | 1 | 0.99
2011 | Week 18 | 0.83 | 0.97 | 0.93 | 0.98 | 0.99 | 0.99 | 0.99 | 1 | 0.99
2011 | Week 19 | 0.77 | 0.97 | 0.94 | 0.94 | 1 | 0.99 | 0.98 | 1 | 0.99
2011 | Week 20 | 0.78 | 0.96 | 0.95 | 0.91 | 0.98 | 0.97 | 1 | 1 | 0.99
2011 | Week 21 | 0.9 | 0.9 | 0.97 | 1 | 1 | 0.98 | 0.97 | 1 | 0.99
2011 | Week 22 | 0.87 | 0.92 | 0.99 | 0.98 | 1 | 0.99 | 0.99 | 1 | 0.99
2011 | Week 23 | 0.87 | 0.93 | 0.89 | 0.99 | 1 | 1 | 0.98 | 1 | 0.99
2011 | Week 24 | 0.89 | 0.93 | 0.96 | 0.99 | 1 | 0.98 | 0.98 | 0.99 | 0.99
2011 | Week 25 | 0.94 | 0.97 | 0.97 | 0.96 | 0.99 | 0.97 | 0.98 | 0.99 | 0.99
2011 | Week 26 | 0.9 | 0.96 | 0.96 | 0.98 | 0.98 | 0.99 | 0.97 | 0.99 | 0.99
2011 | Week 27 | 0.94 | 0.93 | 0.94 | 0.99 | 1 | 0.99 | 0.98 | 1 | 0.99
2011 | Week 28 | 0.9 | 0.97 | 0.99 | 1 | 1 | 0.94 | 0.99 | 1 | 0.99
2011 | Week 29 | 0.92 | 0.97 | 0.99 | 1 | 1 | 0.96 | 0.9 | 0.98 | 0.99
2011 | Week 30 | 0.94 | 1 | 0.97 | 1 | 1 | 0.98 | 0.97 | 0.99 | 0.99
2011 | Week 31 | 0.92 | 0.99 | 0.97 | 0.99 | 1 | 0.99 | 0.99 | 1 | 0.99
2011 | Week 32 | 0.9 | 0.92 | 0.97 | 1 | 1 | 0.98 | 0.95 | 0.98 | 0.99
2011 | Week 33 | 0.96 | 0.98 | 0.95 | 1 | 0.99 | 1 | 0.98 | 1 | 0.99
2011 | Week 34 | 0.96 | 0.96 | 0.97 | 1 | 0.99 | 0.98 | 0.99 | 1 | 0.99
2011 | Week 35 | 0.94 | 0.94 | 0.97 | 0.99 | 1 | 0.99 | 0.99 | 1 | 0.99
2011 | Week 36 | 0.9 | 0.97 | 0.95 | 1 | 1 | 1 | 0.99 | 1 | 0.99
2011 | Week 37 | 0.95 | 0.98 | 1 | 1 | 1 | 1 | 0.99 | 1 | 0.99
2011 | Week 38 | 0.96 | 0.96 | 0.99 | 1 | 1 | 1 | 0.98 | 1 | 0.99
2011 | Week 39 | 0.97 | 0.99 | 0.97 | 1 | 0.99 | 0.98 | 0.97 | 0.99 | 0.99
2011 | Week 40 |  |  |  |  |  |  | 0.98 | 1 | 0.99
2011 | Week 41 |  |  |  |  |  |  | 0.98 | 1 | 0.99
2011 | Week 42 |  |  |  |  |  |  | 0.98 | 1 | 0.99
2011 | Week 43 |  |  |  |  |  |  | 0.96 | 0.97 | 0.99
2011 | Week 44 |  |  |  |  |  |  | 0.99 | 1 | 0.99
2011 | Week 45 |  |  |  |  |  |  | 0.99 | 1 | 0.99
2011 | Week 46 |  |  |  |  |  |  | 0.98 | 1 | 0.99
2011 | Week 47 |  |  |  |  |  |  | 0.99 | 1 | 0.99
2011 | Week 48 |  |  |  |  |  |  | 0.98 | 1 | 0.99
2011 | Week 49 |  |  |  |  |  |  | 0.99 | 1 | 0.99
2011 | Week 50 |  |  |  |  |  |  | 0.99 | 1 | 0.99
2011 | Week 51 |  |  |  |  |  |  | 0.99 | 1 | 0.99
2011 | Week 52 |  |  |  |  |  |  |  |  | 0.99
2012 | Week 1
2012 | Week 2
2012 | Week 3
2012 | Week 4
2012 | Week 5
2012 | Week 6
2012 | Week 7
2012 | Week 8
2012 | Week 9
2012 | Week 10
2012 | Week 11
2012 | Week 12
2012 | Week 13
2012 | Week 14
2012 | Week 15
2012 | Week 16
2012 | Week 17
2012 | Week 18
2012 | Week 19
2012 | Week 20
2012 | Week 21
2012 | Week 22
2012 | Week 23
2012 | Week 24
2012 | Week 25
2012 | Week 26
2012 | Week 27
2012 | Week 28
2012 | Week 29
2012 | Week 30
2012 | Week 31
2012 | Week 32
2012 | Week 33
2012 | Week 34
2012 | Week 35
2012 | Week 36
2012 | Week 37
2012 | Week 38
2012 | Week 39
2012 | Week 40
2012 | Week 41
2012 | Week 42
2012 | Week 43
2012 | Week 44
2012 | Week 45
2012 | Week 46
2012 | Week 47
2012 | Week 48
2012 | Week 49
2012 | Week 50
2012 | Week 51
2012 | Week 52
2013 | Week 1
2013 | Week 2
2013 | Week 3
2013 | Week 4
2013 | Week 5
2013 | Week 6
2013 | Week 7
2013 | Week 8
2013 | Week 9
2013 | Week 10