Data Manipulation: Worksheet Set Column Values to Reference Other Info in Origin Video Lecture | Origin Tutorials for Beginners - Data & Analytics

in this video I will show you how to use
the set column values dialog we're going
to begin by importing a CSV file in the
options dialog we're going to specify
the number of sub header lines we're
also going to choose the first line of
sub header as the long name and the
second as comments and now we want to
save these settings into the worksheet
itself because we'll save this as a
template we're going to click OK that
data file will come in now what we're
going to do is we're going to add a
second sheet and do some calculations in
this second sheet which has two columns
the first column or X column is going to
be the time values here plus the start
time so we'll add the start time to the
values here and then in our Y column
it'll be a scan which will be sample
minus reference so let's go ahead we
right-click we go to set column values
and now we need to insert a range
variable by selections we can go out and
select this time column now we're given
the range variable here our one in terms
of the worksheet column name as well as
an index because we're saving a template
names could change we're going to delete
that it'll be best to refer to it by
index now we have to also get that start
time that's in the column label row we
can again do this by selection again we
have a string both defined here in
name and index so we're going to keep
things consistent we delete that and
let's use the index so now from this
string we need to get the numeric value
we're going to create a variable of type
double and then from this string we're
going to use the string functions here
we first need to get the eighth most
right points characters and this is
string one and then we need to convert
that string to time
so now in our formula our expression
here it's going to be r1 plus t0 and
let's go ahead and set our recalculate
here to auto now these are numeric
values so if we double click we can
change the format of the column to time
okay now we want to do the calculation
on this column as well and I need to
define again a couple of range variables
here the first one is reference and the
second one is sample we can actually go
ahead and change the name here so this
is our reference range again we're going
to stick to index
and this is sample so then our
expression is sample minus reference I'm
just going to left-click on the lock and
go to change parameters here and our
recalculate is set to auto so they're
both set to auto so that means that
these formulas will automatically run
when data changes in this worksheet here
so let's save this as a template so I'm
going to right click and choose save
template as we're going to call it scan
now we can open up a new instance of
this template under recent books
you can see the template saves the
column label raw information as well as
the formulas if you wanted you could
resave the template deleting this
comments here the comments will be
replaced with the header information
from a new file so if I were to import
another data file notice that it picks
up as the theme the settings in the
sheet the data comes in and in our
second sheet our columns are
automatically populated the formulas
associated with each column were
executed this concludes this
presentation thank you for watching