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 <mohamedal...@gmail.com>
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@lists.launchpad.net
> 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.hedb...@gmail.com
Skype: calle_hedberg
*******************************************
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
