Hi Ron, I am eager to try your spread sheet. I have been doing this by
hand for several years now and basing my calculations on a formula from Sherri
Kennedy that was published in Post Acute Payment a few years
ago . As far as knowing how many MPAFs a facility submits you can
get this info from the CASPER on-line report titled RFA (reason for
assessment). I have a question for you though. When you present your
calculations how often would you say the facility then provides the
appropriate staff outlined by your calculations? Jeanne
For those of you who prefer to use different times than those built into
the spreadsheet for the completion of the various assessments I am
attaching an unprotected worksheet so that you can change the time value in
the calculation. For my own personal situation I changed several of the
time calculations, ie., I thought 15 minutes for a d/c tracking/reentry
form was a bit much.
If you click on the box that represents the total # of hours for each
assessment type you will see an equation similar to the one
below: The equation below is for comprehensive assessments
and the number in red represents 6 hours. If you feel it requires more
time you can should change that one number.
=IF(B13="","",((B13*6)/3
Do this for each of the equations and types of assessments. Be very
careful not to change anything else in the equation or it will not calculate
properly.
Remember this is a guide not an exact
science. There are multiple varying opinions on the
amount of time it takes to do the various assessments. Keep in mind
depending on the resident assessment completion times for the same type of
assessment will vary, as well specific facility practices.
In addition, there is no calculation for MPAF assessments, since these
are not reported on the MDS reports separately it would be difficult to
determine the # of those completed and submitted by looking at the state
reports. The current spreadsheet calculates 3 hours for the time to
complete a full assessment ( I actually used 2 hours as my est). Many
facilities do MPAFs for all Medicare only assessments, this may give you the
extra cushion required if 6 hours or 2.5 hours for the comprehensives or
quarterlies is not sufficient.
I used this spreadsheet to see if we were anywhere near close to
having an adequate # of people allocated to meeting the demands of the
RAI/PPS processes.
In addition to the assessment times I also factored in 10 hours a week of
non-MDS related time. Depending on your situation this may be too much
(highe unlikely) or too little.
Hope this helps.
Ron
