Excel Dashboard with Excel VBA Addin - Top Menu Left Pane

CLOSED
Bids
24
Avg Bid (USD)
$2335
Project Budget (USD)
$1500 - $3000

Project Description:
Hello Excel Experts,

We need dynamic interactive Dashboard template in Excel with a Custom Left Pane to give Slicers and Search functions and a Custom Top Menu.

The Dashboard and Excel Addin should be compatible with Excel 2003, 2007 and 2010.

Raw Datasheet will be in Excel file itself. ( optional - a local db probably - phase2 work)

There are 5 Dashboard sheets and one Pivot Report Sheet.
6-7 Charts and Filtered data in bottom in each dashboard sheets (Charts are mostly replications. )
One Control Sheet where flexible configuration of dashboard is saved.

Optional : Apart from Slicers and Search function, ideally we would want All charts and Table in one Active Dashboard Sheet to be in relationship with each other. That is….there is a Filter function, so clicking one Chart area ..creates a drill down or filters data of all charts and raw table in the Active dashboard sheet.

What we need is a Flexible Dashboard Template, and NOT a fixed dashboard tied with a fixed type of dataset.

All our datasets have exactly similar 6 fixed Dimensions. We want a Dashboard template , where we can change data of different Industry with minimal effort using a control sheet.

Data can be large and in some industry can run into a million rows. Further we need to provide a updated dashboard every month.

Any suggestions are welcome. We came up with a web based dashboard, but users refuse to use anything except Excel.


Deliverables:

1) For Users - Neatly formatted Corporate Dashboard Template
2) For Users - Ideally with a installable VSTO or VBA Excel Addin Exe Or Macro Code
( I can manage the Installer part only if required - please confirm )
3) Admin Excel Addin or Macro Code
4) All source Codes.


Delivery time is 3 weeks including testing.

More details are given in the attached "RAR" file which contains detailed specs in Word screenshots and questions.

Pls provide answers in the Questions.doc along with your bid.


Thanks & Regards

Nikhi l

Skills required:
Excel, Visual Basic
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.


$ 3000
in 24 days
$ 2500
in 21 days
Hire mrbrave
$ 2000
in 30 days
Hire kulhanekd
$ 1700
in 30 days
$ 1500
in 20 days
$ 3000
in 30 days
$ 2980
in 30 days
$ 1500
in 1 days
$ 1500
in 24 days
Hire shardak
$ 1500
in 7 days