Analytica Docs - User contributions [en]

Subscript and slice of a subarray

2015-09-24T14:16:15Z

DKontotasiou: /* @: Index Position Operator */

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] > [[Subscript and slice of a subarray]]
__NOTOC__
These constructs and functions let you select a slice or subarray out of an array.

== x[i=v]: Subscript construct ==
This is the most common method to extract a subarray:

:<code>x[i <nowiki>= v]</nowiki></code>

It returns the subarray of '''x '''for which index '''i '''has value '''v'''. If '''v '''is not a value of index '''i''', it returns '''NULL''', and usually gives a warning.

If '''x '''does not have '''i '''as a index, it just returns '''x'''. The reason is that if an array '''x '''is not indexed by '''i''', it means '''x '''is constant over all values of '''i'''.

You can apply the subscript construct to an expression, simply by putting the square bracket immediately after the expression:

:<code>(Revenue - Cost)[Time = 2010]</code>

'''Indexing by name not position''': You can subscript over multiple dimensions, for example:
:<code>x[i=v, j=u]</code>

The ordering of the indexes is arbitrary, so you get the same result from:

:<code>x[j=u, i=v]</code>

Indexing by name means that you don’t have to remember or use any intrinsic ordering of indexes in an array, such as rows or columns, inner or outer, common to most computer languages.

The value '''v '''can be an array with some index other than '''i '''of values from the index '''i'''. For example, '''v '''might be a subset of '''i'''. In that case, the result is an array with the index(es) of '''v '''containing the corresponding elements of '''x'''.

== Subscript(x, i, v) ==
This function is identical to the subscript construct '''x[i=v]''', using different syntax.

== x[@i=n]: Slice construct ==
The slice construct has an @ sign before the index. It is different from the subscript construct in that it refers to the numerical ''position ''rather than associating the ''value ''of index '''i'''. It returns the '''n'''th slice of '''x '''over index '''i''':

:<code>x[@i=n]</code>

The number '''n '''should be an integer between 1 (for the first element of index '''i''') and '''Size(i) '''for the last element of '''i'''. If '''n '''is not an integer in this range, it returns '''NULL''', and returns a warning (unless warnings have been turned off).

Like the subscript construct, it can slice over multiple indexes, for example:

:<code>x[@i=n, @j=m]</code>

And also like the subscript construct, the ordering of the indexes is arbitrary.

'''Mixing subscript and slice constructs''': You can mix slice and subscript operations in the same expression in any order:

:<code>x[@i=1, j=2, k=3]</code>

==Slice(x, i, v)==
This function is identical to the slice construct <code>x[@i=v]</code>, using different syntax.

== Slice(x, n) ==
If '''Slice() '''has only two parameters, and '''x '''has a single dimension, it returns the '''n'''th element of x. For example:

:<code>Index Quarters := 'Q' & 1..4 </code>
:<code>Slice(Quarters, 2) → 'Q2'</code>

This method is the only way to extract an element from an unindexed array, for example:

:<code>Slice(2000..2003, 4) → 2003</code>

It also works to get the '''n'''th slice of a multidimensional array over an unindexed dimension, for example:

:<code>Slice(Quarters & ' ' & 2000..2003, 4) → Array(Quarters, ['Q1 2003', 'Q2 2003', 'Q3 2003', 'Q4 2003'])</code>

<tip title="Tip">If '''x '''is a scalar, or if '''x '''is an array with two or more indexed dimensions and no unindexed dimensions, '''Slice(x, n) '''simply returns '''x'''.</tip>

===Library===
Array

===Examples===
Here, Analytica returns the values in '''Cost '''corresponding to the first element in '''Car_type''', that is, the values of '''VW''':

[[File:Chapter11_80.jpg]]

==Preceding time slice: x[Time-1]==
'''x[Time-n] '''refers to the built-in index <code>Time</code>. It returns the value of variable '''x '''for the time period that is '''n '''periods prior to the current time period. This function is only valid inside the Dynamic() function

== @: Index Position Operator ==
The '''''position '''''of value '''x '''in an index '''i '''is the integer ''n ''where '''x '''is the ''nth ''element of '''i'''. ''n ''is a number between 1 and '''Size(i)'''. The first element of '''i '''is at position 1; the last element of '''i '''is at position '''Size(i)'''. The position operator '''@ '''offers three ways to work with positions:
* '''@i '''→ an array of integers from 1 to '''Size(i) '''indexed by '''i'''.
* '''@[i=x] '''→ the position of value '''x '''in index '''i, '''or 0 if '''x '''is not an element of '''i'''.
* '''e[@i=n] '''→ the '''n'''th slice of the value of expression '''e '''over index '''i'''.

===Examples===
[[File:Chapter11_81.jpg]]

===More examples and tips===
[[File:Chapter11_82.jpg]]

<tip title="Tip">You can use this operator to re-index an array by another index having the same length but different elements. For example, suppose <code>Revenue</code> is indexed by <code>Time</code>, this following gives the same array but indexed by '''Years''': <code>Revenue[@Time=@Years]</code></tip>

==Choice(i, n'', inclAll, eval, result, separator'')==
Appears as a popup menu in the definition field, allowing selection of the '''n'''th item from '''i '''. '''Choice() '''must appear at the topmost level of a definition or table cell. It cannot be used inside another expression. The optional '''inclAll '''parameter controls whether the "All" option (n=0) appears on the popup ('''inclAll '''defaults to True). When you select '''All''', Analytica runs the model on all inputs so you can see how your result varies as this parameter varies, a technique commonly referred to as ''parametric analysis''. If you don’t want '''All '''to be an option, specify '''inclAll '''as <code>false</code>.

When using '''Choice '''in a table cell, it is a good practice to set '''inclAll '''to <code>false</code>.

In a choice definition (non-table), you can specify '''i '''to be '''Self '''if the '''Domain '''attribute contains an explicit list. Otherwise, '''i '''is an index that contains the list of options. '''n '''is the currently selected item, with 1 being the first item, or it is 0 for the '''All '''option. When the user makes a new selection, Analytica will rewrite the definition by changing '''n '''to a new number. '''n '''must be a literal number, it cannot be a general expression.

When index '''i '''contains handles to objects, the optional boolean '''eval '''parameter controls whether the handle is returned (<code>eval:false</code>) or the result of evaluating the variable is returned (<code>eval:true</code>). The optional '''result '''parameter can be an array indexed by '''i''', which specifies the value returned and which may be different from the elements of '''i'''. You can include separators in the choice menu by specifying a value for the optional '''separator '''parameter. The elements of '''i '''matching '''separator '''will appear as non-selectable separators in the popup menu.

===Examples===
[[File:Chapter11_83.jpg]]

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[Splice a table when computed indexes change]] <- || [[Subscript and slice of a subarray]] || -> [[Choice menus in an edit table]]
|}
</translate>

Subscript and slice of a subarray

2015-09-24T14:15:23Z

DKontotasiou:

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] > [[Subscript and slice of a subarray]]
__NOTOC__
These constructs and functions let you select a slice or subarray out of an array.

== x[i=v]: Subscript construct ==
This is the most common method to extract a subarray:

:<code>x[i <nowiki>= v]</nowiki></code>

It returns the subarray of '''x '''for which index '''i '''has value '''v'''. If '''v '''is not a value of index '''i''', it returns '''NULL''', and usually gives a warning.

If '''x '''does not have '''i '''as a index, it just returns '''x'''. The reason is that if an array '''x '''is not indexed by '''i''', it means '''x '''is constant over all values of '''i'''.

You can apply the subscript construct to an expression, simply by putting the square bracket immediately after the expression:

:<code>(Revenue - Cost)[Time = 2010]</code>

'''Indexing by name not position''': You can subscript over multiple dimensions, for example:
:<code>x[i=v, j=u]</code>

The ordering of the indexes is arbitrary, so you get the same result from:

:<code>x[j=u, i=v]</code>

Indexing by name means that you don’t have to remember or use any intrinsic ordering of indexes in an array, such as rows or columns, inner or outer, common to most computer languages.

The value '''v '''can be an array with some index other than '''i '''of values from the index '''i'''. For example, '''v '''might be a subset of '''i'''. In that case, the result is an array with the index(es) of '''v '''containing the corresponding elements of '''x'''.

== Subscript(x, i, v) ==
This function is identical to the subscript construct '''x[i=v]''', using different syntax.

== x[@i=n]: Slice construct ==
The slice construct has an @ sign before the index. It is different from the subscript construct in that it refers to the numerical ''position ''rather than associating the ''value ''of index '''i'''. It returns the '''n'''th slice of '''x '''over index '''i''':

:<code>x[@i=n]</code>

The number '''n '''should be an integer between 1 (for the first element of index '''i''') and '''Size(i) '''for the last element of '''i'''. If '''n '''is not an integer in this range, it returns '''NULL''', and returns a warning (unless warnings have been turned off).

Like the subscript construct, it can slice over multiple indexes, for example:

:<code>x[@i=n, @j=m]</code>

And also like the subscript construct, the ordering of the indexes is arbitrary.

'''Mixing subscript and slice constructs''': You can mix slice and subscript operations in the same expression in any order:

:<code>x[@i=1, j=2, k=3]</code>

==Slice(x, i, v)==
This function is identical to the slice construct <code>x[@i=v]</code>, using different syntax.

== Slice(x, n) ==
If '''Slice() '''has only two parameters, and '''x '''has a single dimension, it returns the '''n'''th element of x. For example:

:<code>Index Quarters := 'Q' & 1..4 </code>
:<code>Slice(Quarters, 2) → 'Q2'</code>

This method is the only way to extract an element from an unindexed array, for example:

:<code>Slice(2000..2003, 4) → 2003</code>

It also works to get the '''n'''th slice of a multidimensional array over an unindexed dimension, for example:

:<code>Slice(Quarters & ' ' & 2000..2003, 4) → Array(Quarters, ['Q1 2003', 'Q2 2003', 'Q3 2003', 'Q4 2003'])</code>

