Information Commands

group”.“label”
group”:“label“
BUTTON
BUTTON NAME
CELL
CELL_STRING
CODE
CODE ID
COUNT
END
END TIME
FROM
GROUP
INDEX
INDEX OF
INSTANCES
INSTANCES2
INSTANCE[x]
LABEL
LABEL IN
LABEL_IN_GROUP
LABELS
LABELS IN
LENGTH
LIMIT
LOOKUP
NOT OPEN
OPEN
OVERLAP
OVERLAP_LENGTH
RANGE
ROW
ROW_NAME
START
START TIME
TIME
UNIQUE
WHERE


group”.“label”

Will return instances match­ing this label.

Format: string1.string2

Arguments: string1: A string in quotes rep­re­sent­ing the group name string2: A string in quotes rep­re­sent­ing the label name. If emp­ty it will match any label

Available: Available for all win­dows Version: 9 and later

Example: 

show count team”.“player1“
Returns the num­ber of instances that have the label team▶player


group”:“label”

Will return labels match­ing this label. If an instance has 3 match­es it will return the instance 3 times.

Format: string1:string2

Arguments: string1: A string in quotes rep­re­sent­ing the group name string2: A string in quotes rep­re­sent­ing the label name. If emp­ty it will match any label

Available: Available for all win­dows Version: 9 and later

Example:

show count team”.“player1“
Returns the num­ber of occur­rences that have the label team▶player


BUTTON

Grabs the out­put from anoth­er but­ton using an identifier

Format: BUTTON button_​identifier OR BUTTON button_​identifier IN WINDOW window_​name OR @button_identifier

Arguments: button_​identifier: a string with the iden­ti­fi­er of a but­ton in the code input win­dow window_​name: the name of the code input window

Available: Available for code win­dows Version: 9 and later

Example: 

BUTTON another_​button“
Returns the out­put from the but­ton with the iden­ti­fi­er another_​button” in the same window

@“another_button“
Returns the out­put from the but­ton with the iden­ti­fi­er another_​button” in the same window


BUTTON NAME

Grabs the name from anoth­er but­ton using an identifier

Format: BUTTON NAME button_​identifier OR BUTTON NAME button_​identifier IN WINDOW window_​name OR #button_​identifier

Arguments: button_​identifier: a string with the iden­ti­fi­er of a but­ton in the code input win­dow window_​name: the name of the code input window

Available: Available for code win­dows Version: 9 and later

Example: 

BUTTON NAME another_​button“
Returns the name from the but­ton with the iden­ti­fi­er another_​button” in the same window

SHOW BUTTON #“another_​button” STATE
Shows the state from the but­ton with the iden­ti­fi­er another_​button” in the same window


CELL

Grabs the out­put from anoth­er cell in the window

Format: CELL reference

Arguments: ref­er­ence: ( col­umn num­ber or col­umn title , row num­ber ) or quot­ed text rep­re­sent­ing a cell or col­umn title

Available: Available for spread­sheet win­dows Version: 9 and later

Example:

show cell (2,1)
Returns the out­put from the cell in col­umn 2, row 1

show cell my cell title“
Returns the out­put from the cell which has a title my cell title” 

show cell my col­umn title“
Returns the cell which has a col­umn title of my col­umn title” on this cell’s row 

show cell ( Column 1” , 3 )
Returns the cell which has a col­umn title of Column 1” on row 3 

show cell ( $col­umn-1, $row+2 )
Returns the con­tents of the cell 1 row left and 2 rows down 

show cell ( Column 2” , $row-2 )
Returns the con­tents of the cell which has a col­umn title of Column 2” and 2 rows up from this cell


CELL_STRING

Grabs the out­put from anoth­er cell in the win­dow as a string

Format: CELL_STRING reference

Arguments: ref­er­ence: ( col­umn num­ber or col­umn title , row num­ber ) or quot­ed text rep­re­sent­ing a cell or col­umn title

Available: Available for spread­sheet win­dows Version: 9 and later

Example:

show cell_​string (2,1)
Returns the out­put from the cell in col­umn 2, row 1 as a string (even if the cell has as a number) 

show cell_​string my cell title“
Returns the out­put from the cell which has a title my cell title” as a string 

show cell_​string my col­umn title“
Returns the cell which has a col­umn title of my col­umn title” on this cell’s row as a string 

