building Heatmap

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.