TZM-bl Neutralization Module

Study Forum (Inactive)
TZM-bl Neutralization Module awilson  2010-08-18 07:59
Status: Closed
 
Hello, I would like to test out the Nab Module and was curious what the data file template looks like. it only states that "The NAb data file is a specially formatted Excel 1997-2003 file with a .xls extension." but does not offer a glimpse of it.

any suggestions?

aaron
 
 
brittp responded:  2010-08-18 09:29
Hi Aaron,

The module supports two different formats, so I've attached an example of each.
- format1.xls has the plate data in a specific location on the second sheet of the workbook. The 96 wells of plate data must be in exactly the same location every time, spanning cells A7-L14.
- format2.xls is more general- it can have the plate data on any sheet of the workbook, but the rows and columns must be labeled with 1-12 and A-H.

For both formats, only the plate data is read from the file- all other content is ignored. Let me know if you need more info.

Thanks,
Britt
 
eknelson responded:  2010-08-18 10:13
I've added this information to our documentation in a section called "Review plate data file formats" on the following page:
https://www.labkey.org/wiki/home/Documentation/page.view?name=nabAssayTutorial

Thanks,

Elizabeth
 
awilson responded:  2010-08-18 10:17
thanks. this is very helpful. do on format1 does the amount of tabs in the worksheet make a difference or is it mostly the tab titling that makes it?
 
brittp responded:  2010-08-18 10:47
The sheet names aren't considered in either format. For format1, we always just look in cells A7-L14 on the second sheet in the workbook. There can be as many additional sheets as you like after the second. This format is awkward, but luminometer manufacturers provide few guarantees for file format stability over time. In this case, we're reasonably confident that this luminometer will output the plate data in the same location over new software versions, but we're less sure that the rest of the file format will remain fixed.

Thanks,
Britt