show cell_​string ( Column 1” , 3 )
Returns the cell which has a col­umn title of Column 1” on row 3 as a string 

show cell_​string ( $col­umn-1, $row+2 )
Returns the string from the cell 1 row left and 2 rows down 

show cell_​string ( Column 2” , $row-2 )
Returns the string from the cell which has a col­umn title of Column 2” and 2 rows up from this cell


CODE

Grabs the out­put from anoth­er but­ton using a name

Format:
CODE button_​name OR
CODE button_​name IN WINDOW window_name

Arguments:
button_​name: a string with the name of a but­ton in the code input win­dow
window_​name: the name of the code input window

Available:
Available for code win­dows
Version: 9 and later

Example:

CODE another_​button“
Returns the out­put from the but­ton with the name another_​button” in the same window


CODE ID

Grabs the iden­ti­fi­er from anoth­er but­ton using a name

Format: CODE ID button_​name OR CODE ID button_​name IN WINDOW window_name

Arguments: button_​name: a string with the name of a but­ton in the code input win­dow window_​name: the name of the code input window

Available: Available for code win­dows Version: 9 and later

Example:

CODE ID another_​button“
Returns the iden­ti­fi­er from the but­ton with the name another_​button” in the same window


COUNT

Will count the num­ber of labels in the time­line (includ­ing mul­ti­ple ones in the same instance)

Format: COUNT labels

Arguments: labels: quot­ed text spec­i­fy­ing label you wish to count in the front time­line or instances(which can be grouped using OR, AND, NOT) option­al WHERE con­di­tions con­di­tions: ROW = quot­ed text or ROW != quot­ed text (which can be grouped using OR, ANDNOT)

Available: Available for all win­dows Version: 9 and later

Example:

count score“
Returns a count of all the score” labels in the front timeline 

count score” and fouls” where row=“smith“
Returns the total num­ber of score” and foul” labels in the row smith”

count score” where row!=“smith“
Returns the total num­ber of score” labels which are not in row smith”

count score” where row!=“smith” or row!=“fred“
Returns the total num­ber of score labels in the front time­line which are not in row smith” or row fred”

In the fol­low­ing exam­ple: $a = not (“shot” or foul”)

show count $a
Shows the total num­ber of labels in the front time­line which do not have shot” or foul” labels in them


END

Will give the lat­est end time of the labels or instances in the time­line in sec­onds. returns -1 if no instances

Format: END instances

Arguments: instances: instances or quot­ed text spec­i­fy­ing label you wish to get the lat­est end time

Available: Available for all win­dows Version: 9 and later

Example:

END score“
Returns the end time of the lat­est instance which has the label score” in seconds 

END score” and fouls” where row=“smith“
Returns the lat­est end time of score” and foul” labels in the row smith” 

END instances
Returns the end time of the last instance. i.e. The lat­est over­all end time 

show END instance[-1]
Shows the end time of the last instance (based on start time). This might not be the lat­est over­all end time


END TIME

will return all instances that have the cor­rect end time condition

Format: instances WHERE END TIME oper­a­tor value

Arguments: instances: quot­ed text spec­i­fy­ing label you wish to count in the front time­line or instances(which can be grouped using OR, AND, NOT) oper­a­tor: < >= = val­ue: the end time you wish to test (in seconds)

Available: Available for all win­dows Version: 9 and later

Example:

count instances where end time > 20
Will count the num­ber of instances that have an end time after 20 seconds 

count a” or b” where row=“row1” and end time > 20
Will count the instances that have a” or b” in them in row row1” end­ing after the first 20 seconds


FROM

will get instances from spec­i­fied time­lines. Not using this com­mand will default to use front timeline

Format: labels FROM time­lines OR labels FROM ALL TIMELINES

Arguments: labels: quot­ed text spec­i­fy­ing label you wish to count in the front time­line or instances(which can be grouped using OR, AND, NOT) time­lines: A set of time­line names sep­a­rat­ed by a com­ma or the key words ALL TIMELINES

Available: Available for all win­dows Version: 9 and later

Example:

show count a” or b” from timeline1”,“timeline2” where row=“row 1” or row=“row 2“
Shows the total num­ber of labels in timeline1” and timeline2” with a or b in them and the row = row 1′ or row 2’

