Reformat

Get Dropbox Data

Look for changes at the bottom of the spreadsheet. Make these in rallies.xls

Sort the new data to remove blank lines. Take care if there are line breaks within cells!

Use quicky.ahk (auto hot key) to add tilde (~) between Location and Event.

Paste whole file into here to reformat.

Look for errors and queries (???) and correct.

Geocode the reformat and corrected data for rallies.xls

Sort on start end and postcode, transfer into rallies.js


1Checks dates.
2Removes unwanted column.
3Splits Place and Event at tilde.
4Removes leading rally number.
5Removes quote marks, punctiation and duplicate spaces.
6Converts well known intials to capitals
7Takes http:// out of URLs.
8Adds country code.