<tip title="Tip">If '''x '''is a scalar, or if '''x '''is an array with two or more indexed dimensions and no unindexed dimensions, '''Slice(x, n) '''simply returns '''x'''.</tip>

===Library===
Array

===Examples===
Here, Analytica returns the values in '''Cost '''corresponding to the first element in '''Car_type''', that is, the values of '''VW''':

[[File:Chapter11_80.jpg]]

==Preceding time slice: x[Time-1]==
'''x[Time-n] '''refers to the built-in index <code>Time</code>. It returns the value of variable '''x '''for the time period that is '''n '''periods prior to the current time period. This function is only valid inside the Dynamic() function

== @: Index Position Operator ==
The '''''position '''''of value '''x '''in an index '''i '''is the integer ''n ''where '''x '''is the ''nth ''element of '''i'''. ''n ''is a number between 1 and '''Size(i)'''. The first element of '''i '''is at position 1; the last element of '''i '''is at position '''Size(i)'''. The position operator '''@ '''offers three ways to work with positions:
* '''@i '''an array of integers from 1 to '''Size(i) '''indexed by '''i'''.
* '''@[i=x] '''the position of value '''x '''in index '''i, '''or 0 if '''x '''is not an element of '''i'''.
* '''e[@i=n] '''the '''n'''th slice of the value of expression '''e '''over index '''i'''.

===Examples===
[[File:Chapter11_81.jpg]]

===More examples and tips===
[[File:Chapter11_82.jpg]]

<tip title="Tip">You can use this operator to re-index an array by another index having the same length but different elements. For example, suppose <code>Revenue</code> is indexed by <code>Time</code>, this following gives the same array but indexed by '''Years''': <code>Revenue[@Time=@Years]</code></tip>

==Choice(i, n'', inclAll, eval, result, separator'')==
Appears as a popup menu in the definition field, allowing selection of the '''n'''th item from '''i '''. '''Choice() '''must appear at the topmost level of a definition or table cell. It cannot be used inside another expression. The optional '''inclAll '''parameter controls whether the "All" option (n=0) appears on the popup ('''inclAll '''defaults to True). When you select '''All''', Analytica runs the model on all inputs so you can see how your result varies as this parameter varies, a technique commonly referred to as ''parametric analysis''. If you don’t want '''All '''to be an option, specify '''inclAll '''as <code>false</code>.

When using '''Choice '''in a table cell, it is a good practice to set '''inclAll '''to <code>false</code>.

In a choice definition (non-table), you can specify '''i '''to be '''Self '''if the '''Domain '''attribute contains an explicit list. Otherwise, '''i '''is an index that contains the list of options. '''n '''is the currently selected item, with 1 being the first item, or it is 0 for the '''All '''option. When the user makes a new selection, Analytica will rewrite the definition by changing '''n '''to a new number. '''n '''must be a literal number, it cannot be a general expression.

When index '''i '''contains handles to objects, the optional boolean '''eval '''parameter controls whether the handle is returned (<code>eval:false</code>) or the result of evaluating the variable is returned (<code>eval:true</code>). The optional '''result '''parameter can be an array indexed by '''i''', which specifies the value returned and which may be different from the elements of '''i'''. You can include separators in the choice menu by specifying a value for the optional '''separator '''parameter. The elements of '''i '''matching '''separator '''will appear as non-selectable separators in the popup menu.

===Examples===
[[File:Chapter11_83.jpg]]

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[Splice a table when computed indexes change]] <- || [[Subscript and slice of a subarray]] || -> [[Choice menus in an edit table]]
|}
</translate>

File:Chapter11 83.jpg

2015-09-24T14:15:12Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 82.jpg

2015-09-24T14:11:02Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 81.jpg

2015-09-24T14:09:18Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 80.jpg

2015-09-24T14:05:52Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

Functions that create indexes

2015-09-24T13:51:34Z

DKontotasiou:

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] > [[Functions that create indexes]]
__NOTOC__
It is usually easiest to define an index as a list, list of labels, or sequence. Sometimes, you need to define an index using a more general expression, as a list of expressions, a list of variables, or a function such as '''Subset()''', '''Concat()''', and '''SortIndex()'''. This section describes these and other functions that you can use to create indexes.

==[ ''u1, u2, u3, … um '']==
A simple way to define an index is specify its definition as a list of values separated by commas and surrounded by square brackets. The values can be numbers, text values, or other expressions.

===Examples===
<code>[8000, 12K, 15K]</code>

<code>['VW', 'Honda', 'BMW']</code>

These lists are equivalent to using the '''List '''or '''List of Labels '''options in the '''''expr '''''menu.

==List of variables==
A list of variables contains identifiers of variables in square brackets, separated by commas. Usually, the simplest way to create a list of variables is to define the variable initially as an empty list, for example:

:<code>Variable CompareVars := []</code>

When you draw an arrow from a variable, <code>A</code>, into <code>CompareVars</code>, it will automatically add <code>A</code> as the next item in the list:

:<code>CompareVars := [A]</code>

Suppose you draw arrows from <code>B</code> and <code>C</code>, the definition will become:

:<code>CompareVars := [A, B, C]</code>

When you draw an arrow from a variable already in the list, it removes it from the list. Suppose we draw an arrow from <code>B</code> to <code>CompareVars</code>, it will become:

:<code>CompareVars := [A, C]</code>

The result of <code>CompareVars</code> is an array of the values of the variables it contains, with a self index, also called <code>CompareVars</code>, that usually shows the titles of the variables.

If any or all the variables contain arrays, the result contains the union of the indexes of the con- tained variables. For example if '''A '''is an atom (not an array) and '''C '''is indexed by '''c''', the result will be indexed by '''I'''. The slice of <code>CompareVars</code> for '''A '''will have the same value of '''A '''repeated for each value of '''A'''.

'''Self index''': The result will contain an extra index, a '''''self index '''''of <code>CompareVars</code>, comprising the list of the variables.

'''Clickable titles or identifiers in table''': Usually these display the titles of the variables in a table or graph result. (If you select '''Show by Identifier '''from the '''Object '''menu (or press ''Control+y'') it toggles to show the identifiers instead of titles. If you double-click a title (or identifier) in a table, it will open the '''Object '''window for that variable. The values in the self index are actually '''''handles '''''to the variables.

== m .. n ==
Returns a sequence of successive integers from '''m '''to '''n '''— increasing if '''n < m''', or decreasing if '''n'''> '''m'''. For example:

:<code>2003..2006 → [2003, 2004, 2005, 2006]</code>

:<code>5 .. 1 → [5, 4, 3, 2, 1]</code>

It is equivalent to '''Sequence(m, n)'''.

<tip title="Tip">The parameters '''n '''and '''m '''must be atoms, that is single numbers. Otherwise, it would result in a non-rectangular array.

==Sequence(start, end'', stepSize, strict, dateUnit'')==
Creates a list of numbers increasing or decreasing from '''start '''to '''end '''by increments (or decrements) of '''stepSize''', which is optional and defaults to 1. When the '''strict '''parameter is omitted or false, '''stepSize '''must be a positive number and the sequence will decrement by '''stepSize '''when '''end '''is less than '''start''', guaranteeing at least one element. When '''strict '''is specified as true, a positive '''stepSize '''increments and negative '''stepSize '''returns a decrementing sequence, possibly with zero elements if '''end '''would come before '''start'''.

The optional '''dateUnit '''parameter is used when creating a sequence of dates, with increments in units of Years (<code>dateUnit:'Y'</code>), Months (<code>'M'</code>), Days (<code>'D' </code>or omitted), Weekdays (<code>'WD'<7code>), Hours (<code>'h'</code>), minutes (<code>'m'</code>) or seconds (<code>'s'</code>).

All parameters must be deterministic scalar numbers, not arrays.

You can also select this function using the '''Sequence '''option from the '''''expr '''''menu.

The expression '''m .. n '''using the operator '''".." '''is equivalent to '''Sequence(m, n, 1)'''.

===Library===
Array

===Examples===
If <code>end</code> is greater than <code>start</code>, the sequence is increasing:

:<code>Sequence(1,5) →</code>

[[File:Chapter11_77.jpg]]

If <code>start</code> is greater than <code>end</code>, the sequence is decreasing:

:<code>Sequence(5, 1) → [5, 4, 3, 2, 1]</code>

Unless <code>strict</code> is true:

:<code>Sequence(5, 1, strict:true) → []</code>

:<code>Sequence(5, 1, -2, strict:true ) → [5, 3, 1]</code>

If <code>start</code> and <code>end</code> are not integers, and you omit <code>stepSize</code>, it rounds them:

:<code>Sequence(1.2, 4.8) → [1, 2, 3, 4, 5]</code>

If you specify <code>stepSize</code>, it can create non-integer values:

:<code>Sequence(0.5, 2.5, 0.5) → [0.5, 1, 1.5, 2, 2.5]</code>

==Concat(i, j)==
Returns a list containing the elements of index '''i '''concatenated to the elements of index '''j'''. Thus the number of items in the result is the sum of the number of items in '''i '''and the number of items in '''j'''.

:<code>Index Year1 := 2006 .. 2008</code>

:<code>Index Years2 := 2009 .. 2010</code>

:<code>Index YearsAll := Concat(Years1, Years2)</code>

:<code>YearsAll → [2006, 2007, 2008, 2009, 2010]</code>

==Subset(d)==
Returns a list containing all the elements of '''d'''’s index for which '''d'''’s values are true (that is, non- zero). '''d '''must be a one-dimensional array.

The optional parameter '''position:true '''can be specified to return the positions along '''d'''’s index for which '''d'''’s values are true. You would need to use positions if your index might contain duplicate values.

The basic use of '''Subset '''does not allow '''d '''to contain more than one dimension.

===When to use===
Use Subset() to create a new index that is a subset of an existing index.

===Library===
Array

===Examples===
:<code>Subset(YearsAll < 2010) → [2006, 2007, 2008, 2009]</code>

:<code>Subset(YearsAll>2007 and YearsAll<2010, position:true) → [3,4]</code>

==CopyIndex(i)==
Makes a copy of the values of index '''i''', to be assigned to a new index variable, global or local. For example, suppose you want to create a matrix of distances between a set of origins and destinations, which are each the same set of cities:

:<code>Index Origins</code>

:<code>Definition:= ['London', 'New York', 'Tokyo', 'Paris', 'Delhi'] </code>

:<code>Index Destinations</code>

:<code>Definition:= CopyIndex(Origins)</code>

:<code>Variable Flight_times := Table(Origins, Destinations)</code>

If you defined <code>Destinations</code> as equal to <code>Origins</code>, without using '''Copyindex()''', <code>Destinations</code> would be indexed by <code>Origins</code>, and the resulting table would have only one dimension index. By defining <code>Destinations</code> with '''CopyIndex()''', it becomes a separate index, so that the table has two dimensions.

== Sortindex(d, i) ==
Assuming '''d '''is an array indexed by '''i''''', '''''SortIndex() '''returns the elements of index '''i''', reordered so that the corresponding values in '''d '''would go from smallest to largest value. The result is indexed by '''i'''''. ''If '''d '''is indexed by dimensions other than '''i''', each “column” is individually sorted, with the resulting sort order being indexed by the extra dimensions. To obtain the sorted array '''d''', use this:

:<code>d[i=Sortindex(d, i)]</code>

When '''d '''is a one-dimensional array, the index parameter '''i '''is optional. When omitted, the result is an unindexed list. Use the one-parameter form only when you want an unindexed result, for example to define an index variable. The one-parameter form does array abstract when a new dimension is added to '''d'''.

===Library===
Array

===Examples===

[[File:Chapter11_78.jpg]]

== Unique(a, i) ==
Returns a maximal subset of '''i '''such that each indicated slice of '''a '''along '''i '''is unique.

The optional parameter '''position:true '''returns the positions of element in '''i''', rather than the elements themselves. Specifying '''caseInsensitive:true '''ignores differences in upper and lower case in text values when determining if values are unique.

===When to use===
Use '''Unique() '''to remove duplicate slices from an array, or to identify a single member of each equivalence class.

===Library===
Array

[[File:Chapter11_79.jpg]]

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[Creating an index]] <- || [[Functions that create indexes]] || -> [[Defining a variable as an edit table]]
|}
</translate>

