search

bthuronyi / CloneCoordinate

CloneCoordinate issue tracking
1 stars 0 forks source link

Assembly transformations resulting in no colonies should give a "stalled" statuses, rather than trying transformation again #259

Open ethanjeon opened 2 hours ago

ethanjeon commented 2 hours ago

proposed by @bthuronyi

Inserted a check for zero colonies following a single transformation FALSE,"bulky addition of volume check for retransformations", and(regexmatch(H3,"(retransform)"),counta(iferror(filter(Transformations_Source_ID,Transformations_Source_ID=B3,Transformations_Date_transformed<>"")))<2),if( and(N3<>"",sum(iferror(arrayformula(value(split(textjoin(", ",TRUE,filter(Transformations_Transformed_amount,Transformations_Source_ID=B3)),", "))),0))>=N3),"ran out!",if( iferror(regexmatch(index(Transformations_Colony_counts,xmatch(B3,Transformations_Source_ID)),"no")),"stalled - no colonies after transformation","ready to transform"&char(10)&"(repeat)")), counta(iferror(filter(Transformations_Source_ID,Transformations_Source_ID=B3,Transformations_Date_transformed="")))>0,if( and(N3<>"",sum(iferror(arrayformula(value(split(textjoin(", ",TRUE,filter(Transformations_Transformed_amount,Transformations_Source_ID=B3)),", "))),0))>=N3),"ran out!",if( iferror(regexmatch(index(Transformations_Colony_counts,xmatch(B3,Transformations_Source_ID)),"no")),"stalled - no colonies after transformation","ready to transform"&char(10)&"(repeat)")),

ethanjeon commented 2 hours ago

So the new parts are the if( iferror(regexmatch(index(Transformations_Colony_counts,xmatch(B3,Transformations_Source_ID)),"no")),"stalled - no colonies after transformation","ready to transform"&char(10)&"(repeat)")

ethanjeon commented 2 hours ago

Successful detection proven with samples like a926, which now give the stalled status instead of "ready to transform (repeat)"

ethanjeon commented 1 hour ago

wait a minute it doesnt work

ethanjeon commented 1 hour ago

oh no

ethanjeon commented 1 hour ago

ok i'm going to come back to this, assemblies status needs a little more overhaul (reordering) :(