{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["PVT Calculator","Group Roster","Instructions","Overview"],"not_rendered":{"charts":0,"images":29,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PVT Calculator","index":0,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[31,1,31,4],[21,4,22,4]]}
[null,"Copyright 2017 MeHI and Massachusetts EOHHS",null,null,"Version 2/19/2019"]
[null,null,"MEHI - PVT CALCULATOR"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Your Claims Date Range"]
[]
[]
[]
[]
[]
[]
[]
[null,"*   = Required field"]
[null,"** = Recommend for group PVT"]
[]
[]
[]
[null,"Paid Claims"]
[null,"Enrollee"]
[]
[null,"Beginner"]
[null,"Expert"]

{"sheet":"Group Roster","index":1,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,5]]}
[null,{"$f":"'PVT Calculator'!B1","v":"Copyright 2017 MeHI and Massachusetts EOHHS"},null,null,null,null,{"$f":"'PVT Calculator'!E1","v":"Version 2/19/2019"}]
[null,"MeHI - Group Roster  Creator",null,null,null," Use \"Find Providers\" button to fill the \n roster with data from your claims sheet","    Header Row Number*"]
[null,"Either a) Fill in this form for all EPs who are part of the group, or b) Upload your own group roster",null,null,null," *   = Required to run \"Find Providers\"\n ** = Enter one or both to run \"Find Providers\"","Yes"]
[null,"You must include all Eligible and Non-Eligible Providers, of all Provider Types,  who rendered services to patients  during the  90-day Patient Volume Reporting Period.\nFor each provider you must enter information in each column. Use the \"Find Providers\" button if your claims sheet contains part or all of this information.",null,null,null,null,"No"]
[null,"                  Provider Name**"," Provider Type","    NPI**","     Site/Location of CEHRT","                        Group Name","Eligible to participate in Medicaid EHR Incentive Program  (Y/N)"]

{"sheet":"Instructions","index":2,"n_rows":58,"n_cols":2,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'PVT Calculator'!B1 & \"                                                                                 Practitioner Panel Instructions updated 2/5/2019\"","v":"Copyright 2017 MeHI and Massachusetts EOHHS                                                                                 Practitioner Panel Instructions updated 2/5/2019"}]
[null,"PVT CALCULATOR INSTRUCTIONS"]
[null,"The PVT Calculator consists of three MS Excel-based  tools to make determination of PVT faster and easier:\nA) PVT Calculator determines the PVT based on One Claim Per Patient Per Day,  including all eligible Medicaid paid claims;\nB) Multiple Payors Converter adapts an encounter-based format to the claims-based format expected by PVT Calculator;\nC) The Group Roster Creator pre-populates the group roster with the provider information included within the claims data."]
[null,"When using these tools, keep in mind that you are responsible for feeding the tools with correct data, for properly defining what your data represents, for analyzing the accuracy of how your data was interpreted, and for reviewing whether your PVT is correct. You also need to correct any incomplete data that affects the PVT."]
[null,"Each tool comes with onscreen instructions to guide you in using the tools. Carefully follow the instructions that pop up while using the tools. When in doubt, press F1=Help for further details."]
[null,"At the top of PVT Calculator you can select whether you are a beginner or expert user:\n- In Beginner mode, you will see pop up instructions a) to get you started, and  b) for issues you need to address;\n- In Expert mode, you will  only see the pop up instructions for the issues you need to address."]
[null,"Use the Down Arrow on your keyboard to scroll down to read the rest of these instructions."]
[null,"LET'S GET STARTED"]
[null,"PREPARE YOUR CLAIMS SHEET\n\nStart with creating an Excel spreadsheet that contains columns with the following information for all your claims created during the PVT Reporting Period:"]
[null,"Required columns:\no Organization Name\no Payee NPI\no Location/Street Address\no Unique Patient ID 1 (MRN)                           Optional columns:\no Unique Patient ID 2 (DOB)                           (Requires use of the Multiple Payor Converter)\no Date of Service                                     o Secondary Payor\no Payor (Either Primary Payor only, or all payors)    o Secondary Amount Paid\no Amount Paid (by Payor)                              o Tertiary Payor\no Denial Reason (Enrollee approach only)              o Tertiary Amount Paid"]
[null,"Optional columns  for Group Proxy Reporting : (allows one claim per patient per day per unique provider)\no Provider NPI, and/or\no Provider Name"]
[null,"You can use your EHR system or Practice Management System to create this Excel sheet, but other methods work too.  Preferably the data is formatted per the claims template available on the MeHI website in the MU Toolkit for Eligible Professionals. A different format is ok, as long as all required data elements are present. You may also add additional columns, such as the Provider Type to enable  the Group Roster Creator to generate a more complete roster for you. "]
[null,"The PVT Calculator requires the claims data to be stored in either: \n- any Excel file format (.xls, .xlsx, .xlsm, .xlsb files), or \n- CSV format (.csv files).\nOther comma delimited file formats may work too, but have not been tested."]
[null,"START PVT CALCULATOR IN MS EXCEL 2010 or 2013.                                                                            (MS EXCEL 2007 may work too but was not tested)\n\nOpen the PVT Calculator file in MS Excel*. The PVT Calculator form will appear. Then follow the instructions listed below.\n\n* Upon opening the PVT Calculator for the first time, Excel may prompt you to enable editing and/or the macros. Enable accordingly."]
[null,"A) USING THE PVT CALCULATOR\n\nSTEP 1\n\na) Use the “1a) Browse Claims File” button, to identify your claims file. The file must include a sheet with the claims information listed in the PREPARE YOUR CLAIMS SHEET section above. Step 1a also imports the names of the spreadsheets included in the claims file, in preparation for step 1b."]
[null,"b) Then use the drop-down menu box and the “1b) Import Claims Sheet” button, to identify your claims  sheet and import the sheet. The sheet must contain all your claims during the PVT reporting  period.\n\nc) If your claims sheet includes multiple payors (secondary, tertiary, etc.) on the same Excel row in the encounter-based format, use the “1c) Convert Multiple Payors” button to convert the data to the claims-based format. You will need to identify the column letters of each payor level. Follow the instructions of the tool."]
[null,"STEP 2\n\nDefine the information on your spreadsheet: the number of the header row, the column range, and whether you are using Paid Claims or Enrollees. Identify the required columns either by letter or names."]
[null,"Then click the “2) Find Payors” button to identify which payers are Medicaid (in and out-of-state) in the new window that pops up. Follow the instructions and then click the “Back to PVT Calculator” buton.\n\nFor the enrollee method, also click the \"2b) Find Denial Reasons\" button to define the denial reasons that indicate the patient wasn't eligible for Medicaid. Follow the instructions and then click the “Back to PVT Calculator” buton."]
[null,"Note: The PVT Calculator inserts extra columns into your sheet to find the duplicates, classify certain information, and select the Medicaid payors. To ensure that this doesn't affect your column definitions, the PVT Calculator replaces column letter definitions with the header text of the corresponding columns. This ensures that subsequent runs of the PVT Calculator can find the same columns. However, if you see that the header text the PVT Calculator found doesn't correspond to your actual headers, you probably didn't identify the correct header row. (For instance, if you see a date appear in the Date of Service field of the PVT Calculator form instead of the actual header name, then the header row you defined wasn't the header row but one of the claim rows)"]
[null,"STEP 3\n\nEnter the appropriate CHIP factor and click the “3) Calculate PVT” button. (You can, but don't need to, enter the % character)"]
[null,"Click this link to select the CHIP Factor: http://mehi.masstech.org/education/health-it-toolkits/mu-toolkit/medicaid-EP/pvt"]
[null,"STEP 4 \n\nReview the findings of the PVT Calculator, which will be posted at the bottom of your claims sheet.  In particular, evaluate any data that has been highlighted in yellow (which the PVT Calculator found might be missing, erroneous, or suspect data). Correct or update the yellow data if required to make your PVT correct. Also evaluate the claims highlighted in pink, which are the duplicates the PVT Calculator found. Verify the selections."]
[null,"When you conclude that the PVT is correct, click the “4) Clean Up” button to remove any duplicates and ineligible claims. This must be done before submitting this file as your PVT Supporting Documentation with your MAPIR application (upon request)."]
[null,"STEP 5 \n\nClick “5) Copy to .xls for MAPIR” button to copy the PVT data into a .xls file. You can upload the .xls file into MAPIR as your PVT Supporting Documentation. \n \nNotice: You will get a  file mismatch/corrupt warning when you open the .xls file in Excel, because the file has the PVT Calculator macros, which Excel doesn't expect in an .xls file. The \"Copy to .xls for MAPIR\" action does not corrupt the .xls file, so you can open the file."]
[null,"B) USING THE MULTIPLE PAYOR CONVERTER\n\nOnly use the Multiple Payor Converter if your claims sheet is in the encounter-based format, i.e. where the payors are listed in multiple columns. Run this tool only once in Step 1c) of the PVT Calculator process. \n \nRerun the tool only after you reimport the claims sheet. The tool will keep duplicating your claims if you run it again without reimporting the claims sheet."]
[null,"STEP B1\n\nUse column letters to define the columns of each payor. Define at least two payors, otherwise there is nothing to convert. Include the Denial Reason column only if you are using the Enrollee method. Column header text is not accepted.\n\nYou can switch to your claims sheet to lookup the column letters. The Converter screen will stay on top, but you can move it to the side for this purpose. "]
[null,"STEP B2\n\nClick the \"Convert Multiple Payors\" button to start the conversion. If you have many payors in the secondary, tertiary, and quarternary columns, this may take a while. The Converter will show status updates at the bottom of the PVT Calculator screen. You can continue working with your computer while the conversion is in progress, but don't use Excel as that may cause the conversion to stop, or the screen to go blank."]
[null,"C) USING THE GROUP ROSTER CREATOR\n\nEither a) use the Creator to generate your roster from the claims data, or b) create your own sheet with this information. In either case, submit your roster as part of the PVT Supporting Documentation with your MAPIR application (upon request)."]
[null,"STEP C1\n\nThe column headers of the roster contain input fields. use these fields to define the header row and the letters of the columns in your claims data that contain the relevant provider information. You cannot use header text in these definitions. "]
[null,"STEP C2\n\nClick the \"Find Providers\" button to start the process. The Creator will generate the roster based on what it finds in the claims. The cells that show the data found will be colored light green."]
[null,"STEP C3\n\nAdd the remaining information in the white cells that have no information yet.  Also manually add the providers in the group who have no claims data. You can add these providers below the providers found in the claims sheet."]
[null,"SUBMITTING YOUR PVT SUPPORTING DOCUMENTATION WITH YOUR MAPIR APPLICATION\n\nAfter the Clean Up and addition of the Group Roster (if required), create the .xls file, and submit the .xls file with your MAPIR application. Make sure that the reported numerator and denominator in MAPIR match the results of the PVT Calculator."]
[null,"Notice Of Responsibility"]
[null,"The PVT Calculator program is designed to enable EPs or their Designees to calculate their PVT. However, without exception, Medicaid EHR Incentive Program compliance remains the sole responsibility of the EP. The requirements are defined by CMS and MassHealth and cannot be overruled by the PVT Calculator. No claims of PVT accuracy can be made based on the results of using the PVT Calculator. The EP and Designee remain solely responsible for the accuracy of the PVT, and must verify the details and results of the PVT calculation. The EP and Designee need to make sure all data entered into PVT Calculator is correct and complete. While PVT Calculator will highlight missing or zero claims data, the EP and Designee are responsible for correcting highlighted or other data as applicable. After changing any data, the EP or Designee must rerun the PVT Calculator."]
[null,"Copyright Notice"]
[null,"The PVT Calculator program is the copyright of the Massachusetts EOHHS (Executive Office of Health and Human Services) and MeHI (Massachusetts eHealth Institute at MassTech).  The program was created by MeHI, on behalf of the Massachusetts EOHHS. PVT Calculator can be downloaded for free from the MeHI website for the purpose of participation in the Medicaid EHR Incentive Program. The program cannot be redistributed for any other purpose and cannot be altered in any way without written consent of MeHI and the Massachusetts EOHHS. "]
[null,"You can use \"FILE - Print\" in the Excel menu to print these Instructions"]
[]
[null,"PVT CALCULATOR ADDITIONAL INSTRUCTIONS TO CALCULATE PVT FOR FQHC and RHC"]
[null,"FQHC/RHC EPs can include claims for Needy Individuals in their Medicaid Volume in the PVT Numerator. The PVT Calculator can account for Needy Individual claims, but this requires some prework. You must first identify the Needy Individual claims. To do so, follow the procedure listed below. The prework is listed in blue:"]
[null,"1) Create a claims file with all claims made during the 90-day PVT Reporting Period."]
[null,"2) Open the claims file, and for each Needy Individual claim that was zero-paid (= Amount Paid is $0):\n       •   When using the Paid Claims Method:  Change the Paid Amount to $1.\n            When using the Enrollee Method:          Change the Denial Reason to \"NEEDY”."]
[null,"3) Start the PVT Calculator:\n       •   Import the updated claims file.\n       •   Select the Paid Claims or Enrollee methodology to calculate the PVT.\n                            (Select the methodology based on what is best for calculating the highest PVT from the Medicaid Patient claims.)\n       •   Enter the claims row and column definitions.\n       •   Create the Payors table and identify the Medicaid Payors,\n               •   and include the Medicaid Payors (\"Uncompensated Care\", \"Health Safety Net\") of Needy Individual claims.\n       •   For the Enrollee Method: \n               •   Create the Denial Reasons Table, and identify the ineligible Denial Reasons.\n                           (Leave \"NEEDY\" blank, so PVT Calculator will treat it as an eligible reason)\n               •   Run the PVT Calculation.\n\n        This process enables the PVT Calculator to properly account for the Needy Individual claims in the PVT."]
[null,"You can use \"FILE - Print\" in the Excel menu to print these Instructions"]
[]
[null,"PVT CALCULATOR ADDITIONAL INSTRUCTIONS TO CALCULATE PRACTITIONER PANEL PVT"]
[null,"Practitioner Panel EPs can include both Panel Patients and FFS patients in their PVT calculation. The PVT Calculator can account for both the Panel Patients and the FFS patients, but you need to run the PVT Calculator separately for these two  components, and then calculate the PVT manually from the results.  Follow the procedure listed below:"]
[null,"1a)  Create an \"FFS Claims File\" for the Non-Panel Patients seen during the 90-day PVT Reporting Period (FFS = Fee-For-Service). "]
[null,"1b)  Start the PVT Calculator, as per the LET'S GET STARTED instructions listed above:\n          •   Import the FFS Claims File.\n          •   Select the Paid Claims to calculate the PVT, and enter the claims row and column definitions, and the CHIP factor.\n          •   Create the Payors table and identify the Medicaid Payors.\n          •   Run the PVT Calculation to calculate the:\n                   - Numerator     =   Unduplicated Medicaid encounters in the 90 day reporting period\n                   - Denominator =   All unduplicated encounters in the 90 day reporting period"]
[null,"           Step 1 enables the PVT Calculator to properly account for the FFS patients to be included in the PVT."]
[null,"2)     Create a \"List of the Panel Patients\" who are on the provider's panel for the chosen PVT Reporting Period. Include the\n         Panel Patients assigned to the Panel Provider during the selected 90 day reporting period, who had at least one\n         visit in the 24-month period preceding the start date of the 90 day reporting period. For each Panel Patient, include:\n         •      Two Unique Patient IDs, and the Panel Provider's NPI or Name."]
[null,"3a)   Create a \"Practitioner Panel Patient File\", with the same data layout as the FFS Claims File.  \n         Make sure to include the following columns with information for each Panel Patient:\n         •   Two unique Patient IDs of the Panel Patients last seen within the 24 months prior to the PVT Reporting Period.\n         •   Provider NPI or Name of the patient's Panel Provider.\n         •   Date of Service, and list the date the patient was last seen within the 24 months prior to the PVT Reporting Period.\n         •   Payor, and list the Payor that paid for the patient.\n         •   Amount Paid, and list $1 as the amount paid for the patient."]
[null,"3b)   Start the PVT Calculator, as per the LET'S GET STARTED instructions listed above:\n          •   Import the Practitioner Panel Patient File \n          •   Select the Paid Claims to calculate the PVT, and enter the claims row and column definitions, and the CHIP factor.\n          •   Create the Payors table and identify the Medicaid Payors.\n          •   Run the PVT Calculation to calculate the:\n                   - Numerator     =    Total Medicaid Patients assigned to the provider in the 90 day reporting period, \n                                                        with at least one encounter in the 24 month preceding the start of the 90 day reporting period  \n                   - Denominator =   Total Patients assigned to the provider in the 90 day reporting period, \n                                                        with at least one encounter in the 24 month preceding the start of the 90 day reporting period"]
[null,"            Step 3 enables the PVT Calculator to properly account for the Panel Patients to be included in the PVT."]
[null,"4)   Manually calculate the PVT from the values the PVT Calculator has calculated as:\n\n                    Total Medicaid Patients assigned to provider in the 90 day reporting period,              +     Unduplicated Medicaid encounters \n                    with at least one encounter in the 24 month preceding the start of the 90 day reporting period                          in the 90 day reporting period\n       PVT =  _______________________________________________________________________________________________________________________________________________________________________________________________________________________________________"]
[null,"                    Total Patients assigned to the provider in the 90 day reporting period,                       +     All unduplicated encounters \n                    with at least one encounter in the 24 month preceding the start of the 90 day reporting period                           in the 90 day reporting period"]
[null," 5)   When done, enter the numbers in MAPIR and upload your PVT Supporting Documentation into MAPIR. Include:\n         •   The .xls files created by PVT Calculator (FFS Claims File and Practitioner Panel Patient File)\n         •   The List of the Panel Patients file"]
[null,"You can use \"FILE - Print\" in the Excel menu to print these Instructions"]

