Sales/Warehouse database

CLOSED
Bids
26
Avg Bid (USD)
$20 / hr
Project Budget (USD)
$15 - $25 / hr

Project Description:
I'm trying to produce a database in excel which will let warehouse sales dealers track what deals have been made/missed.

There is a basic database I've made populated with dummy data which is a copy of the structure of the original database. There are 10 columns with data ranging from date to type of trade to who the salesman was, and more.

This is what I want done:

-IMPORTANT: This must be tailored only to excel 2007

-A dashboard presenting some statistics. Simple and clean. I don't need fancy graphs. Conditional formatting with data bars is fine.

-I need the statistics to automatically update with new data entered into the database

All statistics will be filterable by a date range with quick options to select month-to-date, year-to-date and week-to-date (excluding weekends).
An additional filter for all the statistics presented on the dash by the two options in the type column.

I've thrown some examples into the Excel worksheet called dash.

Statistics needed:

(See attached excel file)

-An optional improvement would be to have searchable drop down data selection boxes in the worksheet so as to make it easier to enter new data.



First milestone would be a few main summary statistics with the option to filter by date and type, and that the stats are able to handle an updated database.

Hours of work: 4 Hr / week Project Duration: 1 - 4 weeks Skills required:
Excel, Visual Basic for Apps
Additional Files: Project.xlsm
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$15 / hr
Hours: 42 hr/ week
$25 / hr
Hours: 4 hr/ week
$25 / hr
Hours: 4 hr/ week
$16 / hr
Hours: 4 hr/ week
Hire finecodervw
$20 / hr
Hours: 8 hr/ week
$22 / hr
Hours: 7 hr/ week
$22 / hr
Hours: 6 hr/ week
$22 / hr
Hours: 4 hr/ week
$15 / hr
Hours: 20 hr/ week
$20 / hr
Hours: 4 hr/ week