How do I group totals inside the RA file?

How do I group totals inside the RA file?


Instructions for combining RA data with MS-Excel for enhanced analysis:

Background: The RA file alone lacks sufficient data for comprehensive analysis across different datasets. However, HYPEMedical provides the capability to merge an RA file with additional data from its billing tables, downloadable as a .csv file. This appended data can be efficiently managed and analyzed using MS Excel.

Requirements: Ensure access to a spreadsheet program such as MS Excel, OpenOffice Calculator, WPS OfficeTools, etc., installed.

Steps for Grouping RA Data with MS-Excel:

  1. Navigate to the desired RA in Claims \ MCEDT Files \ Remittance Advice Files within HYPEMedical.
  2. Hover over the red arrow associated with the RA and select "CSV [All Sections More Columns]."
  3. Download the file, saving it in a location accessible to your spreadsheet program.
  4. Open the downloaded file in a spreadsheet program, such as MS Excel.

Utilizing MS-Excel Features:

  • Sorting: Arrange your data systematically based on specific columns or criteria.
  • Filtering: Easily filter and focus on relevant information using Excel's filtering options.
  • Graphing: Leverage Excel's graphing tools to visually represent and interpret RA data.

Important Note: These instructions presume familiarity with HYPEMedical, access permissions, and the ability to use spreadsheet programs. In case of any queries or challenges, refer to the provided video guide for further assistance.






  1. Advanced MS Excel users can expedite the analysis process by creating a Pivot Table with the RA data. Follow these steps:

    1. Highlight Columns:

      • Select all relevant columns in your data, mirroring the process demonstrated in the provided movie.

    2. Create Pivot Table:

      • Utilize the Pivot Table command button in MS Excel and click OK.

    3. Pivot Table Configuration:

      • Navigate to the Pivot Table configuration panel (refer to the image on the right).
      • Build a comprehensive RA report by specifying criteria such as Submitted Amount and Paid Amount per doctor per clinic.

    4. Customize the Pivot Table:

      • Drag and drop fields into appropriate areas (rows, columns, values) within the Pivot Table layout to structure the report as needed.

    5. Format and Filter:

      • Format the Pivot Table for clarity and professionalism.
      • Apply filters and sorting options to refine the displayed data further.

    Tips for Pivot Table Efficiency:

    • Utilize grouping options for date-related data.
    • Experiment with different summarization methods for numerical values (sum, average, count, etc.).
    • Explore advanced features like calculated fields for additional insights.

    Important Note:

    • This method assumes an intermediate level of proficiency in MS Excel.
    • The provided image to the right serves as a guide for configuring the Pivot Table.
    • For any questions or clarifications, refer to the image for visual guidance, and explore MS Excel's built-in help resources for in-depth assistance.