{"sheet":"Overview","index":3,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'PVT Calculator'!B1","v":"Copyright 2017 MeHI and Massachusetts EOHHS"}]
[null,"PVT CALCULATOR OVERVIEW"]
[null,"The PVT Calculator consists of three tools to make determination of PVT faster and easier:\nA) PVT Calculator determines the PVT based on One Claim Per Patient Per Day,  including all eligible Medicaid paid claims;\nB) Multiple Payors Converter adapts an encounter-based format to the claims-based format expected by PVT Calculator;\nC) The Group Roster Creator pre-populates the group roster with any provider information included in the claims data."]
[null,"The advanced algorithms embedded in these tools implement the PVT regulations. Starting with some explanations of how claims are interpreted, the sections below explain how the  tools work and the basics of how to use these tools. "]
[null,"Use the Down Arrow on your keyboard to scroll down to read the rest of this overview"]
[null,"DEFINITION OF ELIGIBLE AND DUPLICATE CLAIMS"]
[null,"What is an Eligible Claim versus a Duplicate Claim?\n\nEncounter versus Claim: The PVT calculation is based on the one claim per day per patient requirement. This is not one encounter per day, but one claim per day. Therefore, when an encounter has multiple payors, each payor must be treated as a separate claim. Only one of these claims can be counted as an Eligible Claim in the PVT. The other claims are considered Duplicate Claims."]
[null,"Multiple Encounters versus Multiple Claims: If there are multiple encounters for one patient on a given day, each encounter may have one or more payors. Again, each payor must be treated as a separate claim. So for that day, only one of the claims of one of the encounters can be counted as an Eligible Claim.  All the other claims for that day are considered Duplicates and must be excluded. "]
[null,"What claim will be selected? If any of the daily payors is a Medicaid payor, that Medicaid claim will be included, provided it is an eligible claim. If there are multiple Medicaid payors, only one of the Medicaid payors will be included. If there are no Medicaid payors, then one claim of one of the other payors will be included. "]
[null,"For instance: Patient Apple sees Doctor Green twice in one day. \nFor the first visit, a claim is made to 3 payors (Primary: Insurance1, Secondary: Medicaid1, Tertiary: Insurance2). \nFor the second visit, a claim is made to 2 payors (Primary: Insurance1, Secondary: Insurance3). \nThe total number of claims for that day is 3 + 2 = 5. Only one of the 5 will be included in the PVT, and the Eligible Claim included will be Secondary: Medicaid1. The other 4 claims will be considered Duplicates for that day."]
[null,"HOW DO THE TOOLS WORK?"]
[null,"A) How does the PVT Calculator work?\n\nPVT Calculator expects each claim to be listed on a separate Excel row, regardless of whether the claim is for the same or a different encounter. So claims to primary, secondary, tertiary or other payors are all expected to appear on individual rows. "]
[null,"The PVT Calculator will multi-sort the data to select the Eligible Claims and identify the Duplicate Claims. If the enrollee method is used, it will also consider the zero-paid claims and the denial reasons.  Once this evaluation of the claims has been completed, the PVT Calculator will calculate the PVT based on the Eligible Claims it found."]
[null,"To ensure all Eligible Medicaid Claims are included in the PVT Numerator, the PVT Calculator will select:\n1) Medicaid Payor over Non-Medicaid Payor\n2) Paid Claim over Zero-Paid Claim\n3) Eligible Denial Reason over Non-Eligible or Missing reason (if enrollee method is used)"]
[null,"B) What is the purpose of the Multiple Payor Converter?\n\nYour claims sheet may not list the multiple claims information in separate rows, but in multiple columns on the same row. \nIn this case, each row represents an encounter rather than a claim while the extra columns represent the additional secondary, tertiary and quaternary claims."]
[null,"The Multiple Payor Converter, transforms this encounter-based format into the claims-based format expected by the PVT Calculator. In the conversion, the Converter duplicates the multiple claims columns into multiple claims rows. It leaves the original encounter-based information intact, but adds 2 (or 3 for enrollee method ) new columns, in which it copies the data of each payor. These columns are labeled \"All Payors\", \"All Paid\" (and \"All Denial Reasons\") . See the example below."]
[null,"Multiple Payor Example in Encounter Format before conversion:\n\n                            Date of             Primary              Primary          Secondary            Secondary\nPatient ID          Service             Payors                Paid                 Payors                    Paid\nMr Apple         4/14/2017       Insurance1            $100               Medicaid                   $200    \n"]
[null,"Multiple Payor Example in Claims Format after conversion:\n\n                            Date of             Primary              Primary          Secondary            Secondary             All                       All\nPatient ID          Service             Payors                Paid                 Payors                    Paid                        Payors               Paid\nMr Apple         4/14/2017       Insurance1            $100               Medicaid                   $200                   Insurance 1      $100\nMr Apple         4/14/2017       Insurance1            $100               Medicaid                   $200                   Medicaid          $200"]
[null,"By using the new \"All Payors\" and \"All Amounts\" column, the PVT Calculator can now determine which claims to select, including the claims to primary, secondary, tertiary or other payors. For the enrollee method, the converter will  also create the \"All Denial Reasons\" column, and consider whether denied claims were for Medicaid eligible patients."]
[null,"What does the PVT Calculator do with the extra claims rows produced by the Converter?\n\nThe PVT Calculator simply dedupes the extra claims back out after it selects the Eligible Claim.  So for each patient and day, the Calculator will identify the Eligible Claim and will consider the rest of the claims for that day for the same patient as Duplicates."]
[null,"So going back to the example, the Calculator will identify the first claim as a Duplicate and the second claim (the new row) as the Eligible Claim. The reason it selects the second row is that the PVT Calculator will always select a Medicaid Payor over another payor, provided the Medicaid claim is eligible. After Clean Up, the two rows will be reduced back to one row and the \"All Payors\" column will show which payor was selected, as displayed in the example below. "]
[null,"Multiple Payor Example after deduping:\n\n                             Date of            Primary              Primary           Secondary            Secondary            All                       All\nPatient ID          Service             Payors                Paid                 Payors                    Paid                        Payors               Paid\nMr Apple         4/14/2017       Insurance1            $100               Medicaid                   $200                   Medicaid          $200"]
[null,"After the  Clean Up feature of the PVT Calculator has been used, all extra rows created by the Multiple Payor Converter will have been removed again. The conversion in combination with the PVT calculation simply ensures that all eligible Medicaid paid claims will be included, whether as primary, secondary, tertiary, etc."]
[null,"C) What is the purpose of the Group Roster Creator?\n\nThe Group Roster Creator is for EPs who report as a group. This tool has no purpose for EPs who report individually. "]
[null,"The Creator helps you create the required Group Roster from the data in your claims sheet.  If any of the first five data elements are included in your claims data, use the Creator to retrieve and organize this data for you. The rest of the roster data you will have to add manually. At a minimum, you will need to include the provider name and/or NPI in the claims data for the Creator to work.  "]
[null,"After the Creator is done, you will also have to manually add all the other providers in the group that don't have claims data. For instance, a Resident would be part of the group, but will probably not have any claims data. As such, the Resident will have to be added manually.\n\nAfter the roster is generated, you can sort the data by Provider Name or NPI, based on what is most convenient to you."]
[null,"You can use \"FILE - Print\" in the Excel menu to print this Overview"]
[]
[null,"RELEASE NOTES"]
[null,"11/20/2017    First release of PVT Calculator"]
[null,"     2/5/2019    Only the Practitioner Panel Instructions were updated. PVT Calculator program was not modified."]
[null,"   2/19/2019   Workbook protection fixed. 2/5/19 version blocked imports. PVT Calculator program was not modified."]