# Difference between revisions of "ZCubes/Programming in Z space and CALCI Spreadsheet"

(One intermediate revision by one other user not shown) | |||

Line 12: | Line 12: | ||

<br/>e.g 1) In Z3 code editor: | <br/>e.g 1) In Z3 code editor: | ||

− | + | dist:= speed *time; | |

− | + | dist(2,3) | |

− | + | -->This function displays result as 6. | |

− | |||

Line 22: | Line 21: | ||

<br/>e.g. 2) A function can be defined directly in the CALCI cell by using '==' sign and used directly in other cell. | <br/>e.g. 2) A function can be defined directly in the CALCI cell by using '==' sign and used directly in other cell. | ||

− | <br/>cell A1 | + | <br/>Define the function in cell A1 as: |

+ | ==F:=m * a; | ||

<br/>Suppose B1=5, B2=6 | <br/>Suppose B1=5, B2=6 | ||

− | <br/>cell C1 | + | <br/>Call the function in cell C1 as: |

− | + | =F(B1,B2) | |

− | + | -->This function displays result as 30. | |

Predefined functions such as SUM, ADD, SUBTRACT etc. and many other can be used directly in the CALCI as other spreadsheet softwares. | Predefined functions such as SUM, ADD, SUBTRACT etc. and many other can be used directly in the CALCI as other spreadsheet softwares. | ||

− | |||

<br/> | <br/> | ||

− | © Copyright 1996- | + | *[[Z3 | Z3 home]] |

+ | *[[Z^3 Language Documentation]] | ||

+ | *[[ZCubes_Videos | ZCubes Videos and Tutorials]] | ||

+ | *[[Main_Page | About ZCubes ]] | ||

+ | <br/> | ||

+ | <br/> | ||

+ | © Copyright 1996-2021, ZCubes, Inc. |

## Latest revision as of 00:21, 11 March 2021

## Programming in Z space and CALCI Spreadsheet

The video demonstrates how CALCI and the programming environment can interact each other. You can define a function in Z and this function can be called in CALCI. Likewise, functions can be written inside CALCI cell.

## Video

## Examples

This video demonstrates how any variable or a function defined in the Z3 code editor can be used directly in the CALCI cell.

e.g 1) In Z3 code editor:

dist:= speed *time; dist(2,3)

-->This function displays result as 6.

Now, in Calci, enter few cell values. Suppose B1=34 and B2=4. Then the function 'dist' can be used directly as - =dist(B1,B2) that displays the result as 136.
You can change the value of particular cell (e.g by selecting B1-->CAPTURE from the info table at the bottom --> CHANGE). You can observe the change in result value, as you change B1.

e.g. 2) A function can be defined directly in the CALCI cell by using '==' sign and used directly in other cell.

Define the function in cell A1 as:

==F:=m * a;

Suppose B1=5, B2=6

Call the function in cell C1 as:

=F(B1,B2)

-->This function displays result as 30.

Predefined functions such as SUM, ADD, SUBTRACT etc. and many other can be used directly in the CALCI as other spreadsheet softwares.

© Copyright 1996-2021, ZCubes, Inc.