Versions Compared

Old Version 2

changes.mady.by.user Wagner Montes

Saved on

compared with

New Version 3

changes.mady.by.user Wagner Montes

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

Instructions & Definitions

Purpose ~ this section captures the YTD approved # of beds and occupied days.

Table - YTD Number of Resident Days ~ the data is pre-populated from tables "Details for YTD Maximum Days" and "Details for YTD Occupied Days"

Table - Details for YTD Maximum Days
i. The approved # of beds is pre-populated and based on the bed inventory data collection.
ii. Enter the start and end date for when the beds are available. Formulas have been embedded to
calculate the # of days and YTD maximum the beds are available for the start to end period.

Table - Details for YTD Occupied Days
i. For the 3 bed types, enter the # of days the beds are occupied by a client by month.

Image Added

Image Added

Index

Bed Type

Data

Field Type

int/ float / string

Calculated Field

(specify formula/calculation)

Notes

1

1 - In- scope 3.36 HPRD publicly funded beds

Approved Number of Beds

int

Pre-populated with HCC bed inventory

2

1 - In- scope 3.36 HPRD publicly funded beds

YTD Maximum Days

int

Pre-populated with HCC bed inventory

3

1 - In- scope 3.36 HPRD publicly funded beds

YTD Occupied Days

int

Pre-populated with HCC bed inventory

4

1 - In- scope 3.36 HPRD publicly funded beds

Percentage Occupied

Percentage

5

2 - Out of scope publicly funded bed

Approved Number of Beds

int

Pre-populated with HCC bed inventory

6

2 - Out of scope publicly funded bed

YTD Maximum Days

int

Pre-populated with HCC bed inventory

7

2 - Out of scope publicly funded bed

YTD Occupied Days

int

Pre-populated with HCC bed inventory

8

2 - Out of scope publicly funded bed

Percentage Occupied

Percentage

9

3 - Private Beds

Approved Number of Beds

int

Pre-populated with HCC bed inventory

10

3 - Private Beds

YTD Maximum Days

int

Pre-populated with HCC bed inventory

11

3 - Private Beds

YTD Occupied Days

int

Pre-populated with HCC bed inventory

12

3 - Private Beds

Percentage Occupied

Percentage

13

Total number beds and YTD occupied days

Approved Number of Beds

int

Pre-populated with HCC bed inventory

14

Total number beds and YTD occupied days

YTD Maximum Days

int

Pre-populated with HCC bed inventory

15

Total number beds and YTD occupied days

YTD Occupied Days

int

Pre-populated with HCC bed inventory

16

Total number beds and YTD occupied days

Percentage Occupied

Percentage

Index

Sheet

Table

Session

Field Name

Excel position or Column

Field Type

int/ float / string

Calculated Field

(specify formula/calculation)

Dependencies (Internal Sources)

Notes

43

bed occupancy

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds

1. In- scope 3.36 HPRD publicly funded beds

C18

44

bed occupancy

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds

2. Out of scope publicly funded bed

C19

45

bed occupancy

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds

3. Private Beds

C20

46

bed occupancy

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds

Total beds and YTD occupied days

C22

47

bed occupancy

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days

  1. In- scope 3.36 HPRD publicly funded beds

D18

48

bed occupancy

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days

  1. Out of scope publicly funded bed

D19

49

bed occupancy

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days

  1. Private Beds

D20

50

bed occupancy

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days

Total beds and YTD occupied days

D22

51

bed occupancy

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Occupied Days

  1. In- scope 3.36 HPRD publicly funded beds

E18

52

bed occupancy

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Occupied Days

  1. Out of scope publicly funded bed

E19

53

bed occupancy

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Occupied Days

  1. Private Beds

E20

54

bed occupancy

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Occupied Days

Total beds and YTD occupied days

E22

55

bed occupancy

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / % Occupied

  1. In- scope 3.36 HPRD publicly funded beds

F18

56

bed occupancy

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / % Occupied

  1. Out of scope publicly funded bed

F19

57

bed occupancy

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / % Occupied

  1. Private Beds

F20

58

bed occupancy

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / % Occupied

Total beds and YTD occupied days

F22

59

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds

  1. In-scope 3.36 HPRD publicly funded beds - at April 1

Time selection based on which quarter is being reported - needs Bonnie’s confirmation

60

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds

  1. In-scope 3.36 HPRD publicly funded beds - adjustments

61

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds

Subtotal 

62

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds

  1. Out-of-scope publicly funded beds - at April 1

Time selection based on which quarter is being reported - needs Bonnie’s confirmation

63

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds

  1. Out-of-scope publicly funded beds - adjustments

64

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds

Subtotal

65

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds

  1. Private Beds - at April 1

Time selection based on which quarter is being reported - needs Bonnie’s confirmation

66

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds

  1. Private Beds - adjustments

67

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds

Subtotal

68

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds

Total

69

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / Start

  1. In-scope 3.36 HPRD publicly funded beds - at April 1

Time selection based on which quarter is being reported - needs Bonnie’s confirmation

70

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / Start

  1. In-scope 3.36 HPRD publicly funded beds - adjustments

71

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / Start

  1. Out-of-scope publicly funded beds

72

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / Start

  1. Out-of-scope publicly funded beds

73

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / Start

  1. Private Beds

74

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / Start

  1. Private Beds

75

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / End

  1. In-scope 3.36 HPRD publicly funded beds - at April 1

Time selection based on which quarter is being reported - needs Bonnie’s confirmation

