Re: Some advice required [OT]

[Laurent <lutgenl@icloud.com>]

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