Staffing Scenario Worksheet

Staffing Scenario	Actual		Scenario
Staffing Scenario	RN hours	Total nurse staff hours	RN hours	Total nurse staff hours
Reported	{{reportedRNActual}}	{{reportedTotalActual}}
Expected	{{expRNActual}}	{{expTotalActual}}	{{expectedRN() \| setDecimal:5 }}	{{expectedTotal() \| setDecimal:5 }}
Adjusted	{{adjRNActual}}	{{adjTotalActual}}	{{adjustedRN() \| setDecimal:5 }}	{{adjustedTotal() \| setDecimal:5 }}
5 Star rating	{{starRNActual}}	{{starTotalActual}}	{{ratingRN()}}	{{ratingTotal()}}
Staffing 5 Star rating	{{starStaffingActual}}		{{ratingStaffing()}}

BA1 - Behavior

BA2 - Behavior

BB1 - Behavior

BB2 - Behavior

CA1 - Clinically Complex

CA2 - Clinically Complex

CB1 - Clinically Complex

CB2 - Clinically Complex

CC1 - Clinically Complex

CC2 - Clinically Complex

IA1 - Impaired Cognition

IA2 - Impaired Cognition

IB1 - Impaired Cognition

IB2 - Impaired Cognition

PA1 - Physical Function

PA2 - Physical Function

PB1 - Physical Function

PB2 - Physical Function

PC1 - Physical Function

PC2 - Physical Function

PD1 - Physical Function

PD2 - Physical Function

PE1 - Physical Function

PE2 - Physical Function

RHA - Rehab High

RHB - Rehab High

RHC - Rehab High

RHL - Rehab And Extensive

RHX - Rehab And Extensive

RLA - Rehab Low

RLB - Rehab Low

RLX - Rehab And Extensive

RMA - Rehab Medium

RMB - Rehab Medium

RMC - Rehab Medium

RML - Rehab And Extensive

RMX - Rehab And Extensive

RUA - Rehab Ultra High

RUB - Rehab Ultra High

RUC - Rehab Ultra High

RUL - Rehab And Extensive

RUX - Rehab And Extensive

RVA - Rehab Very High

RVB - Rehab Very High

RVC - Rehab Very High

RVL - Rehab And Extensive

RVX - Rehab And Extensive

SE1 - Extensive

SE2 - Extensive

SE3 - Extensive

SSA - Special

SSB - Special

SSC - Special

Star	RN Hours		Total Nurse Staff Hours
Star	Reported	Change in Daily Hours	Reported	Change in Daily Hours
1	< {{ForC( 0.283/0.7472*expectedRN(),'f',0.001) \| setDecimal:3}}	{{ ForC( changeRNperDay( 0.283/0.7472*expectedRN() ),'f',0.001) \| setDecimal:3}}	< {{ForC( 3.262/4.0309*expectedTotal(),'f',0.001) \| setDecimal:3}}	{{ ForC( changeTotalperDay( 3.262/4.0309*expectedTotal() ),'f',0.001) \| setDecimal:3}}
2	{{ForC( 0.283/0.7472expectedRN(),'c',0.001) \| setDecimal:3}} - {{ForC( 0.379/0.7472expectedRN(),'f',0.001) \| setDecimal:3}}	{{ ForC( changeRNperDay( 0.283/0.7472expectedRN() ),'c',0.001) \| setDecimal:3}} to {{ ForC( changeRNperDay( 0.379/0.7472expectedRN() ),'f',0.001) \| setDecimal:3}}	{{ForC( 3.262/4.0309expectedTotal(),'c',0.001) \| setDecimal:3}} - {{ForC( 3.661/4.0309expectedTotal(),'f',0.001) \| setDecimal:3}}	{{ ForC( changeTotalperDay( 3.262/4.0309expectedTotal() ),'c',0.001) \| setDecimal:3}} to {{ ForC( changeTotalperDay( 3.661/4.0309expectedTotal() ),'f',0.001) \| setDecimal:3}}
3	{{ForC( 0.379/0.7472expectedRN(),'c',0.001) \| setDecimal:3}} - {{ForC( 0.513/0.7472expectedRN(),'f',0.001) \| setDecimal:3}}	{{ ForC( changeRNperDay( 0.379/0.7472expectedRN() ),'c',0.001) \| setDecimal:3}} to {{ ForC( changeRNperDay( 0.513/0.7472expectedRN() ),'f',0.001) \| setDecimal:3}}	{{ForC( 3.661/4.0309expectedTotal(),'c',0.001) \| setDecimal:3}} - {{ForC( 4.173/4.0309expectedTotal(),'f',0.001) \| setDecimal:3}}	{{ ForC( changeTotalperDay( 3.661/4.0309expectedTotal() ),'c',0.001) \| setDecimal:3}} to {{ ForC( changeTotalperDay( 4.173/4.0309expectedTotal() ),'f',0.001) \| setDecimal:3}}
4	{{ForC( 0.513/0.7472expectedRN(),'c',0.001) \| setDecimal:3}} - {{ForC( 0.710/0.7472expectedRN(),'f',0.001) \| setDecimal:3}}	{{ ForC( changeRNperDay( 0.513/0.7472expectedRN() ),'c',0.001) \| setDecimal:3}} to {{ ForC( changeRNperDay( 0.710/0.7472expectedRN() ),'f',0.001) \| setDecimal:3}}	{{ForC( 4.173/4.0309expectedTotal(),'c',0.001) \| setDecimal:3}} - {{ForC( 4.418/4.0309expectedTotal(),'f',0.001) \| setDecimal:3}}	{{ ForC( changeTotalperDay( 4.173/4.0309expectedTotal() ),'c',0.001) \| setDecimal:3}} to {{ ForC( changeTotalperDay( 4.418/4.0309expectedTotal() ),'f',0.001) \| setDecimal:3}}
5	≥ {{ForC( 0.710/0.7472*expectedRN(),'c',0.001) \| setDecimal:3}}	{{ ForC( changeRNperDay( 0.710/0.7472*expectedRN() ),'c',0.001) \| setDecimal:3}}	≥ {{ForC( 4.418/4.0309*expectedTotal(),'c',0.001) \| setDecimal:3}}	{{ ForC( changeTotalperDay( 4.418/4.0309*expectedTotal() ),'c',0.001) \| setDecimal:3}}

