...
Alex Buerkle used the complicated TN spreadsheet to create a list of tubes that need to be amplicon sequenced. Shannon Harris had already arranged the tubes they had sent and transcribed the hand written labels into a spreadsheet and added them to 96 tube racks. I attempted to reconcile the tobeplated list from Alex’s data manipulation with this using this r-script and these data. I was able to locate 293 of the 303 tobeplated tubes and created a pull list. I found one transcription error. There are still 10 tubes I could not locate:
...