Spreadsheet: 85771d1285801794-excel-2007-how-to-auto-change-the-cell-and-graph-format-new-dcs-pbcs-nsms
Sheet: Weekly Data

Week End Date | Week # | Ticket Volume (DCS-1) | Ticket closed per hour (DCS-2) | Mean Time to Resolve (DCS-3) | SLA - SLO Misses (DCS 5) | Right To Left (DCS-4) |  | DESC And Field Completion %
2009-03-07 00:00:00 | Wk 10 '09 | 3016 | 869 | 478.8859447004608 | 0.25 | 0.4133016627078385 |  | Week End Date | Week | DESC | Onsite | Total Comp | DESC % | Field %
2009-03-14 00:00:00 | Wk 11 '09 | 3037 | 861 | 550.303488372093 | 0 | 0.4303482587064676 |  | 2009-03-07 00:00:00 | Wk 10 '09 | 870 | 1235 | 2105 | 0.4133016627078385 | 0.5866983372921615
2009-03-21 00:00:00 | Wk 12 '09 | 2643 | 982 | 584.2423625254582 | 0 | 0.5715948777648429 |  | 2009-03-14 00:00:00 | Wk 11 '09 | 865 | 1145 | 2010 | 0.4303482587064676 | 0.5696517412935324
2009-03-28 00:00:00 | Wk 13 '09 | 2788 | 1059 | 639.7342130065975 | 0 | 0.8533440773569702 |  | 2009-03-21 00:00:00 | Wk 12 '09 | 982 | 736 | 1718 | 0.5715948777648429 | 0.4284051222351571
2009-04-04 00:00:00 | Wk 14 '09 | 2916 | 1106 | 489.0840867992767 | 0 | 0.6262740656851642 |  | 2009-03-28 00:00:00 | Wk 13 '09 | 1059 | 182 | 1241 | 0.8533440773569702 | 0.1466559226430298
2009-04-11 00:00:00 | Wk 15 '09 | 3137 | 1298 | 422.6525423728813 | 0 | 0.5259319286871961 |  | 2009-04-04 00:00:00 | Wk 14 '09 | 1106 | 660 | 1766 | 0.6262740656851642 | 0.3737259343148358
2009-04-18 00:00:00 | Wk 16 '09 | 2529 | 920 | 538.6804347826087 | 0 | 0.4829396325459318 |  | 2009-04-11 00:00:00 | Wk 15 '09 | 1298 | 1170 | 2468 | 0.5259319286871961 | 0.4740680713128039
2009-04-25 00:00:00 | Wk 17 '09 | 2385 | 930 | 488.7279569892473 | 0 | 0.4986595174262735 |  | 2009-04-18 00:00:00 | Wk 16 '09 | 920 | 985 | 1905 | 0.4829396325459318 | 0.5170603674540682
2009-05-02 00:00:00 | Wk 18 '09 | 2500 | 942 | 374.2951167728238 | 0.25 | 0.4919060052219321 |  | 2009-04-25 00:00:00 | Wk 17 '09 | 930 | 935 | 1865 | 0.4986595174262735 | 0.5013404825737265
2009-05-09 00:00:00 | Wk 19 '09 | 2669 | 1154 | 387.9081455805892 | 0 | 0.5521531100478468 |  | 2009-05-02 00:00:00 | Wk 18 '09 | 942 | 973 | 1915 | 0.4919060052219321 | 0.5080939947780679
2009-05-16 00:00:00 | Wk 20 '09 | 2646 | 1059 | 401.7337110481586 | 0 | 0.5178484107579462 |  | 2009-05-09 00:00:00 | Wk 19 '09 | 1154 | 936 | 2090 | 0.5521531100478468 | 0.4478468899521531
2009-05-23 00:00:00 | Wk 21 '09 | 2491 | 1130 | 394.2353982300885 | 0 | 0.5509507557289127 |  | 2009-05-16 00:00:00 | Wk 20 '09 | 1059 | 986 | 2045 | 0.5178484107579462 | 0.4821515892420538
2009-05-30 00:00:00 | Wk 22 '09 | 2091 | 783 | 569.3678160919541 | 0 | 0.525503355704698 |  | 2009-05-23 00:00:00 | Wk 21 '09 | 1130 | 921 | 2051 | 0.5509507557289127 | 0.4490492442710873
2009-06-06 00:00:00 | Wk 23 '09 | 2902 | 1257 | 405.400954653938 | 0.25 | 0.6116788321167883 |  | 2009-05-30 00:00:00 | Wk 22 '09 | 783 | 707 | 1490 | 0.525503355704698 | 0.474496644295302
2009-06-13 00:00:00 | Wk 24 '09 | 2594 | 1164 | 427.7027491408934 | 0.5 | 0.539138490041686 |  | 2009-06-06 00:00:00 | Wk 23 '09 | 1257 | 798 | 2055 | 0.6116788321167883 | 0.3883211678832117
2009-06-20 00:00:00 | Wk 25 '09 | 2007 | 1121 | 410.5842997323818 | 0.25 | 0.5095454545454545 |  | 2009-06-13 00:00:00 | Wk 24 '09 | 1164 | 995 | 2159 | 0.539138490041686 | 0.460861509958314
2009-06-27 00:00:00 | Wk 26 '09 | 2102 | 1026 | 434.2319688109162 | 0.25 | 0.5171370967741935 |  | 2009-06-20 00:00:00 | Wk 25 '09 | 1121 | 1079 | 2200 | 0.5095454545454545 | 0.4904545454545455
2009-07-04 00:00:00 | Wk 27 '09 | 1326 | 744 | 423.5275167785235 | 0.25 | 0.488173455978975 |  | 2009-06-27 00:00:00 | Wk 26 '09 | 1026 | 958 | 1984 | 0.5171370967741935 | 0.4828629032258064
2009-07-11 00:00:00 | Wk 28 '09 | 2416 | 918 | 505.1263616557734 | 0.25 | 0.4793733681462141 |  | 2009-07-04 00:00:00 | Wk 27 '09 | 743 | 779 | 1522 | 0.488173455978975 | 0.511826544021025
2009-07-18 00:00:00 | Wk 29 '09 | 2802 | 960 | 471.0666666666667 | 0.25 | 0.475012370113805 |  | 2009-07-11 00:00:00 | Wk 28 '09 | 918 | 997 | 1915 | 0.4793733681462141 | 0.5206266318537859
2009-07-25 00:00:00 | Wk 30 '09 | 2330 | 968 | 393.7747933884298 | 0.25 | 0.4789708065314201 |  | 2009-07-18 00:00:00 | Wk 29 '09 | 960 | 1061 | 2021 | 0.475012370113805 | 0.524987629886195
2009-08-01 00:00:00 | Wk 31 '09 | 1728 | 888 | 428.0574324324324 | 0.25 | 0.4596273291925466 |  | 2009-07-25 00:00:00 | Wk 30 '09 | 968 | 1053 | 2021 | 0.4789708065314201 | 0.5210291934685799
2009-08-08 00:00:00 | Wk 32 '09 | 2547 | 930 | 379.2967741935484 | 0.5 | 0.457002457002457 |  | 2009-08-01 00:00:00 | Wk 31 '09 | 888 | 1044 | 1932 | 0.4596273291925466 | 0.5403726708074534
2009-08-15 00:00:00 | Wk 33 '09 | 2353 | 791 | 458.7018867924529 | 0.25 | 0.4066496163682864 |  | 2009-08-08 00:00:00 | Wk 32 '09 | 930 | 1105 | 2035 | 0.457002457002457 | 0.542997542997543
2009-08-22 00:00:00 | Wk 34 '09 | 2399 | 805 | 385.1507853403141 | 0.25 | 0.4589139836617011 |  | 2009-08-15 00:00:00 | Wk 33 '09 | 795 | 1160 | 1955 | 0.4066496163682864 | 0.5933503836317136
2009-08-29 00:00:00 | Wk 35 '09 | 2444 | 867 | 387.8512110726643 | 0.25 | 0.4350225790265931 |  | 2009-08-22 00:00:00 | Wk 34 '09 | 955 | 1126 | 2081 | 0.4589139836617011 | 0.5410860163382989
2009-09-05 00:00:00 | Wk 36 '09 | 2417 | 797 | 486.2045454545454 | 0.25 | 0.373008434864105 |  | 2009-08-29 00:00:00 | Wk 35 '09 | 867 | 1126 | 1993 | 0.4350225790265931 | 0.564977420973407
2009-09-12 00:00:00 | Wk 37 '09 | 1910 | 608 | 571 | 0.25 | 0.4185724185724186 |  | 2009-09-05 00:00:00 | Wk 36 '09 | 796 | 1338 | 2134 | 0.373008434864105 | 0.626991565135895
2009-09-19 00:00:00 | Wk 38 '09 | 2429 | 990 | 379 | 0.25 | 0.4711217183770883 |  | 2009-09-12 00:00:00 | Wk 37 '09 | 604 | 839 | 1443 | 0.4185724185724186 | 0.5814275814275814
2009-09-26 00:00:00 | Wk 39 '09 | 2367 | 928 | 417 | 0.25 | 0.4759467758444217 |  | 2009-09-19 00:00:00 | Wk 38 '09 | 987 | 1108 | 2095 | 0.4711217183770883 | 0.5288782816229117
2009-10-03 00:00:00 | Wk 40 '09 | 2368 | 945 | 478 | 0.25 | 0.4777777777777778 |  | 2009-09-26 00:00:00 | Wk 39 '09 | 930 | 1024 | 1954 | 0.4759467758444217 | 0.5240532241555783
2009-10-10 00:00:00 | Wk 41 '09 | 2281 | 818 | 475.6 | 0.25 | 0.4544444444444444 |  | 2009-10-03 00:00:00 | Wk 40 '09 | 946 | 1034 | 1980 | 0.4777777777777778 | 0.5222222222222223
2009-10-17 00:00:00 | Wk 42 '09 | 2290 | 878 | 433 | 0.25 | 0.4582463465553236 |  | 2009-10-10 00:00:00 | Wk 41 '09 | 818 | 982 | 1800 | 0.4544444444444444 | 0.5455555555555556
2009-10-24 00:00:00 | Wk 43 '09 | 2383 | 919 | 389 | 0.25 | 0.4778991159646386 |  | 2009-10-17 00:00:00 | Wk 42 '09 | 878 | 1038 | 1916 | 0.4582463465553236 | 0.5417536534446764
2009-10-31 00:00:00 | Wk 44 '09 | 2219 | 846 | 442 | 0.25 | 0.4563 |  | 2009-10-24 00:00:00 | Wk 43 '09 | 919 | 1004 | 1923 | 0.4778991159646386 | 0.5221008840353614
2009-11-07 00:00:00 | Wk 45 '09 | 2418 | 799 | 410 | 0.25 | 0.4225277630883131 |  | 2009-10-31 00:00:00 | Wk 44 '09 | 846 | 1008 | 1854 | 0.4563106796116505 | 0.5436893203883495
2009-11-14 00:00:00 | Wk 46 '09 | 2333 | 880 | 472 | 0.25 | 0.4473817996949669 |  | 2009-11-07 00:00:00 | Wk 45 '09 | 799 | 1092 | 1891 | 0.4225277630883131 | 0.5774722369116869
2009-11-21 00:00:00 | Wk 47 '09 | 2190 | 931 | 462 | 0.25 | 0.4838877338877339 |  | 2009-11-14 00:00:00 | Wk 46 '09 | 880 | 1087 | 1967 | 0.4473817996949669 | 0.5526182003050331
2009-11-28 00:00:00 | Wk 48 '09 | 1186 | 423 | 462 | 0.25 | 0.4351851851851852 |  | 2009-11-21 00:00:00 | Wk 47 '09 | 931 | 993 | 1924 | 0.4838877338877339 | 0.5161122661122661
2009-12-05 00:00:00 | Wk 49 '09 | 2078 | 759 | 475 | 0.25 | 0.4425655976676385 |  | 2009-11-28 00:00:00 | Wk 48 '09 | 423 | 549 | 972 | 0.4351851851851852 | 0.5648148148148148
2009-12-12 00:00:00 | Wk 50 '09 | 2122 | 643 | 478 | 0.5 | 0.4474599860821155 |  | 2009-12-05 00:00:00 | Wk 49 '09 | 759 | 956 | 1715 | 0.4425655976676385 | 0.5574344023323615
2009-12-19 00:00:00 | Wk 51 '09 | 2060 | 667 | 503 | 0.25 | 0.471045197740113 |  | 2009-12-12 00:00:00 | Wk 50 '09 | 643 | 794 | 1437 | 0.4474599860821155 | 0.5525400139178844
2009-12-26 00:00:00 | Wk 52 '09 | 1272 | 316 | 418 | 0.25 | 0.3657407407407408 |  | 2009-12-19 00:00:00 | Wk 51 '09 | 667 | 749 | 1416 | 0.471045197740113 | 0.528954802259887
2010-01-02 00:00:00 | Wk 1 '10 | 986 | 243 | 422 | 0.25 | 0.3333333333333333 |  | 2009-12-26 00:00:00 | Wk 52 '09 | 316 | 548 | 864 | 0.3657407407407408 | 0.6342592592592593
2010-01-09 00:00:00 | Wk 2 '10 | 2134 | 918 | 515 | 0.25 | 0.43342776203966 |  | 2010-01-02 00:00:00 | Wk 1 '10 | 243 | 486 | 729 | 0.3333333333333333 | 0.6666666666666666
2010-01-16 00:00:00 | Wk 3 '10 | 2828 | 1091 | 474 | 0.25 | 0.4648487430762676 |  | 2010-01-09 00:00:00 | Wk 2 '10 | 918 | 1200 | 2118 | 0.43342776203966 | 0.56657223796034
2010-01-23 00:00:00 | Wk 4 '10 | 2923 | 1083 | 421 | 0.25 | 0.4484472049689441 |  | 2010-01-16 00:00:00 | Wk 3 '10 | 1091 | 1256 | 2347 | 0.4648487430762676 | 0.5351512569237324
2010-01-30 00:00:00 | Wk 5 '10 | 2574 | 948 | 462 | 0.25 | 0.412712233347845 |  | 2010-01-23 00:00:00 | Wk 4 '10 | 1083 | 1332 | 2415 | 0.4484472049689441 | 0.5515527950310559
2010-02-06 00:00:00 | Wk 6 '10 | 2915 | 1086 | 400 | 0.25 | 0.4621276595744681 |  | 2010-01-30 00:00:00 | Wk 5 '10 | 948 | 1349 | 2297 | 0.412712233347845 | 0.587287766652155
 | Wk 0 '00 |  |  |  |  |  |  | 2010-02-06 00:00:00 | Wk 6 '10 | 1086 | 1264 | 2350 | 0.4621276595744681 | 0.5378723404255319
 | Wk 0 '00 |  |  |  |  |  |  | 2010-02-13 00:00:00 | Wk 7 '10
 | Wk 0 '00 |  |  |  |  |  |  | 2010-02-20 00:00:00 | Wk 8 '10
 | Wk 0 '00 |  |  |  |  |  |  | 2010-02-27 00:00:00 | Wk 9 '10
 | Wk 0 '00 |  |  |  |  |  |  | 2010-03-06 00:00:00 | Wk 10 '10
 |  |  |  |  |  |  |  | 2010-03-13 00:00:00 | Wk 11 '10