Local Customer MCS Installation info

[SRE]

A while ago TedM put a link on to MCS pv installations up to Dec 2010. Does anyone know where a more updated version of this is - I want to know where the installs in our area are so I can piggyback on some of the national's marketing - we win out everytime we're up against them but we're not always at the same jobs. I reckon if I can find out where they are going in I can be a PV ambulance chaser

 

[TedM]

There is an XLS file on the OFGEM site covering the first full 12 months to the end of March 2011.

http://www.ofgem.gov.uk/Sustainabil... Tariff Installation Report 31 March 2011.xls

I've managed to get this loaded into a SQL database so can produce lots of query results easily.

As far as location is concerned you can see the first part of the Post Code which may be enough info for you.

 

[SRE]

Thanks Ted you're a star! I was going to PM you but I thought others would find the info useful too.

 

[Worcester]

Ted, many thanks.

For those not up to creating their own databases and tables, you can do a great deal of analysis using pivot tables in Excel - just check out MS's online training on pivot tables (it's free!)

Video: Create a PivotTable report - Microsoft Office