dhis2-devs team mailing list archive

[Mohamadine Aly MAIGA <mohamedaly1b@xxxxxxxxx>]

Hi calle !

Thank you very much for these explanations which greatly strengthens my
knowledge and satisfies my question. Now it's very clear in my head and
easy for me to explain. Thank you so much! You are someone very important.

Edem KOSSI also in Cc.

God bless you. I keep your contact.

Mohamadine Aly MAIGA
Bamako - Mali
Tel: 63-12-12-63.


Le sam. 8 sept. 2018 20:30, Calle Hedberg <calle.hedberg@xxxxxxxxx> a
écrit :

> Mohamadine,
>
> (Apologies for replying in English - my French is pretty rusty...). The
> reason for the small discrepances you have noticed is:
>
> The DHIS2 is not using a monthly "annualisation" factor of 12 - it uses
> the number of days in each month and in the year
>
> So for instance for sep-17, the 115.2% you see are the result of something
> like this:
>     3985*(365/30)/221781 =  0.218613
> +  17013*(365/30)/221781 =  0.933314847
> =   1.151928 => 115.2%
>
> If you change your Excel calc formula to using the days per month/year
> approach, it would be 20998*(365/30)/221781 = 1.1492 => 115.2%
>
> So for Jan/Mar/May/Jul/Aug/Oct/Dec you would use 31 days, for Feb 28 days,
> and 30 days for the other months.
>
> Best regards from a winterly Cape Town
> Calle
>
>
>
> On Sat, 8 Sep 2018 at 17:20, Mohamadine Aly MAIGA <mohamedaly1b@xxxxxxxxx>
> wrote:
>
>> English bellow,
>>
>>
>>
>> Bonjour !
>>
>> Je me suis connecté et play.dhis2.org (dhis2.30) et extrait les données
>> ci-dessous puis faire le calcul manuel dans Excel pour comparer les deux
>> résultats ci-dessous, mais c'est pas la même chose. Merci d'avance pour
>> votre retour.
>>
>>
>>
>>
>>
>> Hello!
>>
>> I logged in and play.dhis2.org (dhis2.30) and extracted the data below
>> then do the manual calculation in Excel to compare the two results below,
>> but it's not the same thing. Thank you in advance for your return.
>>
>>
>>
>>
>>
>> *Sierra Leone*
>>
>> Calculer par moi-même dans Excel
>>
>> Period / Data
>>
>> BCG Coverage <1y
>>
>> BCG doses given Outreach, <1y
>> (A)
>>
>> BCG doses given Fixed, <1y
>> (B)
>>
>> Total population < 1 year
>> (C)
>>
>> Total dose BCG
>> Numérateur
>> (A+B)
>>
>> BCG Coverage <1y
>> (A+B) / [(C)/12] ?
>>
>> September 2017
>>
>> 115.2
>>
>> 3985
>>
>> 17013
>>
>> 221781
>>
>> 20998
>>
>> 114%
>>
>> October 2017
>>
>> 88.5
>>
>> 3244
>>
>> 13423
>>
>> 221781
>>
>> 16667
>>
>> 90%
>>
>> November 2017
>>
>> 95.2
>>
>> 3202
>>
>> 14152
>>
>> 221781
>>
>> 17354
>>
>> 94%
>>
>> December 2017
>>
>> 71.6
>>
>> 1883
>>
>> 11595
>>
>> 221781
>>
>> 13478
>>
>> 73%
>>
>> January 2018
>>
>> 105.7
>>
>> 5039
>>
>> 14878
>>
>> 221781
>>
>> 19917
>>
>> 108%
>>
>> February 2018
>>
>> 119.5
>>
>> 5007
>>
>> 15326
>>
>> 221781
>>
>> 20333
>>
>> 110%
>>
>> March 2018
>>
>> 102.9
>>
>> 4472
>>
>> 14905
>>
>> 221781
>>
>> 19377
>>
>> 105%
>>
>> April 2018
>>
>> 111.6
>>
>> 4394
>>
>> 15947
>>
>> 221781
>>
>> 20341
>>
>> 110%
>>
>> May 2018
>>
>> 118.7
>>
>> 4558
>>
>> 17808
>>
>> 221781
>>
>> 22366
>>
>> 121%
>>
>> June 2018
>>
>> 126.2
>>
>> 4670
>>
>> 18341
>>
>> 221781
>>
>> 23011
>>
>> 125%
>>
>> July 2018
>>
>> 113
>>
>> 4191
>>
>> 17095
>>
>> 221781
>>
>> 21286
>>
>> 115%
>>
>> August 2018
>>
>> 108.1
>>
>> 4086
>>
>> 16271
>>
>> 221781
>>
>> 20357
>>
>> 110%
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
> --
>
> *******************************************
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedberg@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>