- Getting Started
New to Livesheets?

This is how you get started.

Once you've entered your username and password, this is what you'll see

The first thing you should do is double-click in some empty space, and you'll create a node

You can type a calculation straight into the box and it will show you the answer.

Try 12*35

You can double click in empty space to make as many nodes as you like.

If you select a node or hover your mouse over it, you'll see a little blob at the bottom.

You can use this to create new nodes or connect existing nodes together.

Try grabbing the blob and dropping it in some empty space...

and when you drop it, you'll get a new node, which you can use in your calculation. You'll see it refers to the original node by its name (A, in this case).

Try adding 5 to A and you'll see how this works (write '+ 5' in the box, after the A)

You can also make a connection by starting to type a name into a box. It will pop up, and you can select it from the list.

Try this out - go to box B and try typing +A at the end. Then use the mouse to select it.

Livesheets will automatically connect it up

Finally - those names? You can change them to whatever you want.

Just double-click over the name

You'll be able to change it to something more useful

and it will update itself wherever you've used it

Good luck. Have fun. Ask if you have trouble: talktome@livesheets.com

- append function
**Description**Adds an item to the end of a list.

**Syntax**append(item,list)

**Example** - arrcount function
**Description**Counts how many times an item occurs in an array.

**Syntax**arrcount(item,list)

If comparing text, it is case sensitive.

**Example** - Boolean operations
You can perform boolean operations in Livesheets.

For 'true' you can type

*true*or*yes*For 'false' you can type

*false*or*no*.Livesheets can perform boolean operations including:

*and*,*or*,*not*Livesheets will return

*yes*or*no.***Examples** - ceiling function
Description

Gives you the next highest multiple of significance.

**Syntax**ceiling(number,significance)

significance is optional. If excluded it will use the default value 1.

**Examples** - Comments
**Description**You can write comments in a formula. Comments can be read by the person looking at them but will be ignored when executing.

**Syntax**Simply type '//' (without the quotes) at the end of a formula and you can then add comments at the end.

//comments go here

**Example** - comparisons
There are 5 symbols or combinations of symbols which can be used for comparisons.

They are:

< less than

> more than

= equal to

<= less than or equal to

>= more than or equal to.

For example,

1<2

will return ‘yes’

2<2

will return ‘no’

2>2 will return ‘no’

3>2 will return ‘yes’

2<=2

will return ‘yes’

2>=2 will return ‘yes’

1+4=5

will return ‘yes’

You can also use it for text.

“hello”=”hello”

will return ‘yes’.

And it’s case sensitive:

“hello”=”Hello”

will return ‘no’.

This is how those look in Livesheets

- concatenate function
**Description**Attaches ('concatenates') strings of text together.

**Syntax**concatenate(text1,text2,text3,...)

or

concatenate(list1,list2,list3,...)

The arguments can be any combination of lists or single items.

**Example** - cos function
**Description**Tells you the cosine of an angle, in radians.

**Syntax**cos(angle)

**Example** - count function
**Description**counts the number of items in a list

**Syntax**count(list)

**Example** - difference function
**Description**Operates on two lists and it gives you a list of the members of the first that are not in the second.

**Syntax**difference(A,B)

returns a list of the members of A which are not in B.

**Example** - extend function
**Description**Sticks two or more lists together.

**Syntax**extend(list1,list2,...)

**Example** - find function
**Description**Searches for one string of text within another and returns its starting position.

**Syntax**find(text_to_find,within_longer_text,starting_at_position)

This function is case sensitive. To do a case sensitive search, you can use the lower() or upper() function on both text strings.

starting_at_position is optional.

**Examples** - floor function
**Description**Gives you next closest multiple of significance without exceeding number.

**Syntax**floor(number,significance)

significance is optional. If excluded it will use default value 1.

**Examples** - If Function
**Description**The If function tests a condition and returns one value if true or the other value if false.**Syntax**if(condition,value_if_true,value_if_false)

**Example**if(1=2,"yes it's equal","no it's not equal")

- insert function
**Description**Inserts an item into a list at a given position.

**Syntax**insert(list,position,item)

