Client produces a weekly metrics report for each location in Excel. Client manually captures data from multiple reports from each location and performs some manual calculation to obtain some of the metrics. Each new month requires manual formatting and formula entry as well as redirecting all of the charts to a new data range. This process can occupy much of a managers time for 2 days each week and, unfortunately, leads to some errors in the reports.