Spreadsheet: 53013d1252937424-mode-function-sample
Sheet: Previous 13mth

1 | 2 |  |  |  |  |  |  |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 29
Wrktype | Capacity Planner RE | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | TOTAL | MODE Weekly Volumes |  | Mode | Daily MODE
Worktype 1 | 5 | 66 | 64 | 45 | 53 | 45 | 65 | 59 | 59 | 62 | 69 | 73 | 64 | 83 | 807 | 12.8 |  | 64 | 2.56
Worktype 2 | 9.84 | 26 | 25 | 32 | 16 | 19 | 23 | 35 | 19 | 28 | 32 | 32 | 30 | 39 | 356 | 6.4 |  | 32 | 1.28
Worktype 3 | 10 | 460 | 556 | 460 | 423 | 387 | 406 | 499 | 426 | 446 | 401 | 466 | 416 | 453 | 5799 | 92 |  | 460 | 18.4
Worktype 4 | 13.46 | 7 | 7 | 7 | 14 | 20 | 27 | 20 | 19 | 20 | 23 | 26 | 22 | 20 | 232 | 4 |  | 20 | 0.8
Worktype 5 | 12 | 6 | 0 | 6 | 6 | 5 | 5 | 6 | 7 | 6 | 3 | 9 | 0 | 3 | 62 | 1.2 |  | 6 | 0.24
Worktype 6 | 1.8711 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 6 | 1 | 12 | 0 |  | 0 | 0
Worktype 7 | 5 | 72 | 110 | 98 | 95 | 47 | 77 | 79 | 124 | 66 | 113 | 137 | 135 | 114 | 1267 | 16 |  | 80 | 3.2
Worktype 8 | 9.78 | 9 | 28 | 13 | 17 | 54 | 28 | 16 | 19 | 24 | 33 | 23 | 32 | 28 | 324 | 5.600000000000001 |  | 28 | 1.12
Worktype 9 | 2.31 | 5 | 4 | 4 | 4 | 2 | 3 | 1 | 1 | 0 | 0 | 0 | 3 | 3 | 30 | 0.8 |  | 4 | 0.16
Worktype 10 | 10.12 | 1085 | 863 | 586 | 721 | 519 | 565 | 687 | 638 | 489 | 605 | 568 | 531 | 800 | 8657 | 117.2 |  | 586 | 23.44
Worktype 11 | 6.19 | 2 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 6 | 0 |  | 0 | 0
Worktype 12 | 7.8 | 170 | 224 | 158 | 146 | 116 | 147 | 156 | 192 | 172 | 194 | 240 | 194 | 187 | 2296 | 38.8 |  | 194 | 7.76
Worktype 13 | 11.91 | 229 | 276 | 256 | 240 | 221 | 251 | 294 | 236 | 184 | 224 | 218 | 221 | 290 | 3140 | 44.2 |  | 221 | 8.84
Worktype 14 | 10.6 | 818 | 865 | 821 | 807 | 550 | 444 | 454 | 464 | 457 | 535 | 432 | 390 | 370 | 7407 | 91.4 |  | 457 | 18.28
Worktype 15 | 9.85 | 1 | 3 | 4 | 1 | 0 | 2 | 4 | 17 | 1 | 1 | 2 | 2 | 2 | 40 | 0.2 |  | 1 | 0.04
Worktype 16 | 6.32 | 134 | 167 | 140 | 178 | 137 | 139 | 178 | 108 | 101 | 114 | 131 | 111 | 132 | 1770 | 35.6 |  | 178 | 7.12
Worktype 17 | 8.74 | 14 | 7 | 15 | 14 | 11 | 17 | 12 | 21 | 24 | 34 | 22 | 37 | 21 | 249 | 2.8 |  | 14 | 0.56
Worktype 18 | 4 | 68 | 36 | 57 | 46 | 35 | 42 | 56 | 71 | 86 | 93 | 85 | 72 | 59 | 806 | 11.2 |  | 56 | 2.24
Worktype 19 | 10.19 | 815 | 930 | 741 | 829 | 751 | 651 | 835 | 910 | 904 | 1040 | 964 | 733 | 790 | 10893 | 180.8 |  | 904 | 36.16
Worktype 20 | 6.42 | 2 | 4 | 5 | 5 | 2 | 4 | 5 | 3 | 2 | 2 | 7 | 2 | 2 | 45 | 0.4 |  | 2 | 0.08
Worktype 21 | 15 | 527 | 665 | 638 | 544 | 322 | 348 | 398 | 402 | 360 | 427 | 325 | 317 | 368 | 5641 | 79.6 |  | 398 | 15.92
Worktype 22 | 15.78 | 818 | 936 | 850 | 825 | 577 | 564 | 600 | 580 | 572 | 576 | 483 | 463 | 482 | 8326 | 115.4 |  | 577 | 23.08
Worktype 23 | 5 | 46 | 69 | 92 | 123 | 96 | 71 | 88 | 24 | 57 | 115 | 81 | 1122 | 34 | 2018 | 16.2 |  | 81 | 3.24
Worktype 24 | 4.62 | 11 | 29 | 21 | 23 | 28 | 21 | 20 | 26 | 18 | 31 | 30 | 19 | 30 | 307 | 4.2 |  | 21 | 0.84
Worktype 25 | 8.8 | 35 | 55 | 35 | 26 | 30 | 27 | 28 | 14 | 25 | 32 | 33 | 43 | 25 | 408 | 7 |  | 35 | 1.4
Worktype 26 | 11.93 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 2 | 5 | 1 | 0 | 11 | 0 |  | 0 | 0
Worktype 27 | 3.16 | 23 | 21 | 18 | 33 | 31 | 72 | 55 | 26 | 18 | 32 | 53 | 37 | 24 | 443 | 3.6 |  | 18 | 0.72
Worktype 28 | 1.5 | 30 | 33 | 22 | 43 | 36 | 27 | 37 | 35 | 41 | 97 | 133 | 47 | 42 | 623 | 7.4 |  | 37 | 1.48
Worktype 29 | 16.46 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 1 | 0 | 2 | 0 | 0 | 6 | 0 |  | 0 | 0
Worktype 30 | 38.4 | 2 | 6 | 7 | 6 | 2 | 6 | 9 | 1 | 1 | 9 | 6 | 9 | 6 | 70 | 1.2 |  | 6 | 0.24
Worktype 31 | 9.3 | 0 | 0 | 0 | 3 | 0 | 3 | 2 | 3 | 1 | 2 | 1 | 2 | 1 | 18 | 0 |  | 0 | 0
Worktype 32 | 8.939700000000002 | 523 | 709 | 591 | 513 | 468 | 561 | 708 | 608 | 569 | 616 | 648 | 549 | 588 | 7651 | 117.6 |  | 588 | 23.52
Worktype 33 | 6.06 | 90 | 92 | 89 | 92 | 67 | 84 | 89 | 97 | 93 | 78 | 87 | 80 | 138 | 1176 | 18.4 |  | 92 | 3.68
Worktype 34 | 11.42 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |  | 0 | 0
Worktype 35 | 18.68 | 54 | 44 | 43 | 54 | 42 | 40 | 36 | 49 | 39 | 40 | 41 | 48 | 64 | 594 | 10.8 |  | 54 | 2.16