@Randy, your solutions seems to be easiest once it reduces the amount of data to upload, but at the moment our requirement is to have population data structured as defined by National Institute of Statistics - NIS.
@Rodolfo, I guess we are at the same step. We are trying to setup an initial version of dhis2 for some Workshops, and your approach is in the way of what we need. Now I just need to create a procedure to automatically load all the data from the source, NIS excel files. Kind regards, Paulo Grácio From: Wilson,Randy [mailto:[email protected]] Sent: terça-feira, 26 de Março de 2013 18:24 To: Rodolfo Melia; Paulo Grácio Cc: [email protected] Subject: RE: [Dhis2-users] Population Definition In Rwanda, we have tried to keep things simple by entering only total population figures for province, district, sector and health facility levels for each year. We have then created indicators for each of the major target population groups by using census breakdowns and multiplying the total population by the following factors (were still waiting for results of 2012 census to update some of these): Children 0 - 11 months 4.10% Children 1 - 4 years 12.10% Children 5 - 14 years 27.50% Children < 15 years 43.70% Population >= 15 years 56.30% Children under 5 years 16.20% Expected Pregnancies 4.10% Women of reproductive age 23.60% If your administrative units are very diverse this approach might not work, but it certainly simplifies analysis and people are less inclined to use smaller denominators to make their performance look better. Randy From: [email protected] [mailto:[email protected]] On Behalf Of Rodolfo Melia Sent: Tuesday, March 26, 2013 6:11 PM To: Paulo Grácio Cc: [email protected] Subject: Re: [Dhis2-users] Population Definition So far (I'm only doing tests, no yet in production), I have imported population data using a dataset with annual data collection, populating 2012, 13 and 14 with the same data, so I can do indicator calculations on those years. For your case, I will create 3 data elements, each one associated to a category combination for Age, Gender and Area. Rodolfo On Tue, Mar 26, 2013 at 3:53 PM, Paulo Grácio <[email protected]> wrote: Hello, Im trying to figure out the best way to define population in a way that it can be used to calculate indicators. We have population values, lowest level is District, aggregated by age(0-5; 5-20;20-60;60+), gender(male, female) and area(rural, urban). Based on you experience what do you consider to be the best approach for this? Kind regards, Paulo Grácio _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp -- Rodolfo Meliá Principal [email protected] www.knowming.com +1 708 872 7636 +44 777 576 4090 Skype: rod.melia Twitter: @RodolfoMelia <https://twitter.com/RodolfoMelia> Note: Please note my new email address, which I will be using for PSI related work: [email protected]
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
