Spreadsheet: 140344d1328713721-dashboard-pivot-table-dashboard-report-v1
Sheet: Pivot Data

A |  |  |  |  |  |  | B |  |  |  |  |  |  | C |  |  |  |  |  |  | D |  |  |  |  |  |  | E |  |  |  |  |  |  | F |  |  |  |  |  |  | G |  |  |  |  |  |  | H |  |  |  |  |  |  | I |  |  |  |  |  |  | J |  |  |  |  |  |  | K
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overall Results
 |  | Data |  |  |  |  |  |  | Data |  |  |  |  |  |  | Data |  |  |  |  |  |  | Data |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data |  |  |  |  |  |  | Data
Year | Month | Sum of quality master pass rate | Average of Pass rate Target | Sum of PASSED | Sum of FAILED |  | Year | Month | Sum of Pass Rate % | Sum of Target for pass rate | Sum of PASSED | Sum of FAILED |  | Year | Month | Monthly Pass Rate | Target | Sum of PASSED | Sum of FAILED |  | Year | Month | Monthly Characterisation Pass Rate | Target | Sum of PASSED | Sum of FAILED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year | Month | [NAME] | Target | Sum of PASSED | Sum of FAILED |  | Year | Month | Host test pass rate | Target | Sum of PASSED | Sum of FAILED |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year | Month | Passed | Failed
2011 | Jan | 97.33636175924013 | 97.40000000000002 | 14142 | 387 |  | 2011 | Jan | 99.8076923076923 | 98 | 10013 | 136 |  | 2011 | Jan | 97.5789905621666 | 98 | 2378 | 59 |  | 2011 | Jan | 89.65330444203684 | 98 | 1655 | 191 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 | Jan | 97.96420391890746 | 98 | 909 | 24 |  | 2011 | Jan | 99.88839285714286 | 99.1 | 895 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 | Jan
 | Feb | 97.83155423908791 | 97.40000000000002 | 17505 | 388 |  |  | Feb | 99.48186528497409 | 98 | 12748 | 93 |  |  | Feb | 96.9807391983342 | 98 | 1863 | 58 |  |  | Feb | 95.95346484572585 | 98 | 1897 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb | 99.23159674197018 | 98 | 1474 | 10 |  |  | July | 99.85422740524781 | 99.65000000000002 | 2055 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 | Feb
 | Mar | 96.93609571053399 | 97.40000000000003 | 16610 | 525 |  |  | Mar | 99.70501474926253 | 98 | 13947 | 103 |  |  | Mar | 96.57372400756144 | 98 | 4087 | 145 |  |  | Mar | 92.48224151539068 | 98 | 4687 | 381 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar | 99.92418498862774 | 98 | 1318 | 1 |  |  | Feb | 99.80719794344473 | 99.09999999999998 | 1553 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 | Mar
 | Apr | 98.14118842051803 | 97.40000000000002 | 9662 | 183 |  |  | Apr | 99.71671388101983 | 98 | 14109 | 48 |  |  | Apr | 98.2561826252378 | 98 | 3099 | 55 |  |  | Apr | 91.74556213017752 | 98 | 3101 | 279 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr | 99.81308411214954 | 98 | 534 | 1 |  |  | Mar | 99.86357435197817 | 99.09999999999998 | 1464 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 | Apr
 | May | 97.81512605042016 | 97.4 | 4656 | 104 |  |  | May | 100 | 98 | 14168 | 114 |  |  | May | 97.8898426323319 | 98 | 2737 | 59 |  |  | May | 88.87253458934354 | 98 | 3019 | 378 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May | 99.81549815498155 | 98 | 1082 | 2 |  |  | Apr | 99.63636363636364 | 99.10000000000001 | 548 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 | May
 | Jun | 98.18601583113457 | 97.40000000000002 | 5954 | 110 |  |  | Jun | 99.82014388489209 | 98 | 16010 | 127 |  |  | Jun | 97.60850310008857 | 98 | 3306 | 81 |  |  | Jun | 90.92115741969737 | 98 | 3438 | 342 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun | 99.90749306197965 | 98 | 1080 | 1 |  |  | May | 99.90749306197965 | 99.65 | 1080 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 | Jun
 | July | 98.28420082911101 | 97.40000000000002 | 8535 | 149 |  |  | July | 98.67768595041322 | 98 | 16129 | 135 |  |  | July | 96.73083908463494 | 98 | 2663 | 90 |  |  | July | 94.07753050969131 | 98 | 2621 | 165 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July | 99.8984771573604 | 98 | 1968 | 2 |  |  | Jun | 99.81325863678805 | 99.65000000000002 | 1069 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 | Jul
 | Aug | 98.43532684283727 | 97.40000000000003 | 8493 | 135 |  |  | Aug | 96.4131994261119 | 98 | 15944 | 145 |  |  | Aug | 98.23430493273543 | 98 | 3505 | 63 |  |  | Aug | 94.22246220302375 | 98 | 3490 | 214 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug | 99.66821499668215 | 98 | 3004 | 10 |  |  | Aug | 99.90173599737963 | 99.65000000000002 | 3050 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 | Aug
 | Sep | 98.24061662198392 | 97.40000000000002 | 5863 | 105 |  |  | Sep | 95.4968944099379 | 98 | 15873 | 49 |  |  | Sep | 97.83595113438045 | 98 | 2803 | 62 |  |  | Sep | 94.0526486837829 | 98 | 2894 | 183 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep | 99.83844911147011 | 98 | 1854 | 3 |  |  | Sep | 99.84334203655352 | 99.65000000000002 | 1912 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 | Sep
 | Oct | 98.51395066720582 | 97.40000000000002 | 9745 | 147 |  |  | Oct | 98.29683698296837 | 98 | 10230 | 94 |  |  | Oct | 97.6328903654485 | 98 | 2351 | 57 |  |  | Oct | 94.80642115203021 | 98 | 2008 | 110 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct | 99.75165562913908 | 98 | 1205 | 3 |  |  | Oct | 100 | 99.65000000000002 | 1244 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 | Oct
 | Nov | 98.56525763653194 | 97.40000000000003 | 6389 | 93 |  |  | Nov | 96.49923896499239 | 98 | 13320 | 170 |  |  | Nov | 98.46678023850085 | 98 | 3468 | 54 |  |  | Nov | 94.16311300639659 | 98 | 3533 | 219 |  |  |  | Data |  |  |  |  |  |  | Data |  |  |  |  |  | Nov | 99.66405375139978 | 98 | 1780 | 6 |  |  | Nov | 99.77900552486187 | 99.65000000000003 | 1806 | 4 |  |  |  | Data |  |  |  |  |  |  | Data |  |  |  | 2011 | Nov
 | Dec | 98.47110650427572 | 97.4 | 3800 | 59 |  |  | Dec | 97.65807962529274 | 98 | 6948 | 61 |  |  | Dec | 97.94180269694819 | 98 | 1380 | 29 |  |  | Dec | 94.62151394422311 | 98 | 1425 | 81 |  | Year | Month | Setup Test Montly Pass Rate | Target | Sum of PASSED | Sum of FAILED |  | Year | Month | Coin Handle Pass Rate | Target | Sum of PASSED | Sum of FAILED |  |  | Dec | 99.80327868852459 | 98 | 1522 | 3 |  |  | Dec | 100 | 99.64999999999999 | 1572 | 0 |  | Year | Month | Build Line Test Pass Rate | Target | Sum of PASSED | Sum of FAILED |  | Year | Month | Characterise Pass Rate | Target | Sum of PASSED | Sum of FAILED | 2011 | Dec