Star	RN Hours		Total Nurse Staff Hours
Star	Reported	Change in Daily Hours	Reported	Change in Daily Hours
1	< {{ForC( 0.283/0.7472*expectedRN(),'f',0.001) \| setDecimal:3}}	{{ ForC( changeRNperDay( 0.283/0.7472*expectedRN() ),'f',0.001) \| setDecimal:3}}	< {{ForC( 3.262/4.0309*expectedTotal(),'f',0.001) \| setDecimal:3}}	{{ ForC( changeTotalperDay( 3.262/4.0309*expectedTotal() ),'f',0.001) \| setDecimal:3}}
2	{{ForC( 0.283/0.7472expectedRN(),'c',0.001) \| setDecimal:3}} - {{ForC( 0.379/0.7472expectedRN(),'f',0.001) \| setDecimal:3}}	{{ ForC( changeRNperDay( 0.283/0.7472expectedRN() ),'c',0.001) \| setDecimal:3}} to {{ ForC( changeRNperDay( 0.379/0.7472expectedRN() ),'f',0.001) \| setDecimal:3}}	{{ForC( 3.262/4.0309expectedTotal(),'c',0.001) \| setDecimal:3}} - {{ForC( 3.661/4.0309expectedTotal(),'f',0.001) \| setDecimal:3}}	{{ ForC( changeTotalperDay( 3.262/4.0309expectedTotal() ),'c',0.001) \| setDecimal:3}} to {{ ForC( changeTotalperDay( 3.661/4.0309expectedTotal() ),'f',0.001) \| setDecimal:3}}
3	{{ForC( 0.379/0.7472expectedRN(),'c',0.001) \| setDecimal:3}} - {{ForC( 0.513/0.7472expectedRN(),'f',0.001) \| setDecimal:3}}	{{ ForC( changeRNperDay( 0.379/0.7472expectedRN() ),'c',0.001) \| setDecimal:3}} to {{ ForC( changeRNperDay( 0.513/0.7472expectedRN() ),'f',0.001) \| setDecimal:3}}	{{ForC( 3.661/4.0309expectedTotal(),'c',0.001) \| setDecimal:3}} - {{ForC( 4.173/4.0309expectedTotal(),'f',0.001) \| setDecimal:3}}	{{ ForC( changeTotalperDay( 3.661/4.0309expectedTotal() ),'c',0.001) \| setDecimal:3}} to {{ ForC( changeTotalperDay( 4.173/4.0309expectedTotal() ),'f',0.001) \| setDecimal:3}}
4	{{ForC( 0.513/0.7472expectedRN(),'c',0.001) \| setDecimal:3}} - {{ForC( 0.710/0.7472expectedRN(),'f',0.001) \| setDecimal:3}}	{{ ForC( changeRNperDay( 0.513/0.7472expectedRN() ),'c',0.001) \| setDecimal:3}} to {{ ForC( changeRNperDay( 0.710/0.7472expectedRN() ),'f',0.001) \| setDecimal:3}}	{{ForC( 4.173/4.0309expectedTotal(),'c',0.001) \| setDecimal:3}} - {{ForC( 4.418/4.0309expectedTotal(),'f',0.001) \| setDecimal:3}}	{{ ForC( changeTotalperDay( 4.173/4.0309expectedTotal() ),'c',0.001) \| setDecimal:3}} to {{ ForC( changeTotalperDay( 4.418/4.0309expectedTotal() ),'f',0.001) \| setDecimal:3}}
5	≥ {{ForC( 0.710/0.7472*expectedRN(),'c',0.001) \| setDecimal:3}}	{{ ForC( changeRNperDay( 0.710/0.7472*expectedRN() ),'c',0.001) \| setDecimal:3}}	≥ {{ForC( 4.418/4.0309*expectedTotal(),'c',0.001) \| setDecimal:3}}	{{ ForC( changeTotalperDay( 4.418/4.0309*expectedTotal() ),'c',0.001) \| setDecimal:3}}

Staffing cut points for scenario resident mix