Collection of Information from HUD Lead Hazard Control Grantees

---

Overview

Start_Here
Central_Control
UNIT_Q

---

Sheet 1: Start_Here

	OHLHB0477-10	<-Grant No.	Questionnaire Completion Status->	Not Completed
INSTRUCTIONS FOR QUESTIONNAIRE
To: Grantees receiving Lead Hazard Control funding
	QuanTech has been tasked to obtain information about your experience conducting clearance testing on your Lead Hazard Control (LHC) grant. Please answer the questions provided in this Excel workbookbased on your organization’s experience during the last 12 months. If you have any questions, contact either Gary Dewalt, of QuanTech, the questionnaire contractor, at 610-255-5525 or Eugene Pinzer, of HUD’s Office of Healthy Homes and Lead Hazard Control, at 202-402-7685. OMB Control No. xxxx-xxxx.
Software Requirements
	This questionnaire contains a large number of macros and must be run using Excel 2007 or a more recent version of Excel. When the workbook (spreadsheet) is opened, you must give permission to allow the macros to be run if asked by your software. In addition, it is recommended that you do not have any other Excel workbooks open when using this spreadsheet!
General Information on How to Use this Questionnaire
	This questionnaire is provided in an email to you and has been specifically configured for your Lead Hazard Control grant (number listed at the top left of this sheet). If the grant number shown is not one that you have, please contact Gary Dewalt for more instructions. Two sets of questions are provided in this workbook. One set is a "general" question set containing 6 questions. The other set is a dwelling "unit-specific" set of 18 questions. All questions are answered by clicking on buttons provided throughout this workbook. Direct entries into worksheet cells are not required nor reccomended. You can change the answer to any question by simply going back and clicking the entry button for that question. However, keep in mind that doing so will remove your previous entry for that specific question and the question must be re-answered even if you decided not to change it after your re-clicked an entry button that already had an answer. The workbook is setup to display your data entries as you make them, so you will know immediately if this happens. This workbook has been pre-populated with up to a maximum of 20 dwelling unit addresses that you have reported as having been completed in OHHLHC's Quarterly Progress Report System. In addition to answering the set of 6 general questions, to complete the questionnaire you must answer the same unit-specific set of 18 questions for each of these unit addresses.
Before You Start
	If you have not done so already, please save this questionnaire in a directory of your hard drive that is easily accessible to you and re-open it from that directory before answering any questions. We recommend not changing the name of the file as it has your grant ID embedded within the filename.
Saving the questionnaire
	Buttons are provided to save a completed or partially completed questionnaire to your hard drive. These buttons will save the workbook in whatever directory the workbook was originally stored. When all the questions for all units have been answered, these save buttons will append a "_done" tag to the filename providing a clear indication that the file is ready to be emailed back to QuanTech.
Submitting a Completed Questionnaire
	Attach the completed workbook to an email and email it to Gary Dewalt at [email protected]
Preparing for Answering Questions
	In order to help you prepare to answer the unit specific questions, a "Click here to print question sets" button is provided below so that you can preview the questions you will be answering in this workbook. Clicking this button will print the 2 question sets (one for general questions and one for unit-specific questions) to your default printer. The printed question set is NOT to be used as a markup sheet to submit your answers to QuanTech or HUD. It is only being provided for you to understand the types of information you need to pull from your records to make data entries into this workbook.

---

Sheet 2: Central_Control

	OHLHB0477-10	<-Grant No.		Questionnaire Completion Status->			Not Completed
ANSWER GENERAL QUESTIONS..........			Not Completed	<-Current Status
	Click the button to the right answer the general questions-------------------->
