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.

    • Related Articles

    • Where can find my RAs and transfer them to PDF?

      To Find your RAs click on Claims in HYPEMedical's main menu and choose MCEDT Files. HYPEMedical's main menu Once the MCEDT Files page loads click on the Remittance Advice Files tab. In the Remittance Advice Files tab hover over the red arrow and ...
    • The RA shows it's paid but HYPEMedical doesnt have the claim anymore?

      This most often occurs when users edit a submitted claim and resubmit it. The permision to edit claims in the Submitted status should be reserved for administrators. In the following example the service date was edited after the claim was submitted ...
    • Downloading an RA in Raw OHIP Format

      Did you know that one format HYPEMedical has for downloading an RA is in the same format that OHIP originally released it? Yes, in addition to the usual RA report in PDF and Spread Sheet formats a raw format may be required. A colleague may need to ...
    • I can't find one of my physician's RAs?!

      Search results are limited to 500 over the most recent six months, by default, within the MCEDT Files tabs. Use the Advanced Search Options (green band) to narrow your search. In the example below, limiting the search results with a date range and ...
    • Can I fax Manual Reviews and RA Inquiries?

      Yes. Fax Manual Review and RA Inquiry PDFs to MOHLTC at 905-434-4186, as per Bulletin Number: 210902