From: Laurent <lutgenl@icloud.com>
Subject: Re: Some advice required [OT]
Date: Mon, 27 Dec 2021 04:29:06 -0800 (PST) [thread overview]
Message-ID: <49538254-21ed-4fd0-8316-1bccc7d3c635n@googlegroups.com> (raw)
In-Reply-To: <j2tlk8FneraU1@mid.individual.net>
On Monday, 27 December 2021 at 12:16:27 UTC+1, Niklas Holsti wrote:
> Sorry, but I found your problem description impossible to understand.
> Try to describe more clearly the experiment that is done, the structure
> of the data the experiment provides (the meaning of the Excel rows and
> columns), and the statistic you want to compute.
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 = Sensible
I = Intermediate
R = Resistant
empty cell <S<I<R
If a patient has 3 strains of the same microorganism but with different resistance 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. Checksum with/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 will again be the same.
How to decide which result to choose.
Would be easier to attach the Excel file directly.
> Also, if you do not intend to implement the solution in Ada, this is not
> the right group to discuss it.
I would very much prefer to solve it in Ada but at work I am stuck with Excel 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 any place where I would get usable advice.
Here at least I know that there are no trolls or whatever. Perhaps some miscommunication because I thought my
explanation was clear but it wasn't because of missing context.
I am lurking in this group for some time. Just gave up on using Ada
Thanks
Laurent
next prev parent reply other threads:[~2021-12-27 12:29 UTC|newest]
Thread overview: 25+ messages / expand[flat|nested] mbox.gz Atom feed top
2021-12-27 9:21 Some advice required [OT] Laurent
2021-12-27 11:16 ` Niklas Holsti
2021-12-27 12:29 ` Laurent [this message]
2021-12-27 13:14 ` Ben Bacarisse
2021-12-27 18:24 ` Laurent
2021-12-27 19:51 ` Dennis Lee Bieber
2021-12-27 20:49 ` Ben Bacarisse
2021-12-27 22:09 ` Laurent
2021-12-28 0:29 ` Ben Bacarisse
2021-12-28 7:48 ` Laurent
2021-12-28 9:05 ` Laurent
2021-12-28 12:54 ` Laurent
2021-12-28 13:57 ` Ben Bacarisse
2021-12-28 18:19 ` Laurent
2021-12-28 13:43 ` Ben Bacarisse
2021-12-28 16:49 ` Dennis Lee Bieber
2021-12-29 4:20 ` Randy Brukardt
2021-12-27 17:41 ` Dennis Lee Bieber
2021-12-27 18:56 ` Niklas Holsti
2021-12-27 19:44 ` Laurent
2021-12-28 2:10 ` Randy Brukardt
2021-12-28 6:02 ` Laurent
2021-12-29 3:58 ` Randy Brukardt
2021-12-27 17:18 ` Simon Wright
2021-12-27 18:30 ` Laurent
replies disabled
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox