Spreadsheet: 136981d1326901613-seperate-years-and-week-to-pivot-table-delivery-performance-with-formula
Sheet: Data

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