count instances from all time­lines where row!=“row 1“
Returns the total num­ber of instances from all open time­lines not count­ing those in row 1’


GROUP

will return all instances that have labels with this group name

Format: instances WHERE group = string OR instances WHERE group != string

Arguments: instances: quot­ed text spec­i­fy­ing label you wish to count in the front time­line or instances(which can be grouped using OR, AND, NOT) string: a group name

Available: Available for all win­dows Version: 9 and later

Example: 

show count instances where group = team1“
Will show a count of all instances that have a label with the group team1”


INDEX

Finds the val­ue from a range of cells with the giv­en offset

Format: INDEX ( off­set IN reference..reference )

Arguments: off­set: an off­set num­ber (1 is the first cell) or col­umn off­set (1 is the first col­umn), row off­set (1 is the first row). If the off­set is just a num­ber, it will count the off­set in the columns first ref­er­ence: col­umn num­ber or col­umn title , row number

Available: Available for spread­sheet win­dows Version: 9 and later

Example:

index (2 in 3,4..3,8)
Returns the 2nd cell in the range. This will be the cell in col­umn 3, row 5. 

index (4,2 in 2,5..9,9)
Returns the 4th col­umn and 2nd row start­ing from col­umn 2, row 5. This will be the val­ue in col­umn 5, row 6


INDEX OF

Will give the index/​position of the first match that con­tains an instance in the oth­er instances (ordered by start times). returns 0 for not found, 1 = 1st instance etc…

Format: INDEX OF instances IN instances

Arguments: instances: labels or instances

Available: Available for all win­dows Version: 9 and later

Example:

index of mark” in instances where row=“row1” lim­it 1, -1
Returns the index of the first instance, in row row1” that con­tains the label mark” not includ­ing the first instance in the row


INSTANCES

Will return the instances in the timeline.

Format: INSTANCES OR INSTANCES ( label log­ic number)

Arguments: label: A string or vari­able rep­re­sent­ing a label. Can also be groupName.labelName log­ic: = != < <= > >= num­ber: the num­ber count to com­pare for each instance. 0 is not used

Available: Available for all win­dows Version: 9 and lat­er. (label log­ic num­ber) intro­duced in 10.2.1

Example:

length instances
Returns the total length of the instances in the timeline

count instances
Returns the total num­ber of instances in the timeline. 

show count instances ( ButtonA” <= 2)
Shows the num­ber of instances with two or one ButtonA” labels 

show count instances ( $a = 2)
Shows the num­ber of instances with two labels rep­re­sent­ed by the string stored in $a 

show instances ( ButtonA” = 1 and ButtonB”)
Shows the instances with one ButtonA” and any amount of ButtonB” 

show instances ( ButtonA” >= 2 or ButtonB” = 1)
Shows the instances with two or more ButtonA” or one ButtonB” 

show count instances( team”.“player” = 2)
Shows the num­ber of instances with two of the label play­er” in the group team” 

show count instances ( ButtonA” != 2)
Shows the num­ber of instances with one ButtonA” label or three and more ButtonA” labels 

show count instances ( not ButtonA” = 2)
Shows the total num­ber of instances that do not have two ButtonA” in them Use in con­junc­tion with WHERE to select par­tic­u­lar rows


INSTANCES2

Will return all the instances in the time­line between the red markers.

Format: INSTANCES2

Arguments:

Available: Available for all win­dows Version: 9 and later

Example: 

length instances2
Returns the total length of the instances in the time­line between the red markers

count a” and instances2
Returns the total num­ber of instances with a” in them between the red mark­ers in the timeline.


INSTANCE[x]

Will return the x’th instance in the time­line based on start times.

Format: INSTANCE[index]

Arguments: index: a num­ber less than or greater than 0. if index is greater than 0 then it will count from the begin­ning. eg. 1 rep­re­sents the first instance in the time­line, 2 the sec­ond instance etc. If index is less than 0 it will count from the end. eg. -1 rep­re­sents the instance with the lat­est start time, -2 the sec­ond lat­est start time etc.

Available: Available for all win­dows Version: 9 and later

Example:

length instance[2]
Returns the length of the sec­ond instance in the timeline.

length instance[-3]
Returns the length of the third last instance in the time­line. If you wish to have more con­trol then the LIMIT com­mand should be used


