Form 1 PDG B-5 Renewal Grant Performance Progress Report

---

Overview

PDG B5 PPR
Macro Edits Made

---

Sheet 1: PDG B5 PPR

Preschool Development Grant Birth through Five Performance Progress Report

OMB Control No: 0970-0490 Expiration Date: 1/31/2020

Preschool Development Grant Birth through Five (PDG B-5) grantees are engaged in a wide array of grant activities, have varied programs in their mixed delivery systems (MDS),

and have differing data capacities and capabilities. In addition, each grantee is working toward achieving their own goals and objectives.

There may be questions in this progress report that are not directly applicable to each grantee or that each grantee may not have the requisite information/data to currently answer.

If you do not respond to a question, describe why it has been left blank and describe any planned activities that will enable completion of a response to the question in future performance progress reports.

Before proceeding, please review the accompanying instruction guide.

THE PAPERWORK REDUCTION ACT OF 1995 (Pub. L. 104-13): Public reporting burden for this collection of information is estimated to average 3 hours per response, including time for reviewing instructions, gathering

and maintaining the data needed, and reviewing the collection of information. An agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a currently

valid OMB control number.

Section A

A.1 Complete the table to provide the following information regarding the programs in your state’s PDG B-5 MDS.

PDG B-5 MDS Program Name (Type Response)

Lead Agency/ Department (Type Response, 500 Character Limit)

Lead Office/ Division/ Bureau (Type Response, 500 Character Limit)

Total Number of Programs:

Total Number of Agencies/ Departments:

Total Number of Offices/ Divisions/ Bureaus:

3

0

0

A.2 Describe recent or ongoing efforts to streamline the administrative governance of programs in your state's PDG B-5 MDS.

Describe progress since the last reporting period and planned activities for the next reporting period.

(500 character limit)

A.3 Does the state have any working groups, comprised of PDG B-5 MDS program representatives, that meet specifically about the PDG B-5 initiative?

Yes

A.3.1 IF YES, please describe the nature of these working groups.

Participating PDG B-5 MDS Programs (Type Response)

Meeting Frequency (Select one)

Meeting Frequency (if other) (Type Response, 500 Character Limit)

Working Group Goals and Objectives (Type Response, 500 Character Limit)

End Table A.3.1

