View source for ZCubes/Programming in Z space and CALCI Spreadsheet

==Programming in Z space and CALCI Spreadsheet==
<br/>
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==
<br/>
{{#ev:youtube|EI6fqrWx_yc|480|left|Programming in Z space and CALCI Spreadsheet}}
<br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/>

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

<br/>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.

<br/>e.g. 2) A function can be defined directly in the CALCI cell by using '==' sign and used directly in other cell.
<br/>Define the function in cell A1 as:  
 ==F:=m * a;
<br/>Suppose B1=5, B2=6
<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.


<<[[Learn_ZCubes | Learn ZCubes ]]
<br/>
&copy; Copyright 1996-2020, ZCubes, Inc.