Both the Census profiler and master database have been expanded to include aggregated information for Church of England Parishes, calculated on a best fit of Census Output Areas (ignoring OAs that fall outside the Leeds boundary). In addition table QS611 "Approximated Social Grade" has been implemented for all geographies.
ONS has published a series of tables on the theme of "Short-Term Residents for Local Authorities" comprising of tables for country of birth, passports held and economic activity of short-term residents, the lowest level of geography is Leeds so these tables may be of limited use but have been included in the database for completeness. Additional (more detailed) tables have been released with a minimum geography level of "Yorkshire and the Humber", these tables have not been included in the database.... read more
The previous update killed the ability to use a single variable in some of the function calls, ranges and arrays were not affected, even ranges of just one cell! This update addresses the problem and everything should again work as advertised.
As before, if you only use the Census Area Profiler and don't build your own templates then you may not want to update as there's nothing new in the files. If you do use the new functions yourself you'll need to either re-download the excel files or replace the CensusAPI code with the new .bas file (a much smaller download).... read more
The code that calculates rates of aggregated variables is incorrect and has been updated (12:30pm Monday 25th March 2013), the Census Area Profiler as supplied is unaffected but the error will show up if you expand the system to use aggregations. Replace CensusAPI.bas in the code or re-download the complete file as a matter of priority. This also apples to the main database file "StatisticalDatabase.xlsm" which should either be re-downloaded or the code module replaced with the updated version.... read more