CapeTools Range Utils
http://www.QuantTools.com
In total there are 43 functions present within the CapeTools Range Utils category of functions.
General Description
Functions to apply basic mathematical functions against numeric ranges (excel ranges also) objects (ie - max, min etc...)
Functions create a range given a matrix formatted string (Used heavily within the example for ease of display) and to create a string given a string (great for debugging purposes).
Functions to manipulate ranges (excel ranges also) objects (ie - transpose, rotate, flip, concatenate, reshape, add, subtract, multiply, sum, sum rows, sum columns etc...)
Functions to select portions of ranges (excel ranges also) objects (ie - select column(s), select row(s) and select a sub range.)
Function list.
- ConcatHorz - Given a range object (excel range) adds a column to the left or right side of the given range.
- ConcatVert - Given a range object (excel range) adds a header or footer range object to the given object.
- CreateVector - Creates a vector range, filled with a default numeric value.
- IsSquareRange - Determines whether the range object passed in is a square range object (equal row and column length).
- IsVector - Determines whether the range object passed in is a vector (either row or column has a length of 1).
- MatrixAdd - Mathematically adds 2 numeric range objects together.
- MatrixCeil - Mathematically rounds all numeric values within a numeric range object upwards.
- MatrixDivide - Mathematically divides 2 numeric range objects.
- MatrixFloor - Mathematically rounds all numeric values within a numeric range object downwards.
- MatrixMax - Mathematically finds the maximum value of a numeric range object.
- MatrixMaxCols - Mathematically finds the maximum value across the columns of a numeric range object.
- MatrixMaxRows - Mathematically finds the maximum value across the rows of a numeric range object.
- MatrixMean - Mathematically computes the mean value for every cell within a numeric range object.
- MatrixMeanCols - Mathematically computes the mean value across the columns of a numeric range object.
- MatrixMeanRows - Mathematically computes the mean values across the rows of a numeric range object.
- MatrixMin - Mathematically finds the minimum value of a numeric range object.
- MatrixMinCols - Mathematically finds the minimum value across the columns of a numeric range object.
- MatrixMinRows - Mathematically finds the minimum value across the rows of a numeric range object.
- MatrixMinus - Matematically subtracts 2 numeric range objects from each other.
- MatrixMultiply - Mathematically multiplies 2 numeric range objects together.
- MatrixPow - Mathematically applies the Pow() function to every value of a numeric range object.
- MatrixSum - Mathematically sums every cell of a range object and returns a numeric value which holds the results of this summation.
- MatrixSumCols - Mathematically sums the columns of a numeric range object and returns a range object containing the results.
- MatrixSumRows - Mathematically sums the rows of a numeric range object and returns a vector range object with the results.
- NumericRange2Str - Given a range object, (Excel range if using Excel, 2D Variant if using Visual Basic or VBA and finally CTRangeData if using C++, Java or any of the .NET languages), this function will convert a range object into a string representation.
- Range2Str - Given a range object, (Excel range if using Excel, 2D Variant if using Visual Basic or VBA and finally CTRangeData if using C++, Java or any of the .NET languages), this function will convert a range object into a string representation.
- RangeFlipNS - Flips a range object in the north-south direction.
- RangeFlipWE - Flips a range object in the west-east direction.
- RangeFromStr - Creates a range object given a string formatted with matrix data.
- RangeNumOfCols - Returns the number of columns within a range object.
- RangeNumOfRows - Returns the number of rows within a range object.
- RangeRotate180 - Rotates a range object 180 degrees.
- RangeRotate270 - Rotates a range object 90 degrees anti-clockwise or 270 degrees clockwise.
- RangeRotate90 - Rotates a range object 90 degrees clockwise or 270 degrees anti-degrees clockwise.
- RangeTranspose - Given a range object, (Excel range if using Excel, 2D Variant if using Visual Basic or VBA and finally CTRangeData if using C++, Java or any of the .NET languages), this function will transpose the range object.
- RectRangeCreate - Creates a rectangular numeric range object filled with a default numeric value.
- Reshape - Reshape a range object.
- SelectCol - Returns a column range object given a range object and a column number (1-based).
- SelectCols - Given a list of column numbers, this function will return a new range object containing just those columns.
- SelectRow - Returns a row range object given a range object and a row number (1-based).
- SelectRows - Given a list of row numbers, this function will return a new range object containing just those rows.
- SelectSubRange - Selects a sub-range within a range object.
- SquareRangeCreate - Creates a square numeric range object filled with a default numeric value.
Copyright (c) 2003-2007 CapeTools - All Rights Reserved.