File:Chapter11 79.jpg

2015-09-24T13:51:24Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 78.jpg

2015-09-24T13:49:54Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 77.jpg

2015-09-24T13:38:48Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

Functions that create indexes

2015-09-24T13:28:45Z

DKontotasiou:

Functions that create indexes

2015-09-24T12:41:50Z

DKontotasiou: Created page with "Category:Analytica User Guide <languages /> <translate> Analytica User Guide > Functions that create indexes ==See Also== {| style="margin: 1em auto 1em auto;wid..."

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] > [[Functions that create indexes]]

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[Creating an index]] <- || [[Functions that create indexes]] || -> [[Defining a variable as an edit table]]
|}
</translate>

Shortcuts to navigate and edit a table

2015-09-24T12:38:03Z

DKontotasiou: Created page with "Category:Analytica User Guide <languages /> <translate> Analytica User Guide > Shortcuts to navigate and edit a table These mouse operations and keyboard shortcut..."

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] > [[Shortcuts to navigate and edit a table]]

These mouse operations and keyboard shortcuts let you navigate around a table, select a region, and search for text. They are the same as in Microsoft Excel, wherever this makes sense. ''Control+Page Up ''and ''Control+Page Down ''are exceptions.

The ''current cell ''is highlighted, or the first cell you selected in a highlighted rectangular region. In a region, the ''anchor cell ''is the corner opposite the current cell. If you select only one cell, the Anchor and Current are the same cell.

'''Mouse operations''':

:''Mouse Click'': Click in a cell to make it the current cell.

:''Mouse Shift+Click'': Select the region from the previous anchor to this cell.

:''Mouse drag'': Select the region from the cell in which you depress the left mouse button to the cell in which you release the button.

:''Mouse wheel'': Scroll vertically without changing the selection.

:''Control+mouse wheel'': Scroll horizontally without changing the selection.

'''Shortcuts to edit a table''': These shortcut keys speed up editing a table. Inserting and deleting rows and columns works only if the index(es) are defined as an explicit list, not if it is computed or a sequence:
:''down-arrow'': If you have selected the last row, add a row.

:''left-arrow'': If you have selected the right column, add a column.

:''Control''+i: If you have selected a row header, insert a row. If you have selected a column header, insert a column.

:''Control''+k: Delete a selected row or column.

:''Control+''v: Paste copied cells from the clipboard into the table into the selected region. If you copy a region and have selected a single cell, it pastes into the region with the current cell as the top-left, if it fits. If you paste a cell or region into a larger region, it repeats the copied material to fill out the destination region.

'''Search a table''':
:''Control+f'': Open the '''Find '''dialog to search for text in the table. Search from the current cell and select the first matching cell, if any.

:''Control+g'': Repeat the previous '''Find''', starting in the next cell.

'''Arrow keys''':
:''arrow (right, left, up, down)'': Move one cell in the given direction. At the end of row, right arrow wraps to the start of the next row. At the end of the last row, it wraps to top-left cell. Similarly, for the other keys.

:''Shift+arrow'': Move the current cell one cell in the given direction. The Anchor cell stays put, causing the selected region to grow or shrink. It does not wrap.

:''Control+arrow'': Move to the end of row or column in the given direction.

:''Shift+Control+arrow'': Move current cell to the end of row or column in the given direction, leaving the Anchor where it is, causing the selected region to grow (or flip).

:''End, arrow'': Two key sequence. Same as ''Control+arrow''.

:''End, Shift+arrow'': Two key sequence. Same as ''Shift+Control+arrow''.

'''Home key''':
:''Home'': Move the anchor to the first column, and sets the current cell to be the anchor (so only one cell is selected). If you are in the row headers, moves the anchor and current to the first row.

:''Control+Home'': Select the top-left cell in the table. (Selects one cell.)

:''Control+End'': Select the bottom-right cell in the table. (Selects one cell.)

:''Shift+Control+Home'': Select the region between the anchor and the top-left cell. (Leaves current as top-left.)

'''Page key''':
:''Page Up, Page Down'': Move the current cell up or down by the number of rows visible in the window, and scrolls up or down to show that cell. (Selects one cell.)

:''Control+Page Up, Control+Page Down'': Move the current cell left or right by the number of columns visible in the window, scrolling horizontally to show the new current cell. (This is not the same as Excel, in which ''Control+Page Up'', ''Control+Page Down ''toggle between worksheets. Since we don't have worksheets, these do something else useful.)

'''Other keys''':

:''Shift+Page Up, Shift+Page Down'': Move the current cell by the number of rows or columns that currently display on the screen, and scroll vertically by one page. Anchor stays the same, so that the currently selected region expands or shrinks by one page length.

:''Shift+Control+Page Up, Shift+Control+Page'': Same as ''Shift+Page Up'', but horizontally rather than vertically.

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[Choice menus in an edit table]] <- || [[Shortcuts to navigate and edit a table]] || -> [[More Array Functions]]
|}
</translate>

Choice menus and Checkboxes in an edit table

2015-09-24T12:28:00Z

DKontotasiou: Created page with "Category:Analytica User Guide <languages /> <translate> Analytica User Guide > Choice menus in an edit table You can include a drop-down (pull-down) menu in any c..."

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] > [[Choice menus in an edit table]]

You can include a drop-down (pull-down) menu in any cell of an edit table to let end users select an option for each cell. Here is an example, in browse mode.

[[File:Chapter11_74.jpg]]

You use the Choice() function in the edit table cells, similar to using '''Choice '''to specify a single menu for a variable:

<ol><li> Create a variable '''X '''as an edit table, in the usual way, selecting '''Table '''from the '''''expr '''''menu above its definition.</li>
<li> Create an index variable, e.g., '''k''', containing the list of options you want to make available from the menu(s), usually as a list of numbers or a list of labels.</li>
<li> In the edit table of '''X''', in edit mode, enter '''Choice(k, 1, 0) '''into the first cell that you want to contain a menu. The second parameter '''1 '''means that the first element of '''k '''is the default option. The third parameter '''0 '''means that it does not show '''All '''as an option, normally what you want.

'''''Note: '''When you enter the cell definition, the choice control displays immediately. You may want to edit the textual expression to make a change, or to copy the textual expression for pasting into other cells. In edit mode you can toggle between the viewing the control and the textual expression using the expression/control selector. Note that the selector is not present in browse mode, or when no cells with controls are visible.'' 

[[File:Chapter11_75.jpg]]</li>

<li> Copy and paste <code>Choice(k, 1, 0)</code> from the first cell to any others you want also to contain the menu. You can also use other indexes than '''k '''if you want to include menus with other options. Here is an example containing drop-down menus in some but not all cells, with ''Show Expressions ''selected. 

[[File:Chapter11_76.jpg]]</li>
<li>Select '''X''', then select '''Make Input '''from the '''Object '''menu to make an input node for it. Move the input node to a good location. You will usually want an input node so the selections can be changed when the table is viewed in browse mode.</li></ol>

<tip title="Tip">The variable containing the edit table with menus ''should always ''have an input node — otherwise, you won’t be able to select from the menus or edit other cells in browse mode.</tip>

'''''Note: '''You can also insert checkbox controls into table cells using the same steps. Enter the expression <code>Checkbox(0)</code> or <code>Checkbox(1)</code> directly into a cell.''

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[Subscript and slice of a subarray]] <- || [[Choice menus in an edit table]] || -> [[Shortcuts to navigate and edit a table]]
|}
</translate>

File:Chapter11 76.jpg

2015-09-24T12:26:34Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 75.jpg

2015-09-24T12:25:28Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 74.jpg

2015-09-24T12:23:50Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

Subscript and slice of a subarray

2015-09-24T12:20:50Z

