building Heatmap

[excelhelp18]

I need help on the following:

I have a set of data on various sites with their Zones & Clusters (refer data tab in attached file).

I am looking for a some kind of macro that would help me consolidate this data by clusters & Zones. Refer "Results" tab

There are certain calculations that need to be build such as Outage Minutes, no.of sites & Uptime%.

Once, I have the results tab,would like to build the heat map of clusters.Refer "Heatmap" tab. It may be through a command button.

Eg: All those clusters having uptime > 99.90 from Results tab, should lined up against it. 3 examples are shown in the tab…

Patna has uptime of 99.70 and therefore is appearing against 99.85-99.65 group

I need to line up all the clusters according to the uptime achieved, lined up against grouped uptime.

looking forward to your inputs...

Thanks in advance.

[excelhelp18]

No body has yet replied to my query...Can someone look into this urgently??

[Palmetto]

Crosstab Heat Map

[excelhelp18]

This feature of heat map is available in excel 2007. I am using excel 2003 and hence need to achieve the same through some macro..

kindly help on this...

Thanks & Regards

[antoka05]

This code get data from data sheet and put data in result and heatmap sheet.
I hope it can help you.

Please Login or Register  to view this content.

Regards,
Antonio

[excelhelp18]

Thanks for your reply...but I am facing some error while executing the macro...

error is attached with the mail..kindly help to rectify the same...

thanks...

[antoka05]

I apologize for the error.

Regards,
Antonio

[excelhelp18]

Thanks a lot for the superb solution...

I need few more enhancement to the same..may be I am asking too much...but I know you people can only make it work for me.

a) In the heatmap prepared, I need a column with the count of cluster falling under defined range..shown in the file attached..

b) I want that only 10 cluster would be shown in a single line and if clusters are more than 10, it would accomodate in another line and range would also adjust...shown in the file attached.

c) I want to show the uptime% in bracket along with the cluster name.this is also shown for some of the clusters in the file attached...

I am bothering you guys too much..thanks for the cooperation till date..

[antoka05]

I modified the macro as you need... I hope it can help!!

Regards,
Antonio

[excelhelp18]

Thanks a lot for all the hardwork you put in achieving this..

This is exceptional...great guys..

[antoka05]

I'm glad to know it helped your.

Regards,
Antonio