view · edit · sidebar · attach · print · history

< Niklaus.20170224-virbac | Index | Niklaus.20170221-price-history-links >>

20170222-alternative-ddd-calculation

Summary

Commits

Index

Alternative DDD calculation

Mr. Walliman has a list of about 50 drugs with an alternative DDD calculation. In these cases we may not refer to the WHO guidelines. But first I must improve the unit test for the DDD calculation to test all calculations. Done with commit Minimize and test ddd_calculation

Also remarked that I must display a reason, when I was unable to calculate the DDD cost. Eg. http://ch.oddb.org/de/gcc/ddd_price/reg/46452/seq/04/pack/038/search_query/augmentin+1+g+%28875%252F125%29/search_type/st_oddb displays no calculation, but only the DDD cost for some alternatives. But in this case the error stemmed from the fact that there was another ROA used. Should we also display the used ROA? Fixed the display with commit Explain absence of DDD price

Also remarked that it should be possible to easily correct some of the errors flagged while exporting

:!registration,36030!sequence,03!package,011.: Collu-Blache, Rachenspray Could not convert 0.6 mg/ml/ml
:!registration,36030!sequence,03!package,011.: Collu-Blache, Rachenspray Could not convert 0.5 mg/ml/ml
:!registration,36631!sequence,02!package,067.: Penicillin Spirig HC 1 Mio U.I., Filmtabletten Could not convert 1 Mio UI
:!registration,36631!sequence,02!package,067.: Penicillin Spirig HC 1 Mio U.I., Filmtabletten Could not convert 1 Mio UI
:!registration,36631!sequence,02!package,068.: Penicillin Spirig HC 1 Mio U.I., Filmtabletten Could not convert 1 Mio UI
:!registration,36631!sequence,02!package,068.: Penicillin Spirig HC 1 Mio U.I., Filmtabletten Could not convert 1 Mio UI
:!registration,36631!sequence,02!package,069.: Penicillin Spirig HC 1 Mio U.I., Filmtabletten Could not convert 1 Mio UI
:!registration,36631!sequence,02!package,069.: Penicillin Spirig HC 1 Mio U.I., Filmtabletten Could not convert 1 Mio UI
:!registration,37523!sequence,01!package,011.: Ospen 1000, Filmtabletten Could not convert 1 Mio UI
:!registration,37523!sequence,01!package,011.: Ospen 1000, Filmtabletten Could not convert 1 Mio UI
:!registration,37523!sequence,01!package,038.: Ospen 1000, Filmtabletten Could not convert 1 Mio UI
:!registration,37523!sequence,01!package,038.: Ospen 1000, Filmtabletten Could not convert 1 Mio UI
:!registration,37523!sequence,02!package,054.: Ospen 1500, Filmtabletten Could not convert 1.5 Mio UI
:!registration,37523!sequence,02!package,054.: Ospen 1500, Filmtabletten Could not convert 1.5 Mio UI
:!registration,37523!sequence,02!package,062.: Ospen 1500, Filmtabletten Could not convert 1.5 Mio UI
:!registration,37523!sequence,02!package,062.: Ospen 1500, Filmtabletten Could not convert 1.5 Mio UI
:!registration,38212!sequence,05!package,095.: Calciparine 5'000 U.I., solution injectable s.c. Could not convert 5000U.I. / 0.2ml
:!registration,38212!sequence,05!package,095.: Calciparine 5'000 U.I., solution injectable s.c. Could not convert 5000U.I. / 0.2ml
:!registration,41022!sequence,01!package,027.: Heparin Fresenius, Injektionslösung Could not convert 25000U.I. / 5ml
:!registration,41022!sequence,01!package,027.: Heparin Fresenius, Injektionslösung Could not convert 25000U.I. / 5ml
:!registration,47249!sequence,03!package,015.: Fragmin 2'500 I.E./0.2 mL, Injektionslösung Could not convert 2500U.I. / 0.2ml
:!registration,47249!sequence,03!package,015.: Fragmin 2'500 I.E./0.2 mL, Injektionslösung Could not convert 2500U.I. / 0.2ml
:!registration,47249!sequence,04!package,031.: Fragmin 5'000 I.E./0.2 mL, Injektionslösung Could not convert 5000U.I. / 0.2ml
:!registration,47249!sequence,04!package,031.: Fragmin 5'000 I.E./0.2 mL, Injektionslösung Could not convert 5000U.I. / 0.2ml
:!registration,47249!sequence,06!package,120.: Fragmin 100'000 I.E./4 mL, Injektionslösung Could not convert 100000U.I. / 4ml
:!registration,47249!sequence,06!package,120.: Fragmin 100'000 I.E./4 mL, Injektionslösung Could not convert 100000U.I. / 4ml
:!registration,47249!sequence,07!package,139.: Fragmin 7'500 I.E./0,3 mL, Injektionslösung Could not convert 7500U.I. / 0.3ml
:!registration,47249!sequence,07!package,139.: Fragmin 7'500 I.E./0,3 mL, Injektionslösung Could not convert 7500U.I. / 0.3ml
:!registration,47249!sequence,08!package,147.: Fragmin 10'000 I.E./0,4 mL, Injektionslösung Could not convert 10000U.I. / 0.4ml
:!registration,47249!sequence,08!package,147.: Fragmin 10'000 I.E./0,4 mL, Injektionslösung Could not convert 10000U.I. / 0.4ml
:!registration,47249!sequence,09!package,155.: Fragmin 12'500 I.E./0,5 mL, Injektionslösung Could not convert 12500U.I. / 0.5ml
:!registration,47249!sequence,09!package,155.: Fragmin 12'500 I.E./0,5 mL, Injektionslösung Could not convert 12500U.I. / 0.5ml
:!registration,47249!sequence,10!package,163.: Fragmin 15'000 I.E./0,6 mL, Injektionslösung Could not convert 15000U.I. / 0.6ml
:!registration,47249!sequence,10!package,163.: Fragmin 15'000 I.E./0,6 mL, Injektionslösung Could not convert 15000U.I. / 0.6ml
:!registration,47249!sequence,11!package,171.: Fragmin 18'000 I.E./0,72 mL, Injektionslösung Could not convert 18000U.I. / 0.72ml
:!registration,47249!sequence,11!package,171.: Fragmin 18'000 I.E./0,72 mL, Injektionslösung Could not convert 18000U.I. / 0.72ml
:!registration,47249!sequence,03!package,198.: Fragmin 2'500 I.E./0.2 mL, Injektionslösung Could not convert 2500U.I. / 0.2ml
:!registration,47249!sequence,03!package,198.: Fragmin 2'500 I.E./0.2 mL, Injektionslösung Could not convert 2500U.I. / 0.2ml
:!registration,47249!sequence,04!package,201.: Fragmin 5'000 I.E./0.2 mL, Injektionslösung Could not convert 5000U.I. / 0.2ml
:!registration,47249!sequence,04!package,201.: Fragmin 5'000 I.E./0.2 mL, Injektionslösung Could not convert 5000U.I. / 0.2ml
:!registration,49078!sequence,18!package,804.: Eprex 1000 U, Injektionslösung (Fertigspritzen) Could not convert 1000U.I. / 0.5ml
:!registration,49078!sequence,18!package,804.: Eprex 1000 U, Injektionslösung (Fertigspritzen) Could not convert 1000U.I. / 0.5ml
:!registration,49078!sequence,19!package,805.: Eprex 2000 U, Injektionslösung (Fertigspritzen) Could not convert 2000U.I. / 0.5ml
:!registration,49078!sequence,19!package,805.: Eprex 2000 U, Injektionslösung (Fertigspritzen) Could not convert 2000U.I. / 0.5ml
:!registration,49078!sequence,20!package,806.: Eprex 3000 U, Injektionslösung (Fertigspritzen) Could not convert 3000U.I. / 0.3ml
:!registration,49078!sequence,20!package,806.: Eprex 3000 U, Injektionslösung (Fertigspritzen) Could not convert 3000U.I. / 0.3ml
:!registration,49078!sequence,21!package,807.: Eprex 4000 U, Injektionslösung (Fertigspritzen) Could not convert 4000U.I. / 0.4ml
:!registration,49078!sequence,21!package,807.: Eprex 4000 U, Injektionslösung (Fertigspritzen) Could not convert 4000U.I. / 0.4ml
:!registration,49078!sequence,36!package,809.: Eprex 20000 U, Injektionslösung (Fertigspritzen) Could not convert 20000U.I. / 0.5ml
:!registration,49078!sequence,36!package,809.: Eprex 20000 U, Injektionslösung (Fertigspritzen) Could not convert 20000U.I. / 0.5ml
:!registration,49078!sequence,38!package,812.: Eprex 5000 U, Injektionslösung (Fertigspritzen) Could not convert 5000U.I. / 0.5ml
:!registration,49078!sequence,38!package,812.: Eprex 5000 U, Injektionslösung (Fertigspritzen) Could not convert 5000U.I. / 0.5ml
:!registration,49078!sequence,39!package,813.: Eprex 6000 U, Injektionslösung (Fertigspritzen) Could not convert 6000U.I. / 0.6ml
:!registration,49078!sequence,39!package,813.: Eprex 6000 U, Injektionslösung (Fertigspritzen) Could not convert 6000U.I. / 0.6ml
:!registration,49078!sequence,41!package,814.: Eprex 8000 U, Injektionslösung (Fertigspritzen) Could not convert 8000U.I. / 0.8ml
:!registration,49078!sequence,41!package,814.: Eprex 8000 U, Injektionslösung (Fertigspritzen) Could not convert 8000U.I. / 0.8ml
:!registration,49078!sequence,43!package,815.: Eprex 30000 U, Injektionslösung (Fertigspritzen) Could not convert 30000U.I. / 0.75ml
:!registration,49078!sequence,43!package,815.: Eprex 30000 U, Injektionslösung (Fertigspritzen) Could not convert 30000U.I. / 0.75ml
:!registration,49078!sequence,43!package,816.: Eprex 30000 U, Injektionslösung (Fertigspritzen) Could not convert 30000U.I. / 0.75ml
:!registration,49078!sequence,43!package,816.: Eprex 30000 U, Injektionslösung (Fertigspritzen) Could not convert 30000U.I. / 0.75ml
:!registration,51035!sequence,01!package,143.: Neupogen Amgen 30, Injektionslösung Could not convert 30 Mio U/ml
:!registration,51035!sequence,01!package,143.: Neupogen Amgen 30, Injektionslösung Could not convert 30 Mio U/ml
:!registration,51035!sequence,06!package,186.: Neupogen Amgen 30, Fertigspritzen Could not convert 30Mio. U. / 0.5ml
:!registration,51035!sequence,06!package,186.: Neupogen Amgen 30, Fertigspritzen Could not convert 30Mio. U. / 0.5ml
:!registration,51035!sequence,07!package,208.: Neupogen Amgen 48, Fertigspritzen Could not convert 48Mio. U. / 0.5ml
:!registration,51035!sequence,07!package,208.: Neupogen Amgen 48, Fertigspritzen Could not convert 48Mio. U. / 0.5ml
:!registration,51795!sequence,01!package,040.: Aspirin Cardio 100, Filmtabletten Could not convert 1 tablet
:!registration,51795!sequence,03!package,059.: Aspirin Cardio 300, Filmtabletten Could not convert 1 tablet
:!registration,51795!sequence,03!package,067.: Aspirin Cardio 300, Filmtabletten Could not convert 1 tablet
:!registration,51795!sequence,01!package,068.: Aspirin Cardio 100, Filmtabletten Could not convert 1 tablet
:!registration,51795!sequence,01!package,069.: Aspirin Cardio 100, Filmtabletten Could not convert 1 tablet
:!registration,52189!sequence,01!package,012.: Tiatral 100 SR, Tabletten Could not convert 1 tablet
:!registration,52189!sequence,01!package,020.: Tiatral 100 SR, Tabletten Could not convert 1 tablet
:!registration,53568!sequence,07!package,084.: Roferon-A 3 Mio I.E./0,5 mL, Injektionslösung Could not convert 3Mio U.I. / 0.5ml
:!registration,53568!sequence,07!package,084.: Roferon-A 3 Mio I.E./0,5 mL, Injektionslösung Could not convert 3Mio U.I. / 0.5ml
:!registration,55197!sequence,02!package,007.: Cardiax ASS 100, Filmtabletten Could not convert 1 tablet
:!registration,55197!sequence,02!package,008.: Cardiax ASS 100, Filmtabletten Could not convert 1 tablet
:!registration,56689!sequence,01!package,007.: Gonal-f PEN 300 U.I./0.5 ml, Injektionslösung Could not convert 300U.I. / 0.5ml
:!registration,56689!sequence,01!package,007.: Gonal-f PEN 300 U.I./0.5 ml, Injektionslösung Could not convert 300U.I. / 0.5ml
:!registration,56689!sequence,02!package,008.: Gonal-f PEN 450 U.I./0.75 ml, Injektionslösung Could not convert 450U.I. / 0.75ml
:!registration,56689!sequence,02!package,008.: Gonal-f PEN 450 U.I./0.75 ml, Injektionslösung Could not convert 450U.I. / 0.75ml
:!registration,56689!sequence,03!package,009.: Gonal-f PEN 900 U.I./1.5 ml, Injektionslösung Could not convert 900U.I. / 1.5ml
:!registration,56689!sequence,03!package,009.: Gonal-f PEN 900 U.I./1.5 ml, Injektionslösung Could not convert 900U.I. / 1.5ml
:!registration,57428!sequence,01!package,001.: Aldurazyme, Concentré à diluer pour perfusion Could not convert 500U.I. / 5ml
:!registration,57428!sequence,01!package,001.: Aldurazyme, Concentré à diluer pour perfusion Could not convert 500U.I. / 5ml
:!registration,59055!sequence,01!package,001.: Binocrit 1000 IE/0,5 ml, Injektionslösung in Fertigspritzen Could not convert 1000U.I. / 0.5ml
:!registration,59055!sequence,01!package,001.: Binocrit 1000 IE/0,5 ml, Injektionslösung in Fertigspritzen Could not convert 1000U.I. / 0.5ml
:!registration,59055!sequence,03!package,003.: Binocrit 3000 IE/0,3 ml, Injektionslösung in Fertigspritzen Could not convert 3000U.I. / 0.3ml
:!registration,59055!sequence,03!package,003.: Binocrit 3000 IE/0,3 ml, Injektionslösung in Fertigspritzen Could not convert 3000U.I. / 0.3ml
:!registration,59055!sequence,04!package,004.: Binocrit 4000 IE/0,4 ml, Injektionslösung in Fertigspritzen Could not convert 4000U.I. / 0.4ml
:!registration,59055!sequence,04!package,004.: Binocrit 4000 IE/0,4 ml, Injektionslösung in Fertigspritzen Could not convert 4000U.I. / 0.4ml
:!registration,59055!sequence,05!package,005.: Binocrit 5000 IE/0,5 ml, Injektionslösung in Fertigspritzen Could not convert 5000U.I. / 0.5ml
:!registration,59055!sequence,05!package,005.: Binocrit 5000 IE/0,5 ml, Injektionslösung in Fertigspritzen Could not convert 5000U.I. / 0.5ml
:!registration,59055!sequence,06!package,006.: Binocrit 6000 IE/0,6 ml, Injektionslösung in Fertigspritzen Could not convert 6000U.I. / 0.6ml
:!registration,59055!sequence,06!package,006.: Binocrit 6000 IE/0,6 ml, Injektionslösung in Fertigspritzen Could not convert 6000U.I. / 0.6ml
:!registration,59055!sequence,07!package,007.: Binocrit 7000 IE/0,7 ml, Injektionslösung in Fertigspritzen Could not convert 7000U.I. / 0.7ml
:!registration,59055!sequence,07!package,007.: Binocrit 7000 IE/0,7 ml, Injektionslösung in Fertigspritzen Could not convert 7000U.I. / 0.7ml
:!registration,59055!sequence,08!package,008.: Binocrit 8000 IE/0,8 ml, Injektionslösung in Fertigspritzen Could not convert 8000U.I. / 0.8ml
:!registration,59055!sequence,08!package,008.: Binocrit 8000 IE/0,8 ml, Injektionslösung in Fertigspritzen Could not convert 8000U.I. / 0.8ml
:!registration,59055!sequence,09!package,009.: Binocrit 9000 IE/0,9 ml, Injektionslösung in Fertigspritzen Could not convert 9000U.I. / 0.9ml
:!registration,59055!sequence,09!package,009.: Binocrit 9000 IE/0,9 ml, Injektionslösung in Fertigspritzen Could not convert 9000U.I. / 0.9ml
:!registration,60722!sequence,01!package,001.: Filgrastim-Teva 30 / 0.5 ml, Injektionslösung in Fertigspritzen Could not convert 30Mio. U. / 0.5ml
:!registration,60722!sequence,01!package,001.: Filgrastim-Teva 30 / 0.5 ml, Injektionslösung in Fertigspritzen Could not convert 30Mio. U. / 0.5ml
:!registration,60722!sequence,01!package,002.: Filgrastim-Teva 30 / 0.5 ml, Injektionslösung in Fertigspritzen Could not convert 30Mio. U. / 0.5ml
:!registration,60722!sequence,01!package,002.: Filgrastim-Teva 30 / 0.5 ml, Injektionslösung in Fertigspritzen Could not convert 30Mio. U. / 0.5ml
:!registration,60722!sequence,02!package,004.: Filgrastim-Teva 48 / 0.8 ml, Injektionslösung in Fertigspritzen Could not convert 48Mio. U. / 0.8ml
:!registration,60722!sequence,02!package,004.: Filgrastim-Teva 48 / 0.8 ml, Injektionslösung in Fertigspritzen Could not convert 48Mio. U. / 0.8ml
:!registration,60722!sequence,02!package,005.: Filgrastim-Teva 48 / 0.8 ml, Injektionslösung in Fertigspritzen Could not convert 48Mio. U. / 0.8ml
:!registration,60722!sequence,02!package,005.: Filgrastim-Teva 48 / 0.8 ml, Injektionslösung in Fertigspritzen Could not convert 48Mio. U. / 0.8ml
:!registration,62784!sequence,01!package,002.: ASS Cardio-Mepha, Filmtabletten Could not convert 1 tablet
:!registration,62784!sequence,01!package,006.: ASS Cardio-Mepha, Filmtabletten Could not convert 1 tablet
:!registration,62784!sequence,01!package,007.: ASS Cardio-Mepha, Filmtabletten Could not convert 1 tablet
:!registration,66097!sequence,01!package,001.: ASS Cardio Spirig HC 100 mg, Filmtabletten Could not convert 1 tablet
:!registration,66097!sequence,01!package,002.: ASS Cardio Spirig HC 100 mg, Filmtabletten Could not convert 1 tablet
:!registration,66097!sequence,01!package,004.: ASS Cardio Spirig HC 100 mg, Filmtabletten Could not convert 1 tablet
:!registration,66097!sequence,01!package,005.: ASS Cardio Spirig HC 100 mg, Filmtabletten Could not convert 1 tablet

