Research and Studies

This .zip file contains a Microsoft Excel workbook that details the revised changes for the upcoming 18.0 release of the NCCI data set and a summary of total counts within the database. I have also included a document that details my findings. The new data is set to become effective January 1, 2012.

I will be conducting a brief (free) quickinar on CCI and the changes for 18.0 on Wednesday, December 21 at 1:00 PM EST. If you are interested in attending, select the Quickinars tab and then the registration link. 

This Microsoft Excel workbook contains the 2011 and the proposed 2012 RBRVS data for all procedure codes in the physician fee schedule (PFS) database. All data are associated to the line-item procedure code; and I have included a summary of the variance calculations for your convenience. 

This .zip file contains two Microsoft Excel workbooks that detail the revised changes for the upcoming 17.3 release of the NCCI data set and a summary of total counts within the database. I have also included a document that details my findings. The new data is set to become effective October 1, 2011.

I will be conducting a brief (free) quickinar on CCI and the changes for 17.3 on Friday, September 16 at 2:00 PM EST. If you are interested in attending, select the Quickinars tab and then the registration link. 

This Microsoft Excel workbook contains the national average charge amounts for nearly 10,000 procedure code/modifier combinations for both 2009 and 2010. It also includes a statistical comparison between the two years, reporting whether the difference is stastically significant or not. 

This .zip file contains two Microsoft Excel workbooks that detail the revised changes for the upcoming 17.2 release of the NCCI data set and a summary of total counts within the database. I have also included a document that details my findings. The new data is set to become effective July 1, 2011.

I will be conducting a brief (free) quickinar on CCI and the changes for 17.2 on June 28 at 11:00 EST. If you are interested in attending, click on the Quickinar tab and then the registration link. 

This .zip file contains two Microsoft Excel workbooks that detail my comparitive analysis between the 2011A RBRVS database and the new 2011AR emergency fix RBRVS database released on December 28, 2011.  Both worksheets contain the same information, however, one is for Excel 2003 and earlier and the other (which contains some additional features) is for Excel 2007 and later. 

This .zip file contains two Microsoft Excel workbooks that detail my comparitive analysis between the 2011 proposed RBRVS database and the current 2010 RBRVS database. Both worksheets contain the same information, however, one is for Excel 2003 and earlier and the other (which contains some additional features) is for Excel 2007 and later. 

This Microsoft Excel workbook contains an analysis of the changes CMS made to the RBRVS and GPCI data sets on May 28, 2010 to be effective June 1, 2010. I will also be offering an very brief (free) quickinar at 1:30 pm on Thursday, June 3 to go over the worksheets and the results. 

This Microsoft Excel workbook contains the changes to the newest release of the RBRVS data base by CMS. This file was released on July 1, 2010 (the second of two) and supposedly contains what will be the data used to calculate Medicare payments for the next several months. The first worksheet contains RVU changes and the second worksheet contains non-RVU changes. 

This Microsoft Excel workbook contains the 2009 and 2010 RBRVS data for all procedure codes in the physician fee schedule (PFS) database that reported an RVU for both periods. All data are associated to the line-item procedure code; and I have included variance calculations for your convenience. 

This Microsoft Excel workbook estimates the overall change in GPCI values by specific location.

It is also an template that, if you enter the percent distribution of procedure types performed by a practice (i.e., surgery, radiology, pathology, E/M, etc.), will calculate the overall Medicare impact for the practice. It is based on the changes in the GPCI components weighted by the proportion of work, practice expense and malpractice expense RVUs within the entire database. To use it, go down the first few columns to find the specific locality for the practice. Then, in the corresponding row, in columns W, X, Y, Z and AA, put the percent distribution of each code category reported by the practice. When you are finished, Column AG will display the overall estimated adjustment for that practice. Remember, this is estimated based on the weighted adjustment in the GPCI for that locality factored by the estimated change in the allowable by category (based on the CF change and the removal of the BNA reduction factor) and doesn't include any code-specific changes that may skew the data. 

This Microsoft Excel workbook contains RVU data for some 14,000 plus procedure codes found within the Physician Fee Schedule Database (PFSDB). It shows RVU values for CY 2008 and the proposed CY 2009 data set and provides comparisons between each of the components by procedure code.