Forum Discussion
Excel crashes on saving
John Barlow Thanks for the link.
I looked at the file you uploaded with your reply to mathetes to understand what you are wanting to achieve. It seems to me that you can do the summary with a simple pivot table. No need to create all the columns that count each type of crime for every area. Attached your file with the pivot table added in Sheet2. Is that what you have in mind?
Then, I looked at the November report for Thames Valley and it's a straight-forward CSV file that could be imported into Excel without a problem. All 17459 rows were summarised into a similar pivot table as mentioned above, of just under 1400 rows (one for each LSOA and 14 columns (one for every crime type) and with grand totals for each row and column. It took less than a minute to create this, from scratch. File also attached. And the best thing is that there is not one single formula in this file!
Hi and thanks for taking an interest.
https://data.police.uk/data/ is the first place to start. Select one of the 43 Police Forces, I suggest Thames Valley, and take it from there.
SadlyI am illiterate when it comes to using JSON but this is an alternative way to access data.
Thanks again.
JohnB
John Barlow Thanks for the link.
I looked at the file you uploaded with your reply to mathetes to understand what you are wanting to achieve. It seems to me that you can do the summary with a simple pivot table. No need to create all the columns that count each type of crime for every area. Attached your file with the pivot table added in Sheet2. Is that what you have in mind?
Then, I looked at the November report for Thames Valley and it's a straight-forward CSV file that could be imported into Excel without a problem. All 17459 rows were summarised into a similar pivot table as mentioned above, of just under 1400 rows (one for each LSOA and 14 columns (one for every crime type) and with grand totals for each row and column. It took less than a minute to create this, from scratch. File also attached. And the best thing is that there is not one single formula in this file!