Background

The original sample Excel workbook provided by Bonnie included 12 sheets that require data entry.

...

The report data is organized in three colored sections besides the facility information:

• Detail each section

Bonnie’s notes:

Quarterly Reporting

There is a calculator tool on bw - notes sheet. Below is a fixed example:

...

Worked Hours Definition

Worked Hours - hours actually worked by an employee and/or contract service provider (productive time) including:

...

• non-paid hours

• unworked hours earned, taken or paid for or in-lieu of:
  -statutory holidays

• annual vacation

• sick time

• any other purpose

• staff development/education/orientation

• "premium" (the list below is not intended to be exhaustive), such as payments based on hours for working:

• an overtime hour

• a named or statutory holiday

• shift differential premium for working an evening, night or weekend shift

• on-call premium/stand-by pay

Direct Care Worked Hours

Direct Care Worked Hours are a subset of worked hours (as defined above) and include only the hours worked by staff or contracted service providers (including RN, RPN, LPN, Care Aides and Allied Care) in the direct delivery of services to residents.

...