DKontotasiou: Created page with "Category:Analytica User Guide <languages /> <translate> Analytica User Guide > Subscript and slice of a subarray ==See Also== {| style="margin: 1em auto 1em auto..."

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] > [[Subscript and slice of a subarray]]

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[Splice a table when computed indexes change]] <- || [[Subscript and slice of a subarray]] || -> [[Choice menus in an edit table]]
|}
</translate>

Splice a table when computed indexes change

2015-09-24T12:18:49Z

DKontotasiou:

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] > [[Splice a table when computed indexes change]]

A computed index is an index that depends on other variables (that is, not an explicit list of numbers or labels). Computed indexes use functions that return indexes, such as '''Sequence()''', '''Concat()''', or '''Subset()''', for example:

:<code>Index Year := Start_year .. Horizon_year</code>
:<code>Index K := Concat(i, j)</code>
:<code>Index S := Subset(Year < 2002)</code>

'''''Splicing '''''is what happens to an editable table (table, determtable, or prob table) when it uses a computed index that changes because of a change to one of its inputs. The change can cause slices to be added, deleted, or reordered. By default, if the changed index has an item with the same value (number or text) as the previous version, all editable tables retain the old data for the slice identified by that item, even if items are removed, reordered, or added. For example:

:<code>Variable Start_year := 2005</code>
:<code>Index Year := Start_year .. (Start_year+2) </code>
:<code>Variable Revenues := Table(Year)(100, 200, 300) </code>
:<code>Revenues → </code>
:<code>Year </code>

[[File:Chapter11_72.jpg]]

Suppose, you change:
:<code>Start_year := 2006</code>

Then by default, <code>Revenues</code> will change to:
:<code>Year</code>

[[File:Chapter11_73.jpg]]

Thus, it loses the cell for '''2005'''. Cells for '''2006 '''and '''2007 '''retain their original values, and it adds a new cell with default '''0 '''for the new year, '''2008'''. This is called '''''associational correspondence''''', because it retains the association between index label and value, even if the positions change.

Alternatively, if you change one or more index values to new text labels or numbers, it retains the same values of for the '''''n'''''th slice, even though the index value changes. This is called '''''positional correspondence''''', because it retains correspondence where the nth position contains the same value.

The default splicing behavior is '''''mixed correspondence''''', preserving ''associational ''correspondence where labels are the same, and preserving ''positional ''correspondence where possible otherwise. It is possible to change this splicing behavior for each editable table to '''''pure associational correspondence '''''— retaining values ''only ''where index values are the same — or '''''pure positional correspondence '''''— going ''only ''by position in the index, irrespective of index values.

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[Editing a table]] <- || [[Splice a table when computed indexes change]] || -> [[Subscript and slice of a subarray]]
|}
</translate>

File:Chapter11 73.jpg

2015-09-24T12:17:58Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 72.jpg

2015-09-24T12:16:28Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

Splice a table when computed indexes change

2015-09-24T12:12:46Z

DKontotasiou: Created page with "Category:Analytica User Guide <languages /> <translate> Analytica User Guide > Splice a table when computed indexes change ==See Also== {| style="margin: 1em aut..."

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] > [[Splice a table when computed indexes change]]

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[Editing a table]] <- || [[Splice a table when computed indexes change]] || -> [[Subscript and slice of a subarray]]
|}
</translate>

To edit a table

2015-09-24T12:11:36Z

DKontotasiou:

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] > [[Editing a table]]
__NOTOC__
To open the '''Edit Table '''window, click the '''Edit Table '''button in either:
* The Object window
* The Attribute panel of the diagram
In the '''Attribute '''panel, select '''Definition ''' from the '''Attribute '''popup menu.

'''The Edit Table window''': The '''Edit Table '''window looks much like the '''Result '''window table view'''. The difference is that you can add indexes and edit the values in cells.

[[File:Chapter11_67.jpg]]

'''Edit a cell''': Click the cell, and start typing to replace what’s in it. To add to what’s there, click three times to get a cursor in the cell, and type. You can use ''left-arrow ''and ''right-arrow ''keys to move the cursor. Press ''Enter ''to accept the value and to select the next cell, or click in another cell.

<tip title="Tip">You can enter an expression into a table cell with operations, function calls, and so on. But, if the expression is complex, it’s easier to enter it as the definition of a new variable, and then just type the name of the variable into the table.</tip>

'''Select a cell''': Click the cell once.

'''Select a range of cells''': Drag the cursor from a cell at one corner of a rectangular region to the cell at the opposite corner.

'''Copy and paste a cell or region''': You can copy a cell or a range (two-dimensional rectangular region) of cells from a table or paste a cell into a region, just as with a spreadsheet:
# Select the source cell or region as above, and choose '''Copy '''from the '''Edit '''menu or press ''Control+c''.
# Select the destination cell (or top-left cell of the destination region), and choose '''Paste '''from the '''Edit '''menu or press ''Control+v''.
If you select a destination region that is '''n '''times larger (width, height, or both) than the source cell or region, it repeats the source '''n '''times in the destination.

'''Accept''': Click [[File:Chapter11_68.jpg]] to accept all the changes you have made to the table. If you close a table, it also accepts the changes, unless you click [[File:Chapter11_69.jpg]].

'''Cancel''': Click [[File:Chapter11_69.jpg]] to cancel all the changes you have made to the table since you opened it or last clicked [[File:Chapter11_68.jpg]].

'''Copy and paste to or from a spreadsheet''': Copy and paste of a cell or region works much the same from a spreadsheet to an Analytica table or vice versa. If necessary, you can easily pivot the Analytica table so its rows and columns correspond with those in the spreadsheet. It copies numbers in exponential format with full precision, no matter what number format is used in the table, so that other applications can receive them with no problems.

'''Copy an entire table''': To copy a table, including its row and column headers, click the top-left cell to select the whole table. You can also copy a table with more than two dimensions: Select '''Copy table '''from the '''Edit '''menu. When you paste into a spreadsheet, it includes the name of the table, and all indexes, including the slicer index(es) for the third and higher dimensions.

'''Entering multi-line text''': When entering multi-line text or multiple line expressions into single cells of an edit table, press ''Ctrl+Enter ''while editing the cell contents to insert a new line within the cell. Pressing just ''Enter ''when editing the contents of a cells accepts the changes for that cell and leaves the cell edit; hence, you need to hold Alt when inserting the new line. You can also select '''Add new line within cell '''from the right-mouse context menu while editing.

==Editing or extending indexes in an edit table==
One convenient aspect of Intelligent Arrays is that you can edit and extend the indexes of an array right in the edit table, to change index values, insert or remove rows or columns, or, more generally, subarrays.

This works for an index defined as a list of numbers or list of labels. If an index is defined in another way — for example as <code>m .. n</code> or <code>Sequence(x1, x2, dx)</code>— you must edit the original index. Either way, all edit tables that use the changed index are automatically modified accordingly.

To edit or extend an index, either you must be in edit mode [[File:Chapter11_70.jpg]] or the index variable you want to modify must have an input node.

'''Edit a cell in a row or column index''': Click the cell once to select its row or column. Then double-click the cell to select its contents. Start typing to replace the text or number. Remember, the same change happens to all tables that use that index.

'''Append a row''': Click the bottom element of the row index to select the bottom row, and press the ''down-arrow ''key or select '''Append Row '''from the '''Edit '''menu.

'''Append a column''': Click the rightmost element of the column index to select the right column, and press the ''right- arrow ''key or select '''Append Column '''from the '''Edit '''menu.

'''Insert a row or column''':
# Click the row or column header to select the row or column before which you wish to insert a new one.
# Select '''Insert Rows '''(or '''Insert Columns''') from the '''Edit '''menu, or press or ''Control+i''.
Normally, the new row or column contains zeros. You can change this default with the system variable <code>Sys_tableCellDefault</code>. You can also set table-specific default values, using the <code>TableCellDefault</code> attribute.

'''Reordering items ''':Items in a list view can be reordered by selecting one or more items and dragging the selected region to a new position. There is also a '''Reorder '''command on the right-mouse context menu. After selecting Reorder, move the mouse or use the arrow keys to move the selected cells to a newposition in the list.

'''Delete a row or column''':
# Click the row or column header to select the row or column you wish to delete.
# Choose '''Delete Rows '''or '''Delete Columns '''from the '''Edit '''menu, or press ''Control+k''.

<tip title="Tip">When you try to add an item to an index or delete an item from an index that is also used by another edit table, it warns you that ''“Changing the size of this index will affect table definitions of other variables.” ''and gives the option of whether to continue. Adding an item will add a new slice containing zeros, just as it does for the one you are editing. Similarly, deleting an item will delete a slice from these other edit table.</tip>

<tip title="Tip">If you intend your model to be used by end users with the Power Player editions (which is fixed in browse mode), or with the Free 101 edition (which is fixed is browse mode when your model has more than 101 user objects), or if youintend to save your model as browse-only (if you have the Enterprise Edition), you can decide whether you want to allow your end users to be able to edit indexes as described above. Create an input node for each index that you want to let them change. Or don’t to prevent them from changing an index.</tip>

'''Add an index''': To add an index, use one of these two methods:
* Draw an arrow from the index to the node containing the table. When it asks if you want to add the index as a new dimension of the table, answer '''Yes'''.
* Click [[File:Chapter11_71.jpg]] in the edit table to open the Indexes dialog. Double-click the index you want to add, and click '''OK'''.

When adding a new dimension to an edit table, it copies the values of the table to each new sub- array over the new index. Thus, the expanded table has the same values for every element of the new index. This has no effect on other edit tables.

'''Remove an index''': To remove an index, use one of these two methods:
* Draw an arrow from the index to the node containing the table. When it asks if you want to remove the index as a dimension of the table, answer '''Yes'''.
* Or, click [[File:Chapter11_71.jpg]] in the edit table to open the Indexes dialog. Double-click the index you want to remove, and click '''OK'''.

<tip title="Tip">When removing a dimension from an edit table, it replaces the entire table by its subarray for the first value of the index you are removing. It deletes all the rest. Be careful, because you will lose all the data in the rest of the table! This has no effect on other edit tables.</tip>

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[Defining a variable as an edit table]] <- || [[Editing a table]] || -> [[Splice a table when computed indexes change]]
|}
</translate>

To edit a table

2015-09-24T12:10:34Z

DKontotasiou: Created page with "Category:Analytica User Guide <languages /> <translate> Analytica User Guide > Editing a table To open the '''Edit Table '''window, click the '''Edit Table '''but..."

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] > [[Editing a table]]

To open the '''Edit Table '''window, click the '''Edit Table '''button in either:
* The Object window
* The Attribute panel of the diagram
In the '''Attribute '''panel, select '''Definition ''' from the '''Attribute '''popup menu.

'''The Edit Table window''': The '''Edit Table '''window looks much like the '''Result '''window table view'''. The difference is that you can add indexes and edit the values in cells.