LABEL

Will return a label in the time­line. If an instance has 3 labels it will return the instance 3 times.

Format: LABEL string

Arguments: string: a label name

Available: Available for all win­dows Version: 9 and later

Example:

show count label a“
Returns the total num­ber of labels in the time­line with a” in them. Use in con­junc­tion with WHERE to select par­tic­u­lar conditions


LABEL IN

Will return a label in the instances. If an instance has 3 labels it will return the instance 3 times.

Format: LABEL string IN instances

Arguments: string: a label name instances: any com­mand that returns instances

Available: Available for all win­dows Version: 9 and later

Example:

show count label a” in instances lim­it 1
Returns the total num­ber of labels in the 1st instance in the time­line with a” in it.


LABEL_IN_GROUP

Filter instances on ranges of numer­ic val­ues of labels in a spec­i­fied group

Format: instances WHERE LABEL_IN_GROUP oper­a­tor value

Arguments:

instances: quot­ed text spec­i­fy­ing label you wish to count in the front time­line or instances (which can be grouped using ORANDNOT)

oper­a­tor: < > = !=

val­ue: the numer­ic val­ue for comparison

Available: code win­dows only

Version: 11.2.7 and later

Example:

show count instances where label_​in_​group dis­tance” >= 10 and label_​in_​group dis­tance” < 15

show instances where label_​in_​group mar­gin” < 5


LABELS

Will return all the labels in the time­line. If an instance has 3 labels it will return the instance 3 times.

Format: LABELS

Arguments:

Available: Available for all win­dows Version: 9 and later

Example:

count labels
Returns the total num­ber of labels in the time­line. Use in con­junc­tion with WHERE to select par­tic­u­lar rows


LABELS IN

Will return all the labels in the instances. If an instance has 3 labels it will return the instance 3 times.

Format: LABELS IN instances

Arguments: instances: any com­mand that returns instances

Available: Available for all win­dows Version: 9 and later

Example:

show count labels in instances lim­it 1,1
Returns the total num­ber of labels in the sec­ond instance in the timeline.


LENGTH

Will give the length of labels in the time­line (includ­ing mul­ti­ple ones in the same instance) in seconds

Format: LENGTH labels

Arguments: labels: quot­ed text spec­i­fy­ing label you wish to get the length of in the front time­line or instances(which can be grouped using OR, AND, NOT) option­al WHERE con­di­tions con­di­tions: ROW = quot­ed text or ROW != quot­ed text (which can be grouped using OR, ANDNOT)

Available: Available for all win­dows Version: 9 and later

Example:

length score“
Returns the total length in sec­onds of all the score” labels in the front timeline 

length score” and fouls” where row=“smith“
Returns the total length of score” and foul” labels in the row smith” 

length score” where row!=“smith“
Returns the total length of score” labels which are not in row smith”

length score” where row!=“smith” or row!=“fred“
Returns the total length of score labels in the front time­line which are not in row smith” or row fred” 

In the fol­low­ing exam­ple: $a = not (“shot” or foul”)

show length $a
Shows the total length of labels in the front time­line which do not have shot” or foul” labels in them. 

show length instance[1]
Shows the length in sec­onds of the first instance in the timeline


LIMIT

will lim­it instances based on conditions

Format: instances LIMIT offset,select OR instances LIMIT select

Arguments: instances: quot­ed text spec­i­fy­ing label you wish to count in the front time­line or instances(which can be grouped using OR, AND, NOT) off­set: the off­set to start count­ing. eg. 1 = will skip the first instance etc. If off­set < 0 then will count from end. eg. -1=last instance. Can be left out if off­set is 0. select: how many instances to select. If select < 0 it will select up to the end val­ue (-1=last, -2=2nd last etc…)

Available: Available for all win­dows Version: 9 and later

Example: 

instances lim­it 2
Will grab the first 2 instances 

instances lim­it 4,2
Will off­set 4 instances and select the next 2. That makes it the 5th and 6th instance

instances lim­it 4,-1 
will grab the 5th to the last instance 

instances lim­it -3,-2
Will grab the 3rd and 2nd last instance 

length a” or b” where row=“row 1” or row=“row 2” lim­it 3,2
Returns the total length of the 4th and 5th labels in the time­line with a or b in them and the row = row 1′ or row 2’


