From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on
	ip-172-31-74-118.ec2.internal
X-Spam-Level: 
X-Spam-Status: No, score=0.8 required=3.0 tests=BAYES_50,FREEMAIL_FROM
	autolearn=ham autolearn_force=no version=3.4.6
X-Received: by 2002:a05:620a:2596:: with SMTP id x22mr11606666qko.408.1640608146984;
        Mon, 27 Dec 2021 04:29:06 -0800 (PST)
X-Received: by 2002:a05:6902:1246:: with SMTP id t6mr21398578ybu.305.1640608146764;
 Mon, 27 Dec 2021 04:29:06 -0800 (PST)
Path: eternal-september.org!reader02.eternal-september.org!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.ada
Date: Mon, 27 Dec 2021 04:29:06 -0800 (PST)
In-Reply-To: <j2tlk8FneraU1@mid.individual.net>
Injection-Info: google-groups.googlegroups.com; posting-host=213.166.55.173; posting-account=sDyr7QoAAAA7hiaifqt-gaKY2K7OZ8RQ
NNTP-Posting-Host: 213.166.55.173
References: <7bede061-4b0f-4029-beb1-1056637e57d6n@googlegroups.com> <j2tlk8FneraU1@mid.individual.net>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <49538254-21ed-4fd0-8316-1bccc7d3c635n@googlegroups.com>
Subject: Re: Some advice required [OT]
From: Laurent <lutgenl@icloud.com>
Injection-Date: Mon, 27 Dec 2021 12:29:06 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Xref: reader02.eternal-september.org comp.lang.ada:63275
List-Id: <comp.lang.ada>

On Monday, 27 December 2021 at 12:16:27 UTC+1, Niklas Holsti wrote:

> Sorry, but I found your problem description impossible to understand.=20
> Try to describe more clearly the experiment that is done, the structure=
=20
> of the data the experiment provides (the meaning of the Excel rows and=20
> columns), and the statistic you want to compute.=20

Sorry tried to keep it short, was too short.

Columns are the antimicrobial drugs
Rows are the microorganism.

So every cell contains a result of S, I, R or simply an empty cell

S =3D Sensible
I =3D Intermediate
R =3D Resistant

empty cell <S<I<R

If a patient has 3 strains of the same microorganism but with different res=
istance profiles
I have to find the most resistant one. Or if they are different I keep them=
 all.

I have no idea how to explain what I am doing to the compiler.
Why I would choose result from strain B over the result from strain A.

strain A: SSSRSS
strain B: SSRRRS

Simply counting the number of S, I and R doesn't work. =E2=80=8BChecksum wi=
th/without weight for the column number doesn't
work either.

Even if I get a correct result I have still the same problem as before why =
result B over result A.

Thought about building a tree for every family of drugs but the problem wil=
l again be the same.
How to decide which result to choose.=20

Would be easier to attach the Excel file directly.=20

> Also, if you do not intend to implement the solution in Ada, this is not=
=20
> the right group to discuss it.

I would very much prefer to solve it in Ada but at work I am stuck with Exc=
el and VBA which is better than
doing it manually. After a few hours starring at a screen with thousand of =
rows of results...
If I get an Ada solution I can adapt it. Just limited to no access/pointers=
 in VBA which shouldn't be required?

I know this is the wrong group to discuss, unfortunately I don't know of an=
y place where I would get usable advice.
Here at least I know that there are no trolls or whatever. Perhaps some mis=
communication because I thought my
explanation was clear but it wasn't because of missing context.=20

I am lurking in this group for some time. Just gave up on using Ada

Thanks

Laurent