[[File:Chapter11_67.jpg]]

'''Edit a cell''': Click the cell, and start typing to replace what’s in it. To add to what’s there, click three times to get a cursor in the cell, and type. You can use ''left-arrow ''and ''right-arrow ''keys to move the cursor. Press ''Enter ''to accept the value and to select the next cell, or click in another cell.

<tip title="Tip">You can enter an expression into a table cell with operations, function calls, and so on. But, if the expression is complex, it’s easier to enter it as the definition of a new variable, and then just type the name of the variable into the table.</tip>

'''Select a cell''': Click the cell once.

'''Select a range of cells''': Drag the cursor from a cell at one corner of a rectangular region to the cell at the opposite corner.

'''Copy and paste a cell or region''': You can copy a cell or a range (two-dimensional rectangular region) of cells from a table or paste a cell into a region, just as with a spreadsheet:
# Select the source cell or region as above, and choose '''Copy '''from the '''Edit '''menu or press ''Control+c''.
# Select the destination cell (or top-left cell of the destination region), and choose '''Paste '''from the '''Edit '''menu or press ''Control+v''.
If you select a destination region that is '''n '''times larger (width, height, or both) than the source cell or region, it repeats the source '''n '''times in the destination.

'''Accept''': Click [[File:Chapter11_68.jpg]] to accept all the changes you have made to the table. If you close a table, it also accepts the changes, unless you click [[File:Chapter11_69.jpg]].

'''Cancel''': Click [[File:Chapter11_69.jpg]] to cancel all the changes you have made to the table since you opened it or last clicked [[File:Chapter11_68.jpg]].

'''Copy and paste to or from a spreadsheet''': Copy and paste of a cell or region works much the same from a spreadsheet to an Analytica table or vice versa. If necessary, you can easily pivot the Analytica table so its rows and columns correspond with those in the spreadsheet. It copies numbers in exponential format with full precision, no matter what number format is used in the table, so that other applications can receive them with no problems.

'''Copy an entire table''': To copy a table, including its row and column headers, click the top-left cell to select the whole table. You can also copy a table with more than two dimensions: Select '''Copy table '''from the '''Edit '''menu. When you paste into a spreadsheet, it includes the name of the table, and all indexes, including the slicer index(es) for the third and higher dimensions.

'''Entering multi-line text''': When entering multi-line text or multiple line expressions into single cells of an edit table, press ''Ctrl+Enter ''while editing the cell contents to insert a new line within the cell. Pressing just ''Enter ''when editing the contents of a cells accepts the changes for that cell and leaves the cell edit; hence, you need to hold Alt when inserting the new line. You can also select '''Add new line within cell '''from the right-mouse context menu while editing.

==Editing or extending indexes in an edit table==
One convenient aspect of Intelligent Arrays is that you can edit and extend the indexes of an array right in the edit table, to change index values, insert or remove rows or columns, or, more generally, subarrays.

This works for an index defined as a list of numbers or list of labels. If an index is defined in another way — for example as <code>m .. n</code> or <code>Sequence(x1, x2, dx)</code>— you must edit the original index. Either way, all edit tables that use the changed index are automatically modified accordingly.

To edit or extend an index, either you must be in edit mode [[File:Chapter11_70.jpg]] or the index variable you want to modify must have an input node.

'''Edit a cell in a row or column index''': Click the cell once to select its row or column. Then double-click the cell to select its contents. Start typing to replace the text or number. Remember, the same change happens to all tables that use that index.

'''Append a row''': Click the bottom element of the row index to select the bottom row, and press the ''down-arrow ''key or select '''Append Row '''from the '''Edit '''menu.

'''Append a column''': Click the rightmost element of the column index to select the right column, and press the ''right- arrow ''key or select '''Append Column '''from the '''Edit '''menu.

'''Insert a row or column''':
# Click the row or column header to select the row or column before which you wish to insert a new one.
# Select '''Insert Rows '''(or '''Insert Columns''') from the '''Edit '''menu, or press or ''Control+i''.
Normally, the new row or column contains zeros. You can change this default with the system variable <code>Sys_tableCellDefault</code>. You can also set table-specific default values, using the <code>TableCellDefault</code> attribute.

'''Reordering items ''':Items in a list view can be reordered by selecting one or more items and dragging the selected region to a new position. There is also a '''Reorder '''command on the right-mouse context menu. After selecting Reorder, move the mouse or use the arrow keys to move the selected cells to a newposition in the list.

'''Delete a row or column''':
# Click the row or column header to select the row or column you wish to delete.
# Choose '''Delete Rows '''or '''Delete Columns '''from the '''Edit '''menu, or press ''Control+k''.

<tip title="Tip">When you try to add an item to an index or delete an item from an index that is also used by another edit table, it warns you that ''“Changing the size of this index will affect table definitions of other variables.” ''and gives the option of whether to continue. Adding an item will add a new slice containing zeros, just as it does for the one you are editing. Similarly, deleting an item will delete a slice from these other edit table.</tip>

<tip title="Tip">If you intend your model to be used by end users with the Power Player editions (which is fixed in browse mode), or with the Free 101 edition (which is fixed is browse mode when your model has more than 101 user objects), or if youintend to save your model as browse-only (if you have the Enterprise Edition), you can decide whether you want to allow your end users to be able to edit indexes as described above. Create an input node for each index that you want to let them change. Or don’t to prevent them from changing an index.</tip>

'''Add an index''': To add an index, use one of these two methods:
* Draw an arrow from the index to the node containing the table. When it asks if you want to add the index as a new dimension of the table, answer '''Yes'''.
* Click [[File:Chapter11_71.jpg]] in the edit table to open the Indexes dialog. Double-click the index you want to add, and click '''OK'''.

When adding a new dimension to an edit table, it copies the values of the table to each new sub- array over the new index. Thus, the expanded table has the same values for every element of the new index. This has no effect on other edit tables.

'''Remove an index''': To remove an index, use one of these two methods:
* Draw an arrow from the index to the node containing the table. When it asks if you want to remove the index as a dimension of the table, answer '''Yes'''.
* Or, click [[File:Chapter11_71.jpg]] in the edit table to open the Indexes dialog. Double-click the index you want to remove, and click '''OK'''.

<tip title="Tip">When removing a dimension from an edit table, it replaces the entire table by its subarray for the first value of the index you are removing. It deletes all the rest. Be careful, because you will lose all the data in the rest of the table! This has no effect on other edit tables.</tip>

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[Introduction: About Analytica]] <- || [[Hardwareand software requirements]] || -> [[Installation and licenses]]
|}
</translate>

File:Chapter11 71.jpg

2015-09-24T12:09:25Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 70.jpg

2015-09-24T12:05:12Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 68.jpg

2015-09-24T11:58:37Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 69.jpg

2015-09-24T11:58:36Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 67.jpg

2015-09-24T11:55:51Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

To make an edit table

2015-09-24T11:51:52Z

DKontotasiou: /* Indexes dialog */

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] >[[Defining a variable as an edit table]]
__NOTOC__
To define a variable as an edit table, you choose '''Table '''from the '''''expr '''''menu above its definition:

<ol><li> Select the variable and open its definition using one of these options:
* Use the variable’s '''Object '''window.
* From the '''Attribute '''panel of the '''Diagram '''window, select '''Definition '''from the '''Attribute''' popup menu.
* Press ''Control+e''.</li>
<li> Press the '''''expr '''''menu above the definition field and select '''Table'''. [[File:Chapter11_61.jpg]] 
If it already has a definition, click '''OK '''to confirms that you wish to replace it. 
[[File:Chapter11_62.jpg]]</li>
<li>It opens the '''Indexes '''dialog so you can select the table’s indexes (dimensions). It already lists under '''Selected indexes '''any index variables from which you have drawn an arrow to this variable. You can keep them, remove them, or add more indexes.

[[File:Chapter11_63.jpg]]</li>
<li>Select a variable from the '''Indexes '''list and click the move button, or double-click the variable, to select it as an index of the table. Repeat for each index you want.</li>
<li> Click '''OK '''to create the table and open the [[Edit Table window]] for editing the table’s values.</li></ol>

== Indexes dialog ==
The '''Indexes '''dialog contains these features (see figure above):

:''Preview'': A list of the values of the selected index variable. If the selected variable is not a list, it says "Can’t use as index''.
:''All Variables'' check- box: If checked, the ''Indexes ''list includes all variables in the model. If not checked, it lists only variables of the class '''Index '''and '''Decision''', plus the variable being defined ('''Self''') and '''Time'''. If you select '''Self '''as an index, the variable itself holds the alternative index values.
:''Selected Indexes'': A list of all indexes already selected for this variable.
:''New index'': Select to create a new index.

'''To create an index''': You can create an index variable in the course of creating a table, in the following way:
<ol><li> Select '''''new index '''''from the '''Indexes '''list in the '''Indexes '''dialog.</li>
<li> Enter a title for the index. [[File:Chapter11_64.jpg]]</li>
<li> Click the '''Create '''button.</li>
<li> To make the new index an index of the table, click the [[File:Chapter11_65.jpg]] button.</li>
<li> Enter the values of the Index in the '''Edit Table '''window (see the following section).</li></ol>

'''To remove an index from an array''':
# Select the index from the '''Selected Indexes '''list.
# Click the [[File:Chapter11_66.jpg]] button.
Removing an index leaves the subarray for the first item in that index as the value of the entire array.

