ComboCurve: ARIES Import/Export Conversions - Comparison Files

ComboCurve: ARIES Import/Export Conversions - Comparison Files

The files and instructions below allow QC and comparison of any import from or export to ARIES.

If you have any further questions, please create a ticket to schedule a demo of these processes with Alan Harris.

Download zip file here with three files to facilitate comparison (if the download link does not work, navigate here and download the attachment at the bottom of the article):
  1. A blank ARIES .accdb file to use to import the csv/txt if not using your own db -and- it also has the ComboCurve formatted AC_ONELINE/oneline query to populate the Excel spreadsheet.
  2. An ARIES .SSF file to allow ARIES to output a copy/pasteable cash flow.
  3. A macro-enabled Excel workbook where you drop cash flows and oneline summaries for comparison between the programs.  Note that this file has detailed instructions as shown in the snip describing the tabs below.




Note: ARIES sometimes has PROPNUMS that are all numeric.  When these exceed 15-characters, Excel auto-converts these to scientific notation by default.  This may make comparison by (X,V)LOOKUP in Excel difficult.  One mitigation in O365 is to ensure "Additional Options" on File==>Options==>Data==>Automatic Data Conversion is checked to allow the popup to prevent automatic data conversion upon loading csv files into Excel.