Spreadsheet analysis and design
Excel Plot Grid
Creative analytics plotting program in Excel
U.S. Daily Report – Overview
Dynamic analytics report for major cosmetics company
U.S. Daily Report – Summary
Can you believe the daily summary was once 15 separate sheets? A sheet for each driver. They were all identical in structure, which made the consolidation process easier. Now, the user simply selects a driver and watch the summary update.
U.S. Daily Report – Estimates
Since the plan does not change, estimates allow stakeholders to change their planned forecast for any number of days. There is a Notes sheet within the report where stakeholders can specify an event for a certain day. Once changes are updated, a color code is automatically assigned to the particular day(s).
U.S. Daily Report – Trend Analysis
The trend analysis section allows users to graphically view performance over a certain timeframe. Each module provides a different view and selection options.