beautypg.com

Chapter 6 data export and analysis, 1 file types, 2 export to microsoft excel software – Bio-Rad PROTEAN® i12™ IEF System User Manual

Page 35: R 6 data export and analysis, Data export and analysis

background image

PROTEAN i12 IEF System Instruction Manual

| 31

Data Export and
Analysis

6

6.1 File Types

PROTEAN

®

i12

software stores three types of files:

.dat — run data files, which contain a record of the protocols run, IPG-strip– or
sample-specific information entered by the user, and a continuous record for
each IPG strip of current, voltage, temperature, and V-hr accumulated, as well
as metadata such as the date, time, instrument serial number, firmware, and
software version

.prt — protocol files

.smp — sample files

Run data files (.dat) can be viewed and manipulated using either Microsoft Excel
software or the PROTEAN i12 Reporter web-based application.

6.2 Export to Microsoft Excel Software

To export data to Excel software:

1. Follow the directions in Section 5.2.2, Copying Files, to copy run data files to

the USB flash drive.

2. Transfer the USB flash drive to a computer (PC) and launch Microsoft Excel.

3. Select File > Open. In the Open dialog, select All Files as the file type. Find

and click the .dat file to select it, then click Open.

4. In the Text Import Wizard, choose Delimited as the file type option, then

click Next and select comma as the delimiter. The .dat file information
appears in an Excel worksheet.