Difference between revisions of "Z API Functions"

From ZCubes Wiki
Jump to navigation Jump to search
 
(76 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 
==LIST OF ALL FUNCTIONS==
 
==LIST OF ALL FUNCTIONS==
==STATISTICAL FUNCTIONS1==
+
===Statistical Functions1===
 +
*[[Manuals/calci/Average, AverageA, AverageX Example| Example]]
 +
*[[Manuals/calci/z3console| z3console]]
 +
*[[Manuals/calci/Examples | Examples of Java and z3 programs]]
 +
*[[Manuals/calci/Examples1 | Engineering Examples in z3]]
 +
*[[Manuals/calci/Exampleslp | Linear Programming in z3]]
 
*[[Manuals/calci/AVEDEV | AVEDEV]]
 
*[[Manuals/calci/AVEDEV | AVEDEV]]
 
*[[Manuals/calci/AVERAGE | AVERAGE]]
 
*[[Manuals/calci/AVERAGE | AVERAGE]]
Line 18: Line 23:
 
*[[Manuals/calci/COUNT | COUNT]]
 
*[[Manuals/calci/COUNT | COUNT]]
 
*[[Manuals/calci/COUNTA | COUNTA]]
 
*[[Manuals/calci/COUNTA | COUNTA]]
 +
*[[Manuals/calci/COUNTBLANK | COUNTBLANK]]
 +
*[[Manuals/calci/COUNTIF | COUNTIF]]
 +
*[[Manuals/calci/COVAR | COVAR]]
 +
*[[Manuals/calci/COVARIANCEDATAANALYSIS | COVARIANCEDATAANALYSIS]]
 
*[[Manuals/calci/DECREASING | DECREASING]]
 
*[[Manuals/calci/DECREASING | DECREASING]]
 
*[[Manuals/calci/DECREMENT | DECREMENT]]
 
*[[Manuals/calci/DECREMENT | DECREMENT]]
 
*[[Manuals/calci/DESCRIBENUMBER | DESCRIBENUMBER]]
 
*[[Manuals/calci/DESCRIBENUMBER | DESCRIBENUMBER]]
 
*[[Manuals/calci/DESCRIPTIVESTATISTICS | DESCRIPTIVESTATISTICS]]
 
*[[Manuals/calci/DESCRIPTIVESTATISTICS | DESCRIPTIVESTATISTICS]]
*[[Manuals/calci/COUNTBLANK | COUNTBLANK]]
+
*[[Manuals/calci/DET | DET]]
*[[Manuals/calci/COUNTIF | COUNTIF]]
 
*[[Manuals/calci/COVAR | COVAR]]
 
*[[Manuals/calci/COVARIANCEDATAANALYSIS | COVARIANCEDATAANALYSIS]]
 
*[[Manuals/Manuals/calci/DET | DET]]
 
 
*[[Manuals/calci/DEVSQ | DEVSQ]]
 
*[[Manuals/calci/DEVSQ | DEVSQ]]
 
*[[Manuals/calci/FEQ | FEQ]]
 
*[[Manuals/calci/FEQ | FEQ]]
Line 115: Line 120:
 
*[[Manuals/calci/XBETWEEN | XBETWEEN]]
 
*[[Manuals/calci/XBETWEEN | XBETWEEN]]
  
==STATISTICAL FUNCTIONS2==
+
===Statistical Functions2===
 
*[[Manuals/calci/BERNOULLIDISTRIBUTED | BERNOULLIDISTRIBUTED]]
 
*[[Manuals/calci/BERNOULLIDISTRIBUTED | BERNOULLIDISTRIBUTED]]
 
*[[Manuals/calci/BETADIST | BETADIST]]
 
*[[Manuals/calci/BETADIST | BETADIST]]
Line 168: Line 173:
 
*[[Manuals/calci/SIGNTEST | SIGNTEST]]
 
*[[Manuals/calci/SIGNTEST | SIGNTEST]]
 
*[[Manuals/calci/SKEW | SKEW]]
 
*[[Manuals/calci/SKEW | SKEW]]
*[[Manuals/calci/SKEWSYMMETRIC | SKEWSYMMETRIC]]
 
 
*[[Manuals/calci/STATIC | STATIC]]
 
*[[Manuals/calci/STATIC | STATIC]]
 
*[[Manuals/calci/STATS | STATS]]
 
*[[Manuals/calci/STATS | STATS]]
Line 183: Line 187:
 
*[[Manuals/calci/ZTESTTWOSAMPLEFORMEANS | ZTESTTWOSAMPLEFORMEANS]]
 
*[[Manuals/calci/ZTESTTWOSAMPLEFORMEANS | ZTESTTWOSAMPLEFORMEANS]]
  
==MATH1==
+
===Math1===
 
*[[Manuals/calci/ABS | ABS]]
 
*[[Manuals/calci/ABS | ABS]]
 
*[[Manuals/calci/ACOS | ACOS]]
 
*[[Manuals/calci/ACOS | ACOS]]
 
*[[Manuals/calci/ACOSH | ACOSH]]
 
*[[Manuals/calci/ACOSH | ACOSH]]
*[[Manuals/calci/SUM | ADD]]
+
*[[Manuals/calci/ADD | ADD]]
 
*[[Manuals/calci/ADDBY | ADDBY]]
 
*[[Manuals/calci/ADDBY | ADDBY]]
 
*[[Manuals/calci/ADDCLAUSE | ADDCLAUSE]]
 
*[[Manuals/calci/ADDCLAUSE | ADDCLAUSE]]
Line 210: Line 214:
 
*[[Manuals/calci/CARTESIANPRODUCT | CARTESIANPRODUCT]]
 
*[[Manuals/calci/CARTESIANPRODUCT | CARTESIANPRODUCT]]
 
*[[Manuals/calci/CARTESIANPRODUCTWITHOUTFLATTEN | CARTESIANPRODUCTWITHOUTFLATTEN]]
 
*[[Manuals/calci/CARTESIANPRODUCTWITHOUTFLATTEN | CARTESIANPRODUCTWITHOUTFLATTEN]]
 +
*[[Manuals/calci/CAR | CDR]]
 
*[[Manuals/calci/CEILING | CEILING]]
 
*[[Manuals/calci/CEILING | CEILING]]
 
*[[Manuals/calci/CEILINGAT | CEILINGAT]]
 
*[[Manuals/calci/CEILINGAT | CEILINGAT]]
Line 217: Line 222:
 
*[[Manuals/calci/COMPLEMENT | COMPLEMENT]]
 
*[[Manuals/calci/COMPLEMENT | COMPLEMENT]]
 
*[[Manuals/calci/COS | COS]]
 
*[[Manuals/calci/COS | COS]]
 +
*[[Manuals/calci/COS#Examples | COSExamples]]
 
*[[Manuals/calci/COSEC | COSEC]]
 
*[[Manuals/calci/COSEC | COSEC]]
 
*[[Manuals/calci/COSH | COSH]]
 
*[[Manuals/calci/COSH | COSH]]
Line 404: Line 410:
 
*[[Manuals/calci/SIGN | SIGN]]
 
*[[Manuals/calci/SIGN | SIGN]]
 
*[[Manuals/calci/SIN | SIN]]
 
*[[Manuals/calci/SIN | SIN]]
 +
*[[Manuals/calci/SIN#Examples |SINExamples]]
 
*[[Manuals/calci/SINC | SINC]]
 
*[[Manuals/calci/SINC | SINC]]
 
*[[Manuals/calci/SINCP | SINCP]]
 
*[[Manuals/calci/SINCP | SINCP]]
Line 461: Line 468:
 
*[[Manuals/calci/VECTORPRODUCT | VECTORPRODUCT]]
 
*[[Manuals/calci/VECTORPRODUCT | VECTORPRODUCT]]
  
==MATH2==
+
===Math2===
 
*[[Manuals/calci/ACKERMANN | ACKERMANN]]
 
*[[Manuals/calci/ACKERMANN | ACKERMANN]]
 
*[[Manuals/calci/ADDINS | ADDINS]]
 
*[[Manuals/calci/ADDINS | ADDINS]]
Line 492: Line 499:
 
*[[Manuals/calci/SUMWITH | SUMWITH]]
 
*[[Manuals/calci/SUMWITH | SUMWITH]]
 
*[[Manuals/calci/TETRATE | TETRATE]]
 
*[[Manuals/calci/TETRATE | TETRATE]]
==DATE AND TIME1==
+
 
 +
===Date and Time1===
 
*[[Manuals/calci/ADDDATE | ADDDATE]]
 
*[[Manuals/calci/ADDDATE | ADDDATE]]
 +
*[[Manuals/calci/AGINGINDAYS | AGINGINDAYS]]
 
*[[Manuals/calci/CLOCK | CLOCK]]
 
*[[Manuals/calci/CLOCK | CLOCK]]
 
*[[Manuals/calci/CALENDER | CALENDER]]
 
*[[Manuals/calci/CALENDER | CALENDER]]
Line 519: Line 528:
 
*[[Manuals/calci/MINUTE | MINUTE]]
 
*[[Manuals/calci/MINUTE | MINUTE]]
 
*[[Manuals/calci/MONTH | MONTH]]
 
*[[Manuals/calci/MONTH | MONTH]]
 +
*[[Manuals/calci/MOMENT| MOMENT]]
 
*[[Manuals/calci/MONTHEND | MONTHEND]]
 
*[[Manuals/calci/MONTHEND | MONTHEND]]
 
*[[Manuals/calci/MONTHENDLEAP | MONTHENDLEAP]]
 
*[[Manuals/calci/MONTHENDLEAP | MONTHENDLEAP]]
Line 536: Line 546:
 
*[[Manuals/calci/YEARBASIS | YEARBASIS]]
 
*[[Manuals/calci/YEARBASIS | YEARBASIS]]
 
*[[Manuals/calci/YEARFRAC | YEARFRAC]]
 
*[[Manuals/calci/YEARFRAC | YEARFRAC]]
==DATE AND TIME2==
+
 
 +
===Date and Time2===
 
*[[Manuals/calci/DAYSOFFSETWITHDST | DAYSOFFSETWITHDST]]
 
*[[Manuals/calci/DAYSOFFSETWITHDST | DAYSOFFSETWITHDST]]
 
*[[Manuals/calci/DAYSONMONTHLYBASIS | DAYSONMONTHLYBASIS]]
 
*[[Manuals/calci/DAYSONMONTHLYBASIS | DAYSONMONTHLYBASIS]]
 
*[[Manuals/calci/TIMEVALUE | TIMEVALUE]]
 
*[[Manuals/calci/TIMEVALUE | TIMEVALUE]]
==ENGINEERING1==
+
 
 +
===Engineering1===
 
*[[Manuals/calci/ARGS | ARGS]]
 
*[[Manuals/calci/ARGS | ARGS]]
 
*[[Manuals/calci/ARGSONE | ARGSONE]]
 
*[[Manuals/calci/ARGSONE | ARGSONE]]
Line 597: Line 609:
 
*[[Manuals/calci/UNITSFAILTONULL | UNITSFAILTONULL]]
 
*[[Manuals/calci/UNITSFAILTONULL | UNITSFAILTONULL]]
 
*[[Manuals/calci/UNITSOF | UNITSOF]]
 
*[[Manuals/calci/UNITSOF | UNITSOF]]
==ENGINEERING2==
+
 
 +
===Engineering2===
 
*[[Manuals/calci/BESSELI | BESSELI]]
 
*[[Manuals/calci/BESSELI | BESSELI]]
 
*[[Manuals/calci/BESSELJ | BESSELJ]]
 
*[[Manuals/calci/BESSELJ | BESSELJ]]
Line 603: Line 616:
 
*[[Manuals/calci/BESSELY | BESSELY]]
 
*[[Manuals/calci/BESSELY | BESSELY]]
 
*[[Manuals/calci/ENFORCECOMPLEX | ENFORCECOMPLEX]]
 
*[[Manuals/calci/ENFORCECOMPLEX | ENFORCECOMPLEX]]
==FINANCIAL1==
+
 
 +
===Financial1===
 
*[[Manuals/calci/ACCRINT | ACCRINT]]
 
*[[Manuals/calci/ACCRINT | ACCRINT]]
 
*[[Manuals/calci/AMORLINC | AMORLINC]]
 
*[[Manuals/calci/AMORLINC | AMORLINC]]
Line 653: Line 667:
 
*[[Manuals/calci/USDOLLAR | USDOLLAR]]
 
*[[Manuals/calci/USDOLLAR | USDOLLAR]]
 
*[[Manuals/calci/XNPV | XNPV]]
 
*[[Manuals/calci/XNPV | XNPV]]
==FINANCIAL2==
+
 
 +
===Financial2===
 
*[[Manuals/calci/ACCRINTM | ACCRINTM]]
 
*[[Manuals/calci/ACCRINTM | ACCRINTM]]
 
*[[Manuals/calci/AMORDEGRC | AMORDEGRC]]
 
*[[Manuals/calci/AMORDEGRC | AMORDEGRC]]
Line 674: Line 689:
 
*[[Manuals/calci/YIELDMAT | YIELDMAT]]
 
*[[Manuals/calci/YIELDMAT | YIELDMAT]]
 
*[[Manuals/calci/YMXC | YMXC]]
 
*[[Manuals/calci/YMXC | YMXC]]
==GEOMETRY AND GRAPH1==
+
 
 +
===Geometry and Graph1===
 
*[[Manuals/calci/BARCHART | BARCHART]]
 
*[[Manuals/calci/BARCHART | BARCHART]]
 
*[[Manuals/calci/BARHIERARCHY | BARHIERARCHY]]
 
*[[Manuals/calci/BARHIERARCHY | BARHIERARCHY]]
Line 723: Line 739:
 
*[[Manuals/calci/TRIANGLE | TRIANGLE]]
 
*[[Manuals/calci/TRIANGLE | TRIANGLE]]
 
*[[Manuals/calci/XYPOINT | XYPOINT]]
 
*[[Manuals/calci/XYPOINT | XYPOINT]]
==GEOMETRY AND GRAPH2==
+
 
 +
===Geometry and Graph2===
 
*[[Manuals/calci/BUBBLECHART | BUBBLECHART]]
 
*[[Manuals/calci/BUBBLECHART | BUBBLECHART]]
 
*[[Manuals/calci/CLOSEDCURVE | CLOSEDCURVE]]
 
*[[Manuals/calci/CLOSEDCURVE | CLOSEDCURVE]]
Line 736: Line 753:
 
*[[Manuals/calci/SURFACEGRAPHCORE | SURFACEGRAPHCORE]]
 
*[[Manuals/calci/SURFACEGRAPHCORE | SURFACEGRAPHCORE]]
 
*[[Manuals/calci/TORUS | TORUS]]
 
*[[Manuals/calci/TORUS | TORUS]]
==INFORMATION1==
+
 
 +
===Information1===
 
*[[Manuals/calci/APPLY | APPLY]]
 
*[[Manuals/calci/APPLY | APPLY]]
 
*[[Manuals/calci/APPLYFUNCTIONTOALLELEMENTS | APPLYFUNCTIONTOALLELEMENTS]]
 
*[[Manuals/calci/APPLYFUNCTIONTOALLELEMENTS | APPLYFUNCTIONTOALLELEMENTS]]
Line 783: Line 801:
 
*[[Manuals/calci/ISBOOLEAN | ISBOOLEAN]]
 
*[[Manuals/calci/ISBOOLEAN | ISBOOLEAN]]
 
*[[Manuals/calci/ISCOMPLEX | ISCOMPLEX]]
 
*[[Manuals/calci/ISCOMPLEX | ISCOMPLEX]]
 +
*[[Manuals/calci/ISCOMPOSITE | ISCOMPOSITE]]
 
*[[Manuals/calci/ISELEMENTLIKECOMPLEX | ISELEMENTLIKECOMPLEX]]
 
*[[Manuals/calci/ISELEMENTLIKECOMPLEX | ISELEMENTLIKECOMPLEX]]
 
*[[Manuals/calci/ISEMPTY | ISEMPTY]]
 
*[[Manuals/calci/ISEMPTY | ISEMPTY]]
Line 789: Line 808:
 
*[[Manuals/calci/ISERROR | ISERROR]]
 
*[[Manuals/calci/ISERROR | ISERROR]]
 
*[[Manuals/calci/ISEVEN | ISEVEN]]
 
*[[Manuals/calci/ISEVEN | ISEVEN]]
 +
*[[Manuals/calci/ISFALSE | ISFALSE]]
 
*[[Manuals/calci/ISFUNCTION | ISFUNCTION]]
 
*[[Manuals/calci/ISFUNCTION | ISFUNCTION]]
 
*[[Manuals/calci/ISFUNCTIONSYMBOL | ISFUNCTIONSYMBOL]]
 
*[[Manuals/calci/ISFUNCTIONSYMBOL | ISFUNCTIONSYMBOL]]
 
*[[Manuals/calci/ISIGNOREINDEX | ISIGNOREINDEX]]
 
*[[Manuals/calci/ISIGNOREINDEX | ISIGNOREINDEX]]
 
*[[Manuals/calci/ISINARRAY | ISINARRAY]]
 
*[[Manuals/calci/ISINARRAY | ISINARRAY]]
 +
*[[Manuals/calci/ISINTEGER | ISINTEGER]]
 +
*[[Manuals/calci/ISINTEGER#Safe_Integer | Safe Integer]]
 
*[[Manuals/calci/ISLAMBDAEQUATION | ISLAMBDAEQUATION]]
 
*[[Manuals/calci/ISLAMBDAEQUATION | ISLAMBDAEQUATION]]
 
*[[Manuals/calci/ISLEAPYEAR | ISLEAPYEAR]]
 
*[[Manuals/calci/ISLEAPYEAR | ISLEAPYEAR]]
Line 820: Line 842:
 
*[[Manuals/calci/ISSUPERSET | ISSUPERSET]]
 
*[[Manuals/calci/ISSUPERSET | ISSUPERSET]]
 
*[[Manuals/calci/ISTEXT | ISTEXT]]
 
*[[Manuals/calci/ISTEXT | ISTEXT]]
 +
*[[Manuals/calci/ISTRUE | ISTRUE]]
 
*[[Manuals/calci/ISVECTOR | ISVECTOR]]
 
*[[Manuals/calci/ISVECTOR | ISVECTOR]]
 
*[[Manuals/calci/ISVECTORSIZE | ISVECTORSIZE]]
 
*[[Manuals/calci/ISVECTORSIZE | ISVECTORSIZE]]
Line 897: Line 920:
 
*[[Manuals/calci/YES | YES]]
 
*[[Manuals/calci/YES | YES]]
 
*[[Manuals/calci/YUP | YUP]]
 
*[[Manuals/calci/YUP | YUP]]
==INFORMATION2==
+
 
 +
===Information2===
 
*[[Manuals/calci/ACRONYM | ACRONYM]]
 
*[[Manuals/calci/ACRONYM | ACRONYM]]
 
*[[Manuals/calci/APOLOGIZE | APOLOGIZE]]
 
*[[Manuals/calci/APOLOGIZE | APOLOGIZE]]
Line 942: Line 966:
 
*[[Manuals/calci/XMLVALUES | XMLVALUES]]
 
*[[Manuals/calci/XMLVALUES | XMLVALUES]]
 
*[[Manuals/calci/XMY | XMY]]
 
*[[Manuals/calci/XMY | XMY]]
==LOGICAL1==
+
 
 +
===Logical===
 
*[[Manuals/calci/BITAND | BITAND]]
 
*[[Manuals/calci/BITAND | BITAND]]
 
*[[Manuals/calci/BITLSHIFT | BITLSHIFT]]
 
*[[Manuals/calci/BITLSHIFT | BITLSHIFT]]
Line 960: Line 985:
 
*[[Manuals/calci/TRUE | TRUE]]
 
*[[Manuals/calci/TRUE | TRUE]]
 
*[[Manuals/calci/TRUEVALUE | TRUEVALUE]]
 
*[[Manuals/calci/TRUEVALUE | TRUEVALUE]]
==DATABASE AND LIST MANAGEMENT1==
+
 
 +
===Database and List Management1===
 
*[[Manuals/calci/DAVERAGE | DAVERAGE]]
 
*[[Manuals/calci/DAVERAGE | DAVERAGE]]
 
*[[Manuals/calci/DCOUNT | DCOUNT]]
 
*[[Manuals/calci/DCOUNT | DCOUNT]]
Line 973: Line 999:
 
*[[Manuals/calci/DVAR | DVAR]]
 
*[[Manuals/calci/DVAR | DVAR]]
 
*[[Manuals/calci/DVARP | DVARP]]
 
*[[Manuals/calci/DVARP | DVARP]]
==DATABASE AND LIST MANAGEMENT2==
+
 
 +
===Database and List Management2===
 
*[[Manuals/calci/DBPEDIA | DBPEDIA]]
 
*[[Manuals/calci/DBPEDIA | DBPEDIA]]
 
*[[Manuals/calci/DIAG | DIAG]]
 
*[[Manuals/calci/DIAG | DIAG]]
Line 981: Line 1,008:
 
*[[Manuals/calci/DOEFFECT | DOEFFECT]]
 
*[[Manuals/calci/DOEFFECT | DOEFFECT]]
 
*[[Manuals/calci/DOFUNCTIONIF | DOFUNCTIONIF]]
 
*[[Manuals/calci/DOFUNCTIONIF | DOFUNCTIONIF]]
==LOOKUP AND REFERENCE1==
+
 
 +
===Lookup and Reference1===
 
*[[Manuals/calci/ADDRESS | ADDRESS]]
 
*[[Manuals/calci/ADDRESS | ADDRESS]]
 
*[[Manuals/calci/AGE | AGE]]
 
*[[Manuals/calci/AGE | AGE]]
Line 1,063: Line 1,091:
 
*[[Manuals/calci/UPTO | UPTO]]
 
*[[Manuals/calci/UPTO | UPTO]]
 
*[[Manuals/calci/VLOOKUP | VLOOKUP]]
 
*[[Manuals/calci/VLOOKUP | VLOOKUP]]
 +
*[[Manuals/calci/VLOOKUP#Examples | VLOOKUPExamples]]
  
==Lookup and Reference2==
+
===Lookup and Reference2===
 
*[[Manuals/calci/ANALYZE | ANALYZE]]
 
*[[Manuals/calci/ANALYZE | ANALYZE]]
 
*[[Manuals/calci/ASSIGN | ASSIGN]]
 
*[[Manuals/calci/ASSIGN | ASSIGN]]
Line 1,099: Line 1,128:
 
*[[Manuals/calci/XRBETWEEN | XRBETWEEN]]
 
*[[Manuals/calci/XRBETWEEN | XRBETWEEN]]
 
*[[Manuals/calci/XSY | XSY]]
 
*[[Manuals/calci/XSY | XSY]]
==Text and Data1==
+
 
 +
===Text and Data1===
 
*[[Manuals/calci/BADWORDS | BADWORDS]]
 
*[[Manuals/calci/BADWORDS | BADWORDS]]
 
*[[Manuals/calci/CHAR | CHAR]]
 
*[[Manuals/calci/CHAR | CHAR]]
Line 1,221: Line 1,251:
 
*[[Manuals/calci/WRITELN | WRITELN]]
 
*[[Manuals/calci/WRITELN | WRITELN]]
 
*[[Manuals/calci/WS | WS]]
 
*[[Manuals/calci/WS | WS]]
==Text and Data2==
+
 
 +
===Text and Data2===
 
*[[Manuals/calci/CHECKFACT | CHECKFACT]]
 
*[[Manuals/calci/CHECKFACT | CHECKFACT]]
 
*[[Manuals/calci/COLLECTION | COLLECTION]]
 
*[[Manuals/calci/COLLECTION | COLLECTION]]
Line 1,247: Line 1,278:
 
*[[Manuals/calci/STYLECELL | STYLECELL]]
 
*[[Manuals/calci/STYLECELL | STYLECELL]]
  
==Matrix Functions1==
+
===Matrix Functions1===
 
*[[Manuals/calci/ADJ | ADJ]]
 
*[[Manuals/calci/ADJ | ADJ]]
 
*[[Manuals/calci/ANTIDIAGONAL | ANTIDIAGONAL]]
 
*[[Manuals/calci/ANTIDIAGONAL | ANTIDIAGONAL]]
 
*[[Manuals/calci/ANTIDIAGONALWITH | ANTIDIAGONALWITH]]
 
*[[Manuals/calci/ANTIDIAGONALWITH | ANTIDIAGONALWITH]]
 +
*[[Manuals/calci/BLOCKDIAGONAL| BLOCKDIAGONAL]]
 
*[[Manuals/calci/CONTOURS | CONTOURS]]
 
*[[Manuals/calci/CONTOURS | CONTOURS]]
 
*[[Manuals/calci/DIAGONALFILL | DIAGONALFILL]]
 
*[[Manuals/calci/DIAGONALFILL | DIAGONALFILL]]
Line 1,325: Line 1,357:
 
*[[Manuals/calci/MMULT | MMULT]]
 
*[[Manuals/calci/MMULT | MMULT]]
 
*[[Manuals/calci/SIZE | SIZE]]
 
*[[Manuals/calci/SIZE | SIZE]]
 +
*[[Manuals/calci/SKEWSYMMETRIC | SKEWSYMMETRIC]]
 
*[[Manuals/calci/SPREAD | SPREAD]]
 
*[[Manuals/calci/SPREAD | SPREAD]]
 
*[[Manuals/calci/SPREADSHEETS | SPREADSHEETS]]
 
*[[Manuals/calci/SPREADSHEETS | SPREADSHEETS]]
Line 1,334: Line 1,367:
 
*[[Manuals/calci/TRACE | TRACE]]
 
*[[Manuals/calci/TRACE | TRACE]]
 
*[[Manuals/calci/TRANSPOSE | TRANSPOSE]]
 
*[[Manuals/calci/TRANSPOSE | TRANSPOSE]]
==Matrix Functions2==
+
 
 +
===Matrix Functions2===
 
*[[Manuals/calci/CHOLESKY | CHOLESKY]]
 
*[[Manuals/calci/CHOLESKY | CHOLESKY]]
 
*[[Manuals/calci/CHOLESKYFACTORIZATION | CHOLESKYFACTORIZATION]]
 
*[[Manuals/calci/CHOLESKYFACTORIZATION | CHOLESKYFACTORIZATION]]
Line 1,348: Line 1,382:
 
*[[Manuals/calci/QRDEV | QRDEV]]
 
*[[Manuals/calci/QRDEV | QRDEV]]
 
*[[Manuals/calci/REDUCEDROWECHELONFORM | REDUCEDROWECHELONFORM]]
 
*[[Manuals/calci/REDUCEDROWECHELONFORM | REDUCEDROWECHELONFORM]]
 +
*[[Manuals/calci/SVD| SVD]]
 
*[[Manuals/calci/TENSORPRODUCT | TENSORPRODUCT]]
 
*[[Manuals/calci/TENSORPRODUCT | TENSORPRODUCT]]
  
==Other Functions1==
+
===Other Functions1===
 
*[[Manuals/calci/ARRAY | ARRAY]]
 
*[[Manuals/calci/ARRAY | ARRAY]]
 
*[[Manuals/calci/ARRAYFY | ARRAYFY]]
 
*[[Manuals/calci/ARRAYFY | ARRAYFY]]
Line 1,430: Line 1,465:
 
*[[Manuals/calci/WITHIN | WITHIN]]
 
*[[Manuals/calci/WITHIN | WITHIN]]
 
*[[Manuals/calci/WORDPROBLEM | WORDPROBLEM]]
 
*[[Manuals/calci/WORDPROBLEM | WORDPROBLEM]]
+
 
==Other Functions2==
+
===Other Functions2===
 
*[[Manuals/calci/ANOVASINGLEFACTOR | ANOVASINGLEFACTOR]]
 
*[[Manuals/calci/ANOVASINGLEFACTOR | ANOVASINGLEFACTOR]]
 
*[[Manuals/calci/ANOVATWOFACTORWITHOUTREPLICATION | ANOVATWOFACTORWITHOUTREPLICATION]]
 
*[[Manuals/calci/ANOVATWOFACTORWITHOUTREPLICATION | ANOVATWOFACTORWITHOUTREPLICATION]]
Line 1,455: Line 1,490:
 
*[[Manuals/calci/TREEMAPBYSIZE | TREEMAPBYSIZE]]
 
*[[Manuals/calci/TREEMAPBYSIZE | TREEMAPBYSIZE]]
  
==Physics & other related functions1==
+
===Physics & other related functions===
 
*[[Manuals/calci/ACCELERATIONDUETOGRAVITY | ACCELERATIONDUETOGRAVITY]]
 
*[[Manuals/calci/ACCELERATIONDUETOGRAVITY | ACCELERATIONDUETOGRAVITY]]
 
*[[Manuals/calci/DISTANCE | DISTANCE]]
 
*[[Manuals/calci/DISTANCE | DISTANCE]]
Line 1,481: Line 1,516:
 
*[[Manuals/calci/VENUS | VENUS]]
 
*[[Manuals/calci/VENUS | VENUS]]
  
==Special Z3 Functions==
+
===Special Z3 Functions===
 
*[[Manuals/calci/Z3 | Z3]]
 
*[[Manuals/calci/Z3 | Z3]]
 
*[[Manuals/calci/Z3A | Z3A]]
 
*[[Manuals/calci/Z3A | Z3A]]

Latest revision as of 18:32, 19 September 2021

LIST OF ALL FUNCTIONS

Statistical Functions1

Statistical Functions2

Math1

Math2

Date and Time1

Date and Time2

Engineering1

Engineering2

Financial1

Financial2

Geometry and Graph1

Geometry and Graph2

Information1

Information2

Logical

Database and List Management1

Database and List Management2

Lookup and Reference1

Lookup and Reference2

Text and Data1

Text and Data2

Matrix Functions1

Matrix Functions2

Other Functions1

Other Functions2

Physics & other related functions

Special Z3 Functions