mohamadine
(Mohamadine Aly MAIGA )
8 September 2018 15:20
1
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%
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
···
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@gmail.com
Skype: calle_hedberg
mohamadine
(Mohamadine Aly MAIGA )
8 September 2018 22:22
3
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@gmail.com 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@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.hedberg@gmail.com
Skype: calle_hedberg