Spreadsheet: 69767d1270396290-delete-blank-rows-and-text-formatting-output
Sheet: 29-Mar-10

 | Time Interval | Forecast Calls | Actual Calls | ABN Calls | Forecast AHT | Actual AHT | Org Stf Req | Org Stf Sch | Act Stf Req | [NAME] | Act SLA | Act Pos Stf
 | 1900-01-01 00:00:00 | 4 | 0 | 0 | 437.64 | 0 | 2.44 | 0 | 0 | 2 | 0 | 3.07
 | 00:30:00 | 1 | 3 | 0 | 522.68 | 338 | 1.28 | 0 | 1.75 | 2 | 100 | 3
 | 01:00:00 | 2 | 1 | 0 | 380 | 305 | 1.52 | 0 | 0.98 | 4 | 100 | 3
 | 01:30:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 3
 | 02:00:00 | 5 | 0 | 0 | 332.9 | 0 | 2.32 | 0 | 0 | 4 | 0 | 3
 | 02:30:00 | 2 | 0 | 0 | 315.37 | 0 | 1.37 | 0 | 0 | 2.5 | 0 | 3
 | 03:00:00 | 8 | 0 | 0 | 398.12 | 0 | 3.56 | 0 | 0 | 4 | 0 | 3
 | 03:30:00 | 2 | 1 | 0 | 466.62 | 408 | 1.71 | 0 | 1.13 | 3.5 | 100 | 3
 | 04:00:00 | 3 | 3 | 0 | 388.71 | 188 | 1.91 | 0 | 1.24 | 4 | 100 | 2.94
 | 04:30:00 | 8 | 5 | 0 | 399.41 | 691.4 | 3.57 | 0 | 3.87 | 2 | 100 | 3.09
 | 05:00:00 | 12 | 11 | 0 | 332.95 | 376.18 | 4.1 | 0 | 4.24 | 13 | 63.63 | 9.79
 | 05:30:00 | 26 | 24 | 2 | 421.5 | 490.77 | 8.9 | 2 | 9.5 | 14.47 | 58.33 | 14.39
 | 06:00:00 | 62 | 89 | 21 | 413.18 | 553.65 | 17.99 | 8 | 32.46 | 30 | 2.24 | 32.3
 | 06:30:00 | 63 | 89 | 2 | 454.33 | 567.14 | 19.9 | 8 | 33.2 | 26.5 | 42.7 | 37.73
 | 07:00:00 | 102 | 141 | 22 | 482.61 | 551.76 | 32.24 | 8.5 | 49.15 | 41 | 3.55 | 46.32
 | 07:30:00 | 85 | 154 | 23 | 535.5 | 546.04 | 30.19 | 7.5 | 52.78 | 35 | 0 | 47.86
 | 08:00:00 | 91 | 154 | 26 | 522.82 | 528.1 | 31.38 | 9.5 | 51.11 | 39 | 0 | 49.18
 | 08:30:00 | 81 | 105 | 3 | 498.01 | 598.54 | 27.03 | 9 | 40.56 | 32 | 34.29 | 50.44
 | 09:00:00 | 67 | 85 | 0 | 542.34 | 597.79 | 24.73 | 8.5 | 33.47 | 37 | 95.29 | 49.19
 | 09:30:00 | 60 | 78 | 1 | 551.1 | 646.05 | 22.78 | 7 | 33.32 | 32.5 | 98.72 | 48.95
 | 10:00:00 | 50 | 41 | 0 | 511.24 | 592.91 | 18.16 | 6.5 | 17.51 | 22.5 | 100 | 48.72
 | 10:30:00 | 50 | 51 | 0 | 532.68 | 478.86 | 18.85 | 8 | 17.4 | 30 | 100 | 48.87
 | 11:00:00 | 47 | 54 | 1 | 506.73 | 588.42 | 17.08 | 7.5 | 22.07 | 32.5 | 98.15 | 48.91
 | 11:30:00 | 50 | 51 | 1 | 479 | 461.66 | 17.11 | 6 | 16.84 | 29 | 98.04 | 44.67
 | 12:00:00 | 51 | 50 | 0 | 507.18 | 572.18 | 18.34 | 6.5 | 20.12 | 28.5 | 100 | 46.68
 | 12:30:00 | 51 | 54 | 0 | 503.76 | 536.61 | 18.22 | 6.5 | 20.28 | 33 | 98.15 | 46.96
 | 13:00:00 | 47 | 51 | 0 | 490.24 | 639.16 | 16.58 | 7.5 | 22.64 | 32.5 | 100 | 47.44
 | 13:30:00 | 48 | 50 | 0 | 524.51 | 600.92 | 17.94 | 8.5 | 21.03 | 31 | 100 | 47.98
 | 14:00:00 | 45 | 50 | 1 | 560.96 | 662.94 | 18.04 | 8 | 23.01 | 23 | 90 | 39.35
 | 14:30:00 | 31 | 36 | 0 | 562.49 | 575.55 | 13.19 | 3 | 15.26 | 18 | 88.89 | 37.61
 | 15:00:00 | 25 | 19 | 0 | 525.65 | 562.84 | 10.42 | 3 | 8.86 | 12 | 89.47 | 21.58
 | 15:30:00 | 17 | 21 | 0 | 508.17 | 636.9 | 7.45 | 2 | 10.66 | 9 | 100 | 18.9
 | 16:00:00 | 8 | 12 | 1 | 529.41 | 666.09 | 4.4 | 1.5 | 7.11 | 4.5 | 75 | 8.48
 | 16:30:00 | 9 | 15 | 1 | 511.29 | 447.07 | 4.66 | 2 | 6.1 | 4 | 60 | 5.07
 | 17:00:00 | 6 | 5 | 2 | 463.4 | 887.33 | 3.28 | 0 | 4.65 | 4 | 40 | 4.02
 | 17:30:00 | 7 | 8 | 2 | 414.96 | 649.67 | 3.35 | 0 | 5.14 | 3.5 | 12.5 | 3.99
 | 18:00:00 | 2 | 3 | 0 | 376.23 | 467.33 | 1.51 | 0 | 2.14 | 3 | 100 | 4
 | 18:30:00 | 3 | 3 | 0 | 430.66 | 342.67 | 2.04 | 0 | 1.77 | 3 | 100 | 4
 | 19:00:00 | 3 | 1 | 0 | 381.88 | 267 | 1.89 | 0 | 0.92 | 3 | 100 | 4
 | 19:30:00 | 1 | 2 | 0 | 384.5 | 501.5 | 1.1 | 0 | 1.78 | 1.5 | 100 | 4
 | 20:00:00 | 4 | 3 | 0 | 490.44 | 324 | 2.63 | 0 | 1.71 | 1 | 100 | 4
 | 20:30:00 | 1 | 0 | 0 | 282.14 | 0 | 0.95 | 0 | 0 | 2.5 | 0 | 4
 | 21:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3.99
 | 21:30:00 | 1 | 0 | 0 | 282.78 | 0 | 0.95 | 0 | 0 | 2.5 | 0 | 4
 | 22:00:00 | 1 | 6 | 0 | 278.62 | 315.33 | 0.94 | 0 | 2.5 | 2.5 | 50 | 4
 | 22:30:00 | 2 | 2 | 0 | 366.77 | 353 | 1.49 | 0 | 1.45 | 3 | 100 | 4
 | 23:00:00 | 1 | 0 | 0 | 447.1 | 0 | 1.19 | 0 | 0 | 2.5 | 0 | 4
 | 23:30:00 | 4 | 4 | 0 | 300.12 | 425 | 1.91 | 0 | 2.39 | 1 | 100 | 4.09
 | Total | 1249 | 1535 | 109 | 498.44 | 563.6 | 231.3 | 72.3 | 301 | 339 | 54 | 491.8