Importing Data from Plate Readers: Unfortunate Format #1: "Multiple Boxes"
Mar 15, 2018 6:35 PM
I'm not sure what the most proper name for the format of data is, but I refer to it as, "multiple boxes". In this format each reading of the plate is output into a grid. or box with the row and column label, along with the read number. Each box is separated by one empty row.
There is also an assumption that the raw data starts at A:1, that is, in Excel on the first row of the table in the first column of the table.
The data formatting goal is to convert this format into the minimum number of columns, where there is one variable per column, and one observation per row.
To use the attached script, go into Excel, and select the whole page, and copy it (edit, copy). Then go in to JMP and run the script.
The script has some interesting parts, like it makes a table from the data saved to the clipboard.
All the rest of it is just basic formatting and logic to get the data into a useful shape.
rev 2 note: 2nd version of the script works better