Inventory of the gotchas
ACD Quarterly Averages need to use only working days
- the Monthly Pivots worksheet has pivots that just average whatever they see in the acd-per-day tables. If you leave in weekdays with zero values because they were holidays, then the quarterly averages are dragged too low. Remove any lines with zero days.