View source for ZCubes/How to Apply Advanced Spreadsheet Computations

==How to Apply Advanced Spreadsheet Computations==
<br/>
This video demonstrates how to define a function in ZCubes and do the computations for a series of values for parameters easily. You will understand how ZCubes differentiates itself from Excel or other typical spreadsheets in computing values for a set of data in a spreadsheet by creating functions. You can enable a function to handle array of values using arrayfy and a series of values can be passed as parameters.

==Video==
<br/>
{{#ev:youtube|FujG4f4cNUc|480|left|Advanced Spreadsheet Computations}}
<br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/>


==Examples==
Finding velocity : Final velocity (v) of an object equals initial velocity (u) of that object plus acceleration (a) of the object times the elapsed time (t) from u to v. For standard gravity, a = 9.80665 m/s2.

1. To find the final velocity (V), use the ZCubes code as-
<br/>
<math>V := u+a*t;</math>
<br/>
<math>V(1,9.8,1)</math>

displays the result as ''10.8''.


2. To find the final velocity(V) for array of values of 't' from 1 to 30, use the following ZCubes code as-
<br/>
<math>V := u+a*t;</math>
<br/>
<math>V arr;</math>               //typing arr and pressing Shift+Space key gives an character '#'
<br/>
<math>V(1,9.8,1..30)</math>

displays the final velocity values with varying inputs of time as: 
<br/>
 u      t       V
</br>   9.8  	1 	10.8
<br/>	9.8	2	20.6
<br/>	9.8	3	30.400000000000002
<br/>	9.8	4	40.2
<br/>	9.8	5	50
<br/>	9.8	6	59.800000000000004
<br/>	9.8	7	69.60000000000001
<br/>   9.8	8	79.4
<br/>	9.8	9	89.2
<br/>	9.8	10	99
<br/>	9.8	11	108.80000000000001
<br/>	9.8	12	118.60000000000001
<br/>	9.8	13	128.4
<br/>	9.8	14	138.20000000000002
<br/>	9.8	15	148
<br/>	9.8	16	157.8
<br/>	9.8	17	167.60000000000002
<br/>	9.8	18	177.4
<br/>	9.8	19	187.20000000000002
<br/>	9.8	20	197
<br/>	9.8	21	206.8
<br/>	9.8	22	216.60000000000002
<br/>	9.8	23	226.4
<br/>	9.8	24	236.20000000000002
<br/>   9.8	25	246.00000000000003
<br/>	9.8	26	255.8
<br/>	9.8	27	265.6
<br/>	9.8	28	275.40000000000003
<br/>	9.8	29	285.20000000000005
<br/>	9.8	30	295


<br/>
*[[Z3 | Z3 home]]
*[[Z^3 Language Documentation]]
*[[ZCubes_Videos | ZCubes Videos and Tutorials]]
*[[Main_Page | About ZCubes ]]
<br/>
<br/>
&copy; Copyright 1996-2020, ZCubes, Inc.