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

Year | Month | Field | [NAME] | Hrs Used | Utilization %
2012 | January | Field 1 | 99 | 71 | 0.7171717171717171
2012 | January | Field 2 | 99 | 40.25 | 0.4065656565656566
2012 | January | Field 3 | 99 | 84 | 0.8484848484848485
2012 | January | Field 4 | 99 | 82.5 | 0.8333333333333334
2012 | January | Field 9 | 99 | 37.5 | 0.3787878787878788
2012 | January | Field 10 | 99 | 43.5 | 0.4393939393939394
2012 | January | Field 11 | 99 | 66 | 0.6666666666666666
2012 | February | Field 1 | 94.5 | 77 | 0.8148148148148148
2012 | February | Field 2 | 94.5 | 31 | 0.328042328042328
2012 | February | Field 3 | 94.5 | 76.5 | 0.8095238095238095
2012 | February | Field 4 | 94.5 | 75.5 | 0.798941798941799
2012 | February | Field 9 | 94.5 | 42 | 0.4444444444444444
2012 | February | Field 10 | 94.5 | 48.5 | 0.5132275132275133
2012 | February | Field 11 | 94.5 | 46 | 0.4867724867724867
2012 | March | Field 1 | 99 | 84.5 | 0.8535353535353535
2012 | March | Field 2 | 99 | 87.75 | 0.8863636363636364
2012 | March | Field 3 | 99 | 81 | 0.8181818181818182
2012 | March | Field 4 | 99 | 74.5 | 0.7525252525252525
2012 | March | Field 9 | 99 | 65.5 | 0.6616161616161617
2012 | March | Field 10 | 99 | 68 | 0.6868686868686869
2012 | March | Field 11 | 99 | 75.5 | 0.7626262626262627
2012 | April | Field 1 | 94.5 | 89.5 | 0.9470899470899471
2012 | April | Field 2 | 94.5 | 78 | 0.8253968253968254
2012 | April | Field 3 | 94.5 | 71 | 0.7513227513227513
2012 | April | Field 4 | 94.5 | 69 | 0.7301587301587301
2012 | April | Field 9 | 94.5 | 53.5 | 0.5661375661375662
2012 | April | Field 10 | 94.5 | 43.5 | 0.4603174603174603
2012 | April | Field 11 | 94.5 | 69 | 0.7301587301587301
2012 | May | Field 1 | 103.5 | 68.5 | 0.6618357487922706
2012 | May | Field 2 | 103.5 | 77 | 0.7439613526570048
2012 | May | Field 3 | 103.5 | 88 | 0.8502415458937198
2012 | May | Field 4 | 103.5 | 71.5 | 0.6908212560386473
2012 | May | Field 9 | 103.5 | 21.5 | 0.2077294685990338
2012 | May | Field 10 | 103.5 | 35.5 | 0.3429951690821256
2012 | May | Field 11 | 103.5 | 68.5 | 0.6618357487922706
2012 | June | Field 1 | 94.5 | 78 | 0.8253968253968254
2012 | June | Field 2 | 94.5 | 68.5 | 0.7248677248677249
2012 | June | Field 3 | 94.5 | 84.5 | 0.8941798941798942
2012 | June | Field 4 | 94.5 | 79 | 0.8359788359788359
2012 | June | Field 9 | 94.5 | 68 | 0.7195767195767195
2012 | June | Field 10 | 94.5 | 58 | 0.6137566137566137
2012 | June | Field 11 | 94.5 | 71.5 | 0.7566137566137566
2012 | July | Field 1 | 99 | 65.5 | 0.6616161616161617
2012 | July | Field 2 | 99 | 67 | 0.6767676767676768
2012 | July | Field 3 | 99 | 67 | 0.6767676767676768
2012 | July | Field 4 | 99 | 66.5 | 0.6717171717171717
2012 | July | Field 9 | 99 | 61.5 | 0.6212121212121212
2012 | July | Field 10 | 99 | 46 | 0.4646464646464646
2012 | July | Field 11 | 99 | 50.5 | 0.51010101010101
2012 | August | Field 1 | 103.5 | 71 | 0.6859903381642513
2012 | August | Field 2 | 103.5 | 72.5 | 0.7004830917874396
2012 | August | Field 3 | 103.5 | 88.5 | 0.855072463768116
2012 | August | Field 4 | 103.5 | 91 | 0.8792270531400966
2012 | August | Field 9 | 103.5 | 75 | 0.7246376811594203
2012 | August | Field 10 | 103.5 | 57 | 0.5507246376811594
2012 | August | Field 11 | 103.5 | 57 | 0.5507246376811594
2012 | September | Field 1 | 90 | 69 | 0.7666666666666667
2012 | September | Field 2 | 90 | 78 | 0.8666666666666667
2012 | September | Field 3 | 90 | 70.5 | 0.7833333333333333
2012 | September | Field 4 | 90 | 72.5 | 0.8055555555555556
2012 | September | Field 9 | 90 | 66 | 0.7333333333333333
2012 | September | Field 10 | 90 | 56 | 0.6222222222222222
2012 | September | Field 11 | 90 | 68.5 | 0.7611111111111111
2012 | October | Field 1 | 103.5 | 83 | 0.8019323671497585
2012 | October | Field 2 | 103.5 | 93 | 0.8985507246376812
2012 | October | Field 3 | 103.5 | 90 | 0.8695652173913043
2012 | October | Field 4 | 103.5 | 79 | 0.7632850241545893
2012 | October | Field 9 | 103.5 | 81 | 0.782608695652174
2012 | October | Field 10 | 103.5 | 77 | 0.7439613526570048
2012 | October | Field 11 | 103.5 | 83 | 0.8019323671497585
2012 | November | Field 1 | 99 | 73.5 | 0.7424242424242424
2012 | November | Field 2 | 99 | 83 | 0.8383838383838383
2012 | November | Field 3 | 99 | 76 | 0.7676767676767676
2012 | November | Field 4 | 99 | 68 | 0.6868686868686869
2012 | November | Field 9 | 99 | 73.5 | 0.7424242424242424
2012 | November | Field 10 | 99 | 70.5 | 0.7121212121212122
2012 | November | Field 11 | 99 | 78 | 0.7878787878787878
2012 | December | Field 1 | 94.5 | 29 | 0.3068783068783069
2012 | December | Field 2 | 94.5 | 39.5 | 0.417989417989418
2012 | December | Field 3 | 94.5 | 45 | 0.4761904761904762
2012 | December | Field 4 | 94.5 | 36 | 0.3809523809523809
2012 | December | Field 9 | 94.5 | 48 | 0.5079365079365079
2012 | December | Field 10 | 94.5 | 43.5 | 0.4603174603174603
2012 | December | Field 11 | 94.5 | 40.5 | 0.4285714285714285
2013 | January | Field 1 | 103.5 | 49.5 | 0.4782608695652174
2013 | January | Field 2 | 103.5 | 76 | 0.7342995169082126
2013 | January | Field 3 | 103.5 | 79.5 | 0.7681159420289855
2013 | January | Field 4 | 103.5 | 80 | 0.7729468599033816
2013 | January | Field 9 | 103.5 | 61 | 0.5893719806763285
2013 | January | Field 10 | 103.5 | 56 | 0.5410628019323671
2013 | January | Field 11 | 103.5 | 58 | 0.5603864734299517
2013 | February | Field 1 | 90 | 67 | 0.7444444444444445
2013 | February | Field 2 | 90 | 79.5 | 0.8833333333333333
2013 | February | Field 3 | 90 | 70.5 | 0.7833333333333333
2013 | February | Field 4 | 90 | 78 | 0.8666666666666667
2013 | February | Field 9 | 90 | 63 | 0.7
2013 | February | Field 10 | 90 | 59.5 | 0.6611111111111111
2013 | February | Field 11 | 90 | 65.5 | 0.7277777777777777
2013 | March | Field 1 | 94.5 | 75.25 | 0.7962962962962963
2013 | March | Field 2 | 94.5 | 80.5 | 0.8518518518518519
2013 | March | Field 3 | 94.5 | 77 | 0.8148148148148148
2013 | March | Field 4 | 94.5 | 74 | 0.783068783068783
2013 | March | Field 9 | 94.5 | 67.5 | 0.7142857142857143
2013 | March | Field 10 | 94.5 | 74 | 0.783068783068783
2013 | March | Field 11 | 94.5 | 72 | 0.7619047619047619
2013 | 2013-04-30 00:00:00 | Field 1 | 99 | 88 | 0.8888888888888888
2013 | 2013-04-30 00:00:00 | Field 2 | 99 | 93 | 0.9393939393939394
2013 | 2013-04-30 00:00:00 | Field 3 | 99 | 86.5 | 0.8737373737373737
2013 | 2013-04-30 00:00:00 | Field 4 | 99 | 79.5 | 0.803030303030303
2013 | 2013-04-30 00:00:00 | Field 9 | 99 | 85 | 0.8585858585858586
2013 | 2013-04-30 00:00:00 | Field 10 | 99 | 84.5 | 0.8535353535353535
2013 | 2013-04-30 00:00:00 | Field 11 | 99 | 77 | 0.7777777777777778
2013 | 2013-05-30 00:00:00 | Field 1 | 103.5 | 93.5 | 0.9033816425120773
2013 | 2013-05-30 00:00:00 | Field 2 | 103.5 | 90 | 0.8695652173913043
2013 | 2013-05-30 00:00:00 | Field 3 | 103.5 | 101 | 0.9758454106280193
2013 | 2013-05-30 00:00:00 | Field 4 | 103.5 | 93.5 | 0.9033816425120773
2013 | 2013-05-30 00:00:00 | Field 9 | 103.5 | 73 | 0.7053140096618358
2013 | 2013-05-30 00:00:00 | Field 10 | 103.5 | 67.5 | 0.6521739130434783
2013 | 2013-05-30 00:00:00 | Field 11 | 103.5 | 86.5 | 0.8357487922705314
2013 | 2013-06-30 00:00:00 | Field 1 | 90 | 63.5 | 0.7055555555555556
2013 | 2013-06-30 00:00:00 | Field 2 | 90 | 80 | 0.8888888888888888
2013 | 2013-06-30 00:00:00 | Field 3 | 90 | 78.5 | 0.8722222222222222
2013 | 2013-06-30 00:00:00 | Field 4 | 90 | 78.5 | 0.8722222222222222
2013 | 2013-06-30 00:00:00 | Field 9 | 90 | 58.5 | 0.65
2013 | 2013-06-30 00:00:00 | Field 10 | 90 | 66 | 0.7333333333333333
2013 | 2013-06-30 00:00:00 | Field 11 | 90 | 73.5 | 0.8166666666666667
2013 | 2013-07-31 00:00:00 | Field 1 | 103.5 | 58.5 | 0.5652173913043478
2013 | 2013-07-31 00:00:00 | Field 2 | 103.5 | 85 | 0.821256038647343
2013 | 2013-07-31 00:00:00 | Field 3 | 103.5 | 81 | 0.782608695652174
2013 | 2013-07-31 00:00:00 | Field 4 | 103.5 | 82.5 | 0.7971014492753623
2013 | 2013-07-31 00:00:00 | Field 9 | 103.5 | 67.5 | 0.6521739130434783
2013 | 2013-07-31 00:00:00 | Field 10 | 103.5 | 69 | 0.6666666666666666
2013 | 2013-07-31 00:00:00 | Field 11 | 103.5 | 60 | 0.5797101449275363
2013 | 2013-08-30 00:00:00 | Field 1 | 99 | 71 | 0.6859903381642513
2013 | 2013-08-30 00:00:00 | Field 2 | 99 | 72.5 | 0.7004830917874396
2013 | 2013-08-30 00:00:00 | Field 3 | 99 | 88.5 | 0.855072463768116
2013 | 2013-08-30 00:00:00 | Field 4 | 99 | 91 | 0.8792270531400966
2013 | 2013-08-30 00:00:00 | Field 9 | 99 | 75 | 0.7246376811594203
2013 | 2013-08-30 00:00:00 | Field 10 | 99 | 57 | 0.5507246376811594
2013 | 2013-08-30 00:00:00 | Field 11 | 99 | 57 | 0.5507246376811594
2013 | 2013-09-30 00:00:00 | Field 1 | 94.5 | 69 | 0.7666666666666667
2013 | 2013-09-30 00:00:00 | Field 2 | 94.5 | 78 | 0.8666666666666667
2013 | 2013-09-30 00:00:00 | Field 3 | 94.5 | 70.5 | 0.7833333333333333
2013 | 2013-09-30 00:00:00 | Field 4 | 94.5 | 72.5 | 0.8055555555555556
2013 | 2013-09-30 00:00:00 | Field 9 | 94.5 | 66 | 0.7333333333333333
2013 | 2013-09-30 00:00:00 | Field 10 | 94.5 | 56 | 0.6222222222222222
2013 | 2013-09-30 00:00:00 | Field 11 | 94.5 | 68.5 | 0.7611111111111111
2013 | 2013-10-30 00:00:00 | Field 1 | 103.5 | 83 | 0.8019323671497585
2013 | 2013-10-30 00:00:00 | Field 2 | 103.5 | 93 | 0.8985507246376812
2013 | 2013-10-30 00:00:00 | Field 3 | 103.5 | 90 | 0.8695652173913043
2013 | 2013-10-30 00:00:00 | Field 4 | 103.5 | 79 | 0.7632850241545893
2013 | 2013-10-30 00:00:00 | Field 9 | 103.5 | 81 | 0.782608695652174
2013 | 2013-10-30 00:00:00 | Field 10 | 103.5 | 77 | 0.7439613526570048
2013 | 2013-10-30 00:00:00 | Field 11 | 103.5 | 83 | 0.8019323671497585
2013 | 2013-11-30 00:00:00 | Field 1 | 94.5 | 73.5 | 0.7424242424242424
2013 | 2013-11-30 00:00:00 | Field 2 | 94.5 | 83 | 0.8383838383838383
2013 | 2013-11-30 00:00:00 | Field 3 | 94.5 | 76 | 0.7676767676767676
2013 | 2013-11-30 00:00:00 | Field 4 | 94.5 | 68 | 0.6868686868686869
2013 | 2013-11-30 00:00:00 | Field 9 | 94.5 | 73.5 | 0.7424242424242424
2013 | 2013-11-30 00:00:00 | Field 10 | 94.5 | 70.5 | 0.7121212121212122
2013 | 2013-11-30 00:00:00 | Field 11 | 94.5 | 78 | 0.7878787878787878
2013 | 2013-12-31 00:00:00 | Field 1 | 99 | 29 | 0.3068783068783069
2013 | 2013-12-31 00:00:00 | Field 2 | 99 | 39.5 | 0.417989417989418
2013 | 2013-12-31 00:00:00 | Field 3 | 99 | 45 | 0.4761904761904762
2013 | 2013-12-31 00:00:00 | Field 4 | 99 | 36 | 0.3809523809523809
2013 | 2013-12-31 00:00:00 | Field 9 | 99 | 48 | 0.5079365079365079
2013 | 2013-12-31 00:00:00 | Field 10 | 99 | 43.5 | 0.4603174603174603
2013 | 2013-12-31 00:00:00 | Field 11 | 99 | 40.5 | 0.4285714285714285
2014 | January | Field 1 | 103.5 | 72 | 0.6956521739130435
2014 | January | Field 2 | 103.5 | 81 | 0.782608695652174
2014 | January | Field 3 | 103.5 | 90 | 0.8695652173913043
2014 | January | Field 4 | 103.5 | 88 | 0.8502415458937198
2014 | January | Field 9 | 103.5 | 78.5 | 0.7584541062801933
2014 | January | Field 10 | 103.5 | 61.5 | 0.5942028985507246
2014 | January | Field 11 | 103.5 | 75 | 0.7246376811594203
2014 | February | Field 1 | 90 | 60 | 0.6666666666666666
2014 | February | Field 2 | 90 | 72 | 0.8
2014 | February | Field 3 | 90 | 76.5 | 0.85
2014 | February | Field 4 | 90 | 73.5 | 0.8166666666666667
2014 | February | Field 9 | 90 | 71.5 | 0.7944444444444444
2014 | February | Field 10 | 90 | 53.5 | 0.5944444444444444
2014 | February | Field 11 | 90 | 58 | 0.6444444444444445
2014 | March | Field 1 | 94.5 | 79 | 0.8359788359788359
2014 | March | Field 2 | 94.5 | 76.5 | 0.8095238095238095
2014 | March | Field 3 | 94.5 | 68.5 | 0.7248677248677249
2014 | March | Field 4 | 94.5 | 69.5 | 0.7354497354497355
2014 | March | Field 9 | 94.5 | 70 | 0.7407407407407407
2014 | March | Field 10 | 94.5 | 75 | 0.7936507936507936
2014 | March | Field 11 | 94.5 | 75 | 0.7936507936507936
2014 | April | Field 1 | 99 | 94 | 0.9494949494949495
2014 | April | Field 2 | 99 | 85.5 | 0.8636363636363636
2014 | April | Field 3 | 99 | 83.5 | 0.8434343434343434
2014 | April | Field 4 | 99 | 92 | 0.9292929292929293
2014 | April | Field 9 | 99 | 84 | 0.8484848484848485
2014 | April | Field 10 | 99 | 79 | 0.797979797979798
2014 | April | Field 11 | 99 | 90 | 0.9090909090909091
2014 | May | Field 1 | 99 | 82.5 | 0.8333333333333334
2014 | May | Field 2 | 99 | 73.5 | 0.7424242424242424
2014 | May | Field 3 | 99 | 83 | 0.8383838383838383
2014 | May | Field 4 | 99 | 86 | 0.8686868686868687
2014 | May | Field 9 | 99 | 68 | 0.6868686868686869
2014 | May | Field 10 | 99 | 62 | 0.6262626262626263
2014 | May | Field 11 | 99 | 69 | 0.696969696969697
2014 | June | Field 1 | 94.5 | 73 | 0.7724867724867724
2014 | June | Field 2 | 94.5 | 68.5 | 0.7248677248677249
2014 | June | Field 3 | 94.5 | 74.5 | 0.7883597883597884
2014 | June | Field 4 | 94.5 | 74.5 | 0.7883597883597884
2014 | June | Field 9 | 94.5 | 51 | 0.5396825396825397
2014 | June | Field 10 | 94.5 | 56.5 | 0.5978835978835979
2014 | June | Field 11 | 94.5 | 68 | 0.7195767195767195
2014 | July | Field 1 | 103.5 | 78.5 | 0.7584541062801933
2014 | July | Field 2 | 103.5 | 76.5 | 0.7391304347826086
2014 | July | Field 3 | 103.5 | 82.5 | 0.7971014492753623
2014 | July | Field 4 | 103.5 | 70.5 | 0.6811594202898551
2014 | July | Field 9 | 103.5 | 63.25 | 0.6111111111111112
2014 | July | Field 10 | 103.5 | 66.5 | 0.642512077294686
2014 | July | Field 11 | 103.5 | 52.5 | 0.5072463768115942
2014 | August | Field 1 | 94.5 | 83 | 0.8783068783068783
2014 | August | Field 2 | 94.5 | 76.5 | 0.8095238095238095
2014 | August | Field 3 | 94.5 | 66.5 | 0.7037037037037037
2014 | August | Field 4 | 94.5 | 60 | 0.6349206349206349
2014 | August | Field 9 | 94.5 | 63.5 | 0.671957671957672
2014 | August | Field 10 | 94.5 | 67 | 0.708994708994709
2014 | August | Field 11 | 94.5 | 59.5 | 0.6296296296296297
2014 | September | Field 1 | 99 | 80 | 0.8080808080808081
2014 | September | Field 2 | 99 | 76.5 | 0.7727272727272727
2014 | September | Field 3 | 99 | 87.5 | 0.8838383838383839
2014 | September | Field 4 | 99 | 90.5 | 0.9141414141414141
2014 | September | Field 9 | 99 | 77 | 0.7777777777777778
2014 | September | Field 10 | 99 | 83 | 0.8383838383838383
2014 | September | Field 11 | 99 | 95 | 0.9595959595959596
2014 | October | Field 1 | 103.5 | 97.5 | 0.9420289855072463
2014 | October | Field 2 | 103.5 | 89.5 | 0.8647342995169082
2014 | October | Field 3 | 103.5 | 96 | 0.927536231884058
2014 | October | Field 4 | 103.5 | 87.5 | 0.8454106280193237
2014 | October | Field 9 | 103.5 | 94.5 | 0.9130434782608695
2014 | October | Field 10 | 103.5 | 90 | 0.8695652173913043
2014 | October | Field 11 | 103.5 | 82.5 | 0.7971014492753623
2014 | November | Field 1 | 90 | 74 | 0.8222222222222222
2014 | November | Field 2 | 90 | 70.5 | 0.7833333333333333
2014 | November | Field 3 | 90 | 68.5 | 0.7611111111111111
2014 | November | Field 4 | 90 | 74.5 | 0.8277777777777777
2014 | November | Field 9 | 90 | 64.5 | 0.7166666666666667
2014 | November | Field 10 | 90 | 67.5 | 0.75
2014 | November | Field 11 | 90 | 66 | 0.7333333333333333
2014 | December | Field 1 | 103.5 | 62.5 | 0.6038647342995169
2014 | December | Field 2 | 103.5 | 60 | 0.5797101449275363
2014 | December | Field 3 | 103.5 | 59.5 | 0.5748792270531401
2014 | December | Field 4 | 103.5 | 61 | 0.5893719806763285
2014 | December | Field 9 | 103.5 | 49 | 0.4734299516908212
2014 | December | Field 10 | 103.5 | 56 | 0.5410628019323671
2014 | December | Field 11 | 103.5 | 48 | 0.463768115942029