Excel Integration - Internal Documentation and Implementation Notes

Contents

Client Site

Example formula:

    _^^revCT0_^^row_-_^^revCVersandDelta1_^^row

The formula is split on the '_' character, which results in the following array:

Formula Component	Meaning	Example Value
`^^revCT0`	The column for the field revCT0	AB
`^^row`	The current row number	27
-	Minus sign	-
`^^revCVersandDelta1`	The column for the field revCVersandDelta1	BD
`^^row`	The current row number	27

For the example values given above, the result is the following formula:

Legacy browser data is problematic for the new excel tool. The excel tool expects the following revision pattern.

'VA'

'VA, ZF'

'VA, ZF, FR'

'VA, ZF, GA'

'ZF'

'ZF, FR'

'ZF, GA'

Using sql, we have produced a prototype query that could be used as a design spec for a new rest transaction.