Hi Angus,
First of all, thanks a lot for your excel file, look neat, clean and really excellent. I liked it from the first sight.
I think it's already enough to show whatever we need. However, I just give a little suggestion here for the layout, please help if you have time. If not, just ignore it. I'm good with the current file already. The purpose of suggestion is giving more candidate names in the first view (not scrolling yet). As many names are showed, as easier to compare time. (So I guess another minor reason is for those who with small monitor like me
)
1. Delete line 2 and 5. They're there for separate purpose, also make clear between sections. However, I think it's still good after removing them.
2. Line 3 and 4 should be combined into one row but in distant columns. Still guarantee for easy look and give more space.
3. Line 6, try to put all column tittles into 1 cell instead of 3 cells. If necessary, can shorten title or widen column width.
e.g:
Application Received --->
App. Received or
App. Received (AR)
Days since Application was received --->
Days after App. Received or
Days after AR or
Days from AR
Total time for AIP --->
AIP total days
Oh, by the way I have a question for my understanding only, all day calculations, did you count weekend too?
Thanks a lot for your excellent idea and the contribution again. Have a nice day. :-*