Méthode de calcul DHIS2

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
©

Total dose BCG
Numérateur
(A+B)

BCG Coverage <1y
(A+B) / [©/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


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
©

Total dose BCG
Numérateur
(A+B)

BCG Coverage <1y
(A+B) / [©/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