U.S. Daily Report

Created :: October 2011
The Daily Report is a dynamic reporting tool. Overall, it took about three months to build, and it is massive. However, it is a great learning tool, which you can download freely.

Daily Report - Overview

Requirements

Microsoft Excel 2007 or higher or compatible :: File size: 6.67 MB

FREE Download

Summary

The Daily Report (“Daily”) is an eCommerce reporting tool developed for a retail cosmetics company. It is based on the company’s performance across the web. The original report took about two hours to update, on a daily basis. It was mostly a manual process. After developing the new report, it took approximately 15 minutes to update.

Possible Bug

Possibly because, the Daily was originally develop for the United States region.  We did not take into account international date formats.  Therefore, the Daily may not work in regions outside of the United States. Possible solution: Change your regional setting to United States, and language to English.

Automatic Calculations

You should have your calculations set to update automatically (see screenshot below). Otherwise, you will have to press F9 to update the screen, each time you make a selection.

Excel Calculation Options

The Components

There are four main components to the Daily Report—the overview, daily summary, estimates, and trend analysis.

Overview

Daily Report - Overview

Daily Summary

Daily Report - Summary

Estimates

Daily Report - Estimates

Trend Analysis

Daily Report - Trend Analysis


Requirements

Microsoft Excel 2007 or higher or compatible :: File size: 6.67 MB

FREE Download
Return to Home Page
One response...

Comments are closed.