Sartorius BioPAT Trace - Data Transfer to Excel Using an Excel Macro

BioPAT
®
Trace | Multi Trace Operating Instructions 115
Operation
8.5.6 Data Transfer to Excel Using an
ExcelMacro
Alternatively to the manual procedure the data
can be transferred to excel using the macro
“Macro_bpd.xlsm”. This macro is stored in the
device’s data memory and can be accessed via
the internal device website (see Chapter
“6.4 Loading the Software and Network
Connection”, page 63). This macro
automatically creates a table and a graph.
Procedure:
t Copy “xx.bpd” and “Macro_bpd.xlsm”
in a new folder
t Rename “xx.bpd” as “data.bpd”
t Open “Macro_bpd.xlsm”
t Start macro with “Ctrl+M”
y Creates a file with table and graph
t Stored as Data_Trace_YYYY_MM_DD.xlsm