Spreadsheet: 769548d1645592780-vlookup-n-a-error-works-in-some-cells-not-others-can-i-have-assistance-tg-forecast-conversion-24x7-2-
Sheet: Summary

1. Paste data in green columns A until H from the Forecast interval tab
2. 30 min converted data in the tables below, correspond to the data table needs in the IDP data tab
3. [NAME], AHT and Required FTE and Paste in the IDP data tab
DAILY |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY
Calls = Volume Lock |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AHT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Agents with Shrinkage = Required FTE
TIME | Sun | Mon | [NAME] | Wed | Thu | Fri | Sat | Sun2 | Mon2 | Tue2 | Wed2 | Thu2 | Fri2 | Sat2 | TIME | Sun | Mon | [NAME] | Wed | Thu | Fri | Sat | Sun2 | Mon2 | Tue2 | Wed2 | Thu2 | Fri2 | Sat2 | TIME | Sun | Mon | [NAME] | Wed | Thu | Fri | Sat | Sun2 | Mon2 | Tue2 | Wed2 | Thu2 | Fri2 | Sat2
00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
00:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:30:00
01:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:00:00
01:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:30:00
02:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:00:00
02:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:30:00
03:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:00:00
03:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:30:00
04:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:00:00
04:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:30:00
05:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:00:00
05:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:30:00
06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:00:00
06:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:30:00
07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00
07:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00
08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00
08:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:30:00
09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00
09:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:30:00
10:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00
10:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00
11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00
11:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00
12:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:30:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00
13:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:30:00
14:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00
14:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:30:00
15:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00
15:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00
16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00
16:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:30:00
17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00
17:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:30:00
18:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00
18:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:30:00
19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00
19:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:30:00
20:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:00:00
20:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:30:00
21:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:00:00
21:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:30:00
22:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00
22:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:30:00
23:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00
23:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:30:00