Hi JustWatching,
let me first commend on this outstanding job of keeping this tracker Excel spreadsheet -- this is one of the most valuable and most useful contributions of this entire website!
One small recommendation to improve it: I love the Pivot Tables for Dallas and Philadelphia, and I make frequent use of sorting by the various columns. However, it would be useful to have an additinal column for SOURCE, and that field should be either STATE or REGION. You could just autopopulate it to REGION if "Transferred From" ends in DOL, and to STATE if "TransferredFrom" ends in SWA. That way, e.g. for Dallas, if people want to review only SWA cases or only cases that made it to the Regional level, they can, with just one mouse click, filter by that category. Right now, this is not possible to do.
Thanks!!! Again, many thanks for this outstanding project.