'''System index variables <code>Run</code> and <code>Time</code>''': Analytica includes two system index variables: <code>Run</code> and <code>Time</code>. You can generally treat these variables like any index variable.

<code>Run</code> is the index for the array of sample values for probabilistic simulation. You can examine the array with the sample uncertainty mode or the Sample() function.

<code>Time</code> is the index for dynamic simulation. It is the only index permitted for cyclically dependent modeling.

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[Functions that create indexes]] <- || [[Defining a variable as an edit table]] || -> [[Editing a table]]
|}
</translate>

To make an edit table

2015-09-24T11:51:11Z

DKontotasiou: /* Indexes dialog */

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] >[[Defining a variable as an edit table]]
__NOTOC__
To define a variable as an edit table, you choose '''Table '''from the '''''expr '''''menu above its definition:

<ol><li> Select the variable and open its definition using one of these options:
* Use the variable’s '''Object '''window.
* From the '''Attribute '''panel of the '''Diagram '''window, select '''Definition '''from the '''Attribute''' popup menu.
* Press ''Control+e''.</li>
<li> Press the '''''expr '''''menu above the definition field and select '''Table'''. [[File:Chapter11_61.jpg]] 
If it already has a definition, click '''OK '''to confirms that you wish to replace it. 
[[File:Chapter11_62.jpg]]</li>
<li>It opens the '''Indexes '''dialog so you can select the table’s indexes (dimensions). It already lists under '''Selected indexes '''any index variables from which you have drawn an arrow to this variable. You can keep them, remove them, or add more indexes.

[[File:Chapter11_63.jpg]]</li>
<li>Select a variable from the '''Indexes '''list and click the move button, or double-click the variable, to select it as an index of the table. Repeat for each index you want.</li>
<li> Click '''OK '''to create the table and open the [[Edit Table window]] for editing the table’s values.</li></ol>

== Indexes dialog ==
The '''Indexes '''dialog contains these features (see figure above):

:''Preview'': A list of the values of the selected index variable. If the selected variable is not a list, it says "Can’t use as index''.
:"All Variables ''check- box: If checked, the ''Indexes ''list includes all variables in the model. If not checked, it lists only variables of the class '''Index '''and '''Decision''', plus the variable being defined ('''Self''') and '''Time'''. If you select '''Self '''as an index, the variable itself holds the alternative index values.
:''Selected Indexes'': A list of all indexes already selected for this variable.
:''New index'': Select to create a new index.

'''To create an index''': You can create an index variable in the course of creating a table, in the following way:
<ol><li> Select '''''new index '''''from the '''Indexes '''list in the '''Indexes '''dialog.</li>
<li> Enter a title for the index. [[File:Chapter11_64.jpg]]</li>
<li> Click the '''Create '''button.</li>
<li> To make the new index an index of the table, click the [[File:Chapter11_65.jpg]] button.</li>
<li> Enter the values of the Index in the '''Edit Table '''window (see the following section).</li></ol>

'''To remove an index from an array''':
# Select the index from the '''Selected Indexes '''list.
# Click the [[File:Chapter11_66.jpg]] button.
Removing an index leaves the subarray for the first item in that index as the value of the entire array.

'''System index variables <code>Run</code> and <code>Time</code>''': Analytica includes two system index variables: <code>Run</code> and <code>Time</code>. You can generally treat these variables like any index variable.

<code>Run</code> is the index for the array of sample values for probabilistic simulation. You can examine the array with the sample uncertainty mode or the Sample() function.

<code>Time</code> is the index for dynamic simulation. It is the only index permitted for cyclically dependent modeling.

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[Functions that create indexes]] <- || [[Defining a variable as an edit table]] || -> [[Editing a table]]
|}
</translate>

To make an edit table

2015-09-24T11:50:32Z

DKontotasiou:

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] >[[Defining a variable as an edit table]]
__NOTOC__
To define a variable as an edit table, you choose '''Table '''from the '''''expr '''''menu above its definition:

<ol><li> Select the variable and open its definition using one of these options:
* Use the variable’s '''Object '''window.
* From the '''Attribute '''panel of the '''Diagram '''window, select '''Definition '''from the '''Attribute''' popup menu.
* Press ''Control+e''.</li>
<li> Press the '''''expr '''''menu above the definition field and select '''Table'''. [[File:Chapter11_61.jpg]] 
If it already has a definition, click '''OK '''to confirms that you wish to replace it. 
[[File:Chapter11_62.jpg]]</li>
<li>It opens the '''Indexes '''dialog so you can select the table’s indexes (dimensions). It already lists under '''Selected indexes '''any index variables from which you have drawn an arrow to this variable. You can keep them, remove them, or add more indexes.

[[File:Chapter11_63.jpg]]</li>
<li>Select a variable from the '''Indexes '''list and click the move button, or double-click the variable, to select it as an index of the table. Repeat for each index you want.</li>
<li> Click '''OK '''to create the table and open the [[Edit Table window]] for editing the table’s values.</li></ol>

== Indexes dialog ==
The '''Indexes '''dialog contains these features (see figure above):

: ''Preview'': A list of the values of the selected index variable. If the selected variable is not a list, it says "Can’t use as index''.
: "All Variables ''check- box: If checked, the ''Indexes ''list includes all variables in the model. If not checked, it lists only variables of the class '''Index '''and '''Decision''', plus the variable being defined ('''Self''') and '''Time'''. If you select '''Self '''as an index, the variable itself holds the alternative index values.
: ''Selected Indexes'': A list of all indexes already selected for this variable.
: ''New index'': Select to create a new index.

'''To create an index''': You can create an index variable in the course of creating a table, in the following way:
<ol><li> Select '''''new index '''''from the '''Indexes '''list in the '''Indexes '''dialog.</li>
<li> Enter a title for the index.

[[File:Chapter11_64.jpg]]</li>
<li> Click the '''Create '''button.</li>
<li> To make the new index an index of the table, click the [[File:Chapter11_65.jpg]] button.</li>
<li> Enter the values of the Index in the '''Edit Table '''window (see the following section).</li></ol>

'''To remove an index from an array''':
# Select the index from the '''Selected Indexes '''list.
# Click the [[File:Chapter11_66.jpg]] button.
Removing an index leaves the subarray for the first item in that index as the value of the entire array.

'''System index variables <code>Run</code> and <code>Time</code>''': Analytica includes two system index variables: <code>Run</code> and <code>Time</code>. You can generally treat these variables like any index variable.

<code>Run</code> is the index for the array of sample values for probabilistic simulation. You can examine the array with the sample uncertainty mode or the Sample() function.

<code>Time</code> is the index for dynamic simulation. It is the only index permitted for cyclically dependent modeling.

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[Functions that create indexes]] <- || [[Defining a variable as an edit table]] || -> [[Editing a table]]
|}
</translate>

To make an edit table

2015-09-24T11:49:54Z

DKontotasiou:

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] >[[Defining a variable as an edit table]]
__NOTOC__
To define a variable as an edit table, you choose '''Table '''from the '''''expr '''''menu above its definition:

<ol><li> Select the variable and open its definition using one of these options:
* Use the variable’s '''Object '''window.
* From the '''Attribute '''panel of the '''Diagram '''window, select '''Definition '''from the '''Attribute''' popup menu.
* Press ''Control+e''.</li>
<li> Press the '''''expr '''''menu above the definition field and select '''Table'''. [[File:Chapter11_61.jpg]] 
If it already has a definition, click '''OK '''to confirms that you wish to replace it. 
[[File:Chapter11_62.jpg]]</li>
<li>It opens the '''Indexes '''dialog so you can select the table’s indexes (dimensions). It already lists under '''Selected indexes '''any index variables from which you have drawn an arrow to this variable. You can keep them, remove them, or add more indexes.

[[File:Chapter11_63.jpg]]</li>
<li>Select a variable from the '''Indexes '''list and click the move button, or double-click the variable, to select it as an index of the table. Repeat for each index you want.</li>
<li> Click '''OK '''to create the table and open the [#_bookmark817 Edit Table window] '''(p[#_bookmark817 age 18]0) for editing the table’s values.</li></ol>

== Indexes dialog ==
The '''Indexes '''dialog contains these features (see figure above):

: ''Preview'': A list of the values of the selected index variable. If the selected variable is not a list, it says "Can’t use as index''.
: "All Variables ''check- box: If checked, the ''Indexes ''list includes all variables in the model. If not checked, it lists only variables of the class '''Index '''and '''Decision''', plus the variable being defined ('''Self''') and '''Time'''. If you select '''Self '''as an index, the variable itself holds the alternative index values.
: ''Selected Indexes'': A list of all indexes already selected for this variable.
: ''New index'': Select to create a new index.

'''To create an index''': You can create an index variable in the course of creating a table, in the following way:
<ol><li> Select '''''new index '''''from the '''Indexes '''list in the '''Indexes '''dialog.</li>
<li> Enter a title for the index.

[[File:Chapter11_64.jpg]]</li>
<li> Click the '''Create '''button.</li>
<li> To make the new index an index of the table, click the [[File:Chapter11_65.jpg]] button.</li>
<li> Enter the values of the Index in the '''Edit Table '''window (see the following section).</li></ol>

'''To remove an index from an array''':
# Select the index from the '''Selected Indexes '''list.
# Click the [[File:Chapter11_66.jpg]] button.
Removing an index leaves the subarray for the first item in that index as the value of the entire array.

'''System index variables <code>Run</code> and <code>Time</code>''': Analytica includes two system index variables: <code>Run</code> and <code>Time</code>. You can generally treat these variables like any index variable.

<code>Run</code> is the index for the array of sample values for probabilistic simulation. You can examine the array with the sample uncertainty mode or the Sample() function.

<code>Time</code> is the index for dynamic simulation. It is the only index permitted for cyclically dependent modeling.

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[Functions that create indexes]] <- || [[Defining a variable as an edit table]] || -> [[Editing a table]]
|}
</translate>