LOOKUP

Finds a match for a giv­en val­ue in the first range, and then returns the val­ue in the cell with the same rel­a­tive posi­tion in the sec­ond range. Ranges can­not over­lap or be of dif­fer­ent sizes

Format: LOOKUP ( val­ue IN ref­er­ence .. ref­er­ence USING reference..reference )

Arguments: ref­er­ence: col­umn num­ber or col­umn title, row num­ber val­ue: a num­ber, string, or instances you want to search the first range with. A range is spec­i­fied by reference..reference

Available: Available for spread­sheet win­dows Version: 9 and later

Example: 

show lookup ( w” in $column-2,1..$column-1,8 using $column-4,1..$column-3,8 )
Shows the val­ue in the cell 3 to 4 columns to the left of the cur­rent cell, if it finds w” in the cell 1 to 2 columns to the left of the cur­rent cell 

lookup(cell data” in sorted”,1..“sorted”,8 using rank”,1..“rank”,8 )
Using the cell on the same row in col­umn data” search the col­umn sort­ed” and if it finds it returns the val­ue from the col­umn rank” at the same row


NOT OPEN

Will test whether a giv­en time­line is cur­rent­ly not open

Format: NOT OPEN timeline_name

Arguments: timeline_​name: the name of the timeline

Available: Available for all win­dows Version: 9 and later

Example: 

if (“my time­line” not open, show YES”)
Shows YES” if the time­line with the name my time­line” is not loaded


OPEN

Will test whether a giv­en time­line is cur­rent­ly open

Format: OPEN timeline_name

Arguments: timeline_​name: the name of the timeline

Available: Available for all win­dows Version: 9 and later

Example:

if (“my time­line” open, show YES”)
Shows YES” if the time­line with the name my time­line” is open


OVERLAP

Will return instances from the giv­en argu­ments that over­lap for any part of the time­line. Opposite of the unique command

Format: OVERLAP ( instances , instances )

Arguments: instances: labels or instances

Available: Available for all win­dows Version: 9 and later

Example: 

$a=OVERLAP ( label 1”, labels 2” )
Returns all instances which have label1 in them and over­lap with any instance con­tain­ing label2 in them. It will also return all instances which have label2 in them and over­lap with any instance con­tain­ing label1. It will also return instances with both labels in them but only once. 

$a=OVERLAP ( instances,instances )
Will return all the instances as every instance will over­lap itself 

$a=OVERLAP ( instance[1], instance[2] )
Returns both the first and sec­ond instance in the time­line pro­vid­ed they over­lap. Otherwise it will return noth­ing show start 

OVERLAP (“label 1” where row=“row 1” ‚“label 2” where row=“row 2”)
Will show the start time of the first instance that over­laps where label 1 is in row 1 and label 2 is in row 2


OVERLAP_LENGTH

Will give the length of instances that over­lap with anoth­er instance in the time­line in seconds

Format: OVERLAP_LENGTH instances

Arguments: instances: labels or instances

Available: Available for all win­dows Version: 9 and later

Example: 

show overlap_​length instances
Returns the total length in sec­onds of all the time peri­ods where two or more instances occur


RANGE

will return all instances that have the cor­rect range time condition

Format: instances WHERE RANGE oper­a­tor value

Arguments: instances: quot­ed text spec­i­fy­ing label you wish to count in the front time­line or instances(which can be grouped using OR, AND, NOT) oper­a­tor: < >= = != val­ue: the time you wish to test (in sec­onds) that inter­sects the range of the instances

Available: Available for all win­dows Version: 9 and later

Example: 

count instances where range > 20
Will count the num­ber of instances that have a start time after 20 seconds 

count instances where range >= 20
Will count the num­ber of instances that at some time occur at 20 sec­onds or have a start time after 20 seconds 

count instances where range != 20
Will count the num­ber of instances that do not occur at 20 seconds


ROW

will return all instances that are on these rows

Format: instances WHERE row = string OR instances WHERE row != string OR instances WHERE row = val­ue OR instances WHERE row != val­ue OR instances WHERE row < val­ue OR instances WHERE row <= val­ue OR instances WHERE row > val­ue OR instances WHERE row >= value

Arguments: instances: quot­ed text spec­i­fy­ing label you wish to count in the front time­line or instances(which can be grouped using OR, AND, NOT) string: a row name val­ue: the row order in the timeline