76

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / End

  1. In-scope 3.36 HPRD publicly funded beds - adjustments

77

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / End

  1. Out-of-scope publicly funded beds

78

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / End

  1. Out-of-scope publicly funded beds

79

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / End

  1. Private Beds

80

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / End

  1. Private Beds

81

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of days

  1. In-scope 3.36 HPRD publicly funded beds - at April 1

82

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of days

  1. In-scope 3.36 HPRD publicly funded beds - adjustments

83

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of days

  1. Out-of-scope publicly funded beds

84

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of days

  1. Out-of-scope publicly funded beds

85

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of days

  1. Private Beds

86

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of days

  1. Private Beds

87

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum

  1. In-scope 3.36 HPRD publicly funded beds - at April 1

88

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum

  1. In-scope 3.36 HPRD publicly funded beds - adjustments

89

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum

Subtotal 

90

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum

  1. Out-of-scope publicly funded beds

Field Name to be confirmed

91

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum

  1. Out-of-scope publicly funded beds

Field Name to be confirmed

92

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum

Subtotal

93

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum

  1. Private Beds

Field Name to be confirmed

94

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum

  1. Private Beds

Field Name to be confirmed

95

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum

Subtotal

96

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum

Total

97

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

April 

98

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

May

99

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

June

100

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

Subtotal ~ Q1

101

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

July

102

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

August

103

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

September

104

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

Subtotal ~ Q2

105

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

October

106

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

November

107

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

December

108

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

Subtotal ~ Q3

109

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

January

110

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

February

111

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

March 

112

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

Subtotal ~ Q4

113

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

Total

114

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

April 

115

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

May

116

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

June

117

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

Subtotal ~ Q1

118

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

July

119

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

August

120

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

September

121

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

Subtotal ~ Q2

122

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

October

123

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

November

124

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

December

125

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

Subtotal ~ Q3

126

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

January

127

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

February

128

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

March 

129

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

Subtotal ~ Q4

130

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

Total

131

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

April 

132

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

May

133

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

June

134

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

Subtotal ~ Q1

135

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

July

136

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

August

137

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

September

138

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

Subtotal ~ Q2

139

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

October

140

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

November

141

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

December

142

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

Subtotal ~ Q3

143

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

January

144

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

February

145

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

March 

146

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

Subtotal ~ Q4

147

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

Total

148

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

April 

149

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

May

150

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

June

151

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

Subtotal ~ Q1

152

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

July

153

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

August

154

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

September

155

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

Subtotal ~ Q2

156

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

October

157

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

November

158

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

December

159

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

Subtotal ~ Q3

160

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

January

161

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

February

162

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

March 

163

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

Subtotal ~ Q4

164

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

Total

165

# of beds & occupancy rate

Forecast Bed Days & Resident Days for in-scope 3.36 HPRD publicly funded beds (for 3.36 HPRD reporting) / Bed Types / # of Beds

  1. In scope 3.36 HPRD publicly funded beds

166

# of beds & occupancy rate

Forecast Bed Days & Resident Days for in-scope 3.36 HPRD publicly funded beds (for 3.36 HPRD reporting) / Bed Types / Bed days Maximum Days

  1. In scope 3.36 HPRD publicly funded beds

167

# of beds & occupancy rate

Forecast Bed Days & Resident Days for in-scope 3.36 HPRD publicly funded beds (for 3.36 HPRD reporting) / Bed Types / Resident Days

  1. In scope 3.36 HPRD publicly funded beds

168

# of beds & occupancy rate

Forecast ~ bed days maximum days / # of beds

In-scope 3.36 HPRD publicly funded beds - at April

169

# of beds & occupancy rate

Forecast ~ bed days maximum days / # of beds

In-scope 3.36 HPRD publicly funded beds - adjustment

170

# of beds & occupancy rate

Forecast ~ bed days maximum days / # of beds

Total

171

# of beds & occupancy rate

Forecast ~ bed days maximum days / Start

In-scope 3.36 HPRD publicly funded beds - at April

172

# of beds & occupancy rate

Forecast ~ bed days maximum days / Start

In-scope 3.36 HPRD publicly funded beds - adjustment

173

# of beds & occupancy rate

Forecast ~ bed days maximum days / End

In-scope 3.36 HPRD publicly funded beds - at April

174

# of beds & occupancy rate

Forecast ~ bed days maximum days / End

In-scope 3.36 HPRD publicly funded beds - adjustment

175

# of beds & occupancy rate

Forecast ~ bed days maximum days / # of days

In-scope 3.36 HPRD publicly funded beds - at April

176

# of beds & occupancy rate

Forecast ~ bed days maximum days / # of days

In-scope 3.36 HPRD publicly funded beds - adjustment

177

# of beds & occupancy rate

Forecast ~ bed days maximum days / Max. Days

In-scope 3.36 HPRD publicly funded beds - at April

178

# of beds & occupancy rate

Forecast ~ bed days maximum days / Max. Days

In-scope 3.36 HPRD publicly funded beds - adjustment

179

# of beds & occupancy rate

Forecast ~ bed days maximum days / Max. Days

Total

180

# of beds & occupancy rate

Forecast ~ resident days / Forecast

YTD resident days = 

181

# of beds & occupancy rate

Forecast ~ resident days / Forecast

# of days for last qtr ending =

182

# of beds & occupancy rate

Forecast ~ resident days / Forecast

# of days for the fiscal year =

183

# of beds & occupancy rate

Forecast ~ resident days / Forecast

Forecast