Spreadsheet Limitations

Top  Previous  Next

Excel basically has a two-dimensional display of the data: columns and rows. EDI data is hierarchical and nested which does not allow a true two-dimensional representation.

HIPAAsuite tries to accommodate this using multiple values. For example, REF and DTP segments are translated into multi-line cells. In this way the spreadsheet displays multiple Benefits that a record might contain. For each Benefit, an Excel spreadsheet displays only one COB record and only one Provider.

Multi-line cells in Excel

Note: The record separator in Excel is ASCII 10 or Linefeed.