writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 8:
Line 8: + + + + + + + + + + + + + + + + + + + + +
ZCubes/Programming in Z space and CALCI Spreadsheet (view source)
Revision as of 07:32, 31 March 2020
, 07:32, 31 March 2020no edit summary
<br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/>
<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:
<br/>dist:= speed *time;
<br/>dist(2,3)
<br/>-->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/>cell A1 --> ==F:=m * a;
<br/>Suppose B1=5, B2=6
<br/>cell C1 --> =F(B1,B2)
<br/>-->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.