hemantmohan.1
New Member
- Joined
- Oct 26, 2010
- Messages
- 30
Hello Everyone,
I'm afraid i am not able to put the picture of the file for better understanding. Though, i tried and failed. I will try my best to explain. In the below grid-1, in front of the date (1-Feb), i want to insert a formula that uses the grid2 (mentioned even below). The formula should be able to count the intervals wherein the value is between 2-4 basis the dates (1-Feb) only.
I have tried using sumproduct(--(Date range="1-Feb"),ABD RATE). But it didn't work. I will be obliged in case anyone can help. Thanks in anticipation.
GRID1
<colgroup><col><col><col><col><col span="2"><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I'm afraid i am not able to put the picture of the file for better understanding. Though, i tried and failed. I will try my best to explain. In the below grid-1, in front of the date (1-Feb), i want to insert a formula that uses the grid2 (mentioned even below). The formula should be able to count the intervals wherein the value is between 2-4 basis the dates (1-Feb) only.
I have tried using sumproduct(--(Date range="1-Feb"),ABD RATE). But it didn't work. I will be obliged in case anyone can help. Thanks in anticipation.
GRID1
DATE | FORECAST VOL | ACTUAL VOL | CALLS ABN | CALLS ANS | ANS in Threshold | Vol Error% | |||||||
1-Feb | 75723 | 82844 | 2461 | 80383 | 48160 | -8.6 | |||||||
2-Feb | 73871 | 81067 | 2274 | 78793 | 45842 | -8.9 | |||||||
3-Feb | 53605 | 58885 | 2679 | 56206 | 32577 | -9.0 | |||||||
4-Feb | 40743 | 38498 | 16 | 38482 | 38301 | 5.8 | |||||||
5-Feb | 81069 | 89167 | 2284 | 86883 | 49157 | -9.1 | |||||||
6-Feb | 77940 | 79443 | 246 | 79197 | 73564 | -1.9 | |||||||
7-Feb | 78291 | 78668 | 916 | 77752 | 55288 | -0.5 | |||||||
8-Feb | 73668 | 75339 | 1003 | 74336 | 62822 | -2.2 | |||||||
9-Feb | 70555 | 75903 | 393 | 75510 | 65921 | -7.0 | |||||||
10-Feb | 51135 | 56281 | 949 | 55332 | 39182 | -9.1 | |||||||
11-Feb | 39694 | 45580 | 1901 | 43679 | 23841 | -12.9 | |||||||
12-Feb | 79358 | 90645 | 5708 | 84937 | 24702 | -12.5 | |||||||
13-Feb | 78089 | 84271 | 1222 | 83049 | 61625 | -7.3 | |||||||
14-Feb | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
15-Feb | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
16-Feb | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
17-Feb | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
18-Feb | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
19-Feb | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
20-Feb | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
21-Feb | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
22-Feb | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
23-Feb | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
24-Feb | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
25-Feb | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
26-Feb | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
27-Feb | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
28-Feb | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
1-Mar | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
2-Mar | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
3-Mar | 0 | 0 | 0 | 0 | 0 | 0.0 | |||||||
GRID2 | OPERATIONS | STAFF | |||||||||||
INTERVALS | TIME | IFR | ABD | ASA (sec) | SVL | REQ+ | REQ | SCH+ | SCH | ACTUAL | PLAN | EXEC | |
DATE | RATE | UNPRD | UNPRD | ||||||||||
TOTAL | 2.35 | 32.4 | 66.30 | 11925 | 7983 | 14574 | 13517 | 12265 | |||||
1-Feb | 00:00 | 0 | . | 0 | 1.4 | 99.1 | 128.2 | 94.9 | 167 | 152.8 | 158.7 | 36 | 17 |
1-Feb | 00:30 | 0.3 | . | 0.3 | 0.9 | 99.5 | 99.7 | 73.8 | 153 | 140.4 | 137.8 | 49 | 7 |
1-Feb | 01:00 | 1 | . | 0 | 0.3 | 99.6 | 74.4 | 68 | 133 | 121.9 | 125 | 54 | 13.3 |
1-Feb | 01:30 | 1.3 | . | 0 | 0.1 | 100 | 55.6 | 50.9 | 104 | 101.7 | 108.6 | 51 | 13.4 |
1-Feb | 02:00 | 2 | . | 0 | 0.1 | 100 | 44.3 | 27.3 | 61 | 77.1 | 80.9 | 36 | 3.6 |
1-Feb | 02:30 | 2.3 | . | 0 | 0 | 100 | 25.3 | 23 | 51 | 46.3 | 67.1 | 23 | 20.8 |
1-Feb | 03:00 | 3 | . | 0 | 0 | 100 | 19.2 | 17.5 | 47 | 42.6 | 57.9 | 25 | 15.3 |
1-Feb | 03:30 | 3.3 | . | 0 | 0 | 100 | 25.1 | 11.4 | 49 | 44.5 | 45.8 | 22 | 1.4 |
1-Feb | 04:00 | 4 | . | 0 | 0.2 | 100 | 23.9 | 10.9 | 47 | 42.6 | 41.9 | 21 | -0.7 |
1-Feb | 04:30 | 4.3 | . | 0 | 0 | 100 | 20.7 | 18.8 | 19 | 34.5 | 39.3 | 16 | 4.8 |
1-Feb | 05:00 | 5 | . | 0.8 | 16.6 | 66.9 | 24.6 | 11.1 | 35 | 31.7 | 35.3 | 9 | 3.6 |
1-Feb | 05:30 | 5.3 | . | 0 | 6.9 | 87 | 25.7 | 11.6 | 33 | 29.9 | 33.8 | 7 | 3.8 |
1-Feb | 06:00 | 6 | . | 0 | 4.4 | 91.6 | 36.1 | 24.3 | 54 | 53.5 | 49 | 21 | -4.6 |
1-Feb | 06:30 | 6.3 | . | 1 | 7.3 | 84.5 | 55.1 | 37 | 69 | 62.6 | 60.2 | 13 | -2.5 |
1-Feb | 07:00 | 7 | . | 0 | 8.1 | 87.5 | 75.3 | 51.6 | 127 | 150.4 | 137.1 | 82 | -6.5 |
1-Feb | 07:30 | 7.3 | . | 0 | 0.4 | 99.6 | 115.6 | 86.6 | 200 | 182.5 | 169.9 | 77 | -2.8 |
1-Feb | 08:00 | 8 | . | 0.1 | 0.3 | 99.7 | 189.7 | 130 | 276 | 280.5 | 247.1 | 107 | -21.6 |
1-Feb | 08:30 | 8.3 | . | 1.6 | 11.7 | 79.1 | 263.3 | 180.4 | 352 | 320.6 | 282 | 80 | -25.1 |
1-Feb | 09:00 | 9 | . | 1.9 | 40 | 50 | 357.6 | 245.1 | 482 | 439.3 | 384.4 | 113 | -18.7 |
1-Feb | 09:30 | 9.3 | . | 0.6 | 14.6 | 70.2 | 443.9 | 304.2 | 577 | 526.3 | 485.7 | 121 | -3.3 |
1-Feb | 10:00 | 10 | . | 3.8 | 45.9 | 29.3 | 515.3 | 386.1 | 632 | 576.5 | 535.9 | 106 | 18.5 |
1-Feb | 10:30 | 10.3 | . | 2.4 | 50.6 | 26.4 | 568.9 | 389.9 | 713 | 650.4 | 598 | 131 | 17.6 |
1-Feb | 11:00 | 11 | . | 1.3 | 17.8 | 63.2 | 605.3 | 414.8 | 714 | 651.3 | 602.9 | 98 | 32.6 |
1-Feb | 11:30 | 11.3 | . | 5.5 | 60.7 | 14.8 | 639.4 | 438.2 | 656 | 679.7 | 615.4 | 95 | 15.8 |
1-Feb | 12:00 | 12 | . | 10.2 | 127 | 8.1 | 634.2 | 475.1 | 739 | 674.3 | 617 | 95 | 15.6 |
1-Feb | 12:30 | 12.3 | . | 7.3 | 128.8 | 6.8 | 644.3 | 441.5 | 772 | 704.1 | 657.6 | 115 | 35.1 |
1-Feb | 13:00 | 13 | . | 2.3 | 47.6 | 27.2 | 641.7 | 480.8 | 795 | 725.1 | 682.1 | 139 | 61.5 |
1-Feb | 13:30 | 13.3 | . | 0.2 | 3.3 | 94.7 | 662.9 | 454.3 | 728 | 752.5 | 697.7 | 147 | 55.2 |
1-Feb | 14:00 | 14 | . | 0 | 0.4 | 99.5 | 650 | 445.4 | 834 | 760.7 | 717.7 | 167 | 55 |
<colgroup><col><col><col><col><col span="2"><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>