2012 | Jan | 97.9612511080157 | 97.40000000000002 | 7736 | 161 |  | 2012 | Jan | 99.32998324958123 | 98 | 11129 | 103 |  | 2012 | Jan | 98.74703691161531 | 98 | 2916 | 37 |  | 2012 | Jan | 93.81570810142239 | 98 | 3034 | 200 |  | 2012 | Jan | 96.93069306930693 | 98 | 979 | 31 |  | 2012 | Jan | 100 | 98 | 949 | 0 |  | 2012 | Jan | 99.84520123839009 | 98 | 1290 | 2 |  | 2012 | Jan | 100 | 99.65000000000002 | 1212 | 0 |  | 2012 | Jan | 96.79266895761741 | 98 | 845 | 28 |  | 2012 | Jan | 84.80635551142007 | 98 | 854 | 153 | 2012 | Jan
 | Feb | 97.13740458015268 | 97.4 | 1018 | 30 |  |  | Feb | 99.2248062015504 | 98 | 3045 | 9 |  |  | Feb | 98.41628959276018 | 98 | 435 | 7 |  |  | Feb | 95.71150097465888 | 98 | 491 | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb | 100 | 98 | 170 | 0 |  |  | Feb | 100 | 99.65 | 170 | 0 |  |  | Feb | 97.33727810650888 | 98 | 329 | 9 |  |  | Feb | 96.10983981693364 | 98 | 420 | 17 | 2012 | Feb
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar | 100 | 98 | 90 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | Mar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | Apr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | Jun
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | Jul
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | Aug
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | Sep
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | Oct
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | Nov
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | Dec