Re: [Gnumed-devel] Finally ... monocomponent and multicomponent drug lists for Brazil

[Busser, Jim]

On 2013-06-24, at 7:27 PM, Jim Busser <address@hidden> wrote:

inside which are four "sheets" each named

Lista A Fármacos Isolados
Lista B Associações
Lista A em avaliação
Lista B em avaliação

To me, "Lista A Fármacos Isolados" appears pretty useless because it gives no substance name for the brand and it seems that the second "Lista A" contains all of what is in the first one, while also including the substance names.

The two "Lista B" sheets seem to contain the same information. Is this incorrect?

=====================

Lista A Fármacos Isolados <--- pretty useless, see last comment

=====================

lists in the column "NOME COMERCIAL" the product "FLUIMUCIL" and it seems that this brand is available in

(i) three solid strengths of "gran" (I would imagine "granules"), all sharing a single cell, which will need separating (splitting) using comma "," and "e" as follows

100, 200 e 600 mg

and that this same product is also available in a different form, a "sol spr nas" which is given its own row in the row below -- but with a blank value for the commercial name since they do not bother to repeat it -- and with a concentration of

11,5 mg/mL

but not only are there blank values in the sheet required to be filled in with the value above, but they do not even provide the substance name for these commercial drugs. This at least seems taken care of in the second "Lista A" however this still is missing some repeats in the commercial name, and it also uses the pipe '|' to split multiple concentrations but without repeating the units, for example

0,25 | 0,50 mg/mL

=====================

Lista B Associações

=====================

This lists combinations, with the substances in a single cell separated by spaces and a "+"

ACETATO DE CLORMADINONA + ETINILESTRADIOL

and, in another single cell separated by spaces and a "+"

2mg + 0,03mg

and provides, in separate columns, the "NOME COMERCIAL" and the "FORMA FARMACÊUTICA"

"BELARA", "com rev".

and I notice most (but not all) repeat values of commercial brands are filled in.

-- JIm