Spreadsheet: 390945d1429808116-index-match-function-using-a-table-and-named-ranges-biv2
Sheet: Weekend

Year | Month | Field | [NAME] | Hours Used | Utilization %
2012 | January | Field 1 | 81 | 57 | 0.7037037037037037
2012 | January | Field 2 | 81 | 61 | 0.7530864197530864
2012 | January | Field 3 | 81 | 54 | 0.6666666666666666
2012 | January | Field 4 | 81 | 51 | 0.6296296296296297
2012 | January | Field 9 | 81 | 22 | 0.2716049382716049
2012 | January | Field 10 | 81 | 23.5 | 0.2901234567901235
2012 | January | Field 11 | 81 | 51 | 0.6296296296296297
2012 | February | Field 1 | 72 | 70 | 0.9722222222222222
2012 | February | Field 2 | 72 | 70 | 0.9722222222222222
2012 | February | Field 3 | 72 | 54 | 0.75
2012 | February | Field 4 | 72 | 54 | 0.75
2012 | February | Field 9 | 72 | 33 | 0.4583333333333333
2012 | February | Field 10 | 72 | 38 | 0.5277777777777778
2012 | February | Field 11 | 72 | 55 | 0.7638888888888888
2012 | March | Field 1 | 81 | 60 | 0.7407407407407407
2012 | March | Field 2 | 81 | 63 | 0.7777777777777778
2012 | March | Field 3 | 81 | 55 | 0.6790123456790124
2012 | March | Field 4 | 81 | 48 | 0.5925925925925926
2012 | March | Field 9 | 81 | 78 | 0.9629629629629629
2012 | March | Field 10 | 81 | 78 | 0.9629629629629629
2012 | March | Field 11 | 81 | 35.5 | 0.4382716049382716
2012 | April | Field 1 | 81 | 59.5 | 0.7345679012345679
2012 | April | Field 2 | 81 | 67.5 | 0.8333333333333334
2012 | April | Field 3 | 81 | 62.5 | 0.7716049382716049
2012 | April | Field 4 | 81 | 61.5 | 0.7592592592592593
2012 | April | Field 9 | 81 | 64.5 | 0.7962962962962963
2012 | April | Field 10 | 81 | 60 | 0.7407407407407407
2012 | April | Field 11 | 81 | 43.5 | 0.5370370370370371
2012 | May | Field 1 | 72 | 65 | 0.9027777777777778
2012 | May | Field 2 | 72 | 70 | 0.9722222222222222
2012 | May | Field 3 | 72 | 70 | 0.9722222222222222
2012 | May | Field 4 | 72 | 68 | 0.9444444444444444
2012 | May | Field 9 | 72 | 59.5 | 0.8263888888888888
2012 | May | Field 10 | 72 | 54.5 | 0.7569444444444444
2012 | May | Field 11 | 72 | 58 | 0.8055555555555556
2012 | June | Field 1 | 81 | 74 | 0.9135802469135802
2012 | June | Field 2 | 81 | 73.5 | 0.9074074074074074
2012 | June | Field 3 | 81 | 67 | 0.8271604938271605
2012 | June | Field 4 | 81 | 65.5 | 0.808641975308642
2012 | June | Field 9 | 81 | 37 | 0.4567901234567901
2012 | June | Field 10 | 81 | 35.5 | 0.4382716049382716
2012 | June | Field 11 | 81 | 52.5 | 0.6481481481481481
2012 | July | Field 1 | 81 | 59.5 | 0.7345679012345679
2012 | July | Field 2 | 81 | 55 | 0.6790123456790124
2012 | July | Field 3 | 81 | 55 | 0.6790123456790124
2012 | July | Field 4 | 81 | 55 | 0.6790123456790124
2012 | July | Field 9 | 81 | 27 | 0.3333333333333333
2012 | July | Field 10 | 81 | 27 | 0.3333333333333333
2012 | July | Field 11 | 81 | 41 | 0.5061728395061729
2012 | August | Field 1 | 72 | 63 | 0.875
2012 | August | Field 2 | 72 | 58 | 0.8055555555555556
2012 | August | Field 3 | 72 | 58 | 0.8055555555555556
2012 | August | Field 4 | 72 | 58 | 0.8055555555555556
2012 | August | Field 9 | 72 | 36 | 0.5
2012 | August | Field 10 | 72 | 36 | 0.5
2012 | August | Field 11 | 72 | 42 | 0.5833333333333334
2012 | September | Field 1 | 90 | 76.5 | 0.85
2012 | September | Field 2 | 90 | 80.5 | 0.8944444444444445
2012 | September | Field 3 | 90 | 60 | 0.6666666666666666
2012 | September | Field 4 | 90 | 61 | 0.6777777777777778
2012 | September | Field 9 | 90 | 86 | 0.9555555555555556
2012 | September | Field 10 | 90 | 82 | 0.9111111111111111
2012 | September | Field 11 | 90 | 44 | 0.4888888888888889
2012 | October | Field 1 | 72 | 61 | 0.8472222222222222
2012 | October | Field 2 | 72 | 61 | 0.8472222222222222
2012 | October | Field 3 | 72 | 56.5 | 0.7847222222222222
2012 | October | Field 4 | 72 | 44 | 0.6111111111111112
2012 | October | Field 9 | 72 | 68 | 0.9444444444444444
2012 | October | Field 10 | 72 | 65 | 0.9027777777777778
2012 | October | Field 11 | 72 | 42.5 | 0.5902777777777778
2012 | November | Field 1 | 72 | 64.5 | 0.8958333333333334
2012 | November | Field 2 | 72 | 60.5 | 0.8402777777777778
2012 | November | Field 3 | 72 | 56 | 0.7777777777777778
2012 | November | Field 4 | 72 | 55.5 | 0.7708333333333334
2012 | November | Field 9 | 72 | 59 | 0.8194444444444444
2012 | November | Field 10 | 72 | 53 | 0.7361111111111112
2012 | November | Field 11 | 72 | 51 | 0.7083333333333334
2012 | December | Field 1 | 90 | 59.5 | 0.6611111111111111
2012 | December | Field 2 | 90 | 52.5 | 0.5833333333333334
2012 | December | Field 3 | 90 | 48 | 0.5333333333333333
2012 | December | Field 4 | 90 | 46.5 | 0.5166666666666667
2012 | December | Field 9 | 90 | 30.5 | 0.3388888888888889
2012 | December | Field 10 | 90 | 23 | 0.2555555555555555
2012 | December | Field 11 | 90 | 46.5 | 0.5166666666666667
2013 | January | Field 1 | 72 | 70 | 0.9722222222222222
2013 | January | Field 2 | 72 | 67 | 0.9305555555555556
2013 | January | Field 3 | 72 | 54 | 0.75
2013 | January | Field 4 | 72 | 54 | 0.75
2013 | January | Field 9 | 72 | 55 | 0.7638888888888888
2013 | January | Field 10 | 72 | 34 | 0.4722222222222222
2013 | January | Field 11 | 72 | 54 | 0.75
2013 | February | Field 1 | 72 | 55 | 0.7638888888888888
2013 | February | Field 2 | 72 | 51.5 | 0.7152777777777778
2013 | February | Field 3 | 72 | 39.5 | 0.5486111111111112
2013 | February | Field 4 | 72 | 39 | 0.5416666666666666
2013 | February | Field 9 | 72 | 44.5 | 0.6180555555555556
2013 | February | Field 10 | 72 | 30 | 0.4166666666666667
2013 | February | Field 11 | 72 | 40 | 0.5555555555555556
2013 | March | Field 1 | 90 | 65.5 | 0.7277777777777777
2013 | March | Field 2 | 90 | 53 | 0.5888888888888889
2013 | March | Field 3 | 90 | 63.5 | 0.7055555555555556
2013 | March | Field 4 | 90 | 52 | 0.5777777777777777
2013 | March | Field 9 | 90 | 69 | 0.7666666666666667
2013 | March | Field 10 | 90 | 69 | 0.7666666666666667
2013 | March | Field 11 | 90 | 65 | 0.7222222222222222
2013 | April | Field 1 | 72 | 63.5 | 0.8819444444444444
2013 | April | Field 2 | 72 | 66.5 | 0.9236111111111112
2013 | April | Field 3 | 72 | 66 | 0.9166666666666666
2013 | April | Field 4 | 72 | 66 | 0.9166666666666666
2013 | April | Field 9 | 72 | 70 | 0.9722222222222222
2013 | April | Field 10 | 72 | 70 | 0.9722222222222222
2013 | April | Field 11 | 72 | 62.5 | 0.8680555555555556
2013 | May | Field 1 | 72 | 52 | 0.7222222222222222
2013 | May | Field 2 | 72 | 46.5 | 0.6458333333333334
2013 | May | Field 3 | 72 | 72 | 1
2013 | May | Field 4 | 72 | 72 | 1
2013 | May | Field 9 | 72 | 34 | 0.4722222222222222
2013 | May | Field 10 | 72 | 36 | 0.5
2013 | May | Field 11 | 72 | 40.5 | 0.5625
2013 | June | Field 1 | 90 | 82.5 | 0.9166666666666666
2013 | June | Field 2 | 90 | 71 | 0.7888888888888889
2013 | June | Field 3 | 90 | 81 | 0.9
2013 | June | Field 4 | 90 | 78 | 0.8666666666666667
2013 | June | Field 9 | 90 | 45.5 | 0.5055555555555555
2013 | June | Field 10 | 90 | 45.5 | 0.5055555555555555
2013 | June | Field 11 | 90 | 55.5 | 0.6166666666666667
2013 | July | Field 1 | 72 | 59 | 0.8194444444444444
2013 | July | Field 2 | 72 | 65 | 0.9027777777777778
2013 | July | Field 3 | 72 | 54 | 0.75
2013 | July | Field 4 | 72 | 45 | 0.625
2013 | July | Field 9 | 72 | 43 | 0.5972222222222222
2013 | July | Field 10 | 72 | 43 | 0.5972222222222222
2013 | July | Field 11 | 72 | 50 | 0.6944444444444444
2013 | August | Field 1 | 81 | 75 | 0.9259259259259259
2013 | August | Field 2 | 81 | 75 | 0.9259259259259259
2013 | August | Field 3 | 81 | 75 | 0.9259259259259259
2013 | August | Field 4 | 81 | 73 | 0.9012345679012346
2013 | August | Field 9 | 81 | 43 | 0.5308641975308642
2013 | August | Field 10 | 81 | 50 | 0.6172839506172839
2013 | August | Field 11 | 81 | 50 | 0.6172839506172839
2013 | September | Field 1 | 81 | 68.5 | 0.845679012345679
2013 | September | Field 2 | 81 | 72 | 0.8888888888888888
2013 | September | Field 3 | 81 | 67.5 | 0.8333333333333334
2013 | September | Field 4 | 81 | 53.5 | 0.6604938271604939
2013 | September | Field 9 | 81 | 77 | 0.9506172839506173
2013 | September | Field 10 | 81 | 73 | 0.9012345679012346
2013 | September | Field 11 | 81 | 37 | 0.4567901234567901
2013 | October | Field 1 | 72 | 58 | 0.8055555555555556
2013 | October | Field 2 | 72 | 64 | 0.8888888888888888
2013 | October | Field 3 | 72 | 63 | 0.875
2013 | October | Field 4 | 72 | 56 | 0.7777777777777778
2013 | October | Field 9 | 72 | 68 | 0.9444444444444444
2013 | October | Field 10 | 72 | 65 | 0.9027777777777778
2013 | October | Field 11 | 72 | 46 | 0.6388888888888888
2013 | November | Field 1 | 81 | 71 | 0.8765432098765432
2013 | November | Field 2 | 81 | 72.5 | 0.8950617283950617
2013 | November | Field 3 | 81 | 73 | 0.9012345679012346
2013 | November | Field 4 | 81 | 71.5 | 0.8827160493827161
2013 | November | Field 9 | 81 | 59 | 0.7283950617283951
2013 | November | Field 10 | 81 | 61.5 | 0.7592592592592593
2013 | November | Field 11 | 81 | 57.5 | 0.7098765432098766
2013 | December | Field 1 | 81 | 52 | 0.6419753086419753
2013 | December | Field 2 | 81 | 51.5 | 0.6358024691358025
2013 | December | Field 3 | 81 | 44 | 0.5432098765432098
2013 | December | Field 4 | 81 | 51 | 0.6296296296296297
2013 | December | Field 9 | 81 | 31.5 | 0.3888888888888889
2013 | December | Field 10 | 81 | 29.5 | 0.3641975308641975
2013 | December | Field 11 | 81 | 44.5 | 0.5493827160493827
2014 | January | Field 1 | 72 | 71 | 0.9861111111111112
2014 | January | Field 2 | 72 | 70.5 | 0.9791666666666666
2014 | January | Field 3 | 72 | 71 | 0.9861111111111112
2014 | January | Field 4 | 72 | 71 | 0.9861111111111112
2014 | January | Field 9 | 72 | 44.5 | 0.6180555555555556
2014 | January | Field 10 | 72 | 45.5 | 0.6319444444444444
2014 | January | Field 11 | 72 | 61.5 | 0.8541666666666666
2014 | February | Field 1 | 72 | 59.5 | 0.8263888888888888
2014 | February | Field 2 | 72 | 54.5 | 0.7569444444444444
2014 | February | Field 3 | 72 | 51.5 | 0.7152777777777778
2014 | February | Field 4 | 72 | 49 | 0.6805555555555556
2014 | February | Field 9 | 72 | 47 | 0.6527777777777778
2014 | February | Field 10 | 72 | 39 | 0.5416666666666666
2014 | February | Field 11 | 72 | 44 | 0.6111111111111112
2014 | March | Field 1 | 90 | 76 | 0.8444444444444444
2014 | March | Field 2 | 90 | 82 | 0.9111111111111111
2014 | March | Field 3 | 90 | 80.5 | 0.8944444444444445
2014 | March | Field 4 | 90 | 77.5 | 0.8611111111111112
2014 | March | Field 9 | 90 | 90 | 1
2014 | March | Field 10 | 90 | 90 | 1
2014 | March | Field 11 | 90 | 54.5 | 0.6055555555555555
2014 | April | Field 1 | 72 | 53 | 0.7361111111111112
2014 | April | Field 2 | 72 | 51.5 | 0.7152777777777778
2014 | April | Field 3 | 72 | 52 | 0.7222222222222222
2014 | April | Field 4 | 72 | 49 | 0.6805555555555556
2014 | April | Field 9 | 72 | 61 | 0.8472222222222222
2014 | April | Field 10 | 72 | 45 | 0.625
2014 | April | Field 11 | 72 | 38.5 | 0.5347222222222222
2014 | May | Field 1 | 81 | 74.5 | 0.9197530864197531
2014 | May | Field 2 | 81 | 55 | 0.6790123456790124
2014 | May | Field 3 | 81 | 47.5 | 0.5864197530864198
2014 | May | Field 4 | 81 | 44.5 | 0.5493827160493827
2014 | May | Field 9 | 81 | 25 | 0.308641975308642
2014 | May | Field 10 | 81 | 22 | 0.2716049382716049
2014 | May | Field 11 | 81 | 36 | 0.4444444444444444
2014 | June | Field 1 | 81 | 66 | 0.8148148148148148
2014 | June | Field 2 | 81 | 72.5 | 0.8950617283950617
2014 | June | Field 3 | 81 | 62 | 0.7654320987654321
2014 | June | Field 4 | 81 | 61.5 | 0.7592592592592593
2014 | June | Field 9 | 81 | 69.5 | 0.8580246913580247
2014 | June | Field 10 | 81 | 68 | 0.8395061728395061
2014 | June | Field 11 | 81 | 51 | 0.6296296296296297
2014 | July | Field 1 | 72 | 42.5 | 0.5902777777777778
2014 | July | Field 2 | 72 | 37.5 | 0.5208333333333334
2014 | July | Field 3 | 72 | 43 | 0.5972222222222222
2014 | July | Field 4 | 72 | 43 | 0.5972222222222222
2014 | July | Field 9 | 72 | 36 | 0.5
2014 | July | Field 10 | 72 | 36 | 0.5
2014 | July | Field 11 | 72 | 41 | 0.5694444444444444
2014 | August | Field 1 | 90 | 62.5 | 0.6944444444444444
2014 | August | Field 2 | 90 | 76 | 0.8444444444444444
2014 | August | Field 3 | 90 | 77 | 0.8555555555555555
2014 | August | Field 4 | 90 | 77 | 0.8555555555555555
2014 | August | Field 9 | 90 | 36 | 0.4
2014 | August | Field 10 | 90 | 36 | 0.4
2014 | August | Field 11 | 90 | 55.5 | 0.6166666666666667
2014 | September | Field 1 | 72 | 56 | 0.7777777777777778
2014 | September | Field 2 | 72 | 63 | 0.875
2014 | September | Field 3 | 72 | 42 | 0.5833333333333334
2014 | September | Field 4 | 72 | 36 | 0.5
2014 | September | Field 9 | 72 | 68 | 0.9444444444444444
2014 | September | Field 10 | 72 | 68 | 0.9444444444444444
2014 | September | Field 11 | 72 | 41.5 | 0.5763888888888888
2014 | October | Field 1 | 72 | 61.5 | 0.8541666666666666
2014 | October | Field 2 | 72 | 64.5 | 0.8958333333333334
2014 | October | Field 3 | 72 | 56.5 | 0.7847222222222222
2014 | October | Field 4 | 72 | 49.5 | 0.6875
2014 | October | Field 9 | 72 | 69 | 0.9583333333333334
2014 | October | Field 10 | 72 | 69 | 0.9583333333333334
2014 | October | Field 11 | 72 | 32.5 | 0.4513888888888889
2014 | November | Field 1 | 90 | 80.5 | 0.8944444444444445
2014 | November | Field 2 | 90 | 82 | 0.9111111111111111
2014 | November | Field 3 | 90 | 75 | 0.8333333333333334
2014 | November | Field 4 | 90 | 78 | 0.8666666666666667
2014 | November | Field 9 | 90 | 51 | 0.5666666666666667
2014 | November | Field 10 | 90 | 60 | 0.6666666666666666
2014 | November | Field 11 | 90 | 71.5 | 0.7944444444444444
2014 | December | Field 1 | 72 | 41 | 0.5694444444444444
2014 | December | Field 2 | 72 | 35 | 0.4861111111111111
2014 | December | Field 3 | 72 | 37.5 | 0.5208333333333334
2014 | December | Field 4 | 72 | 36 | 0.5
2014 | December | Field 9 | 72 | 28 | 0.3888888888888889
2014 | December | Field 10 | 72 | 22 | 0.3055555555555556
2014 | December | Field 11 | 72 | 32 | 0.4444444444444444