Closed

Excel Dashboard with Excel VBA Addin - Top Menu Left Pane

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 [url removed, login to view] along with your bid.

Thanks & Regards

Nikhi l

Skills: Excel, Visual Basic

See more: dashboard excel vba, excel dashboard vba, menu dashboard excel, dashboard excel 2010 addin, dashboard vba excel, excel dashboard charts addin, excel addin dashboard, vba dashboard, excel vba dashboard, excel dashboard vba code, vba filter excel, excel dashboard addin, top menu vba excel, excel dashboard menu template, excel 2010 vba pane, addin dashboard excel, excel addin 2010 chart dashboard drill, vba excel excel chart template, custom left pane top menu excel, excel vba pane, excel 2010 dashboard addin, dashboard vba, dashboard menu excel, we-top dynamic, we top dynamic

About the Employer:
( 0 reviews ) New Delhi, India

Project ID: #1369605

24 freelancers are bidding on average $2335 for this job

Krusche

Hello. We have a team of 2 dedicated professionals in developing MS Excel\Access applications based on the VBA programming. Please refer to your PMB

$3000 USD in 24 days
(29 Reviews)
5.6
fedalal2

Hi, I have more 10 years experience in MS Office automation, so I'm realy GURU in this. I can help you with this project, so just contact me. Best Regards, Alex

$2500 USD in 21 days
(32 Reviews)
5.5
mrbrave

Hi, See PMB please...

$2000 USD in 30 days
(67 Reviews)
5.3
kulhanekd

I would like to bid ob this project. I gave 15 years experience in excel design. Please see PM thanks Donna

$1700 USD in 30 days
(10 Reviews)
4.5
aptecpymefree

Hi. I can create your Excel Dashboard.I have 14 Years of experience in Software development Windows and Web. Expert in Sql Server and .NET. Microsoft Certified as MCP, MCTS, MCPD, MCT. Please contact me to clarify all More

$1500 USD in 20 days
(7 Reviews)
4.4
esalem

Hello, please see the PM for details.

$3000 USD in 30 days
(8 Reviews)
2.8
henryli2008

Please check the PMB for details. Regards Henry -:)

$2980 USD in 30 days
(3 Reviews)
2.5
marasinghe82

Dear Sir, Please check the attached sample work smiler to your one & please reply me for farther details Best Regards, Jinesh

$1500 USD in 1 day
(1 Review)
2.0
shebabnewtok

Dear Sir We are very much interested in this project. Shebab

$1500 USD in 24 days
(2 Reviews)
0.8
punshar71

keen to do this project for you pls connect with me asap.

$3000 USD in 21 days
(0 Reviews)
0.0
sriabt

Whatever ur need, Its my pleasure to fulfill in macros

$1650 USD in 15 days
(0 Reviews)
0.0
ashishjha1212

Hi, I am an experienced reports and dashboard developer and currently working directly for a fortune 500 company CEO. Contact me if you are looking for executive quality reports. Regards, Ashish

$3000 USD in 30 days
(0 Reviews)
0.0
SriSuKu

I am hand on this type of projects. Am reay to start any time.

$2500 USD in 30 days
(0 Reviews)
0.0
shardak

I have 10 + years experience in vreating dashboards in excel.

$1500 USD in 7 days
(0 Reviews)
0.0
soumyastat

Hi, I'm new in this website. Just saw your requirement. If you has not got the solution kindly see the belopw note. I'm working in a corprate specially in analytical sector. My team creates and provides DASH BOARD t More

$2000 USD in 20 days
(0 Reviews)
0.0
Writersparadize

I am an expert data analyst and have experience in building dashboards with VB and form controls. I was unable to see the attachment and hence unable to respond with a [url removed, login to view]

$1600 USD in 10 days
(0 Reviews)
0.0
devendra1984

Before thinking, please visit the excel guru developed by me with all my excel VBA work and experiance. I have 5 yrs of core Excel, VBA, VB6 exp, so you can gain from it I think the work needs around 30 days with More

$2800 USD in 30 days
(0 Reviews)
0.0
bhambar

Hi Sir, I have 4 years of experience in VBA(Macros) and i have developed many kinds of MI/BI applications. Please check your PMB.

$4000 USD in 30 days
(0 Reviews)
0.0
Manvi73

we are expert in excel macros... have done projects in excel macro... ready to start the project..

$2800 USD in 22 days
(0 Reviews)
3.6
ValentinAnd

Pls give some examples if it is posible

$2500 USD in 30 days
(0 Reviews)
0.0