Menu

Fix for the fix!

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).

Part of the problem was to do with calculating aggregated rates, the aggregation function is designed for such things as combining single year of age into user defined bands, the rate is then formed from the base variable for the table - of course that denominator is used only once, no matter how many bands are aggregated. It is, of course, possible to aggregate variables from different tables, in which case no valid rate can be generated, currently the code will return a rate using the denominator for the first variable in the aggregation list as in general there is very little error checking in the code - the resulting rate will be meaningless and currently it's up to the user to recognise this fact.

Posted by Phil Ogden 2013-05-01 Labels: update errata

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.