ZCubes/How to Apply Advanced Spreadsheet Computations - Revision history

Jayaram: /* Examples */

2021-09-14T19:07:47Z

Examples

Swapna at 10:01, 13 March 2020

2020-03-13T10:01:47Z

Jayaram: /* Video */

2020-03-06T10:26:09Z

Video

Jayaram: Created page with "==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 paramete..."

2020-03-06T09:54:16Z

Created page with "==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 paramete..."

New page

==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==
 
{{#ev:youtube|FujG4f4cNUc|480|center|Advanced Spreadsheet Computations}}
 

<<[[Learn_ZCubes | Learn ZCubes ]]
 
© Copyright 1996-2020, ZCubes, Inc.

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

← Older revision		Revision as of 10:01, 13 March 2020
Line 8:		Line 8:
	<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==
		+	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

@@ Line 5: / Line 5: @@
 ==Video==
 <br/>
-{{#ev:youtube|FujG4f4cNUc|480|center|Advanced Spreadsheet Computations}}
+{{#ev:youtube|FujG4f4cNUc|480|left|Advanced Spreadsheet Computations}}
 <br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/>

ZCubes/How to Apply Advanced Spreadsheet Computations - Revision history

Jayaram: /* Examples */

Swapna at 10:01, 13 March 2020

Jayaram: /* Video */

Jayaram: Created page with "==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 paramete..."

Jayaram: Created page with "==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 paramete..."