Available: Available for all win­dows Version: 9 and later

Example: 

show count instances where row = code1“
Will show a count of all instances that have are on row code1” 

show count instances where row <= 3
Will show a count of all instances that are in the first 3 rows


ROW_NAME

Returns the row name from the front or spec­i­fied time­line for the giv­en index

Format: ROW_NAME ( val­ue ) OR ROW_NAME ( val­ue ) FROM timeline

Arguments: val­ue: The index for the row in the time­line you wish to get the row name. 1 for the the first row time­line: The time­line title

Available: Available for all win­dows Version: 9 and later

Example: 

show row_​name (1) 
Shows the top row name in the front timeline


START

Will give the ear­li­est start time of the labels or instances in the time­line in sec­onds. returns -1 if no instances

Format: START instances

Arguments: instances: instances or quot­ed text spec­i­fy­ing label you wish to get the ear­li­est start time

Available: Available for all win­dows Version: 9 and later

Example: 

START score“
Returns the start time of the ear­li­est instance which has the label score” in seconds 

START score” and fouls” where row=“smith“
Returns the ear­li­est start time of score” and foul” labels in the row smith” 

START instances
Returns the start time of the first instance show 

START instance[-1]
Shows the start time of the last instance (based on start time)


START TIME

will return all instances that have the cor­rect start time condition

Format: instances WHERE START TIME oper­a­tor value

Arguments: instances: quot­ed text spec­i­fy­ing label you wish to count in the front time­line or instances(which can be grouped using OR, AND, NOT) oper­a­tor: < >= = val­ue: the start time you wish to test (in seconds)

Available: Available for all win­dows Version: 9 and later

Example: 

count instances where start time < 20
Will count the num­ber of instances that have a start time in the first 20 seconds 

count a” or b” where row=“row1” and start time < 20
Will count the instances that have a” or b” in them in row row1” start­ing in the first 20 seconds


TIME

will return all instances that have the instance length condition

Format: instances WHERE TIME oper­a­tor value

Arguments: instances: quot­ed text spec­i­fy­ing label you wish to count in the front time­line or instances(which can be grouped using OR, AND, NOT) oper­a­tor: < >= = val­ue: the instance length you wish to test (in seconds)

Available: Available for all win­dows Version: 9 and later

Example: 

count instances where time < 20
Will count the num­ber of instances that are short­er than 20 sec­onds in length 

count a” or b” where row=“row1” and time < 20
Will count the instances that have a” or b” in them in row row1” and are short­er than 20 seconds


UNIQUE

Will return instances from the giv­en argu­ments that do not over­lap for any part of the time­line. Opposite of the over­lap command

Format: UNIQUE ( instances , instances )

Arguments: instances: labels or instances

Available: Available for all win­dows Version: 9 and later

Example: 

$a=UNIQUE ( label 1”, labels 2” ) 
Returns all instances which have label1 in them and do not over­lap with any instance con­tain­ing label2 in them. It will also return all instances which have label2 in them and do not over­lap with any instance con­tain­ing label1 

$a=UNIQUE ( instances,instances )
Will do noth­ing as there will be no unique instance as it will over­lap with itself 

$a=UNIQUE ( instance[1], instance[2] )
Returns both the first and sec­ond instance in the time­line pro­vid­ed they do not over­lap. Otherwise it will return noth­ing show start 

UNIQUE (“label 1” where row=“row 1” ‚“label 2” where row=“row 2”)
Will show the start time of the first instance that does not over­lap where label 1 is in row 1 and label 2 is in row 2


WHERE

will select cer­tain instances based on conditions

Format: labels WHERE conditions

Arguments: labels: quot­ed text spec­i­fy­ing label you wish to count in the front time­line or instances(which can be grouped using OR, AND, NOT) con­di­tions: ROW = quot­ed text or ROW != quot­ed text (which can be grouped using OR, ANDNOT)

Available: Available for all win­dows Version: 9 and later

Example: 

count a” or b” where row=“row 1” or row=“row 2“
Returns the total num­ber of labels in the time­line with a or b in them and the row = row 1′ or row 2’ 

count instances where row!=“row 1“
Returns the total num­ber of instances in the time­line not count­ing those in row 1’