Business Functions Library for Excel

##### Range Handling And Constraints
Most functions involving range inputs do some pre-processing of these input ranges during the functions input screening process. The types of processes carried out are as follows. See each function for details pertaining to that function.
NameWhat It Does
2 Dimensional Matrix TrimTthe 2 dimensional array will be trimmed to match the size of the axis variables.
Check AscendingThe dates in this range must (after any previous range-handling adjustments) be in order of ascending date.
Check DescendingThe dates in this range must (after any previous range-handling adjustments) be in order of descending date.
Check Same LengthThe length of these ranges (after any previous range handling adjustments and including any blanks or zeros) must be the same length or the function will report an error.
Date SizeThe first (date) range will be shortened to the first non-zero element, eliminating trailing zeros. If the second range is then longer then it will be shortened to the size of the date range. If the second range is shorter it will be padded by zeros. If both the date and the corresponding value are zero at any location in the range, the range is compacted and shortened.
Make Same SizeIf the two ranges are differing lengths, the longer range will be shortened to the size of the other, so that both ranges are the same length.
Preceding Zero SizeTrims the zeros at the start of the list.
Trailing Blank Size (one range, and will not shorten to a range length less than 1)If this range has trailing blanks (as opposed to zeros, a blank is a cell with nothing in it), the range will be shortened to the last non-blank element.
Trailing Zero Size (2 or more ranges)If the ranges are of different lengths, the longer will be shortened to the size of the shorter range. Then, if both corresponding elements at the end of the ranges are zero, the ranges are shortened further. For instance ({20,30,0,0,0},{0,10,10,0,0}) would be shortened to ({20,30,0},{0,10,10})
Trailing Zero Size (one range)If this range has trailing zeros, the range will be shortened to last non-zero element. So {0,20,0,30,0,0} would be shortened to {0,20,0,30}.
Trailing Zero Size (one range, and will not shorten to a range length less than 1)If this range has trailing zeros, the range will be shortened to last non-zero element. So {0,20,0,30,0,0} would be shortened to {0,20,0,30}. However, it will not be shortened to less than 1 item if more than one item exists.

Business Functions Ltd, London, UK Website Design: Webpure