Instead of Excel you can use another spreadsheet that has the ability
to copy and paste from using "tab delimited" text. This means that when
you copy and paste from and into this program it should accept the "tab"
character as a command to go to a new cell and the "enter" character as
a command to go to a new line.
Filter should be one to two characters that represent BAC Filter libraries.
The BAC Calculator currently supports libraries from A to Z and AA, AB,
to AZ. The filter libraries should adhere to the same hashing algorythm
as present filters.
Field can be any uninterupted integer.
Address can be any non-whitespace character.
Position can be any uninterupted integer.
Notes will be anything that is past the numerical position data.
The algorythm is as follows: plate = (position - 1) * 6 + field; final_plate
= plate + (filter - 1) * 48.
The final output is in the format final_plate immediately followed
by the address and then the notes included with the sample. For example
532D9 or 12o5.
WSU Barley Genomics suggests that you use all caps in your data, except
use a lower case 'o'. This will help prevent misreading.