**Example** - int function
**Description**Gives you the integer part of a number.

**Syntax**int(number)

**Example** - intersection function
**Description**Operates on two lists and gives you the items which are in both lists.

**Syntax**intersection(list1,list2)

**Example** - isnothing function
**Description**If a function fails, it returns the value

*nothing.*However, you can't directly test for nothing - it will return*nothing*instead of*true*.The isnothing function gives you a way to test whether another node has returned

*nothing*.**Syntax**isnothing(value)

**Example** - left function
**Description**The left function returns the specified number of characters from the left-hand side of a string of text.

**Syntax**left(text,num_characters)

If

*num_characters*is more than the length of the text, it will return*text*.**Example** - len function
**Description**returns the length of a string of text.

**Syntax**len(text)

**Example** - log function
**Description**The log function tells you the logarithm of a number with a given base.**Syntax**log(number,base)

**Example** - lower function
**Description**Converts a string of text to lower case

**Syntax**lower(text)

**Example** - match function
**Description**Tells you whether an item is a member of a list, and where it is in that list.

**Syntax**match(item,list)

**Example** - matchall function
**Description**Like the match function, it tells you where an item sits in a list, but gives you the position of every position it occurs in, instead of just one.

**Syntax**matchall(item,list)

**Example** - max function
**Description**Operates on any number of items or lists and returns the highest value found.

**Syntax**max(item1,item2,item3,...)

or

max(list1,list2,list3,...)

**Example** - mid function
**Description**returns a section from the middle of a string of text

**Syntax**mid(text,start_position,num_characters)

**Example** - min function
**Description**Operates on any number of items or lists and returns the lowest value found.

**Syntax**min(item1,item2,item3,...)

or

min(list1,list2,list3,...)

**Example** - mod function
**Description**Gives you the modulus of a number. That is, the remainder if you divide one number by another.

**Syntax**mod(number,modulus)

Examples

*mod(12,5)*=2because 2 is the remainder when you divide 12 by 5.

- pick function
**Description**The pick function lets you pick an item from a list.

**Syntax**pick(list,item_number)

The item number is an index starting at 1.

**Example** - proper function
**Description**Converts a string of text to 'proper' case (capitalising the first letter of each word and every word in lower case).

**Syntax**proper(text)

**Example** - range operator (:)
**Description**The range operator allows you to automatically generate a range of numbers.

**Syntax**from:to

This will generate a list of values from

*from*to*to*inclusive. The values can go in either direction, from low to high or high to low**Example** - reverse function
**Description**Reverse the order of a list

**Syntax**reverse(list)

**Example** - right function
**Description**returns the specified number of characters from the right-hand-side of a string of text

**Syntax**right(text,num_characters)

**Example** - round function
**Description**Rounds a number to the specified number of digits.

**Syntax**round(number,digits)

digits is optional. If excluded it will use the default value 0.

**Example** - sin function
**Description**Tells you the sine of an angle, in radians.

**Syntax**sin(angle)

**Example** - sort function
**Description**Sorts a list

**Syntax**sort(list)

**Example** - substitute function
**Description**Lets you search and replace inside text.

**Syntax**substitute(text,old_text,new_text,instance_num)

instance_num is optional. If this argument isn't included, it will replace every instance.

**Example** - trim function
**Description**Removes spaces on either side of the text.

**Syntax**trim(text)

Unlike the Excel version of this function, internal spaces are left intact.

**Example**This example shows the spaces on either side being trimmed. The two boxes at the bottom add brackets on either side so that we can see the extra space.

- union function
**Description**Operates on two lists and it gives you all of the items which are a member of at least one of the lists.

**Syntax**union(list1,list2)

**Example**union(A,B)

- unique function
**Description**Reduces a list to just one of each item.

**Syntax**unique(list)

**Example** - Universal Constants (e, pi)
Two universal constants are available in Livesheets, e and pi.

Access them simply by typing

e() or pi().

**Examples** - upper function
**Description**Converts a string of text to upper case

**Syntax**upper(text)

**Example**

For help, email talktome@livesheets.com