Spreadsheet: 356141d1415005463-average-with-criteria-average
Sheet: Resource Loading Chart

 | Resource Loading Chart  How busy are people each week-based on 5 day week?
 | Team Member | Week
 |  | 2014-10-27 00:00:00 | 2014-11-03 00:00:00 | 2014-11-10 00:00:00 | 2014-11-17 00:00:00 | 2014-11-24 00:00:00 | 2014-12-01 00:00:00 | 2014-12-08 00:00:00 | 2014-12-15 00:00:00 | 2014-12-22 00:00:00 | 2014-12-29 00:00:00 | 2015-01-05 00:00:00 | 2015-01-12 00:00:00 | 2015-01-19 00:00:00 | 2015-01-26 00:00:00 | 2015-02-02 00:00:00 | 2015-02-09 00:00:00 | 2015-02-16 00:00:00 | 2015-02-23 00:00:00 | 2015-03-02 00:00:00 | 2015-03-09 00:00:00 | 2015-03-16 00:00:00 | 2015-03-23 00:00:00 | 2015-03-30 00:00:00 | 2015-04-06 00:00:00 | 2015-04-13 00:00:00 | 2015-04-20 00:00:00 | 2015-04-27 00:00:00 | 2015-05-04 00:00:00 | 2015-05-11 00:00:00 | 2015-05-18 00:00:00 | 2015-05-25 00:00:00 | 2015-06-01 00:00:00 | 2015-06-08 00:00:00 | 2015-06-15 00:00:00 | 2015-06-22 00:00:00 | 2015-06-29 00:00:00
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36
 | Person 1 | 5.55 | 5.716666666666667 | 6.716666666666667 | 7.216666666666667 | 7.216666666666667 | 4.716666666666667 | 4.716666666666667 | 4.716666666666667 | 4.716666666666667 | 4.716666666666667 | 6.916666666666667 | 7.916666666666667 | 7.916666666666667 | 7.916666666666667 | 5 | 5 | 5 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Person 2 | 4.999999999999999 | 6.524999999999999 | 6.524999999999999 | 6.024999999999999 | 5.024999999999999 | 5.524999999999999 | 5.524999999999999 | 5.524999999999999 | 5.524999999999999 | 5.524999999999999 | 4.05 | 6.05 | 6.05 | 6.05 | 1.55 | 1.05 | 1.05 | 1.05 | 1.05 | 1.05 | 1.05 | 1.05 | 1.05 | 1.05 | 1.05 | 1.05 | 1.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Person 3 | 5 | 4.485294117647059 | 4.485294117647059 | 4.485294117647059 | 4.785294117647059 | 5.535294117647059 | 5.235294117647059 | 5.235294117647059 | 5.235294117647059 | 5.485294117647059 | 4.985294117647059 | 4.985294117647059 | 4.985294117647059 | 4.985294117647059 | 5 | 5 | 5 | 5 | 5 | 2 | 2 | 2 | 2 | 5 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Person 4 | 3.75 | 5.25 | 5.25 | 5.25 | 3.25 | 5.25 | 5.25 | 5.25 | 5.25 | 5.25 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Person 5 | 3.5 | 4.157232704402515 | 4.157232704402515 | 4.157232704402515 | 4.157232704402515 | 4.157232704402515 | 4.157232704402515 | 4.157232704402515 | 4.157232704402515 | 4.157232704402515 | 4.035714285714286 | 5.5 | 5.5 | 5.5 | 4 | 3.5 | 3.5 | 3.5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Person 6 | 5 | 7 | 5.5 | 5.5 | 5.5 | 5 | 1.5 | 1.5 | 1.5 | 1.5 | 3 | 1.5 | 1.5 | 1.5 | 2 | 0.5 | 0.5 | 0.5 | 2 | 0.5 | 0.5 | 0.5 | 0.5 | 2 | 0.5 | 0.5 | 0.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Person 7 | 1.5 | 5.5 | 5.5 | 5 | 5 | 5.5 | 5 | 5 | 5 | 5 | 5.5 | 5.5 | 5 | 5 | 5 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Legend | 5 | The redder a box is, the more activities that person has to do that week
 | Total | 29.3 | 38.63419348871624 | 38.13419348871624 | 37.63419348871624 | 34.93419348871625 | 35.68419348871624 | 31.38419348871624 | 31.38419348871624 | 31.38419348871624 | 31.63419348871624 | 33.48767507002801 | 36.45196078431373 | 35.95196078431373 | 35.95196078431373 | 27.55 | 22.05 | 22.05 | 21.05 | 23.05 | 17.55 | 17.55 | 17.55 | 17.55 | 19.05 | 14.55 | 14.55 | 14.55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Team Member | Average
 |  | 2014-10-27 00:00:00 | 2014-11-03 00:00:00 | 2014-11-10 00:00:00 | 2014-11-17 00:00:00 | 2014-11-24 00:00:00 | 2014-12-01 00:00:00 | 2014-12-08 00:00:00 | 2014-12-15 00:00:00 | 2014-12-22 00:00:00 | 2014-12-29 00:00:00 | 2015-01-05 00:00:00 | 2015-01-12 00:00:00 | 2015-01-19 00:00:00 | 2015-01-26 00:00:00 | 2015-02-02 00:00:00 | 2015-02-09 00:00:00 | 2015-02-16 00:00:00 | 2015-02-23 00:00:00 | 2015-03-02 00:00:00 | 2015-03-09 00:00:00 | 2015-03-16 00:00:00 | 2015-03-23 00:00:00 | 2015-03-30 00:00:00 | 2015-04-06 00:00:00 | 2015-04-13 00:00:00 | 2015-04-20 00:00:00 | 2015-04-27 00:00:00 | 2015-05-04 00:00:00 | 2015-05-11 00:00:00 | 2015-05-18 00:00:00 | 2015-05-25 00:00:00 | 2015-06-01 00:00:00 | 2015-06-08 00:00:00 | 2015-06-15 00:00:00 | 2015-06-22 00:00:00 | 2015-06-29 00:00:00
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36
 | Person 1 | 5.55 | 5.633333333333333 | 5.994444444444444 | 6.300000000000001 | 6.483333333333334 | 6.18888888888889 | 5.97857142857143 | 5.820833333333335 | 5.69814814814815 | 5.600000000000001 | 5.719696969696971 | 5.902777777777779 | 6.057692307692308 | 6.190476190476192 | 6.111111111111112 | 6.041666666666668 | 5.980392156862746 | 5.870370370370371 | 5.719298245614036 | 5.583333333333334 | 5.460317460317461 | 5.34848484848485 | 5.246376811594204 | 5.066666666666667 | 4.987179487179488 | 4.987179487179488 | 4.913580246913581 | 4.738095238095239 | 4.574712643678161 | 4.422222222222222 | 4.279569892473119 | 4.145833333333334 | 4.020202020202021 | 3.901960784313726 | 3.790476190476191 | 3.685185185185186
 | Person 2 | 4.999999999999999 | 5.762499999999999 | 6.016666666666666 | 6.018749999999999 | 5.819999999999999 | 5.770833333333332 | 5.735714285714285 | 5.709374999999999 | 5.688888888888887 | 5.672499999999999 | 5.524999999999999 | 5.568749999999999 | 5.60576923076923 | 5.637499999999998 | 5.364999999999998 | 5.095312499999999 | 4.857352941176469 | 4.645833333333332 | 4.45657894736842 | 4.286249999999998 | 4.132142857142855 | 3.992045454545453 | 3.864130434782607 | 3.638999999999998 | 3.539423076923075 | 3.539423076923075 | 3.44722222222222 | 3.324107142857141 | 3.209482758620688 | 3.102499999999998 | 3.002419354838708 | 2.908593749999998 | 2.820454545454544 | 2.737499999999998 | 2.659285714285713 | 2.585416666666665
 | Person 3 | 5 | 4.742647058823529 | 4.656862745098039 | 4.613970588235293 | 4.648235294117646 | 4.796078431372549 | 4.858823529411764 | 4.905882352941176 | 4.942483660130718 | 4.996764705882352 | 4.995721925133689 | 4.99485294117647 | 4.994117647058824 | 4.993487394957983 | 4.993921568627451 | 4.994301470588235 | 4.994636678200692 | 4.994934640522875 | 4.995201238390092 | 4.845441176470588 | 4.709943977591037 | 4.586764705882353 | 4.474296675191816 | 4.39635294117647 | 4.304185520361991 | 4.304185520361991 | 4.218845315904139 | 4.068172268907563 | 3.92789046653144 | 3.796960784313725 | 3.674478178368121 | 3.559650735294118 | 3.451782531194296 | 3.350259515570934 | 3.25453781512605 | 3.164133986928105
 | Person 4 | 3.75 | 4.5 | 4.75 | 4.875 | 4.55 | 4.666666666666667 | 4.75 | 4.8125 | 4.861111111111111 | 4.9 | 4.909090909090909 | 4.916666666666667 | 4.923076923076923 | 4.928571428571429 | 4.933333333333334 | 4.9375 | 4.941176470588236 | 4.944444444444445 | 4.947368421052632 | 4.95 | 4.952380952380953 | 4.954545454545454 | 4.956521739130435 | 4.72 | 4.615384615384615 | 4.615384615384615 | 4.518518518518518 | 4.357142857142857 | 4.206896551724138 | 4.066666666666666 | 3.935483870967742 | 3.8125 | 3.696969696969697 | 3.588235294117647 | 3.485714285714286 | 3.388888888888889
 | Person 5 | 3.5 | 3.828616352201258 | 3.938155136268344 | 3.992924528301887 | 4.025786163522012 | 4.04769392033543 | 4.063342318059299 | 4.075078616352202 | 4.084206848357792 | 4.091509433962265 | 4.086437147757903 | 4.204234052111411 | 4.303908355795149 | 4.389343473238353 | 4.363387241689129 | 4.309425539083558 | 4.261812272078643 | 4.219489368074274 | 4.260568875017733 | 4.297540431266847 | 4.330990886920806 | 4.361400392060769 | 4.389165592405954 | 4.438032345013477 | 4.459646485589882 | 4.459646485589882 | 4.479659578716182 | 4.319671736619176 | 4.170717538804722 | 4.031693620844565 | 3.901638987914095 | 3.779712769541779 | 3.665176018949604 | 3.557376724274615 | 3.455737389295341 | 3.359744684037137
 | Person 6 | 5 | 6 | 5.833333333333333 | 5.75 | 5.7 | 5.583333333333333 | 5 | 4.5625 | 4.222222222222222 | 3.95 | 3.863636363636364 | 3.666666666666667 | 3.5 | 3.357142857142857 | 3.266666666666667 | 3.09375 | 2.941176470588236 | 2.805555555555555 | 2.763157894736842 | 2.65 | 2.547619047619047 | 2.454545454545455 | 2.369565217391304 | 2.28 | 2.211538461538462 | 2.211538461538462 | 2.148148148148148 | 2.071428571428572 | 2 | 1.933333333333333 | 1.870967741935484 | 1.8125 | 1.757575757575758 | 1.705882352941176 | 1.657142857142857 | 1.611111111111111
 | Person 7 | 1.5 | 3.5 | 4.166666666666667 | 4.375 | 4.5 | 4.666666666666667 | 4.714285714285714 | 4.75 | 4.777777777777778 | 4.8 | 4.863636363636363 | 4.916666666666667 | 4.923076923076923 | 4.928571428571429 | 4.933333333333334 | 4.75 | 4.588235294117647 | 4.444444444444445 | 4.315789473684211 | 4.15 | 4 | 3.863636363636364 | 3.739130434782609 | 3.52 | 3.423076923076923 | 3.423076923076923 | 3.333333333333333 | 3.214285714285714 | 3.103448275862069 | 3 | 2.903225806451613 | 2.8125 | 2.727272727272727 | 2.647058823529412 | 2.571428571428572 | 2.5
 | Starting Week Number
 | Ending Week Number
 | Specific Average
 | Team Member
 | Person 1
 | Person 2
 | Person 3
 | Person 4
 | Person 5
 | Person 6
 | Person 7