Help-Wanted: Help us clean up these workbooks, compile them into a single sheet, then export them as .csv
files.
TASK-DESCRIPTION: We've got raw .xlsx
workbooks of crime data from SCMPD that need to be cleaned and consolidated into a single spreadsheet for each weekly report. If you open the workbooks in Google Sheets or Excel, you'll notice the weekly summary as the last worksheet of the workbook. For now, let's stick to that one sheet.
FIRST: Sign up for a few workbooks to tackle by opening an issue here on GitHub. That way we won't overlap.
- Go to the worksheet entitled
Total Jurisdictions
and just stick with that one for now. Remove all decorative formatting (images, link breaks, etc.) and summary rows so that there is only one (1) title field row with as many columns as there may be (typically crimetypes). - Make sure you have a report date
date
column formattedYYYY-MM-DD
. - When finished, export just the last sheet with the weekly summaries as a '.csv' and either submit it as a PR to this repository or post it to http://forum.opensavannah.org.
More TK