I'm in need of assistance in Excel to create graphs based on a metrics data dump. This is a two part project with the first part consisting of recreation/adjustment of the current worksheets and then a macro based formatting system to accommodate the metrics that get populated.
Report [url removed, login to view] contains various worksheets that need data aggregated based on the [url removed, login to view] file.
I will run this report every Thursday for multiple departments which will have different information but will have the same layout and the same data file format to run against.
Attached is a breakdown of each tab within the final reporting file. Once you have completed the work, I will test it against a couple of weeks to audit the data and then I will provide the final milestone.
To ensure you have gone through the requirements and understand them, please include the word “metrics” in the bid.
If you have any questions, know of a better alternative to a method I provided, or perhaps you have a simple format already created and can provide a sample for me to review and see if it will work for my needs, please let me know. Do not make assumptions if you’re unclear so that no time is wasted.