Creating unit tests and fixing the missing conversions from quanties to units understood by ruby-units. Also fixing the problem with 1 tablet which stems from the fact, that we did not handle correctly the ROA OIndependent of strength.

The only remaining problems when exporting the DDD are

:!registration,36030!sequence,03!package,011.: Collu-Blache, Rachenspray Could not convert 0.6 mg/ml/ml
:!registration,36030!sequence,03!package,011.: Collu-Blache, Rachenspray Could not convert 0.5 mg/ml/ml

But this is a different problem, because parsing the composition should not have resulted in a dose of mg/ml/ml.

Looking at the generated ddd.csv I see that we suddenly have a daily cost of 0.00 for products name Nicorette. Why? They do not have a PricePublic and should therefore be excluded. Fixed this problem by not simply returning by default the first roa if there is no roa_0, but only 'OIndependent of strength'.

Also not calculating DDD cost when the price_public is 0.

Pushed commit Fix converting some units for DDD_price and ROA independent of strength

Using existing script and adapt to check all reported errors by Mr.Wallimann. My local patch correct 181 of the 224, has 10 with differences < 10 %. There are 32 errors which I must investigate. Also it changed in total over 253 prices. Therefore I am very unsure which errors I introduced.

After considering the multi field in the variant 14 I am down to 15 errors. One was easy to fix by upping the limit of DDD cost from 10'000 to 20'000/day.

Fixed all regressions introduced by wrong handling of retard tablets. Also changing implementation of tables to be taken once a week with commit Revert handling of retard tablets. Fix Wochentabletten

The Tageskosten of http://ch.oddb.org/de/gcc/ddd_price/reg/58691/seq/01/pack/001/search_query/Alendronat/search_type/st_sequence display items which are no longer active lik Alendronat Mylan. Fixed with commit Don't display inactive package in ddd_chart

Okay. I think I could have achieved the same result for the Wochentablette if I had looked at the package.name, eg. Alendron D3-Mepha 70/2800, Wochentabletten

view · edit · sidebar · attach · print · history
Page last modified on February 22, 2017, at 06:35 PM