To make an edit table

2015-09-24T11:49:11Z

DKontotasiou: Created page with "Category:Analytica User Guide <languages /> <translate> Analytica User Guide >Defining a variable as an edit table __NOTOC__ To define a variable as an edit table,..."

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] >[[Defining a variable as an edit table]]
__NOTOC__
To define a variable as an edit table, you choose '''Table '''from the '''''expr '''''menu above its definition:

<ol><li> Select the variable and open its definition using one of these options:
* Use the variable’s '''Object '''window.
* From the '''Attribute '''panel of the '''Diagram '''window, select '''Definition '''from the '''Attribute''' popup menu.
* Press ''Control+e''.</li>
<li> Press the '''''expr '''''menu above the definition field and select '''Table'''.

[[File:Chapter11_61.jpg]]

If it already has a definition, click '''OK '''to confirms that you wish to replace it.

[[File:Chapter11_62.jpg]]</li>
<li>It opens the '''Indexes '''dialog so you can select the table’s indexes (dimensions). It already lists under '''Selected indexes '''any index variables from which you have drawn an arrow to this variable. You can keep them, remove them, or add more indexes.

[[File:Chapter11_63.jpg]]</li>
<li>Select a variable from the '''Indexes '''list and click the move button, or double-click the variable, to select it as an index of the table. Repeat for each index you want.</li>
<li> Click '''OK '''to create the table and open the [#_bookmark817 Edit Table window] '''(p[#_bookmark817 age 18]0) for editing the table’s values.</li></ol>

== Indexes dialog ==
The '''Indexes '''dialog contains these features (see figure above):

: ''Preview'': A list of the values of the selected index variable. If the selected variable is not a list, it says "Can’t use as index''.
: "All Variables ''check- box: If checked, the ''Indexes ''list includes all variables in the model. If not checked, it lists only variables of the class '''Index '''and '''Decision''', plus the variable being defined ('''Self''') and '''Time'''. If you select '''Self '''as an index, the variable itself holds the alternative index values.
: ''Selected Indexes'': A list of all indexes already selected for this variable.
: ''New index'': Select to create a new index.

'''To create an index''': You can create an index variable in the course of creating a table, in the following way:
<ol><li> Select '''''new index '''''from the '''Indexes '''list in the '''Indexes '''dialog.</li>
<li> Enter a title for the index.

[[File:Chapter11_64.jpg]]</li>
<li> Click the '''Create '''button.</li>
<li> To make the new index an index of the table, click the [[File:Chapter11_65.jpg]] button.</li>
<li> Enter the values of the Index in the '''Edit Table '''window (see the following section).</li></ol>

'''To remove an index from an array''':
# Select the index from the '''Selected Indexes '''list.
# Click the [[File:Chapter11_66.jpg]] button.
Removing an index leaves the subarray for the first item in that index as the value of the entire array.

'''System index variables <code>Run</code> and <code>Time</code>''': Analytica includes two system index variables: <code>Run</code> and <code>Time</code>. You can generally treat these variables like any index variable.

<code>Run</code> is the index for the array of sample values for probabilistic simulation. You can examine the array with the sample uncertainty mode or the Sample() function.

<code>Time</code> is the index for dynamic simulation. It is the only index permitted for cyclically dependent modeling.

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[Functions that create indexes]] <- || [[Defining a variable as an edit table]] || -> [[Editing a table]]
|}
</translate>

File:Chapter11 66.jpg

2015-09-24T11:46:50Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 65.jpg

2015-09-24T11:45:00Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 64.jpg

2015-09-24T11:42:35Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 63.jpg

2015-09-24T11:39:08Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 62.jpg

2015-09-24T11:37:43Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 61.jpg

2015-09-24T11:37:08Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

Creating an index

2015-09-23T16:21:17Z

DKontotasiou:

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] > [[Creating an index]]
__NOTOC__
An '''''index '''''is a class of variable used to identify a dimension of an array. The same index can identify the same dimension shared by many arrays. Sometimes, variables of other classes, such as a decision, can also be used as an index to identify a dimension of an array. For clarity, use an index variable whenever possible.

You create an index much like any other variable:

'''Create an index node''':
<ol><li> Select the edit tool [[File:Chapter11_48.jpg]] and open a '''Diagram '''window.</li>
<li> Drag the parallelogram shape [[File:Chapter11_49.jpg]] from the node palette to the diagram.</li>
<li> Type a title into the new index node.</li>
<li> Open the definition attribute for the new index:
* Either double-click the index node to open its '''Object '''window
* Or, select the index node, open the Attribute panel and select '''Definition''' from the '''Attribute '''menu.</li>
<li> Press the '''''expr '''''menu above the definition field, to see these options. 
[[File:Chapter11_50.jpg]] 
(If the variable already has a definition, Analytica confirms that you wish to replace it. Click '''OK '''to replace the definition with a one-element list.)</li>
<li> Select '''List '''(of numbers) or '''List of Labels '''according to whether you want to enter a list of numbers or text values. It will display a list with one item in the definition field. [[File:Chapter11_51.jpg]]</li>
<li> Click the cell to select it, and Type in a number for '''List '''or text for '''List of Labels'''.</li>
<li> Press ''Enter ''or ''down-arrow ''to add a cell for the next item. Type in its value.</li>
<li> Repeat until you have entered all the values you want. 
[[File:Chapter11_52.jpg]]</li></ol>

'''Autofill a list''': It gives the first cell of a list the default value of 1 (or the previous definition if it had one). When you press ''Enter ''or ''down-arrow'', it adds a cell adding 1, or the increment between the two preceding cells, to the value of the preceding cell.

'''Expression view''': You can display a list or list of labels as a '''''list view''''', the default view showing as a column of cells, or as an '''''expression view''''', showing it as a list of items between square brackets. Select [[File:Chapter11_53.jpg]] from the toolbar to show the '''expression view'''. For example, here is a list of numbers in each view.

[[File:Chapter11_54.jpg]]

'''List of labels''': In a list of labels, every value is text. In the expression view, each label is enclosed in single quotation marks.

[[File:Chapter11_55.jpg]]

To include a single quote (apostrophe) as part of the text in a label in expression view, insert two adjacent single quotes, or enclose in double quotes:

:<code>['can''t','won''t','didn''t']</code>

'''Mixing numbers and text''': A list can include a mix of text and numbers. In both views the text is contained in single quotation marks as shown below.

[[File:Chapter11_56.jpg]]

If you attempt to mix numbers and text in a list of labels, all the values are treated as text, as shown below.

[[File:Chapter11_57.jpg]]

<tip title="Tip">A list cell can contain any valid expression, including one that refers to other variables or one that evaluates to an array. If you are defining an index object, whose sole purpose should be to serve as an index and not as an array result, then each element should evaluate to a scalar; otherwise, a warning will result. For general variables, the use of expressions that return array results is often very useful.</tip>

==Editing a list==
You can edit a list by changing, adding, or deleting '''''cells '''''(list items).

'''Insert a cell''': To insert a cell anywhere other than at the end of the list, select a cell and choose '''Insert Rows''' (''Control+i'') from the '''Edit '''menu. The value in the selected cell is duplicated in the new cell.

To add a cell at the end of the list, select the last cell and press ''Enter ''or the ''down-arrow ''key.

To insert several contiguous cells in the middle of the list, select the number of cells you want to insert and choose '''Insert Rows '''(''Control+i'') from the '''Edit '''menu. It duplicates the value of the last selected cell as the default for the new cells.

'''Delete a cell''': To delete one or more contiguous cells, select them and:
* Choose '''Delete Rows '''from the '''Edit '''menu.
* Or, just press ''Control+k ''or ''Backspace''.

<tip title="Tip">If you add or delete a cell in a list that is an index of one or more edit tables, it will warn you that it will change the corresponding slices of the tables.</tip>

'''Navigating a list''': Use the ''up ''and ''down-arrow ''keys to move the cursor up and down the list, or simply click the cell you want.

== Defining an index as a sequence ==
'''Create a list with the Sequence option''': To define an index as a list of equally spaced numbers, it is usually easier to select the '''Sequence''' function from the '''''expr '''''menu (instead of '''List''').

[[File:Chapter11_58.jpg]]