ANSWER UNIT-SPECIFIC QUESTIONS....			Not Completed	<-Current Status
	Please provide answers to unit-specific questions on the units listed below.
	To print a list of these units, use the "Click here to print unit list" button. Clicking this button will print the address listing shown below to your default printer in a portrait format.
	To answer the unit-specific questions for each unit listed in the table below, use the "Answer Unit Questions" button shown under "Questionnaire Access Control" in the row listing each unit address.
	Units Selected for Survey					Questionnaire Access Control	Question Completion Status
	Address	Apt#	City	State	Zip
	621 Pasadena Place		Youngstown	OH	44502		- not entered -
	123 Alabama Lane		Youngstown	OH	44502		- not entered -
	33 Georgia Avenue	3B	Youngstown	OH	44502		- not entered -
	33 Georgia Avenue	4A	Youngstown	OH	44502		- not entered -
	275 Maryland Place		Youngstown	OH	44502		- not entered -
	99 Sprint Avenue		Youngstown	OH	44502		- not entered -
	1313 Developer Lane		Youngstown	OH	44502		- not entered -
	911 Airport Rd		Youngstown	OH	44502		- not entered -
	14 Colorado Blvd		Youngstown	OH	44502		- not entered -
	747 Hanger Street		Youngstown	OH	44502		- not entered -
	86 Deep Creek Lane		Youngstown	OH	44502		- not entered -
	2155 Park Place		Youngstown	OH	44502		- not entered -
	1 Canary Place		Youngstown	OH	44502		- not entered -
	9 Catalina Lane		Youngstown	OH	44502		- not entered -
	101 Spotted Dog Rd		Youngstown	OH	44502		- not entered -
	1 Picture Street		Youngstown	OH	44502		- not entered -
	44 Gunsmoke Rd		Youngstown	OH	44502		- not entered -
	38 Caliber Street	2A	Youngstown	OH	44502		- not entered -
	38 Caliber Street	4A	Youngstown	OH	44502		- not entered -
	38 Caliber Street	6A	Youngstown	OH	44502		- not entered -

---

Sheet 3: UNIT_Q

This sheet contains questions for the unit shown below
	Completion status of entire questionnaire ->	Not Completed
	Completion status of questions for this unit ->	0 % completed
Questions for: 621 Pasadena Place, Youngstown, OH ,44502
	Question Topic Area	Your Data Entry
Question 1	Please identify the type of dwelling:	- not entered -
Question 2	Please identify the construction date of this unit:	- not entered -
Question 3	After conducting lead hazard control in this unit, what cleaning or other procedures did you use to reduce/eliminate remaining lead dust hazards before clearance testing ?	- not entered -
		Question 4	Did this unit pass clearance on floors on the FIRST TRY?	- not entered -
		Question 5	Did this unit pass clearance on floors on the SECOND TRY?	- not entered -
Question 6	Please identify the type of action taken to achieve clearance on floors in this unit AFTER ONE OR MORE CLEARANCE FAILURES​:	- not entered -
Question 7	Please identify the number of FINAL floor dust wipe clearance samples that were collected in this unit:	- not entered -
Question 8	Please enter the loading levels (µg/ft²) for each of the FINAL floor dust wipe clearance samples:	- not entered -
		Question 9	Did this unit pass clearance on windowsills on the FIRST TRY?	- not entered -
		Question 10	Did this unit pass clearance on windowsills on the SECOND TRY?	- not entered -
		Question 11	Please identify the type of action taken to achieve clearance on windowsills in this unit AFTER ONE OR MORE CLEARANCE FAILURES:	- not entered -
		Question 12	Identify the number of FINAL windowsill dust wipe clearance samples that were collected in this unit:	- not entered -
		Question 13	Please enter the loading levels (µg/ft²) for each of the FINAL windowsill dust wipe clearance samples:	- not entered -
				Question 14	Did this unit pass clearance on window troughs on the FIRST TRY?	- not entered -
				Question 15	Did this unit pass clearance on window troughs on the SECOND TRY?	- not entered -
				Question 16	Please identify the type of action taken to achieve clearance on window troughs in this unit AFTER ONE OR MORE CLEARANCE FAILURES:	- not entered -
Question 17	How many FINAL window trough dust wipe clearance samples were collected in this unit ?			- not entered -
Question 18	Please enter the loading levels (µg/ft²) for each of the FINAL window trough dust wipe clearance samples:			- not entered -