A.4 Does the state have other active councils or working groups that support efforts to coordinate programs within the PDG B-5 MDS (e.g. children's cabinets, early learning advisory groups)?

A.4.1 IF YES, please provide the following details for each active council or entity.

Council/Entity Name (Type Response)

Council/Entity Description (Type Response, 500 Character Limit)

Council/Entity Goals and Objectives (Type Response, 500 Character Limit)

Participating PDG B-5 MDS Programs and # of Representatives from Each (Type Response)

End Table A.4.1

A.5 Does your state have external partners that support state efforts to coordinate programs within your state’s PDG B-5 MDS?

A.5.1 IF YES, provide a detailed description of each external partnership.

External Partner Name (Type Response)

External Partner Category (Select one)

External Partner Category (if other) (Type Response, 500 Character Limit)

Coordination with PDG B-5 MDS Programs (Type Response)

Is there a formal partnership agreement/ MOU? (Select Yes or No)

Partnership Goals and Objectives (Type Response, 500 Character Limit)

End Table A.5.1

A.6 Describe recent or ongoing efforts to better coordinate programs in your state's PDG B-5 MDS.

Describe progress since the last reporting period and planned activities for the next reporting period.

(500 character limit)

A.7 Describe how your state's Head Start Collaboration Office is engaged in PDG B-5 activities and otherwise supports state efforts to coordinate programs in your PDG B-5 MDS.

(500 character limit)

A.8 Complete the table to describe the following terms as defined by your state for the PDG B-5 initiative:

Term

Does the state have a PDG B-5 definition for this term? (Select Yes or No)

Definition or Coding (Type Response, 500 Character Limit)

Which of your state's PDG B-5 MDS programs use this definition? (Type Response)

Quality Early Childhood Care and Education

Availability

Vulnerable or Underserved

Children in Rural Areas

Low-Income Children/Families

End Table A.8

A.9 Describe recent or ongoing efforts to standardize definitions across programs in your state's PDG B-5 MDS.

Describe progress since the last reporting period and planned activities for the next reporting period.

(500 character limit)

Section B

B.1 Complete the tables below.

B.1.1 Type of Services Provided: Identify the type of services provided by each program in your state's PDG B-5 MDS. All PDG B-5 MDS programs identified in question A.1 are listed below.

PDG B-5 MDS Program Name

Child Care Financial Assistance (Type "1" if Applicable)

Child Welfare (Type "1" if Applicable)

Early Care and Education (Type "1" if Applicable)

Family Outreach/Support (Type "1" if Applicable)

Financial Assistance (Non-Child Care) (Type "1" if Applicable)

Health Insurance (Type "1" if Applicable)

Health Services (Type "1" if Applicable)

Home Visiting (Type "1" if Applicable)

Literacy (Type "1" if Applicable)

Nutrition (Type "1" if Applicable)

Other (Type "1" if Applicable)

If Selected "Other" Please describe

Err:508

Totals

0

0

0

0

0

0

0

0

0

0

0

NA

End Table B.1.1

As of Date:

B.1.2 Funding and Expenditures

Funding Fiscal Year:

Expenditure Fiscal Year:

PDG B-5 MDS Program Name

Federal Funds (Type "1" if Applicable)

Private Funds (Type "1" if Applicable)

State Funds (Type "1" if Applicable)

County/Local Funds (Type "1" if Applicable)

Federal Funding Source (Select Response)

If Selected "Other," Please describe

Federal Funding Total Amount (Type $ Amount)

State Funding Total Amount (Type $ Amount)

Other Funding Sources Total Amount (Type $ Amount)

Total Funding

Total Expenditures (Type $ Amount)

Service Delivery Expenditures (Type $ Amount)

Overhead Expenditures (Automatically Calculated)

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

$-

Totals

0

0

0

NA

NA

$-

$-

$-

$-

$-

$-

$-

End Table B.1.2

B.1.3 Children Served: Data entered in this table pertain to the number of children served by each program in your state’s PDG B-5 MDS.

Please note that any counts of children served entered in this chart are not unduplicated counts. Enter the appropriate number response or respond with "NA" or "UN" as applicable.

PDG B-5 MDS Program Name

Total Children Served, across all ages (Type # Served)

Total B-5 Children Served (Type # Served)

Vulnerable or Underserved B-5 Children Served (Type # Served)

Low Income B-5 Children Served (Type # Served)

Rural B-5 Children Served (Type # Served)

Ages 0 -1 (Type # Served)

Age 1 (Type # Served)

Age 2 (Type # Served)

Age 3 (Type # Served)

Age 4 (Type # Served)

Age 5 (Type # Served)

Err:508

Err:508

Err:508

Err:508

Err:508

Err:508

Err:508

Err:508

Err:508

Err:508

Err:508

Err:508

Err:508

Err:508

Err:508

End Table B.1.3

As of Date:

B.1.3.1 If the state is able to provide distinct (unduplicated) counts of children served across the PDG B-5 MDS, enter those counts for each column.; otherwise enter 'UN' for unavailable.

Total Children Served Across PDG B-5 MDS Programs, include all ages (Type # Served)

Total B-5 Children Served (Type # Served)

Vulnerable or Underserved B-5 Children Served (Type # Served)

Low Income B-5 Children Served (Type # Served)

Rural B-5 Children Served (Type # Served)

Ages 0 -1 (Type # Served)

Age 1 (Type # Served)

Age 2 (Type # Served)

Age 3 (Type # Served)

Age 4 (Type # Served)

Age 5 (Type # Served)

End Table B.1.3.1

As of Date:

B.1.4 Families Served

Please note that any counts of families served entered in this chart are not unduplicated counts. Enter the appropriate number response or respond with "NA" or "UN" as applicable.

PDG B-5 MDS Program Name

Total Families Served, include families with children of all ages (Type # Served)

Total B-5 Families Served (Type # Served)

Vulnerable or Underserved B-5 Families Served (Type # Served)

Low Income B-5 Families Served (Type # Served)

Rural B-5 Families Served (Type # Served)

End Table B.1.4

As of Date:

B.1.4.1 If your state is able to produce distinct (unduplicated) counts of families served across the PDG B-5 MDS, enter distinct counts below; otherwise enter 'UN' for unavailable.

Total Families Served, include all ages (Type # Served)

Total B-5 Families Served (Type # Served)

Vulnerable or Underserved B-5 Families Served (Type # Served)

Low Income B-5 Families Served (Type # Served)

Rural B-5 Families Served (Type # Served)

End Table B.1.4.1

As of Date:

B.1.5 If you were unable to provide any of the data in the questions above (B.1.1-B.1.3) due to data capacity limitations,

describe barriers to providing data and plans to improve data capacity in order to report this information in future reporting periods.

(500 character limit)

B.2 Describe recent or ongoing efforts to serve more children and families in your state's PDG B-5 MDS.

Describe progress since the last reporting period and planned activities for the next reporting period.

B.3 Describe recent or ongoing efforts (including policies or incentives) to align funding, regulatory standards, or other regulatory requirements across your state's PDG B-5 MDS programs.

Describe progress since the last reporting period and planned activities for the next reporting period.

(500 character limit)

B.4 Describe recent or ongoing efforts across PDG B-5 MDS programs to engage unlisted, unregistered, unlicensed, or informal care providers.

Describe progress since the last reporting period and planned activities for the next reporting period.

(500 character limit)

B.5 Do you have external partners that support state efforts to reach unlisted, unregistered, unlicensed, or informal ECE providers?

B.5.1 IF YES, provide a detailed description of each external partnership.

External Partner Name (Type Response)

External Partner Category (Select one)

External Partner Category (if other) (Type Response, 500 Character Limit)

Coordination with PDG B-5 MDS Programs (Type Response)

Partnership Goals and Objectives (Type Response, 500 Character Limit)

End Table B.5.1

B.6 Provide the number of registered providers and slots for each PDG B-5 MDS program that offers ECE services in your state.

Please note that any counts entered in this chart do not need to be unduplicated counts. Enter the appropriate number response or respond with "NA" or "UN" as applicable.

PDG B-5 MDS Program Name

Who is included in your definition of "Registered Providers"? (Type Response, 500 Character Limit)

Total Number of Providers (Type #)

Total Number of Center-Based Providers (Type #)

Total Number of Home-Based Providers (Type #)

Total Number of Slots (Type #)

Total Number of Center-Based Slots (Type #)

Total Number of Home-Based Slots (Type #)

End Table B.6

As of Date:

B.6.1 If the state is able to provide distinct counts of providers and slots across the PDG B-5 MDS programs that offer ECE services, provide the information below; otherwise enter 'UN' for unavailable.

Total Number of Providers (Type #)

Total Number of Center-Based Providers (Type #)

Total Number of Home-Based Providers (Type #)

Total Number of Slots (Type #)

Total Number of Center-Based Slots (Type #)

Total Number of Home-Based Slots (Type #)

End Table B.6.1

As of Date:

B.6.2 If you were unable to provide any of the data in the questions above (B.6 or B.6.2) due to data capacity limitations,

describe barriers to providing data and plans to improve data capacity in order to report this information in future reporting periods.

(500 character limit)

Section C

C.1 Are any vulnerable and/or underserved populations prioritized for enrollment in your state's PDG B-5 MDS programs?

C.1.1 IF YES, list the programs and the populations prioritized.

Enter PDG B-5 MDS Program Name(s) (Type Response)

Prioritized Population(s) (Type Response, 500 Character Limit)

Prioritization Description (Type Response, 500 Character Limit)

End Table C.1.1

C.2 Describe recent or ongoing efforts to serve more vulnerable and/or underserved children and families in your state's PDG B-5 MDS.

Describe progress since the last reporting period and planned activities for the next reporting period.

(500 character limit)

Section D

D.1 Detail which of your state’s PDG B-5 MDS programs that offer ECE services are included in the state’s QRIS and licensing system.

PDG B-5 MDS Program Name (Select Response)

Included in state QRIS System? (Select Yes or No)

Included in state licensing system? (Select Yes or No)

End Table D.1

D.2 Does your state have an early childhood workforce registry?

D.2.1 IF YES, indicate which of your state's PDG B-5 MDS Programs participate in the state early childhood workforce registry.

PDG B-5 MDS Program Name(s) (Type Response)

End Table D.2.1

D.3 Does your state have early learning standards?

D.3.1 IF YES, for what ages?

D.3.2 IF YES, indicate which of your state's PDG B-5 MDS Programs use these standards and and describe how they use them (e.g., quality improvement initiatives, curricula selection, professional development and training)

D.4 Does your state have a competency framework that articulates the competencies (i.e., knowledge, skills, or other attributes) essential to the practice of teaching and caregiving for children B-5?

D.4.1 IF YES, which programs in your state PDG B-5 MDS use this framework?

PDG B-5 MDS Program Name(s) (Type Response)

End Table D.4.1

D.5 Describe recent or ongoing efforts to improve the quality of PDG B-5 MDS programs?

Describe progress since the last reporting period and planned activities for the next reporting period.

(500 character limit)

Section E

E.1 Identify the programs in your state's PDG B-5 MDS that are featured or listed in your state child care consumer education website.

PDG B-5 MDS Program Name(s) (Type Response)

End Table E.1

E.2 Does your state have a family engagement framework detailing the way families are engaged across PDG B-5 MDS programs?

E.2.1 IF YES, which of the state's PDG B-5 MDS programs use the framework?

PDG B-5 MDS Program Name(s) (Type Response)

End table E.2.1

E.3 Does your state have a Kindergarten Readiness Assessment (KRA)?

E.3.1 IF YES, describe whether and how the KRA aligns with your state's early learning standards.

(500 character limit)

E.4 Describe recent or ongoing efforts to support collaboration between your state's PDG B-5 MDS programs and elementary schools?

Describe progress since the last reporting period and planned activities for the next reporting period.

(500 character limit)

Section F

F.1 Does the state have centralized or consolidated application processes established across programs in your state's PDG B-5 MDS?

F.1.1 IF YES, identify the PDG B-5 MDS programs with programs included in a centralized or consolidated application processes and provide a brief description of the centralized or consolidated application process.

PDG B-5 MDS Program Name(s) (Type Response)

Description of the application process (Type Response, 500 Character Limit)

End Table F.1.1

F.1.2 IF NO, is there a plan/roadmap toward creating centralized or consolidated application processes across your state's PDG B-5 MDS programs?

F.1.3 Describe progress since the last reporting period and planned activities for the next reporting period.

Include any plans the state has to enhance, expand, or improve previously consolidated application processes across your state's PDG B-5 MDS programs.

(500 character limit)

F.2 Do any programs in your state's PDG B-5 MDS share common eligibility requirements?

F.2.1 IF YES, describe common eligibility requirements and identify the programs they apply to. Describe progress since the last reporting period and planned activities for the next reporting period.

(500 character limit)

F.3 Describe recent or ongoing efforts to improve resource efficiency in PDG B-5 MDS programs?

Describe efficiencies resulting from (1) resource sharing, (2) coordination of services, and (3) reduction in duplication of services. In addition, describe other approaches to improve resource efficiency.

Describe progress since the last reporting period and planned activities for the next reporting period.

(500 character limit)

Section G

G.1 Describe governance of administrative data for each PDG B-5 MDS program. Include a description of the groups involved and their roles and responsibilities.

(500 character limit)

G.2 Describe recent or ongoing efforts to streamline data governance? Describe progress since the last reporting period and planned activities for the next reporting period.

(500 character limit)

Section H

H.1 Does your state have an integrated data system?

H.1.1 IF YES, what agency governs the integrated data system?

(500 character limit)

H.1.2 IF YES, provide a description of your state's integrated data system.

(500 character limit)

H.1.3 IF YES, identify which programs in your state's PDG B-5 MDS are included in the integrated data system.

PDG B-5 MDS Program Name(s) (Type Response)

End Table H.1.3

H.1.4 IF YES, describe recent or ongoing efforts to develop or enhance your integrated data system. Describe progress since the last reporting period and planned activities for the next reporting period

(500 character limit)

H.1.5 IF NO, are there plans to build an integrated data system as part of the PDG B-5 grant? If so, describe plans and estimated timeline.

(500 character limit)

H.2 Describe recent or ongoing efforts to enhance or improve data coordination and sharing between programs in your state's PDG B-5 MDS.

Describe progress since the last reporting period and planned activities for the next reporting period.

(500 character limit)

H.3 Do any programs in your state's PDG B-5 MDS that have the data capacity to track children, families, and/or service providers longitudinally (i.e., over time)?

H.3.1 IF YES, describe capability and how these data are used to inform PDG B-5 grant activities.

(500 character limit)

H.3.2 Describe recent or ongoing efforts to enhance or improve longitudinal data system capabilities.

Describe progress since the last reporting period and planned activities for the next reporting period.

(500 character limit)

H.4 Does your state have the ability to distinctly track and produce distinct counts (e.g. unduplicated counts) for children, families, and/or ECE providers?

H.4.1 IF YES, detail capability below

Capability Level (Select one)

Detailed description of capability Examples: UID type, Data matching elements such as DOB, etc. (Type Response, 500 Character Limit)

Applicable PDG B-5 Programs (Type Response)

Data System Name and/or Description (Type Response, 500 Character Limit)

Detailed description of how you use this information to inform PDG B-5 grant activities (Type Response, 500 Character Limit)

End Table H.4.1

H.4.2 IF NO, describe plans to develop the capability to distinctly track and produce distinct counts (i.e., unduplicated counts) of children, families, and/or ECE providers across PDG B-5 MDS programs.

(500 character limit)

H.5 How does your state currently use the administrative data of programs in your state's PDG B-5 MDS?

Data Uses

PDG B-5 MDS Program Name(s) (Type Response)

Research

Continuous quality improvement

Decision making

Other (Describe)

End Table H.5

If Selected "Other," Please describe:

(500 character limit)

Section I

I.1 PDG B-5 GRANT ACTIVITY STATUS

Grant Activity, Goal or Objective (Type Name or Description)

Status (Type Response, 750 Character Limit)

Completion Date (Type Response)

Activity Progress Details (Type Response, 750 Character Limit)

End Table I.1

I.2 Describe recent or ongoing efforts to enhance and/or implement your State's Program Performance Evaluation plan.

Describe progress since the last reporting period and planned activities for the next reporting period.

(750 character limit)

I.3 Provide a description of how your Program Performance Evaluation (PPE) has informed your PDG B-5 grant activities to date.

(750 character limit)

---

Sheet 2: Macro Edits Made

Original Question #	New Question #	Original Function	Change Made	Rationale for Change
A.1	A.1	Macros enabled an "Insert Row" button to easily add rows for grantees to list program names. Macros also enabled program names to auto populate into other tables and dropdown lists.	"Insert Row" button removed. Table contains 50 rows, with a formula that will auto populate other tables and dropdown boxes elsewhere.	Maintains similar functionality without use of macros. Grantees will be instructed to delete unused rows.
A.1.1	A.1.1	Macros enabled "Auto-populate Program Names" button, which initiated a command to auto populate other tables and dropdowns.	Button removed, as formula within A.1 enables auto population.	A.1 maintains similar functionality without use of macros.
A.3.1	A.3.1	Macros enabled multiple dropdown selections to be listed in one cell under the "Participating PDG B-5 MDS Programs" column.	"Participating PDG B-5 MDS Programs" column switched to a "Type Response" cell.	Multiple selections from a dropdown list in one cell is not possible without macros. Typed response allows grantee to list applicable programs separated by a comma.
A.3.1	A.3.1	Macros enabled a pop-up box which allowed grantees to describe if they selected "Other" in "Meeting Frequency" column	"Other" response column added to table. Conditional formatting added to highlight the cell if grantees select "Other" under the "Meeting Frequency" column	Grantees unable to describe "Other" within table without use of macros. Response box added below table so grantees can provide applicable details.
A.3.1	A.3.1	Macros enabled an "Insert Row" button to easily add rows for grantees to list program names.	"Insert Row" button removed. 10 rows added as a baseline.	Maintains similar functionality without use of macros. Grantees may add additional rows if needed.
A.4.1	A.4.1	Macros enabled multiple dropdown selections to be listed in one cell under "Participating PDG B-5 MDS Programs" column.	"Participating PDG B-5 MDS Programs" column switched to a "Type Response" cell.	Multiple selections from a dropdown list in one cell is not possible without macros. Typed response allows grantee to list applicable programs separated by a comma.
A.4.1	A.4.1	Macros enabled an "Insert Row" button to easily add rows.	"Insert Row" button removed. 10 rows added as a baseline.	Maintains similar functionality without use of macros. Grantees may add additional rows if needed.
A.5.1	A.5.1	Macros enabled a pop-up box which allowed grantees to describe if they selected "Other" in External Partner Category" column	"Other" response column added to the table. Conditional formatting added to highlight the cell if grantees select "Other" under the "External Partner Category" column.	Grantees unable to describe "Other" within table without use of macros. Response box added below table so grantees can provide applicable details.
A.5.1	A.5.1	Macros enabled multiple dropdown selections to be listed in one cell under "Participating PDG B-5 MDS Programs" column.	"Participating PDG B-5 MDS Programs" column switched to a "Type Response" cell.	Multiple selections from a dropdown list in one cell is not possible without macros. Typed response allows grantee to list applicable programs separated by a comma.
A.5.1	A.5.1	Macros enabled an "Insert Row" button to easily add rows.	"Insert Row" button removed. 10 rows added as a baseline.	Maintains similar functionality without use of macros. Grantees may add additional rows if needed.
A.8	A.8	Macros enabled multiple dropdown selections to be listed in one cell under "Which of your state's PDG B-5 MDS programs use this definition" column.	"Which of your state's PDG B-5 MDS programs use this definition" column switched to a "Type Response" cell.	Multiple selections from a dropdown list in one cell is not possible without macros. Typed response allows grantee to list applicable programs separated by a comma.
A.8	A.8	Macros enabled an "Insert Row" button to easily add rows.	"Insert Row" button removed.	No need for insert row button anymore
B.1.1	B.1.1	Macros enabled auto-population of "Program Name" rows	Formula added to auto populate rows with programs listed in A.1. 50 cells added as a baseline.	Maintains similar functionality without use of macros. Grantees will be instructed to delete unused rows.
B.1.1	B.1.1	Macros enabled multiple selections under "Types of Services Provided", "Types of Federal Funding Sources", and "Federal Funding Sources" columns	Original table has been split into 2, with services now in its own table (B.1.1). Allows grantees to indicate multiple services per program.	Maintains similar functionality without use of macros. Grantees will be instructed to delete unused rows.
B.1.1	B.1.1	Macros enabled a pop-up box which allowed grantees to describe if they selected "Other" in "Types of Services Provided" column	"If selected "other", please describe below" column added within table. Conditional formatting added to un-shade column if grantees select "Other" option	Grantees unable to describe "Other" within table without use of macros. Column added to end of table so grantees can provide applicable details.
B.1.1	B.1.1	Macros enabled multiple service selections per program	Added row at the bottom of the table with AutoSum function to count the number of each service indicated in each column.	Maintains similar functionality without use of macros. Allows ACF to view how many programs per service were selected across the MDS.
B.1.1	B.1.2	Macros enabled multiple selections under "Types of Services Provided", "Types of Federal Funding Sources", and "Federal Funding Sources" columns	Original table has been split into 2, with funding details now its own table (B.1.2). Allows grantees to indicate multiple funding details per program.	Maintains similar functionality without use of macros. Grantees will be instructed to delete unused rows.
B.1.1	B.1.2	Macros enabled a pop-up box which allowed grantees to describe if they selected "Other" in "Federal Funding Source" column	"If selected "other", please describe below" column added within table. Conditional formatting added to un-shade column if grantees select "Other" option	Grantees unable to describe "Other" within table without use of macros. Column added so grantees can provide applicable details.
B.1.2	B.1.3	Macros enabled auto-population of "Program Name" rows	Formula added to allow for auto population of rows. 50 cells added as a baseline. Grantees will be instructed to delete any rows that are not used	Maintains similar functionality without use of macros. Grantees will be instructed to delete unused rows.
B.1.3	B.1.4	Macros enabled auto-population of "Program Name" rows	Formula added to allow for auto population of rows. 50 cells added as a baseline, grantees will be instructed to delete any rows that are not used	Maintains similar functionality without use of macros. Grantees will be instructed to delete unused rows.
B.5.1	B.5.1	Macros enabled multiple dropdown selections to be listed in one cell under "Coordination with PDG B-5 MDS Programs" column.	"Coordination with PDG B-5 MDS Programs" column switched to a "Type Response" cell.	Multiple selections from a dropdown list in one cell is not possible without macros. Typed response allows grantee to list applicable programs separated by a comma.
B.5.1	B.5.1	Macros enabled a pop-up box which allowed grantees to describe if they selected "Other" in "External Partner Category" column	"Other" response column added to the table. Conditional formatting added to highlight the cell if grantees select "Other" under the "External Partner Category" column	Grantees unable to describe "Other" within table without use of macros. Response box added below table so grantees can provide applicable details.
B.5.1	B.5.1	Macros enabled an "Insert Row" button to easily add rows.	"Insert Row" button removed. 10 rows added as a baseline.	Maintains similar functionality without use of macros. Grantees may add additional rows if needed.
C.1.1	C.1.1	Macros enabled multiple dropdown selections to be listed in one cell under "PDG B-5 MDS Program Name" column.	"PDG B-5 MDS Program Name" column switched to a "Type Response" cell.	Multiple selections from a dropdown list in one cell is not possible without macros. Typed response allows grantee to list applicable programs separated by a comma.
C.1.1	C.1.1	Macros enabled an "Insert Row" button to easily add rows.	"Insert Row" button removed. 10 rows added as a baseline.	Maintains similar functionality without use of macros. Grantees may add additional rows if needed.
D.1	D.1	Macros enabled a dropdown list to appear under "PDG B-5 MDS Program Name" column, based on programs listed in A.1	Data validation applied for a dropdown list to appear in "PDG B-5 MDS Program Name" column, based on programs listed in A.1. 10 rows added as a baseline	Maintains similar functionality without use of macros. Grantees may add additional rows if needed.
D.2.1	D.2.1	Macros enabled multiple dropdown selections to be listed in one cell under "PDG B-5 MDS Program Name" column.	"PDG B-5 MDS Program Name" column switched to a "Type Response" cell.	Multiple selections from a dropdown list in one cell is not possible without macros. Typed response allows grantee to list applicable programs separated by a comma.
D.3.2	D.3.2	Macros enabled multiple dropdown selections to be listed in one cell under "PDG B-5 MDS Program Name" column.	"PDG B-5 MDS Program Name" column switched to a "Type Response" cell.	Multiple selections from a dropdown list in one cell is not possible without macros. Typed response allows grantee to list applicable programs separated by a comma.
D.4.1	D.4.1	Macros enabled multiple dropdown selections to be listed in one cell under "PDG B-5 MDS Program Name" column.	"PDG B-5 MDS Program Name" column switched to a "Type Response" cell.	Multiple selections from a dropdown list in one cell is not possible without macros. Typed response allows grantee to list applicable programs separated by a comma.
E.1	E.1	Macros enabled multiple dropdown selections to be listed in one cell under "PDG B-5 MDS Program Name" column.	"PDG B-5 MDS Program Name" column switched to a "Type Response" cell.	Multiple selections from a dropdown list in one cell is not possible without macros. Typed response allows grantee to list applicable programs separated by a comma.
E.2.1	E.2.1	Macros enabled multiple dropdown selections to be listed in one cell under "PDG B-5 MDS Program Name" column.	"PDG B-5 MDS Program Name" column switched to a "Type Response" cell.	Multiple selections from a dropdown list in one cell is not possible without macros. Typed response allows grantee to list applicable programs separated by a comma.
F.1.1	F.1.1	Macros enabled multiple dropdown selections to be listed in one cell under "PDG B-5 MDS Program Name" column.	"PDG B-5 MDS Program Name" column switched to a "Type Response" cell.	Multiple selections from a dropdown list in one cell is not possible without macros. Typed response allows grantee to list applicable programs separated by a comma.
F.1.1	F.1.1	Macros enabled an "Insert Row" button to easily add rows.	"Insert Row" button removed. 10 rows added as a baseline.	Maintains similar functionality without use of macros. Grantees may add additional rows if needed.
H.1.3	H.1.3	Macros enabled multiple dropdown selections to be listed in one cell under "PDG B-5 MDS Program Name" column.	"PDG B-5 MDS Program Name" column switched to a "Type Response" cell.	Multiple selections from a dropdown list in one cell is not possible without macros. Typed response allows grantee to list applicable programs separated by a comma.
H.4.1	H.4.1	Macros enabled multiple dropdown selections to be listed in one cell under "PDG B-5 MDS Program Name" column.	"PDG B-5 MDS Program Name" column switched to a "Type Response" cell.	Multiple selections from a dropdown list in one cell is not possible without macros. Typed response allows grantee to list applicable programs separated by a comma.
H.4.1	H.4.1	Macros enabled an "Insert Row" button to easily add rows.	"Insert Row" button removed. 10 rows added as a baseline.	Maintains similar functionality without use of macros. Grantees may add additional rows if needed.
H.5	H.5	Macros enabled multiple selections from dropdown under "Data Uses" column.	Options that were originally in a dropdown list are now pre-populated in the first column of the table.	Multiple selections from a dropdown list in one cell is not possible without macros. Pre-filled rows will allow grantees to indicate which programs apply to each Data Use.
H.5	H.5	Macros enabled a pop-up box allowed grantees to describe if they selected "Other" in Data Uses" column	"Other" response box added below table. Conditional formatting added to highlight box if grantees select "Other" under the Data Uses" column	Grantees unable to describe "Other" within table without use of macros. Response box added below table so grantees can provide applicable details.
H.5	H.5	Macros enabled multiple dropdown selections to be listed in one cell under "PDG B-5 MDS Program Name" column.	"PDG B-5 MDS Program Name" column switched to a "Type Response" cell.	Multiple selections from a dropdown list in one cell is not possible without macros. Typed response allows grantee to list applicable programs separated by a comma.
H.5	H.5	Macros enabled an "Insert Row" button to easily add rows.	"Insert Row" button removed.	Maintains similar functionality without use of macros. Grantees may add additional rows if needed.