Then it shows the Sequence() function in the '''Object Finder.

[[File:Chapter11_59.jpg]]

After entering the '''Start''', '''End''', and '''Stepsize '''values, click '''OK'''<nowiki>; the definition field</nowiki> shows the '''Sequence '''button with its parameters.

[[File:Chapter11_60.jpg]]

<tip title="Tip">To change the start, end, or stepsize parameters of a sequence, click the '''Sequence '''button.</tip>

To define an index as a sequence of successive integers, you can use the “'''..'''” operator in the expression view, for example:

:<code>Index Year := 2000 .. 2012</code>

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[IF a THEN b ELSE c with arrays]] <- || [[Creating an index]] || -> [[Functions that create indexes]]
|}
</translate>

Creating an index

2015-09-23T16:20:23Z

DKontotasiou:

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] > [[Creating an index]]
__NOTOC__
An '''''index '''''is a class of variable used to identify a dimension of an array. The same index can identify the same dimension shared by many arrays. Sometimes, variables of other classes, such as a decision, can also be used as an index to identify a dimension of an array. For clarity, use an index variable whenever possible.

You create an index much like any other variable:

'''Create an index node''':
<ol><li> Select the edit tool [[File:Chapter11_48.jpg]] and open a '''Diagram '''window.</li>
<li> Drag the parallelogram shape [[File:Chapter11_49.jpg]] from the node palette to the diagram.</li>
<li> Type a title into the new index node.</li>
<li> Open the definition attribute for the new index:
* Either double-click the index node to open its '''Object '''window
* Or, select the index node, open the Attribute panel and select '''Definition''' from the '''Attribute '''menu.</li>
<li> Press the '''''expr '''''menu above the definition field, to see these options.

[[File:Chapter11_50.jpg]]

(If the variable already has a definition, Analytica confirms that you wish to replace it. Click '''OK '''to replace the definition with a one-element list.)</li>
<li> Select '''List '''(of numbers) or '''List of Labels '''according to whether you want to enter a list of numbers or text values. It will display a list with one item in the definition field. [[File:Chapter11_51.jpg]]</li>
<li> Click the cell to select it, and Type in a number for '''List '''or text for '''List of Labels'''.</li>
<li> Press ''Enter ''or ''down-arrow ''to add a cell for the next item. Type in its value.</li>
<li> Repeat until you have entered all the values you want.

[[File:Chapter11_52.jpg]]</li></ol>

'''Autofill a list''': It gives the first cell of a list the default value of 1 (or the previous definition if it had one). When you press ''Enter ''or ''down-arrow'', it adds a cell adding 1, or the increment between the two preceding cells, to the value of the preceding cell.

'''Expression view''': You can display a list or list of labels as a '''''list view''''', the default view showing as a column of cells, or as an '''''expression view''''', showing it as a list of items between square brackets. Select [[File:Chapter11_53.jpg]] from the toolbar to show the '''expression view'''. For example, here is a list of numbers in each view.

[[File:Chapter11_54.jpg]]

'''List of labels''': In a list of labels, every value is text. In the expression view, each label is enclosed in single quotation marks.

[[File:Chapter11_55.jpg]]

To include a single quote (apostrophe) as part of the text in a label in expression view, insert two adjacent single quotes, or enclose in double quotes:

:<code>['can''t','won''t','didn''t']</code>

'''Mixing numbers and text''': A list can include a mix of text and numbers. In both views the text is contained in single quotation marks as shown below.

[[File:Chapter11_56.jpg]]

If you attempt to mix numbers and text in a list of labels, all the values are treated as text, as shown below.

[[File:Chapter11_57.jpg]]

<tip title="Tip">A list cell can contain any valid expression, including one that refers to other variables or one that evaluates to an array. If you are defining an index object, whose sole purpose should be to serve as an index and not as an array result, then each element should evaluate to a scalar; otherwise, a warning will result. For general variables, the use of expressions that return array results is often very useful.</tip>

==Editing a list==
You can edit a list by changing, adding, or deleting '''''cells '''''(list items).

'''Insert a cell''': To insert a cell anywhere other than at the end of the list, select a cell and choose '''Insert Rows''' (''Control+i'') from the '''Edit '''menu. The value in the selected cell is duplicated in the new cell.

To add a cell at the end of the list, select the last cell and press ''Enter ''or the ''down-arrow ''key.

To insert several contiguous cells in the middle of the list, select the number of cells you want to insert and choose '''Insert Rows '''(''Control+i'') from the '''Edit '''menu. It duplicates the value of the last selected cell as the default for the new cells.

'''Delete a cell''': To delete one or more contiguous cells, select them and:
* Choose '''Delete Rows '''from the '''Edit '''menu.
* Or, just press ''Control+k ''or ''Backspace''.

<tip title="Tip">If you add or delete a cell in a list that is an index of one or more edit tables, it will warn you that it will change the corresponding slices of the tables.</tip>

'''Navigating a list''': Use the ''up ''and ''down-arrow ''keys to move the cursor up and down the list, or simply click the cell you want.

== Defining an index as a sequence ==
'''Create a list with the Sequence option''': To define an index as a list of equally spaced numbers, it is usually easier to select the '''Sequence''' function from the '''''expr '''''menu (instead of '''List''').

[[File:Chapter11_58.jpg]]

Then it shows the Sequence() function in the '''Object Finder.

[[File:Chapter11_59.jpg]]

After entering the '''Start''', '''End''', and '''Stepsize '''values, click '''OK'''<nowiki>; the definition field</nowiki> shows the '''Sequence '''button with its parameters.

[[File:Chapter11_60.jpg]]

<tip title="Tip">To change the start, end, or stepsize parameters of a sequence, click the '''Sequence '''button.</tip>

To define an index as a sequence of successive integers, you can use the “'''..'''” operator in the expression view, for example:

:<code>Index Year := 2000 .. 2012</code>

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[IF a THEN b ELSE c with arrays]] <- || [[Creating an index]] || -> [[Functions that create indexes]]
|}
</translate>

Creating an index

2015-09-23T16:18:13Z

DKontotasiou: Created page with "Category:Analytica User Guide <languages /> <translate> Analytica User Guide > Creating an index An '''''index '''''is a class of variable used to identify a dime..."

[[Category:Analytica User Guide]]
<languages />
<translate>
[[Analytica User Guide]] > [[Creating an index]]

An '''''index '''''is a class of variable used to identify a dimension of an array. The same index can identify the same dimension shared by many arrays. Sometimes, variables of other classes, such as a decision, can also be used as an index to identify a dimension of an array. For clarity, use an index variable whenever possible.

You create an index much like any other variable:

'''Create an index node''':
# Select the edit tool [[File:Chapter11_48.jpg]] and open a '''Diagram '''window.
# Drag the parallelogram shape [[File:Chapter11_49.jpg]] from the node palette to the diagram.
# Type a title into the new index node.
# Open the definition attribute for the new index:
* Either double-click the index node to open its '''Object '''window
* Or, select the index node, open the Attribute panel and select '''Definition''' from the '''Attribute '''menu.
# Press the '''''expr '''''menu above the definition field, to see these options. [[File:Chapter11_50.jpg]] (If the variable already has a definition, Analytica confirms that you wish to replace it. Click '''OK '''to replace the definition with a one-element list.)
# Select '''List '''(of numbers) or '''List of Labels '''according to whether you want to enter a list of numbers or text values. It will display a list with one item in the definition field. [[File:Chapter11_51.jpg]]
# Click the cell to select it, and Type in a number for '''List '''or text for '''List of Labels'''.
# Press ''Enter ''or ''down-arrow ''to add a cell for the next item. Type in its value.
# Repeat until you have entered all the values you want.

[[File:Chapter11_52.jpg]]

'''Autofill a list''': It gives the first cell of a list the default value of 1 (or the previous definition if it had one). When you press ''Enter ''or ''down-arrow'', it adds a cell adding 1, or the increment between the two preceding cells, to the value of the preceding cell.

'''Expression view''': You can display a list or list of labels as a '''''list view''''', the default view showing as a column of cells, or as an '''''expression view''''', showing it as a list of items between square brackets. Select [[File:Chapter11_53.jpg]] from the toolbar to show the '''expression view'''. For example, here is a list of numbers in each view.

[[File:Chapter11_54.jpg]]

'''List of labels''': In a list of labels, every value is text. In the expression view, each label is enclosed in single quotation marks.

[[File:Chapter11_55.jpg]]

To include a single quote (apostrophe) as part of the text in a label in expression view, insert two adjacent single quotes, or enclose in double quotes:

:<code>['can''t','won''t','didn''t']</code>

'''Mixing numbers and text''': A list can include a mix of text and numbers. In both views the text is contained in single quotation marks as shown below.

[[File:Chapter11_56.jpg]]

If you attempt to mix numbers and text in a list of labels, all the values are treated as text, as shown below.

[[File:Chapter11_57.jpg]]

<tip title="Tip">A list cell can contain any valid expression, including one that refers to other variables or one that evaluates to an array. If you are defining an index object, whose sole purpose should be to serve as an index and not as an array result, then each element should evaluate to a scalar; otherwise, a warning will result. For general variables, the use of expressions that return array results is often very useful.</tip>

==Editing a list==
You can edit a list by changing, adding, or deleting '''''cells '''''(list items).

'''Insert a cell''': To insert a cell anywhere other than at the end of the list, select a cell and choose '''Insert Rows''' (''Control+i'') from the '''Edit '''menu. The value in the selected cell is duplicated in the new cell.

To add a cell at the end of the list, select the last cell and press ''Enter ''or the ''down-arrow ''key.

To insert several contiguous cells in the middle of the list, select the number of cells you want to insert and choose '''Insert Rows '''(''Control+i'') from the '''Edit '''menu. It duplicates the value of the last selected cell as the default for the new cells.

'''Delete a cell''': To delete one or more contiguous cells, select them and:
* Choose '''Delete Rows '''from the '''Edit '''menu.
* Or, just press ''Control+k ''or ''Backspace''.

<tip title="Tip">If you add or delete a cell in a list that is an index of one or more edit tables, it will warn you that it will change the corresponding slices of the tables.</tip>

'''Navigating a list''': Use the ''up ''and ''down-arrow ''keys to move the cursor up and down the list, or simply click the cell you want.

== Defining an index as a sequence ==
'''Create a list with the Sequence option''': To define an index as a list of equally spaced numbers, it is usually easier to select the '''Sequence''' function from the '''''expr '''''menu (instead of '''List''').

[[File:Chapter11_58.jpg]]

Then it shows the Sequence() function in the '''Object Finder.

[[File:Chapter11_59.jpg]]

After entering the '''Start''', '''End''', and '''Stepsize '''values, click '''OK'''<nowiki>; the definition field</nowiki> shows the '''Sequence '''button with its parameters.

[[File:Chapter11_60.jpg]]

<tip title="Tip">To change the start, end, or stepsize parameters of a sequence, click the '''Sequence '''button.</tip>

To define an index as a sequence of successive integers, you can use the “'''..'''” operator in the expression view, for example:

:<code>Index Year := 2000 .. 2012</code>

==See Also==
{| style="margin: 1em auto 1em auto;width: 100%;border:0;table-layout: fixed;" cellpadding=5
|- style="text-align: center"
| [[IF a THEN b ELSE c with arrays]] <- || [[Creating an index]] || -> [[Functions that create indexes]]
|}
</translate>

File:Chapter11 60.jpg

2015-09-23T16:17:20Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 59.jpg

2015-09-23T16:16:30Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 58.jpg

2015-09-23T16:15:00Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 57.jpg

2015-09-23T16:12:27Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 56.jpg

2015-09-23T16:10:57Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 55.jpg

2015-09-23T16:08:53Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload

File:Chapter11 54.jpg

2015-09-23T16:07:30Z

DKontotasiou: File uploaded with MsUpload

File uploaded with MsUpload