Broadly....
Open spreadsheet, and use the filters to display data for one exchange
Copy, including header line
Paste into webpage
Hit validate, and set some options (especially the "region" to UK, and the "group by" option to "Deployed")
Hit big green button to create map.
Wait an awfully long time
This is enough to get all the postcodes correct where the postcode only appears once (as either deployed=yes, no or blank), but I think it will get confused in the cases where a postcode appears twice (ie served by 2 cabinets), and especially where the deployment status is different for the 2 cabinets. To get this correct will require more processing of the data in the spreadsheet, to get data in such a way as to only have one line per postcode.
And remember that, when "deployed=yes" it means it is planned; when "deployed=no" it means it was planned but is now either "still planned but deferred until later" or "removed"; when "deployed=blank" it means that service is not planned. In no case does it actually mean deployed.
I did this twice with the data for the Brookwood exchange:
The first was
Simple BatchGeo map for Brookwood FTTC, without accounting for duplicate postcodes.
The second was a
Fixed BatchGeo Map for Brookwood FTTC where I manually fixed the data for duplicate postcodes, giving a single status for each one.
Pages in this thread: 
Print Thread
deleted
