ZCubes/How to Apply Advanced Spreadsheet Computations

How to Apply Advanced Spreadsheet Computations

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

Advanced Spreadsheet Computations

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-

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-

//typing arr and pressing Shift+Space key gives an character '#'

displays the final velocity values with varying inputs of time as:

u      t       V

9.8 1 10.8
9.8 2 20.6
9.8 3 30.400000000000002
9.8 4 40.2
9.8 5 50
9.8 6 59.800000000000004
9.8 7 69.60000000000001
9.8 8 79.4
9.8 9 89.2
9.8 10 99
9.8 11 108.80000000000001
9.8 12 118.60000000000001
9.8 13 128.4
9.8 14 138.20000000000002
9.8 15 148
9.8 16 157.8
9.8 17 167.60000000000002
9.8 18 177.4
9.8 19 187.20000000000002
9.8 20 197
9.8 21 206.8
9.8 22 216.60000000000002
9.8 23 226.4
9.8 24 236.20000000000002
9.8 25 246.00000000000003
9.8 26 255.8
9.8 27 265.6
9.8 28 275.40000000000003
9.8 29 285.20000000000005
9.8 30 295