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:622a:115:: with SMTP id u21mr15579870qtw.472.1640629845184;
        Mon, 27 Dec 2021 10:30:45 -0800 (PST)
X-Received: by 2002:a05:6902:727:: with SMTP id l7mr22781787ybt.115.1640629845000;
 Mon, 27 Dec 2021 10:30:45 -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 10:30:44 -0800 (PST)
In-Reply-To: <lytueuufsz.fsf@pushface.org>
Injection-Info: google-groups.googlegroups.com; posting-host=78.141.135.179; posting-account=sDyr7QoAAAA7hiaifqt-gaKY2K7OZ8RQ
NNTP-Posting-Host: 78.141.135.179
References: <7bede061-4b0f-4029-beb1-1056637e57d6n@googlegroups.com> <lytueuufsz.fsf@pushface.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <1b900321-0ef5-4a93-9816-db7ea55d49bfn@googlegroups.com>
Subject: Re: Some advice required [OT]
From: Laurent <lutgenl@icloud.com>
Injection-Date: Mon, 27 Dec 2021 18:30:45 +0000
Content-Type: text/plain; charset="UTF-8"
Xref: reader02.eternal-september.org comp.lang.ada:63283
List-Id: <comp.lang.ada>

On Monday, 27 December 2021 at 18:18:54 UTC+1, Simon Wright wrote:
> Laurent <lut...@icloud.com> writes: 
> 
> > Until now I have been doing it manually by staring for hours at Excel 
> > sheets. I am trying to get it automated but I don't know how to solve 
> > my problem.
> You must go through some mental process while staring at the 
> spreadsheets; what's that process? It can't involve checksums! 
> 

Perhaps not calculating but somehow estimating which has the most R's and considering
the positions they are at. Considering the family of drug it belongs to.

With certain microorganisms it works quite good because they are not very variable.
Others are a real pain. Mostly finding the least resistant with the most in common of
the more resistant and then deleting one after another. Then comparing the leftover ones.

Takes time, high risk of messing up things because I begin to see things which are not there...

> In a post below, you said you had to choose the most resistant, or if 
> different all of them, which doesn't make sense. Are you perhaps 
> thinking of ties? in which case you must have some notion of scoring 
> profiles so you can determine which profiles come equal-first. 
> 
> Does RSSSSS score higher or lower than SIIIII?

That would be 2 different strains which I would keep both.

Thanks

Laurent