Hello,
I am trying to budget worked relative value units (wRVU's) for physicians in a hospital owned medical group. Each physician has wRVU benchmarks based on their specialty. I included the wRVU's for each percentile in the attached spreadsheet (columns G through Q). I have calculated their Sept. 2014 year to date RVU's (column B) and Annualized 2015 RVU's (column D) and would like to create a formula that will populate in columns E and F the percentile that each physician is performing at based on the benchmark RVU values in columns G though Q. The only issue I have is that the benchmarks for each percentile needs to be adjusted based on their Scheduled FTE's (1.0 is full time) and non-clinical RVU's so that their benchmark only represents clinical productivity (benchmark X Sched FTE's - Non-clinical RVU's). Therefore, we need to compare each physician's Sept YTD 2014 RVU's and Annualized 2015 YTD RVU's to the adjusted benchmarks to determine what their percentile is. This formula is illustrated for the Median benchmark (see Column U). In row 3, I illustrate what should populate in column E if provider 2200's Sept. 2014 YTD worked RVU's equalled the adjusted median (column U).
Is it possible to create a formula that will do this?
Thank you so much.
I am trying to budget worked relative value units (wRVU's) for physicians in a hospital owned medical group. Each physician has wRVU benchmarks based on their specialty. I included the wRVU's for each percentile in the attached spreadsheet (columns G through Q). I have calculated their Sept. 2014 year to date RVU's (column B) and Annualized 2015 RVU's (column D) and would like to create a formula that will populate in columns E and F the percentile that each physician is performing at based on the benchmark RVU values in columns G though Q. The only issue I have is that the benchmarks for each percentile needs to be adjusted based on their Scheduled FTE's (1.0 is full time) and non-clinical RVU's so that their benchmark only represents clinical productivity (benchmark X Sched FTE's - Non-clinical RVU's). Therefore, we need to compare each physician's Sept YTD 2014 RVU's and Annualized 2015 YTD RVU's to the adjusted benchmarks to determine what their percentile is. This formula is illustrated for the Median benchmark (see Column U). In row 3, I illustrate what should populate in column E if provider 2200's Sept. 2014 YTD worked RVU's equalled the adjusted median (column U).
Is it possible to create a formula that will do this?
Thank you so much.