You have chosen to sponsor your bid up to a maximum amount of .
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.
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